LCM_COLLECTIONNOTICE 通知收款返回目录
序号 | 列名 | 数据类型 | 长度 | 小数位数 | 主键 | 自增 | 允许空 | 默认值 | 列说明 |
1 | ACTUALCOLLECTDATE | CHAR | 19 | | | | √ | | 实际收款日期 |
2 | ACTUALREMITAMOUNT | NUMBER | 28 | 8 | | | √ | | 实收现汇金额 |
3 | ACTUALREMITGLCAMOUNT | NUMBER | 28 | 8 | | | √ | | 实收现汇集团本币金额 |
4 | ACTUALREMITGLLCAMOUNT | NUMBER | 28 | 8 | | | √ | | 实收现汇全局本币金额 |
5 | ACTUALREMITOLCAMOUNT | NUMBER | 28 | 8 | | | √ | | 实收现汇组织本币金额 |
6 | APPROVEDATE | CHAR | 19 | | | | √ | | 审核日期 |
7 | APPROVENOTE | VARCHAR2 | 1024 | | | | √ | | 审批批语 |
8 | APPROVER | VARCHAR2 | 20 | | | | √ | '~' | 审核人 |
9 | BILLNO | VARCHAR2 | 50 | | | | √ | | 票据号 |
10 | COLLECTACCOUNT | VARCHAR2 | 20 | | | | √ | '~' | 收款账户 |
11 | COLLECTAMOUNT | NUMBER | 28 | 8 | | | √ | | 收款金额 |
12 | COLLECTGLCAMOUNT | NUMBER | 28 | 8 | | | √ | | 收款金额集团本币金额 |
13 | COLLECTGLLCAMOUNT | NUMBER | 28 | 8 | | | √ | | 收款金额全局本币金额 |
14 | COLLECTOLCAMOUNT | NUMBER | 28 | 8 | | | √ | | 收款金额组织本币金额 |
15 | COLLECTPLAN | VARCHAR2 | 20 | | | | √ | '~' | 收款计划项目 |
16 | COLLECTREGDATE | CHAR | 19 | | | | √ | | 收款登记日期 |
17 | COLLECTREGISTRANT | VARCHAR2 | 20 | | | | √ | '~' | 收款登记人 |
18 | COMMITDATE | CHAR | 19 | | | | √ | | 承付日期 |
19 | COMMITREGDATE | CHAR | 19 | | | | √ | | 承付登记日期 |
20 | COMMITREGISTRANT | VARCHAR2 | 20 | | | | √ | '~' | 承付登记人 |
21 | COMMITTYPE | NUMBER | 38 | 0 | | | √ | | 承付类型 |
22 | CREATIONTIME | CHAR | 19 | | | | √ | | 创建时间 |
23 | CREATOR | VARCHAR2 | 20 | | | | √ | '~' | 创建人 |
24 | DOCBILLREPAYAMOUNT | NUMBER | 28 | 8 | | | √ | | 押汇还款金额 |
25 | DOCBILLREPAYGLCAMOUNT | NUMBER | 28 | 8 | | | √ | | 押汇还款集团本币金额 |
26 | DOCBILLREPAYGLLCAMOUNT | NUMBER | 28 | 8 | | | √ | | 押汇还款全局本币金额 |
27 | DOCBILLREPAYOLCAMOUNT | NUMBER | 28 | 8 | | | √ | | 押汇还款组织本币金额 |
28 | DR | NUMBER | 10 | 0 | | | √ | 0 | |
29 | GLCPOUNDAGEAMOUNT | NUMBER | 28 | 8 | | | √ | | 手续费集团本币金额 |
30 | GLCRATE | NUMBER | 28 | 8 | | | √ | | 集团本币汇率 |
31 | GLLCPOUNDAGEAMOUNT | NUMBER | 28 | 8 | | | √ | | 手续费全局本币金额 |
32 | GLLCRATE | NUMBER | 28 | 8 | | | √ | | 全局本币汇率 |
33 | ISBATCH | CHAR | 1 | | | | √ | | 分批 |
34 | ISDOCUBILLS | CHAR | 1 | | | | √ | | 押汇 |
35 | ISINITIAL | CHAR | 1 | | | | √ | | 期初 |
36 | MODIFIEDTIME | CHAR | 19 | | | | √ | | 最后修改时间 |
37 | MODIFIER | VARCHAR2 | 20 | | | | √ | '~' | 最后修改人 |
38 | NOPAYREASON | VARCHAR2 | 181 | | | | √ | | 拒付原因 |
39 | OLCPOUNDAGEAMOUNT | NUMBER | 28 | 8 | | | √ | | 手续费组织本币金额 |
40 | OLCRATE | NUMBER | 28 | 8 | | | √ | | 组织本币汇率 |
41 | PAYTYPE | NUMBER | 38 | 0 | | | √ | | 兑付方式 |
42 | PK_BILLTYPECODE | VARCHAR2 | 20 | | | | √ | | 单据类型 |
43 | PK_BILLTYPEID | VARCHAR2 | 20 | | | | √ | '~' | 单据类型主键 |
44 | PK_BUSIPERSION | VARCHAR2 | 20 | | | | √ | '~' | 业务员 |
45 | PK_COLLECTIONNOTICE | CHAR | 20 | | √ | | | | 通知收款主键 |
46 | PK_CUSTOMER | VARCHAR2 | 20 | | | | √ | '~' | 客户 |
47 | PK_DEPT | VARCHAR2 | 20 | | | | √ | '~' | 部门 |
48 | PK_DEPT_V | VARCHAR2 | 20 | | | | √ | '~' | 部门版本 |
49 | PK_ENTRUSTORG | VARCHAR2 | 20 | | | | √ | '~' | 核算委托关系组织 |
50 | PK_ENTRUSTORG_V | VARCHAR2 | 20 | | | | √ | '~' | 核算委托关系组织版本 |
51 | PK_GROUP | VARCHAR2 | 20 | | | | √ | '~' | 集团 |
52 | PK_LCCURRTYPE | VARCHAR2 | 20 | | | | √ | '~' | 信用证币种 |
53 | PK_LCNO | VARCHAR2 | 20 | | | | √ | '~' | 信用证号 |
54 | PK_ORG | VARCHAR2 | 20 | | | | √ | '~' | 财务组织 |
55 | PK_ORG_V | VARCHAR2 | 20 | | | | √ | '~' | 财务组织版本 |
56 | PK_PAYACCOUNT | VARCHAR2 | 20 | | | | √ | '~' | 付款银行账户 |
57 | PK_RECEIVEBANK | VARCHAR2 | 20 | | | | √ | '~' | 收单银行 |
58 | PK_SRCBILL | VARCHAR2 | 20 | | | | √ | | 来源单据ID |
59 | PK_SRCBILLTYPE | VARCHAR2 | 50 | | | | √ | | 来源单据类型 |
60 | PK_SUBMISSION_SRCBILL | VARCHAR2 | 50 | | | | √ | | 交单登记来源主键 |
61 | PK_SUBMISSIONNO | VARCHAR2 | 20 | | | | √ | '~' | 交单登记单号 |
62 | POUNDAGEAMOUNT | NUMBER | 28 | 8 | | | √ | | 手续费 |
63 | PRECOLAPTAMOUNT | NUMBER | 28 | 8 | | | √ | | 预计收款金额 |
64 | PRECOLLECTDATE | CHAR | 19 | | | | √ | | 预计收款日期 |
65 | SUBMISSION_SRCCODE | VARCHAR2 | 50 | | | | √ | | 交单登记来源编号 |
66 | TS | CHAR | 19 | | | | √ | to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') | |
67 | VBILLNO | VARCHAR2 | 50 | | | | √ | | 单据编号 |
68 | VBILLSTATUS | NUMBER | 38 | 0 | | | √ | | 审批状态 |
69 | VDEF1 | VARCHAR2 | 101 | | | | √ | | 自定义项1 |
70 | VDEF10 | VARCHAR2 | 101 | | | | √ | | 自定义项10 |
71 | VDEF11 | VARCHAR2 | 101 | | | | √ | | 自定义项11 |
72 | VDEF12 | VARCHAR2 | 101 | | | | √ | | 自定义项12 |
73 | VDEF13 | VARCHAR2 | 101 | | | | √ | | 自定义项13 |
74 | VDEF14 | VARCHAR2 | 101 | | | | √ | | 自定义项14 |
75 | VDEF15 | VARCHAR2 | 101 | | | | √ | | 自定义项15 |
76 | VDEF16 | VARCHAR2 | 101 | | | | √ | | 自定义项16 |
77 | VDEF17 | VARCHAR2 | 101 | | | | √ | | 自定义项17 |
78 | VDEF18 | VARCHAR2 | 101 | | | | √ | | 自定义项18 |
79 | VDEF19 | VARCHAR2 | 101 | | | | √ | | 自定义项19 |
80 | VDEF2 | VARCHAR2 | 101 | | | | √ | | 自定义项2 |
81 | VDEF20 | VARCHAR2 | 101 | | | | √ | | 自定义项20 |
82 | VDEF21 | VARCHAR2 | 101 | | | | √ | | 自定义项21 |
83 | VDEF22 | VARCHAR2 | 101 | | | | √ | | 自定义项22 |
84 | VDEF23 | VARCHAR2 | 101 | | | | √ | | 自定义项23 |
85 | VDEF24 | VARCHAR2 | 101 | | | | √ | | 自定义项24 |
86 | VDEF25 | VARCHAR2 | 101 | | | | √ | | 自定义项25 |
87 | VDEF26 | VARCHAR2 | 101 | | | | √ | | 自定义项26 |
88 | VDEF27 | VARCHAR2 | 101 | | | | √ | | 自定义项27 |
89 | VDEF28 | VARCHAR2 | 101 | | | | √ | | 自定义项28 |
90 | VDEF29 | VARCHAR2 | 101 | | | | √ | | 自定义项29 |
91 | VDEF3 | VARCHAR2 | 101 | | | | √ | | 自定义项3 |
92 | VDEF30 | VARCHAR2 | 101 | | | | √ | | 自定义项30 |
93 | VDEF4 | VARCHAR2 | 101 | | | | √ | | 自定义项4 |
94 | VDEF5 | VARCHAR2 | 101 | | | | √ | | 自定义项5 |
95 | VDEF6 | VARCHAR2 | 101 | | | | √ | | 自定义项6 |
96 | VDEF7 | VARCHAR2 | 101 | | | | √ | | 自定义项7 |
97 | VDEF8 | VARCHAR2 | 101 | | | | √ | | 自定义项8 |
98 | VDEF9 | VARCHAR2 | 101 | | | | √ | | 自定义项9 |
99 | VOUCHERDATE | CHAR | 19 | | | | √ | | 制证日期 |
100 | VOUCHERFLAG | CHAR | 1 | | | | √ | | 已制证 |
101 | VOUCHERMAKER | VARCHAR2 | 20 | | | | √ | '~' | 制证人 |
|