打包贷款sql.doc

- Create tablecreate table IQP_COM_DOMESTIC_LC 国内信用证信息表( SERNO VARCHAR2(40) not null, BILL_NO VARCHAR2(30), CONT_NO VARCHAR2(30), LC_NO VARCHAR2(30), APPLY_CUR_TYPE CHAR(3), APPLY_AMOUNT NUMBER(16,2), PAY_MODE CHAR(1), PAY_LIMIT_DAY NUMBER, IS_ALLOW_PART CHAR(1), ISSUING_BANK_NAME CHAR(60), START_DATE VARCHAR2(10), DUE_DATE VARCHAR2(10)tablespace TBC pctfree 10 initrans 1 maxtrans 255 storage ( initial 64 minextents 1 maxextents unlimited );- Add comments to the columns comment on column IQP_COM_DOMESTIC_LC.SERNO is 流水号;comment on column IQP_COM_DOMESTIC_LC.BILL_NO is 借据号;comment on column IQP_COM_DOMESTIC_LC.CONT_NO is 合同号;comment on column IQP_COM_DOMESTIC_LC.LC_NO is 信用证号;comment on column IQP_COM_DOMESTIC_LC.APPLY_CUR_TYPE is 币种;comment on column IQP_COM_DOMESTIC_LC.APPLY_AMOUNT is 开证金额;comment on column IQP_COM_DOMESTIC_LC.PAY_MODE is 付款方式;comment on column IQP_COM_DOMESTIC_LC.PAY_LIMIT_DAY is 付款期限;comment on column IQP_COM_DOMESTIC_LC.IS_ALLOW_PART is 是否分批装运;comment on column IQP_COM_DOMESTIC_LC.ISSUING_BANK_NAME is 开户行名称;comment on column IQP_COM_DOMESTIC_LC.START_DATE is 开证日期;comment on column IQP_COM_DOMESTIC_LC.DUE_DATE is 到期日期;- Create/Recreate indexes create unique index PK_IQP_COM_DOMESTIC_LCK on IQP_COM_DOMESTIC_LC (SERNO) tablespace TBIDX pctfree 10 initrans 2 maxtrans 255 storage ( initial 64K minextents 1 maxextents unlimited );- Create tablecreate table ACC_DOMESTIC_LC 国内信用证台帐表( BILL_NO VARCHAR2(30) not null, CONT_NO VARCHAR2(30) not null, LC_NO VARCHAR2(30) not null, BIZ_TYPE VARCHAR2(6) not null, PRD_NAME VARCHAR2(60) not null, PRD_TYPE CHAR(2) not null, CUS_ID VARCHAR2(30), CUS_NAME VARCHAR2(60), CUS_POST_CODE VARCHAR2(6), CUS_ADDR VARCHAR2(60), ISSUING_BANK_NAME VARCHAR2(60), APPLY_CUR_TYPE CHAR(3), APPLY_AMOUNT NUMBER(16,2), IS_BB_LC CHAR(1), OLD_LC_NO VARCHAR2(30), OLD_APPLY_AMOUNT NUMBER(16,2), OLD_DUE_DATE CHAR(10), START_DATE CHAR(10), DUE_DATE CHAR(10), SECURITY_MONEY_AMT NUMBER(16,2), SECURITY_MONEY_RT NUMBER(10,4), THIRD_SEC_IND CHAR(1), RISK_OPEN_AMT NUMBER(16,2), RISK_OPEN_RATE NUMBER(10,4), LIMIT_IND CHAR(1), LIMIT_MA_NO VARCHAR2(32), LIMIT_AMT NUMBER(16,2), LIMIT_ACC_NO VARCHAR2(32), AFFORD_FEE VARCHAR2(60), FEE_ACCOUNT VARCHAR2(32), INPUT_DATE CHAR(10), CUS_MANAGER VARCHAR2(20), INPUT_ID VARCHAR2(20), MAIN_BR_ID VARCHAR2(20), INPUT_BR_ID VARCHAR2(20), PRD_PK VARCHAR2(32) not null, APPROVE_STATUS CHAR(3), NOTE_NO VARCHAR2(30), NOTE_DATE CHAR(10), FEE_AMOUNT NUMBER(16,2), CUS_ACCOUNT VARCHAR2(32), CUS_ACCOUNT_NAME VARCHAR2(32), BFC_ACCOUNT VARCHAR2(32), BFC_ACCOUNT_NAME VARCHAR2(32), FINA_BR_ID VARCHAR2(20), FEE_ACCOUNT_NAME VARCHAR2(60), ASSURE_MEANS_MAIN CHAR(2), ACCOUNT_STATUS CHAR(1), CLA CHAR(2), CLA_DATE VARCHAR2(10), CLA_PRE CHAR(2), CLA_DATE_PRE VARCHAR2(10), ACCT_TYPE CHAR(1), ACCT_CODE VARCHAR2(10), ACCT_NTT_IND CHAR(1), ACCOUNT_CLASS VARCHAR2(10), BFC_ACCT_TYPE CHAR(1), BFC_ACCT_CODE VARCHAR2(10), BFC_ACCT_NTT_IND CHAR(1), BFC_ACCOUNT_CLASS VARCHAR2(10), MOD_NUM NUMBER, MOD_CONT_NO VARCHAR2(30), LC_STATUS CHAR(2), DEAL_PLC CHAR(1), POST_FEE_AMOUNT NUMBER(16,2), FEE_RATE NUMBER(16,9), CHANGE_DATE CHAR(10), PAY_MODE CHAR(1), PAY_LIMIT_DAY NUMBER, IS_ALLOW_PART CHAR(1), IS_ALLOW_TRAN CHAR(1), GOODS_START_ADDR VARCHAR2(60), GOODS_DUE_ADDR VARCHAR2(60), GOODS_LAST_LOAD_DATE CHAR(10), TRADE_CONT_NO VARCHAR2(30), GOODS_DESC VARCHAR2(2000), BFC_SUB_DOCS VARCHAR2(1000), SUB_DOCS_LIMIT NUMBER, MORE_LESS_CLAUSE VARCHAR2(1000), EXP_ISSUING_BANK_FEE VARCHAR2(60), P_BILL_BE_START_DATE CHAR(1), T_BILL_BE_START_DATE CHAR(1), EXPIRY_PLACE VARCHAR2(40)tablespace TBC pctfree 10 initrans 1 maxtrans 255 storage ( initial 16 minextents 1 maxextents unlimited );- Add comments to the columns comment on column ACC_DOMESTIC_LC.BILL_NO is 借据编号;comment on column ACC_DOMESTIC_LC.CONT_NO is 合同编号;comment on column ACC_DOMESTIC_LC.LC_NO is 信用证号码;comment on column ACC_DOMESTIC_LC.BIZ_TYPE is 产品编号;comment on column ACC_DOMESTIC_LC.PRD_NAME is 产品名;comment on column ACC_DOMESTIC_LC.PRD_TYPE is 产品类别;comment on column ACC_DOMESTIC_LC.CUS_ID is 客户代码;comment on column ACC_DOMESTIC_LC.CUS_NAME is 客户名称;comment on column ACC_DOMESTIC_LC.CUS_POST_CODE is 申请人邮编;comment on column ACC_DOMESTIC_LC.CUS_ADDR is 申请人地址;comment on column ACC_DOMESTIC_LC.ISSUING_BANK_NAME is 开证行名称;comment on column ACC_DOMESTIC_LC.APPLY_CUR_TYPE is 币种;comment on column ACC_DOMESTIC_LC.APPLY_AMOUNT is 申请开证金额;comment on column ACC_DOMESTIC_LC.IS_BB_LC is 是否背对背信用证;comment on column ACC_DOMESTIC_LC.OLD_LC_NO is 原信用证证号码;comment on column ACC_DOMESTIC_LC.OLD_APPLY_AMOUNT is 原证开证金额;comment on column ACC_DOMESTIC_LC.OLD_DUE_DATE is 原证到期日;comment on column ACC_DOMESTIC_LC.START_DATE is 起始日;comment on column ACC_DOMESTIC_LC.DUE_DATE is 到期日;comment on column ACC_DOMESTIC_LC.SECURITY_MONEY_AMT is 保证金金额(元);comment on column ACC_DOMESTIC_LC.SECURITY_MONEY_RT is 保证金比例;comment on column ACC_DOMESTIC_LC.THIRD_SEC_IND is 是否使用第三方保证金;comment on column ACC_DOMESTIC_LC.RISK_OPEN_AMT is 风险敞口金额(元);comment on column ACC_DOMESTIC_LC.RISK_OPEN_RATE is 风险敞口比例;comment on column ACC_DOMESTIC_LC.LIMIT_IND is 使用授信额度标识;comment on column ACC_DOMESTIC_LC.LIMIT_MA_NO is 授信协议编号;comment on column ACC_DOMESTIC_LC.LIMIT_AMT is 使用额度金额;comment on column ACC_DOMESTIC_LC.LIMIT_ACC_NO is 授信台帐编号;comment on column ACC_DOMESTIC_LC.AFFORD_FEE is 费用承担人;comment on column ACC_DOMESTIC_LC.FEE_ACCOUNT is 手续费扣款账号;comment on column ACC_DOMESTIC_LC.INPUT_DATE is 登记日期;comment on column ACC_DOMESTIC_LC.CUS_MANAGER is 客户经理;comment on column ACC_DOMESTIC_LC.INPUT_ID is 协办客户经理;comment on column ACC_DOMESTIC_LC.MAIN_BR_ID is 主管机构;comment on column ACC_DOMESTIC_LC.INPUT_BR_ID is 受理机构;comment on column ACC_DOMESTIC_LC.PRD_PK is 产品主键;comment on column ACC_DOMESTIC_LC.APPROVE_STATUS is 流程状态;comment on column ACC_DOMESTIC_LC.NOTE_NO is 通知书;comment on column ACC_DOMESTIC_LC.NOTE_DATE is 通知书日期;comment on column ACC_DOMESTIC_LC.FEE_AMOUNT is 手续费;comment on column ACC_DOMESTIC_LC.CUS_ACCOUNT is 申请人账户;comment on column ACC_DOMESTIC_LC.CUS_ACCOUNT_NAME is 申请人账户名称;comment on column ACC_DOMESTIC_LC.BFC_ACCOUNT is 受益人账户;comment on column ACC_DOMESTIC_LC.BFC_ACCOUNT_NAME is 受益人账户名称;comment on column ACC_DOMESTIC_LC.FINA_BR_ID is 账务机构;comment on column ACC_DOMESTIC_LC.FEE_ACCOUNT_NAME is 手续费账户名称;comment on column ACC_DOMESTIC_LC.ASSURE_MEANS_MAIN is 担保方式;comment on column ACC_DOMESTIC_LC.ACCOUNT_STATUS is 台账状态;comment on column ACC_DOMESTIC_LC.CLA is 五级分类结果;comment on column ACC_DOMESTIC_LC.CLA_DATE is 五级分类日期;comment on column ACC_DOMESTIC_LC.CLA_PRE is 上次五级分类结果;comment on column ACC_DOMESTIC_LC.CLA_DATE_PRE is 上次五级分类日期;comment on column ACC_DOMESTIC_LC.ACCT_TYPE is 开证人帐户类型;comment on column ACC_DOMESTIC_LC.ACCT_CODE is 开证人账号代码;comment on column ACC_DOMESTIC_LC.ACCT_NTT_IND is 开证人账号钞汇标志;comment on column ACC_DOMESTIC_LC.ACCOUNT_CLASS is 开证人科目号;comment on column ACC_DOMESTIC_LC.BFC_ACCT_TYPE is 受益人帐户类型;comment on column ACC_DOMESTIC_LC.BFC_ACCT_CODE is 受益人帐户代码;comment on column ACC_DOMESTIC_LC.BFC_ACCT_NTT_IND is 受益人账号钞汇标志;comment on column ACC_DOMESTIC_LC.BFC_ACCOUNT_CLASS is 受益人科目号;comment on column ACC_DOMESTIC_LC.MOD_NUM is 修改次数;comment on column ACC_DOMESTIC_LC.MOD_CONT_NO is 最近一次信用证修改的协议号;comment on column ACC_DOMESTIC_LC.LC_STATUS is 信用证状态;comment on column ACC_DOMESTIC_LC.DEAL_PLC is 信用证处理过程 1 开证行处理中 2 通知行处理中 3 议付行处理中;comment on column ACC_DOMESTIC_LC.POST_FEE_AMOUNT is 邮电费;comment on column ACC_DOMESTIC_LC.FEE_RATE is 手续费率;comment on column ACC_DOMESTIC_LC.CHANGE_DATE is 修改日期;comment on column ACC_DOMESTIC_LC.PAY_MODE is 付款方式;comment on column ACC_DOMESTIC_LC.PAY_LIMIT_DAY is 付款期限;comment on column ACC_DOMESTIC_LC.IS_ALLOW_PART is 分批装运;comment on column ACC_DOMESTIC_LC.IS_ALLOW_TRAN is 转运;comment on column ACC_DOMESTIC_LC.GOODS_START_ADDR is 货物运输起止地自（起始地）;comment on column ACC_DOMESTIC_LC.GOODS_DUE_ADDR is 货物运输起止地自（目的地）;comment on column ACC_DOMESTIC_LC.GOODS_LAST_LOAD_DATE is 货物最迟装运日期;comment on column ACC_DOMESTIC_LC.TRADE_CONT_NO is 贸易合同号码;comment on column ACC_DOMESTIC_LC.GOODS_DESC is 货物描述;comment on column ACC_DOMESTIC_LC.BFC_SUB_DOCS is 受益人应提交的单据;comment on column AC