LCM_PAYMENT 付款登记单返回目录
序号 | 列名 | 数据类型 | 长度 | 小数位数 | 主键 | 自增 | 允许空 | 默认值 | 列说明 |
1 | APPROVEDATE | CHAR | 19 | | | | √ | | 审核日期 |
2 | APPROVER | VARCHAR2 | 20 | | | | √ | '~' | 审核人 |
3 | ARRIVAL_SRCCODE | VARCHAR2 | 50 | | | | √ | | 通知承付单来源编号 |
4 | BILLMAKEDATE | CHAR | 19 | | | | √ | | 录入日期 |
5 | BILLMAKER | VARCHAR2 | 20 | | | | √ | '~' | 录入人 |
6 | BUYGLCAMT | NUMBER | 28 | 8 | | | √ | | 买汇金额(集团本币) |
7 | BUYGLLCAMT | NUMBER | 28 | 8 | | | √ | | 买汇金额(全局本币) |
8 | BUYLCAMT | NUMBER | 28 | 8 | | | √ | | 买汇本币金额 |
9 | BUYREMITTANCEAMT | NUMBER | 28 | 8 | | | √ | | 买汇金额 |
10 | CCTLCRATE | NUMBER | 28 | 8 | | | √ | | 授信本币汇率 |
11 | CREATIONTIME | CHAR | 19 | | | | √ | | 创建时间 |
12 | CREATOR | VARCHAR2 | 20 | | | | √ | '~' | 创建人 |
13 | DELEGATESENDAMT | NUMBER | 28 | 8 | | | √ | | 委托放款金额 |
14 | DEPOSITACCOUNT | VARCHAR2 | 20 | | | | √ | '~' | 保证金账户 |
15 | DEPOSITPAYAMT | NUMBER | 28 | 8 | | | √ | | 保证金支付金额 |
16 | DEPOSITPAYGLCAMT | NUMBER | 28 | 8 | | | √ | | 保证金支付集团本币金额 |
17 | DEPOSITPAYGLLCAMT | NUMBER | 28 | 8 | | | √ | | 保证金支付全局本币金额 |
18 | DEPOSITPAYLCAMT | NUMBER | 28 | 8 | | | √ | | 保证金支付款折本币金额 |
19 | DEPOSITPAYLCMAMT | NUMBER | 28 | 8 | | | √ | | 保证金支付信用证金额 |
20 | DEPOSITPAYLCMGLCAMT | NUMBER | 28 | 8 | | | √ | | 保证金抵扣信用证金额(集团本币) |
21 | DEPOSITPAYLCMGLLCAMT | NUMBER | 28 | 8 | | | √ | | 保证金抵扣信用证金额(全局本币) |
22 | DEPOSITPAYLCMLCAMT | NUMBER | 28 | 8 | | | √ | | 保证金支付信用证款本币金额 |
23 | DEPOSITPROFIT_LOSS | NUMBER | 28 | 8 | | | √ | | 保证金支付信用证款损益 |
24 | DEPOSITTGLCRATE | NUMBER | 28 | 8 | | | √ | | 保证金集团本币汇率 |
25 | DEPOSITTGLLCRATE | NUMBER | 28 | 8 | | | √ | | 保证金全局本币汇率 |
26 | DEPOSITTOLCRATE | NUMBER | 28 | 8 | | | √ | | 保证金币种折本位币汇率 |
27 | DR | NUMBER | 10 | 0 | | | √ | 0 | |
28 | EXCHANGERATE | NUMBER | 28 | 8 | | | √ | | 汇率 |
29 | FREE_CCAMOUNT | NUMBER | 28 | 8 | | | √ | | 释放授信金额 |
30 | GLCDELEGATESENDAMT | NUMBER | 28 | 8 | | | √ | | 委托放款集团本币金额 |
31 | GLCPOUNDAGEAMOUNT | NUMBER | 28 | 8 | | | √ | | 手续费集团本币金额 |
32 | GLCRATE | NUMBER | 28 | 8 | | | √ | | 汇率(集团本币) |
33 | GLLCDELEGATESENDAMT | NUMBER | 28 | 8 | | | √ | | 委托放款全局本币金额 |
34 | GLLCPOUNDAGEAMOUNT | NUMBER | 28 | 8 | | | √ | | 手续费全局本币金额 |
35 | GLLCRATE | NUMBER | 28 | 8 | | | √ | | 汇率(全局本币) |
36 | HASPASSEDNTBCHECK | CHAR | 1 | | | | √ | | 是否通过预算检查 |
37 | ISINITIAL | CHAR | 1 | | | | √ | | 期初 |
38 | ISVOUCHER | CHAR | 1 | | | | √ | | 制证 |
39 | LCMAMT | NUMBER | 28 | 8 | | | √ | | 信用证金额 |
40 | MODIFIEDTIME | CHAR | 19 | | | | √ | | 修改时间 |
41 | MODIFIER | VARCHAR2 | 20 | | | | √ | '~' | 修改人 |
42 | MODIFYDATE | CHAR | 19 | | | | √ | | 修改日期 |
43 | NTBMESSAGE | VARCHAR2 | 50 | | | | √ | | 预算提示信息 |
44 | OLCDELEGATESENDAMT | NUMBER | 28 | 8 | | | √ | | 委托放款本币金额 |
45 | OLCPOUNDAGEAMOUNT | NUMBER | 28 | 8 | | | √ | | 手续费组织本币金额 |
46 | PAYAMT | NUMBER | 28 | 8 | | | √ | | 承付金额(原币) |
47 | PAYDATE | CHAR | 19 | | | | √ | | 付款日期 |
48 | PK_ARRIVAL | VARCHAR2 | 20 | | | | √ | '~' | 通知承付单 |
49 | PK_ARRIVAL_SRCBILL | VARCHAR2 | 50 | | | | √ | | 通知承付单来源主键 |
50 | PK_BILLTYPE | VARCHAR2 | 20 | | | | √ | '~' | 单据类型 |
51 | PK_BILLTYPECODE | VARCHAR2 | 50 | | | | √ | | 单据类型编号 |
52 | PK_BUSIPERSION | VARCHAR2 | 20 | | | | √ | '~' | 业务员 |
53 | PK_CCPROTOCOL | VARCHAR2 | 20 | | | | √ | '~' | 授信协议 |
54 | PK_CCTCURRTYPE | VARCHAR2 | 20 | | | | √ | '~' | 授信协议币种 |
55 | PK_DEPT | VARCHAR2 | 20 | | | | √ | '~' | 部门 |
56 | PK_ENTRUSTORG | VARCHAR2 | 20 | | | | √ | '~' | 核算委托关系组织 |
57 | PK_ENTRUSTORG_V | VARCHAR2 | 20 | | | | √ | '~' | 核算委托关系组织版本 |
58 | PK_GROUP | VARCHAR2 | 20 | | | | √ | '~' | 所属集团 |
59 | PK_LCMCURRTYPE | VARCHAR2 | 20 | | | | √ | '~' | 信用证币种 |
60 | PK_OLCCURRTYPE | VARCHAR2 | 20 | | | | √ | '~' | 组织本币 |
61 | PK_ORG | VARCHAR2 | 20 | | | | √ | '~' | 财务组织 |
62 | PK_ORG_V | VARCHAR2 | 20 | | | | √ | '~' | 财务组织多版本 |
63 | PK_PAYMENT | CHAR | 20 | | √ | | | | 主键 |
64 | PK_PLAN | VARCHAR2 | 20 | | | | √ | '~' | 付款计划项目 |
65 | PK_PLEDGECURR | VARCHAR2 | 20 | | | | √ | '~' | 保证金币种 |
66 | PK_RECACCOUNT | VARCHAR2 | 20 | | | | √ | '~' | 收款银行账户 |
67 | PK_REGISTER | VARCHAR2 | 20 | | | | √ | '~' | 信用证号 |
68 | PK_SELL_CURRTYPE | VARCHAR2 | 20 | | | | √ | '~' | 卖汇币种 |
69 | PK_SRCBILL | VARCHAR2 | 20 | | | | √ | | 来源单据id |
70 | PK_SUPPLIER | VARCHAR2 | 20 | | | | √ | '~' | 供应商 |
71 | POUNDAGEAMOUNT | NUMBER | 28 | 8 | | | √ | | 手续费 |
72 | RELCOMMONEY | NUMBER | 28 | 8 | | | √ | | 释放单位票据池金额 |
73 | RELSHAREMONEY | NUMBER | 28 | 8 | | | √ | | 释放共享票据池金额 |
74 | SELLACCOUNT | VARCHAR2 | 20 | | | | √ | '~' | 卖汇账户 |
75 | SELLAMT | NUMBER | 28 | 8 | | | √ | | 卖汇金额 |
76 | SELLGLCAMT | NUMBER | 28 | 8 | | | √ | | 卖汇金额(集团本币) |
77 | SELLGLCRATE | NUMBER | 28 | 8 | | | √ | | 卖汇集团本币汇率 |
78 | SELLGLLCAMT | NUMBER | 28 | 8 | | | √ | | 卖汇金额(全局本币) |
79 | SELLGLLCRATE | NUMBER | 28 | 8 | | | √ | | 卖汇全局本币汇率 |
80 | SELLLCAMT | NUMBER | 28 | 8 | | | √ | | 卖汇本币金额 |
81 | SELLLCRATE | NUMBER | 28 | 8 | | | √ | | 卖汇本币汇率 |
82 | SPOTACCOUNT | VARCHAR2 | 20 | | | | √ | '~' | 现汇支付账户 |
83 | SPOTAMT | NUMBER | 28 | 8 | | | √ | | 现汇支付金额 |
84 | SPOTGLCAMT | NUMBER | 28 | 8 | | | √ | | 现汇支付金额(集团本币) |
85 | SPOTGLLCAMT | NUMBER | 28 | 8 | | | √ | | 现汇支付金额(全局本币) |
86 | SPOTPAYLCAMT | NUMBER | 28 | 8 | | | √ | | 现汇支付本币金额 |
87 | SRCBILLCODE | VARCHAR2 | 20 | | | | √ | | 来源单据类型 |
88 | SWAPPROFIT_LOSS | NUMBER | 28 | 8 | | | √ | | 换汇损益 |
89 | THISPAYAMT | NUMBER | 28 | 8 | | | √ | | 本次支付总金额 |
90 | THISPAYGLCAMT | NUMBER | 28 | 8 | | | √ | | 本次支付集团本币总金额 |
91 | THISPAYGLLCAMT | NUMBER | 28 | 8 | | | √ | | 本次支付全局本币总金额 |
92 | THISPAYLCAMT | NUMBER | 28 | 8 | | | √ | | 本次支付本币金额 |
93 | TS | CHAR | 19 | | | | √ | to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') | |
94 | VBILLNO | VARCHAR2 | 50 | | | | √ | | 单据编号 |
95 | VBILLSTATUS | NUMBER | 38 | 0 | | | √ | | 审批状态 |
96 | VDEF1 | VARCHAR2 | 101 | | | | √ | | 自定义项1 |
97 | VDEF10 | VARCHAR2 | 101 | | | | √ | | 自定义项10 |
98 | VDEF11 | VARCHAR2 | 101 | | | | √ | | 自定义项11 |
99 | VDEF12 | VARCHAR2 | 101 | | | | √ | | 自定义项12 |
100 | VDEF13 | VARCHAR2 | 101 | | | | √ | | 自定义项13 |
101 | VDEF14 | VARCHAR2 | 101 | | | | √ | | 自定义项14 |
102 | VDEF15 | VARCHAR2 | 101 | | | | √ | | 自定义项15 |
103 | VDEF16 | VARCHAR2 | 101 | | | | √ | | 自定义项16 |
104 | VDEF17 | VARCHAR2 | 101 | | | | √ | | 自定义项17 |
105 | VDEF18 | VARCHAR2 | 101 | | | | √ | | 自定义项18 |
106 | VDEF19 | VARCHAR2 | 101 | | | | √ | | 自定义项19 |
107 | VDEF2 | VARCHAR2 | 101 | | | | √ | | 自定义项2 |
108 | VDEF20 | VARCHAR2 | 101 | | | | √ | | 自定义项20 |
109 | VDEF3 | VARCHAR2 | 101 | | | | √ | | 自定义项3 |
110 | VDEF4 | VARCHAR2 | 101 | | | | √ | | 自定义项4 |
111 | VDEF5 | VARCHAR2 | 101 | | | | √ | | 自定义项5 |
112 | VDEF6 | VARCHAR2 | 101 | | | | √ | | 自定义项6 |
113 | VDEF7 | VARCHAR2 | 101 | | | | √ | | 自定义项7 |
114 | VDEF8 | VARCHAR2 | 101 | | | | √ | | 自定义项8 |
115 | VDEF9 | VARCHAR2 | 101 | | | | √ | | 自定义项9 |
116 | VOUCHER | VARCHAR2 | 20 | | | | √ | '~' | 制证人 |
117 | VOUCHERDATE | CHAR | 19 | | | | √ | | 制证日期 |
|