RLM_BALANCEPAY_B 租赁结算单子表返回目录
序号 | 列名 | 数据类型 | 长度 | 小数位数 | 主键 | 自增 | 允许空 | 默认值 | 列说明 |
1 | ADJUSTMONEY | NUMBER | 28 | 8 | | | √ | | 调整金额(原币) |
2 | ADJUSTMONEY_GLOBAL | NUMBER | 28 | 8 | | | √ | | 调整金额(全局) |
3 | ADJUSTMONEY_GROUP | NUMBER | 28 | 8 | | | √ | | 调整金额(集团) |
4 | ADJUSTMONEY_ORG | NUMBER | 28 | 8 | | | √ | | 调整金额(本币) |
5 | AGGMONEY | NUMBER | 28 | 8 | | | √ | | 应付合计(原币) |
6 | AGGMONEY_GLOBAL | NUMBER | 28 | 8 | | | √ | | 应付合计(全局) |
7 | AGGMONEY_GROUP | NUMBER | 28 | 8 | | | √ | | 应付合计(集团) |
8 | AGGMONEY_ORG | NUMBER | 28 | 8 | | | √ | | 应付合计(本币) |
9 | COMPMONEY | NUMBER | 28 | 8 | | | √ | | 赔偿金额(原币) |
10 | COMPMONEY_GLOBAL | NUMBER | 28 | 8 | | | √ | | 赔偿金额(全局) |
11 | COMPMONEY_GROUP | NUMBER | 28 | 8 | | | √ | | 赔偿金额(集团) |
12 | COMPMONEY_ORG | NUMBER | 28 | 8 | | | √ | | 赔偿金额(本币) |
13 | DAMAGEMONEY | NUMBER | 28 | 8 | | | √ | | 损坏赔偿金额(原币) |
14 | DAMAGEMONEY_GLOBAL | NUMBER | 28 | 8 | | | √ | | 损坏赔偿金额(全局) |
15 | DAMAGEMONEY_GROUP | NUMBER | 28 | 8 | | | √ | | 损坏赔偿金额(集团) |
16 | DAMAGEMONEY_ORG | NUMBER | 28 | 8 | | | √ | | 损坏赔偿金额(本币) |
17 | DEF1 | VARCHAR2 | 101 | | | | √ | | 自定义项1 |
18 | DEF10 | VARCHAR2 | 101 | | | | √ | | 自定义项10 |
19 | DEF11 | VARCHAR2 | 101 | | | | √ | | 自定义项11 |
20 | DEF12 | VARCHAR2 | 101 | | | | √ | | 自定义项12 |
21 | DEF13 | VARCHAR2 | 101 | | | | √ | | 自定义项13 |
22 | DEF14 | VARCHAR2 | 101 | | | | √ | | 自定义项14 |
23 | DEF15 | VARCHAR2 | 101 | | | | √ | | 自定义项15 |
24 | DEF16 | VARCHAR2 | 101 | | | | √ | | 自定义项16 |
25 | DEF17 | VARCHAR2 | 101 | | | | √ | | 自定义项17 |
26 | DEF18 | VARCHAR2 | 101 | | | | √ | | 自定义项18 |
27 | DEF19 | VARCHAR2 | 101 | | | | √ | | 自定义项19 |
28 | DEF2 | VARCHAR2 | 101 | | | | √ | | 自定义项2 |
29 | DEF20 | VARCHAR2 | 101 | | | | √ | | 自定义项20 |
30 | DEF3 | VARCHAR2 | 101 | | | | √ | | 自定义项3 |
31 | DEF4 | VARCHAR2 | 101 | | | | √ | | 自定义项4 |
32 | DEF5 | VARCHAR2 | 101 | | | | √ | | 自定义项5 |
33 | DEF6 | VARCHAR2 | 101 | | | | √ | | 自定义项6 |
34 | DEF7 | VARCHAR2 | 101 | | | | √ | | 自定义项7 |
35 | DEF8 | VARCHAR2 | 101 | | | | √ | | 自定义项8 |
36 | DEF9 | VARCHAR2 | 101 | | | | √ | | 自定义项9 |
37 | DISCARDMONEY | NUMBER | 28 | 8 | | | √ | | 报废赔偿金额(原币) |
38 | DISCARDMONEY_GLOBAL | NUMBER | 28 | 8 | | | √ | | 报废赔偿金额(全局) |
39 | DISCARDMONEY_GROUP | NUMBER | 28 | 8 | | | √ | | 报废赔偿金额(集团) |
40 | DISCARDMONEY_ORG | NUMBER | 28 | 8 | | | √ | | 报废赔偿金额(本币) |
41 | DR | NUMBER | 10 | 0 | | | √ | 0 | |
42 | GATHMONEY | NUMBER | 28 | 8 | | | √ | | 本期付款(原币) |
43 | GATHMONEY_GLOBAL | NUMBER | 28 | 8 | | | √ | | 本期付款(全局) |
44 | GATHMONEY_GROUP | NUMBER | 28 | 8 | | | √ | | 本期付款(集团) |
45 | GATHMONEY_ORG | NUMBER | 28 | 8 | | | √ | | 本期付款(本币) |
46 | LAST_DATE | CHAR | 19 | | | | √ | | 上次结算日 |
47 | LOADMONEY | NUMBER | 28 | 8 | | | √ | | 装卸费(原币) |
48 | LOADMONEY_GLOBAL | NUMBER | 28 | 8 | | | √ | | 装卸费(全局) |
49 | LOADMONEY_GROUP | NUMBER | 28 | 8 | | | √ | | 装卸费(集团) |
50 | LOADMONEY_ORG | NUMBER | 28 | 8 | | | √ | | 装卸费(本币) |
51 | LOSTPAYMONEY | NUMBER | 28 | 8 | | | √ | | 遗失赔偿金额(原币) |
52 | LOSTPAYMONEY_GLOBAL | NUMBER | 28 | 8 | | | √ | | 遗失赔偿金额(全局) |
53 | LOSTPAYMONEY_GROUP | NUMBER | 28 | 8 | | | √ | | 遗失赔偿金额(集团) |
54 | LOSTPAYMONEY_ORG | NUMBER | 28 | 8 | | | √ | | 遗失赔偿金额(本币) |
55 | MAINTAINMONEY | NUMBER | 28 | 8 | | | √ | | 维修金额(原币) |
56 | MAINTAINMONEY_GLOBAL | NUMBER | 28 | 8 | | | √ | | 维修金额(全局) |
57 | MAINTAINMONEY_GROUP | NUMBER | 28 | 8 | | | √ | | 维修金额(集团) |
58 | MAINTAINMONEY_ORG | NUMBER | 28 | 8 | | | √ | | 维修金额(本币) |
59 | MEMO | VARCHAR2 | 200 | | | | √ | | 备注 |
60 | ORIGIN_RATE | NUMBER | 28 | 8 | | | √ | | 汇率 |
61 | OTHERMONEY | NUMBER | 28 | 8 | | | √ | | 其他应付(原币) |
62 | OTHERMONEY_GLOBAL | NUMBER | 28 | 8 | | | √ | | 其他应付(全局) |
63 | OTHERMONEY_GROUP | NUMBER | 28 | 8 | | | √ | | 其他应付(集团) |
64 | OTHERMONEY_ORG | NUMBER | 28 | 8 | | | √ | | 其他应付(本币) |
65 | PK_BALANCEPAY | CHAR | 20 | | | | | | 租赁结算单_主键 |
66 | PK_BALANCEPAY_B | CHAR | 20 | | √ | | | | 租赁结算单子表主键 |
67 | PK_CONTRACT_BASE | VARCHAR2 | 20 | | | | √ | '~' | 租入合同原版主键 |
68 | PK_CONTRACT_V | VARCHAR2 | 20 | | | | | '~' | 合同编码 |
69 | PK_CURRENCY_ORIGIN | VARCHAR2 | 20 | | | | √ | '~' | 原币 |
70 | PK_GROUP | VARCHAR2 | 20 | | | | √ | '~' | 集团 |
71 | PK_ORG | VARCHAR2 | 20 | | | | √ | '~' | 承租组织最新版本 |
72 | PK_ORG_V | VARCHAR2 | 20 | | | | √ | '~' | 承租组织 |
73 | RENTMONEY | NUMBER | 28 | 8 | | | √ | | 租金(原币) |
74 | RENTMONEY_GLOBAL | NUMBER | 28 | 8 | | | √ | | 租金(全局) |
75 | RENTMONEY_GROUP | NUMBER | 28 | 8 | | | √ | | 租金(集团) |
76 | RENTMONEY_ORG | NUMBER | 28 | 8 | | | √ | | 租金(本币) |
77 | RETURNMONEY | NUMBER | 28 | 8 | | | √ | | 归还费用(原币) |
78 | RETURNMONEY_GLOBAL | NUMBER | 28 | 8 | | | √ | | 归还费用(全局) |
79 | RETURNMONEY_GROUP | NUMBER | 28 | 8 | | | √ | | 归还费用(集团) |
80 | RETURNMONEY_ORG | NUMBER | 28 | 8 | | | √ | | 归还费用(本币) |
81 | ROWNO | VARCHAR2 | 30 | | | | √ | | 行号 |
82 | STOPMONEY | NUMBER | 28 | 8 | | | √ | | 停租租金(原币) |
83 | STOPMONEY_GLOBAL | NUMBER | 28 | 8 | | | √ | | 停租租金(全局) |
84 | STOPMONEY_GROUP | NUMBER | 28 | 8 | | | √ | | 停租租金(集团) |
85 | STOPMONEY_ORG | NUMBER | 28 | 8 | | | √ | | 停租租金(本币) |
86 | TRANSPORTMONEY | NUMBER | 28 | 8 | | | √ | | 运输费(原币) |
87 | TRANSPORTMONEY_GLOBAL | NUMBER | 28 | 8 | | | √ | | 运输费(全局) |
88 | TRANSPORTMONEY_GROUP | NUMBER | 28 | 8 | | | √ | | 运输费(集团) |
89 | TRANSPORTMONEY_ORG | NUMBER | 28 | 8 | | | √ | | 运输费(本币) |
90 | TS | CHAR | 19 | | | | √ | to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') | |
|