CFBM_SIGN_APPLY 开票申请表返回目录
序号 | 列名 | 数据类型 | 长度 | 小数位数 | 主键 | 自增 | 允许空 | 默认值 | 列说明 |
1 | ACCEPTACCOUNT | VARCHAR2 | 40 | | | | √ | | 承兑单位银行账户 |
2 | ACCEPTDATE | CHAR | 19 | | | | √ | | 承兑日期 |
3 | ACCEPTORACCOUNT | VARCHAR2 | 50 | | | | √ | | 承兑人账号 |
4 | ACCEPTORADRESS | VARCHAR2 | 200 | | | | √ | | 承兑行地址 |
5 | ACCEPTORAREAPOINT | VARCHAR2 | 300 | | | | √ | | 承兑网点号 |
6 | ACCEPTORBANKACCOUNT | VARCHAR2 | 20 | | | | √ | '~' | 承兑人开户行号 |
7 | ACCEPTORNAME | VARCHAR2 | 200 | | | | √ | | 承兑人名称 |
8 | ACCEPTORTYPE | NUMBER | 38 | 0 | | | √ | | 承兑类型 |
9 | ACCEPTUNIT | VARCHAR2 | 20 | | | | √ | '~' | 承兑单位 |
10 | AMOUNT | NUMBER | 28 | 8 | | | √ | | 申请金额 |
11 | APPLYDATE | CHAR | 19 | | | | √ | | 申请日期 |
12 | APPLYSTATUS | VARCHAR2 | 50 | | | | √ | | 申请状态 |
13 | APPROVEDATE | CHAR | 19 | | | | √ | | 审批日期 |
14 | APPROVENOTE | VARCHAR2 | 1024 | | | | √ | | 审批批语 |
15 | APPROVER | VARCHAR2 | 20 | | | | √ | '~' | 审批人 |
16 | AUTOACCEPTANCE | CHAR | 1 | | | | √ | | 自动承兑签收 |
17 | BILLDEADLINE | NUMBER | 38 | 0 | | | √ | | 单据期限 |
18 | BILLMAKEDATE | CHAR | 19 | | | | √ | | 制单日期 |
19 | BILLMAKER | VARCHAR2 | 20 | | | | √ | '~' | 制单人 |
20 | BILLMAKETIME | CHAR | 19 | | | | √ | | 制单时间 |
21 | BILLPOOLFLAG | CHAR | 1 | | | | √ | | 票据池 |
22 | BUSINESSPEOPLE | VARCHAR2 | 20 | | | | √ | '~' | 业务人员 |
23 | BUSISTATUS | NUMBER | 38 | 0 | | | | | 单据状态 |
24 | BUYERINTEREST | CHAR | 1 | | | | √ | | 买方付息 |
25 | CANCELLATION | CHAR | 1 | | | | √ | 'N' | 已作废 |
26 | CCBANK | VARCHAR2 | 20 | | | | √ | '~' | 授信银行 |
27 | CCNO | VARCHAR2 | 20 | | | | √ | '~' | 授信协议编号 |
28 | CCTYPE | VARCHAR2 | 30 | | | | √ | | 授信类型 |
29 | CONTRACTNO | VARCHAR2 | 50 | | | | √ | | 交易合同编码 |
30 | CREATIONTIME | CHAR | 19 | | | | √ | | 创建时间 |
31 | CREATOR | VARCHAR2 | 20 | | | | √ | '~' | 创建人 |
32 | CYBERBANKFLAG | CHAR | 1 | | | | √ | | 网银 |
33 | DEALSIGN | CHAR | 1 | | | | √ | | 受理标记 |
34 | DEPT | VARCHAR2 | 20 | | | | √ | '~' | 部门 |
35 | DISABLEDATE | CHAR | 19 | | | | √ | | 作废时间 |
36 | DISABLENOTE | VARCHAR2 | 1024 | | | | √ | | 作废原因 |
37 | DISABLEUSER | VARCHAR2 | 20 | | | | √ | '~' | 作废人 |
38 | DISUSEDATE | CHAR | 19 | | | | √ | | 作废日期 |
39 | DISUSEFLAG | CHAR | 1 | | | | √ | | 作废 |
40 | DOWNQUOTAFLAG | CHAR | 1 | | | | √ | | 是否使用下拨额度 |
41 | DR | NUMBER | 10 | 0 | | | √ | 0 | |
42 | DRAWBILLMODE | NUMBER | 38 | 0 | | | √ | | 出票方式 |
43 | DRAWERMENTSTATUS | NUMBER | 38 | 0 | | | √ | | 交易指令状态 |
44 | DRAWERREMARK | VARCHAR2 | 181 | | | | √ | | 电票出票指令返回描述 |
45 | ENSURE | CHAR | 1 | | | | √ | | 是否保证 |
46 | FBMBILLTYPE | VARCHAR2 | 20 | | | | √ | '~' | 票据类型 |
47 | GLCAMOUNT | NUMBER | 28 | 8 | | | √ | | 申请金额集团本币金额 |
48 | GLCCCAMOUNT | NUMBER | 28 | 8 | | | √ | | 占用授信集团本币金额 |
49 | GLCINNERSECURITYAMOUNT | NUMBER | 28 | 8 | | | √ | | 内部保证金集团本币金额 |
50 | GLCOCCUCOMMONEY | NUMBER | 28 | 8 | | | √ | | 占用单位票据池集团本币金额 |
51 | GLCOCCUSHAREMONEY | NUMBER | 28 | 8 | | | √ | | 占用共享票据池集团本币金额 |
52 | GLCPOUNDAGEAMOUNT | NUMBER | 23 | 8 | | | √ | | 手续费集团本币金额 |
53 | GLCRATE | NUMBER | 15 | 8 | | | √ | | 集团本币汇率 |
54 | GLCSECURITYAMOUNT | NUMBER | 23 | 8 | | | √ | | 保证金集团本币金额 |
55 | GLLCAMOUNT | NUMBER | 28 | 8 | | | √ | | 申请金额全局本币金额 |
56 | GLLCCAMOUNT | NUMBER | 28 | 8 | | | √ | | 占用授信全局本币金额 |
57 | GLLCINNERSECURITYAMOUNT | NUMBER | 28 | 8 | | | √ | | 内部保证金全局本币金额 |
58 | GLLCPOUNDAGEAMOUNT | NUMBER | 23 | 8 | | | √ | | 手续费全局本币金额 |
59 | GLLCRATE | NUMBER | 15 | 8 | | | √ | | 全局本币汇率 |
60 | GLLCSECURITYAMOUNT | NUMBER | 23 | 8 | | | √ | | 保证金全局本币金额 |
61 | GLLOCCUCOMMONEY | NUMBER | 28 | 8 | | | √ | | 占用单位票据池全局本币金额 |
62 | GLLOCCUSHAREMONEY | NUMBER | 28 | 8 | | | √ | | 占用共享票据池全局本币金额 |
63 | GUARANTORADRESS | VARCHAR2 | 200 | | | | √ | | 保证人地址 |
64 | GUARANTORNAME | VARCHAR2 | 50 | | | | √ | | 保证人全称 |
65 | GUARANTORNO | VARCHAR2 | 50 | | | | √ | | 保证人账号 |
66 | GUARANTORNOISICBC | CHAR | 1 | | | | √ | | 保证人账号是否工行 |
67 | GUARANTOROPENNAME | VARCHAR2 | 50 | | | | √ | | 保证人开户行名称 |
68 | GUARANTOROPENNO | VARCHAR2 | 50 | | | | √ | | 保证人开户行行号 |
69 | HASPASSEDNTBCHECK | CHAR | 1 | | | | √ | | 是否通过预算检查 |
70 | HIDEACCEPTBANKACC | VARCHAR2 | 20 | | | | √ | '~' | 承兑人账户主键 |
71 | IMPAWNMODE | VARCHAR2 | 30 | | | | √ | | 担保方式 |
72 | INITPOOLFLAG | CHAR | 1 | | | | √ | | 期初票据池 |
73 | INNERSECURITYAMOUNT | NUMBER | 23 | 8 | | | √ | | 内部保证金金额 |
74 | INNERSECURITYRATE | NUMBER | 23 | 8 | | | √ | | 内部保证金比例 |
75 | INVOICEPLANITEM | VARCHAR2 | 20 | | | | √ | '~' | 开票计划项目 |
76 | INVSTFINCVARTYID | VARCHAR2 | 20 | | | | √ | '~' | 融资品种 |
77 | ISACCEPTEDNOW | CHAR | 1 | | | | √ | | 是否本级受理 |
78 | ISACCEPTOREQUAL | CHAR | 1 | | | | √ | 'N' | 承兑人账号是否同行 |
79 | ISSECURITY | CHAR | 1 | | | | √ | | 保证金 |
80 | MODIFIEDTIME | CHAR | 19 | | | | √ | | 修改时间 |
81 | MODIFIER | VARCHAR2 | 20 | | | | √ | '~' | 修改人 |
82 | OCCUCOMMONEY | NUMBER | 28 | 8 | | | √ | | 占用单位票据池金额 |
83 | OCCUSHAREMONEY | NUMBER | 28 | 8 | | | √ | | 占用共享票据池金额 |
84 | OLCAMOUNT | NUMBER | 28 | 8 | | | √ | | 申请金额组织本币金额 |
85 | OLCCCAMOUNT | NUMBER | 28 | 8 | | | √ | | 占用授信组织本币金额 |
86 | OLCINNERSECURITYAMOUNT | NUMBER | 28 | 8 | | | √ | | 内部保证金组织本币金额 |
87 | OLCOCCUCOMMONEY | NUMBER | 28 | 8 | | | √ | | 占用单位票据池组织本币金额 |
88 | OLCOCCUSHAREMONEY | NUMBER | 28 | 8 | | | √ | | 占用共享票据池组织本币金额 |
89 | OLCPOUNDAGEAMOUNT | NUMBER | 23 | 8 | | | √ | | 手续费组织本币金额 |
90 | OLCRATE | NUMBER | 15 | 8 | | | √ | | 组织本币汇率 |
91 | OLCSECURITYAMOUNT | NUMBER | 23 | 8 | | | √ | | 保证金组织本币金额 |
92 | PK_ACCEPTOR | VARCHAR2 | 20 | | | | √ | '~' | 承兑人 |
93 | PK_ACCEPTORBANK | VARCHAR2 | 20 | | | | √ | '~' | 承兑人开户行名 |
94 | PK_ACCEPTORG | VARCHAR2 | 20 | | | | √ | '~' | 受理组织 |
95 | PK_ACCEPTORG_V | VARCHAR2 | 20 | | | | √ | '~' | 受理组织版本 |
96 | PK_APPLYBANK | VARCHAR2 | 20 | | | | √ | '~' | 申请银行 |
97 | PK_APPLYBANKACC | VARCHAR2 | 20 | | | | √ | '~' | 银行账户 |
98 | PK_APPLYORG | VARCHAR2 | 20 | | | | √ | '~' | 申请组织 |
99 | PK_APPLYORG_V | VARCHAR2 | 20 | | | | √ | '~' | 申请组织版本 |
100 | PK_BANKSECURITYACC | VARCHAR2 | 20 | | | | √ | '~' | 银行保证金账户 |
101 | PK_BANKTYPE | VARCHAR2 | 20 | | | | √ | '~' | 银行类别 |
102 | PK_BILLTYPECODE | VARCHAR2 | 20 | | | | √ | | 单据类型 |
103 | PK_BILLTYPEID | VARCHAR2 | 20 | | | | √ | | 单据类型主键 |
104 | PK_BUSITYPE | VARCHAR2 | 20 | | | | √ | '~' | 业务流程 |
105 | PK_CCCURRTYPE | VARCHAR2 | 20 | | | | √ | '~' | 授信币种 |
106 | PK_CCTYPE | VARCHAR2 | 20 | | | | √ | '~' | 授信类别 |
107 | PK_CURRTYPE | VARCHAR2 | 20 | | | | √ | '~' | 币种 |
108 | PK_ENTRUSTORG | VARCHAR2 | 20 | | | | √ | '~' | 核算委托组织 |
109 | PK_ENTRUSTORG_V | VARCHAR2 | 20 | | | | √ | '~' | 核算委托组织版本信息 |
110 | PK_GROUP | VARCHAR2 | 20 | | | | √ | '~' | 集团 |
111 | PK_ORG | VARCHAR2 | 20 | | | | √ | '~' | 财务组织 |
112 | PK_ORG_V | VARCHAR2 | 20 | | | | √ | '~' | 财务组织版本 |
113 | PK_POUNDAGEACC | VARCHAR2 | 20 | | | | √ | '~' | 内部结算账户 |
114 | PK_RECEIVEBANK | VARCHAR2 | 20 | | | | √ | '~' | 收款人开户银行 |
115 | PK_RECEIVEBANKACC | VARCHAR2 | 20 | | | | √ | '~' | 收款人账户 |
116 | PK_RECEIVEUNIT | VARCHAR2 | 20 | | | | √ | '~' | 收款人全称 |
117 | PK_SECURITYACC | VARCHAR2 | 20 | | | | √ | '~' | 保证金账户 |
118 | PK_SETTLEORG | VARCHAR2 | 50 | | | | √ | | 直接受理资金组织主键 |
119 | PK_SIGN_APPLY | CHAR | 20 | | √ | | | | 主键 |
120 | PK_SRCBILL | VARCHAR2 | 20 | | | | √ | | 来源单据主键 |
121 | PK_SRCBILLTYPE | VARCHAR2 | 50 | | | | √ | | 来源票据类型 |
122 | PK_SUMMARY | VARCHAR2 | 100 | | | | √ | | 摘要主键 |
123 | PLANPAYDATE | CHAR | 19 | | | | √ | | 预计付票日期 |
124 | POUNDAGEAMOUNT | NUMBER | 23 | 8 | | | √ | | 手续费金额 |
125 | POUNDAGEPLANITEM | VARCHAR2 | 20 | | | | √ | '~' | 手续费计划项目 |
126 | PROMPTTICKET | CHAR | 1 | | | | √ | | 自动提示收票 |
127 | PURPOSE | VARCHAR2 | 181 | | | | √ | | 用途 |
128 | RECEIVEACCOUNT | VARCHAR2 | 20 | | | | √ | '~' | 电票签约账号 |
129 | REGISTERSTATUS | VARCHAR2 | 30 | | | | √ | | 票据状态 |
130 | REMARK | VARCHAR2 | 181 | | | | √ | | 备注 |
131 | RETURNDATE | CHAR | 19 | | | | √ | | 退回日期 |
132 | RETURNER | VARCHAR2 | 20 | | | | √ | '~' | 退回人 |
133 | RETURNREASON | VARCHAR2 | 181 | | | | √ | | 退回原因 |
134 | SECURITYAMOUNT | NUMBER | 23 | 8 | | | √ | | 保证金金额 |
135 | SECURITYPLANITEM | VARCHAR2 | 20 | | | | √ | '~' | 保证金计划项目 |
136 | SECURITYRATE | NUMBER | 23 | 8 | | | √ | | 保证金比例 |
137 | SIGNAGRBANK | VARCHAR2 | 20 | | | | √ | '~' | 承兑行 |
138 | SIGNAGRBANKNAME | VARCHAR2 | 300 | | | | √ | | 承兑行行名 |
139 | SIGNAGRBANKNUM | VARCHAR2 | 50 | | | | √ | | 承兑行行号 |
140 | SIGNAGRBANKTEXT | VARCHAR2 | 300 | | | | √ | | 承兑银行 |
141 | SIGNAGREEMENTNO | VARCHAR2 | 50 | | | | √ | | 承兑协议编号 |
142 | SUBMITDATE | CHAR | 19 | | | | √ | | 提交日期 |
143 | SUBMITER | VARCHAR2 | 20 | | | | √ | '~' | 提交人 |
144 | SUMMARY | VARCHAR2 | 181 | | | | √ | '~' | 摘要 |
145 | TBBMESSAGE | VARCHAR2 | 1025 | | | | √ | | 预算提示信息 |
146 | TS | CHAR | 19 | | | | √ | to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') | |
147 | USEDCCAMOUNT | NUMBER | 28 | 8 | | | √ | | 使用授信金额 |
148 | VBILLNO | VARCHAR2 | 50 | | | | √ | | 单据编号 |
149 | VBILLSTATUS | NUMBER | 38 | 0 | | | √ | | 审批状态 |
150 | VDEF1 | VARCHAR2 | 101 | | | | √ | | 自定义项1 |
151 | VDEF10 | VARCHAR2 | 101 | | | | √ | | 自定义项10 |
152 | VDEF11 | VARCHAR2 | 101 | | | | √ | | 自定义项11 |
153 | VDEF12 | VARCHAR2 | 101 | | | | √ | | 自定义项12 |
154 | VDEF13 | VARCHAR2 | 101 | | | | √ | | 自定义项13 |
155 | VDEF14 | VARCHAR2 | 101 | | | | √ | | 自定义项14 |
156 | VDEF15 | VARCHAR2 | 101 | | | | √ | | 自定义项15 |
157 | VDEF16 | VARCHAR2 | 101 | | | | √ | | 自定义项16 |
158 | VDEF17 | VARCHAR2 | 101 | | | | √ | | 自定义项17 |
159 | VDEF18 | VARCHAR2 | 101 | | | | √ | | 自定义项18 |
160 | VDEF19 | VARCHAR2 | 101 | | | | √ | | 自定义项19 |
161 | VDEF2 | VARCHAR2 | 101 | | | | √ | | 自定义项2 |
162 | VDEF20 | VARCHAR2 | 101 | | | | √ | | 自定义项20 |
163 | VDEF3 | VARCHAR2 | 101 | | | | √ | | 自定义项3 |
164 | VDEF4 | VARCHAR2 | 101 | | | | √ | | 自定义项4 |
165 | VDEF5 | VARCHAR2 | 101 | | | | √ | | 自定义项5 |
166 | VDEF6 | VARCHAR2 | 101 | | | | √ | | 自定义项6 |
167 | VDEF7 | VARCHAR2 | 101 | | | | √ | | 自定义项7 |
168 | VDEF8 | VARCHAR2 | 101 | | | | √ | | 自定义项8 |
169 | VDEF9 | VARCHAR2 | 101 | | | | √ | | 自定义项9 |
170 | VOUCHERDATE | CHAR | 19 | | | | √ | | 制证日期 |
171 | VOUCHERMAKER | VARCHAR2 | 20 | | | | √ | '~' | 制证人 |
|