TB_ADJUSTBILL
预算调整单主表返回目录
序号列名数据类型长度小数位数主键自增允许空默认值列说明
1APPROVEDBYVARCHAR220    审批人
2APPROVEDDATECHAR19    审批日期
3APPROVEDNOTEVARCHAR21024    审批意见
4BILLTYPECODEVARCHAR220    单据类型编码
5BUSISYSTEMVARCHAR220    业务系统
6CREATEDBYVARCHAR220    调整人
7CREATEDDATECHAR19    调整日期
8CREATEDNOTEVARCHAR21024    调整意见
9CREATIONTIMECHAR19    创建时间
10CREATORVARCHAR220    创建人
11DEF1VARCHAR2101    自定义项1
12DEF10VARCHAR2101    自定义项10
13DEF2VARCHAR2101    自定义项2
14DEF3VARCHAR2101    自定义项3
15DEF4VARCHAR2101    自定义项4
16DEF5VARCHAR2101    自定义项5
17DEF6VARCHAR2101    自定义项6
18DEF7VARCHAR2101    自定义项7
19DEF8VARCHAR2101    自定义项8
20DEF9VARCHAR2101    自定义项9
21DIM1VARCHAR220    动态维度1
22DIM10VARCHAR220    动态维度10
23DIM11VARCHAR220    动态维度11
24DIM12VARCHAR220    动态维度12
25DIM13VARCHAR220    动态维度13
26DIM14VARCHAR220    动态维度14
27DIM15VARCHAR220    动态维度15
28DIM16VARCHAR220    动态维度16
29DIM17VARCHAR220    动态维度17
30DIM18VARCHAR220    动态维度18
31DIM19VARCHAR220    动态维度19
32DIM2VARCHAR220    动态维度2
33DIM20VARCHAR220    动态维度20
34DIM3VARCHAR220    动态维度3
35DIM4VARCHAR220    动态维度4
36DIM5VARCHAR220    动态维度5
37DIM6VARCHAR220    动态维度6
38DIM7VARCHAR220    动态维度7
39DIM8VARCHAR220    动态维度8
40DIM9VARCHAR220    动态维度9
41DRNUMBER100  0 
42MODIFIEDTIMECHAR19    最后修改时间
43MODIFIERVARCHAR220    最后修改人
44PK_ADJUSTBILLCHAR20    调整单主键
45PK_BILLTYPEVARCHAR220    单据类型主键
46PK_GROUPVARCHAR220    所属集团
47PK_ORGVARCHAR220    创建组织
48PK_ORG_VVARCHAR220    创建组织多版本
49PK_TRANSTYPEVARCHAR220     调整方式
50TSCHAR19   to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') 
51VBILLNOVARCHAR230     单据编号
52VBILLSTATUSNUMBER380    单据状态
53VBILLTYPEVARCHAR210     单据类型
54VTRANSTYPEVARCHAR220    交易类型编码