PAM_THAW_B
资产启封表体返回目录
序号列名数据类型长度小数位数主键自增允许空默认值列说明
1BILL_CODEVARCHAR240    封存单号
2BILL_TYPEVARCHAR24    来源单据类型
3DEF1VARCHAR2101    自定义项1
4DEF10VARCHAR2101    自定义项10
5DEF11VARCHAR2101    自定义项11
6DEF12VARCHAR2101    自定义项12
7DEF13VARCHAR2101    自定义项13
8DEF14VARCHAR2101    自定义项14
9DEF15VARCHAR2101    自定义项15
10DEF16VARCHAR2101    自定义项16
11DEF17VARCHAR2101    自定义项17
12DEF18VARCHAR2101    自定义项18
13DEF19VARCHAR2101    自定义项19
14DEF2VARCHAR2101    自定义项2
15DEF20VARCHAR2101    自定义项20
16DEF3VARCHAR2101    自定义项3
17DEF4VARCHAR2101    自定义项4
18DEF5VARCHAR2101    自定义项5
19DEF6VARCHAR2101    自定义项6
20DEF7VARCHAR2101    自定义项7
21DEF8VARCHAR2101    自定义项8
22DEF9VARCHAR2101    自定义项9
23DRNUMBER100  0 
24FT_DATECHAR19    封存日期
25MEMOVARCHAR2200    备注
26PK_EQUIPVARCHAR220    '~' 设备
27PK_FREEZE_B_SRCVARCHAR220    来源单据表体主键
28PK_FREEZE_SRCVARCHAR220    来源单据主键
29PK_GROUPVARCHAR220   '~'集团
30PK_JOBMNGFILVARCHAR220   '~'项目
31PK_ORGVARCHAR220   '~'资产组织最新版本
32PK_ORG_VVARCHAR220   '~'资产组织
33PK_STATUS_AFTERVARCHAR220   '~'变动后设备状态
34PK_STATUS_BEFOREVARCHAR220   '~'变动前设备状态
35PK_THAWCHAR20     资产启封_主键
36PK_THAW_BCHAR20    表体主键
37PK_TRANSITYPE_SRCVARCHAR220   '~'来源交易类型主键
38PRE_TEXT1VARCHAR2128    预置字符1
39PRE_TEXT10VARCHAR2128    预置字符10
40PRE_TEXT11VARCHAR2128    预置字符11
41PRE_TEXT12VARCHAR2128    预置字符12
42PRE_TEXT13VARCHAR2128    预置字符13
43PRE_TEXT14VARCHAR2128    预置字符14
44PRE_TEXT15VARCHAR2128    预置字符15
45PRE_TEXT16VARCHAR2128    预置字符16
46PRE_TEXT17VARCHAR2128    预置字符17
47PRE_TEXT18VARCHAR2128    预置字符18
48PRE_TEXT19VARCHAR2128    预置字符19
49PRE_TEXT2VARCHAR2128    预置字符2
50PRE_TEXT20VARCHAR2128    预置字符20
51PRE_TEXT3VARCHAR2128    预置字符3
52PRE_TEXT4VARCHAR2128    预置字符4
53PRE_TEXT5VARCHAR2128    预置字符5
54PRE_TEXT6VARCHAR2128    预置字符6
55PRE_TEXT7VARCHAR2128    预置字符7
56PRE_TEXT8VARCHAR2128    预置字符8
57PRE_TEXT9VARCHAR2128    预置字符9
58ROWNOVARCHAR230    行号
59STATUS_DATE_AFTERCHAR19    变动后状态日期
60STATUS_DATE_BEFORECHAR19    变动前状态日期
61TH_REASONVARCHAR2200    启封原因
62TRANSI_TYPE_SRCVARCHAR230    来源交易类型编码
63TSCHAR19   to_char(sysdate,'yyyy-mm-dd hh24:mi:ss')