PAM_INSPECT_B
检验申报单表体返回目录
序号列名数据类型长度小数位数主键自增允许空默认值列说明
1CHECK_PERIODVARCHAR2500    检验周期(隐藏)
2CHECK_PERIOD_NAMEVARCHAR2100    检验周期
3CLOSE_FLAGCHAR1    关闭
4DEF1VARCHAR2101    自定义项1
5DEF10VARCHAR2101    自定义项10
6DEF11VARCHAR2101    自定义项11
7DEF12VARCHAR2101    自定义项12
8DEF13VARCHAR2101    自定义项13
9DEF14VARCHAR2101    自定义项14
10DEF15VARCHAR2101    自定义项15
11DEF16VARCHAR2101    自定义项16
12DEF17VARCHAR2101    自定义项17
13DEF18VARCHAR2101    自定义项18
14DEF19VARCHAR2101    自定义项19
15DEF2VARCHAR2101    自定义项2
16DEF20VARCHAR2101    自定义项20
17DEF3VARCHAR2101    自定义项3
18DEF4VARCHAR2101    自定义项4
19DEF5VARCHAR2101    自定义项5
20DEF6VARCHAR2101    自定义项6
21DEF7VARCHAR2101    自定义项7
22DEF8VARCHAR2101    自定义项8
23DEF9VARCHAR2101    自定义项9
24DRNUMBER100  0 
25MEMOVARCHAR2200    备注
26PK_EQUIPVARCHAR220    '~' 设备
27PK_GROUPVARCHAR220   '~'集团
28PK_INSPECTCHAR20     检验申报单_主键
29PK_INSPECT_BCHAR20    检验申报表体主键
30PK_JOBMNGFILVARCHAR220   '~'项目
31PK_ORGVARCHAR220   '~'资产组织最新版本
32PK_ORG_VVARCHAR220   '~'资产组织
33PRE_INSPECT_DATECHAR19    约检日期
34PRE_TEXT1VARCHAR250    预置字符1
35PRE_TEXT10VARCHAR250    预置字符10
36PRE_TEXT2VARCHAR250    预置字符2
37PRE_TEXT3VARCHAR250    预置字符3
38PRE_TEXT4VARCHAR250    预置字符4
39PRE_TEXT5VARCHAR250    预置字符5
40PRE_TEXT6VARCHAR250    预置字符6
41PRE_TEXT7VARCHAR250    预置字符7
42PRE_TEXT8VARCHAR250    预置字符8
43PRE_TEXT9VARCHAR250    预置字符9
44ROWNOVARCHAR230    行号
45TSCHAR19   to_char(sysdate,'yyyy-mm-dd hh24:mi:ss')