1.T_EBG_VCPDetailInfoSync（虚拟现金池明细同步记录表）编号字段名字段说明主键类型长度允许空1bank_Version_Id银行版本IDYvarchar20N2bank_Login_Id前置机版本IDYvarchar50N3impl_Class_Name实现类名Yvarchar255N4acc_No帐号Yvarchar50N5insert_Time创建时间Ndatetime8N6sync_Start_Date同步开始日期Ydatetime8N7sync_End_Date同步结束日期Ydatetime8N2.T_EBG_BankLogin（银企结算中心登陆表）编号字段名字段说明主键类型长度允许空1bank_Login_Id前置机版本IDYvarchar50N2bank_Version_Id银行版本IDNvarchar50N3bank_Version_Name银行版本名称Nnvarchar100N4bank_Name银行名称Nnvarchar100N5bank_Login_Count银行账号Nint4N6bank_Login_Name银行户名Nnvarchar200Y3.T_EBG_PayRouter（付款路由表）编号字段名字段说明主键类型长度允许空1idIDYvarchar50N2bank_version_id银行版本IDNvarchar50N3class_name实现类名Nvarchar255Y4match_expression表达式Nvarchar255Y5interface_name银行接口说明Nvarchar255Y4.T_EBG_MBTSRequst（MBTS请求记录表）编号字段名字段说明主键类型长度允许空1method_Name业务方法Nnvarchar100N2request_Seq业务流水号Nvarchar100N3invoke_Time请求时间Ndatetime8N4return_Time响应时间Ndatetime8Y5cost_Time耗时Nint4Y6log_Absolute_Path文件日志路径Nnvarchar510Y7request请求内容Nnvarchar4000N8response响应内容Nnvarchar2000Y9exist_Exception是否异常Nvarchar5N10invoke_id请求IDNvarchar50Y11bank_message_log银行日志路径Nvarchar255Y12details详细信息Nvarchar1000Y13extra_message_log额外信息路径Nvarchar1000Y14acc_no账号Nvarchar50Y15batch_seq_id批次号Nvarchar50Y5.T_EBG_BankLoginConfig（银企结算中心登陆配置表）编号字段名字段说明主键类型长度允许空1bank_Version_Id银行版本IDYvarchar50N2bank_Login_Id前置机版本IDYvarchar50N3bank_Config_Id配置项IDYvarchar50N4bank_Config_Value配置项值Nnvarchar100Y5bank_Config_Name配置项名称Nnvarchar300Y6read_Only是否只读Nvarchar5N7nullable是否允许为空Nvarchar5N6.T_EBG_PaymentInfo（付款信息表）编号字段名字段说明主键类型长度允许空1idIDYvarchar44N2bank_Version_Id银行版本IDNvarchar20N3bank_Login_Id前置机版本IDNvarchar50N4biz_Type业务类型Nvarchar50N5sub_Biz_Type子业务类型Nvarchar50N6impl_Class_Name类名实现Nvarchar255N7package_Key付款数据的部分关键字段的摘要，Nnvarchar510N8total_Count总数量Nint4N9total_Amount总金额Ndecimal9N10batch_Seq_Id批次号Nvarchar100N11detail_Seq_Id流水号Nvarchar100N12detail_Biz_No单笔业务号Nvarchar100N13insert_Batch_Seq插入批次号Nvarchar44N14insert_Time插入时间Ndatetime8N15request_Seq请求流水号Nvarchar44N16request_Time请求时间Ndatetime8N17update_Time更新时间Ndatetime8N18update_Batch_Seq更新批次号Nvarchar44N19update_Operation更新操作Nnvarchar100N20verify_Field校验字段,用于防篡改Nvarchar255N21amount金额Ndecimal9N22currency币别Nvarchar10Y23use_Code用途编码Nnvarchar100N24use_Cn用途Nnvarchar510N25explanation备注Nnvarchar510Y26same_Bank是否同行支付Nvarchar5N27same_City是否同城支付Nvarchar5N28urgent是否加急Nvarchar5N29to_Individual是否对私支付Nvarchar5N30force_Manual是否强制落地Nvarchar5N31fee_Type手续费支付方式Nvarchar50Y32booking_Time预约支付时间Ndatetime8Y33emails需要通知的emailNnvarchar510Y34mobiles需要通知的电话Nnvarchar510Y35acc_No支付账号Nvarchar50N36acc_Name支付户名Nnvarchar510N37bank_Name支付行名Nnvarchar510N38bank_Address支付账户开户行地址Nnvarchar510N39area_Code支付账户开户行地区码Nvarchar50Y40acc_Dept支付账户开户行机构号Nvarchar50Y41acc_Country支付账户开户行所在国家Nnvarchar100Y42acc_Province支付账户开户行所在省份Nnvarchar100Y43acc_City支付账户开户行所在城市Nnvarchar100Y44third_Acc_No第三方账号Nvarchar50Y45third_Acc_Name第三方户名Nnvarchar510Y46third_Bank_Name第三方行名Nnvarchar510Y47third_Bank_Address第三方账户开户行地址Nnvarchar510Y48third_Area_Code第三方账户开户行地区码Nvarchar50Y49third_Acc_Dept第三方账户开户行机构号Nvarchar50Y50income_Acc_No收款账号Nvarchar50N51income_Acc_Name收款户名Nnvarchar510N52income_Bank_Name收款行名Nnvarchar510N53income_Bank_Address收款行开户行地址Nnvarchar510N54income_Area_Code收款行开户行地区码Nvarchar50Y55income_Acc_Dept收款行开户行机构号Nvarchar50Y56income_Swift_Code收款行开户行SWIFT编码Nvarchar50Y57income_Cnaps收款行开户行CNAPS号Nvarchar50Y58income_Country收款行开户行所在国家Nnvarchar100Y59income_Province收款行开户行所在省份Nnvarchar100Y60income_City收款行开户行所在城市Nnvarchar100Y61status状态码。0：尚未处理,还未打包；1：发送失败,需要重发；7：完成打包,准备提交；9：提交中；10：银行处理中；11：交易结果未知；12：交易成功；13：交易失败；14：明细业务编号重复Nint4N62status_Name含义Nnvarchar40Y63status_Msg描述Nnvarchar160Y64bank_Status当前的银行状态Nnvarchar160Y65bank_Msg当前的银行状态描述Nnvarchar510Y66error_Msg当前的业务异常提示Nnvarchar160Y67error_Stack当前的异常详细堆栈Nntext16Y68bak_Status备份的提交完成时的的内部状态Nint4Y69bak_Status_Name含义Nnvarchar40Y70bak_Status_Msg描述Nnvarchar160Y71bak_bank_Status提交完成时的的银行状态Nnvarchar160Y72bak_bank_Msg提交完成时的的银行状态描述Nnvarchar510Y73bak_Error_Msg提交完成时的的业务异常提示Nnvarchar160Y74bak_Error_Stack提交完成时的的异常详细堆栈Nntext16Y75package_Time打包时间Ndatetime8Y76bank_Batch_Seq_Id银行批次流水号Nvarchar44N77bank_Detail_Seq_Id银行明细流水号Nvarchar44Y78bank_Serial_No银行明细顺序号Nvarchar44Y79last_Submit_Time最后一次尝试提交的时间Ndatetime8Y80last_Submit_Request_Seq最后一次尝试提交的请求流水Nvarchar44N81submit_Count尝试提交的总次数Nint4Y82submit_Success_Time成功提交支付请求的时间Ndatetime8Y83last_Sync_Time最后一次尝试同步的时间Ndatetime8Y84last_Sync_Request_Seq最后一次尝试同步的请求流水Nvarchar44N85sync_Count尝试同步的总次数Nint4Y86pay_Finish_Time成功同步到最终结果的时间Ndatetime8Y87to_Give_Up放弃处理Nvarchar5N88reserved_Biz_Filed预留字段Nntext16Y89reserved_Sys_Filed预留字段Nntext16Y90reserved_Filed_1预留字段Nvarchar255Y91reserved_Filed_2预留字段Nvarchar255Y92reserved_Filed_3预留字段Nvarchar255Y93reserved_Filed_4预留字段Nvarchar255Y94reserved_Filed_5预留字段Nvarchar255Y95reserved_Filed_6预留字段Nvarchar255Y96reserved_Filed_7预留字段Nvarchar255Y97reserved_Filed_8预留字段Nvarchar255Y98ebg_Mark_IdNvarchar100Y99payer_FeeType付款费用类型Nvarchar10Y100payer_FeeAccNo费用账号Nvarchar50Y101payer_FeeCurrency费用币别Nvarchar10Y102exchange_Rate汇率Nvarchar10Y103actual_Amount实际金额Ndecimal9Y104payee_BankCode费用行编码Nvarchar20Y105transaction_Remarks人民币交易种类Nvarchar100Y106proxy_AccNo代理帐号Nvarchar50Y107proxy_AccName代理户名Nvarchar200Y108proxy_BankCountry代理行国家Nvarchar10Y109proxy_BankArea代理行区域Nvarchar200Y110proxy_BankSwiftCode代理行国家编码Nvarchar50Y111proxy_BankName代理行名Nvarchar200Y112proxy_BankAddress代理行地址Nvarchar200Y113proxy_FeeType代理行费用类型Nvarchar10Y114proxy_FeeCurrency代理行费用币别Nvarchar10Y115pay_Currency付款币别Nvarchar10Y116exContractNvarchar200Y117priority_pay付款优先级Nint4Y118income_Address付款方地址Nvarchar200Y119income_Bank_LocalClearCode本地清算行号Nvarchar50Y120income_Bank_LocalClearBCode本地清算分行代码Nvarchar50Y121income_Bank_LocalClearBSCode分行子代码Nvarchar50Y122third_Address第三方地址Nvarchar255Y123payment_Method付款种类Nvarchar10Y124service_Level服务等级Nvarchar10Y125delivery_Method发送方式Nvarchar10Y126cheque_Type支票类型Nvarchar10YT_EBG_Bank_Currency（银行币别转换表）编号字段名字段说明主键类型长度允许空1iso_Code国家编码Yvarchar20N2bank_Version_Id银行版本IDYvarchar20N3bank_Currency银行币别编码Nnvarchar40N7.T_EBG_BASE_AreaCode（区域编码表）编号字段名字段说明主键类型长度允许空1areaID区域IDYint4N2areaCode区域编码Nint4Y3areaName区域名称Nvarchar100Y4areaLevel区域级别Nint4Y5cityID城市IDNint4Y6provinceID省份IDNint4Y8.T_EBG_BASE_BankCode（银行编码表）编号字段名字段说明主键类型长度允许空1bankID银行IDYint4N2bankCode银行编码Nvarchar6Y3bankName银行名称Nvarchar100Y4bankType银行类型Nvarchar50Y9.T_EBG_Bank_Request_Log（银行请求日志表）编号字段名字段说明主键类型长度允许空1idIDYvarchar16N2request_seq_id请求流水号Nvarchar50Y3bank_request_seq业务流水号Nvarchar50Y4bank_response_seqNvarchar20Y5bank_ralation_request_seq付款流水号Nvarchar100Y6existException是否存在异常Nvarchar8Y7bank_version_id银行版本IDNvarchar20Y8bank_login_id银行前置机配置IDNvarchar20Y9biz_name业务名称Nvarchar20Y10request_lock_time请求锁时间Ndatetime8Y11lock_time锁时间Ndatetime8Y12begin_send_time开始发送时间Ndatetime8Y13read_full_time完全读取时间Ndatetime8Y14release_time释放时间Ndatetime8Y15cost持有时间Nint4Y16batch_seq_id批次号Nvarchar255Y17acc_no付款账号Nvarchar24Y18log_path日志路径Nvarchar255Y19details详细信息Nvarchar1000Y10.T_EBG_BASE_BankDetail（银行信息表）编号字段名字段说明主键类型长度允许空1bankCNAPS联行号Yvarchar14N2bankCode银行编码Nvarchar6Y3areaID区域IDNint4Y4bankName银行名称Nvarchar100Y5bankAddress银行地址Nvarchar500Y6clearingBankId清算行IDNint4Y7clearingBankCode清算行编码Nvarchar14Y11.T_EBG_BASE_CityCode（城市编码表）编号字段名字段说明主键类型长度允许空1cityID城市IDYint4N2cityName城市名称Nvarchar100Y3provinceID省份IDNint4Y12.T_EBG_BASE_ClearingBank（清算银行表）编号字段名字段说明主键类型长度允许空1IDIDYint4N2BANK_CODE银行编码Nvarchar14Y3BANK_NAME银行名称Nvarchar100Y4BANK_KEYWORDS关键字Nvarchar50Y5BANK_TYPE银行类型Nvarchar255Y13.T_EBG_BASE_ProvinceCode（省份编码表）编号字段名字段说明主键类型长度允许空1provinceID省份IDYint4N2provinceName省份名称Nvarchar100Y3provinceCode省份编码Nint4Y14.T_EBG_BOCOM_DC_BusiNo（交行直连代发的协议编号表）编号字段名字段说明主键类型长度允许空1acc_No帐号Yvarchar50N2busi_Type协议类型Yvarchar10N3busi_No协议号Nvarchar50N15.T_EBG_BOCOM_DC_busi_No（交行直连代发的协议编号表）编号字段名字段说明主键类型长度允许空1acc_No帐号Yvarchar50N2busi_Type协议类型Yvarchar10N3busi_No协议号Nvarchar50N16.T_EBG_Bank_CNAPS（银行行名行号表）编号字段名字段说明主键类型长度允许空1bankCNAPS行号Ynvarchar40N2bankName银行名称Nnvarchar100N3province省份Nnvarchar100Y4city城市Nnvarchar200Y5bankDetailNnvarchar400N6remark备注Nnvarchar1000Y17.T_EBG_SUPPORT_BANKS（银行名称表）编号字段名字段说明主键类型长度允许空1sequenceIDIDYnvarchar20N2bankName银行名称Nnvarchar100N3remark备注Nnvarchar1000Y4bankCode银行编码Nnvarchar20Y18.T_EBG_SUPPORT_PROVINCES（省份表）编号字段名字段说明主键类型长度允许空1sequenceIDIDYnvarchar20N2province省份Nnvarchar20Y3remark备注Nnvarchar1000Y19.T_EBG_SUPPORT_CITYS（城市表）编号字段名字段说明主键类型长度允许空1sequenceIDIDYnvarchar20N2provinceID省份IDNnvarchar20Y3city城市Nnvarchar200Y4remark备注Nnvarchar1000Y5areaCode区域编码Nint4Y20.T_EBG_BankCNAPS_Update（行名行号更新记录表）编号字段名字段说明主键类型长度允许空1sequenceIDIDYnvarchar20N2insertTime插入时间Ndatetime8Y3description描述Nnvarchar100Y4totalSize总大小Nint4Y5remark备注Nnvarchar1000Y21.T_EBG_Bank_CNAPS_Temp1（行名行号更新临时表）编号字段名字段说明主键类型长度允许空1bankCNAPS行号Ynvarchar40N2bankName银行名称Nnvarchar100N3province省份Nnvarchar100Y4city城市Nnvarchar200Y5bankDetailNnvarchar400N6remark备注Nnvarchar1000Y22.T_EBG_CreditDealReceivedInfo（信用证收票信息表）目前已不使用编号字段名字段说明主键类型长度允许空1idIDYvarchar50N2bank_Version_Id银行版本IdNvarchar20N3bank_Login_Id前置机版本IDNvarchar50N4biz_Type业务类型Nvarchar50N5sub_Biz_Type业务子类型Nvarchar50N6impl_Class_Name实现类名Nvarchar255N7package_Key付款数据的部分关键字段的摘要，Nvarchar255N8batchSeqId批次流水号Nvarchar50N9detailSeqId单笔流水号Nvarchar50N10detailBizNo单笔业务号Nvarchar50Y11insertBatchSeq插入批次号Nvarchar50Y12insertTime插入时间Ndatetime8N13requestSeq请求批次号Nvarchar50Y14requestTime请求时间Ndatetime8Y15updateTime更新时间Ndatetime8Y16updateBatchSeq更新批次号Nvarchar50Y17updateOperation更新操作Nvarchar50Y18verifyField验签字段Nvarchar255Y19status状态码Nint4Y20statusName状态名Nvarchar20Y21statusMsg状态信息Nvarchar50Y22bankStatus银行状态Nvarchar20Y23bankMsg状态信息Nvarchar255Y24errorMsg错误信息Nvarchar250Y25bakStatus备份状态码Nvarchar50Y26bakStatusName备份状态名Nvarchar50Y27bakStatusMsg备份状态信息Nvarchar50Y28bakBankStatus备份银行状态码Nvarchar50Y29bakBankMsg备份银行状态信息Nvarchar50Y30bakErrorMsg备份错误信息Nvarchar50Y31packageTime打包时间Ndatetime8Y32bankBatchSeqId银行批次流水号Nvarchar50Y33bankDetailSeqId银行单笔流水号Nvarchar50Y34bankSerialNo银行流水号Nvarchar50Y35lastSubmitTime上次提交时间Ndatetime8Y36lastSubmitRequestSeq上次请求序列号Nvarchar50Y37submitCount提交次数Nint4N38submitSuccessTime提交成功时间Ndatetime8Y39lastSyncTimeNdatetime8Y40lastSyncRequestSeqNvarchar50Y41syncCountNint4Y42finishTimeNdatetime8Y43accNoNvarchar50N44creditNoNvarchar20Y45branchNoNvarchar255Y46receivedCreditNumberNvarchar50Y47referenceNumNvarchar50Y48contractNoNvarchar50Y49receivedDateNdatetime8Y50amountNvarchar50Y51claimAmountNvarchar50Y52submitBankNvarchar255Y53applicantNvarchar255Y54beneficiaryNvarchar255Y55noticedDateNdatetime8Y56systemBuisnessNoNvarchar250Y57receivedNoticeDateNdatetime8Y58applicationItemsNvarchar50Y59rejectResultNvarchar50Y60noteNvarchar255Y61applyDateNdatetime8Y62rejectDateNdatetime8Y63rejectAmountNvarchar50Y64expireDateNdatetime8Y65acceptDateNdatetime8Y66acceptAmountNvarchar50Y67notifyDateNdatetime8Y68payTypeNvarchar50Y69payDateNdatetime8Y70payAmountNvarchar50Y71dealTypeNvarchar50Y72dealSubTypeNvarchar50Y73queryInterfaceTypeNint4Y74toGiveUpNvarchar50Y75useCodeNvarchar50Y76useCnNvarchar50Y77mobileNvarchar50Y78emailNvarchar50Y79ebSeqIdNvarchar50Y80ebStatusNvarchar50Y81ebStatusMsgNvarchar150Y82dealModeNvarchar50Y83isGenPayNvarchar20Y84isGenLoanReqNvarchar20Y85isAcceptNvarchar20Y86isRefuseNvarchar20Y87billStateNvarchar20Y88creditOpenIdNvarchar50Y89PlanPayDateNdatetime8Y90DraftDayNvarchar20Y91reserved_Biz_FiledNtext16Y92reserved_Sys_FiledNtext16Y93reserved_Filed_1Nvarchar255Y94reserved_Filed_2Nvarchar255Y95reserved_Filed_3Nvarchar255Y96reserved_Filed_4Nvarchar255Y97reserved_Filed_5Nvarchar255Y98reserved_Filed_6Nvarchar255Y99reserved_Filed_7Nvarchar255Y100reserved_Filed_8Nvarchar255Y23.T_EBG_CreditModifyInfo（信用证修改信息表）目前已不使用编号字段名字段说明主键类型长度允许空1idYvarchar50N2bank_Version_IdNvarchar20N3bank_Login_IdNvarchar50N4biz_TypeNvarchar50N5sub_Biz_TypeNvarchar50N6impl_Class_NameNvarchar255N7package_KeyNvarchar255N8batchSeqIdNvarchar50N9detailSeqIdNvarchar50N10detailBizNoNvarchar50Y11insertBatchSeqNvarchar50Y12insertTimeNdatetime8N13requestSeqNvarchar50Y14requestTimeNdatetime8Y15updateTimeNdatetime8Y16updateBatchSeqNvarchar50Y17updateOperationNvarchar50Y18verifyFieldNvarchar255Y19statusNint4Y20statusNameNvarchar20Y21statusMsgNvarchar250Y22bankStatusNvarchar50Y23bankMsgNvarchar250Y24errorMsgNvarchar150Y25bakStatusNvarchar250Y26bakStatusNameNvarchar250Y27bakStatusMsgNvarchar250Y28bakBankStatusNvarchar250Y29bakBankMsgNvarchar250Y30bakErrorMsgNvarchar250Y31packageTimeNdatetime8Y32bankBatchSeqIdNvarchar50Y33bankDetailSeqIdNvarchar50Y34bankSerialNoNvarchar50Y35lastSubmitTimeNdatetime8Y36lastSubmitRequestSeqNvarchar50Y37submitCountNint4Y38submitSuccessTimeNdatetime8Y39lastSyncTimeNdatetime8Y40lastSyncRequestSeqNvarchar50Y41syncCountNint4Y42finishTimeNdatetime8Y43accNoNvarchar50N44branchNoNvarchar255N45creditNoNvarchar50N46applicantNvarchar255N47beneficiaryNvarchar255N48applyItemsNtext16N49ccommentNvarchar255Y50applyDateNdatetime8N51sendReferenceNvarchar50Y52receiverReferenceNvarchar50Y53issuingBankReferenceNvarchar50Y54amendmentNumberNvarchar50Y55amendmentDateNdatetime8Y56issueDateNdatetime8Y57newExpiryDateNdatetime8Y58increaseCreditAmountNvarchar50Y59decreaseCreditAmountNvarchar50Y60newCreditAmountNvarchar50Y61percentageAmountToleranceNvarchar50Y62maximumCreditAmountNvarchar50Y63additionalAmountCoveredNvarchar50Y64placeOfReceiptNvarchar255Y65portOfLoadingNvarchar255Y66portOfDischargeNvarchar255Y67placeOfDeliveryNvarchar255Y68newLatestShipmentDateNdatetime8Y69shipmentPeriodNvarchar150Y70narrativeNvarchar255Y71senderToReceiverInfomationNvarchar255Y72systemBuisnessNoNvarchar50Y73receivedNotifyDateTimeNdatetime8Y74useCodeNvarchar50Y75useCnNvarchar50Y76mobileNvarchar50Y77emailNvarchar50Y78ebSeqIdNvarchar50Y79ebStatusNvarchar50Y80ebStatusMsgNvarchar150Y81creditOpenIdNvarchar250Y82modifyReasonNvarchar222Y83queryInterfaceTypeNint4Y84toGiveUpNvarchar20Y85reserved_Biz_FiledNtext16Y86reserved_Sys_FiledNtext16Y87reserved_Filed_1Nvarchar255Y88reserved_Filed_2Nvarchar255Y89reserved_Filed_3Nvarchar255Y90reserved_Filed_4Nvarchar255Y91reserved_Filed_5Nvarchar255Y92reserved_Filed_6Nvarchar255Y93reserved_Filed_7Nvarchar255Y94reserved_Filed_8Nvarchar255Y24.T_EBG_CreditOpenInfo（信用证开票信息表）目前已不使用编号字段名字段说明主键类型长度允许空1idYvarchar50N2bank_Version_IdNvarchar20N3bank_Login_IdNvarchar50N4biz_TypeNvarchar50N5sub_Biz_TypeNvarchar50N6impl_Class_NameNvarchar255N7package_KeyNvarchar255N8batchSeqIdNvarchar50N9detailSeqIdNvarchar50N10detailBizNoNvarchar50Y11insertBatchSeqNvarchar50Y12insertTimeNdatetime8N13requestSeqNvarchar50Y14requestTimeNdatetime8Y15updateTimeNdatetime8Y16updateBatchSeqNvarchar50Y17updateOperationNvarchar50Y18verifyFieldNvarchar255Y19statusNint4Y20statusNameNvarchar50Y21statusMsgNvarchar250Y22bankStatusNvarchar250Y23bankMsgNvarchar255Y24errorMsgNvarchar250Y25bakStatusNvarchar250Y26bakStatusNameNvarchar250Y27bakStatusMsgNvarchar250Y28bakBankStatusNvarchar250Y29bakBankMsgNvarchar250Y30bakErrorMsgNvarchar250Y31packageTimeNdatetime8Y32bankBatchSeqIdNvarchar50Y33bankDetailSeqIdNvarchar50Y34bankSerialNoNvarchar50Y35lastSubmitTimeNdatetime8Y36lastSubmitRequestSeqNvarchar50Y37submitCountNint4N38submitSuccessTimeNdatetime8Y39lastSyncTimeNdatetime8Y40lastSyncRequestSeqNvarchar50Y41syncCountNint4Y42finishTimeNdatetime8Y43creditTypeNvarchar50N44nominalCurrencyNvarchar50N45nominalAmountNvarchar50N46initialCodeNvarchar50N47issuedDateNdatetime8N48latestShipmentDateNdatetime8Y49expiringDateNdatetime8N50expiryPlaceNvarchar150N51tenorsNvarchar150N52applicableRulesNvarchar150N53contractNoNvarchar50N54contractAmountNvarchar50N55applicantNvarchar200N56advisingBankNvarchar200N57beneficiaryNvarchar200N58confirmInstructionNvarchar50N59applicantBankNvarchar200Y60otherAdvisingBankNvarchar200Y61availableWithBankNvarchar200N62availableByNvarchar200N63draftsAtNvarchar200Y64draweeNvarchar200Y65defPaymentDetailsNvarchar255Y66mixedPaymentDetailsNvarchar255Y67presentationPeriodNvarchar200Y68detailsOfChargesNvarchar255Y69countryCodeNvarchar50N70patialShipmentNvarchar20Y71transshipmentNvarchar20Y72placeOfReceiptNvarchar255Y73portOfLoadingNvarchar255Y74portOfDischargeNvarchar255Y75finalDestinationNvarchar255Y76shipmentPeriodNtext16Y77goodsNtext16N78documentsNtext16N79additionalConditionsNtext16N80ccommentNvarchar255Y81creditReferenceNoNvarchar50Y82preadviceDateNdatetime8Y83goodsSecondNtext16Y84documentsSecondNtext16Y85additionalConditionsSecondNtext16Y86reimbursementBankNvarchar255Y87payBankNtext16Y88toReceiverInfoNvarchar255Y89correspondentBankNvarchar255Y90applicationNoNvarchar150Y91systemBuisnessNoNvarchar150Y92dateOfReceivedNotifyNvarchar50Y93ebSeqIdNvarchar50Y94ebStatusNvarchar50Y95ebStatusMsgNvarchar150Y96queryInterfaceTypeNint4N97lastQueryDateTimeNdatetime8Y98toGiveUpNvarchar10Y99modifyFlagNvarchar10Y100modifyReferenceNoNvarchar50Y101finishDateNdatetime8Y102isForwardNvarchar20Y103blockFlowTypeNvarchar100Y104accountantNvarchar100Y105creditPercentageNvarchar100Y106usedCreditAmtNvarchar100Y107ntTypeNvarchar50Y108marginRateNvarchar50Y109limitMarginNvarchar50Y110marginCurrencyNvarchar20Y111marginExRateNvarchar50Y112marginExNvarchar50Y113marginAcctNvarchar50Y114payBankAcctNvarchar50Y115marginAlgorithmNvarchar150Y116cashierNvarchar150Y117isGenRepaymentNvarchar20Y118departmentNvarchar50Y119projectNvarchar50Y120ltterHandlerNvarchar50Y121babNumberNvarchar50Y122hxdNumberNvarchar50Y123transportModeNvarchar50Y124balanceNvarchar50Y125localCurExRateNvarchar50Y126reserved_Biz_FiledNtext16Y127reserved_Sys_FiledNtext16Y128reserved_Filed_1Nvarchar255Y129reserved_Filed_2Nvarchar255Y130reserved_Filed_3Nvarchar255Y131reserved_Filed_4Nvarchar255Y132reserved_Filed_5Nvarchar255Y133reserved_Filed_6Nvarchar255Y134reserved_Filed_7Nvarchar255Y135reserved_Filed_8Nvarchar255Y25.T_EBG_DetailInfo（明细表）编号字段名字段说明主键类型长度允许空1idIDYvarchar44N2bank_Version_Id银行版本IDNvarchar20N3bank_Login_Id前置机版本IDNvarchar50N4impl_Class_Name实现类名Nvarchar255N5insert_Time插入时间Ndatetime8N6update_Time更新时间Ndatetime8Y7debit_Amount付款金额Ndecimal9N8credit_Amount收款金额Ndecimal9N9currency币别Nvarchar3N10trans_Date交易时间Ndatetime8N11serial_No顺序号Nint4N12is_History是否历史明细Nvarchar5N13explanation备注Nnvarchar1000Y14trans_Time交易时间Ndatetime8Y15trans_Type类型autotransup自动归集产生,autotransdown自动下划产生,normal普通交易产生Nnvarchar60Y16use_CN用途Nnvarchar510Y17balance余额Ndecimal9Y18acc_No支付帐号Nvarchar50N19acc_Name支付户名Nnvarchar510Y20bank_Name支付行名Nnvarchar510Y21third_Acc_No第三方账号Nvarchar50Y22third_Acc_Name第三方户名Nnvarchar510Y23third_Bank_Name第三方行名Nnvarchar510Y24opp_Acc_No对方账号Nvarchar50Y25opp_Acc_Name对方户名Nnvarchar510Y26opp_Bank_Name对方行名Nnvarchar510Y27reserved_Biz_Filed预留字段Nnvarchar2000Y28reserved_Sys_Filed预留字段Nnvarchar2000Y29acc_TypeNvarchar10Y26.T_EBG_DetailInfoSync（历史明细同步记录表）编号字段名字段说明主键类型长度允许空1bank_Version_Id银行版本IDYvarchar20N2bank_Login_Id前置机版本IDYvarchar50N3impl_Class_Name实现类名Yvarchar255N4acc_No付款账号Yvarchar50N5insert_Time插入时间Ndatetime8N6sync_Start_Date同步开始日期Ydatetime8N7sync_End_Date同步结束日期Ydatetime8N27.T_EBG_DetailInfo_History（历史明细表）编号字段名字段说明主键类型长度允许空1idIDYvarchar44N2bank_Version_Id银行版本IDNvarchar20N3bank_Login_Id前置机版本IDNvarchar50N4impl_Class_Name实现类名Nvarchar255N5insert_Time插入时间Ndatetime8N6update_Time更新时间Ndatetime8Y7debit_Amount付款金额Ndecimal9N8credit_Amount收款金额Ndecimal9N9currency币别Nvarchar3N10trans_Date交易时间Ndatetime8N11serial_No顺序号Nint4N12is_History是否历史明细Nvarchar5N13explanation备注Nnvarchar1000Y14trans_Time交易时间Ndatetime8Y15trans_Type类型autotransup自动归集产生,autotransdown自动下划产生,normal普通交易产生Nnvarchar60Y16use_CN用途Nnvarchar510Y17balance余额Ndecimal9Y18acc_No支付帐号Nvarchar50N19acc_Name支付户名Nnvarchar510Y20bank_Name支付行名Nnvarchar510Y21third_Acc_No第三方账号Nvarchar50Y22third_Acc_Name第三方户名Nnvarchar510Y23third_Bank_Name第三方行名Nnvarchar510Y24opp_Acc_No对方账号Nvarchar50Y25opp_Acc_Name对方户名Nnvarchar510Y26opp_Bank_Name对方行名Nnvarchar510Y27reserved_Biz_Filed预留字段Nnvarchar2000Y28reserved_Sys_Filed预留字段Nnvarchar2000Y29acc_TypeNvarchar10Y28.T_EBG_DetailInfo_Record（明细记录表）编号字段名字段说明主键类型长度允许空1bank_Version_Id银行版本IDYvarchar20N2bank_Login_Id前置机版本IDYvarchar50N3acc_No付款账号Yvarchar50N4update_Time更新时间Ndatetime8N5start_Date开始日期Ndatetime8N6end_Date结束日期Ndatetime8N29.T_EBG_EBWSS_Config（webservice安全配置表）编号字段名字段说明主键类型长度允许空1config_Key配置项keyYvarchar50N2config_Value配置项valueNntext16N3scheme_NoNint4N30.T_EBG_Encryption_Hash（敏感信息加密信息表）编号字段名字段说明主键类型长度允许空1object_name对象名Yvarchar50N2object_id对象IDYvarchar50N3hash_code哈希值Nvarchar64N31.T_EBG_FundArrivalNotification（到账通知表）编号字段名字段说明主键类型长度允许空1idIDYvarchar44N2acc_No账号Nvarchar50Y3act_Name户名Nvarchar255Y4curr_Type币别Nvarchar10Y5swift_Bank国际行号Nvarchar210Y6detail_No交易序号Nvarchar100Y7busi_Date入账日期Ndatetime8Y8busi_Time入账时间Ndatetime8Y9rev_Tranf正反交易标志Nvarchar50Y10upd_Tranf冲正标志Nvarchar50Y11drcrf借贷标志Nvarchar5Y12vouh_Type凭证种类Nvarchar20Y13vouh_No凭证号Nvarchar100Y14cvouh_Type贷方凭证种类Nvarchar100Y15cvouh_No贷方凭证号Nvarchar100Y16amount发生额Ndecimal9N17recip_Bk_No对方行号Nvarchar100Y18recip_Bk_Name对方行名Nvarchar100Y19recip_Acc_No对方账号Nvarchar50Y20recip_Name对方户名Nvarchar255Y21oreg_Acc_No对方入账账号Nvarchar50Y22oreg_Name对方入账户名Nvarchar255Y23oreg_Bk_No对方入账行号Nvarchar210Y24stat_Code外汇统计代码Nvarchar50Y25settle_Mode外汇结算方式Nvarchar20Y26summary摘要Nvarchar210Y27use_CN用途Nvarchar50Y28post_Script附言Nvarchar100Y29ref业务编号Nvarchar100Y30oref相关业务编号Nvarchar100Y31sqn流水号Nvarchar50Y32bus_Code业务代码Nvarchar20Y33en_Summary英文备注Nvarchar100Y34add_Info附加信息Nvarchar210Y35ERP_chk_noERP支票号Nvarchar50Y36ERP_eft_Ref付款批次Nvarchar50Y37rep_Reserved1响应备用字段1Nvarchar100Y38rep_Reserved2响应备用字段2Nvarchar100Y39rep_Reserved3响应备用字段3Nvarchar100Y40rep_Reserved4响应备用字段4Nvarchar100Y41value_Day起息日Ndatetime8Y42cash_Sign现金标志Nvarchar20Y43bus_TypeNvarchar20Y44read_Status回单业务类型Nint4N45create_Time插入时间Ndatetime8N46update_Time更新时间Ndatetime8N32.T_EBG_IsoCurrency（标准币别表）编号字段名字段说明主键类型长度允许空1iso_Code国家编码Yvarchar20N2currency_Name币别名称Nnvarchar200N33.T_EBG_Iso_Currency（标准币别表）编号字段名字段说明主键类型长度允许空1iso_Code国家编码Yvarchar20N2currency_Name币别名称Nnvarchar200N34.T_EBG_LinkPaymentInfo（联动支付表）编号字段名字段说明主键类型长度允许空1idIDYvarchar50N2batch_Seq_ID批次号Nvarchar100N3parent_Acnt母账号Nvarchar50N4child_Acnt_1子账号1Nvarchar50N5child_Acnt_2子账号2Nvarchar50Y6child_Acnt_3子账号3Nvarchar50Y7child_Acnt_4子账号4Nvarchar50Y8child_Acnt_5子账号5Nvarchar50Y9batch_Biz_No业务批次号Nvarchar50Y10total_Count总笔数Nvarchar50N11total_Amount总金额Nvarchar50N12fee_TypeNvarchar50Y13detail_Seq_ID单笔业务号Nvarchar100N14detail_Biz_No单笔批次号Nvarchar100N15payee_Acc_No收款账号Nvarchar50N16payee_Acc_Name收款户名Nvarchar255N17payee_Type收款类型Nvarchar20Y18payee_Bank_Name收款银行Nvarchar255Y19payee_Bank_Addr收款行地址Nvarchar255Y20payee_Country收款国家Nvarchar50Y21payee_Province收款省份Nvarchar50Y22payee_City收款城市Nvarchar50Y23payee_Area_Code收款地区编码Nvarchar50Y24payee_Cnaps_Code收款联行号Nvarchar50Y25payee_Swift_Code收款国际代码Nvarchar50Y26amount发生额Nvarchar50N27booking_Date预约时间Nvarchar20Y28urgent是否紧急Nvarchar5Y29force_Manual是否手工操作Nvarchar5Y30use_Code用途代码Nvarchar50Y31use_msg用途信息Nvarchar255Y32desc_msg备注Nvarchar255Y33mobile手机号码Nvarchar255Y34email邮箱Nvarchar255Y35verify_Field验签字段Nvarchar255Y36eb_Seq_ID流水号Nvarchar44Y37eb_Status状态码Nvarchar50Y38eb_Status_Msg状态信息Nnvarchar1000Y39bank_Batch_Seq_ID批次号Nvarchar100Y40bank_Status银行状态码Nnvarchar160Y41bank_Status_Msg银行状态信息Nnvarchar510Y42biz_Type业务类型Nvarchar50N43sub_Biz_Type子业务类型Nvarchar50N44currency币别Nvarchar3N45insert_Batch_Seq批次号Nvarchar44N46reserved_1备用字段1Nvarchar255Y47reserved_2备用字段2Nvarchar255Y48reserved_3备用字段3Nvarchar255Y49reserved_4备用字段4Nvarchar255Y50reserved_5备用字段5Nvarchar255Y51reserved_6备用字段6Nvarchar255Y52reserved_7备用字段7Nvarchar255Y53reserved_8备用字段8Nvarchar255Y54create_time创建时间Ndatetime8Y55update_time更新时间Ndatetime8Y35.T_EBG_Logging（预警日志表）编号字段名字段说明主键类型长度允许空1FCREATORIDNvarchar44Y2FCREATETIMENdatetime8Y3FLASTUPDATEUSERIDNvarchar44Y4FLASTUPDATETIMENdatetime8Y5FCONTROLUNITIDNvarchar44Y6FNUMBERNnvarchar160Y7FBIZDATENdatetime8Y8FHANDLERIDNvarchar44Y9FDESCRIPTIONNnvarchar160Y10FHASEFFECTEDNint4Y11FAUDITORIDNvarchar44Y12FSOURCEBILLIDNnvarchar160Y13FSOURCEFUNCTIONNnvarchar160Y14FIDNvarchar44N15FFIVOUCHEREDNint4Y16FTHREADNnvarchar100Y17FCATALOGNnvarchar400Y18FLEVELNnvarchar20Y19FLINENnvarchar40Y20FTIMENdatetime8Y21FMODULENnvarchar400Y22FBIZTYPENnvarchar100Y23FSTATUSNnvarchar100Y24FFLAGNint4Y25FATTR1Nnvarchar510Y26FATTR2Nnvarchar510Y27FA...
