國(guó)際結(jié)算數(shù)據(jù)字典_第1頁(yè)
國(guó)際結(jié)算數(shù)據(jù)字典_第2頁(yè)
國(guó)際結(jié)算數(shù)據(jù)字典_第3頁(yè)
國(guó)際結(jié)算數(shù)據(jù)字典_第4頁(yè)
國(guó)際結(jié)算數(shù)據(jù)字典_第5頁(yè)
已閱讀5頁(yè),還剩17頁(yè)未讀, 繼續(xù)免費(fèi)閱讀

下載本文檔

版權(quán)說(shuō)明:本文檔由用戶提供并上傳,收益歸屬內(nèi)容提供方,若內(nèi)容存在侵權(quán),請(qǐng)進(jìn)行舉報(bào)或認(rèn)領(lǐng)

文檔簡(jiǎn)介

1、1TRS-復(fù)核信息bchkeyThebranchdothetransction機(jī)構(gòu)唯一標(biāo)志VARCHAR9INR唯一IDVARCHAR8SSNINRSessionIDVARCHAR8DATTIM簽名時(shí)間TIMESTAMPFLG授權(quán)標(biāo)志VARCHAR1USR用戶IDVARCHAR12OBJTYP關(guān)聯(lián)交易VARCHAR6OBJINR關(guān)聯(lián)交易inrVARCHAR8SIGIDX經(jīng)辦和復(fù)核狀態(tài)VARCHAR5ETYEXTKEY實(shí)體VARCHAR8NameHelpVARCHARDescriptionDateTypeLenCodetablePTS-PartyperContract角色信息NameDescri

2、ptionDatatypeLenCodetablebchkeyThebranchdothetransction機(jī)構(gòu)唯一標(biāo)志VARCHAR9INRInternalUniqueIDofContractparty流水號(hào)VARCHAR8OBJTYPObjectType業(yè)務(wù)品種(關(guān)聯(lián)業(yè)務(wù)表)VARCHAR6CBOTXTOBJINRObjectINR業(yè)務(wù)流水號(hào)VARCHAR8ROLRoleofAddress角色種類VARCHAR3ROLALLPTAINRAddress(optional)關(guān)聯(lián)地址的INRVARCHAR8PTYINRParty(optional)關(guān)聯(lián)當(dāng)事人INRVARCHAR8EXTKEYE

3、xternalKeyofAddress角色地址編號(hào)VARCHAR16ADRBLKAddressBlock地址信息Block144REFRefereneeforAddress(optional)地址4卄VARCHAR16NAMNameofParty當(dāng)事人基本名稱VARCHAR40OWNREFRefereneeofContract+Role業(yè)務(wù)編號(hào)VARCHAR20DFTCUR號(hào)DefaultCurrency默認(rèn)貨幣種類VARCHAR3CURTXTDFTDSPDefaultDisposition默認(rèn)的角色等級(jí)VARCHAR3DFTACTDefaultAccount默認(rèn)賬戶種類VARCHAR34DF

4、TFEECURDefaultfeecurrency默認(rèn)費(fèi)用使用的VARCHAR3CURTXT貨幣種類DFTACTPTAINRDefaultAddresstoSearchAccount默認(rèn)帳戶VARCHAR8GLGGRPFLGGroupingruleofamounts費(fèi)用合計(jì)方式標(biāo)志VARCHAR3EmbeddedEXTACTExternalaccount帳號(hào)VARCHAR34VERVersion版本VARCHAR4ISSBANINF銀行機(jī)構(gòu)信息VARCHAR40BANKNO銀行碼VARCHAR9CBE-CBSEntry發(fā)生額NameDescriptionDatatypeLenCodetable

5、bchkeyThebranchdothetransction機(jī)構(gòu)唯一標(biāo)志VARCHAR9INRIdentificationNumberINR流水號(hào)VARCHAR8OBJTYPObjectType業(yè)務(wù)種類VARCHAR6CBOTXTOBJINRObjectIdentificationNumber業(yè)務(wù)流水號(hào)VARCHAR8EXTIDExternalKey退出IDVARCHAR16CBTTypeofEntry業(yè)務(wù)類型CBSENTRY類型VARCHAR6CBTTXTTRNTYPTransactionType交易類型VARCHAR6TRNINRTransactionIdentificationNumbe

6、r交易流水號(hào)VARCHAR8DATRelevantDate相關(guān)的日期TIMESTAMPCURCurrency幣種VARCHAR3CURTXTAMTAmount金額Numeric18,3RELFLGReleaseFlag發(fā)生狀態(tài)VARCHAR1EmbeddedCREDATDateofCreation創(chuàng)建日期TIMESTAMPXRFCURCurrencyofConvertedAmount(Optional)可更換的幣種VARCHAR3XRFAMTJK口JHI1ConvertedAmount(Optional)可更換的金額Numeric18,3NAMDescriptiveNameofEntry扌苗述

7、VARCHAR40ACCBookingAccount核心帳號(hào)1VARCHAR34ACC2CounterAccount核心賬號(hào)2VARCHAR34OPTDATDate(Optional)可選日期TIMESTAMPGLEDATDateofGLEEntriesofTransaction記賬日期TIMESTAMPCHKFLG檢杳標(biāo)示VARCHAR1GLE-GeneralLedgerEntry賬務(wù)NameDescriptionDatatypeLenCodetablebchkeyThebranchdothetransction機(jī)構(gòu)唯一標(biāo)志VARCHAR9INRInternalUniqueID(setinG

8、LEMOD)流水號(hào)VARCHAR8OBJTYPObjecttypeofContract(SetinGLEMOD)業(yè)務(wù)種類VARCHAR6OBJINRINRofLinkedRecord(SetinGLEMOD)業(yè)務(wù)流水號(hào)VARCHAR8TRNINRTransactionCreatingEntry(SetinGLEMOD)交易流水號(hào)VARCHAR8ACTAccountNumberinourBooks(Mandatory)交易帳號(hào)VARCHAR34DBTCDTDebit/Credit(Mandatory)借貸標(biāo)志VARCHAR1DBTCDTCURBookedinCurrency(Mandatory)

9、幣種VARCHAR3CURTXTAMTBookingAmount(Mandatory)金額Numeric18,3SYSCURSystemCurrency(Optional)規(guī)定幣種VARCHAR3CURTXTSYSAMTBookingAmountinSystemCurrency(Optional)規(guī)疋幣種類型金額Numeric18,3VALDATValueDate(DefaultstoBUCDAT)生效日期TIMESTAMPBUCDATBookingDate(DefaultstoToday)記錄日期TIMESTAMPTXT1BookingVARCHAR1預(yù)付文本1VARCHAR40TXT2Bo

10、okingVARCHAR2預(yù)付文本2VARCHAR40TXT3BookingVARCHAR3預(yù)付文本3VARCHAR40PRNPrimaNotaVARCHAR4EXPSESExportSession出口用戶會(huì)話VARCHAR8EXPFLGExportStatus(Stored,Released,Exported,Accepted)狀態(tài)VARCHAR1EmbeddedACTTRNCODtransactioncodeforaccountinginterface傳票打印類型VARCHAR4BRANCHINRbranchcodeinr記賬機(jī)構(gòu)INRVARCHAR8DBTDFTDebitdraft借據(jù)號(hào)

11、(融資時(shí))VARCHAR17PEEACTPeeract對(duì)應(yīng)帳號(hào)VARCHAR21RATRATE匯率Numeric12,6RAT1匯率1DECIMAL12,6TRDTYPtradetype交易類型VARCHAR3CLIEXTKEYClientExtendID客戶號(hào)VARCHAR24WHMTYPTypeofforeignexchange結(jié)售匯類型VARCHAR2GLEORDOrderofGLE分錄順序號(hào)VARCHAR5NEWACTCODACTtypr(7759or5006)核心系統(tǒng)交易代碼VARCHAR4TRMTYPTermtype科目代號(hào)VARCHAR5TRNMAN交易主體VARCHAR2MID

12、RATMiddleRat中間價(jià)Numeric12,6XRTTIMXRTTime中間價(jià)的牌價(jià)時(shí)間VARCHAR20RATCNT牌價(jià)盤數(shù)Numeric3,0BLAINRBLA表INRVARCHAR8GLEFCDFLG標(biāo)識(shí)是否為平盤傳票VARCHAR2TRDWAY進(jìn)口押匯途徑VARCHAR8BNKCOD聯(lián)行號(hào)VARCHAR6DSP:賬務(wù)標(biāo)示VARCHAR6BUSCOD:賬務(wù)類型VARCHAR5SUBCOD1科目號(hào)VARCHAR8FCTSGN:結(jié)售匯標(biāo)示VARCHAR45FEP-費(fèi)用明細(xì)bchkeyThebranchdothetransction機(jī)構(gòu)唯一標(biāo)志VARCHAR9INR內(nèi)部唯一IDVARCH

13、AR8FEECOD費(fèi)用代碼VARCHAR6OBJTYP對(duì)象表名稱VARCHAR6OBJINR對(duì)象表INRVARCHAR8RELOBJTYP相關(guān)對(duì)象類型VARCHAR6RELOBJINR相關(guān)對(duì)象的INRVARCHAR8EXTKEY外部可見(jiàn)名VARCHAR20NAM費(fèi)用文本信息VARCHAR45RELCUR相關(guān)幣種VARCHAR3RELAMT相關(guān)金額DECIMAL18,3DAT1費(fèi)用收取起始日TIMESTAMPDAT2費(fèi)用收取截止日TIMESTAMPMODFLG修改標(biāo)志(費(fèi)用變化狀態(tài))VARCHAR1UNT費(fèi)用收取的份數(shù)DECIMAL5,0UNTAMT每份費(fèi)用的金額DECIMAL18,3RATCA

14、L計(jì)算使用的費(fèi)率DECIMAL14,6RAT費(fèi)率DECIMAL14,6MINMAXFLG取低取咼費(fèi)率使用標(biāo)示VARCHAR1CUR費(fèi)用幣種VARCHAR3AMT費(fèi)用金額DECIMAL18,3XRFCUR費(fèi)用折算后的幣種VARCHAR3XRFAMT費(fèi)用折算后的金額DECIMAL18,3FEEACC費(fèi)用入賬的賬號(hào)VARCHAR34INFDETSTM費(fèi)用計(jì)算細(xì)節(jié)VARCHAR1620PTYINR支付實(shí)體的INRVARCHAR8SRCTRNINR創(chuàng)建或者修改該費(fèi)用的交易的TRN表INRVARCHAR8SRCDAT創(chuàng)建日期TIMESTAMPRPLTRNINR取代交易的TRNINRVARCHAR8RPLD

15、AT取代日期TIMESTAMPDONTRNINR結(jié)算費(fèi)用交易的TRN表INRVARCHAR8DONDAT結(jié)算日期TIMESTAMPADVTRNINR通知費(fèi)用交易的TRN表INRVARCHAR8ADVDAT通知日期TIMESTAMPACRINR循環(huán)計(jì)算的INRVARCHAR8SEPINR對(duì)應(yīng)的臨時(shí)結(jié)算的INRVARCHAR8ROL角色VARCHAR3FLG費(fèi)用標(biāo)示1VARCHAR1FLG1費(fèi)用標(biāo)示2VARCHAR1BASEAMT基礎(chǔ)費(fèi)用金額DECIMAL18,3STAFLG費(fèi)用狀態(tài)VARCHAR1PRVFEPINR前手費(fèi)用INRVARCHAR86PTY客戶信息NameHelpVARCHARDes

16、criptionDateTypeLenCodetablebchkeyThebranchdothetransction機(jī)構(gòu)唯一標(biāo)志VARCHAR9INRInternaluniqueID流水號(hào)VARCHAR8EXTKEYExternalKey客戶號(hào)VARCHAR24NAMName客戶名稱VARCHAR40PTYTYP:TypeofParty客戶類型VARCHAR15ACCUSRUserIDofAccountOfficer用戶帳戶的IDVARCHAR12HBKACCFLGUseAccountingofHouseBankHousebank帳戶標(biāo)志VARCHAR1HBKCONFLGUseConditio

17、nsofHouseBankHousebank用戶環(huán)境標(biāo)志VARCHAR1HBKINRINRofAssociatedHouseBank銀行INRVARCHAR8HEQACCFLGUseAccountingofHeadquarters總行帳戶標(biāo)志VARCHAR1HEQCONFLGUseConditionsofHeadquarters總行環(huán)境標(biāo)志VARCHAR1HEQINRINRofAssociatedHeadquarters總部INRVARCHAR8PRFCTRProfitcenterVARCHAR6RESUSRIdentifiesResponsibleUser客戶經(jīng)理VARCHAR8RSKCLS

18、RiskClass風(fēng)險(xiǎn)級(jí)別VARCHAR6RSKCTYRiskCountry風(fēng)險(xiǎn)發(fā)生國(guó)家VARCHAR2CTYTXTRSKTXTRiskVARCHARualDescription風(fēng)險(xiǎn)文本描述VARCHAR35UILDefaultLanguageforcommunication傳輸?shù)恼Z(yǔ)言VARCHAR2VERVersion版本VARCHAR4AKKBRAAKKBusinessAreaVARCHAR3AKKCOMAKKCompanyIDNo.VARCHAR8AKKREGAKKRegionCodeVARCHAR2AKKREGLIDCNDFLGSpecialVARCHAR1LIDMAXDURMaxim

19、umNumeric4,0TRDCNDFLG進(jìn)口押匯標(biāo)記VARCHAR1TRDTENTOT匯票的最大期限日Numeric5,0TRDTENINI最初匯票期限Numeric5,0TRDTENEXT匯票的最大延期日Numeric5,0TRDEXTNMBMaximumNumeric5,0BADCNDFLGSpecialBAConditionsforPartyVARCHAR1BADTENEXTMaximumNumeric4,0ADRSTAAddressStatus客戶狀態(tài)VARCHAR1EmbeddedSELTYPCustomerSpecificSellingRateType客戶信貸利率VARCHAR1

20、RATTYPBUYTYPCustomerSpecificBuyingRateType客戶借貸利率VARCHAR1RATTYPSLA服務(wù)等級(jí)VARCHAR3SLATXTETGEXTKEYEntityGroup實(shí)體組VARCHAR8NAM1中文名稱VARCHAR128BRANCHINR所屬機(jī)構(gòu)號(hào)VARCHAR8JUSCOD技術(shù)監(jiān)督局編號(hào)VARCHAR10BILVVV利率Numeric8,5CUNQII利款檔次VARCHAR3IDCODE身份證號(hào)碼VARCHAR32IDTYPE客戶類型VARCHAR1BCHKEYINRBCHKEYINRVARCHAR8CLSCTYCreditclassofCount

21、ryVARCHAR6PROCODPROCODVARCHAR2RGCP對(duì)公客戶注冊(cè)資金varchar20CRNM對(duì)公客戶法定代表人姓名varchar32CRIT對(duì)公客戶法定代表人身份證件類型varchar2CRID對(duì)公客戶法定代表人身份證件號(hào)碼VARCHAR20RGCPCUR對(duì)公客戶注冊(cè)資金幣種VARCHAR30CTVC行業(yè)類別VARCHAR2CRDCNT申請(qǐng)授信次數(shù)VARCHAR30CLIENTID核心客戶標(biāo)號(hào)VARCHAR20CBOSTA核心客戶狀態(tài)VARCHAR27TRN-TransactionControlRecordNameDescriptionDatatypeLenCodetable

22、bchkeyThebranchdothetransction機(jī)構(gòu)唯一標(biāo)志VARCHAR9INRInternalUniqueIDofTransaction流水號(hào)VARCHAR8INIDATTIMDateofEntryofTransaction交易日期TIMESTAMPINIFRMFrameUsedtoCreatetheTransaction交易名VARCHAR6INIUSRUsercreatingthetransaction交易柜員VARCHAR12ININAMTransactionNameofStoringTransaction交易名VARCHAR40OWNREFOwnReferenee參考號(hào)

23、VARCHAR16OBJTYPObjectTypeofAssociatedContract(Optional)業(yè)務(wù)種類VARCHAR6OBJINRObjectINRofAssociatedContract(Optional)業(yè)務(wù)流水號(hào)VARCHAR8OBJNAMExternalReadableObjectIdentification業(yè)務(wù)描述VARCHAR40SSNINRINRofSSNwheretransactionwascreatedSessionIDVARCHAR8SMHNXTNextCounterforSMHwithinTRN報(bào)文、面函個(gè)數(shù)Numeric3,0USGResponsible

24、Group經(jīng)辦組VARCHAR6USGTXTUSRResponsibleUser指定聯(lián)系人VARCHAR12CPLDATTIMDateofCompletion(ExecutionofLastService)交易結(jié)卷日期TIMESTAMPINFDSPInfoflag顯示信息標(biāo)志VARCHAR1INFDSPINFTXTInfoVARCHAR信息文本VARCHAR264RELFLGReleaseStatus授權(quán)狀態(tài)VARCHAR1RELSTACOMFLGCommitted(CifCommitted)交易確認(rèn)狀態(tài)VARCHAR1EmbeddedCOMDATDateofCommitCommint日期TI

25、MESTAMPCORTRNINRINRofpreceedingTRN被刪除貨需要修改的TRN的INRVARCHAR8XREFLGStatusofrecalculation交易重估狀態(tài)標(biāo)志VARCHAR1EmbeddedXRECURBLKCurrencieshandledbytransaction重算標(biāo)志Block40RELCURCurrencyofRelevantAmountforRelease系統(tǒng)貨幣VARCHAR3CURTXTRELAMTRelevantAmountforRelease系統(tǒng)貨幣金額Numeric18,3RELORICURCurrencyofRelevantAmountfor

26、ReleaseinOriginalCurrency交易幣種VARCHAR3RELORIAMTRelevantAmountforReleaseinOriginalCurrency交易金額Numeric18,3RELREQRequiredSignatures要求授權(quán)標(biāo)志VARCHAR3RELRESAppliedSignatures已經(jīng)授權(quán)標(biāo)志VARCHAR3CNFFLGFlag,ifExternalConfirmationNecessary標(biāo)志VARCHAR1TRNCNFEVTTXTEvents事件描述(主要存放記賬動(dòng)作)LONGVARCHARRPRUSRSentforrepairto退回至U指定

27、人員VARCHAR12ORDINRINRoftriggeringorderORD表inrVARCHAR8EXEDATExecutionDate執(zhí)行日期TIMESTAMPCLRFLG清算標(biāo)志VARCHAR1ETYEXTKEYEntityholdingTransaction實(shí)體VARCHAR8BCHKEYINRBCHKEYINR經(jīng)辦機(jī)構(gòu)VARCHAR8ACCBCHINRACCBCHINR記賬機(jī)構(gòu)VARCHAR8TRXSQNB核心記賬流水號(hào)1VARCHAR20TRXSQNBADD核心記賬流水號(hào)2VARCHAR20ACCSNDFLG記賬標(biāo)示VARCHAR1RELREQ0單證中心授權(quán)請(qǐng)求VARCHAR3

28、RELREQ1分仃授權(quán)請(qǐng)求VARCHAR3RELREQ2支仃授權(quán)請(qǐng)求VARCHAR3RELRES0單證中心簽名VARCHAR3RELRES1分行簽名VARCHAR3RELRES2支行簽名VARCHAR3IMGINR圖像inrVARCHAR8CMTFLG跨境標(biāo)志VARCHAR1ESBINRESB流水號(hào)VARCHAR198FCD-結(jié)售匯NameDescriptionDatatypeLenCodetablebchkeyThebranchdothetransction機(jī)構(gòu)唯一標(biāo)志VARCHAR9INRINROFFCCONTRACT內(nèi)部號(hào)VARCHAR8OWNREFOURREFERENCE業(yè)務(wù)參考號(hào)VA

29、RCHAR16NAMNAMEOFFCCONTRACT名稱VARCHAR40OWNUSRRESP.USER經(jīng)辦人VARCHAR12CREDATCREATIONDATE創(chuàng)建日期TIMESTAMPOPNDATOPENINGDATE開(kāi)立日期TIMESTAMPCLSDATDATECLOSED閉卷日期TIMESTAMPAPLPTYINRDRAWERPARTY申請(qǐng)人ptyinrVARCHAR8APLPTAINRDRAWERADDRESS申請(qǐng)人地址inrVARCHAR8APLNAMDRAWERNAME申請(qǐng)人名稱VARCHAR40APLREFDRAWERREFERENCE申請(qǐng)人編號(hào)VARCHAR16CNVDAT

30、CONVERSIONDATE變換日期TIMESTAMPVERVERSION版本VARCHAR4ACCCURTARGETCURRENCY幣另UVARCHAR3DCBEXTRATCONTRACTRATE禾悴NUMERIC14,6SCBEXTRATTARGETRATE禾U率NUMERIC14,6RATCROSSRATE利率NUMERIC14,6ENGACTEngagementaccount保證金賬號(hào)VARCHAR34BCHKEYINRThebranchdothetransction經(jīng)辦機(jī)構(gòu)編號(hào)VARCHAR8CURcurrency幣種VARCHAR3AMTbalaneevalidinperiode金

31、額NUMERIC18,3EXTKEYExternalkeyusedtouniquelyidentifyapartyVARCHAR24RELFLGreleaseflagVARCHAR1USEFLGuseflagVARCHAR1REASONcollectreasonVARCHAR40GLEFLG賬務(wù)標(biāo)示VARCHAR1REGREFRegisterRef.VARCHAR16BRANCHINRBRANCHINRVARCHAR8EXTACTExtendAccountVARCHAR34TRMTYPTERMTYPEVARCHAR5ACCAMT記賬金額NUMERIC18,3CRDRFLGBaseonCrorD

32、rActVARCHAR1FLGZY自營(yíng)結(jié)售匯VARCHAR10FCDTYPTypeVARCHAR2SS:即期售匯;FS:遠(yuǎn)期售匯SB:即期結(jié)匯FB:遠(yuǎn)期結(jié)匯OT:會(huì)計(jì)調(diào)賬OBJTYPObjectTypeVARCHAR3OBJINRObjectINRVARCHAR8TRQ結(jié)售匯類型號(hào)VARCHAR50ICBEXTRAT匯率DECIMAL14,6ETYEXTKEY實(shí)體VARCHAR89ACT-賬戶表NameDescriptionDatatypeLenCodetableBRANCHBranchcodeoftheothersystem機(jī)構(gòu)號(hào)VARCHARn91INRInternaluniqueID流水號(hào)VARCHAR8PRIPriorityforDefaulting初始默認(rèn)帳號(hào)VARCHAR1CURAccountCurrency幣種VARCHAR3EXTKEYExternalKey帳號(hào)VARCHAR34SERACCAccountNumberDefinedbyServicingInstitute服務(wù)帳號(hào)VARCHAR34SERNAMAccountNam

溫馨提示

  • 1. 本站所有資源如無(wú)特殊說(shuō)明,都需要本地電腦安裝OFFICE2007和PDF閱讀器。圖紙軟件為CAD,CAXA,PROE,UG,SolidWorks等.壓縮文件請(qǐng)下載最新的WinRAR軟件解壓。
  • 2. 本站的文檔不包含任何第三方提供的附件圖紙等,如果需要附件,請(qǐng)聯(lián)系上傳者。文件的所有權(quán)益歸上傳用戶所有。
  • 3. 本站RAR壓縮包中若帶圖紙,網(wǎng)頁(yè)內(nèi)容里面會(huì)有圖紙預(yù)覽,若沒(méi)有圖紙預(yù)覽就沒(méi)有圖紙。
  • 4. 未經(jīng)權(quán)益所有人同意不得將文件中的內(nèi)容挪作商業(yè)或盈利用途。
  • 5. 人人文庫(kù)網(wǎng)僅提供信息存儲(chǔ)空間,僅對(duì)用戶上傳內(nèi)容的表現(xiàn)方式做保護(hù)處理,對(duì)用戶上傳分享的文檔內(nèi)容本身不做任何修改或編輯,并不能對(duì)任何下載內(nèi)容負(fù)責(zé)。
  • 6. 下載文件中如有侵權(quán)或不適當(dāng)內(nèi)容,請(qǐng)與我們聯(lián)系,我們立即糾正。
  • 7. 本站不保證下載資源的準(zhǔn)確性、安全性和完整性, 同時(shí)也不承擔(dān)用戶因使用這些下載資源對(duì)自己和他人造成任何形式的傷害或損失。

評(píng)論

0/150

提交評(píng)論