金蝶EAS Cloud 语句.docx

1.建表语句CREATETABLE"T_EBG_BANK_CNAPS"("BANKCNAPS"NVARCHAR2(20),"BANKNAME"NVARCHAR2(50)NOTNULLENABLE,"PROVINCE"NVARCHAR2(50),"CITY"NVARCHAR2(100),"BANKDETAIL"NVARCHAR2(200)NOTNULLENABLE,"REMARK"NVARCHAR2(500),CONSTRAINT"PK_T_EBG_BANK_CNAPS"PRIMARYKEY("BANKCNAPS")ENABLE);CREATETABLE"T_EBG_BANK_CNAPS_TEMP1"("BANKCNAPS"NVARCHAR2(20),"BANKNAME"NVARCHAR2(50)NOTNULLENABLE,"PROVINCE"NVARCHAR2(50),"CITY"NVARCHAR2(100),"BANKDETAIL"NVARCHAR2(200)NOTNULLENABLE,"REMARK"NVARCHAR2(500),CONSTRAINT"PK_T_EBG_BANK_CNAPS_TEMP1"PRIMARYKEY("BANKCNAPS")ENABLE);CREATETABLE"T_EBG_BANK_CURRENCY"("ISO_CODE"VARCHAR2(20BYTE)NOTNULLENABLE,"BANK_VERSION_ID"VARCHAR2(20BYTE)NOTNULLENABLE,"BANK_CURRENCY"NVARCHAR2(20)NOTNULLENABLE,CONSTRAINT"PK_EBG_BANK_CURRENCY"PRIMARYKEY("ISO_CODE","BANK_VERSION_ID")ENABLE);CREATEUNIQUEINDEX"INDX_EBG_BANK_CURRENCY"ON"T_EBG_BANK_CURRENCY"("BANK_VERSION_ID","BANK_CURRENCY");CREATETABLE"T_EBG_BANK_KEYWORD"("BANK_VERSION_ID"VARCHAR2(15BYTE)NOTNULLENABLE,"BANK_KEY"NVARCHAR2(200)NOTNULLENABLE,CONSTRAINT"PK_EBG_BANK_KEYWORDS"PRIMARYKEY("BANK_VERSION_ID","BANK_KEY")ENABLE);CREATETABLE"T_EBG_BANK_PAYROUTE"("ID"VARCHAR2(25BYTE)NOTNULLENABLE,"PARENT_ID"VARCHAR2(25BYTE)NOTNULLENABLE,"NAME"NVARCHAR2(200)NOTNULLENABLE,"DESCVALUE"NVARCHAR2(200),"BANK_VERSION_ID"VARCHAR2(15BYTE)NOTNULLENABLE,"MER_NAME"VARCHAR2(260BYTE),CONSTRAINT"PK_EBG_BANK_PAYROUTE_KEYWORDS"PRIMARYKEY("ID")ENABLE);CREATETABLE"T_EBG_BANK_REQUEST_LOG"("ID"VARCHAR2(16BYTE)NOTNULLENABLE,"REQUEST_SEQ_ID"VARCHAR2(50BYTE),"BANK_REQUEST_SEQ"VARCHAR2(50BYTE),"BANK_RESPONSE_SEQ"VARCHAR2(20BYTE),"BANK_RALATION_REQUEST_SEQ"VARCHAR2(100BYTE),"EXISTEXCEPTION"VARCHAR2(8BYTE),"BANK_VERSION_ID"VARCHAR2(20BYTE),"BANK_LOGIN_ID"VARCHAR2(20BYTE),"BIZ_NAME"VARCHAR2(50BYTE),"REQUEST_LOCK_TIME"TIMESTAMP(6),"LOCK_TIME"TIMESTAMP(6),"BEGIN_SEND_TIME"TIMESTAMP(6),"READ_FULL_TIME"TIMESTAMP(6),"RELEASE_TIME"TIMESTAMP(6),"COST"NUMBER(10,0),"BATCH_SEQ_ID"VARCHAR2(255BYTE),"ACC_NO"VARCHAR2(50BYTE),"LOG_PATH"VARCHAR2(255BYTE),"DETAILS"VARCHAR2(1000BYTE),CONSTRAINT"PK_EBG_BANKREQUESTLOG"PRIMARYKEY("ID")ENABLE);;CREATEINDEX"IX_BANK_LOG_LOGIN"ON"T_EBG_BANK_REQUEST_LOG"("BANK_LOGIN_ID");CREATEINDEX"BANKREQUESTLOGTIMEINDEX"ON"T_EBG_BANK_REQUEST_LOG"("RELEASE_TIME");CREATETABLE"T_EBG_BANKACNT"("ACC_NO"VARCHAR2(50BYTE)NOTNULLENABLE,"ACC_NAME"VARCHAR2(255BYTE)NOTNULLENABLE,"BANK_NAME"VARCHAR2(255BYTE)NOTNULLENABLE,"BANK_ADDRESS"NVARCHAR2(255),"AREA_CODE"VARCHAR2(50BYTE)NOTNULLENABLE,"ACC_DEPT"VARCHAR2(50BYTE)NOTNULLENABLE,"COUNTRY"VARCHAR2(50BYTE)NOTNULLENABLE,"PROVINCE"VARCHAR2(50BYTE)NOTNULLENABLE,"CITY"VARCHAR2(50BYTE)NOTNULLENABLE,"CNAPS"VARCHAR2(50BYTE),"SWIFT_CODE"VARCHAR2(50BYTE),"CURRENCY"VARCHAR2(3BYTE)NOTNULLENABLE,"BANK_VERSION_ID"VARCHAR2(20BYTE)NOTNULLENABLE,"BANK_LOGIN_ID"VARCHAR2(20BYTE)NOTNULLENABLE,"BANK_SHORT_NAME"VARCHAR2(255BYTE)NOTNULLENABLE,CONSTRAINT"PK_EBG_BANKACNT"PRIMARYKEY("ACC_NO")ENABLE);CREATETABLE"T_EBG_BANKACNT_TYPE"("BANK_VERSION_ID"VARCHAR2(15BYTE)NOTNULLENABLE,"ACCNO_CODE"NVARCHAR2(20)NOTNULLENABLE,"ACCNO_TYPE"NVARCHAR2(20)NOTNULLENABLE,CONSTRAINT"PK_EBG_BANKACNT_TYPE"PRIMARYKEY("BANK_VERSION_ID","ACCNO_CODE")ENABLE);CREATETABLE"T_EBG_BANKCNAPS_UPDATE"("SEQUENCEID"NVARCHAR2(10),"INSERTTIME"TIMESTAMP(6),"DESCRIPTION"NVARCHAR2(50),"TOTALSIZE"NUMBER(10,0),"REMARK"NVARCHAR2(500),CONSTRAINT"PK_T_EBG_BANKCNAPS_UPDATE"PRIMARYKEY("SEQUENCEID")ENABLE);CREATETABLE"T_EBG_BANKINFO"("ID"VARCHAR2(50BYTE)NOTNULLENABLE,"BANK_LOGIN_ID"VARCHAR2(20BYTE)NOTNULLENABLE,"UPDATE_TIME"TIMESTAMP(6)NOTNULLENABLE,"VERIFY_CODE"VARCHAR2(255BYTE)NOTNULLENABLE,"MODULE_NAME"VARCHAR2(40BYTE),CONSTRAINT"PK_EBG_BANKINFO"PRIMARYKEY("ID")ENABLE);CREATETABLE"T_EBG_BANKLOGIN"("BANK_LOGIN_ID"VARCHAR2(50BYTE)NOTNULLENABLE,"BANK_VERSION_ID"VARCHAR2(50BYTE)NOTNULLENABLE,"BANK_VERSION_NAME"NVARCHAR2(50)NOTNULLENABLE,"BANK_NAME"NVARCHAR2(150)NOTNULLENABLE,"BANK_LOGIN_COUNT"NUMBER(10,0)NOTNULLENABLE,"BANK_LOGIN_NAME"NVARCHAR2(150)DEFAULT'EMPTY',CONSTRAINT"PK_EBG_BANKLOGIN"PRIMARYKEY("BANK_LOGIN_ID")ENABLE);CREATETABLE"T_EBG_BANKLOGINCONFIG"("BANK_VERSION_ID"VARCHAR2(50BYTE)NOTNULLENABLE,"BANK_LOGIN_ID"VARCHAR2(50BYTE)NOTNULLENABLE,"BANK_CONFIG_ID"VARCHAR2(50BYTE)NOTNULLENABLE,"BANK_CONFIG_VALUE"NVARCHAR2(200),"BANK_CONFIG_NAME"NVARCHAR2(150),"READ_ONLY"VARCHAR2(5BYTE)NOTNULLENABLE,"NULLABLE"VARCHAR2(5BYTE)NOTNULLENABLE,CONSTRAINT"PK_EBG_BKLOGINCONF"PRIMARYKEY("BANK_VERSION_ID","BANK_LOGIN_ID","BANK_CONFIG_ID")ENABLE);CREATETABLE"T_EBG_BASE_AREACODE"("AREAID"NUMBER(10,0),"AREACODE"NUMBER(10,0),"AREANAME"VARCHAR2(100BYTE),"AREALEVEL"NUMBER(10,0),"CITYID"NUMBER(10,0),"PROVINCEID"NUMBER(10,0),PRIMARYKEY("AREAID")ENABLE);CREATETABLE"T_EBG_BASE_BANKCODE"("BANKID"NUMBER(10,0),"BANKCODE"VARCHAR2(6BYTE),"BANKNAME"VARCHAR2(100BYTE),"BANKTYPE"VARCHAR2(50BYTE),PRIMARYKEY("BANKID")ENABLE);CREATETABLE"T_EBG_BASE_BANKDETAIL"("BANKCNAPS"VARCHAR2(14BYTE),"BANKCODE"VARCHAR2(6BYTE),"AREAID"NUMBER(10,0),"BANKNAME"VARCHAR2(100BYTE),"BANKADDRESS"VARCHAR2(500BYTE),"CLEARINGBANKID"NUMBER(10,0)DEFAULT-1,"CLEARINGBANKCODE"VARCHAR2(14BYTE),PRIMARYKEY("BANKCNAPS")ENABLE);CREATETABLE"T_EBG_BASE_CITYCODE"("CITYID"NUMBER(10,0),"CITYNAME"VARCHAR2(100BYTE),"PROVINCEID"NUMBER(10,0),PRIMARYKEY("CITYID")ENABLE);CREATETABLE"T_EBG_BASE_CLEARINGBANK"("ID"NUMBER(10,0),"BANK_CODE"VARCHAR2(14BYTE),"BANK_NAME"VARCHAR2(100BYTE),"BANK_KEYWORDS"VARCHAR2(50BYTE),"BANK_TYPE"VARCHAR2(255BYTE),PRIMARYKEY("ID")ENABLE);CREATETABLE"T_EBG_BASE_PROVINCECODE"("PROVINCEID"NUMBER(10,0),"PROVINCENAME"VARCHAR2(100BYTE),"PROVINCECODE"NUMBER(10,0),PRIMARYKEY("PROVINCEID")ENABLE);CREATETABLE"T_EBG_BOCOM_DC_BUSI_NO"("ACC_NO"VARCHAR2(50BYTE)NOTNULLENABLE,"BUSI_TYPE"VARCHAR2(10BYTE)NOTNULLENABLE,"BUSI_NO"VARCHAR2(50BYTE)NOTNULLENABLE,CONSTRAINT"PK_EBG_BOCOM_DC_BUSI_NO"PRIMARYKEY("ACC_NO","BUSI_TYPE")ENABLE);CREATETABLE"T_EBG_BOCOM_DC_BUSINO"("ACC_NO"VARCHAR2(50BYTE)NOTNULLENABLE,"BUSI_TYPE"VARCHAR2(10BYTE)NOTNULLENABLE,"BUSI_NO"VARCHAR2(50BYTE)NOTNULLENABLE,CONSTRAINT"PK_EBG_BOCOM_DC_BUSINO"PRIMARYKEY("ACC_NO","BUSI_TYPE")ENABLE);CREATETABLE"T_EBG_CONCURRENCY"("BANK_VERSION_ID"VARCHAR2(20BYTE),"BANK_NAME"VARCHAR2(255BYTE)NOTNULLENABLE,"FRONT_THREAD"NUMBER(10,0),"PAY_THREAD"NUMBER(10,0),"QUERY_THREAD"NUMBER(10,0),"PAY_STATE"NUMBER(10,0),"QUERY_STATE"NUMBER(10,0),PRIMARYKEY("BANK_VERSION_ID")ENABLE);CREATETABLE"T_EBG_CREDITDEALRECEIVEDINFO"("ID"VARCHAR2(50BYTE)NOTNULLENABLE,"BANK_VERSION_ID"VARCHAR2(20BYTE)NOTNULLENABLE,"BANK_LOGIN_ID"VARCHAR2(50BYTE)NOTNULLENABLE,"BIZ_TYPE"VARCHAR2(50BYTE)NOTNULLENABLE,"SUB_BIZ_TYPE"VARCHAR2(50BYTE)NOTNULLENABLE,"IMPL_CLASS_NAME"VARCHAR2(255BYTE)NOTNULLENABLE,"PACKAGE_KEY"VARCHAR2(255BYTE)NOTNULLENABLE,"BATCHSEQID"VARCHAR2(50BYTE)NOTNULLENABLE,"DETAILSEQID"VARCHAR2(50BYTE)NOTNULLENABLE,"DETAILBIZNO"VARCHAR2(50BYTE),"INSERTBATCHSEQ"VARCHAR2(50BYTE),"INSERTTIME"TIMESTAMP(6)NOTNULLENABLE,"REQUESTSEQ"VARCHAR2(50BYTE),"REQUESTTIME"TIMESTAMP(6),"UPDATETIME"TIMESTAMP(6),"UPDATEBATCHSEQ"VARCHAR2(50BYTE),"UPDATEOPERATION"VARCHAR2(50BYTE),"VERIFYFIELD"VARCHAR2(255BYTE),"STATUS"NUMBER(10,0),"STATUSNAME"VARCHAR2(20BYTE),"STATUSMSG"VARCHAR2(50BYTE),"BANKSTATUS"VARCHAR2(20BYTE),"BANKMSG"VARCHAR2(255BYTE),"ERRORMSG"VARCHAR2(250BYTE),"BAKSTATUS"VARCHAR2(50BYTE),"BAKSTATUSNAME"VARCHAR2(50BYTE),"BAKSTATUSMSG"VARCHAR2(50BYTE),"BAKBANKSTATUS"VARCHAR2(50BYTE),"BAKBANKMSG"VARCHAR2(50BYTE),"BAKERRORMSG"VARCHAR2(50BYTE),"PACKAGETIME"TIMESTAMP(6),"BANKBATCHSEQID"VARCHAR2(50BYTE),"BANKDETAILSEQID"VARCHAR2(50BYTE),"BANKSERIALNO"VARCHAR2(50BYTE),"LASTSUBMITTIME"TIMESTAMP(6),"LASTSUBMITREQUESTSEQ"VARCHAR2(50BYTE),"SUBMITCOUNT"NUMBER(10,0)DEFAULT0NOTNULLENABLE,"SUBMITSUCCESSTIME"TIMESTAMP(6),"LASTSYNCTIME"TIMESTAMP(6),"LASTSYNCREQUESTSEQ"VARCHAR2(50BYTE),"SYNCCOUNT"NUMBER(10,0),"FINISHTIME"TIMESTAMP(6),"ACCNO"VARCHAR2(50BYTE)NOTNULLENABLE,"CREDITNO"VARCHAR2(20BYTE),"BRANCHNO"VARCHAR2(255BYTE),"RECEIVEDCREDITNUMBER"VARCHAR2(50BYTE),"REFERENCENUM"VARCHAR2(50BYTE),"CONTRACTNO"VARCHAR2(50BYTE),"RECEIVEDDATE"TIMESTAMP(6),"AMOUNT"VARCHAR2(50BYTE),"CLAIMAMOUNT"VARCHAR2(50BYTE),"SUBMITBANK"VARCHAR2(255BYTE),"APPLICANT"VARCHAR2(255BYTE),"BENEFICIARY"VARCHAR2(255BYTE),"NOTICEDDATE"TIMESTAMP(6),"SYSTEMBUISNESSNO"VARCHAR2(250BYTE),"RECEIVEDNOTICEDATE"TIMESTAMP(6),"APPLICATIONITEMS"VARCHAR2(50BYTE),"REJECTRESULT"VARCHAR2(50BYTE),"NOTE"VARCHAR2(255BYTE),"APPLYDATE"TIMESTAMP(6),"REJECTDATE"TIMESTAMP(6),"REJECTAMOUNT"VARCHAR2(50BYTE),"EXPIREDATE"TIMESTAMP(6),"ACCEPTDATE"TIMESTAMP(6),"ACCEPTAMOUNT"VARCHAR2(50BYTE),"NOTIFYDATE"TIMESTAMP(6),"PAYTYPE"VARCHAR2(50BYTE),"PAYDATE"TIMESTAMP(6),"PAYAMOUNT"VARCHAR2(50BYTE),"DEALTYPE"VARCHAR2(50BYTE),"DEALSUBTYPE"VARCHAR2(50BYTE),"QUERYINTERFACETYPE"NUMBER(10,0),"TOGIVEUP"VARCHAR2(50BYTE),"USECODE"VARCHAR2(50BYTE),"USECN"VARCHAR2(50BYTE),"MOBILE"VARCHAR2(50BYTE),"EMAIL"VARCHAR2(50BYTE),"EBSEQID"VARCHAR2(50BYTE),"EBSTATUS"VARCHAR2(50BYTE),"EBSTATUSMSG"VARCHAR2(150BYTE),"DEALMODE"VARCHAR2(50BYTE),"ISGENPAY"VARCHAR2(20BYTE),"ISGENLOANREQ"VARCHAR2(20BYTE),"ISACCEPT"VARCHAR2(20BYTE),"ISREFUSE"VARCHAR2(20BYTE),"BILLSTATE"VARCHAR2(20BYTE),"CREDITOPENID"VARCHAR2(50BYTE),"PLANPAYDATE"TIMESTAMP(6),"DRAFTDAY"VARCHAR2(20BYTE),"RESERVED_BIZ_FILED"CLOB,"RESERVED_SYS_FILED"CLOB,"RESERVED_FILED_1"VARCHAR2(255BYTE),"RESERVED_FILED_2"VARCHAR2(255BYTE),"RESERVED_FILED_3"VARCHAR2(255BYTE),"RESERVED_FILED_4"VARCHAR2(255BYTE),"RESERVED_FILED_5"VARCHAR2(255BYTE),"RESERVED_FILED_6"VARCHAR2(255BYTE),"RESERVED_FILED_7"VARCHAR2(255BYTE),"RESERVED_FILED_8"VARCHAR2(255BYTE),PRIMARYKEY("ID")ENABLE);CREATETABLE"T_EBG_CREDITMODIFYINFO"("ID"VARCHAR2(50BYTE)NOTNULLENABLE,"BANK_VERSION_ID"VARCHAR2(20BYTE)NOTNULLENABLE,"BANK_LOGIN_ID"VARCHAR2(50BYTE)NOTNULLENABLE,"BIZ_TYPE"VARCHAR2(50BYTE)NOTNULLENABLE,"SUB_BIZ_TYPE"VARCHAR2(50BYTE)NOTNULLENABLE,"IMPL_CLASS_NAME"VARCHAR2(255BYTE)NOTNULLENABLE,"PACKAGE_KEY"VARCHAR2(255BYTE)NOTNULLENABLE,"BATCHSEQID"VARCHAR2(50BYTE)NOTNULLENABLE,"DETAILSEQID"VARCHAR2(50BYTE)NOTNULLENABLE,"DETAILBIZNO"VARCHAR2(50BYTE),"INSERTBATCHSEQ"VARCHAR2(50BYTE),"INSERTTIME"TIMESTAMP(6)NOTNULLENABLE,"REQUESTSEQ"VARCHAR2(50BYTE),"REQUESTTIME"TIMESTAMP(6),"UPDATETIME"TIMESTAMP(6),"UPDATEBATCHSEQ"VARCHAR2(50BYTE),"UPDATEOPERATION"VARCHAR2(50BYTE),"VERIFYFIELD"VARCHAR2(255BYTE),"STATUS"NUMBER(10,0),"STATUSNAME"VARCHAR2(20BYTE),"STATUSMSG"VARCHAR2(250BYTE),"BANKSTATUS"VARCHAR2(50BYTE),"BANKMSG"VARCHAR2(250BYTE),"ERRORMSG"VARCHAR2(150BYTE),"BAKSTATUS"VARCHAR2(250BYTE),"BAKSTATUSNAME"VARCHAR2(250BYTE),"BAKSTATUSMSG"VARCHAR2(250BYTE),"BAKBANKSTATUS"VARCHAR2(250BYTE),"BAKBANKMSG"VARCHAR2(250BYTE),"BAKERRORMSG"VARCHAR2(250BYTE),"PACKAGETIME"TIMESTAMP(6),"BANKBATCHSEQID"VARCHAR2(50BYTE),"BANKDETAILSEQID"VARCHAR2(50BYTE),"BANKSERIALNO"VARCHAR2(50BYTE),"LASTSUBMITTIME"TIMESTAMP(6),"LASTSUBMITREQUESTSEQ"VARCHAR2(50BYTE),"SUBMITCOUNT"NUMBER(10,0),"SUBMITSUCCESSTIME"TIMESTAMP(6),"LASTSYNCTIME"TIMESTAMP(6),"LASTSYNCREQUESTSEQ"VARCHAR2(50BYTE),"SYNCCOUNT"NUMBER(10,0),"FINISHTIME"TIMESTAMP(6),"ACCNO"VARCHAR2(50BYTE)NOTNULLENABLE,"BRANCHNO"VARCHAR2(255BYTE)NOTNULLENABLE,"CREDITNO"VARCHAR2(50BYTE)NOTNULLENABLE,"APPLICANT"VARCHAR2(255BYTE)NOTNULLENABLE,"BENEFICIARY"VARCHAR2(255BYTE)NOTNULLENABLE,"APPLYITEMS"CLOBNOTNULLENABLE,"CCOMMENT"VARCHAR2(255BYTE),"APPLYDATE"TIMESTAMP(6)NOTNULLENABLE,"SENDREFERENCE"VARCHAR2(50BYTE),"RECEIVERREFERENCE"VARCHAR2(50BYTE),"ISSUINGBANKREFERENCE"VARCHAR2(50BYTE),"AMENDMENTNUMBER"VARCHAR2(50BYTE),"AMENDMENTDATE"TIMESTAMP(6),"ISSUEDATE"TIMESTAMP(6),"NEWEXPIRYDATE"TIMESTAMP(6),"INCREASECREDITAMOUNT"VARCHAR2(50BYTE),"DECREASECREDITAMOUNT"VARCHAR2(50BYTE),"NEWCREDITAMOUNT"VARCHAR2(50BYTE),"PERCENTAGEAMOUNTTOLERANCE"VARCHAR2(50BYTE),"MAXIMUMCREDITAMOUNT"VARCHAR2(50BYTE),"ADDITIONALAMOUNTCOVERED"VARCHAR2(50BYTE),"PLACEOFRECEIPT"VARCHAR2(255BYTE),"PORTOFLOADING"VARCHAR2(255BYTE),"PORTOFDISCHARGE"VARCHAR2(255BYTE),"PLACEOFDELIVERY"VARCHAR2(255BYTE),"NEWLATESTSHIPMENTDATE"TIMESTAMP(6),"SHIPMENTPERIOD"VARCHAR2(150BYTE),"NARRATIVE"VARCHAR2(255BYTE),"SENDERTORECEIVERINFOMATION"VARCHAR2(255BYTE),"SYSTEMBUISNESSNO"VARCHAR2(50BYTE),"RECEIVEDNOTIFYDATETIME"TIMESTAMP(6),"USECODE"VARCHAR2(50BYTE),"USECN"VARCHAR2(50BYTE),"MOBILE"VARCHAR2(50BYTE),"EMAIL"VARCHAR2(50BYTE),"EBSEQID"VARCHAR2(50BYTE),"EBSTATUS"VARCHAR2(50BYTE),"EBSTATUSMSG"VARCHAR2(150BYTE),"CREDITOPENID"VARCHAR2(250BYTE),"MODIFYREASON"VARCHAR2(222BYTE),"QUERYINTERFACETYPE"NUMBER(10,0),"TOGIVEUP"VARCHAR2(20BYTE),"RESERVED_BIZ_FILED"CLOB,"RESERVED_SYS_FILED"CLOB,"RESERVED_FILED_1"VARCHAR2(255BYTE),"RESERVED_FILED_2"VARCHAR2(255BYTE),"RESERVED_FILED_3"VARCHAR2(255BYTE),"RESERVED_FILED_4"VARCHAR2(255BYTE),"RESERVED_FILED_5"VARCHAR2(255BYTE),"RESERVED_FILED_6"VARCHAR2(255BYTE),"RESERVED_FILED_7"VARCHAR2(255BYTE),"RESERVED_FILED_8"VARCHAR2(255BYTE),PRIMARYKEY("ID")ENABLE);CREATETABLE"T_EBG_CREDITOPENINFO"("ID"VARCHAR2(50BYTE)NOTNULLENABLE,"BANK_VERSION_ID"VARCHAR2(20BYTE)NOTNULLENABLE,"BANK_LOGIN_ID"VARCHAR2(50BYTE)NOTNULLENABLE,"BIZ_TYPE"VARCHAR2(50BYTE)NOTNULLENABLE,"SUB_BIZ_TYPE"VARCHAR2(50BYTE)NOTNULLENABLE,"IMPL_CLASS_NAME"VARCHAR2(255BYTE)NOTNULLENABLE,"PACKAGE_KEY"VARCHAR2(255BYTE)NOTNULLENABLE,"BATCHSEQID"VARCHAR2(50BYTE)NOTNULLENABLE,"DETAILSEQID"VARCHAR2(50BYTE)NOTNULLENABLE,"DETAILBIZNO"VARCHAR2(50BYTE),"INSERTBATCHSEQ"VARCHAR2(50BYTE),"INSERTTIME"TIMESTAMP(6)NOTNULLENABLE,"REQUESTSEQ"VARCHAR2(50BYTE),"REQUESTTIME"TIMESTAMP(6),"UPDATETIME"TIMESTAMP(6),"UPDATEBATCHSEQ"VARCHAR2(50BYTE),"UPDATEOPERATION"VARCHAR2(50BYTE),"VERIFYFIELD"VARCHAR2(255BYTE),"STATUS"NUMBER(10,0),"STATUSNAME"VARCHAR2(50BYTE),"STATUSMSG"VARCHAR2(250BYTE),"BANKSTATUS"VARCHAR2(250BYTE),"BANKMSG"VARCHAR2(255BYTE),"ERRORMSG"VARCHAR2(250BYTE),"BAKSTATUS"VARCHAR2(250BYTE),"BAKSTATUSNAME"VARCHAR2(250BYTE),"BAKSTATUSMSG"VARCHAR2(250BYTE),"BAKBANKSTATUS"VARCHAR2(250BYTE),"BAKBANKMSG"VARCHAR2(250BYTE),"BAKERRORMSG"VARCHAR2(250BYTE),"PACKAGETIME"TIMESTAMP(6),"BANKBATCHSEQID"VARCHAR2(50BYTE),"BANKDETAILSEQID"VARCHAR2(50BYTE),"BANKSERIALNO"VARCHAR2(50BYTE),"LASTSUBMITTIME"TIMESTAMP(6),"LASTSUBMITREQUESTSEQ"VARCHAR2(50BYTE),"SUBMITCOUNT"NUMBER(10,0)NOTNULLENABLE,"SUBMITSUCCESSTIME"TIMESTAMP(6),"LASTSYNCTIME"TIMESTAMP(6),"LASTSYNCREQUESTSEQ"VARCHAR2(50BYTE),"SYNCCOUNT"NUMBER(10,0),"FINISHTIME"TIMESTAMP(6),"CREDITTYPE"VARCHAR2(50BYTE)NOTNULLENABLE,"NOMINALCURRENCY"VARCHAR2(50BYTE)NOTNULLENABLE,"NOMINALAMOUNT"VARCHAR2(50BYTE)NOTNULLENABLE,"INITIALCODE"VARCHAR2(50BYTE)NOTNULLENABLE,"ISSUEDDATE"TIMESTAMP(6)NOTNULLENABLE,"LATESTSHIPMENTDATE"TIMESTAMP(6),"EXPIRINGDATE"TIMESTAMP(6)NOTNULLENABLE,"EXPIRYPLACE"VARCHAR2(150BYTE)NOTNULLENABLE,"TENORS"VARCHAR2(150BYTE)NOTNULLENABLE,"APPLICABLERULES"VARCHAR2(150BYTE)NOTNULLENABLE,"CONTRACTNO"VARCHAR2(50BYTE)NOTNULLENABLE,"CONTRACTAMOUNT"VARCHAR2(50BYTE)NOTNULLENABLE,"APPLICANT"VARCHAR2(200BYTE)NOTNULLENABLE,"ADVISINGBANK"VARCHAR2(200BYTE)NOTNULLENABLE,"BENEFICIARY"VARCHAR2(200BYTE)NOTNULLENABLE,"CONFIRMINSTRUCTION"VARCHAR2(50BYTE)NOTNULLENABLE,"APPLICANTBANK"VARCHAR2(200BYTE),"OTHERADVISINGBANK"VARCHAR2(200BYTE),"AVAILABLEWITHBANK"VARCHAR2(200BYTE)NOTNULLENABLE,"AVAILABLEBY"VARCHAR2(200BYTE)NOTNULLENABLE,"DRAFTSAT"VARCHAR2(200BYTE),"DRAWEE"VARCHAR2(200BYTE),"DEFPAYMENTDETAILS"VARCHAR2(255BYTE),"MIXEDPAYMENTDETAILS"VARCHAR2(255BYTE),"PRESENTATIONPERIOD"VARCHAR2(200BYTE),"DETAILSOFCHARGES"VARCHAR2(255BYTE),"COUNTRYCODE"VARCHAR2(50BYTE)NOTNULLENABLE,"PATIALSHIPMENT"VARCHAR2(20BYTE),"TRANSSHIPMENT"VARCHAR2(20BYTE),"PLACEOFRECEIPT"VARCHAR2(255BYTE),"PORTOFLOADING"VARCHAR2(255BYTE),"PORTOFDISCHARGE"VARCHAR2(255BYTE),"FINALDESTINATION"VARCHAR2(255BYTE),"SHIPMENTPERIOD"CLOB,"GOODS"CLOBNOTNULLENABLE,"DOCUMENTS"CLOBNOTNULLENABLE,"ADDITIONALCONDITIONS"CLOBNOTNULLENABLE,"CCOMMENT"VARCHAR2(255BYTE),"CREDITREFERENCENO"VARCHAR2(50BYTE),"PREADVICEDATE"TIMESTAMP(6),"GOODSSECOND"CLOB,"DOCUMENTSSECOND"CLOB,"ADDITIONALCONDITIONSSECOND"CLOB,"REIMBURSEMENTBANK"VARCHAR2(255BYTE),"PAYBANK"CLOB,"TORECEIVERINFO"VARCHAR2(255BYTE),"CORRESPONDENTBANK"VARCHAR2(255BYTE),"APPLICATIONNO"VARCHAR2(150BYTE),"SYSTEMBUISNESSNO"VARCHAR2(150BYTE),"DATEOFRECEIVEDNOTIFY"VARCHAR2(50BYTE),"EBSEQID"VARCHAR2(50BYTE),"EBSTATUS"VARCHAR2(50BYTE),"EBSTATUSMSG"VARCHAR2(150BYTE),"QUERYINTERFACETYPE"NUMBER(10,0)NOTNULLENABLE,"LASTQUERYDATETIME"TIMESTAMP(6),"TOGIVEUP"VARCHAR2(10BYTE),"MODIFYFLAG"VARCHAR2(10BYTE),"MODIFYREFERENCENO"VARCHAR2(50BYTE),"FINISHDATE"TIMESTAMP(6),"ISFORWARD"VARCHAR2(20BYTE),"BLOCKFLOWTYPE"VARCHAR2(100BYTE),"ACCOUNTANT"VARCHAR2(100BYTE),"CREDITPERCENTAGE"VARCHAR2(100BYTE),"USEDCREDITAMT"VARCHAR2(100BYTE),"NTTYPE"VARCHAR2(50BYTE),"MARGINRATE"VARCHAR2(50BYTE),"LIMITMARGIN"VARCHAR2(50BYTE),"MARGINCURRENCY"VARCHAR2(20BYTE),"MARGINEXRATE"VARCHAR2(50BYTE),"MARGINEX"VARCHAR2(50BYTE),"MARGINACCT"VARCHAR2(50BYTE),"PAYBANKACCT"VARCHAR2(50BYTE),"MARGINALGORITHM"VARCHAR2(150BYTE),"CASHIER"VARCHAR2(150BYTE),"ISGENREPAYMENT"VARCHAR2(20BYTE),"DEPARTMENT"VARCHAR2(50BYTE),"PROJECT"VARCHAR2(50BYTE),"LTTERHANDLER"VARCHAR2(50BYTE),"BABNUMBER"VARCHAR2(50BYTE),"HXDNUMBER"VARCHAR2(50BYTE),"TRANSPORTMODE"VARCHAR2(50BYTE),"BALANCE"VARCHAR2(50BYTE),"LOCALCUREXRATE"VARCHAR2(50BYTE),"RESERVED_BIZ_FILED"CLOB,"RESERVED_SYS_FILED"CLOB,"RESERVED_FILED_1"VARCHAR2(255BYTE),"RESERVED_FILED_2"VARCHAR2(255BYTE),"RESERVED_FILED_3"VARCHAR2(255BYTE),"RESERVED_FILED_4"VARCHAR2(255BYTE),"RESERVED_FILED_5"VARCHAR2(255BYTE),"RESERVED_FILED_6"VARCHAR2(255BYTE),"RESERVED_FILED_7"VARCHAR2(255BYTE),"RESERVED_FILED_8"VARCHAR2(255BYTE),PRIMARYKEY("ID")ENABLE);CREATETABLE"T_EBG_DETAILINFO"("ID"VARCHAR2(44BYTE)NOTNULLENABLE,"BANK_VERSION_ID"VARCHAR2(20BYTE)NOTNULLENABLE,"BANK_LOGIN_ID"VARCHAR2(50BYTE)NOTNULLENABLE,"IMPL_CLASS_NAME"VARCHAR2(255BYTE)NOTNULLENABLE,"INSERT_TIME"TIMESTAMP(6)NOTNULLENABLE,"UPDATE_TIME"TIMESTAMP(6),"DEBIT_AMOUNT"NUMBER(19,2)NOTNULLENABLE,"CREDIT_AMOUNT"NUMBER(19,2)NOTNULLENABLE,"CURRENCY"VARCHAR2(3BYTE)NOTNULLENABLE,"TRANS_DATE"TIMESTAMP(6)NOTNULLENABLE,"SERIAL_NO"NUMBER(10,0)NOTNULLENABLE,"IS_HISTORY"VARCHAR2(5BYTE)NOTNULLENABLE,"EXPLANATION"NVARCHAR2(500),"TRANS_TIME"TIMESTAMP(6),"TRANS_TYPE"NVARCHAR2(30),"USE_CN"NVARCHAR2(255),"BALANCE"NUMBER(19,2),"ACC_NO"VARCHAR2(50BYTE)NOTNULLENABLE,"ACC_NAME"NVARCHAR2(255),"BANK_NAME"NVARCHAR2(255),"THIRD_ACC_NO"VARCHAR2(50BYTE),"THIRD_ACC_NAME"NVARCHAR2(255),"THIRD_BANK_NAME"NVARCHAR2(255),"OPP_ACC_NO"VARCHAR2(101BYTE),"OPP_ACC_NAME"NVARCHAR2(255),"OPP_BANK_NAME"NVARCHAR2(255),"RESERVED_BIZ_FILED"NVARCHAR2(1000),"RESERVED_SYS_FILED"NVARCHAR2(2000),"ACC_TYPE"VARCHAR2(10BYTE),"BANK_ONLY_ID"VARCHAR2(500BYTE),CONSTRAINT"PK_EBG_DETAILINFO"PRIMARYKEY("ID")ENABLE);CREATEINDEX"INDEX_ACC_NO_DETAIL"ON"T_EBG_DETAILINFO"("ACC_NO");CREATEINDEX"INDEX_TRANS_DATE_DETAIL"ON"T_EBG_DETAILINFO"("TRANS_DATE");CREATEINDEX"INDEX_BANK_VERSION_ID_DETAIL"ON"T_EBG_DETAILINFO"("BANK_VERSION_ID");CREATEUNIQUEINDEX"INDX_ONLY_EBG_DETAILINFO"ON"T_EBG_DETAILINFO"("BANK_ONLY_ID");CREATETABLE"T_EBG_DETAILINFO_BK221019"("ID"VARCHAR2(44BYTE)NOTNULLENABLE,"BANK_VERSION_ID"VARCHAR2(20BYTE)NOTNULLENABLE,"BANK_LOGIN_ID"VARCHAR2(50BYTE)NOTNULLENABLE,"IMPL_CLASS_NAME"VARCHAR2(255BYTE)NOTNULLENABLE,"INSERT_TIME"TIMESTAMP(6)NOTNULLENABLE,"UPDATE_TIME"TIMESTAMP(6),"DEBIT_AMOUNT"NUMBER(19,2)NOTNULLENABLE,"CREDIT_AMOUNT"NUMBER(19,2)NOTNULLENABLE,"CURRENCY"VARCHAR2(3BYTE)NOTNULLENABLE,"TRANS_DATE"TIMESTAMP(6)NOTNULLENABLE,"SERIAL_NO"NUMBER(10,0)NOTNULLENABLE,"IS_HISTORY"VARCHAR2(5BYTE)NOTNULLENABLE,"EXPLANATION"NVARCHAR2(500),"TRANS_TIME"TIMESTAMP(6),"TRANS_TYPE"NVARCHAR2(30),"USE_CN"NVARCHAR2(255),"BALANCE"NUMBER(19,2),"ACC_NO"VARCHAR2(50BYTE)NOTNULLENABLE,"ACC_NAME"NVARCHAR2(255),"BANK_NAME"NVARCHAR2(255),"THIRD_ACC_NO"VARCHAR2(50BYTE),"THIRD_ACC_NAME"NVARCHAR2(255),"THIRD_BANK_NAME"NVARCHAR2(255),"OPP_ACC_NO"VARCHAR2(101BYTE),"OPP_ACC_NAME"NVARCHAR2(255),"OPP_BANK_NAME"NVARCHAR2(255),"RESERVED_BIZ_FILED"NVARCHAR2(1000),"RESERVED_SYS_FILED"NVARCHAR2(2000),"ACC_TYPE"VARCHAR2(10BYTE),"BANK_ONLY_ID"VARCHAR2(500BYTE));CREATETABLE"T_EBG_DETAILINFO_BK22101902"("ID"VARCHAR2(44BYTE)NOTNULLENABLE,"BANK_VERSION_ID"VARCHAR2(20BYTE)NOTNULLENABLE,"BANK_LOGIN_ID"VARCHAR2(50BYTE)NOTNULLENABLE,"IMPL_CLASS_NAME"VARCHAR2(255BYTE)NOTNULLENABLE,"INSERT_TIME"TIMESTAMP(6)NOTNULLENABLE,"UPDATE_TIME"TIMESTAMP(6),"DEBIT_AMOUNT"NUMBER(19,2)NOTNULLENABLE,"CREDIT_AMOUNT"NUMBER(19,2)NOTNULLENABLE,"CURRENCY"VARCHAR2(3BYTE)NOTNULLENABLE,"TRANS_DATE"TIMESTAMP(6)NOTNULLENABLE,"SERIAL_NO"NUMBER(10,0)NOTNULLENABLE,"IS_HISTORY"VARCHAR2(5BYTE)NOTNULLENABLE,"EXPLANATION"NVARCHAR2(500),"TRANS_TIME"TIMESTAMP(6),"TRANS_TYPE"NVARCHAR2(30),"USE_CN"NVARCHAR2(255),"BALANCE"NUMBER(19,2),"ACC_NO"VARCHAR2(50BYTE)NOTNULLENABLE,"ACC_NAME"NVARCHAR2(255),"BANK_NAME"NVARCHAR2(255),"THIRD_ACC_NO"VARCHAR2(50BYTE),"THIRD_ACC_NAME"NVARCHAR2(255),"THIRD_BANK_NAME"NVARCHAR2(255),"OPP_ACC_NO"VARCHAR2(101BYTE),"OPP_ACC_NAME"NVARCHAR2(255),"OPP_BANK_NAME"NVARCHAR2(255),"RESERVED_BIZ_FILED"NVARCHAR2(1000),"RESERVED_SYS_FILED"NVARCHAR2(2000),"ACC_TYPE"VARCHAR2(10BYTE),"BANK_ONLY_ID"VARCHAR2(500BYTE));CREATETABLE"T_EBG_DETAILINFO_BK22101903"("ID"VARCHAR2(44BYTE)NOTNULLENABLE,"BANK_VERSION_ID"VARCHAR2(20BYTE)NOTNULLENABLE,"BANK_LOGIN_ID"VARCHAR2(50BYTE)NOTNULLENABLE,"IMPL_CLASS_NAME"VARCHAR2(255BYTE)NOTNULLENABLE,"INSERT_TIME"TIMESTAMP(6)NOTNULLENABLE,"UPDATE_TIME"TIMESTAMP(6),"DEBIT_AMOUNT"NUMBER(19,2)NOTNULLENABLE,"CREDIT_AMOUNT"NUMBER(19,2)NOTNULLENABLE,"CURRENCY"VARCHAR2(3BYTE)NOTNULLENABLE,"TRANS_DATE"TIMESTAMP(6)NOTNULLENABLE,"SERIAL_NO"NUMBER(10,0)NOTNULLENABLE,"IS_HISTORY"VARCHAR2(5BYTE)NOTNULLENABLE,"EXPLANATION"NVARCHAR2(500),"TRANS_TIME"TIMESTAMP(6),"TRANS_TYPE"NVARCHAR2(30),"USE_CN"NVARCHAR2(255),"BALANCE"NUMBER(19,2),"ACC_NO"VARCHAR2(50BYTE)NOTNULLENABLE,"ACC_NAME"NVARCHAR2(255),"BANK_NAME"NVARCHAR2(255),"THIRD_ACC_NO"VARCHAR2(50BYTE),"THIRD_ACC_NAME"NVARCHAR2(255),"THIRD_BANK_NAME"NVARCHAR2(255),"OPP_ACC_NO"VARCHAR2(101BYTE),"OPP_ACC_NAME"NVARCHAR2(255),"OPP_BANK_NAME"NVARCHAR2(255),"RESERVED_BIZ_FILED"NVARCHAR2(1000),"RESERVED_SYS_FILED"NVARCHAR2(2000),"ACC_TYPE"VARCHAR2(10BYTE),"BANK_ONLY_ID"VARCHAR2(500BYTE));CREATETABLE"T_EBG_DETAILINFO_BK221021"("ID"VARCHAR2(44BYTE)NOTNULLENABLE,"BANK_VERSION_ID"VARCHAR2(20BYTE)NOTNULLENABLE,"BANK_LOGIN_ID"VARCHAR2(50BYTE)NOTNULLENABLE,"IMPL_CLASS_NAME"VARCHAR2(255BYTE)NOTNULLENABLE,"INSERT_TIME"TIMESTAMP(6)NOTNULLENABLE,"UPDATE_TIME"TIMESTAMP(6),"DEBIT_AMOUNT"NUMBER(19,2)NOTNULLENABLE,"CREDIT_AMOUNT"NUMBER(19,2)NOTNULLENABLE,"CURRENCY"VARCHAR2(3BYTE)NOTNULLENABLE,"TRANS_DATE"TIMESTAMP(6)NOTNULLENABLE,"SERIAL_NO"NUMBER(10,0)NOTNULLENABLE,"IS_HISTORY"VARCHAR2(5BYTE)NOTNULLENABLE,"EXPLANATION"NVARCHAR2(500),"TRANS_TIME"TIMESTAMP(6),"TRANS_TYPE"NVARCHAR2(30),"USE_CN"NVARCHAR2(255),"BALANCE"NUMBER(19,2),"ACC_NO"VARCHAR2(50BYTE)NOTNULLENABLE,"ACC_NAME"NVARCHAR2(255),"BANK_NAME"NVARCHAR2(255),"THIRD_ACC_NO"VARCHAR2(50BYTE),"THIRD_ACC_NAME"NVARCHAR2(255),"THIRD_BANK_NAME"NVARCHAR2(255),"OPP_ACC_NO"VARCHAR2(101BYTE),"OPP_ACC_NAME"NVARCHAR2(255),"OPP_BANK_NAME"NVARCHAR2(255),"RESERVED_BIZ_FILED"NVARCHAR2(1000),"RESERVED_SYS_FILED"NVARCHAR2(2000),"ACC_TYPE"VARCHAR2(10BYTE),"BANK_ONLY_ID"VARCHAR2(500BYTE));CREATETABLE"T_EBG_DETAILINFO_HISTORY"("ID"VARCHAR2(44BYTE)NOTNULLENABLE,"BANK_VERSION_ID"VARCHAR2(20BYTE)NOTNULLENABLE,"BANK_LOGIN_ID"VARCHAR2(50BYTE)NOTNULLENABLE,"IMPL_CLASS_NAME"VARCHAR2(255BYTE)NOTNULLENABLE,"INSERT_TIME"TIMESTAMP(6)NOTNULLENABLE,"UPDATE_TIME"TIMESTAMP(6),"DEBIT_AMOUNT"NUMBER(19,2)NOTNULLENABLE,"CREDIT_AMOUNT"NUMBER(19,2)NOTNULLENABLE,"CURRENCY"VARCHAR2(3BYTE)NOTNULLENABLE,"TRANS_DATE"TIMESTAMP(6)NOTNULLENABLE,"SERIAL_NO"NUMBER(10,0)NOTNULLENABLE,"IS_HISTORY"VARCHAR2(5BYTE)NOTNULLENABLE,"EXPLANATION"NVARCHAR2(500),"TRANS_TIME"TIMESTAMP(6),"TRANS_TYPE"NVARCHAR2(30),"USE_CN"NVARCHAR2(255),"BALANCE"NUMBER(19,2),"ACC_NO"VARCHAR2(50BYTE)NOTNULLENABLE,"ACC_NAME"NVARCHAR2(255),"BANK_NAME"NVARCHAR2(255),"THIRD_ACC_NO"VARCHAR2(50BYTE),"THIRD_ACC_NAME"NVARCHAR2(255),"THIRD_BANK_NAME"NVARCHAR2(255),"OPP_ACC_NO"VARCHAR2(100BYTE),"OPP_ACC_NAME"NVARCHAR2(255),"OPP_BANK_NAME"NVARCHAR2(255),"RESERVED_BIZ_FILED"NVARCHAR2(1000),"RESERVED_SYS_FILED"NVARCHAR2(2000),"ACC_TYPE"VARCHAR2(10BYTE),"BANK_ONLY_ID"VARCHAR2(500BYTE),CONSTRAINT"PK_EBG_DETAILINFO_HISTORY"PRIMARYKEY("ID")ENABLE);CREATEINDEX"INDEX_ACC_NO_DETAIL_HISTORY"ON"T_EBG_DETAILINFO_HISTORY"("ACC_NO");CREATEINDEX"INDEX_TRANS_DATE_HISDETAIL"ON"T_EBG_DETAILINFO_HISTORY"("TRANS_DATE");CREATEINDEX"INDEX_VER_ID_DETAIL_HISTORY"ON"T_EBG_DETAILINFO_HISTORY"("BANK_VERSION_ID");CREATEUNIQUEINDEX"INDX_ONLY_DETAILHIS"ON"T_EBG_DETAILINFO_HISTORY"("BANK_ONLY_ID");CREATETABLE"T_EBG_DETAILINFO_RECORD"("BANK_VERSION_ID"VARCHAR2(20BYTE)NOTNULLENABLE,"BANK_LOGIN_ID"VARCHAR2(50BYTE)NOTNULLENABLE,"ACC_NO"VARCHAR2(50BYTE)NOTNULLENABLE,"UPDATE_TIME"TIMESTAMP(6)NOTNULLENABLE,"START_DATE"TIMESTAMP(6)NOTNULLENABLE,"END_DATE"TIMESTAMP(6)NOTNULLENABLE,CONSTRAINT"PK_EBG_DETAILINFO_RECORD"PRIMARYKEY("BANK_VERSION_ID","BANK_LOGIN_ID","ACC_NO")ENABLE);CREATETABLE"T_EBG_DETAILINFOSYNC"("BANK_VERSION_ID"VARCHAR2(20BYTE)NOTNULLENABLE,"BANK_LOGIN_ID"VARCHAR2(50BYTE)NOTNULLENABLE,"IMPL_CLASS_NAME"VARCHAR2(255BYTE)NOTNULLENABLE,"ACC_NO"VARCHAR2(50BYTE)NOTNULLENABLE,"INSERT_TIME"TIMESTAMP(6)NOTNULLENABLE,"SYNC_START_DATE"TIMESTAMP(6)NOTNULLENABLE,"SYNC_END_DATE"TIMESTAMP(6)NOTNULLENABLE,CONSTRAINT"PK_EBG_DETAILINFOSYNC"PRIMARYKEY("BANK_VERSION_ID","BANK_LOGIN_ID","IMPL_CLASS_NAME","ACC_NO","SYNC_START_DATE","SYNC_END_DATE")ENABLE);CREATETABLE"T_EBG_EBWSS_CONFIG"("CONFIG_KEY"VARCHAR2(50BYTE)NOTNULLENABLE,"CONFIG_VALUE"NCLOBNOTNULLENABLE,"SCHEME_NO"NUMBER(10,0)NOTNULLENABLE,CONSTRAINT"PK_EBG_EBWSS_CONFIG"PRIMARYKEY("CONFIG_KEY")ENABLE);CREATETABLE"T_EBG_ENCRYPTION_HASH"("OBJECT_NAME"VARCHAR2(50BYTE)NOTNULLENABLE,"OBJECT_ID"VARCHAR2(50BYTE)NOTNULLENABLE,"HASH_CODE"VARCHAR2(64BYTE)NOTNULLENABLE,CONSTRAINT"PK_EBG_ENCRYPTION_HASH"PRIMARYKEY("OBJECT_NAME","OBJECT_ID")ENABLE);CREATETABLE"T_EBG_FUNDARRIVALNOTIFICATION"("ID"VARCHAR2(44BYTE)NOTNULLENABLE,"ACC_NO"VARCHAR2(50BYTE),"ACT_NAME"VARCHAR2(255BYTE),"CURR_TYPE"VARCHAR2(10BYTE),"SWIFT_BANK"VARCHAR2(210BYTE),"DETAIL_NO"VARCHAR2(100BYTE),"BUSI_DATE"TIMESTAMP(6),"BUSI_TIME"TIMESTAMP(6),"REV_TRANF"VARCHAR2(50BYTE),"UPD_TRANF"VARCHAR2(50BYTE),"DRCRF"VARCHAR2(5BYTE),"VOUH_TYPE"VARCHAR2(20BYTE),"VOUH_NO"VARCHAR2(100BYTE),"CVOUH_TYPE"VARCHAR2(100BYTE),"CVOUH_NO"VARCHAR2(100BYTE),"AMOUNT"NUMBER(19,2)NOTNULLENABLE,"RECIP_BK_NO"VARCHAR2(100BYTE),"RECIP_BK_NAME"VARCHAR2(100BYTE),"RECIP_ACC_NO"VARCHAR2(50BYTE),"RECIP_NAME"VARCHAR2(255BYTE),"OREG_ACC_NO"VARCHAR2(50BYTE),"OREG_NAME"VARCHAR2(255BYTE),"OREG_BK_NO"VARCHAR2(210BYTE),"STAT_CODE"VARCHAR2(50BYTE),"SETTLE_MODE"VARCHAR2(20BYTE),"SUMMARY"VARCHAR2(210BYTE),"USE_CN"VARCHAR2(50BYTE),"POST_SCRIPT"VARCHAR2(100BYTE),"REF"VARCHAR2(100BYTE),"OREF"VARCHAR2(100BYTE),"SQN"VARCHAR2(50BYTE),"BUS_CODE"VARCHAR2(20BYTE),"EN_SUMMARY"VARCHAR2(100BYTE),"ADD_INFO"VARCHAR2(210BYTE),"ERP_CHK_NO"VARCHAR2(50BYTE),"ERP_EFT_REF"VARCHAR2(50BYTE),"REP_RESERVED1"VARCHAR2(100BYTE),"REP_RESERVED2"VARCHAR2(100BYTE),"REP_RESERVED3"VARCHAR2(100BYTE),"RE...