{"text_format":"2","workbook":"xls","n_sheets":57,"sheets":["Intro&History","PAYMENTS","TRADE","SECURITIES","CARDS","1-AccountIdentification","2-BalanceSubType","3-CashClearingSystem","4-CategoryPurpose","5-ClearingSystemIdentification","6-FinancialInstitutionIdentif","7-LocalInstrument","8-MandateReason","9-OrganisationIdentification","10-PersonIdentification","11-Purpose","12-ReportingSource","13-ReturnReason","14-ReversalReason ","15-ServiceLevel","16-StatusReason","17-TechnicalInputChannel","18-VerificationReason","19-DocumentPurpose","20-DocumentType","21-Incoterms","22-InformationType","23-PackagingTypeCode","24-FinancialInstrumentIdType","25-TradeTransactionCondition","26-ChargeType","27-CashAccountType","28-DiscountAmountType","29-TaxAmountType","30-CardTransactionCategory","31-BillingBalanceType","32-BillingCompensationType","33-BillingRateIdentification","34-RePresentmentReason","35-Channel","36-DateFrequency","37-DocumentFormat","38-ModelFormIdentification","39-NarrativeType","40-RelativeTo","41-TypeOfParty","42-UnderlyingTradeTransactionTp","43-UndertakingAmountType","44-UndertakingChargeType","45-UndertakingDocumentType1","46-UndertakingDocumentType2","47-UndertakingStatusCategory","48-UndertakingType","49-DocumentLineType","50-GarnishmentType","51-TradeMarket","52-MandateSetupReason"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":86,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Intro&History","index":0,"n_rows":62,"n_cols":2,"rows_kept":62,"cut":false,"hidden":false,"merged":[[56,0,60,0]],"flags":["formulas_cached_only"]}
["Subject","Inventory of External Code Sets - Required by (but external to) the ISO 20022 Message Schemas"]
[]
["Publication date","31 August 2015 - V02"]
["Source","ISO20022.org"]
[null,"See this site for the latest version of these code sets."]
[]
["Related Messages  ","Payments messages: See PAYMENTS inventory sheet.    "]
[null,"Trade Services messages: See TRADE inventory sheet."]
[null,"Securities messages: See SECURITIES inventory sheet"]
[null,"Cards messages: See CARDS inventory sheet"]
[]
["Details","All external code sets required to fully use the ISO 20022 Message Schemas are included in this document but 3."]
[null,"An additional 3 code sets (Bank Transaction Code) can be found separately on ISO20022.org."]
[]
["Description","These codes are required by the messages as indicated in the following inventory sheets.  They have been made external to the schema to allow for separate maintenance of messages and codes. The inventory sheets mention the latest versions of the messages. This document also includes the external code sets used by previous versions of messages. "]
[]
["Content","External code sets published in this spreadsheet are versioned at three levels: the spreadsheet itself has a publication date (see above), each code list within the spreadsheet has a publication date (see inventory sheets) and each individual code has a date of last update ('status date'). The updates since the last publication are highlighted in italic red."]
[]
["Maintenance/ Requests for New Values","External code sets are maintained on a quarterly basis. Updated sets are published by end February, end of May, end of August and end of November. Additional releases may happen upon publication of new messages or new versions of existing messages using cexternal code sets. Requests for changes must be submitted using the form:"]
[null,"\"Change Request for the update of an External Code Set\" template."]
[null,"       "]
[]
["Revision History","Based on 09 June 2009 Edition"]
["17 Jan, 2010","Additions for CR0002, CR0005, CR0006, CR0007.  7 new external codes.  Impacted code sets:  LocalInstrument, Purpose, ReturnReason.  Reformatted to include 'introduced date'. "]
["03 Feb, 2010","Revised proposed code value for CoreNoRefund per submitter request (CR0005, code set LocalInstrument)."]
["26 April, 2010 draft","Draft 1Q2010 Codes CR0010, CR0011, CR0012, CR0016."]
["21 June, 2010 draft","Draft 2Q2010 Codes CR0015. Addition of MandateReason and VerificationReason code sets"]
["16 August, 2010 Final","1st and 2nd quarter 2010 CR's related to code requests including: CR0010 (StatusReason), CR0015 (ClearingSystemIdentification), and CR0011, CR0012, CR0016 (LocalInstrument)"]
["23 September, 2010  draft","EPC values for MandateReason code set.  3Q2010 eval, CR0052"]
["30 November, 2010 Final","3rd quarter 2010 including \nFor the Payments SEG - CR0052 (MandateReason),  \nFor the Trade SEG - addition of 5 code sets (DocumentPurpose, DocumentType, Incoterms, InformationType, PackagingType)  \nFor the Securities SEG - addition of code set FinancialInstrumentIdentificationType "]
["6 December, 2010 Draft","For the Payments SEG - CR0053, 54, 55, 56 approved in 4Q2010 evaluation"]
["17 February, 2011 Final","4th quarter 2010 including for the Payments SEG - CR0053 and 55 (LocalInstrument), 54 and 56 (OrganisationIdentification) "]
["31 May, 2011 Final","1st quarter 2011 including for the Payments SEG - CR0058 (BalanceSubType), 59 (StatusReason), 63 (CategoryPurpose) and correction of a typo in an example of ClearingSystemIdentification"]
["31 August, 2011 Final","2nd quarter 2011 including: \nFor the Payments SEG - CR0073 impacting LocalInstrumentCode and \nFor the Securities SEG - addition of code set TradeTransactionCondition "]
["2 December, 2011 Final","3rd quarter 2011 including: \nFor the Payments SEG - CR0148, CR0149, CR0150 impacting LocalInstrumentCode and including PaySEG subgroup formatting revisions for clarity and improved information.  Code sets will now consist of 3 sections:  Identification, Information, and Status. Identification and Status are mandatory sections.  Information is helpful information needed to clarify application of the codes.\n"]
["9 February, 2012 Final","4th quarter 2011 including: \nFor the Payments SEG: CR0153 - Berlin Group - Purpose - 2 new codes for card settlement. CR0154 - Berlin Group - ReturnReason - 3 new codes. CR0060 - CGI - Local Instrument - 13 additional codes. CR0155 - CGI - Purpose Codes- 3 additional codes. CR0156 - CGI - Category Purpose - 2 additional codes."]
["31 May, 2012 Final","1st quarter 2012 including: CR0170 - Berlin Group - Purpose - 1 new code for card settlement. 4 new code sets: 26-ChargeType ; 27-CashAccountType ; 28-DiscountAmountType ; 29-TaxAmountType"]
["22 June, 2012 Final","Revision of 1st quarter 2012 to correct 7-LocalInstrument code list to correct misaligned rows "]
["16 July, 2012 Final","2nd quarter 2012 including:\nFor the Payments SEG: CR0243 - EPC - ReturnReasonCode & StatusReasonCode. CR0244 - Bank Association of Slovenia - PurposeCode. Code sets 28-DiscountAmountType and 29-TaxAmountType: code values for the sets created as external code sets but unpopulated during the last message maintenance cycle."]
["22 Oct, 2012 Final","3rd quarter 2012 including:\nFor the Payments SEG: CR0247 - CFONB - ReturnReason; CR0248 - CFONB - ReversalReason; CR0250 - DSGV - Purpose; CR0251 - BerlinGroup - Purpose & CategoryPurpose. 4 new code sets: 30-CardTransactionCategory; 31-BillingBalanceType ; 32-BillingCompensationType ; 33-BillingRateIdentification"]
["7 Feb, 2013","4th quarter 2012 including:\nFor the Payments SEG:  CR0242 - SIX - 16-StatusReason; CR0253 - Berling Group - 11-Purpose; code values for code sets 31-BillingBalanceType ; 32-BillingCompensationType ; 33-BillingRateIdentification to be used in the Bank Services Billing message\nFor Cards SEG: new code set 34-RePresentmentReason for use in Berlin Group SupplementaryData extension\nFor Trade SEG: 14 new code sets (35 to 48) for use in Demand Guarantees and Standby Letters of Credit messages"]
["7 May, 2013","1st quarter 2013 including:\nFor the Payments SEG: CR0255 - BCS Singapore, 11-Purpose;  CR0257 - EPC, 13-ReturnReason.\n"]
["29 Nov, 2013","3rd quarter 2013 External Codes evaluation including:\nFor the Payment SEG:  CR308 - Deutscher Sparkassen- und Giroverband (German Savings Banks Association) , 11-Purpose, 1 new code."]
["2 Dec, 2013","For the Payments SEG: CR308 - Deutscher Sparkassen- und Giroverband (German Savings Banks Association) , 11-Purpose, correction of the name and definition of the RIMB code."]
["16 Jan, 2014","4th quarter 2013 including:\nFor the Payments SEG: \nCR0310 –Canadian Payments Assoc - 3-CashClearingSystem - 3 new codes including a replacement;  \nCR0311 - German Banking Industry Committee - 11-Purpose - 1 new code\nCR0312 – All German Bausparkassen and all 422 German Savings Banks and 8 regional banks (Landesbanken) - 11-Purpose - 1 new code + 1 code updated. \nCR0314 –SWIFT and ETDA Thailand-5-ClearingSystemIdentification - 1 new code, removal of the example column."]
["21 Feb, 2014","Publication of new message versions resulting from maintenance cycle 2013/2014 including:\nFor the Trade SEG:\nCR0316 - Trade SEG - 21-Incoterms - Updated code set definitions"]
["17 April, 2014","Addition of two new code sets used in the newly approved Stand-alone Remittance Advice messages: 49-DocumentLineType and 50-GarnishmentType"]
["13 June, 2014","2nd quarter 2014 including for the Payments SEG: \nCR0315 –Banco Central del Ecuador - 3-CashClearingSystem - 1 new code\nCR0385 - Deutsche Bundesbank - 3-CashClearingSystem - 1 new code replaces (retires) an existing code."]
["31 July, 2014","2nd quarter 2014 errata related to CR0385 - Deutsche Bundesbank - 3-CashClearingSystem - Reinstatement of ELS"]
["28 November, 2014","3rd quarter CRs including for the Payments SEG:\nCR0456 - STUZZA - 1 new code for 16-StatusReason\nCR0459 - Hungarian Banking Association (HBA) - 1 new code for  11-Purpose"]
["26 December, 2014","3rd quarter CRs including for the Payments SEG:"]
[null,"CR0458 - Association of German Banks  - 3 new codes for 11-Purpose"]
[null,"CR0462 - STUZZA - Update of 1 code in 4-CategoryPurpose"]
["27 February, 2015","4th quarter 2014 CR including for the Payments SEG:\nCR0464 - Equens - 1 new code for 3-CashClearingSystem"]
["13 March, 2015","Publication of new messages and new versions resulting from maintenance cycle 2014/2015 "]
["28 April, 2015","Introduction of a new code set: 51-TradeMarket submitted by the ASF (Association des Sociétés Françaises)"]
["31 August, 2015","2nd quarter 2015 CRs including for the Payments SEG:"]
[null,"CR0466 - SEB - 2 new codes for 4-CategoryPurpose"]
[null,"CR0467 - Deutsche Bundesbank - 8 new codes for 11-Purpose"]
[null,"CR0468 - Deustche Bundesbank - 2 new codes for 7-LocalInstrumentCode"]
[null,"CR0469 - Deutsche Bundesbank - 1 new code for 15-ServiceLevelCode"]
[null,"CR0522 - GUF - 1 new code for the Bank Transaction Code set\nIntroduction of new code set: 52-MandateSetupReason\n"]

{"sheet":"PAYMENTS","index":1,"n_rows":74,"n_cols":68,"rows_kept":74,"cut":false,"hidden":false,"merged":[[1,67,2,67],[56,2,58,2],[56,67,58,67],[1,1,3,1],[1,2,3,2],[1,3,2,66]],"flags":["formulas_cached_only"]}
[null,"OVERVIEW EXTERNAL CODE SETS USED IN PAYMENTS MESSAGES"]
[null,"Data Element Name","SEG","Used in"]
[]
[null,null,null,"auth.001.001.01","auth.002.001.01","acmt.007.001.02","acmt.008.001.02","acmt.009.001.02","acmt.010.001.02","acmt.011.001.02","acmt.012.001.02","acmt.013.001.02","acmt.014.001.02","acmt.015.001.02","acmt.016.001.02","acmt.017.001.02","acmt.018.001.02","acmt.019.001.02","acmt.020.001.02","acmt.021.001.02","acmt.022.001.02","acmt.023.001.02","acmt.024.001.02","camt.026.001.04","camt.027.001.04","camt.028.001.05","camt.029.001.05","camt.030.001.04","camt.031.001.04","camt.032.001.03","camt.033.001.04","camt.034.001.04","camt.035.001.03","camt.036.001.03","camt.037.001.04","camt.038.001.03","camt.039.001.04","camt.052.001.05","camt.053.001.05","camt.054.001.05","camt.055.001.04","camt.056.001.04","camt.057.001.04","camt.058.001.04","camt.059.001.04","camt.060.001.03","camt.086.001.01","camt.087.001.02","pacs.002.001.06","pacs.003.001.05","pacs.004.001.05","pacs.007.001.05","pacs.008.001.05","pacs.009.001.05","pain.001.001.06","pain.002.001.06","pain.007.001.05","pain.008.001.05","pain.009.001.04","pain.010.001.04","pain.011.001.04","pain.012.001.04","pain.013.001.04","pain.014.001.04","remt.001.001.01","remt.002.001.01","supl.027.001.01","Last Publication Date"]
[1,"ExternalAccountIdentification1Code","Payments","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√",null,"√","√","√",{"$nulls":10},"√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√",null,"√","2009-06-09"]
[2,"ExternalBalanceSubType1Code","Payments",{"$nulls":34},"√","√",{"$nulls":6},"√",{"$nulls":21},"2011-05-31"]
[3,"ExternalCashClearingSystem1Code","Payments",{"$nulls":22},"√","√",{"$nulls":13},"√","√",{"$nulls":6},"√","√","√","√","√","√",null,"√","√",{"$nulls":10},"2015-02-27"]
[4,"ExternalCategoryPurpose1Code","Payments",{"$nulls":22},"√","√",{"$nulls":13},"√","√",{"$nulls":5},"√","√","√","√","√","√","√","√","√","√","√",{"$nulls":4},"√","√","√",null,null,"2015-08-31"]
[5,"ExternalClearingSystemIdentification1Code ","Payments","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","2014-01-16"]
[6,"ExternalFinancialInstitutionIdentification1Code","Payments","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","2009-06-09"]
[7,"ExternalLocalInstrument1Code ","Payments",{"$nulls":22},"√","√","`",{"$nulls":12},"√","√",{"$nulls":5},"√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√",null,null,"2015-08-31"]
[8,"ExternalMandateReason1Code","Payments",{"$nulls":56},"√","√","√",{"$nulls":5},"2010-11-30"]
[9,"ExternalOrganisationIdentification1Code","Payments","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","2011-02-17"]
[10,"ExternalPersonIdentification1Code","Payments","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√",null,"√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","2009-06-09"]
[11,"ExternalPurpose1Code ","Payments",{"$nulls":22},"√","√",{"$nulls":10},"√","√","√",null,null,"√","√","√",null,null,"√",null,"√",null,null,"√",null,"√",null,null,"√",{"$nulls":4},"√",{"$nulls":4},"2015-08-31"]
[12,"ExternalReportingSource1Code","Payments",{"$nulls":34},"√","√","√",{"$nulls":27},"2009-06-09"]
[13,"ExternalReturnReason1Code","Payments",{"$nulls":34},"√","√","√",{"$nulls":10},"√",{"$nulls":16},"2013-05-07"]
[14,"ExternalReversalReason1Code","Payments",{"$nulls":48},"√",{"$nulls":4},"√",{"$nulls":10},"2012-10-22"]
[15,"ExternalServiceLevel1Code","Payments",{"$nulls":22},"√","√",{"$nulls":13},"√","√",{"$nulls":5},"√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√",null,null,"2015-08-31"]
[16,"ExternalStatusReason1Code","Payments",{"$nulls":45},"√",{"$nulls":6},"√",{"$nulls":7},"√",null,null,null,"2014-11-28"]
[17,"ExternalTechnicalInputChannel1Code","Payments",{"$nulls":34},"√","√","√",{"$nulls":27},"2009-06-09"]
[18,"ExternalVerificationReason1Code","Payments",{"$nulls":19},"√",{"$nulls":44},"2010-08-16"]
[19,"ExternalDocumentPurpose1Code","Trade",{"$nulls":64},"2010-11-30"]
[20,"ExternalDocumentType1Code","Trade",{"$nulls":64},"2010-11-30"]
[21,"ExternalIncoterms1Code","Trade",{"$nulls":64},"2014-02-21"]
[22,"ExternalInformationType1Code","Trade",{"$nulls":64},"2010-11-30"]
[23,"ExternalPackagingType1Code","Trade",{"$nulls":64},"2010-11-30"]
[24,"ExternalFinancialInstrumentIdentificationType1Code","Securities",{"$nulls":34},"√","√","√",{"$nulls":27},"2010-11-30"]
[25,"ExternalTradeTransactionConditions1Code","Securities",{"$nulls":64},"2011-08-31"]
[26,"ExternalChargeType1Code","Payments",{"$nulls":23},"√",{"$nulls":10},"√","√","√",{"$nulls":27},"2012-05-31"]
[27,"ExternalCashAccountType1Code","Payments","√","√","√","√","√",{"$nulls":4},"√","√","√",{"$nulls":9},"√","√","√",{"$nulls":10},"√","√","√","√","√","√","√","√","√",null,"√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√",null,null,"2012-05-31"]
[28,"ExternalDiscountAmountType1Code","Payments",{"$nulls":22},"√","√",{"$nulls":10},"√","√","√","√","√","√","√","√",null,null,"√","√","√","√","√","√","√","√","√","√","√",{"$nulls":4},"√",null,"√",null,null,"2012-07-16"]
[29,"ExternalTaxAmountType1Code","Payments",{"$nulls":22},"√","√",{"$nulls":10},"√","√","√","√","√","√","√","√",null,null,"√","√","√","√","√","√","√","√","√","√","√",{"$nulls":4},"√",null,"√",null,null,"2012-07-16"]
[30,"ExternalCardTransactionCategory1Code","Payments",{"$nulls":64},"2012-10-22"]
[31,"ExternalBillingBalanceType1Code","Payments",{"$nulls":43},"√",{"$nulls":20},"2012-10-22"]
[32,"ExternalBillingCompensationType1Code","Payments",{"$nulls":43},"√",{"$nulls":20},"2012-10-22"]
[33,"ExternalBillingRateIdentification1Code","Payments",{"$nulls":43},"√",{"$nulls":20},"2012-10-22"]
[34,"ExternalRePresentmentReason1Code","Cards",{"$nulls":64},"2013-02-07"]
[35,"ExternalChannel1Code","Trade",{"$nulls":64},"2013-02-07"]
[36,"ExternalDateFrequency1Code","Trade",{"$nulls":64},"2013-02-07"]
[37,"ExternalDocumentFormat1Code","Trade",{"$nulls":64},"2013-02-07"]
[38,"ExternalModelFormIdentification1Code","Trade",{"$nulls":64},"2013-02-07"]
[39,"ExternalNarrativeType1Code ","Trade",{"$nulls":64},"2013-02-07"]
[40,"ExternalRelativeTo1Code","Trade",{"$nulls":64},"2013-02-07"]
[41,"ExternalTypeOfParty1Code","Trade",{"$nulls":64},"2013-02-07"]
[42,"ExternalUnderlyingTradeTransactionType1Code","Trade",{"$nulls":64},"2013-02-07"]
[43,"ExternalUndertakingAmountType1Code","Trade",{"$nulls":64},"2013-02-07"]
[44,"ExternalUndertakingChargeType1Code","Trade",{"$nulls":64},"2013-02-07"]
[45,"ExternalUndertakingDocumentType1Code","Trade",{"$nulls":64},"2013-02-07"]
[46,"ExternalUndertakingDocumentType2Code","Trade",{"$nulls":64},"2013-02-07"]
[47,"ExternalUndertakingStatusCategory1Code","Trade",{"$nulls":64},"2013-02-07"]
[48,"ExternalUndertakingType1Code","Trade",{"$nulls":64},"2013-02-07"]
[49,"ExternalDocumentLineType1Code","Payments",{"$nulls":61},"√",null,null,"2014-04-17"]
[50,"ExternalGarnishmentType1Code","Payments",{"$nulls":22},"√","√",{"$nulls":10},"√","√","√","√","√","√","√","√",null,null,"√","√","√","√","√","√","√","√","√","√","√",{"$nulls":4},"√",null,"√",null,null,"2014-04-17"]
[51,"ExternalTradeMarket1Code","Trade",{"$nulls":64},"2015-04-28"]
[52,"ExternalMandateSetupReason1Code","Payments",{"$nulls":23},"√",{"$nulls":13},"√","√",{"$nulls":6},"√","√","√","√",null,null,null,"√","√","√","√","√","√","√",{"$nulls":5},"2015-08-31"]
[null,"ExternalBankTransactionDomain1Code 1","Payments",null,null,"√","√",{"$nulls":5},"√",null,null,"√","√",{"$nulls":20},"√","√","√",{"$nulls":27},"2015-08-31"]
[null,"ExternalBankTransactionFamily1Code 1",null,null,null,"√","√",{"$nulls":5},"√",null,null,"√","√",{"$nulls":20},"√","√","√"]
[null,"ExternalBankTransactionSubFamily1Code 1",null,null,null,"√","√",{"$nulls":5},"√",null,null,"√","√",{"$nulls":20},"√","√","√"]
[]
[null,"Legend"]
[null,"1.  The Bank Transaction Code documentation is available separately on ISO20022.org"]
[]
[null," Items in a code list should have 7 attributes:"]
[null,"1)     Code value"]
[null,"2)     Name "]
[null,"3)     Definition "]
[null,"4)     Origin/requester "]
[null,"5)     Status "]
[null,"6)     Status date"]
[null,"7)     Introduced date "]
[]
[null,"Code Statuses are:"]
[null,"New: introduction of a new code\nNew. Replaces code ABC: introduction of a new code to replace a code that has been retired\nDefinition updated: definition of the code has been modified\nRetired. Replaced by ABC.  Do not use: the code is not in use anymore"]

{"sheet":"TRADE","index":2,"n_rows":73,"n_cols":44,"rows_kept":73,"cut":false,"hidden":false,"merged":[[1,3,2,42],[1,1,3,1],[1,2,3,2],[1,43,2,43],[56,2,58,2],[56,43,58,43]],"flags":["formulas_cached_only"]}
[null,"OVERVIEW EXTERNAL CODE SETS USED IN TRADE SERVICES MESSAGES"]
[null,"Data Element Name","SEG","Used in"]
[]
[null,null,null,"tsin.004.001.01","tsin.005.001.01","tsin.006.001.01","tsin.007.001.01","tsin.008.001.01","tsin.009.001.01","tsin.010.001.01","tsin.011.001.01","tsin.012.001.01","tsin.013.001.01","tsmt.009.001.05","tsmt.012.001.05","tsmt.014.001.05","tsmt.017.001.05","tsmt.018.001.05","tsmt.019.001.05","tsmt.044.001.02","tsmt.045.001.02","tsmt.053.001.01","tsmt.054.001.01","tsmt.055.001.01","tsrv.001.001.01","tsrv.002.001.01","tsrv.003.001.01","tsrv.004.001.01","tsrv.005.001.01","tsrv.006.001.01","tsrv.007.001.01","tsrv.008.001.01","tsrv.009.001.01","tsrv.010.001.01","tsrv.011.001.01","tsrv.012.001.01","tsrv.013.001.01","tsrv.014.001.01","tsrv.015.001.01","tsrv.016.001.01","tsrv.017.001.01","tsrv.018.001.01","tsrv.019.001.01","Last Publication Date"]
[1,"ExternalAccountIdentification1Code","Payments","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√",{"$nulls":13},"√",{"$nulls":6},"2009-06-09"]
[2,"ExternalBalanceSubType1Code","Payments",{"$nulls":40},"2011-05-31"]
[3,"ExternalCashClearingSystem1Code","Payments",{"$nulls":40},"2015-02-27"]
[4,"ExternalCategoryPurpose1Code","Payments","√",null,"√","√","√",{"$nulls":4},"√",{"$nulls":8},"√","√",{"$nulls":20},"2015-08-31"]
[5,"ExternalClearingSystemIdentification1Code ","Payments","√",null,"√","√","√","√","√","√","√","√",{"$nulls":8},"√","√","√",{"$nulls":12},"√",{"$nulls":4},"√","√","2014-01-16"]
[6,"ExternalFinancialInstitutionIdentification1Code","Payments","√",null,"√","√","√","√","√","√","√","√",{"$nulls":8},"√","√",{"$nulls":13},"√",{"$nulls":4},"√","√","2009-06-09"]
[7,"ExternalLocalInstrument1Code ","Payments","√",null,"√","√","√",{"$nulls":4},"√",{"$nulls":8},"√","√",{"$nulls":20},"2015-08-31"]
[8,"ExternalMandateReason1Code","Payments",{"$nulls":40},"2010-11-30"]
[9,"ExternalOrganisationIdentification1Code","Payments","√","√","√","√","√","√","√","√","√","√",{"$nulls":8},"√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","2011-02-17"]
[10,"ExternalPersonIdentification1Code","Payments","√","√","√","√","√","√","√","√","√","√",{"$nulls":8},"√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","2009-06-09"]
[11,"ExternalPurpose1Code ","Payments",{"$nulls":40},"2015-08-31"]
[12,"ExternalReportingSource1Code","Payments",{"$nulls":40},"2009-06-09"]
[13,"ExternalReturnReason1Code","Payments",{"$nulls":40},"2013-05-07"]
[14,"ExternalReversalReason1Code","Payments",{"$nulls":40},"2012-10-22"]
[15,"ExternalServiceLevel1Code","Payments","√",null,"√","√","√",{"$nulls":4},"√",{"$nulls":8},"√","√",{"$nulls":20},"2015-08-31"]
[16,"ExternalStatusReason1Code","Payments",{"$nulls":38},"√","√","2014-11-28"]
[17,"ExternalTechnicalInputChannel1Code","Payments",{"$nulls":40},"2009-06-09"]
[18,"ExternalVerificationReason1Code","Payments",{"$nulls":40},"2010-08-16"]
[19,"ExternalDocumentPurpose1Code","Trade","√",null,"√","√","√","√","√","√","√","√",{"$nulls":8},"√","√",{"$nulls":20},"2010-11-30"]
[20,"ExternalDocumentType1Code","Trade","√",null,"√","√","√","√","√","√","√","√",{"$nulls":8},"√","√","√",{"$nulls":19},"2010-11-30"]
[21,"ExternalIncoterms1Code","Trade","√",{"$nulls":9},"√","√","√","√","√","√",{"$nulls":24},"2014-02-21"]
[22,"ExternalInformationType1Code","Trade","√",{"$nulls":39},"2010-11-30"]
[23,"ExternalPackagingType1Code","Trade","√",{"$nulls":39},"2010-11-30"]
[24,"ExternalFinancialInstrumentIdentificationType1Code","Securities",{"$nulls":40},"2010-11-30"]
[25,"ExternalTradeTransactionConditions1Code","Securities",{"$nulls":40},"2011-08-31"]
[26,"ExternalChargeType1Code","Payments",{"$nulls":40},"2012-05-31"]
[27,"ExternalCashAccountType1Code","Payments",{"$nulls":10},"√","√","√","√","√","√","√","√",{"$nulls":22},"2012-05-31"]
[28,"ExternalDiscountAmountType1Code","Payments",{"$nulls":40},"2012-07-16"]
[29,"ExternalTaxAmountType1Code","Payments",{"$nulls":40},"2012-07-16"]
[30,"ExternalCardTransactionCategory1Code","Payments",{"$nulls":40},"2012-10-22"]
[31,"ExternalBillingBalanceType1Code","Payments",{"$nulls":40},"2012-10-22"]
[32,"ExternalBillingCompensationType1Code","Payments",{"$nulls":40},"2012-10-22"]
[33,"ExternalBillingRateIdentification1Code","Payments",{"$nulls":40},"2012-10-22"]
[34,"ExternalRePresentmentReason1Code","Cards",{"$nulls":40},"2013-02-07"]
[35,"ExternalChannel1Code","Trade",null,"√",{"$nulls":19},"√","√","√","√","√","√","√",{"$nulls":12},"2013-02-07"]
[36,"ExternalDateFrequency1Code","Trade",null,"√",{"$nulls":19},"√","√","√",{"$nulls":16},"2013-02-07"]
[37,"ExternalDocumentFormat1Code","Trade",null,"√",{"$nulls":19},"√","√","√","√","√","√","√",{"$nulls":4},"√","√","√",{"$nulls":4},"√","2013-02-07"]
[38,"ExternalModelFormIdentification1Code","Trade",null,"√",{"$nulls":19},"√","√","√",{"$nulls":16},"2013-02-07"]
[39,"ExternalNarrativeType1Code ","Trade",null,"√",{"$nulls":19},"√","√","√","√","√","√","√",{"$nulls":12},"2013-02-07"]
[40,"ExternalRelativeTo1Code","Trade",null,"√",{"$nulls":19},"√","√","√",{"$nulls":16},"2013-02-07"]
[41,"ExternalTypeOfParty1Code","Trade",null,"√",{"$nulls":19},"√","√","√","√","√","√","√",{"$nulls":12},"2013-02-07"]
[42,"ExternalUnderlyingTradeTransactionType1Code","Trade",null,"√",{"$nulls":19},"√","√","√",{"$nulls":16},"2013-02-07"]
[43,"ExternalUndertakingAmountType1Code","Trade",{"$nulls":39},"√","2013-02-07"]
[44,"ExternalUndertakingChargeType1Code","Trade",{"$nulls":39},"√","2013-02-07"]
[45,"ExternalUndertakingDocumentType1Code","Trade",null,"√",{"$nulls":19},"√","√","√","√","√","√","√",{"$nulls":4},"√","√","√",{"$nulls":4},"√","2013-02-07"]
[46,"ExternalUndertakingDocumentType2Code","Trade",null,"√",{"$nulls":19},"√","√","√",{"$nulls":16},"2013-02-07"]
[47,"ExternalUndertakingStatusCategory1Code","Trade",{"$nulls":39},"√","2013-02-07"]
[48,"ExternalUndertakingType1Code","Trade",null,"√",{"$nulls":19},"√","√","√",{"$nulls":16},"2013-02-07"]
[49,"ExternalDocumentLineType1Code","Payments",{"$nulls":40},"2014-04-17"]
[50,"ExternalGarnishmentType1Code","Payments",{"$nulls":40},"2014-04-17"]
[51,"ExternalTradeMarket1Code","Trade",null,null,"√","√","√","√","√","√","√","√",{"$nulls":8},"√","√",{"$nulls":20},"2015-04-28"]
[52,"ExternalMandateSetupReason1Code","Payments",{"$nulls":40},"2015-08-31"]
[null,"ExternalBankTransactionDomain1Code 1","Payments",{"$nulls":40},"2015-08-31"]
[null,"ExternalBankTransactionFamily1Code 1"]
[null,"ExternalBankTransactionSubFamily1Code 1"]
[null,"Legend"]
[null,"1.  The Bank Transaction Code documentation is available separately on ISO20022.org"]
[]
[null," Items in a code list should have 7 attributes:"]
[null,"1)     Code value"]
[null,"2)     Name "]
[null,"3)     Definition "]
[null,"4)     Origin/requester "]
[null,"5)     Status "]
[null,"6)     Status date"]
[null,"7)     Introduced date "]
[]
[null,"Code Statuses are:"]
[null,"New: introduction of a new code\nNew. Replaces code ABC: introduction of a new code to replace a code that has been retired\nDefinition updated: definition of the code has been modified\nRetired. Replaced by ABC.  Do not use: the code is not in use anymore"]

{"sheet":"SECURITIES","index":3,"n_rows":73,"n_cols":70,"rows_kept":73,"cut":false,"hidden":false,"merged":[[56,2,58,2],[56,69,58,69],[0,0,0,25],[1,1,3,1],[1,2,3,2],[1,69,2,69],[1,3,2,66]],"flags":["formulas_cached_only"]}
["OVERVIEW EXTERNAL CODE SETS USED IN SECURITIES MESSAGES"]
[null,"Data Element Name","SEG","Used in"]
[]
[null,null,null,"colr.007.001.03","colr.008.001.03","colr.010.001.03","colr.016.001.02","secl.001.001.03","secl.002.001.03","secl.003.001.03","secl.004.001.03","secl.005.001.02","secl.006.001.02","secl.007.001.03","secl.008.001.03","secl.009.001.03","secl.010.001.03 ","seev.001.001.05","seev.002.001.05","seev.003.001.05","seev.004.001.05","seev.005.001.05","seev.006.001.05","seev.007.001.05","seev.008.001.05","seev.031.001.05 ","seev.033.001.05","seev.034.001.06","seev.035.001.06","seev.036.001.06","seev.037.001.06","seev.038.001.03","seev.039.001.05","seev.040.001.05","seev.041.001.05","seev.042.001.04","seev.044.001.05","semt.002.001.08","semt.003.001.08","semt.013.001.03","semt.014.001.03","semt.015.001.04","semt.016.001.04","semt.017.001.05","semt.018.001.06","semt.019.001.04","semt.021.001.05","semt.022.001.02","semt.024.001.01","sese.020.001.04","sese.023.001.05","sese.024.001.06","sese.025.001.05","sese.026.001.04","sese.027.001.04","sese.028.001.04","sese.029.001.03","sese.030.001.05","sese.032.001.05","sese.033.001.05","sese.034.001.05","sese.035.001.05","sese.036.001.04","sese.037.001.03","sese.038.001.03","sese.039.001.03","sese.040.001.01","setr.027.001.03","setr.044.001.02","Last Publication Date"]
[1,"ExternalAccountIdentification1Code","Payments","√","√","√",{"$nulls":6},"√",{"$nulls":56},"2009-06-09"]
[2,"ExternalBalanceSubType1Code","Payments",{"$nulls":66},"2011-05-31"]
[3,"ExternalCashClearingSystem1Code","Payments",{"$nulls":66},"2015-02-27"]
[4,"ExternalCategoryPurpose1Code","Payments",{"$nulls":66},"2015-08-31"]
[5,"ExternalClearingSystemIdentification1Code ","Payments",{"$nulls":66},"2014-01-16"]
[6,"ExternalFinancialInstitutionIdentification1Code","Payments",{"$nulls":66},"2009-06-09"]
[7,"ExternalLocalInstrument1Code ","Payments",{"$nulls":66},"2015-08-31"]
[8,"ExternalMandateReason1Code","Payments",{"$nulls":66},"2010-11-30"]
[9,"ExternalOrganisationIdentification1Code","Payments",{"$nulls":44},"√",{"$nulls":21},"2011-02-17"]
[10,"ExternalPersonIdentification1Code","Payments",{"$nulls":66},"2009-06-09"]
[11,"ExternalPurpose1Code ","Payments",{"$nulls":66},"2015-08-31"]
[12,"ExternalReportingSource1Code","Payments",{"$nulls":66},"2009-06-09"]
[13,"ExternalReturnReason1Code","Payments",{"$nulls":66},"2013-05-07"]
[14,"ExternalReversalReason1Code","Payments",{"$nulls":66},"2012-10-22"]
[15,"ExternalServiceLevel1Code","Payments",{"$nulls":66},"2015-08-31"]
[16,"ExternalStatusReason1Code","Payments",{"$nulls":66},"2014-11-28"]
[17,"ExternalTechnicalInputChannel1Code","Payments",{"$nulls":66},"2009-06-09"]
[18,"ExternalVerificationReason1Code","Payments",{"$nulls":66},"2010-08-16"]
[19,"ExternalDocumentPurpose1Code","Trade",{"$nulls":66},"2010-11-30"]
[20,"ExternalDocumentType1Code","Trade",{"$nulls":66},"2010-11-30"]
[21,"ExternalIncoterms1Code","Trade",{"$nulls":66},"2014-02-21"]
[22,"ExternalInformationType1Code","Trade",{"$nulls":66},"2010-11-30"]
[23,"ExternalPackagingType1Code","Trade",{"$nulls":66},"2010-11-30"]
[24,"ExternalFinancialInstrumentIdentificationType1Code","Securities","√",null,"√","√","√","√","√","√","√",null,"√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√",null,"√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","2010-11-30"]
[25,"ExternalTradeTransactionCondition1Code","Securities",{"$nulls":64},"√","√","2011-08-31"]
[26,"ExternalChargeType1Code","Payments",{"$nulls":66},"2012-05-31"]
[27,"ExternalCashAccountType1Code","Payments",{"$nulls":66},"2012-05-31"]
[28,"ExternalDiscountAmountType1Code","Payments",{"$nulls":66},"2012-07-16"]
[29,"ExternalTaxAmountType1Code","Payments",{"$nulls":66},"2012-07-16"]
[30,"ExternalCardTransactionCategory1Code","Payments",{"$nulls":66},"2012-10-22"]
[31,"ExternalBillingBalanceType1Code","Payments",{"$nulls":66},"2012-10-22"]
[32,"ExternalBillingCompensationType1Code","Payments",{"$nulls":66},"2012-10-22"]
[33,"ExternalBillingRateIdentification1Code","Payments",{"$nulls":66},"2012-10-22"]
[34,"ExternalRePresentmentReason1Code","Cards",{"$nulls":66},"2013-02-07"]
[35,"ExternalChannel1Code","Trade",{"$nulls":66},"2013-02-07"]
[36,"ExternalDateFrequency1Code","Trade",{"$nulls":66},"2013-02-07"]
[37,"ExternalDocumentFormat1Code","Trade",{"$nulls":66},"2013-02-07"]
[38,"ExternalModelFormIdentification1Code","Trade",{"$nulls":66},"2013-02-07"]
[39,"ExternalNarrativeType1Code ","Trade",{"$nulls":66},"2013-02-07"]
[40,"ExternalRelativeTo1Code","Trade",{"$nulls":66},"2013-02-07"]
[41,"ExternalTypeOfParty1Code","Trade",{"$nulls":66},"2013-02-07"]
[42,"ExternalUnderlyingTradeTransactionType1Code","Trade",{"$nulls":66},"2013-02-07"]
[43,"ExternalUndertakingAmountType1Code","Trade",{"$nulls":66},"2013-02-07"]
[44,"ExternalUndertakingChargeType1Code","Trade",{"$nulls":66},"2013-02-07"]
[45,"ExternalUndertakingDocumentType1Code","Trade",{"$nulls":66},"2013-02-07"]
[46,"ExternalUndertakingDocumentType2Code","Trade",{"$nulls":66},"2013-02-07"]
[47,"ExternalUndertakingStatusCategory1Code","Trade",{"$nulls":66},"2013-02-07"]
[48,"ExternalUndertakingType1Code","Trade",{"$nulls":66},"2013-02-07"]
[49,"ExternalDocumentLineType1Code","Payments",{"$nulls":66},"2014-04-17"]
[50,"ExternalGarnishmentType1Code","Payments",{"$nulls":66},"2014-04-17"]
[51,"ExternalTradeMarket1Code","Trade",{"$nulls":66},"2014-04-28"]
[52,"ExternalMandateSetupReason1Code","Payments",{"$nulls":66},"2015-08-31"]
[null,"ExternalBankTransactionDomain1Code 1","Payments",{"$nulls":66},"2015-08-31"]
[null,"ExternalBankTransactionFamily1Code 1"]
[null,"ExternalBankTransactionSubFamily1Code 1"]
[null,"Legend"]
[null,"1.  The Bank Transaction Code documentation is available separately on ISO20022.org"]
[]
[null," Items in a code list should have 7 attributes:"]
[null,"1)     Code value"]
[null,"2)     Name "]
[null,"3)     Definition "]
[null,"4)     Origin/requester "]
[null,"5)     Status "]
[null,"6)     Status date"]
[null,"7)     Introduced date "]
[]
[null,"Code Statuses are:"]
[null,"New: introduction of a new code\nNew. Replaces code ABC: introduction of a new code to replace a code that has been retired\nDefinition updated: definition of the code has been modified\nRetired. Replaced by ABC.  Do not use: the code is not in use anymore"]

{"sheet":"CARDS","index":4,"n_rows":74,"n_cols":8,"rows_kept":74,"cut":false,"hidden":false,"merged":[[1,1,3,1],[1,2,3,2],[1,7,2,7],[56,2,58,2],[56,7,58,7],[1,3,2,6]],"flags":["formulas_cached_only"]}
[null,"OVERVIEW EXTERNAL CODE SETS USED IN CARDS MESSAGES"]
[null,"Data Element Name","SEG","Used in"]
[]
[null,null,null,"caaa.001.001.04","caaa.003.001.04","caaa.011.001.04","supl.017.001.01","Last Publication Date"]
[1,"ExternalAccountIdentification1Code","Payments",null,null,null,"√","2009-06-09"]
[2,"ExternalBalanceSubType1Code","Payments",{"$nulls":4},"2011-05-31"]
[3,"ExternalCashClearingSystem1Code","Payments",{"$nulls":4},"2015-02-27"]
[4,"ExternalCategoryPurpose1Code","Payments",{"$nulls":4},"2015-08-31"]
[5,"ExternalClearingSystemIdentification1Code ","Payments",{"$nulls":4},"2014-01-16"]
[6,"ExternalFinancialInstitutionIdentification1Code","Payments",{"$nulls":4},"2009-06-09"]
[7,"ExternalLocalInstrument1Code ","Payments",{"$nulls":4},"2015-08-31"]
[8,"ExternalMandateReason1Code","Payments",{"$nulls":4},"2010-11-30"]
[9,"ExternalOrganisationIdentification1Code","Payments",{"$nulls":4},"2011-02-17"]
[10,"ExternalPersonIdentification1Code","Payments","√","√","√",null,"2009-06-09"]
[11,"ExternalPurpose1Code ","Payments",{"$nulls":4},"2015-08-31"]
[12,"ExternalReportingSource1Code","Payments",{"$nulls":4},"2009-06-09"]
[13,"ExternalReturnReason1Code","Payments",{"$nulls":4},"2013-05-07"]
[14,"ExternalReversalReason1Code","Payments",{"$nulls":4},"2012-10-22"]
[15,"ExternalServiceLevel1Code","Payments",{"$nulls":4},"2015-08-31"]
[16,"ExternalStatusReason1Code","Payments",{"$nulls":4},"2014-11-28"]
[17,"ExternalTechnicalInputChannel1Code","Payments",{"$nulls":4},"2009-06-09"]
[18,"ExternalVerificationReason1Code","Payments",{"$nulls":4},"2010-08-16"]
[19,"ExternalDocumentPurpose1Code","Trade","√","√","√",null,"2010-11-30"]
[20,"ExternalDocumentType1Code","Trade","√","√","√",null,"2010-11-30"]
[21,"ExternalIncoterms1Code","Trade","√","√","√",null,"2014-02-21"]
[22,"ExternalInformationType1Code","Trade","√","√","√",null,"2010-11-30"]
[23,"ExternalPackagingType1Code","Trade","√","√","√",null,"2010-11-30"]
[24,"ExternalFinancialInstrumentIdentificationType1Code","Securities",{"$nulls":4},"2010-11-30"]
[25,"ExternalTradeTransactionConditions1Code","Securities",{"$nulls":4},"2011-08-31"]
[26,"ExternalChargeType1Code","Payments",{"$nulls":4},"2012-05-31"]
[27,"ExternalCashAccountType1Code","Payments",null,null,null,"√","2012-05-31"]
[28,"ExternalDiscountAmountType1Code","Payments",{"$nulls":4},"2012-07-16"]
[29,"ExternalTaxAmountType1Code","Payments",{"$nulls":4},"2012-07-16"]
[30,"ExternalCardTransactionCategory1Code","Payments",{"$nulls":4},"2012-10-22"]
[31,"ExternalBillingBalanceType1Code","Payments",{"$nulls":4},"2012-10-22"]
[32,"ExternalBillingCompensationType1Code","Payments",{"$nulls":4},"2012-10-22"]
[33,"ExternalBillingRateIdentification1Code","Payments",{"$nulls":4},"2012-10-22"]
[34,"ExternalRePresentmentReason1Code","Cards",null,null,null,"√","2013-02-07"]
[35,"ExternalChannel1Code","Trade",{"$nulls":4},"2013-02-07"]
[36,"ExternalDateFrequency1Code","Trade",{"$nulls":4},"2013-02-07"]
[37,"ExternalDocumentFormat1Code","Trade",{"$nulls":4},"2013-02-07"]
[38,"ExternalModelFormIdentification1Code","Trade",{"$nulls":4},"2013-02-07"]
[39,"ExternalNarrativeType1Code ","Trade",{"$nulls":4},"2013-02-07"]
[40,"ExternalRelativeTo1Code","Trade",{"$nulls":4},"2013-02-07"]
[41,"ExternalTypeOfParty1Code","Trade",{"$nulls":4},"2013-02-07"]
[42,"ExternalUnderlyingTradeTransactionType1Code","Trade",{"$nulls":4},"2013-02-07"]
[43,"ExternalUndertakingAmountType1Code","Trade",{"$nulls":4},"2013-02-07"]
[44,"ExternalUndertakingChargeType1Code","Trade",{"$nulls":4},"2013-02-07"]
[45,"ExternalUndertakingDocumentType1Code","Trade",{"$nulls":4},"2013-02-07"]
[46,"ExternalUndertakingDocumentType2Code","Trade",{"$nulls":4},"2013-02-07"]
[47,"ExternalUndertakingStatusCategory1Code","Trade",{"$nulls":4},"2013-02-07"]
[48,"ExternalUndertakingType1Code","Trade",{"$nulls":4},"2013-02-07"]
[49,"ExternalDocumentLineType1Code","Payments",{"$nulls":4},"2014-04-17"]
[50,"ExternalGarnishmentType1Code","Payments",{"$nulls":4},"2014-04-17"]
[51,"ExternalTradeMarket1Code","Trade",{"$nulls":4},"2015-04-28"]
[52,"ExternalMandateSetupReason1Code","Payments",{"$nulls":4},"2015-08-31"]
[null,"ExternalBankTransactionDomain1Code 1","Payments",{"$nulls":4},"2015-08-31"]
[null,"ExternalBankTransactionFamily1Code 1"]
[null,"ExternalBankTransactionSubFamily1Code 1"]
[null,"Legend"]
[null,"1.  The Bank Transaction Code documentation is available separately on ISO20022.org"]
[]
[null," Items in a code list should have 7 attributes:"]
[null,"1)     Code value"]
[null,"2)     Name "]
[null,"3)     Definition "]
[null,"4)     Origin/requester "]
[null,"5)     Status "]
[null,"6)     Status date"]
[null,"7)     Introduced date "]
[]
[]
[null,"Code Statuses are:"]
[null,"New: introduction of a new code\nNew. Replaces code ABC: introduction of a new code to replace a code that has been retired\nDefinition updated: definition of the code has been modified\nRetired. Replaced by ABC.  Do not use: the code is not in use anymore"]

{"sheet":"1-AccountIdentification","index":5,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,5,2,8],[1,0,1,8]],"flags":["formulas_cached_only"]}
[]
["ExternalAccountIdentification1Code"]
["Identification",null,null,null,"Information/Details","Status"]
[null,"\nCode","\nName","\nDefinition",null,"Origin/Requester","Status","Status Date","Introduced Date"]
[1,"BBAN","BBANIdentifier","Basic Bank Account Number (BBAN) - identifier used nationally by financial institutions, ie, in individual countries, generally as part of a National Account Numbering Scheme(s), to uniquely identify the account of a customer.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[2,"CUID","CHIPSUniversalIdentifier","(United States) Clearing House Interbank Payments System (CHIPS) Universal Identification (UID) - identifies entities that own accounts at CHIPS participating financial institutions, through which CHIPS payments are effected. The CHIPS UID is assigned by the New York Clearing House.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[3,"UPIC","UPICIdentifier","Universal Payment Identification Code (UPIC) - identifier used by the New York Clearing House to mask confidential data, such as bank accounts and bank routing numbers. UPIC numbers remain with business customers, regardless of banking relationship changes.",null,"Maintenance SR2009","New","April 2009","April 2009"]

{"sheet":"2-BalanceSubType","index":6,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,5,2,8],[1,0,1,8]],"flags":["formulas_cached_only"]}
[]
["ExternalBalanceSubType1Code"]
["Identification",null,null,null,"Information/Details","Status"]
[null,"\nCode","\nName","\nDefinition",null,"Origin/Requester","Status","Status Date","Introduced Date"]
[1,"ADJT","Adjustment ","Balance to be held in the settlement account in order to comply with the average reserve due, in the event that the bank's balance is equal to the reserve due during the remaining days of the maintenance period.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[2,"BCUR","BaseCurrency","Balance representing the amount in the domestic or base accounting currency. ",null,"Maintenance SR2009","New","April 2009","April 2009"]
[3,"BLCK","Blocked","Balance representing the regulatory reserve that a financial institution must have with the account servicing institution, eg, the minimum credit balance a financial institution is to keep with its Central Bank for mandatory reserve purposes. In some countries, a blocked balance is known as a 'reserve' balance.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[4,"BLKD","Blocked Funds","Balance representing funds that cannot be touched by the account owner.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[5,"DLOD","DaylightOverdraft","Balance representing the intra day overdraft granted by the Central Bank to financial institutions participating in a RTGS system. This balance may vary over time and shall be offset at the end of the day.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[6,"EAST","EligibleAssets","Balance representing the potential loan a Central Bank would make in cash if the collateral is pledged, eg, securities available and eligible as collateral with the Central Bank.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[7,"FCOL","Firm collateralization","Balance representing the forecast of the cash-equivalent resulting from evaluation of existing holdings at CSD that are qualified to serve as collateral.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[8,"FCOU","Amounts that have been used to serve as firm collateral","Balance representing the cash equivalent resulting from evaluation of existing holdings at CSD that are qualified to serve as collateral and have been used as collateral.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[9,"FORC","SecuritiesForecast","Balance representing the total of all balance types representing the forecast of transactions to settle, blocked items, custody transactions and corporate actions cash disbursements.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[10,"FUND","NetFunding","Balance representing the net amount to be funded resulting from the difference between the total of all transactions with a cash impact and the existing cash coverage.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[11,"INTM","Intermediate","Balance representing an intermediate amount such as the opening or closing balance incrementally carried forward from one page to the next in a multi-page statement or report.",null,"CR0058/CGI","New","14 Feb 2011","14 Feb 2011"]
[12,"LCUR","LocalCurrency","Balance representing the amount in the local market currency for which the asset is held. ",null,"Maintenance SR2009","New","April 2009","April 2009"]
[13,"LRLD","LimitRelated","Balance of a specific limit value, eg, a bilateral balance is calculated in relation to a given bilateral limit.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[14,"NOTE","Reserved liquidity","Balance representing the amount that a financial institution has set aside for a specific reason and which is therefore not available. In the context of CSDs, reservation of liquidity made to meet settlement obligations.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[15,"PDNG","SecuritiesPending","Balance of securities pending delivery, such as orders to sell securities have been executed but settlement of the open transactions has not been confirmed.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[16,"PIPO","PayInPayOut","Balance representing the fictive amount of automated direct debits or payment based on standing arrangements between the CSD and the user. Usage: Pay-Ins and Pay-Outs can be different based on individual payment instructions or available funds.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[17,"PRAV","ProgressiveAverage","Average of the daily balances on the account used to fulfil the reserve requirements calculated from the beginning of the maintenance period.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[18,"RESV","Reserve ","Balance representing the regulatory reserve that a financial institution must have with the account servicing institution, eg, the minimum credit balance a financial institution is to keep with its Central Bank for mandatory reserve purposes. ",null,"Maintenance SR2009","New","April 2009","April 2009"]
[19,"SCOL","Self-collateralization","Balance representing the forecast of the cash-equivalent resulting from evaluation of the net incoming balance of securities qualified to serve as collateral for which settlement instructions are held at.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[20,"SCOU","Amounts that have been used to serve as self collateral","Balance representing the cash-equivalent resulting from evaluation of incoming securities, qualified to serve as collateral and actually used as collateral, which have been settled during the settlement process. ",null,"Maintenance SR2009","New","April 2009","April 2009"]
[21,"THRE","Threshold","Balance representing the amount that will be destined for investment. Difference between available balance and threshold for investment limit.",null,"Maintenance SR2009","New","April 2009","April 2009"]

{"sheet":"3-CashClearingSystem","index":7,"n_rows":93,"n_cols":10,"rows_kept":93,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,5,2,8],[1,0,1,8]],"flags":["formulas_cached_only"]}
[]
["ExternalCashClearingSystem1Code"]
["Identification",null,null,null,"Information/Details","Status"]
[null,"\nCode","\nName","\nDefinition",null,"Origin/Requester","Status","Status Date","Introduced Date"]
[1,"ABE","EBAEuro1Step1","EBA Euro1/Step1.",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[2,"ACH","ACH","Automated Clearing House. Payment system that clears cash transfers and settles the proceeds in a lump sum, usually on a multilateral netting basis.",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[3,"ACS","Canada","Canadian Dollar (CAD)  - Automated Clearing Settlement System (ACSS) ",null,"CR0310, CPA","New","16 January 2014","16 January 2014",1]
[4,"AIP","Albania","AL (Albania) -  Albania Interbank Payment System.",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[5,"ART","Austrian","AT (Austria) - Austrian RTGS (ARTIS).",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[6,"AVP","NewZealand","NZ (New Zealand) - New Zealand Assured Value Payments.",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[7,"AZM","Azerbaijan","AZ (Azerbaijan) - Azerbaijan Interbank Payment System (AZIPS).",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[8,"BAP","BosniaHerzegovina","BA (Bosnia and Herzegovina).",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[9,"BCC","SwedenBGC","SE (Sweden) - Sweden BGC Clearing CUG.",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[10,"BCE","Ecuador","EC (Ecuador) - Ecuadorian Central Payment System (Sistema Central de Pagos Ecuatoriano)",null,"CR0315, Banco Central del Ecuador ","New","13 June 2014","13 June 2014",1]
[11,"BDS","Barbados","BB (Barbados) - Barbados RTGS (CBRTGS).",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[12,"BEL","Belgium","BE (Belgium) - Belgium RTGS (ELLIPS).",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[13,"BGN","Bulgaria","BG (Bulgaria) - Bulgaria RTGS.",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[14,"BHS","Bahamas","BS (Bahamas) - Bahamas RTGS.",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[15,"BIS","Botswana","BW (Botswana) - Botswana Interbank Settlement System.",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[16,"BOF","Finland","FI (Finland) - RTGS (BOF).",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[17,"BOJ","BankOfJapanNet","the Bank of Japan clearing system.",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[18,"BRL","Italy","IT (Italy) - Italy RTGS (BIREL).",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[19,"BSP","Philippines","PH (Philippines) - Philippines Payment System.",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[20,"CAD","Canada","CA (Canada) - Canadian Large Value Transfer System (LVTS)",null,"CR0310, CPA","Retired.  Replaced by LVT.  Do not use.","16 January 2014","April 2009",1]
[21,"CAM","SpainCAM","ES (Spain).",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[22,"CBJ","Ireland","IE (Ireland) - Irish RTGS (IRIS).",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[23,"CHI ","USTCHChips ","US - The Clearing House CHIPS",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[24,"CHP","UnitedKingdom","GB (UK) - British Euro RTGS (CHAPS).",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[25,"CIS","Central Interoperability Service","Central Interoperability Service of the EACHA Clearing Cooperative, for exchanging SEPA payments between Automated Clearing Houses in the EEA.",null,"CR0464, Equens (NL)","New","27 February 2015","27 February 2015"]
[26,"COE","Columbia","CO (Columbia) - Colombian Electronic Cheque System named CEDEC (Compensación Electrónica De Cheques).",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[27,"COI","Columbia","CO (Columbia) - Colombian Central Bank´s ACH named CENIT (Compensación Electrónica Nacional Interbancaria).",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[28,"COU","Columbia","CO (Columbia) - Colombian RTGS System named CUD (Cuentas de Depósito).",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[29,"DDK","DenmarkDDK","DK (Denmark) - Danish Krone RTGS (KRONOS)",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[30,"DKC","Denmark","DK (Denmark) - Danish Euro RTGS (KRONOS)",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[31,"EBA","EBAEuro1","EBA Euro1.",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[32,"ELS","GermanyELS","DE (Germany).",null,"Maintenance SR2009/Errata","New","31 July 2014","April 2009",1]
[33,"EMZ","Germany","Elektronischer Massenzahlungsverkehr (EMZ)","DE (Germany) – retail payment system operated by the Deutsche Bundesbank ","CR0385, Deutsche Bundesbank","New. Replaces SCL","13 June 2014","13 June 2014",1]
[34,"EPM","ECB","ECB (European Central Bank) - ECB Payment Mechanism.",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[35,"EPN ","USTCHEPN ","US - The Clearing House EPN",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[36,"ERP","EBAStep1","EBA step 1 (members).",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[37,"FDA ","USFedACH ","US (United States) - FED-ACH",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[38,"FDN","FedNet","FedNet is a link to a Federal Bank account via the internet.  FedNet enables checking of account balance, transactions, take print outs of account statement, transfer funds to third party accounts, E-shopping, BSNL Payments, Deposit opening, Deposit Renewal, Request for Demand Draft, Cheque Book etc.",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[39,"FDW ","USFedwire ","US (United States) – FEDWIRE",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[40,"FEY","ForeignExchangeYenClearing","JP (Japan) the Foreign Exchange Yen Clearing system (FEYCS). It is the Japanese electronic interbank system for sending guaranteed and unconditional yen payments of FX deals for same day settlement from one settlement bank, on behalf of itself or its customers, to another settlement bank.",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[41,"GIS","Ghana","GH (Ghana) - Ghana Interbank Settlement System (GISS).",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[42,"HRK","Croatia","HR (Croatia) - HSVP.",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[43,"HRM","Greece","GR (Greece) - Greek RTGS (HERMES).",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[44,"HUF","Hungary","HU (Hungary) - VIBER.",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[45,"INC ","DEandNLEquens ","DE and NL - Equens ",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[46,"JOD","Jordan","JO (Jordan) - Jordan RTGS.",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[47,"KPS","Kenya","KE (Kenya) - Kenyan Electronic Payment Settlement System.",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[48,"LGS","Luxemburg","LU (Luxemburg) - Luxembourg RTGS (LIPS).",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[49,"LKB","SriLanka","LK (Sri Lanka) - Sri Lanka (Lankasettle).",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[50,"LVL","Latvia","LV (Latvia).",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[51,"LVT","Canada","CA (Canada) - Large Value Transfer System (LVTS).  Replaces CAD.",null,"CR0310, CPA","New","16 January 2014","16 January 2014",1]
[52,"MEP","Singapore","SG (Singapore) - Singapore RTGS (MEPS+).",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[53,"MOS","SouthAfrica","ZA (South Africa) - South-African Multiple Option Settlement.",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[54,"MRS","Malta","MT (Malta) - Malta Realtime Interbank Settlement System.",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[55,"MUP","Mauritius","MU (Mauritius).",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[56,"NAM","Namibia","NA (Namibian) - Namibian Interbank Settlement System.",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[57,"NOC","Norway","NO (Norway).",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[58,"PCH","Switzerland","CH (Switzerland).",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[59,"PDS","Australia","AU (Australia).",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[60,"PEG","Egypt","EG (Egypt).",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[61,"PNS","FrancePNS","FR (France).",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[62,"PTR","Angola","AO (Angola) - Angola RTGS.",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[63,"PVE","Venezuela","Ve (Venezuela).",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[64,"ROL","RomaniaEPO","RO (Romania) - Romanian Electronic Payment Operations RT.",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[65,"ROS","RomaniaGSRS","RO (Romania) - Romanian GSRS.",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[66,"RTG","RTGS","Real Time Gross Settlement System. Payment system that simultaneously clears individual transfers and settles them in central bank money.",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[67,"RTP","GermanyRTGSPlus","DE (Germany).",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[68,"SCL","RPS SEPA-Clearer ","DE – SEPA-Clearer of the Retail Payment System operated by Deutsche Bundesbank",null,"Deutsche Bundesbank (2Q2010-CR0015)\nCR0385, Deutsche Bundesbank","Retired.  Replaced by EMZ.  Do not use.","13 June 2014","August 2010",1]
[69,"SCP","Chili","CL (Chile) - Chilean Interbank Payment System.",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[70,"SEC","SwedenSEC","SE (Sweden) - Swedish Euro RTGS (SEC).",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[71,"SIT","Slovania","SI (Slovenia).",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[72,"SLB","SpainES","ES (Spain) - Spanish RTGS (SLBE).",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[73,"SPG","Portugal","PT (Portugal) - Portuguese RTGS (SPGT).",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[74,"SSK","SwedenSSK","SE (Sweden) - SEK RTGS (RIX).",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[75,"ST2","EBAStep2","EBA Clearing STEP 2",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[76,"STG","UnitedKingdomGBP","UK (United Kingdom) - CHAPS Sterling RTGS.",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[77,"TBF","FranceFR","FR (France) - French RTGS (TBF).",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[78,"TGT","Target","Target.",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[79,"THB","Thailand","TH (Thailand) - Thailand Payment System (Bahtnet/2).",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[80,"TIS","Tanzania","TZ (Tanzania) - Tanzania Interbank Settlement System (TISS).",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[81,"TOP","Netherlands","NL (Netherlands) - Dutch RTGS (TOP) ",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[82,"TTD","TrinidadAndTobago","TT (Trinidad and Tobago ) - Trinidad and Tobago SAFE-TT.",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[83,"UBE","Canada","United States Dollar  (USD) – US Bulk Exchange Clearing System (USBE)",null,"CR0310, CPA","New","16 January 2014","16 January 2014",1]
[84,"UIS","Uganda","UG (Uganda) - Uganda National Interbank Settlement System.",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[85,"VCS","VocaLink","VocaLink Clearing System",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[86,"XCT","EBAStep2","EBA step 2.",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[87,"ZEN","Zengin","JP (Japan) the Zengin system. The electronic payment system for domestic third party transfers managed by the Tokyo Bankers Association.",null,"Maintenance SR2009","New","April 2009","April 2009",1]
[88,"ZET","Zimbabwe","ZW (Zimbabwe) - Zimbabwe Electronic Transfer & Settlement System.",null,"Maintenance SR2009","New","April 2009","April 2009",2]
[89,"ZIS","Zambia","ZM (Zambia) - Zambian Interbank Payment &Settlement System.",null,"Maintenance SR2009","New","April 2009","April 2009",2]

{"sheet":"4-CategoryPurpose","index":8,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,5,2,8],[1,0,1,8],[34,2,34,8],[34,0,34,1]],"flags":["formulas_cached_only"]}
[]
["ExternalCategoryPurpose1Code"]
["Identification",null,null,null,"Information/Details","Status"]
[null,"\nCode","\nName","\nDefinition",null,"Origin/Requester","Status","Status Date","Introduced Date"]
[1,"BONU","BonusPayment","Transaction is the payment of a bonus.",null,"CR0156/CGI Group","New","9 February 2012","9 February 2012"]
[2,"CASH","CashManagementTransfer","Transaction is a general cash management instruction.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[3,"CBLK","Card Bulk Clearing"," A Service that is settling money for a bulk of card transactions, while referring to a specific transaction file or other information like terminal ID, card acceptor ID or other transaction details."," A Service that is settling money for a bulk of card transactions, while referring to a specific transaction file or other information like terminal ID, card acceptor ID or other transaction details.","CodeEval 3Q2012 CR0251-Berlin Group.","New","08 Oct 2012","08 Oct 2012"]
[4,"CCRD","Credit Card Payment","Transaction is related to a payment of credit card.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[5,"CORT","TradeSettlementPayment","Transaction is related to settlement of a trade, eg a foreign exchange deal or a securities transaction.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[6,"DCRD","Debit Card Payment","Transaction is related to a payment of debit card.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[7,"DIVI","Dividend","Transaction is the payment of dividends.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[8,"DVPM","DeliverAgainstPayment","Code used to pre-advise the account servicer of a forthcoming deliver against payment instruction.",null,"CR0466/SEB","New","31 August 2015","31 August 2015"]
[9,"EPAY","Epayment","Transaction is related to ePayment.",null,"CR0462/STUZZA","Updated","2014-12-26","23 May 2011"]
[10,"FCOL","Fee Collection","A Service that is settling card transaction related fees between two parties."," A Service that is settling card transaction related fees between two parties.","CodeEval 3Q2012 CR0251-Berlin Group.","New","08 Oct 2012","08 Oct 2012"]
[11,"GOVT","GovernmentPayment","Transaction is a payment to or from a government department.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[12,"HEDG","Hedging","Transaction is related to the payment of a hedging operation.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[13,"ICCP","Irrevocable Credit Card Payment","Transaction is reimbursement of credit card payment.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[14,"IDCP","Irrevocable Debit Card Payment","Transaction is reimbursement of debit card payment.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[15,"INTC","IntraCompanyPayment","Transaction is an intra-company payment, ie, a payment between two companies belonging to the same group.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[16,"INTE","Interest","Transaction is the payment of interest.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[17,"LOAN","Loan","Transaction is related to the transfer of a loan to a borrower.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[18,"OTHR","OtherPayment","Other payment purpose.",null,"CR0156/CGI Group","New","9 February 2012","9 February 2012"]
[19,"PENS","PensionPayment","Transaction is the payment of pension.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[20,"RVPM","ReceiveAgainstPayment","Code used to pre-advise the account servicer of a forthcoming receive against payment instruction.",null,"CR0466/SEB","New","31 August 2015","31 August 2015"]
[21,"SALA","SalaryPayment","Transaction is the payment of salaries.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[22,"SECU","Securities","Transaction is the payment of securities.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[23,"SSBE","SocialSecurityBenefit","Transaction is a social security benefit, ie payment made by a government to support individuals.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[24,"SUPP","SupplierPayment","Transaction is related to a payment to a supplier.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[25,"TAXS","TaxPayment","Transaction is the payment of taxes.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[26,"TRAD","Trade","Transaction is related to the payment of a trade finance transaction.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[27,"TREA","TreasuryPayment","Transaction is related to treasury operations.  E.g. financial contract settlement.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[28,"VATX","ValueAddedTaxPayment","Transaction is the payment of value added tax.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[29,"WHLD","WithHolding","Transaction is the payment of withholding tax.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[]
["Usage Rules:",null," * If the tag is present, and no specific code is required, SUPP is the recommended default."]
[null,null," * The more specific code is the one which should be used.  "]
[null,null,"E.g. if a payment is to a government for withholding tax, relevant codes would include GOVT, TAXS, and WHLD.  WHLD would be the preferred code here."]

{"sheet":"5-ClearingSystemIdentification","index":9,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,7,2,10],[2,4,2,6],[1,0,1,10]],"flags":["formulas_cached_only"]}
[]
["ExternalClearingSystemIdentification1Code"]
["Identification",null,null,null,"Information/Details",null,null,"Status"]
[null,"\nCode","\nName","\nDefinition","Country","Bank Identifier [CharacterType] {Length}","Example","\nOrigin/Requester","Status","Status Date","Introduced Date"]
[1,"ATBLZ","Austrian Bankleitzahl","Bank Branch code used in Austria","Austria","[0-9]{5,5}",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[2,"AUBSB","Australian Bank State Branch Code (BSB)","Bank Branch code used in Australia","Australia","[0-9]{6,6}",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[3,"CACPA","Canadian Payments Association Payment Routing Number","Bank Branch code used in Canada","Canada","[0-9]{9,9}",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[4,"CHBCC","Swiss Clearing Code (BC Code)","Bank Clearing number used in Switzerland ","Switzerland","[0-9]{3,5}",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[5,"CHSIC","Swiss Clearing Code (SIC Code)","Bank Branch code used in clearing with Swiss Francs","Switzerland","[0-9]{6,6}",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[6,"CNAPS","CNAPS Identifier","Bank Branch code used in China","China","[0-9]{12,12}",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[7,"DEBLZ","German Bankleitzahl","Bank Branch code used in Germany","Germany","[0-9]{8,8}",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[8,"ESNCC","Spanish Domestic Interbanking Code","Bank Branch code used in Spain","Spain","[0-9]{8,9}",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[9,"GBDSC","UK Domestic Sort Code","Bank Branch code used in the UK","UK","[0-9]{6,6}",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[10,"GRBIC","Helenic Bank Identification Code","Bank Branch code used in Greece","Greece","[0-9]{7,7}",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[11,"HKNCC","Hong Kong Bank Code ","Bank Branch code used in Hong Kong","Hong Kong","[0-9]{3,3}",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[12,"IENCC","Irish National Clearing Code","Bank Branch code used in Ireland","Ireland","[0-9]{6,6}",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[13,"INFSC","Indian Financial System Code","Bank Branch code used in India","India","[a-zA-Z0-9]{11,11}",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[14,"ITNCC","Italian Domestic Identification Code","Bank Branch code used in Italy","Italy","[0-9]{10,10}",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[15,"JPZGN","Japan Zengin Clearing Code","Bank Branch code used in Japan","Japan","[0-9]{7,7}",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[16,"NZNCC","New Zealand National Clearing Code","Bank Branch code used in New Zealand","New Zealand","[0-9]{6,6}",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[17,"PLKNR","Polish National Clearing Code","Bank Branch code used in Poland","Poland","[0-9]{8,8}",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[18,"PTNCC","Portuguese National Clearing Code","Bank Branch code used in Portugal","Portugal","[0-9]{8,8}",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[19,"RUCBC","Russian Central Bank Identification Code","Bank Branch code used in Russia","Russia","[0-9]{9,9}",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[20,"SESBA","Sweden Bankgiro Clearing Code       ","Bank Branch code used in Sweden","Sweden","[0-9]{4,4}",null,"Swedish Bankers Association/Rolf Bohman","New","April 2009","April 2009"]
[21,"SGIBG","IBG Sort Code","Bank Branch code used in Singapore","Singapore","[0-9]{7,7}                                  or [0-9]{3,4}",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[22,"THCBC","Thai Central Bank Identification Code","Bank Identification code used in Thailand","Thailand","[0-9]{3,3}",null,"CR0314/SWIFT & ETDA TH","New","16 January 2014","16 January 2014"]
[23,"TWNCC","Financial Institution Code","Bank Branch code used in Taiwan","Taiwan","[0-9]{7,7}                                  ",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[24,"USABA","United States Routing Number (Fedwire, NACHA)","Routing Transit number assigned by the ABA for US financial institutons","US","[0-9]{9,9}",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[25,"USPID","CHIPS Participant Identifier","Bank identifier used by CHIPs in the US","US","[0-9]{4,4}",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[26,"ZANCC","South African National Clearing Code","Bank Branch code used in South Africa","South Africa","[0-9]{6,6}",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]

{"sheet":"6-FinancialInstitutionIdentif","index":10,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,4,2,7]],"flags":["formulas_cached_only"]}
[]
["ExternalFinancialInstitutionIdentification1Code"]
["Identification",null,null,null,"Status"]
[null,"\nCode","\nName","\nDefinition","\nOrigin/Requester","Status","Status Date","Introduced Date"]
[1,"Currently no codes have been defined."]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]

{"sheet":"7-LocalInstrument","index":11,"n_rows":91,"n_cols":14,"rows_kept":91,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,4,2,9],[2,10,2,13]],"flags":["formulas_cached_only"]}
[]
["ExternalLocalInstrument1Code"]
["Identification",null,null,null,"Information/Details",{"$nulls":5},"Status"]
[null,"\nCode*","\nName","\nDefinition","Region","ISO Country Code","ISO Currency Code","Payment System","DD/CT/ Both/ Other","Corp2Bk, Bk2Bk, or Both","Origin/Requester","Status","Status Date","Introduced Date"]
[1,"TRF","Credit Transfers","Transaction is related to credit transfers","EMEA","AT","All","correspondent banking","CT",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[2,82,"Non-pre authorised Direct Debit","Transaction is related to a direct debit that is not pre authorised (Einzugsermächtigung). ","EMEA","AT","EUR"," Domestic AT","DD","Both","CR0060/CGI Group","New","9 February 2012","9 February 2012"]
[3,83,"Pre authorised Direct Debit","Transaction is related to a direct debit that is pre authorised (Abbuchungsauftrag). ","EMEA","AT","EUR"," Domestic AT","DD","Both","CR0060/CGI Group","New","9 February 2012","9 February 2012"]
[4,"CPP","Cash Per Post","Transaction is related to cash per post.\nTransaction to ultimate recipient having no bank account. Primary beneficiary is a postal service provider. Funds are paid out by cash. Additional necessary information for address and delivery options need to be attached.\n","EMEA","AT","EUR","correspondent banking","CT",null,"Payments Harmonisation 2006 External Code List","Definition clarified","2 December 2011","September 2007"]
[5,"RTR","Returned Credit Transfers","Transaction is related to returned credit transfers.","EMEA","AT","EUR","correspondent banking","CT",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[6,"GST","Truncated Credit Transfers","Transaction is related to truncated credit transfers.\nConversion of physical instrument to electonric form for transmission to the paying bank and where the original paper document does not continue in the clearing process..The original instrument rules are retained throughout the life of the instrument.\nTransaction triggered by specific marked and populated paper slip.\nReconciliation reference is secured by check digits supporting secure optical recognition. All other remittance information is truncated prior transmission.\n","EMEA","AT","EUR","correspondent banking","CT",null,"Payments Harmonisation 2006 External Code List","Definition clarified","2 December 2011","September 2007"]
[7,"DDT","Direct Debits","Transaction is related to direct debits.","EMEA","AT","EUR","correspondent banking","DD",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[8,"RDD","Returned Direct Debits","Transaction is related to returned direct debits.","EMEA","AT","EUR","correspondent banking","DD",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[9,"CHN","Truncated Checks","Transaction is related to truncated checks.\nConversion of physical instrument to electonric form for transmission to the paying bank and where the original paper document does not continue in the clearing process..The original instrument rules are retained throughout the life of the instrument.","EMEA","AT","EUR","correspondent banking","DD",null,"Payments Harmonisation 2006 External Code List","Definition clarified","2 December 2011","September 2007"]
[10,"STR","Revoked Credit Transfers","Transaction is related to revoked credit transfers","EMEA","AT","EUR","correspondent banking","other",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[11,"SDD","Revoked Direct Debits","Transaction is related to revoked direct debits.","EMEA","AT","EUR","correspondent banking","other",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[12,"SRT","Revoked Returned Credit Transfers","Transaction is related to revoked returned credit transfers","EMEA","AT","EUR","correspondent banking","other",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[13,"SRD","Revoked Returned Direct Debits","Transaction is related to revoked returned direct debits.","EMEA","AT","EUR","correspondent banking","other",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[14,"SCN","Revoked Truncated Checks","Transaction is related to revoked truncated checks.","EMEA","AT","EUR","correspondent banking","other",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[15,"SGT","Revoked Truncated Credit Transfers","Transaction is related to revoked truncated credit transfers.","EMEA","AT","EUR","correspondent banking","other",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[16,"CARD","Card Clearing","Transaction is related to card clearing.","EMEA","DE","EUR","All","Both",null,"Maintenance SR2009","New","April 2009","April 2009"]
[17,"05","Non-pre authorised Direct Debit","Transaction is related to a direct debit that is not pre authorised (Einzugsermächtigung). ","EMEA","DE","EUR","Domestic DE","DD","Both","CR0060/CGI Group","New","9 February 2012","9 February 2012"]
[18,"04","Pre authorised Direct Debit","Transaction is related to a direct debit that is pre authorised (Abbuchungsauftrag). ","EMEA","DE","EUR","Domestic DE","DD","Both","CR0060/CGI Group","New","9 February 2012","9 February 2012"]
[19,"ISE","Image-based Cheque Collection","Transaction is related to the German Image-based Cheque Collection Procedure “Imagegestützter Scheckeinzug - ISE”","EMEA","DE","EUR","Domestic DE","Other","Bk2Bk","CR0468/Deutsche Bundesbank","New","31 August 2015","31 August 2015"]
[20,"BSE","Paperless Cheque Collection","Transaction is related to the German Paperless Cheque Collection procedure “Belegloser Scheckeinzug - BSE”","EMEA","DE","EUR","Domestic DE","Other","Bk2Bk","CR0468/Deutsche Bundesbank","New","31 August 2015","31 August 2015"]
[21,"IN","Cross Border Customer Credit Transfer","Transaction is related to cross border customers credit transfers","EMEA","DK","All","All","CT",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[22,58,"Business-to-business Direct Debit","Transaction is related to a business-to-business direct debit (CSB58).","EMEA","ES","EUR","Domestic ES","DD","Both","CR0060/CGI Group","New","9 February 2012","9 February 2012"]
[23,19,"Business-to-customer Direct Debit","Transaction is related to a business-to-customer direct debit (CSB19).","EMEA","ES","EUR","Domestic ES","DD","Both","CR0060/CGI Group","New","9 February 2012","9 February 2012"]
[24,85,"Pre-authorised Direct Debit Accéléré (Accelerated clearing / 2 Day)Ordinaire (Normal clearing / 4 Day)","Transaction is related to an urgent direct debit that is pre authorised (Avis de Prélèvement accéléré).","EMEA","FR","EUR","Domestic FR","DD","Both","CR0060/CGI Group","New","9 February 2012","9 February 2012"]
[25,"08","Pre-authorised Direct Debit Ordinaire (Normal clearing / 4 Day)","Transaction is related to a direct debit that is pre authorised (Avis de Prélèvement).","EMEA","FR","EUR","Domestic FR","DD","Both","CR0060/CGI Group","New","9 February 2012","9 February 2012"]
[26,89,"Pre-authorised Direct Debit Vérifié  (Verified clearing)","Transaction is related to an urgent direct debit that is pre authorised (Avis de Prélèvement vérifié).","EMEA","FR","EUR","Domestic FR","DD","Both","CR0060/CGI Group","New","9 February 2012","9 February 2012"]
[27,60,"Recovered Bill of Exchange or Promissory Note","LCR - Lettre de Change Relevé (Recovered Bill of Exchange) and BOR - Billet à Orde Relevé (Promissory Note)","EMEA","FR","EUR","Domestic FR","Other","Both","CR0060/CGI Group","New","9 February 2012","9 February 2012"]
[28,"RIBA","Non-pre authorised direct debit","Transaction is related to a non-pre authorised collection (RIBA).","EMEA","IT","EUR"," Domestic IT","DD","Both","CR0060/CGI Group","New","9 February 2012","9 February 2012"]
[29,"RIDO","Pre authorised revocable Direct Debit","Transaction is related to a direct debit that is pre authorised and revocable (RID Ordinario).","EMEA","IT","EUR","Domestic IT","DD","Both","CR0060/CGI Group","New","9 February 2012","9 February 2012"]
[30,"RIDV","Pre authorised revocable urgent Direct Debit","Transaction is related to an urgent direct debit that is pre authorised and revocable (RID Veloce).","EMEA","IT","EUR","Domestic IT","DD","Both","CR0060/CGI Group","New","9 February 2012","9 February 2012"]
[31,"IDEAL","Payments via Internet owned by Currence ","Transaction is related to payments via internet owned by Currence.","EMEA","NL","EUR","All","Both",null,"Netherlands/Ton Versteeg ","New","April 2009","April 2009"]
[32,"NLDO","Dutch Domestic Bulk Payment","Transaction is related to a Domestic payment initiated by PAIN.001","EMEA","NL","EUR","All","CT",null,"1Q2010 Code Eval CR0012.  Dutch Bankers Assoc & Currence","New","August 2010","August 2010"]
[33,"NLUP","Dutch Urgent Payment","Transaction is related to a Domestic payment initiated by PAIN.001","EMEA","NL","EUR","All","CT",null,"1Q2010 Code Eval CR0012.  Dutch Bankers Assoc & Currence","New","August 2010","August 2010"]
[34,"ACCEPT","Payment via Acceptgiro owned by Currence","Transaction is related to payments via Acceptgiro owned by Currence.","EMEA","NL","EUR","All","CT",null,"1Q2010 Code Eval CR0012.  Dutch Bankers Assoc & Currence","New","August 2010","August 2010"]
[35,"SDN","Payments via Standaard Digitale Nota","Transaction is related to payments via a ‘Standaard Digitale Nota’ InvoiceAcceptgiro payment.","EMEA","NL","EUR","All","CT",null,"4Q2010 Code Eval CR0055.  Dutch Bankers Assoc ","New","6 Dec 2010","6 Dec 2010"]
[36,"NLGOV","Direct debit initiated by the government with special conditions","Transaction is related to direct debit scheme owned by the NVB","EMEA","NL","EUR","All","DD",null,"1Q2010 Code Eval CR0012.  Dutch Bankers Assoc & Currence","New","August 2010","August 2010"]
[37,"0090","Mass Payment Beneficiary","Transaction is related to mass payment beneficiary.\n","EMEA","NL","EUR","CSS","CT",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[38,"0091","Mass Payment Ours","Transaction is related to mass payment ours.\n","EMEA","NL","EUR","CSS","CT",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[39,"0092","Mass Payment Shared","Transaction is related to mass payment shared.\n","EMEA","NL","EUR","CSS","CT",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[40,"0002","Standing Order","Transaction is related to standing order.","EMEA","NL","EUR","CSS","CT",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[41,"0221","One-off Authorisation","Transaction is related to one-off authorisation.","EMEA","NL","EUR","CSS","DD",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[42,"0224","One-off Authorisation Charities","Transaction is related to one-off authorisation charities.","EMEA","NL","EUR","CSS","DD",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[43,"0226","One-off Authorisation Construction Industry","Transaction is related to one-off authorisation construction industry.","EMEA","NL","EUR","CSS","DD",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[44,"0225","One-off Authorisation Tuition Fees","Transaction is related to one-off authorisation tuition fees.","EMEA","NL","EUR","CSS","DD",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[45,"0222","Standing Authorisation Companies","Transaction is related to standing authorisation companies.","EMEA","NL","EUR","CSS","DD",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[46,"0227","Standing Authorisation Companies Without Debtor Revocation Right","Transaction is related to standing authorisation companies without debtor revocation right.","EMEA","NL","EUR","CSS","DD",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[47,"0220","Standing Authorisation General","Transaction is related to standing authorisation general.\n","EMEA","NL","EUR","CSS","DD",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[48,"0223","Standing Authorisation Lotteries","Transaction is related to standing authorisation lotteries.","EMEA","NL","EUR","CSS","DD",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[49,"0001","Converted (Bank) Payment","Transaction is related to converted (bank) payment.\nConversion of physical instrument to electonric form for transmission to the paying bank and where the original paper document does not continue in the clearing process.The instrument rules change upon conversion.","EMEA","NL","EUR","CSS ","CT",null,"Payments Harmonisation 2006 External Code List","Definition clarified","2 December 2011","September 2007"]
[50,"0000","Business Payment","Transaction is related to business payment","EMEA","NL","EUR","CSS (Equens Clearing & Settlement System)","CT",null,"Payments Harmonisation 2006 External Code List","Definition clarified","2 December 2011","September 2007"]
[51,"IN","Cross Border Customer Credit Transfer","Transaction is related to cross border customer credit transfer.","EMEA","SE","All","All","CT",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[52,"ONCL","Overnight","Transaction is related to overnight clearing.","EMEA","SEPA","EUR","Corporate banking","CT","B2B","CGI-4Q2010 CR0053","New","December 2010","December 2010"]
[53,"SDCL","Same Day","Transaction is related to same day clearing.","EMEA","SEPA","EUR","Corporate banking","CT","B2B","CGI-4Q2010 CR0053","New","December 2010","December 2010"]
[54,"DDNR","CoreNoRefund","SEPA Core Direct Debit with ‘no refund’ option","EMEA","SEPA","EUR","PEACH","DD","B2B","EPC-4Q2009 CR0005","Replaced by DDFA","August 2010","January 2010"]
[55,"DDFA","DirectDebitFixedAmount","SEPA Fixed Amount Direct Debit","EMEA","SEPA","EUR","PEACH","DD","B2B","EPC-1Q2010 CR0016","New","August 2010","August 2010"]
[56,"CORE","SEPA Direct Debit - Core ","Transaction is related to SEPA direct debit -core.","EMEA","SEPA","EUR","PEACH","DD","Both","Maintenance SR2009","New","April 2009","April 2009"]
[57,"B2BAMIPM","SEPA B2B Direct Debit AMI","SEPA B2B Direct Debit AMI based on a paper mandate","EMEA","SEPA","EUR","PEACH","DD",null,"EPC-3Q2011 CR0149","New","2 December 2011","2 December 2011"]
[58,"B2B","SEPA Business to Business Direct Debit","Transaction is related to SEPA business to business direct debit.","EMEA","SEPA","EUR","PEACH","DD",null,"Maintenance SR2009","New","April 2009","April 2009"]
[59,"CR1AMIPM","SEPA Core D-1 Direct Debit AMI","Optional shorter time cycle (D-1) for SEPA Core Direct Debit AMI based on a paper mandate","EMEA","SEPA","EUR","PEACH","DD",null,"EPC-3Q2011 CR0149","New","2 December 2011","2 December 2011"]
[60,"CORAMIPM","SEPA Core Direct Debit AMI","SEPA Core Direct Debit AMI based on a paper mandate","EMEA","SEPA","EUR","PEACH","DD",null,"EPC-3Q2011 CR0149","New","2 December 2011","2 December 2011"]
[61,"COR1","SEPA Direct Debit - 1 Day Settlement","Optional shorter time cycle (D-1) for SEPA Core Direct Debit","EMEA","SEPA","EUR","PEACH","DD",null,"EPC-3Q2011 CR0148","New","2 December 2011","2 December 2011"]
[62,"FADAMIPM","SEPA FA Direct Debit AMI","SEPA Fixed Amount Direct Debit AMI based on a paper mandate","EMEA","SEPA","EUR","PEACH","DD",null,"EPC-3Q2011 CR0149","New","2 December 2011","2 December 2011"]
[63,"CCI","Cash Concentration Intragroup","Transaction is related to an intra-group bank initiated cash management payment","GLOBAL","GLOBAL","All","All","DD, CT and CPAR",null,"GSBA-3Q2011 CR0150","New","2 December 2011","2 December 2011"]
[64,"BTR","Bank Transfer","Transaction is related to a bank transfer.","WHEM","US","USD","Fedwire","CT","B2B","FED-2Q2011 CR0073","New","31 August 2011","31 August 2011"]
[65,"CKS","Check Same Day Settlement Wire","Transaction is related to check same day settlement wire.","WHEM","US","USD","Fedwire","CT","B2B","Maintenance SR2009","New","April 2009","April 2009"]
[66,"CTR","Customer Transfer ","Transaction is related to customer transfer.","WHEM","US","USD","Fedwire","CT","B2B","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[67,"CTP","Customer Transfer Plus","Transaction is related to a customer transfer, which may include information related to a cover payment or extended remittance information.  ","WHEM","US","USD","Fedwire","CT","B2B","FED-2Q2011 CR0073","New","31 August 2011","31 August 2011"]
[68,"DEP","Deposit to Sender’s Account","Transaction is related to deposit to sender's account.","WHEM","US","USD","Fedwire","CT","B2B","Maintenance SR2009","New","April 2009","April 2009"]
[69,"FFR","Fed Funds Returned","Transaction is related to Fed funds returned.","WHEM","US","USD","Fedwire","CT","B2B","Maintenance SR2009","New","April 2009","April 2009"]
[70,"FFS","Fed Funds Sold","Transaction is related to Fed funds sold.","WHEM","US","USD","Fedwire","CT","B2B","Maintenance SR2009","New","April 2009","April 2009"]
[71,"SVC","Non-Value Service Message","Transaction is related to non-value service message.","WHEM","US","USD","Fedwire","Non-value Service Message","B2B","Maintenance SR2009","New","April 2009","April 2009"]
[72,"DRW","Drawdown Response (Value) to Honor a Drawdown Request","Transaction is related to drawdown response (value) to honor a drawdown request.","WHEM","US","USD","Fedwire","other","B2B","Payments Harmonisation 2006 External Code List","Definition updated","April 2009","September 2007"]
[73,"DRB","Bank-to-Bank Drawdown Request or Response (Non-value)","Transaction is related to bank-to-bank drawdown request or response (non-value)","WHEM","US","USD","Fedwire","Request for credit","B2B","Maintenance SR2009","New","April 2009","April 2009"]
[74,"DRC","Customer or Corporate Drawdown Request or Response (Non-value)","Transaction is related to customer or corporate drawdown request or response (non-value).","WHEM","US","USD","Fedwire","Request for credit","B2B","Payments Harmonisation 2006 External Code List","Definition updated","April 2009","September 2007"]
[75,"IAT","International ACH","Transaction is related to international ACH.","WHEM","US","USD","NACHA","Both","Both","US NACHA/Susan Colles","New","April 2009","April 2009"]
[76,"CCD","Cash Concentration or Disbursement Corporate counterparty.","Transaction is related to cash concentration or disbursement corporate counterparty.","WHEM","US","USD","NACHA","Both plus prenote.","Both","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[77,"CTX","Corporate Trade Exchange","Transaction is related to corporate trade exchange.","WHEM","US","USD","NACHA","Both plus prenote.","Both","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[78,"PPD","Prearranged Payment or Deposit.  Consumer counterparty.","Transaction is related to prearranged payment or deposit consumer counterparty.","WHEM","US","USD","NACHA","Both plus prenote.","Both","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[79,"CIE","Customer Initiated Entry","A credit entry initiated by or on behalf of the holder of a consumer account","WHEM","US","USD","NACHA","CT","Both","1Q2010 Code Eval, CR0011.  Bank of America Merrill Lynch","New","August 2010","August 2010"]
[80,"RCK","Re-presented Check Entry ","Transaction is related to re-presented check entry.","WHEM","US","USD","NACHA","CT","Both","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[81,"ARC","Accounts Receivable Check","Transaction is related to accounts receivable check.","WHEM","US","USD","NACHA","DD","Both","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[82,"WEB","Internet Initiated Entry","Transaction is related to internet initiated entry.","WHEM","US","USD","NACHA","DD","Both","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[83,"POP","Point-Of-Purchase","Transaction is related to point-of-purchase.","WHEM","US","USD","NACHA","DD","Both","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[84,"POS","Point-Of-Sale","Transaction is related to point-of-sale.","WHEM","US","USD","NACHA","DD","Both","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[85,"TEL","Telephone Initiated Entry","Transaction is related to telephone initiated entry.","WHEM","US","USD","NACHA","DD","Both","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[]
[null,"* the codes are sorted according to the first four columns of the \"information details\", then by alphabetical order"]

{"sheet":"8-MandateReason","index":12,"n_rows":43,"n_cols":9,"rows_kept":43,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,5,2,8],[1,0,1,8]],"flags":["formulas_cached_only"]}
[]
["ExternalMandateReason1Code"]
["Identification",null,null,null,"Information/Details","Status"]
[null,"Code","Name","Definition",null,"Origin/Requester","Status","Status Date","Introduced Date"]
[1,"AC01","IncorrectAccountNumber","Format of the account number specified is not correct",null,"CR0052 3Q2010/EPC","New","Oct 2010","November 2010"]
[2,"AC04","ClosedAccountNumber","Account number specified has been closed on the Receiver's books",null,"CR0052 3Q2010/EPC","New","Oct 2010","November 2010"]
[3,"AC06","BlockedAccount","Account specified is blocked, prohibiting posting of transactions against it.",null,"CR0052 3Q2010/EPC","New","Oct 2010","November 2010"]
[4,"AG01","TransactionForbidden","Transaction forbidden on this type of account (formerly NoAgreement)",null,"CR0052 3Q2010/EPC","New","Oct 2010","November 2010"]
[5,"AG02","InvalidBankOperationCode","Bank Operation code specified in the message is not valid for receiver",null,"CR0052 3Q2010/EPC","New","Oct 2010","November 2010"]
[6,"AM02","NotAllowedAmount","Specific transaction/message amount is greater than allowed maximum",null,"CR0052 3Q2010/EPC","New","Oct 2010","November 2010"]
[7,"AM03","NotAllowedCurrency","Specified message amount is a non processable currency outside of existing agreement",null,"CR0052 3Q2010/EPC","New","Oct 2010","November 2010"]
[8,"AM05","Duplication","Duplication ",null,"CR0052 3Q2010/EPC","New","Oct 2010","November 2010"]
[9,"BE01","InconsistenWithEndCustomer","Identification of end customer is not consistent with associated account number. (formerly CreditorConsistency).",null,"CR0052 3Q2010/EPC","New","Oct 2010","November 2010"]
[10,"BE04","MissingCreditorAddress","Specification of creditor's address, which is required for payment, is missing/not correct (formerly IncorrectCreditorAddress).",null,"CR0052 3Q2010/EPC","New","Oct 2010","November 2010"]
[11,"BE05","UnrecognisedInitiatingParty","Party who initiated the message is not recognised by the end customer",null,"CR0052 3Q2010/EPC","New","Oct 2010","November 2010"]
[12,"BE06","UnknownEndCustomer","End customer specified is not known at associated Sort/National Bank Code or does no longer exist in the books",null,"CR0052 3Q2010/EPC","New","Oct 2010","November 2010"]
[13,"BE07","MissingDebtorAddress","Specification of debtor's address, which is required for payment, is missing/not correct.",null,"CR0052 3Q2010/EPC","New","Oct 2010","November 2010"]
[14,"DT01","InvalidDate","Invalid date (eg, wrong settlement date)",null,"CR0052 3Q2010/EPC","New","Oct 2010","November 2010"]
[15,"FF01","InvalidFileFormat","File format incomplete or invalid",null,"CR0052 3Q2010/EPC","New","Oct 2010","November 2010"]
[16,"MD01","NoMandate","No Mandate",null,"CR0052 3Q2010/EPC","New","Oct 2010","November 2010"]
[17,"MD02","MissingMandatoryInformationInMandate","Mandate related information data required by the scheme is missing.",null,"CR0052 3Q2010/EPC","New","Oct 2010","November 2010"]
[18,"MD07","EndCustomerDeceased","End customer is deceased.",null,"CR0052 3Q2010/EPC","New","Oct 2010","November 2010"]
[19,"MD08","NoMandateServiceByAgent","Receiving agent does not offer specified Mandate services",null,"CR0052 3Q2010/EPC","New","Oct 2010","November 2010"]
[20,"MD09","NoMandateServiceOnCustomer","Account is not open to specified Mandates services",null,"CR0052 3Q2010/EPC","New","Oct 2010","November 2010"]
[21,"MD10","NoMandateServiceForSpecified","Account is not open to specified Mandates services for this particular creditor",null,"CR0052 3Q2010/EPC","New","Oct 2010","November 2010"]
[22,"MD11","UnrecognisedAgent","Agent to whom the message needs to be forwarded cannot be located",null,"CR0052 3Q2010/EPC","New","Oct 2010","November 2010"]
[23,"MD12","NotUniqueMandateReference","Mandate identification is not unique to the creditor",null,"CR0052 3Q2010/EPC","New","Oct 2010","November 2010"]
[24,"MD13","IncorrectCustomerAuthentication","There is a problem with the customer authentication",null,"CR0052 3Q2010/EPC","New","Oct 2010","November 2010"]
[25,"MD14","IncorrectAgent","Agent in the payment workflow is incorrect",null,"CR0052 3Q2010/EPC","New","Oct 2010","November 2010"]
[26,"MD15","IncorrectCurrency","Currency of the transaction is incorrect",null,"CR0052 3Q2010/EPC","New","Oct 2010","November 2010"]
[27,"MD16","RequestedByCustomer","Cancellation/amendment requested by the debtor",null,"CR0052 3Q2010/EPC","New","Oct 2010","November 2010"]
[28,"MD17","RequestedByInitiatingParty","Cancellation/amendment requested by the creditor",null,"CR0052 3Q2010/EPC","New","Oct 2010","November 2010"]
[29,"MD18","RequestedByInitiatingPartyAndCustomer","Cancellation/amendment requested by the creditor and the debtor",null,"CR0052 3Q2010/EPC","New","Oct 2010","November 2010"]
[30,"MS02","NotSpecifiedReasonCustomer Generated","Reason has not been specified by end customer",null,"CR0052 3Q2010/EPC","New","Oct 2010","November 2010"]
[31,"MS03","NotSpecifiedReasonAgentGenerated","Reason has not been specified by agent.",null,"CR0052 3Q2010/EPC","New","Oct 2010","November 2010"]
[32,"NARR","Narrative","Reason is provided as narrative information in the additional reason information.",null,"CR0052 3Q2010/EPC","New","Oct 2010","November 2010"]
[33,"RC01","BankIdentifierIncorrect","Bank Identifier code specified in the message has an incorrect format (formerly IncorrectFormatForRoutingCode).",null,"CR0052 3Q2010/EPC","New","Oct 2010","November 2010"]
[34,"RF01","NotUniqueTransactionReference","Transaction reference is not unique within the message.",null,"CR0052 3Q2010/EPC","New","Oct 2010","November 2010"]
[35,"RR01","Missing Debtor Account or Identification","Specification of the debtor’s account or unique identification needed for reasons of regulatory requirements is insufficient or missing",null,"CR0052 3Q2010/EPC","New","Oct 2010","November 2010"]
[36,"RR02","Missing Debtor Name or Address","Specification of the debtor’s name and/or address needed for regulatory requirements is insufficient or missing.",null,"CR0052 3Q2010/EPC","New","Oct 2010","November 2010"]
[37,"RR03","Missing Creditor Name or Address","Specification of the creditor’s name and/or address needed for regulatory requirements is insufficient or missing.",null,"CR0052 3Q2010/EPC","New","Oct 2010","November 2010"]
[38,"RR04","Regulatory Reason ","Regulatory Reason",null,"CR0052 3Q2010/EPC","New","Oct 2010","November 2010"]
[39,"SL01","Specific Service offered by Debtor Agent","Due to specific service offered by the Debtor Agent",null,"CR0052 3Q2010/EPC","New","Oct 2010","November 2010"]

{"sheet":"9-OrganisationIdentification","index":13,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,5,2,8],[1,0,1,8]],"flags":["formulas_cached_only"]}
[]
["ExternalOrganisationIdentification1Code"]
["Identification",null,null,null,"Information/Details","Status"]
[null,"\nCode","\nName","\nDefinition",null,"Origin/Requester","Status","Status Date","Introduced Date"]
[1,"BANK","BankPartyIdentification","Unique and unambiguous assignment made by a specific bank or similar financial institution to identify a relationship as defined between the bank and its client. ",null,"Maintenance SR2009","New","April 2009","April 2009"]
[2,"CBID","Central Bank Identification Number ","A unique identification number assigned by a central bank to identify an organisation.",null,"CR0054/CGI","New","6 Dec 2010 ","6 Dec 2010 "]
[3,"CHID","Clearing Identification Number","A unique identification number assigned by a clearing house to identify an organisation",null,"CR0054/CGI","New","6 Dec 2010 ","6 Dec 2010 "]
[4,"COID","CountryIdentificationCode","Country authority given organisation identification (e.g., corporate registration number)",null,"CR0056/Trade SEG","New","14 Feb 2011","14 Feb 2011"]
[5,"CUST","CustomerNumber","Number assigned by an issuer to identify a customer.\nNumber assigned by a party to identify a creditor or debtor relationship.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[6,"DUNS","Data Universal Numbering System","A unique identification number provided by Dun & Bradstreet to identify an organisation.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[7,"EMPL","EmployerIdentificationNumber","Number assigned by a registration authority to an employer.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[8,"GS1G","GS1GLNIdentifier","Global Location Number. A non-significant reference number used to identify legal entities, functional entities, or physical entities according to GS1 numbering scheme rules.The number is used to retrieve detailed information that is linked to it.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[9,"SREN","SIREN","The SIREN number is a 9 digit code assigned by INSEE, the French National Institute for Statistics and Economic Studies, to identify an organisation in France.",null,"CR0054/CGI","New","6 Dec 2010 ","6 Dec 2010 "]
[10,"SRET","SIRET","The SIRET number is a 14 digit code assigned by INSEE, the French National Institute for Statistics and Economic Studies, to identify an organisation unit in France. It consists of the SIREN number, followed by a five digit classification number, to identify the local geographical unit of that entity",null,"CR0054/CGI","New","6 Dec 2010 ","6 Dec 2010 "]
[11,"TXID","TaxIdentificationNumber","Number assigned by a tax authority to identify an organisation.",null,"Maintenance SR2009","New","April 2009","April 2009"]

{"sheet":"10-PersonIdentification","index":14,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,5,2,8]],"flags":["formulas_cached_only"]}
[]
["ExternalPersonIdentification1Code"]
["Identification",null,null,null,"Information/Details","Status"]
[null,"\nCode","\nName","\nDefinition",null,"Origin/Requester","Status","Status Date","Introduced Date"]
[1,"ARNU","AlienRegistrationNumber","Number assigned by a social security agency to identify a non-resident person.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[2,"CCPT","PassportNumber","Number assigned by an authority to identify the passport number of a person.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[3,"CUST","CustomerIdentificationNumber","Number assigned by an issuer to identify a customer.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[4,"DRLC","DriversLicenseNumber","Number assigned by an authority to identify a driver's license.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[5,"EMPL","EmployeeIdentificationNumber","Number assigned by a registration authority to an employee.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[6,"NIDN","NationalIdentityNumber","Number assigned by an authority to identify the national identity number of a person.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[7,"SOSE","SocialSecurityNumber","Number assigned by an authority to identify the social security number of a person.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[8,"TXID","TaxIdentificationNumber","Number assigned by a tax authority to identify a person.",null,"Maintenance SR2009","New","April 2009","April 2009"]

{"sheet":"11-Purpose","index":15,"n_rows":180,"n_cols":9,"rows_kept":180,"cut":false,"hidden":false,"merged":[[2,0,2,4],[2,5,2,8]],"flags":["formulas_cached_only"]}
[]
["ExternalPurpose1Code"]
["Identification",{"$nulls":4},"Status"]
[null,"\nCode","Classification1","\nName","\nDefinition","Origin/Requester","Status","Status Date","Introduced Date"]
[1,"CBLK","Card Settlement","Card Bulk Clearing"," A Service that is settling money for a bulk of card transactions, while referring to a specific transaction file or other information like terminal ID, card acceptor ID or other transaction details.","CodeEval 3Q2012 CR0251-Berlin Group.","New","08 Oct 2012","08 Oct 2012"]
[2,"CDCB","Card Settlement","CardPayment with CashBack","Purchase of Goods and Services with additional Cash disbursement at the POI (Cashback)","Berlin Group","New","January 2010","January 2010"]
[3,"CDCD","Card Settlement","CashDisbursement","ATM Cash Withdrawal in an unattended or Cash Advance in an attended environment (POI or bank counter)","Berlin Group","New","January 2010","January 2010"]
[4,"CDCS","Card Settlement","Cash Disbursement with Surcharging","ATM Cash Withdrawal in an unattended or Cash Advance in an attended environment (POI or bank counter) with surcharging.","CR0153/Berlin Group","New","9 February 2012","9 February 2012"]
[5,"CDDP","Card Settlement","Card Deferred Payment","A combined service which enables the card acceptor to perform an authorisation for a temporary amount and a completion for the final amount within a limited time frame. Deferred Payment is only available in the unattended environment.\nExamples where this service is widely used are unattended petrol pumps and phone booths","CodeEval 4Q2012\nCR0253- \nBerlin Group","New","11 January 2013","11 January 2013"]
[6,"CDOC","Card Settlement","OriginalCredit ","A service which allows the card acceptor to effect a credit to a cardholder' account. Unlike a Merchant Refund, an Original Credit is not preceded by a card payment. This service is used for example for crediting winnings from gaming.","Berlin Group","New","January 2010","January 2010"]
[7,"CDQC","Card Settlement","QuasiCash ","Purchase of Goods which are equivalent to cash like coupons in casinos.","Berlin Group","New","January 2010","January 2010"]
[8,"ETUP","Card Settlement","E-Purse Top Up","Transaction is related to a Service that is first reserving money from a card account and then is loading an e-purse application by this amount.","CR0170/Berlin Group","New","31 May 2012","31 May 2012"]
[9,"FCOL","Card Settlement","Fee Collection","A Service that is settling card transaction related fees between two parties.","CodeEval 3Q2012 CR0251-Berlin Group.","New","08 Oct 2012","08 Oct 2012"]
[10,"MTUP","Card Settlement","Mobile Top Up","A Service that is first reserving money from a card account and then is loading a prepaid mobile phone amount by this amount.","CR0153/Berlin Group","New","9 February 2012","9 February 2012"]
[11,"ACCT","Cash Mgmt","AccountManagement","Transaction moves funds between 2 accounts of same account holder at the same bank.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[12,"CASH","Cash Mgmt","CashManagementTransfer","Transaction is a general cash management instruction.","Payments Harmonisation 2006 External Code List","Definition updated","April 2009","September 2007"]
[13,"COLL","Cash Mgmt","CollectionPayment","Transaction is a collection of funds initiated via a credit transfer or direct debit.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[14,"CSDB","Cash Mgmt","CashDisbursement","Transaction is related to cash disbursement.","Maintenance SR2009","New","April 2009","April 2009"]
[15,"DEPT","Cash Mgmt","Deposit","Transaction is releted to a payment of deposit.","US NACHA/Susan Colles","New","April 2009","April 2009"]
[16,"INTC","Cash Mgmt","IntraCompanyPayment","Transaction is an intra-company payment, ie, a payment between two companies belonging to the same group.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[17,"LIMA","Cash Mgmt","LiquidityManagement","Bank initiated account transfer to support zero target balance management, pooling or sweeping.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[18,"NETT","Cash Mgmt","Netting","Transaction is related to a netting operation.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[19,"AGRT","Commercial","AgriculturalTransfer","Transaction is related to the agricultural domain.","Payments Harmonisation 2006 External Code List","Definition updated","April 2009","September 2007"]
[20,"AREN","Commercial","Accounts Receivables Entry","Transaction is related to a payment associated with an Account Receivable Entry","US NACHA/Susan Colles","New","April 2009","April 2009"]
[21,"BEXP","Commercial","BusinessExpenses","Transaction is related to a payment of business expenses.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[22,"BOCE","Commercial","Back Office Conversion Entry","Transaction is related to a payment associated with a Back Office Conversion Entry","US NACHA/Susan Colles","New","April 2009","April 2009"]
[23,"COMC","Commercial","CommercialPayment","Transaction is related to a payment of commercial credit or debit. (formerly CommercialCredit)","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[24,"CPYR","Commercial","Copyright","Transaction is payment of copyright.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[25,"GDDS","Commercial","PurchaseSaleOfGoods","Transaction is related to purchase and sale of goods.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[26,"GDSV","Commercial","PurchaseSaleOfGoodsAndServices","Transaction is related to purchase and sale of goods and services.","Maintenance SR2009","New","April 2009","April 2009"]
[27,"GSCB","Commercial","PurchaseSaleOfGoodsAndServicesWithCashBack","Transaction is related to purchase and sale of goods and services with cash back.","Maintenance SR2009","New","April 2009","April 2009"]
[28,"LICF","Commercial","LicenseFee","Transaction is payment of a license fee.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[29,"POPE","Commercial","Point of Purchase Entry","Transaction is related to a payment associated with a Point of Purchase Entry.","US NACHA/Susan Colles","New","April 2009","April 2009"]
[30,"ROYA","Commercial","Royalties","Transaction is the payment of royalties.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[31,"SCVE","Commercial","PurchaseSaleOfServices","Transaction is related to purchase and sale of services.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[32,"SUBS","Commercial","Subscription","Transaction is related to a payment of information or entertainment services either in printed or electronic form.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[33,"SUPP","Commercial","SupplierPayment","Transaction is related to a payment to a supplier.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[34,"TRAD","Commercial","TradeServices","Transaction is related to a trade services operation.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[35,"CHAR","Consumer","CharityPayment","Transaction is a payment for charity reasons.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[36,"COMT","Consumer","ConsumerThirdPartyConsolidatedPayment","Transaction is a payment used by a third party who can collect funds to pay on behalf of consumers, ie credit counseling or bill payment companies.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[37,"ECPG","E-Commerce","GuaranteedEPayment","E-Commerce payment with payment guarantee of the issuing bank.","CodeEval 3Q2014 - CR0468 - Association of German Banks","New","2014-12-26","2014-12-26"]
[38,"ECPR","E-Commerce","EPaymentReturn","E-Commerce payment return.","CodeEval 3Q2014 - CR0468 - Association of German Banks","New","2014-12-26","2014-12-26"]
[39,"ECPU","E-Commerce","NonGuaranteedEPayment","E-Commerce payment without payment guarantee of the issuing bank.","CodeEval 3Q2014 - CR0468 - Association of German Banks","New","2014-12-26","2014-12-26"]
[40,"CLPR","Finance","CarLoanPrincipalRepayment","Transaction is a payment of car loan principal payment.","Payments Harmonisation 2006 External Code List","Definition updated","April 2009","September 2007"]
[41,"DBTC","Finance","DebitCollectionPayment","Collection of funds initiated via a debit transfer.","Initial Schema Internal Code List - September 2005","New","April 2009","April 2009"]
[42,"GOVI","Finance","GovernmentInsurance","Transaction is related to a payment of government insurance.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[43,"HLRP","Finance","HousingLoanRepayment","Transaction is related to a payment of housing loan.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[44,"INPC","Finance","InsurancePremiumCar","Transaction is a payment of car insurance premium.","Initial Schema Internal Code List - September 2005","New","April 2009","April 2009"]
[45,"INSU","Finance","InsurancePremium","Transaction is payment of an insurance premium.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[46,"INTE","Finance","Interest","Transaction is payment of interest.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[47,"LBRI","Finance","LaborInsurance","Transaction is a payment of labor insurance.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[48,"LIFI","Finance","LifeInsurance","Transaction is a payment of life insurance.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[49,"LOAN","Finance","Loan","Transaction is related to transfer of loan to borrower.","Payments Harmonisation 2006 External Code List","Definition updated","April 2009","September 2007"]
[50,"LOAR","Finance","LoanRepayment","Transaction is related to repayment of loan to lender.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[51,"PENO","Finance","PaymentBasedOnEnforcementOrder","Payment based on enforcement orders except those arising from judicial alimony decrees.","CodeEval 2Q2012 (CR0244.The Bank Association of Slovenia)","New","16 July 2012","16 July 2012"]
[52,"PPTI","Finance","PropertyInsurance","Transaction is a payment of property insurance.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[53,"RINP","Finance","RecurringInstallmentPayment","Transaction is related to a payment of a recurring installment made at regular intervals.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[54,"TRFD","Finance","TrustFund","Transaction is related to a payment of a trust fund.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[55,"ADMG","General","AdministrativeManagement","Transaction is related to a payment associated with administrative management.","CR0155/CGI Group","New","9 February 2012","9 February 2012"]
[56,"ADVA","General","AdvancePayment","Transaction is an advance payment.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[57,"BCDM","General","BearerChequeDomestic","Transaction is the payment of a domestic bearer cheque.","CR0467/Deutsche Bundesbank","New","31 August 2015","31 August 2015"]
[58,"BCFG","General","BearerChequeForeign","Transaction is the payment of a foreign bearer cheque.","CR0467/Deutsche Bundesbank","New","31 August 2015","31 August 2015"]
[59,"BLDM","General","BuildingMaintenance","Transaction is related to a payment associated with building maintenance.","CR0155/CGI Group","New","9 February 2012","9 February 2012"]
[60,"CBFF","General","CapitalBuilding","Transaction is related to capital building fringe fortune, ie capital building in general","CR0312/German banking industry","Definition updated","16 January 2014","April 2009"]
[61,"CBFR","General","CapitalBuildingRetirement ","Transaction is related to capital building fringe fortune for retirement","CR0312/German banking industry","New","16 January 2014","16 January 2014"]
[62,"CCRD","General","CreditCardPayment ","Transaction is related to a payment of credit card account.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[63,"CDBL","General","CreditCardBill","Transaction is related to a payment of credit card bill.","Initial Schema Internal Code List - September 2005","New","April 2009","April 2009"]
[64,"CFEE","General","CancellationFee","Transaction is related to a payment of cancellation fee.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[65,"CGDD","General","CardGeneratedDirectDebit","Transaction is related to a direct debit where the mandate was generated by using data from a payment card at the point of sale.","CR0311/German Savings Banks Association","New","16 January 2014","16 January 2014"]
[66,"COST","General","Costs","Transaction is related to payment of costs.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[67,"CPKC","General","Carpark Charges ","Transaction is related to carpark charges.","Code Eval 1Q2013\nCR0255 - Singapore","New","6 May 2013","7 May 2013"]
[68,"DCRD","General","Debit Card Payment","Transaction is related to a debit card payment.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[69,"DSMT","General","Printed Order Disbursement","Transaction is the payment of a disbursement due to a specific type of printed order for a payment of a  specified sum, issued by a bank or a post office (Zahlungsanweisung zur Verrechnung)","CR0467/Deutsche Bundesbank","New","31 August 2015","31 August 2015"]
[70,"EDUC","General","Education ","Transaction is related to a payment of study/tuition fees.","Code Eval 1Q2013\nCR0255 - Singapore","New","6 May 2013","7 May 2013"]
[71,"FAND","General","FinancialAidInCaseOfNaturalDisaster","Financial aid by State authorities for abolition of consequences of natural disasters.","CodeEval 2Q2012 (CR0244.The Bank Association of Slovenia)","New","16 July 2012","16 July 2012"]
[72,"FCPM","General","Late Payment of Fees & Charges ","Transaction is the payment for late fees & charges. E.g Credit card charges","Code Eval 1Q2013\nCR0255 - Singapore","New","6 May 2013","7 May 2013"]
[73,"GOVT","General","GovernmentPayment","Transaction is a payment to or from a government department.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[74,"ICCP","General","IrrevocableCreditCardPayment","Transaction is reimbursement of credit card payment.","Maintenance SR2009","New","April 2009","April 2009"]
[75,"IDCP","General","IrrevocableDebitCardPayment","Transaction is reimbursement of debit card payment.","Maintenance SR2009","New","April 2009","April 2009"]
[76,"IHRP","General","InstalmentHirePurchaseAgreement","Transaction is payment for an installment/hire-purchase agreement.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[77,"INSM","General","Installment","Transaction is related to a payment of an installment.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[78,"IVPT","General","Invoice Payment ","Transaction is the payment for invoices.","Code Eval 1Q2013\nCR0255 - Singapore","New","6 May 2013","7 May 2013"]
[79,"MCDM","General","MultiCurrenyChequeDomestic","Transaction is the payment of a domestic multi-currency cheque","CR0467/Deutsche Bundesbank","New","31 August 2015","31 August 2015"]
[80,"MCFG","General","MultiCurrenyChequeForeign","Transaction is the payment of a foreign multi-currency cheque","CR0467/Deutsche Bundesbank","New","31 August 2015","31 August 2015"]
[81,"MSVC","General","MultipleServiceTypes","Transaction is related to a payment for multiple service types.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[82,"NOWS","General","NotOtherwiseSpecified","Transaction is related to a payment for type of services not specified elsewhere.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[83,"OCDM","General","OrderChequeDomestic","Transaction is the payment of a domestic order cheque","CR0467/Deutsche Bundesbank","New","31 August 2015","31 August 2015"]
[84,"OCFG","General","OrderChequeForeign","Transaction is the payment of a foreign order cheque","CR0467/Deutsche Bundesbank","New","31 August 2015","31 August 2015"]
[85,"OFEE","General","OpeningFee","Transaction is related to a payment of opening fee.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[86,"OTHR","General","Other","Other payment purpose.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[87,"PADD","General","Preauthorized debit","Transaction is related to a pre-authorized debit origination","Payments Harmonisation 2006 External Code List","Definition updated","April 2009","September 2007"]
[88,"PTSP","General","PaymentTerms","Transaction is related to payment terms specifications","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[89,"RCKE","General","Re-presented Check Entry","Transaction is related to a payment associated with a re-presented check entry","US NACHA/Susan Colles","New","April 2009","April 2009"]
[90,"RCPT","General","ReceiptPayment","Transaction is related to a payment of receipt.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[91,"REBT","General","Rebate ","Transaction is the payment of a rebate.","Code Eval 1Q2013\nCR0255 - Singapore","New","6 May 2013","7 May 2013"]
[92,"REFU","General","Refund","Transaction is the payment of a refund.","Maintenance SR2009","New","April 2009","April 2009"]
[93,"RENT","General","Rent","Transaction is the payment of rent.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[94,"RIMB","General","Reimbursement of a previous erroneous transaction","Transaction is related to a reimbursement of a previous erroneous transaction.","CodeEval 3Q2013 CR0308-German Savings Banks","Name and definition updated","2 December 2013","29 November 2013"]
[95,"STDY","General","Study","Transaction is related to a payment of study/tuition costs.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[96,"TBIL","General","Telecommunications Bill ","Transaction is related to a payment of telecommunications related bill.","Code Eval 1Q2013\nCR0255 - Singapore","New","6 May 2013","7 May 2013"]
[97,"TCSC","General","Town Council Service Charges ","Transaction is related to a payment associated with charges levied by a town council.","Code Eval 1Q2013\nCR0255 - Singapore","New","6 May 2013","7 May 2013"]
[98,"TELI","General","Telephone-Initiated Transaction","Transaction is related to a payment initiated via telephone.","US NACHA/Susan Colles","New","April 2009","April 2009"]
[99,"TRVC","General","TravellerCheque","Transaction is the payment of a travellers cheque","CR0467/Deutsche Bundesbank","New","31 August 2015","31 August 2015"]
[100,"WEBI","General","Internet-Initiated Transaction","Transaction is related to a payment initiated via internet.","US NACHA/Susan Colles","New","April 2009","April 2009"]
[101,"ANNI","Investment","Annuity","Transaction settles annuity related to credit, insurance, investments, other.n","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[102,"CAFI","Investment","Custodian Management fee In-house","Transaction is the payment of custodian account management fee where custodian bank and current account servicing bank coincide","CodeEval 3Q2012 CR0250-DSGV.","New","08 Oct 2012","08 Oct 2012"]
[103,"CFDI","Investment","Capital falling due In-house","Transaction is the payment of capital falling due where custodian bank and current account servicing bank coincide","CodeEval 3Q2012 CR0250-DSGV.","New","08 Oct 2012","08 Oct 2012"]
[104,"CMDT","Investment","CommodityTransfer","Transaction is payment of commodities.","Payments Harmonisation 2006 External Code List","Definition updated","April 2009","September 2007"]
[105,"DERI","Investment","Derivatives","Transaction is related to a derivatives transaction","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[106,"DIVD","Investment","Dividend","Transaction is payment of dividends.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[107,"FREX","Investment","ForeignExchange","Transaction is related to a foreign exchange operation.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[108,"HEDG","Investment","Hedging","Transaction is related to a hedging operation.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[109,"INVS","Investment","Investment & Securities ","Transaction is for the payment of mutual funds, investment products and shares","Code Eval 1Q2013\nCR0255 Singapore","New","6 May 2013","7 May 2013"]
[110,"PRME","Investment","PreciousMetal","Transaction is related to a precious metal operation.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[111,"SAVG","Investment","Savings","Transfer to savings/retirement account.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[112,"SECU","Investment","Securities","Transaction is the payment of securities.","Payments Harmonisation 2006 External Code List","Definition updated","April 2009","September 2007"]
[113,"SEPI","Investment","Securities Purchase In-house","Transaction is the payment of a purchase of securities where custodian bank and current account servicing bank coincide","CodeEval 3Q2012 CR0250-DSGV.","New","08 Oct 2012","08 Oct 2012"]
[114,"TREA","Investment","TreasuryPayment","Transaction is related to treasury operations.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[115,"ANTS","Medical","AnesthesiaServices","Transaction is a payment for anesthesia services.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[116,"CVCF","Medical","ConvalescentCareFacility","Transaction is a payment for convalescence care facility services.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[117,"DMEQ","Medical","DurableMedicaleEquipment","Transaction is a payment is for use of durable medical equipment.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[118,"DNTS","Medical","DentalServices","Transaction is a payment for dental services.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[119,"HLTC","Medical","HomeHealthCare","Transaction is a payment for home health care services.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[120,"HLTI","Medical","HealthInsurance","Transaction is a payment of health insurance.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[121,"HSPC","Medical","HospitalCare","Transaction is a payment for hospital care services.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[122,"ICRF","Medical","IntermediateCareFacility","Transaction is a payment for intermediate care facility services.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[123,"LTCF","Medical","LongTermCareFacility","Transaction is a payment for long-term care facility services.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[124,"MDCS","Medical","MedicalServices","Transaction is a payment for medical care services.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[125,"VIEW","Medical","VisionCare","Transaction is a payment for vision care services.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[126,"ALLW","Salary & Benefits","Allowance ","Transaction is the payment of allowances.","Code Eval 1Q2013\nCR0255 - Singapore","New","6 May 2013","7 May 2013"]
[127,"ALMY","Salary & Benefits","AlimonyPayment","Transaction is the payment of alimony.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[128,"BBSC","Salary & Benefits","Baby Bonus Scheme ","Transaction is related to a payment made as incentive to encourage parents to have more children","Code Eval 1Q2013\nCR0255 - Singapore","New","6 May 2013","7 May 2013"]
[129,"BECH","Salary & Benefits","ChildBenefit","Transaction is related to a payment made to assist parent/guardian to maintain child.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[130,"BENE","Salary & Benefits","UnemploymentDisabilityBenefit","Transaction is related to a payment to a person who is unemployed/disabled.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[131,"BONU","Salary & Benefits","BonusPayment.","Transaction is related to payment of a bonus.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[132,"COMM","Salary & Benefits","Commission","Transaction is payment of commission.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[133,"CSLP","Salary & Benefits","CompanySocialLoanPaymentToBank","Transaction is a payment by a company to a bank for financing social loans to employees.","Initial Schema Internal Code List - September 2005","New","April 2009","April 2009"]
[134,"GVEA","Salary & Benefits","Austrian Government Employees Category A","Transaction is payment to category A Austrian government employees.","Maintenance SR2009","New","April 2009","April 2009"]
[135,"GVEB","Salary & Benefits","Austrian Government Employees Category B","Transaction is payment to category B Austrian government employees.","Maintenance SR2009","New","April 2009","April 2009"]
[136,"GVEC","Salary & Benefits","Austrian Government Employees Category C","Transaction is payment to category C Austrian government employees.","Maintenance SR2009","New","April 2009","April 2009"]
[137,"GVED","Salary & Benefits","Austrian Government Employees Category D","Transaction is payment to category D Austrian government employees.","Maintenance SR2009","New","April 2009","April 2009"]
[138,"PAYR","Salary & Benefits","Payroll","Transaction is related to the payment of payroll.","Initial Schema Internal Code List - September 2005","New","April 2009","April 2009"]
[139,"PENS","Salary & Benefits","PensionPayment","Transaction is the payment of pension.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[140,"PRCP","Salary & Benefits","PricePayment","Transaction is related to a payment of a price.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[141,"SALA","Salary & Benefits","SalaryPayment","Transaction is the payment of salaries.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[142,"SSBE","Salary & Benefits","SocialSecurityBenefit","Transaction is a social security benefit, ie payment made by a government to support individuals.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[143,"AEMP","Salary&Benefits","ActiveEmploymentPolicy","Payment concerning active employment policy.","CodeEval 2Q2012 (CR0244.The Bank Association of Slovenia)","New","16 July 2012","16 July 2012"]
[144,"GFRP","Salary&Benefits","GuaranteeFundRightsPayment","Compensation to unemployed persons during insolvency procedures.","CodeEval 2Q2012 (CR0244.The Bank Association of Slovenia)","New","16 July 2012","16 July 2012"]
[145,"GWLT","Salary&Benefits","GovermentWarLegislationTransfer","Payment to victims of war violence and to disabled soldiers.","CodeEval 2Q2012 (CR0244.The Bank Association of Slovenia)","New","16 July 2012","16 July 2012"]
[146,"HREC","Salary&Benefits","Housing Related Contribution","Transaction is a contribution by an employer to the housing expenditures (purchase, construction, renovation) of the employees within a tax free fringe benefit system ","Code Eval 3Q2014 CR0459 - Hungary","New","2014-11-28","2014-11-28"]
[147,"RHBS","Salary&Benefits","RehabilitationSupport","Benefit for the duration of occupational rehabilitation.","CodeEval 2Q2012 (CR0244.The Bank Association of Slovenia)","New","16 July 2012","16 July 2012"]
[148,"ESTX","Tax","EstateTax","Transaction is related to a payment of estate tax.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[149,"FWLV","Tax","Foreign Worker Levy ","Transaction is related to a payment of Foreign Worker Levy","Code Eval 1Q2013\nCR0255 - Singapore","New","6 May 2013","7 May 2013"]
[150,"GSTX","Tax","Goods & Services Tax ","Transaction is the payment of Goods & Services Tax","Code Eval 1Q2013\nCR0255 - Singapore","New","6 May 2013","7 May 2013"]
[151,"HSTX","Tax","HousingTax","Transaction is related to a payment of housing tax.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[152,"INTX","Tax","IncomeTax","Transaction is related to a payment of income tax.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[153,"NITX","Tax","NetIncomeTax","Transaction is related to a payment of net income tax.","Initial Schema Internal Code List - September 2005","New","April 2009","April 2009"]
[154,"PTXP","Tax","Property Tax ","Transaction is related to a payment of property tax.","Code Eval 1Q2013\nCR0255 - Singapore","New","6 May 2013","7 May 2013"]
[155,"RDTX","Tax","Road Tax ","Transaction is related to a payment of road tax.","Code Eval 1Q2013\nCR0255 - Singapore","New","6 May 2013","7 May 2013"]
[156,"TAXS","Tax","TaxPayment","Transaction is the payment of taxes.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[157,"VATX","Tax","ValueAddedTaxPayment","Transaction is the payment of value added tax.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[158,"WHLD","Tax","WithHolding","Transaction is related to a payment of withholding tax.","Initial Schema Internal Code List - September 2005","New","April 2009","April 2009"]
[159,"TAXR","Tax ","TaxRefund","Transaction is the refund of a tax payment or obligation.","CR0155/CGI Group","New","9 February 2012","9 February 2012"]
[160,"AIRB","Transport","Air","Transaction is a payment for air transport related business.","Payments Harmonisation 2006 External Code List","Definition updated","April 2009","April 2009"]
[161,"BUSB","Transport","Bus","Transaction is a payment for bus transport related business.","Payments Harmonisation 2006 External Code List","Definition updated","April 2009","April 2009"]
[162,"FERB","Transport","Ferry","Transaction is a payment for ferry related business.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[163,"RLWY","Transport","Railway","Transaction is a payment for railway transport related business.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[164,"TRPT","Transport","RoadPricing","Transaction is for the payment to top-up pre-paid card and electronic road pricing for the purpose of transportation","Code Eval 1Q2013\nCR0255 - Singapore","New","6 May 2013","7 May 2013"]
[165,"CBTV","Utilities","CableTVBill","Transaction is related to a payment of cable TV bill.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[166,"ELEC","Utilities","ElectricityBill","Transaction is related to a payment of electricity bill.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[167,"ENRG","Utilities","Energies","Transaction is related to a utility operation.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[168,"GASB","Utilities","GasBill","Transaction is related to a payment of gas bill.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[169,"NWCH","Utilities","NetworkCharge","Transaction is related to a payment of network charges.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[170,"NWCM","Utilities","NetworkCommunication","Transaction is related to a payment of network communication.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[171,"OTLC","Utilities","OtherTelecomRelatedBill","Transaction is related to a payment of other telecom related bill.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[172,"PHON","Utilities","TelephoneBill","Transaction is related to a payment of telephone bill.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[173,"UBIL","Utilities","Utilities ","Transaction is for the payment to common utility provider that provide gas, water and/or electricity.","Code Eval 1Q2013\nCR0255 - Singapore","New","6 May 2013","7 May 2013"]
[174,"WTER","Utilities","WaterBill","Transaction is related to a payment of water bill.","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[]
["1. The column \"Classification\" has been provided for convenience only.  It has no function within the schema."]

{"sheet":"12-ReportingSource","index":16,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,5,2,8]],"flags":["formulas_cached_only"]}
[]
["ExternalReportingSource1Code"]
["Identification",null,null,null,"Information/Details","Status"]
[null,"\nCode","\nName","\nDefinition",null,"Origin/Requester","Status","Status Date","Introduced Date"]
[1,"ACCT","Accounting","Statement or Report is based on accounting data.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[2,"ARPF","Account Reconciliation System - Full","An account reconciliation system that provides full reconciliation that usually addresses checks",null,"Maintenance SR2009","New","April 2009","April 2009"]
[3,"ARPP","Account Reconciliation System - Partial","An account reconciliation system that provides partial reconciliation that usually addresses checks",null,"Maintenance SR2009","New","April 2009","April 2009"]
[4,"CTDB","Controlled Disbursement System","A sub-application that reports presentment totals",null,"Maintenance SR2009","New","April 2009","April 2009"]
[5,"CUST","Custody","Statement or Report is based on custody data.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[6,"DEPT","Deposit System","Cash or deposit accounting system",null,"Maintenance SR2009","New","April 2009","April 2009"]
[7,"DPCS","Deposit Concentration System","Deposit system that reports what has been collected from various financial institutions",null,"Maintenance SR2009","New","April 2009","April 2009"]
[8,"LKBX","Lockbox","Processing system that captures and reports check data in a lockbox environment.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[9,"RCPT","Receipts ","A system that reports consolidated remittance information obtained from various , i.e., ACH, wires, lockbox, etc.",null,"Maintenance SR2009","New","April 2009","April 2009"]

{"sheet":"13-ReturnReason","index":17,"n_rows":58,"n_cols":9,"rows_kept":58,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,5,2,8]],"flags":["formulas_cached_only"]}
[]
["ExternalReturnReason1Code"]
["Identification",null,null,null,"Information/Details","Status"]
[null,"\nCode","\nName","\nDefinition",null,"Origin/Requester","Status","Status Date","Introduced Date"]
[1,"AC01","IncorrectAccountNumber","Format of the account number specified is not correct",null,"Maintenance SR2009","New","April 2009","April 2009"]
[2,"AC03","InvalidCreditorAccountNumber","Wrong IBAN in SCT",null,"CodeEval 3Q2012 CR0247-CFONB.","New","08 Oct 2012","08 Oct 2012"]
[3,"AC04","ClosedAccountNumber","Account number specified has been closed on the bank of account's books",null,"Maintenance SR2009","New","April 2009","April 2009"]
[4,"AC06","BlockedAccount","Account specified is blocked, prohibiting posting of transactions against it.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[5,"AC13","InvalidDebtorAccountType","Debtor account type is missing or invalid",null,"CodeEval 1Q2013 CR0257 - EPC","New","6 May 2013","7 May 2013"]
[6,"AG01","TransactionForbidden","Transaction forbidden on this type of account (formerly NoAgreement)",null,"Maintenance SR2009","New","April 2009","April 2009"]
[7,"AG02","InvalidBankOperationCode","Bank Operation code specified in the message is not valid for receiver",null,"Maintenance SR2009","New","April 2009","April 2009"]
[8,"AM01","ZeroAmount","Specified message amount is equal to zero",null,"Maintenance SR2009","New","April 2009","April 2009"]
[9,"AM02","NotAllowedAmount","Specific transaction/message amount is greater than allowed maximum",null,"Maintenance SR2009","New","April 2009","April 2009"]
[10,"AM03","NotAllowedCurrency","Specified message amount is an non processable currency outside of existing agreement",null,"Maintenance SR2009","New","April 2009","April 2009"]
[11,"AM04","InsufficientFunds","Amount of funds available to cover specified message amount is insufficient.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[12,"AM05","Duplication","Duplication",null,"Maintenance SR2009","New","April 2009","April 2009"]
[13,"AM06","TooLowAmount","Specified transaction amount is less than agreed minimum.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[14,"AM07","BlockedAmount","Amount of funds available to cover specified message amount is insufficient.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[15,"AM09","WrongAmount","Amount received is not the amount agreed or expected",null,"Maintenance SR2009","New","April 2009","April 2009"]
[16,"AM10","InvalidControlSum","Sum of instructed amounts does not equal the control sum.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[17,"ARDT","AlreadyReturnedTransaction","Already returned original SCT",null,"CodeEval 3Q2012 CR0247-CFONB.","New","08 Oct 2012","08 Oct 2012"]
[18,"BE01","InconsistenWithEndCustomer","Identification of end customer is not consistent with associated account number (formerly CreditorConsistency).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[19,"BE04","MissingCreditorAddress","Specification of creditor's address, which is required for payment, is missing/not correct (formerly IncorrectCreditorAddress).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[20,"BE05","UnrecognisedInitiatingParty","Party who initiated the message is not recognised by the end customer",null,"Maintenance SR2009","New","April 2009","April 2009"]
[21,"BE06","UnknownEndCustomer","End customer specified is not known at associated Sort/National Bank Code or does no longer exist in the books",null,"Maintenance SR2009","New","April 2009","April 2009"]
[22,"BE07","MissingDebtorAddress","Specification of debtor's address, which is required for payment, is missing/not correct.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[23,"CNOR","Creditor bank is not registered ","Creditor bank is not registered under this BIC in the CSM",null,"CodeEval 2Q2012 (CR0243. EPC)","New","16 July 2012","16 July 2012"]
[24,"CURR","IncorrectCurrency","Currency of the payment is incorrect",null,"Maintenance SR2009","New","April 2009","April 2009"]
[25,"CUST","RequestedByCustomer","Cancellation requested by the Debtor",null,"Maintenance SR2009","New","April 2009","April 2009"]
[26,"DNOR","Debtor bank is not registered","Debtor bank is not registered under this BIC in the CSM",null,"CodeEval 2Q2012 (CR0243. EPC)","New","16 July 2012","16 July 2012"]
[27,"DT01","InvalidDate","Invalid date (eg, wrong settlement date)",null,"Maintenance SR2009","New","April 2009","April 2009"]
[28,"ED01","CorrespondentBankNotPossible","Correspondent bank not possible.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[29,"ED03","BalanceInfoRequest","Balance of payments complementary info is requested",null,"Maintenance SR2009","New","April 2009","April 2009"]
[30,"ED05","SettlementFailed","Settlement of the transaction has failed.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[31,"EMVL","EMV Liability Shift","The card payment is fraudulent and was not processed with EMV technology for an EMV card. ",null,"CR0154/Berlin Group","New","9 February 2012","9 February 2012"]
[32,"FF05","InvalidLocalInstrumentCode","Local Instrument code is missing or invalid",null,"CodeEval 1Q2013 CR0257 - EPC","New","6 May 2013","7 May 2013"]
[33,"FOCR","FollowingCancellationRequest","Return following a cancellation request",null,"4Q2009 CR0006/EPC","New","January 2010","January 2010"]
[34,"MD01","NoMandate","No Mandate",null,"Maintenance SR2009","New","April 2009","April 2009"]
[35,"MD02","MissingMandatoryInformationIn Mandate","Mandate related information data required by the scheme is missing.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[36,"MD06","RefundRequestByEndCustomer","Return of funds requested by end customer",null,"Maintenance SR2009","New","April 2009","April 2009"]
[37,"MD07","EndCustomerDeceased","End customer is deceased.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[38,"MS02","NotSpecifiedReasonCustomer Generated","Reason has not been specified by end customer",null,"Maintenance SR2009","New","April 2009","April 2009"]
[39,"MS03","NotSpecifiedReasonAgent     Generated","Reason has not been specified by agent.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[40,"NARR","Narrative","Reason is provided as narrative information in the additional reason information.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[41,"NOAS ","NoAnswerFromCustomer","No response from Beneficiary",null,"CodeEval 3Q2012 CR0247-CFONB","New","08 Oct 2012","08 Oct 2012"]
[42,"NOOR","NoOriginalTransactionReceived","Original SCT never received",null,"CodeEval 3Q2012 CR0247-CFONB","New","08 Oct 2012","08 Oct 2012"]
[43,"PINL","PIN Liability Shift","The card payment is fraudulent (lost and stolen fraud) and was processed as EMV transaction without PIN verification.",null,"CR0154/Berlin Group","New","9 February 2012","9 February 2012"]
[44,"RC01","BankIdentifierIncorrect","Bank Identifier code specified in the message has an incorrect format (formerly IncorrectFormatForRoutingCode).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[45,"RC07","InvalidCreditorBICIdentifier ","Incorrrect BIC of the beneficiary Bank in the SCTR",null,"CodeEval 3Q2012 CR0247-CFONB","New","08 Oct 2012","08 Oct 2012"]
[46,"RF01","NotUniqueTransactionReference","Transaction reference is not unique within the message.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[47,"RR01","Missing Debtor Account or Identification","Specification of the debtor’s account or unique identification needed for reasons of regulatory requirements is insufficient or missing",null,"Maintenance SR2009","New","April 2009","April 2009"]
[48,"RR02","Missing Debtor Name or Address","Specification of the debtor’s name and/or address needed for regulatory requirements is insufficient or missing.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[49,"RR03","Missing Creditor Name or Address","Specification of the creditor’s name and/or address needed for regulatory requirements is insufficient or missing.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[50,"RR04","Regulatory Reason ","Regulatory Reason",null,"Maintenance SR2009","New","April 2009","April 2009"]
[51,"SL01","Specific Service offered by Debtor Agent","Due to specific service offered by the Debtor Agent",null,"Maintenance SR2009","New","April 2009","April 2009"]
[52,"SL02","Specific Service offered by Creditor Agent","Due to specific service offered by the Creditor Agent",null,"Maintenance SR2009","New","April 2009","April 2009"]
[53,"SVNR","ServiceNotRendered","The card payment is returned since a cash amount rendered was not correct or goods or a service was not rendered to the customer, e.g. in an e-commerce situation.",null,"CR0154/Berlin Group","New","9 February 2012","9 February 2012"]
[54,"TM01","CutOffTime","Associated message was received after agreed processing cut-off time.",null,"Maintenance SR2009","New","April 2009","April 2009"]

{"sheet":"14-ReversalReason ","index":18,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,5,2,8]],"flags":["formulas_cached_only"]}
[]
["ExternalReversalReason1Code"]
["Identification",null,null,null,"Information/Details","Status"]
[null,"\nCode","\nName","\nDefinition",null,"Origin/Requester","Status","Status Date","Introduced Date"]
[1,"AC03","InvalidCreditorAccountNumber","Wrong IBAN in  SCT",null,"CodeEval 3Q2012 CR0248-CFONB.","New","08 Oct 2012","08 Oct 2012"]
[2,"AC04","ClosedAccountNumber","Account number specified has been closed on the Receiver's books",null,"Maintenance SR2009","New","April 2009","April 2009"]
[3,"AG02","InvalidBankOperationCode","Bank Operation code specified in the message is not valid for receiver",null,"Maintenance SR2009","New","April 2009","April 2009"]
[4,"AM05","Duplication","Duplication",null,"Maintenance SR2009","New","April 2009","April 2009"]
[5,"AM09","WrongAmount","Wrong amount in SCT",null,"CodeEval 3Q2012 CR0248-CFONB.","New","08 Oct 2012","08 Oct 2012"]
[6,"MD01","NoMandate","No Mandate",null,"Maintenance SR2009","New","April 2009","April 2009"]
[7,"MD05","CollectionNotDue","Creditor or creditor's agent should not have collected the direct debit",null,"Maintenance SR2009","New","April 2009","April 2009"]
[8,"MS02","NotSpecifiedReasonCustomerGenerated","Reason has not been specified by end customer",null,"Maintenance SR2009","New","April 2009","April 2009"]
[9,"MS03","NotSpecifiedReasonAgentGenerated","Reason has not been specified by agent.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[10,"RC07","InvalidCreditorBICIdentifier","Wrong BIC in SCT",null,"CodeEval 3Q2012 CR0248-CFONB.","New","08 Oct 2012","08 Oct 2012"]
[11,"TM01","CutOffTime","Associated message was received after agreed processing cut-off time.",null,"Maintenance SR2009","New","April 2009","April 2009"]

{"sheet":"15-ServiceLevel","index":19,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,5,2,8]],"flags":["formulas_cached_only"]}
[]
["ExternalServiceLevel1Code"]
["Identification",null,null,null,"Information/Details","Status"]
[null,"\nCode","\nName","\nDefinition",null,"\nOrigin/Requester","Status","Status Date","Introduced Date"]
[1,"BKTR","Book Transaction","Payment through internal book transfer.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[2,"NUGP","Non-urgent Priority Payment","Payment must be executed as a non-urgent transaction with priority settlement.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[3,"NURG","Non-urgent Payment","Payment must be executed as a non-urgent transaction, which is typically identified as an ACH or low value transaction. ",null,"Maintenance SR2009","New","April 2009","April 2009"]
[4,"PRPT","EBAPriorityService","Transaction must be processed according to the EBA Priority Service.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[5,"SDVA","SameDayValue","Payment must be executed with same day value to the creditor.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[6,"SEPA","SingleEuroPaymentsArea","Payment must be executed following the Single Euro Payments Area scheme.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[7,"SVDE","Domestic Cheque Clearing and Settlement","Payment execution following the cheque agreement and traveller cheque agreement of the German Banking Industry Committee (Die Deutsche Kreditwirtschaft - DK) and Deutsche Bundesbank – Scheck Verrechnung Deutschland",null,"CR0469/Deutsche Bundesbank","New","31 August 2015","31 August 2015"]
[8,"URGP","Urgent Payment","Payment must be executed as an urgent transaction cleared through a real-time gross settlement system, which is typically identified as a wire or high value transaction.  ",null,"Maintenance SR2009","New","April 2009","April 2009"]
[9,"URNS","Urgent Payment Net Settlement","Payment must be executed as an urgent transaction cleared through a real-time net settlement system, which is typically identified as a wire or high value transaction.  ",null,"Maintenance SR2009","New","April 2009","April 2009"]

{"sheet":"16-StatusReason","index":20,"n_rows":192,"n_cols":9,"rows_kept":192,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,5,2,8],[1,0,1,8]],"flags":["formulas_cached_only"]}
[]
["ExternalStatusReason1Code"]
["Identification",null,null,null,"Information/Details","Status"]
[null,"\nCode","\nName","\nDefinition",null,"Origin/Requester","Status","Status Date","Introduced Date"]
[1,"AC01","IncorrectAccountNumber","Account number is invalid or missing.   \n",null,"Maintenance SR2009","Definition updated (CR0010)","August 2010","April 2009"]
[2,"AC02","InvalidDebtorAccountNumber","Debtor account number invalid or missing",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[3,"AC03","InvalidCreditorAccountNumber","Creditor account number invalid or missing",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[4,"AC04","ClosedAccountNumber","Account number specified has been closed on the bank of account's books. ",null,"Maintenance SR2009","Definition updated (CR0010)","August 2010","April 2009"]
[5,"AC05","ClosedDebtorAccountNumber","Debtor account number closed",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[6,"AC06","BlockedAccount","Account specified is blocked, prohibiting posting of transactions against it.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[7,"AC07","ClosedCreditorAccountNumber","Creditor account number closed",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[8,"AC08","InvalidBranchCode","Branch code is invalid or missing",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[9,"AC09","InvalidAccountCurrency","Account currency is invalid or missing",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[10,"AC10","InvalidDebtorAccountCurrency","Debtor account currency is invalid or missing",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[11,"AC11","InvalidCreditorAccountCurrency","Creditor account currency is invalid or missing",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[12,"AC12","InvalidAccountType","Account type missing or invalid.\nGeneric usage if cannot specify between group and payment information levels",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[13,"AC13","InvalidDebtorAccountType","Debtor account type missing or invalid",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[14,"AC14","InvalidCreditorAccountType","Creditor account type missing or invalid",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[15,"AG01","TransactionForbidden","Transaction forbidden on this type of account (formerly NoAgreement)",null,"Maintenance SR2009","New","April 2009","April 2009"]
[16,"AG02","InvalidBankOperationCode","Bank Operation code specified in the message is not valid for receiver",null,"Maintenance SR2009","New","April 2009","April 2009"]
[17,"AG03","TransactionNotSupported","Transaction type not supported/authorized on this account ",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[18,"AG04","InvalidAgentCountry","Agent country code is missing or invalid.\nGeneric usage if cannot specify between group and payment information levels.",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[19,"AG05","InvalidDebtorAgentCountry","Debtor agent country code is missing or invalid",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[20,"AG06","InvalidCreditorAgentCountry","Creditor agent country code is missing or invalid",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[21,"AG07","UnsuccesfulDirectDebit","Debtor account cannot be debited for a generic reason.\nCode value may be used in general purposes and as a replacement for AM04 if debtor bank does not reveal its customer's insufficient funds for privacy reasons",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[22,"AG08","InvalidAccessRights","Transaction failed due to invalid or missing user or access right",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[23,"AGNT","IncorrectAgent","Agent in the payment workflow is incorrect",null,"Maintenance SR2009","New","April 2009","April 2009"]
[24,"AM01","ZeroAmount","Specified message amount is equal to zero",null,"Maintenance SR2009","New","April 2009","April 2009"]
[25,"AM02","NotAllowedAmount","Specific transaction/message amount is greater than allowed maximum",null,"Maintenance SR2009","New","April 2009","April 2009"]
[26,"AM03","NotAllowedCurrency","Specified message amount is an non processable currency outside of existing agreement",null,"Maintenance SR2009","New","April 2009","April 2009"]
[27,"AM04","InsufficientFunds","Amount of funds available to cover specified message amount is insufficient.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[28,"AM05","Duplication","Duplication",null,"Maintenance SR2009","New","April 2009","April 2009"]
[29,"AM06","TooLowAmount","Specified transaction amount is less than agreed minimum.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[30,"AM07","BlockedAmount","Amount of funds available to cover specified message amount is insufficient.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[31,"AM09","WrongAmount","Amount received is not the amount agreed or expected",null,"Maintenance SR2009","New","April 2009","April 2009"]
[32,"AM10","InvalidControlSum","Sum of instructed amounts does not equal the control sum.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[33,"AM11","InvalidTransactionCurrency","Transaction currency is invalid or missing",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[34,"AM12","InvalidAmount","Amount is invalid or missing",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[35,"AM13","AmountExceedsClearingSystemLimit","Transaction amount exceeds limits set by clearing system",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[36,"AM14","AmountExceedsAgreedLimit","Transaction amount exceeds limits agreed between bank and client",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[37,"AM15","AmountBelowClearingSystemMinimum","Transaction amount below minimum set by clearing system",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[38,"AM16","InvalidGroupControlSum","Control Sum at the Group level is invalid",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[39,"AM17","InvalidPaymentInfoControlSum","Control Sum at the Payment Information level is invalid",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[40,"AM18","InvalidNumberOfTransactions","Number of transactions is invalid or missing.\nGeneric usage if cannot specify between group and payment information levels.",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[41,"AM19","InvalidGroupNumberOfTransactions","Number of transactions at the Group level is invalid or missing",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[42,"AM20","InvalidPaymentInfoNumberOfTransactions","Number of transactions at the Payment Information level is invalid",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[43,"AM21","LimitExceeded","Transaction amount exceeds limits agreed between bank and client.",null,"CodeEval 1Q2011 (CR0059/EBICS)","New","14 Feb 2011","14 Feb 2011"]
[44,"BE01","InconsistenWithEndCustomer","Identification of end customer is not consistent with associated account number. (formerly CreditorConsistency).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[45,"BE04","MissingCreditorAddress","Specification of creditor's address, which is required for payment, is missing/not correct (formerly IncorrectCreditorAddress).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[46,"BE05","UnrecognisedInitiatingParty","Party who initiated the message is not recognised by the end customer",null,"Maintenance SR2009","New","April 2009","April 2009"]
[47,"BE06","UnknownEndCustomer","End customer specified is not known at associated Sort/National Bank Code or does no longer exist in the books",null,"Maintenance SR2009","New","April 2009","April 2009"]
[48,"BE07","MissingDebtorAddress","Specification of debtor's address, which is required for payment, is missing/not correct.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[49,"BE08","MissingDebtorName","Debtor name is missing",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[50,"BE09","InvalidCountry","Country code is missing or Invalid.\nGeneric usage if cannot specifically identify debtor or creditor",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[51,"BE10","InvalidDebtorCountry","Debtor country code is missing or invalid",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[52,"BE11","InvalidCreditorCountry","Creditor country code is missing or invalid",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[53,"BE12","InvalidCountryOfResidence","Country code of residence is missing or Invalid.\nGeneric usage if cannot specifically identify debtor or creditor",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[54,"BE13","InvalidDebtorCountryOfResidence","Country code of debtor's residence is missing or Invalid",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[55,"BE14","InvalidCreditorCountryOfResidence","Country code of creditor's residence is missing or Invalid",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[56,"BE15","InvalidIdentificationCode","Identification code missing or invalid.\nGeneric usage if cannot specifically identify debtor or creditor.",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[57,"BE16","InvalidDebtorIdentificationCode","Debtor or Ultimate Debtor identification code missing or invalid",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[58,"BE17","InvalidCreditorIdentificationCode","Creditor or Ultimate Creditor identification code missing or invalid",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[59,"BE18","InvalidContactDetails","Contact details missing or invalid",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[60,"BE19","InvalidChargeBearerCode","Charge bearer code for transaction type is invalid",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[61,"BE20","InvalidNameLength","Name length exceeds local rules for payment type.",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[62,"BE21","MissingName","Name missing or invalid.  Generic usage if cannot specifically identify debtor or creditor.",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[63,"BE22","MissingCreditorName","Creditor name is missing",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[64,"CH03","RequestedExecutionDateOrRequestedCollectionDateTooFarInFuture","Value in Requested Execution Date or Requested Collection Date is too far in the future",null,"CodeEval 4Q2012 (CR242 v3/SIX)","New","17 December 2012","17 December 2012"]
[65,"CH04","RequestedExecutionDateOrRequestedCollectionDateTooFarInPast","Value in Requested Execution Date or Requested Collection Date is too far in the past",null,"CodeEval 4Q2012 (CR242 v3/SIX)","New","17 December 2012","17 December 2012"]
[66,"CH07","ElementIsNotToBeUsedAtB-andC-Level","Element is not to be used at B- and C-Level",null,"CodeEval 4Q2012 (CR242 v3/SIX)","New","17 December 2012","17 December 2012"]
[67,"CH09","MandateChangesNotAllowed","Mandate changes are not allowed",null,"CodeEval 4Q2012 (CR242 v3/SIX)","New","17 December 2012","17 December 2012"]
[68,"CH10","InformationOnMandateChangesMissing","Information on mandate changes are missing",null,"CodeEval 4Q2012 (CR242 v3/SIX)","New","17 December 2012","17 December 2012"]
[69,"CH11","CreditorIdentifierIncorrect","Value in Creditor Identifier is incorrect",null,"CodeEval 4Q2012 (CR242 v3/SIX)","New","17 December 2012","17 December 2012"]
[70,"CH12","CreditorIdentifierNotUnambiguouslyAtTransaction-Level","Creditor Identifier is ambiguous at Transaction Level",null,"CodeEval 4Q2012 (CR242 v3/SIX)","New","17 December 2012","17 December 2012"]
[71,"CH13","OriginalDebtorAccountIsNotToBeUsed","Original Debtor Account is not to be used",null,"CodeEval 4Q2012 (CR242 v3/SIX)","New","17 December 2012","17 December 2012"]
[72,"CH14","OriginalDebtorAgentIsOnlyToBeUsedWithSequenceTypeFRST","Original Debtor Agent is only to be used with Sequence Type=FRST",null,"CodeEval 4Q2012 (CR242 v3/SIX)","New","17 December 2012","17 December 2012"]
[73,"CH15","ElementContentIncludesMoreThan140Charac­ters","Content Remittance Information/Structured includes more than 140 characters",null,"CodeEval 4Q2012 (CR242 v3/SIX)","New","17 December 2012","17 December 2012"]
[74,"CH16","ElementContentFormallyIncorrect","Content is incorrect",null,"CodeEval 4Q2012 (CR242 v3/SIX)","New","17 December 2012","17 December 2012"]
[75,"CH17","ElementNotAdmitted","Element is not allowed",null,"CodeEval 4Q2012 (CR242 v3/SIX)","New","17 December 2012","17 December 2012"]
[76,"CH19","ValuesWillBeSetToNextTARGETday","Values in Interbank Settlement Date or Requested Collection Date will be set to the next TARGET day",null,"CodeEval 4Q2012 (CR242 v3/SIX)","New","17 December 2012","17 December 2012"]
[77,"CH20","DecimalPointsNotCompatibleWithCurrency","Number of decimal points not compatible with the currency",null,"CodeEval 4Q2012 (CR242 v3/SIX)","New","17 December 2012","17 December 2012"]
[78,"CH21","RequiredCompulsoryElementMissing ","Mandatory element is missing ",null,"CodeEval 4Q2012 (CR242 v3/SIX)","New","17 December 2012","17 December 2012"]
[79,"CH22","COREandB2BwithinOnemessage ","SDD CORE and B2B not permitted within one message ",null,"CodeEval 4Q2012 (CR242 v3/SIX)","New","17 December 2012","17 December 2012"]
[80,"CNOR","Creditor bank is not registered ","Creditor bank is not registered under this BIC in the CSM",null,"CodeEval 2Q2012 (CR0243. EPC)","New","16 July 2012","16 July 2012"]
[81,"CURR","IncorrectCurrency","Currency of the payment is incorrect",null,"Maintenance SR2009","New","April 2009","April 2009"]
[82,"CUST","RequestedByCustomer","Cancellation requested by the Debtor",null,"Maintenance SR2009","New","April 2009","April 2009"]
[83,"DNOR","Debtor bank is not registered","Debtor bank is not registered under this BIC in the CSM",null,"CodeEval 2Q2012 (CR0243. EPC)","New","16 July 2012","16 July 2012"]
[84,"DS01","ElectronicSignaturesCorrect","The electronic signature(s) is/are correct",null,"CodeEval 1Q2011 (CR0059/EBICS)","New","14 Feb 2011","14 Feb 2011"]
[85,"DS02","OrderCancelled","An authorized user has cancelled the order",null,"CodeEval 1Q2011 (CR0059/EBICS)","New","14 Feb 2011","14 Feb 2011"]
[86,"DS03","OrderNotCancelled","The user’s attempt to cancel the order was not successful ",null,"CodeEval 1Q2011 (CR0059/EBICS)","New","14 Feb 2011","14 Feb 2011"]
[87,"DS04","OrderRejected","The order was rejected by the bank side (for reasons concerning content)",null,"CodeEval 1Q2011 (CR0059/EBICS)","New","14 Feb 2011","14 Feb 2011"]
[88,"DS05","OrderForwardedForPostprocessing","The order was correct and could be forwarded for postprocessing",null,"CodeEval 1Q2011 (CR0059/EBICS)","New","14 Feb 2011","14 Feb 2011"]
[89,"DS06","TransferOrder","The order was transferred to VEU",null,"CodeEval 1Q2011 (CR0059/EBICS)","New","14 Feb 2011","14 Feb 2011"]
[90,"DS07","ProcessingOK","All actions concerning the order could be done by the EBICS bank server",null,"CodeEval 1Q2011 (CR0059/EBICS)","New","14 Feb 2011","14 Feb 2011"]
[91,"DS08","DecompressionError","The decompression of the file was not successful",null,"CodeEval 1Q2011 (CR0059/EBICS)","New","14 Feb 2011","14 Feb 2011"]
[92,"DS09","DecryptionError","The decryption of the file was not successful",null,"CodeEval 1Q2011 (CR0059/EBICS)","New","14 Feb 2011","14 Feb 2011"]
[93,"DS0A","DataSignRequested","Data signature is required.",null,"France/Stella Petiot & Isabelle DeMendonca","New","April 2009","April 2009"]
[94,"DS0B","UnknownDataSignFormat","Data signature for the format is not available or invalid.",null,"France/Stella Petiot & Isabelle DeMendonca","New","April 2009","April 2009"]
[95,"DS0C","SignerCertificateRevoked","The signer certificate is revoked.",null,"France/Stella Petiot & Isabelle DeMendonca","New","April 2009","April 2009"]
[96,"DS0D","SignerCertificateNotValid","The signer certificate is not valid (revoked or not active).",null,"France/Stella Petiot & Isabelle DeMendonca","New","April 2009","April 2009"]
[97,"DS0E","IncorrectSignerCertificate","The signer certificate is not present.",null,"France/Stella Petiot & Isabelle DeMendonca","New","April 2009","April 2009"]
[98,"DS0F","SignerCertificationAuthoritySignerNotValid","The authority of the signer certification sending the certificate is unknown.",null,"France/Stella Petiot & Isabelle DeMendonca","New","April 2009","April 2009"]
[99,"DS0G","NotAllowedPayment","Signer is not allowed to sign this operation type.",null,"France/Stella Petiot & Isabelle DeMendonca","New","April 2009","April 2009"]
[100,"DS0H","NotAllowedAccount","Signer is not allowed to sign for this account.",null,"France/Stella Petiot & Isabelle DeMendonca","New","April 2009","April 2009"]
[101,"DS0K","NotAllowedNumberOfTransaction","The number of transaction is over the number allowed for this signer.",null,"France/Stella Petiot & Isabelle DeMendonca","New","April 2009","April 2009"]
[102,"DS10","Signer1CertificateRevoked","The certificate is revoked for the first signer.",null,"France/Stella Petiot & Isabelle DeMendonca","New","April 2009","April 2009"]
[103,"DS11","Signer1CertificateNotValid","The certificate is not valid (revoked or not active) for the first signer.",null,"France/Stella Petiot & Isabelle DeMendonca","New","April 2009","April 2009"]
[104,"DS12","IncorrectSigner1Certificate","The certificate is not present for the first signer.",null,"France/Stella Petiot & Isabelle DeMendonca","New","April 2009","April 2009"]
[105,"DS13","SignerCertificationAuthoritySigner1NotValid","The authority of signer certification sending the certificate is unknown for the first signer.",null,"France/Stella Petiot & Isabelle DeMendonca","New","April 2009","April 2009"]
[106,"DS14","UserDoesNotExist","The user is unknown on the server",null,"CodeEval 1Q2011 (CR0059/EBICS)","New","14 Feb 2011","14 Feb 2011"]
[107,"DS15","IdenticalSignatureFound","The same signature has already been sent to the bank",null,"CodeEval 1Q2011 (CR0059/EBICS)","New","14 Feb 2011","14 Feb 2011"]
[108,"DS16","PublicKeyVersionIncorrect","The public key version is not correct. This code is returned when a customer sends signature files to the financial institution after conversion from an older program version (old ES format) to a new program version (new ES format) without having carried out re-initialisation with regard to a public key change.",null,"CodeEval 1Q2011 (CR0059/EBICS)","New","14 Feb 2011","14 Feb 2011"]
[109,"DS17","DifferentOrderDataInSignatures","Order data and signatures don’t match",null,"CodeEval 1Q2011 (CR0059/EBICS)","New","14 Feb 2011","14 Feb 2011"]
[110,"DS18","RepeatOrder","File cannot be tested, the complete order has to be repeated. This code is returned in the event of a malfunction during the signature check, e.g. not enough storage space.",null,"CodeEval 1Q2011 (CR0059/EBICS)","New","14 Feb 2011","14 Feb 2011"]
[111,"DS19","ElectronicSignatureRightsInsufficient","The user’s rights (concerning his signature) are insufficient to execute the order",null,"CodeEval 1Q2011 (CR0059/EBICS)","New","14 Feb 2011","14 Feb 2011"]
[112,"DS20","Signer2CertificateRevoked","The certificate is revoked for the second signer.",null,"France/Stella Petiot & Isabelle DeMendonca","New","April 2009","April 2009"]
[113,"DS21","Signer2CertificateNotValid","The certificate is not valid (revoked or not active) for the second signer.",null,"France/Stella Petiot & Isabelle DeMendonca","New","April 2009","April 2009"]
[114,"DS22","IncorrectSigner2Certificate","The certificate is not present for the second signer.",null,"France/Stella Petiot & Isabelle DeMendonca","New","April 2009","April 2009"]
[115,"DS23","SignerCertificationAuthoritySigner2NotValid","The authority of signer certification sending the certificate is unknown for the second signer.",null,"France/Stella Petiot & Isabelle DeMendonca","New","April 2009","April 2009"]
[116,"DS24","WaitingTimeExpired","Waiting time expired due to incomplete order",null,"CodeEval 1Q2011 (CR0059/EBICS)","New","14 Feb 2011","14 Feb 2011"]
[117,"DS25","OrderFileDeleted","The order file was deleted by the bank server \n(for multiple reasons)",null,"CodeEval 1Q2011 (CR0059/EBICS)","New","14 Feb 2011","14 Feb 2011"]
[118,"DS26","UserSignedMultipleTimes","The same user has signed multiple times",null,"CodeEval 1Q2011 (CR0059/EBICS)","New","14 Feb 2011","14 Feb 2011"]
[119,"DS27","UserNotYetActivated","The user is not yet activated (technically)",null,"CodeEval 1Q2011 (CR0059/EBICS)","New","14 Feb 2011","14 Feb 2011"]
[120,"DT01","InvalidDate","Invalid date (eg, wrong or missing settlement date)",null,"Maintenance SR2009","Definition updated (CR0010)","August 2010","April 2009"]
[121,"DT02","InvalidCreationDate","Invalid creation date and time in Group Header (eg, historic date)",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[122,"DT03","InvalidNonProcessingDate","Invalid non bank processing date (eg, weekend or local public holiday)",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[123,"DT04","FutureDateNotSupported","Future date not supported",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[124,"DT05","InvalidCutOffDate","Associated message, payment information block or transaction was received after agreed processing cut-off date, i.e., date in the past.",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[125,"DT06","ExecutionDateChanged","Execution Date has been modified in order for transaction to be processed",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[126,"DU01","DuplicateMessageID","Message Identification is not unique.",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[127,"DU02","DuplicatePaymentInformationID","Payment Information Block is not unique.",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[128,"DU03","DuplicateTransaction","Transaction is not unique.",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[129,"DU04","DuplicateEndToEndID","End To End ID is not unique.",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[130,"DU05","DuplicateInstructionID","Instruction ID is not unique.",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[131,"DUPL","DuplicatePayment","Payment is a duplicate of another payment",null,"Maintenance SR2009","New","April 2009","April 2009"]
[132,"ED01","CorrespondentBankNotPossible","Correspondent bank not possible.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[133,"ED03","BalanceInfoRequest","Balance of payments complementary info is requested",null,"Maintenance SR2009","New","April 2009","April 2009"]
[134,"ED05","SettlementFailed","Settlement of the transaction has failed.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[135,"FF01","Invalid File Format","File Format incomplete or invalid",null,"Maintenance SR2009","New","April 2009","April 2009"]
[136,"FF02","SyntaxError","Syntax error reason is provided as narrative information in the additional reason information.",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[137,"FF03","InvalidPaymentTypeInformation","Payment Type Information is missing or invalid.\nGeneric usage if cannot specify Service Level or Local Instrument code",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[138,"FF04","InvalidServiceLevelCode","Service Level code is missing or invalid",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[139,"FF05","InvalidLocalInstrumentCode","Local Instrument code is missing or invalid",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[140,"FF06","InvalidCategoryPurposeCode","Category Purpose code is missing or invalid",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[141,"FF07","InvalidPurpose","Purpose is missing or invalid",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[142,"FF08","InvalidEndToEndId","End to End Id missing or invalid",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[143,"FF09","InvalidChequeNumber","Cheque number missing or invalid",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[144,"FF10","BankSystemProcessingError","File or transaction cannot be processed due to technical issues at the bank side",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[145,"ID01","CorrespondingOriginalFileStillNotSent","Signature file was sent to the bank but the corresponding original file has not been sent yet.",null,"CodeEval 1Q2011 (CR0059/EBICS)","New","14 Feb 2011","14 Feb 2011"]
[146,"MD01","NoMandate","No Mandate",null,"Maintenance SR2009","New","April 2009","April 2009"]
[147,"MD02","MissingMandatoryInformationIn Mandate","Mandate related information data required by the scheme is missing.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[148,"MD05","CollectionNotDue","Creditor or creditor's agent should not have collected the direct debit",null,"Maintenance SR2009","New","April 2009","April 2009"]
[149,"MD06","RefundRequestByEndCustomer","Return of funds requested by end customer",null,"Maintenance SR2009","New","April 2009","April 2009"]
[150,"MD07","EndCustomerDeceased","End customer is deceased.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[151,"MS02","NotSpecifiedReasonCustomer Generated","Reason has not been specified by end customer",null,"Maintenance SR2009","New","April 2009","April 2009"]
[152,"MS03","NotSpecifiedReasonAgent  Generated","Reason has not been specified by agent.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[153,"NARR","Narrative","Reason is provided as narrative information in the additional reason information.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[154,"RC01","BankIdentifierIncorrect","Bank identifier code specified in the message has an incorrect format (formerly IncorrectFormatForRoutingCode).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[155,"RC02","InvalidBankIdentifier","Bank identifier is invalid or missing.\nGeneric usage if cannot specify between debit or credit account",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[156,"RC03","InvalidDebtorBankIdentifier","Debtor bank identifier is invalid or missing",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[157,"RC04","InvalidCreditorBankIdentifier","Creditor bank identifier is invalid or missing",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[158,"RC05","InvalidBICIdentifier","BIC identifier is invalid or missing.\nGeneric usage if cannot specify between debit or credit account.",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[159,"RC06","InvalidDebtorBICIdentifier","Debtor BIC identifier is invalid or missing",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[160,"RC07","InvalidCreditorBICIdentifier","Creditor BIC identifier is invalid or missing",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[161,"RC08","InvalidClearingSystemMemberIdentifier","ClearingSystemMemberidentifier is invalid or missing.\nGeneric usage if cannot specify between debit or credit account",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[162,"RC09","InvalidDebtorClearingSystemMemberIdentifier","Debtor ClearingSystemMember identifier is invalid or missing",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[163,"RC10","InvalidCreditorClearingSystemMemberIdentifier","Creditor ClearingSystemMember identifier is invalid or missing",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[164,"RC11","InvalidIntermediaryAgent","Intermediary Agent is invalid or missing",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[165,"RC12","MissingCreditorSchemeId","Creditor Scheme Id is invalid or  missing",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[166,"RCON","R-MessageConflict","Conflict with R-Message",null,"CodeEval 3Q2014 CR0456 - Austria","New","2014-11-28","2014-11-28"]
[167,"RF01","NotUniqueTransactionReference","Transaction reference is not unique within the message.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[168,"RR01","Missing Debtor Account or Identification","Specification of the debtor’s account or unique identification needed for reasons of regulatory requirements is insufficient or missing",null,"Maintenance SR2009","New","April 2009","April 2009"]
[169,"RR02","Missing Debtor Name or Address","Specification of the debtor’s name and/or address needed for regulatory requirements is insufficient or missing.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[170,"RR03","Missing Creditor Name or Address","Specification of the creditor’s name and/or address needed for regulatory requirements is insufficient or missing.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[171,"RR04","RegulatoryReason ","Regulatory Reason",null,"Maintenance SR2009","New","April 2009","April 2009"]
[172,"RR05","RegulatoryInformationInvalid","Regulatory or Central Bank Reporting information missing, incomplete or invalid.",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[173,"RR06","TaxInformationInvalid","Tax information missing, incomplete or invalid.",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[174,"RR07","RemittanceInformationInvalid","Remittance information structure does not comply with rules for payment type.",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[175,"RR08","RemittanceInformationTruncated","Remittance information truncated to comply with rules for payment type.",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[176,"RR09","InvalidStructuredCreditorReference","Structured creditor reference invalid or missing.",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[177,"RR10","InvalidCharacterSet","Character set supplied not valid for the country and payment type.",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[178,"RR11","InvalidDebtorAgentServiceID","Invalid or missing identification of a bank proprietary service.",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[179,"RR12","InvalidPartyID","Invalid or missing identification required within a particular country or payment type.",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[180,"SL01","Specific Service offered by Debtor Agent","Due to specific service offered by the Debtor Agent",null,"Maintenance SR2009","New","April 2009","April 2009"]
[181,"SL02","Specific Service offered by Creditor Agent","Due to specific service offered by the Creditor Agent",null,"Maintenance SR2009","New","April 2009","April 2009"]
[182,"TA01","TransmissonAborted","The transmission of the file was not successful – it had to be aborted (for technical reasons)",null,"CodeEval 1Q2011 (CR0059/EBICS)","New","14 Feb 2011","14 Feb 2011"]
[183,"TD01","NoDataAvailable","There is no data available (for download)",null,"CodeEval 1Q2011 (CR0059/EBICS)","New","14 Feb 2011","14 Feb 2011"]
[184,"TD02","FileNonReadable","The file cannot be read (e.g. unknown format)",null,"CodeEval 1Q2011 (CR0059/EBICS)","New","14 Feb 2011","14 Feb 2011"]
[185,"TD03","IncorrectFileStructure","The file format is incomplete or invalid",null,"CodeEval 1Q2011 (CR0059/EBICS)","New","14 Feb 2011","14 Feb 2011"]
[186,"TM01","InvalidCutOffTime\nFormerly:  CutOffTime","Associated message, payment information block, or transaction was received after agreed processing cut-off time.",null,"Maintenance SR2009","Definition updated (CR0010)","August 2010","April 2009"]
[187,"TS01","TransmissionSuccessful","The (technical) transmission of the file was successful.",null,"CodeEval 1Q2011 (CR0059/EBICS)","New","14 Feb 2011","14 Feb 2011"]
[188,"TS04","TransferToSignByHand","The order was transferred to pass by accompanying note signed by hand",null,"CodeEval 1Q2011 (CR0059/EBICS)","New","14 Feb 2011","14 Feb 2011"]

{"sheet":"17-TechnicalInputChannel","index":21,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,4,2,7]],"flags":["formulas_cached_only"]}
[]
["ExternalTechnicalInputChannel1Code"]
["Identification",null,null,null,"Status"]
[null,"\nCode","\nName","\nDefinition","Origin/Requester","Status","Status Date","Introduced Date"]
[1,"FAXI","Fax","Technical Input Channel is fax or facsimile","Maintenance SR2009","New","April 2009","April 2009"]
[2,"PAPR","Paper","Technical Input Channel is paper","Maintenance SR2009","New","April 2009","April 2009"]
[3,"TAPE","Tape","Technical Input Channel is tape","Maintenance SR2009","New","April 2009","April 2009"]
[4,"WEBI","Internet","Technical Input Channel is internet","Maintenance SR2009","New","April 2009","April 2009"]

{"sheet":"18-VerificationReason","index":22,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,5,2,8]],"flags":["formulas_cached_only"]}
[]
["ExternalVerificationReason1Code"]
["Identification",null,null,null,"Information/Details","Status"]
[null,"\nCode","\nName","\nDefinition",null,"\nOrigin/Requester","Status","Status Date","Introduced Date"]
[1,"Currently no codes have been defined."]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]

{"sheet":"19-DocumentPurpose","index":23,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,5,2,8]],"flags":["formulas_cached_only"]}
[]
["ExternalDocumentPurpose1Code"]
["Identification",null,null,null,"Information/Details","Status"]
[null,"Code ","\nName","\nDefinition",null,"Origin/Requester","Status","Status Date","Introduced Date"]
[1,"CONF","Confirmed","The document represents a document that has been confirmed, for example an invoice that has been confirmed by the buyer for payment.\n",null,"FinancialInvoiceV01 Trade Services SEG","New","30-Nov-10","30-Nov-10"]
[2,"FINV","Factored invoice","The document represents an invoice submitted under a factoring arrangment. ",null,"FinancialInvoiceV01 Trade Services SEG","New","30-Nov-10","30-Nov-10"]

{"sheet":"20-DocumentType","index":24,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,5,2,8]],"flags":["formulas_cached_only"]}
[]
["ExternalDocumentType1Code"]
["Identification",null,null,null,"Information/Details","Status"]
[null,"Code","\nName","\nDefinition",null,"Origin/Requester","Status","Status Date","Introduced Date"]
[1,"CINV","CommercialInvoice","Document is an invoice.",null,"FinancialInvoiceV01 Trade Services SEG","New","30-Nov-10","30-Nov-10"]
[2,"CNFA","CreditNoteRelatedToFinancialAdjustment","Document is a credit note for the final amount settled for a commercial transaction.",null,"FinancialInvoiceV01 Trade Services SEG","New","30-Nov-10","30-Nov-10"]
[3,"CONT","Contract","Document is a contract evidencing an agreement between the seller and buyer for the supply of goods and/or services.",null,"FinancialInvoiceV01 Trade Services SEG","New","30-Nov-10","2010-11-30"]
[4,"CREN","CreditNote","Document is a credit note.",null,"FinancialInvoiceV01 Trade Services SEG","New","30-Nov-10","30-Nov-10"]
[5,"DEBN","DebitNote","Document is a debit note.",null,"FinancialInvoiceV01 Trade Services SEG","New","30-Nov-10","30-Nov-10"]
[6,"DISP","DispatchAdvice","Document is an advice of despatch of the goods.",null,"FinancialInvoiceV01 Trade Services SEG","New","30-Nov-10","2010-11-30"]
[7,"DNFA","DebitNoteRelatedToFinancialAdjustment","Document is a debit note for the final amount settled for a commercial transaction.",null,"FinancialInvoiceV01 Trade Services SEG","New","30-Nov-10","30-Nov-10"]
[8,"HIRI","HireInvoice","Document is an invoice for the hiring of human resources or renting goods or equipment.",null,"FinancialInvoiceV01 Trade Services SEG","New","30-Nov-10","30-Nov-10"]
[9,"INVS","InvoiceSigned","Document is a signed invoice.",null,"FinancialInvoiceV01 Trade Services SEG","New","30-Nov-10","2010-11-30"]
[10,"MSIN","MeteredServiceInvoice","Document is an invoice claiming payment for the supply of metered services, eg. Gas or electricity, supplied to a fixed meter.",null,"FinancialInvoiceV01 Trade Services SEG","New","30-Nov-10","30-Nov-10"]
[11,"PROF","ProformaInvoice","In trade transactions, a pro forma invoice is a document that states a commitment from the seller to sell goods to the buyer at specified prices and terms. It is used to declare the value of the trade. It is not a true invoice, because it is not used to record accounts receivable for the seller and accounts payable for the buyer.",null,"FinancialInvoiceV01 Trade Services SEG","New","30-Nov-10","30-Nov-10"]
[12,"PUOR","PurchaseOrder","Document is a purchase order.",null,"FinancialInvoiceV01 Trade Services SEG","New","30-Nov-10","2010-11-30"]
[13,"QUOT","Quotation","Document is a quotation setting out the conditions under which the goods and/or services are offered.",null,"FinancialInvoiceV01 Trade Services SEG","New","30-Nov-10","2010-11-30"]
[14,"SBIN","SelfBilledInvoice","Document is a statement of the transactions posted to the debtor's account at the supplier.",null,"FinancialInvoiceV01 Trade Services SEG","New","30-Nov-10","30-Nov-10"]
[15,"SPRR","SellerPresentment","Document is a document presented by the seller in support of the procurement of goods and/or services.",null,"FinancialInvoiceV01 Trade Services SEG","New","30-Nov-10","2010-11-30"]
[16,"TISH","TimeSheet","Document is a timesheet recording times for the provision of services and/or delivery of goods.",null,"FinancialInvoiceV01 Trade Services SEG","New","30-Nov-10","2010-11-30"]
[17,"USAR","UsageReport","Document is a usage report indicating the consumption pattern for designated goods and/or services.",null,"FinancialInvoiceV01 Trade Services SEG","New","30-Nov-10","2010-11-30"]

{"sheet":"21-Incoterms","index":25,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,5,2,8]],"flags":["formulas_cached_only"]}
[]
["ExternalIncoterms1Code"]
["Identification",null,null,null,"Information/Details","Status"]
[null,"\nCode","\nName","\nDefinition",null,"\nOrigin/Requester","\nStatus","Status Date","Introduced Date"]
[1,"CFR","CostAndFreight","Cost and Freight (sea and inland waterway transport) - Incoterms 2010",null,"FinancialInvoiceV01 Trade Services SEG","Updated Definition","2014-02-04","2010-11-30"]
[2,"CIF","CostInsuranceAndFreight","Cost, Insurance and Freight (sea and inland waterway transport) - Incoterms 2010",null,"FinancialInvoiceV01 Trade Services SEG","Updated Definition","2014-02-04","2010-11-30"]
[3,"CIP","CarriageAndInsurancePaid","Carriage and Insurance Paid To (any mode of transport, including multimodal) - Incoterms 2010",null,"FinancialInvoiceV01 Trade Services SEG","Updated Definition","2014-02-04","2010-11-30"]
[4,"CPT","CarriagePaid","Carriage Paid To (any mode of transport, including multimodal) - Incoterms 2010",null,"FinancialInvoiceV01 Trade Services SEG","Updated Definition","2014-02-04","2010-11-30"]
[5,"DAP","DeliveredAtPlace","Delivered at Place (any mode of transport, including multimodal) - Incoterms 2010",null,"FinancialInvoiceV01 Trade Services SEG","Updated Definition","2014-02-04","2010-11-30"]
[6,"DAT","DeliveredAtTerminal","Delivered at Terminal (any mode of transport, including multimodal) - Incoterms 2010",null,"FinancialInvoiceV01 Trade Services SEG","Updated Definition","2014-02-04","2010-11-30"]
[7,"DDP","DeliveredDutyPaid","Delivered Duty Paid (any mode of transport, including multimodal) - Incoterms 2010",null,"FinancialInvoiceV01 Trade Services SEG","Updated Definition","2014-02-04","2010-11-30"]
[8,"EXW","ExWorks","Ex Works (any mode of transport, including multimodal) - Incoterms 2010",null,"FinancialInvoiceV01 Trade Services SEG","Updated Definition","2014-02-04","2010-11-30"]
[9,"FAS","FreeAlongsideShip","Free Alongside Ship (sea and inland waterway transport) - Incoterms 2010",null,"FinancialInvoiceV01 Trade Services SEG","Updated Definition","2014-02-04","2010-11-30"]
[10,"FCA","FreeCarrier","Free Carrier (any mode of transport, including multimodal) - Incoterms 2010",null,"FinancialInvoiceV01 Trade Services SEG","Updated Definition","2014-02-04","2010-11-30"]
[11,"FOB","FreeOnBoard","Free On Board (sea and inland waterway transport) - Incoterms 2010",null,"FinancialInvoice Trade Services SEG","Updated Definition","2014-02-04","2010-11-30"]

{"sheet":"22-InformationType","index":26,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,5,2,8]],"flags":["formulas_cached_only"]}
[]
["ExternalInformationType1Code"]
["Identification",null,null,null,"Information/Details","Status"]
[null,"\nCode","\nName","\nDefinition",null,"Origin/Requester","Status","Status\nDate","Introduced Date"]
[1,"INST","ProcessingInstructions","Instructions used to ease automatic request processing.",null,"FinancialInvoiceV01 Trade Services SEG","New","2010-11-30","2010-11-30"]
[2,"OTHR","OtherInformation","Additional information not otherwise specified.",null,"FinancialInvoiceV01 Trade Services SEG","New","2010-11-30","2010-11-30"]
[3,"RELY","RelayInstructions","Instructions used to ease automatic request relay.",null,"FinancialInvoiceV01 Trade Services SEG","New","2010-11-30","2010-11-30"]
[4,"SHPG","ShippingInformation","Additional shipping information not otherwise specified.",null,"FinancialInvoiceV01 Trade Services SEG","New","2010-11-30","2010-11-30"]
[5,"SHPM","ShippingMarks","Information concerning the letters, numbers or other symbols placed on the outside of cargo to facilitate identification.",null,"FinancialInvoiceV01 Trade Services SEG","New","2010-11-30","2010-11-30"]
[6,"SLDC","SellerDomicileLocation","Information concerning the domicile location of the seller.",null,"FinancialInvoiceV01 Trade Services SEG","New","2010-11-30","2010-11-30"]

{"sheet":"23-PackagingTypeCode","index":27,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,5,2,8]],"flags":["formulas_cached_only"]}
[]
["ExternalPackagingType1Code"]
["Identification",null,null,null,"Information/Details","Status"]
[null,"\nCode","\nName","\nDefinition",null,"\nOrigin/Requester","Status","Status Date","Introduced Date"]
[1,"HDPE","HighDensityPolyethylene","Packaging is high density polyethylene.",null,"FinancialInvoiceV01 Trade Services SEG","New","2010-11-30","2010-11-30"]
[2,"LDPE","LowDensityPolyethylene","Packaging is low density polyethylene.",null,"FinancialInvoiceV01 Trade Services SEG","New","2010-11-30","2010-11-30"]
[3,"LLDP","LinearLowDensityPolyethylene","Packaging is linear low density polyethylene.",null,"FinancialInvoiceV01 Trade Services SEG","New","2010-11-30","2010-11-30"]
[4,"OTHR","OtherPackagingType","Other packaging type not otherwise specified.",null,"FinancialInvoiceV01 Trade Services SEG","New","2010-11-30","2010-11-30"]

{"sheet":"24-FinancialInstrumentIdType","index":28,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,5,2,8]],"flags":["formulas_cached_only"]}
[]
["ExternalFinancialInstrumentIdentificationType1Code"]
["Identification",null,null,null,"Information/Details","Status"]
[null,"\nCode","\nName","\nDefinition","ISO 15022","Origin/Requester","Status","Status  Date","Introduced Date"]
[1,"BELC","Code SRW (Secretariaat voor Roerende Waarden) or SVM (Secrétariat des Valeurs mobilières)","National securities identification number for BE issued by the National Numbering Association SIX Telekurs Belgium.","/BE/","ISITC/JASDEC/SWIFT CR0036","New","2010-11-30","2010-11-30"]
[2,"BLOM","Bloomberg","Ticker-like code assigned by Bloomberg to identify financial instruments.","/BLOM/","ISITC/JASDEC/SWIFT CR0036","New","2010-11-30","2010-11-30"]
[3,"CCCD","Other National Securities Identification Number","National Securities Identification Number issued by the National Numbering Association for a country for which no specific financial instrument identification type code already yet. The first two letters of the code represents the coutry code (for example, EGDC for Egyptian NSIN). To be used only until the code is added to the ISO ExternalFinancialInstrumentIdentificationType1Code list.","/cc/","ISITC/JASDEC/SWIFT CR0036","New","2010-11-30","2010-11-30"]
[4,"CMED","Chicago Mercantil Exchange (CME)","Ticker-like code assigned by the Chicago Mercantile Exchange to identify listed-derivatives instruments.","/CMED/","ISITC/JASDEC/SWIFT CR0036","New","2010-11-30","2010-11-30"]
[5,"COMM","Common Code","National securities identification number for ICSDs issued by the National Numbering Association Clearstreaam and Euroclear.","/XS/","ISITC/JASDEC/SWIFT CR0036","New","2010-11-30","2010-11-30"]
[6,"CTAC","Consolidated Tape Association (CTA)","Ticker-like code assigned by the Consolidated Tape Association to identify financial instruments.","/CTAC/","ISITC/JASDEC/SWIFT CR0036","New","2010-11-30","2010-11-30"]
[7,"CUSP","Committee on Uniform Security Identification Procedures (CUSIP)","National securities identification number for US and CA issued by the National Numbering Association Standard & Poor´s - CUSIP Global Services.","/US/","ISITC/JASDEC/SWIFT CR0036","New","2010-11-30","2010-11-30"]
[8,"ISDU","ISDA/FpML Product URL (URL in SecurityID)\n","URL in Description to identify OTC derivatives instruments.","/ISDU/","ISITC/JASDEC/SWIFT CR0036","New","2010-11-30","2010-11-30"]
[9,"ISDX","ISDA/FpML Product Specification (XML in EncodedSecurityDesc)","XML in Description to identify OTC derivatives instruments.","/ISDX/","ISITC/JASDEC/SWIFT CR0036","New","2010-11-30","2010-11-30"]
[10,"LCHD","LCH-Clearnet","Ticker-like code assigned by LCH to identify listed-derivatives instruments.","/LCHD/","ISITC/JASDEC/SWIFT CR0036","New","2010-11-30","2010-11-30"]
[11,"OCCS","Options Clearing Corp (OCC)","Ticker-like code assigned by the Options Clearing Corporation to identify financial instruments.","/OCCS/","ISITC/JASDEC/SWIFT CR0036","New","2010-11-30","2010-11-30"]
[12,"OPRA","Options Price Reporting Authority (OPRA)","Ticker-like code assigned by the Options Price Reporting Authority to identify financial instruments.","/OPRA/","ISITC/JASDEC/SWIFT CR0036","New","2010-11-30","2010-11-30"]
[13,"RCMD","Markit Red Code","Ticker-like code assigned by Markit to identify listed-derivatives instruments.","/RCMD/","ISITC/JASDEC/SWIFT CR0036","New","2010-11-30","2010-11-30"]
[14,"RICC","Reuters Instrument Code (RIC)","Ticker-like code assigned by Thomson Reuters to identify financial instruments.","/RICC/","ISITC/JASDEC/SWIFT CR0036","New","2010-11-30","2010-11-30"]
[15,"SEDL","Stock Exchange Daily Official List (SEDOL)","National securities identification number for GB issued by the National Numbering Association London Stock Exchange.","/GB/","ISITC/JASDEC/SWIFT CR0036","New","2010-11-30","2010-11-30"]
[16,"SICC","Securities Identification Code Committee","National securities identification number for JP issued by the National Numbering Association 6 Stock Exchanges and JASDEC (Securities Identification Ticker-like code Committee)","/JP/","ISITC/JASDEC/SWIFT CR0036","New","2010-11-30","2010-11-30"]
[17,"TIKR","Ticker Symbol (TS)","Ticker Code assigned by an exchange to identify financial instruments.","/TS/","ISITC/JASDEC/SWIFT CR0036","New","2010-11-30","2010-11-30"]
[18,"VALO","VALOR","National securities identification number for CH and LI issued by the National Numbering Association SIX Telekurs Ltd.","/CH/","ISITC/JASDEC/SWIFT CR0036","New","2010-11-30","2010-11-30"]
[19,"WKNR","Wertpapierkennummer (WKN)","National securities identification number for DE issued by the National Numbering Association WM Datenservice.","/DE/","ISITC/JASDEC/SWIFT CR0036","New","2010-11-30","2010-11-30"]

{"sheet":"25-TradeTransactionCondition","index":29,"n_rows":51,"n_cols":9,"rows_kept":51,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,5,2,8]],"flags":["formulas_cached_only"]}
[]
["ExternalTradeTransactionCondition1Code"]
["Identification",null,null,null,"Information/Details","Status"]
[null,"\nCode","\nName","\nDefinition",null,"Origin/Requester","Status","Status Date","Introduced Date"]
[1,"BCBL","BoardLot","Board lots, not set for odd lots (UK specific).",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[2,"BCBN","BadName","Bad names, not set for good names (UK specific).",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[3,"BCFD","DeliveryForm","Form of delivery, not for foreign registration when unset (UK specific).",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[4,"BCPD","DeliverCountryIncorporation","Place of delivery, in country of incorporation when unset (UK specific).",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[5,"BCRO","ResultOption","Result of option when set (UK specific).",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[6,"BCRP","ResultRepo","Result of repo when set (UK specific).",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[7,"BLKO","Block","The trade is a block trade or not, ie, whether allocation instruction will follow or not.",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[8,"BTEX","BestExecution","Trade to be executed done at best execution.",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[9,"BTMI","BoughtMinus","Bought minus indicator.",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[10,"CALL","Call","Trade to be executed following the exercise of a call option on the security.",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[11,"CBNS","CumBonus","The trade is executed cum bonus.",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[12,"CCPN","CumCoupon","The trade is executed cum coupon.",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[13,"CDIV","CumDividend","The trade is executed cum dividend.",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[14,"CLBR","ClosureBeforeRollOver","Trade to be executed for closure of a previous position before the rollover of a position (Deferred Settlement Service). ",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[15,"CLEN","Clean","The trade is executed clean, ie government tax must not be paid on the accrued interest on the bond.",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[16,"CRST","CrossTrade","Cross trades are allowed whereby buy and sell orders are offset without recording the trade on the exchange",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[17,"CRTS","CumRights","The trade is executed cum rights.",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[18,"CWAR","CumWarrant","The trade is executed cum warrant.",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[19,"DIOR","DirectedOrder","A customer order where the customer gives specific instructions to the broker concerning the orders routing destination.",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[20,"DIRT","Dirty","The trade is executed dirty, ie government tax must be paid on the accrued interest on the bond.",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[21,"DORD","DirectOrder","The order is to be executed by a trading party other than the trading party to which the order is sent. In this case, the instructing party has traded with another broker which will subsequently send an advice of execution to the executing party who received the order and which is acting as clearing broker.",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[22,"FORW","ForwardPriceTrade","The order is based on a forward price.",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[23,"FRAC","Fractions","Fractional parts are allowed.",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[24,"GTDL","GuaranteedDelivery","The delivery of the financial instrument on settlement date is guaranteed.",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[25,"HIST","HistoricPriceTrade","The order is based on a historic price.",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[26,"MAPR","MarketPrice","Trade was executed at market price.",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[27,"MONT","Monthly","Trade to be executed for month-end settlement (Deferred Settlement Service). ",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[28,"NBFR","NewTradeFollowingRollover","Trade to be executed for a new trade position on the next month following the roll-over of a position (Deferred Settlement Service). ",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[29,"NCRS","NoCrossTrade","Cross trades, whereby buy and sell orders are offset without recording the trade on the exchange, are not allowed.",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[30,"NEGO","NegotiatedTrade","Trade for which the price is not the one quoted but an improved one, that is, the negotiated price.",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[31,"NMPR","NonMarketPrice","Trade was executed outside of normal market conditions, for example, in the case of an iceberg order.",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[32,"PETA","PreTradeAnonimity","Allows trader to explicitly request anonymity or disclosure in pre-trade market data feeds. Anonymity is relevant in markets where counterparties are regularly disclosed in order depth feeds. Disclosure is relevant when counterparties are not normally visible.",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[33,"PUTT","Putt","Trade to be executed following the exercise of a put option on the security. ",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[34,"SETI","SoldExempt","Trade is exempt from short-sale rules.",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[35,"SPCU","SpecialCumDividend","The trade is executed  with a special cum dividend, ie, buying after the ex date and getting the dividend.",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[36,"SPEX","SpecialExDividend","The trade is executed  with a special ex dividend, ie, selling before the ex date without the coupon. ",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[37,"SPSI","SoldPlus","Sold plus indication.",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[38,"SSTI","SoldShort","The trade is sold short. When the seller does not have the financial instrument, the delivery is effected by borrowing the financial instrument by or for the account of the seller.",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[39,"TEFR","TradeExecutedFollowingRollover","Trade executed this month following the rollover of positions. ",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[40,"TRFR","TradeFollowingRollover","Trade to be executed on the next month following the roll-over of positions. ",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[41,"WIBC","BeforeAuction","Transaction is before the issue date after announcement of the auction.",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[42,"WICD","AfterAuction","Transaction is after the issue date after announcement of the auction.",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[43,"XBNS","ExBonus","The trade is executed ex bonus.",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[44,"XCPN","ExCoupon","The trade is executed ex coupon.",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[45,"XDIV","ExDividend","The trade is executed ex dividend.",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[46,"XRTS","ExRights","The trade is executed ex rights.",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]
[47,"XWAR","ExWarrant","The trade is executed ex warrant.",null,"Post-trade matching Omgeo/SWIFT","New","2011-08-31","2011-08-31"]

{"sheet":"26-ChargeType","index":30,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,5,2,8]],"flags":["formulas_cached_only"]}
[]
["ExternalChargeType1Code"]
["Identification",null,null,null,"Information/Details","Status"]
[null,"\nCode","\nName","\nDefinition",null,"Origin/Requester","Status","Status Date","Introduced Date"]
[1,"BRKF","BrokerageFee","Fee paid to a broker for services provided.",null,"Maintenance SR2012","New","2012-05-31","2012-05-31"]
[2,"COMM","Commission","Fee paid for services provided.",null,"Maintenance SR2012","New","2012-05-31","2012-05-31"]
[3,"SUMM","Summation","Summation of individual fees.",null,"Maintenance SR2012","New","2012-05-31","2012-05-31"]
[4,"BTCH","Batch","Fee paid for processing a batch of transactions.",null,"Maintenance SR2012","New","2012-05-31","2012-05-31"]

{"sheet":"27-CashAccountType","index":31,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,5,2,8]],"flags":["formulas_cached_only"]}
[]
["ExternalCashAccountType1Code"]
["Identification",null,null,null,"Information/Details","Status"]
[null,"\nCode","\nName","\nDefinition",null,"Origin/Requester","Status","Status Date","Introduced Date"]
[1,"CISH","CashIncome","Account used for payment of income if different from the current cash account",null,"Maintenance SR2012","New","2012-05-31","2012-05-31"]
[2,"CACC","Current","Account used to post debits and credits when no specific account has been nominated.",null,"Maintenance SR2012","New","2012-05-31","2012-05-31"]
[3,"CASH","CashPayment","Account used for the payment of cash.",null,"Maintenance SR2012","New","2012-05-31","2012-05-31"]
[4,"CHAR","Charges","Account used for charges if different from the account for\npayment.",null,"Maintenance SR2012","New","2012-05-31","2012-05-31"]
[5,"COMM","Commission","Account used for commission if different from the account\nfor payment.",null,"Maintenance SR2012","New","2012-05-31","2012-05-31"]
[6,"LOAN","Loan","Account used for loans.",null,"Maintenance SR2012","New","2012-05-31","2012-05-31"]
[7,"MGLD","Marginal Lending","Account used for a marginal lending facility.",null,"Maintenance SR2012","New","2012-05-31","2012-05-31"]
[8,"MOMA","Money Market","Account used for money markets if different from the cash\naccount.",null,"Maintenance SR2012","New","2012-05-31","2012-05-31"]
[9,"NREX","NonResidentExternal","Account used for non-resident external.",null,"Maintenance SR2012","New","2012-05-31","2012-05-31"]
[10,"ODFT","Overdraft","Account is used for overdrafts.",null,"Maintenance SR2012","New","2012-05-31","2012-05-31"]
[11,"ONDP","OverNightDeposit","Account used for overnight deposits.",null,"Maintenance SR2012","New","2012-05-31","2012-05-31"]
[12,"SACC","Settlement","Account used to post debit and credit entries, as a result of\ntransactions cleared and settled through a specific clearing\nand settlement system.",null,"Maintenance SR2012","New","2012-05-31","2012-05-31"]
[13,"SLRY","Salary","Accounts used for salary payments.",null,"Maintenance SR2012","New","2012-05-31","2012-05-31"]
[14,"SVGS","Savings","Account used for savings.",null,"Maintenance SR2012","New","2012-05-31","2012-05-31"]
[15,"TAXE","Tax","Account used for taxes if different from the account for\npayment.",null,"Maintenance SR2012","New","2012-05-31","2012-05-31"]
[16,"TRAS","Cash Trading","Account used for trading if different from the current cash\naccount.",null,"Maintenance SR2012","New","2012-05-31","2012-05-31"]
[17,"LLSV","LimitedLiquiditySavingsAccount","Account used for savings with special interest and withdrawal terms.  ",null,"Maintenance SR2012","New","2012-05-31","2012-05-31"]
[18,"OTHR","OtherAccount","Account not otherwise specified. ",null,"Maintenance SR2012","New","2012-05-31","2012-05-31"]

{"sheet":"28-DiscountAmountType","index":32,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,5,2,8]],"flags":["formulas_cached_only"]}
[]
["ExternalDiscountAmountType1Code"]
["Identification",null,null,null,"Information/Details","Status"]
[null,"\nCode","\nName","\nDefinition",null,"Origin/Requester","Status","Status Date","Introduced Date"]
[1,"APDS","AdditionalPromotionalDiscount","Addition discount based on third-party agreed business promotional activity, i.e., extra 10 percent discount for 15 days)",null,"Maintenance 2011/2012","New","16 July 2012","16 July 2012"]
[2,"STDS","StandingDiscount","Discount based on volume purchased.",null,"Maintenance 2011/2012","New","16 July 2012","16 July 2012"]
[3,"TMDS","TermsDiscount","Discount based on terms negotiated for payment within a specified time period, i.e., 2/10 Net 30 (2 percent discount if paid in 10 days; otherwise, net amount is due in 30 days).",null,"Maintenance 2011/2012","New","16 July 2012","16 July 2012"]

{"sheet":"29-TaxAmountType","index":33,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,5,2,8]],"flags":["formulas_cached_only"]}
[]
["ExternalTaxAmountType1Code"]
["Identification",null,null,null,"Information/Details","Status"]
[null,"\nCode","\nName","\nDefinition",null,"Origin/Requester","Status","Status Date","Introduced Date"]
[1,"CITY","CityTax","Tax accessed by city jurisdications within a country.",null,"Maintenance 2011/2012","New","16 July 2012","16 July 2012"]
[2,"CNTY","CountyTax","Tax accessed by county jurisdications within a country.",null,"Maintenance 2011/2012","New","16 July 2012","16 July 2012"]
[3,"LOCL","LocalTax","Tax accessed by local jurisdications within a country.",null,"Maintenance 2011/2012","New","16 July 2012","16 July 2012"]
[4,"PROV","ProvinceTax","Tax accessed by province jurisdications within a country.",null,"Maintenance 2011/2012","New","16 July 2012","16 July 2012"]
[5,"STAT","StateTax","Tax accessed by state jurisdications within a country.",null,"Maintenance 2011/2012","New","16 July 2012","16 July 2012"]

{"sheet":"30-CardTransactionCategory","index":34,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,4,2,7]],"flags":["formulas_cached_only"]}
[]
["ExternalCardTransactionCategory1Code"]
["Identification",null,null,null,"Status"]
[null,"\nCode","\nName","\nDefinition","\nOrigin/Requester","Status","Status Date","Introduced Date"]
[1,"Currently no codes have been defined."]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]

{"sheet":"31-BillingBalanceType","index":35,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,4,2,7]],"flags":["formulas_cached_only"]}
[]
["ExternalBillingBalanceType1Code"]
["Identification",null,null,null,"Status"]
[null,"\nCode","\nName","\nDefinition","\nOrigin/Requester","Status","Status Date","Introduced Date"]
[1,"ABRR","AdditionalBal-ReserveRequirement","The difference between the excess/(deficit) investable balance and the excess/(deficit) collected balance due to the reserve requirement. This balance is not used if the account’s Earnings Credit Rate is net of reserves. This may be used when the earnings allowance rate is not adjusted for reserves. It may be that reserves have been subtracted from the collected balance to determine the investable balance. Therefore, they must be added back to the excess/(deficit) investable balance to determine the collected balance position. The presentation of this calculation is optional. AFP code=00 04 21","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[2,"BEQU","BalEquivalent ","Balance required to offset the current analysis period’s balance compensable service charges. The balance equivalent can be calculated in two different ways. The first simply multiplies the balance compensable service charge total by the multiplier.  The second calculation incorporates all of the elements of the multiplier calculation. Note that this calculation may result in a slightly different value due to the decimal precision and rounding used in the calculation: AFP code=00 04 00","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[3,"CBAM","CollectedBal-AvgNegative","The sum of only the daily ending NEGATIVE collected balances divided by the number of days in the statement period. The average negative balance, if present, is always positively signed. Balances are net of current period adjustments. Note that a NEGATIVE balance is equal to the POSITIVE balance less the NET balance. Note that a NEGATIVE Collected Balance Interest Rate can be applied to this balance to develop an OD interest charge. AFP code=00 00 13","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[4,"CBAN","CollectedBal-AvgNet","The sum of the daily ending collected balances (both positive and negative) divided by the number of days in the statement period.  A negative-signed value indicates a negative average NET balance.  If a reserve-adjusted earnings allowance/credit rate is used, this balance may be the same as the investable balance (00 00 40).  Balances are net of current period adjustments. Collected balances represent deposit money that has been collected and excludes any money in float. Note that a NET balance is equal to the POSITIVE balance less the NEGATIVE balance. Note that a NET Collected Balance OD Interest Rate (00 01 43) can be applied to this balance, if negative, to develop an OD interest charge.  AFP code=00 00 10","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[5,"CBAP","CollectedBal-AvgPositive","The sum of only the daily ending POSITIVE collected balances divided by the number of days in the statement period.  Balances are net of current period adjustments. Collected balances represent deposit money that has been collected and excludes any money in float. Note that a POSITIVE balance is equal to the NET balance plus the NEGATIVE balance. AFP code=00 00 11","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[6,"DABR","DemandDepositAccount Balance-ReserveRequirement","That portion of the demand deposit account balance that must be set aside by the bank to meet reserve requirements. AFP code=00 04 20","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[7,"EDCB","ExcessDeficitCollectedBal","Collected balance remaining after the balance required to offset the current analysis period’s balance compensable service charges has been deducted.  If negative (deficit), this represents the additional collected balance required to fully offset balance compensable service charges for the current period.  If positive (excess), this represents the collected balance surplus after offsetting balance compensable service charges for the current period. AFP code=00 04 12","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[8,"EDIB","ExcessDeficitInvestableBal","Investable balance remaining after the balance required to offset the current analysis period’s balance compensable service charges has been deducted.  If negative (deficit), this represents the additional investable balance required to fully offset balance compensable service charges for the current period.  If positive (excess), this represents the investable balance surplus after offsetting balance compensable service charges for the current period. Depending on the type of underlying account, a hard interest rate may be applied to a balance excess resulting in a hard interest credit to the underlying account. AFP code=00 04 10","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[9,"FDIC","FDICAssesmentBal","That account balance used to calculate the FDIC assessment charge. AFP code=00 00 50","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[10,"FLBA","FloatBal-Avg","The sum of the daily dollar amount of items in the process of collection divided by the number of days in the statement period.  AFP code=00 00 30","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[11,"FLPP","BalAdj-PriorPeriod-AvgFloat","Sum of the adjustments to the average float in a prior period(s).  A negative-signed value indicates a balance reduction. This balance can also be used to adjust the average collected balances since money in float has a direct effect on collected balances. AFP code=00 00 61","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[12,"IBAL","InvestableBal","Balance on which the earnings allowance/credit rate is applied.  This value can be signed either positive or negative.  A negative-signed balance indicates a shortage of investable funds.and may result in a charge. AFP code=00 00 40","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[13,"IBIB","InterestBearingInvestableBalance","The average investable balance that can be used to show the base balance for the calculation of a hard interest credited. This is a hard interest credit as opposed to an earnings credit. AFP code=00 00 75","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[14,"IBLB","InterestBearingLedgerBalance","The average ledger balance that can be used to show the base balance for the calculation of a hard interest credited. This is a hard interest credit as opposed to an earnings credit. AFP code=00 00 70","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[15,"IBNC","InterestBearingNetCollectedBalance","The average net collected balance that can be used to show the base balance for the calculation of a hard interest credited. This is a hard interest credit as opposed to an earnings credit. AFP code=00 00 71","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[16,"IBNG","InterestBearingNegativeCollectedBalance","The average negatve collected balance that can be used to show the base balance for the calculation of a hard interest debit. This is a hard interest debit as opposed to an earnings credit debit. AFP code=00 00 73","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[17,"IBPC","InterestBearingPositiveCollectedBalance","The average positive collected balance that can be used to show the base balance for the calculation of a hard interest credited. This is a hard interest credit as opposed to an earnings credit. AFP code=00 00 72","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[18,"IBRR","InterestBearingReserveRequirementBalance","The average reserve requirement balance that can be used to show the base balance for the calculation of a hard interest credited. This is a hard interest credit as opposed to an earnings credit. AFP code=00 00 74","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[19,"LBAN","LedgerBal-AvgNet","The sum of the daily ending ledger balances (both positive and negative) divided by the number of days in the statement period.  A negative-signed value indicates a negative average NET balance. Balances are net of current period adjustments. The ledger balance includes any deposit money that has not been collected, ie, money in float.Note that a NET balance is equal to the POSITIVE balance less the NEGATIVE balance.Note that a NET Ledger Balance OD Interest Rate can be applied to this balance, if negative, to develop an OD interest charge.  AFP code=00 00 00","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[20,"LBAP","LedgerBal-AvgPositive","The sum of only the daily ending POSITIVE ledger balances divided by the number of days in the statement period.  Balances are net of current period adjustments. The ledger balance includes any deposit money that has not been collected, ie, money in float. Note that a POSITIVE balance is equal to the NET balance plus the NEGATIVE balance. AFP code=00 00 01","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[21,"LBME","LedgerBal-MonthEnd","Value of the book or ledger balance at the end of the calendar month. AFP code=00 00 05","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[22,"LBNM","LedgerBal-AvgNegative","The sum of only the daily ending NEGATIVE ledger balances divided by the number of days in the statement period. The average negative balance, if present, is always positively signed. Balances are net of current period adjustments. Note that a NEGATIVE balance is equal to the POSITIVE balance less the NET balance. Note that a NEGATIVE Ledger Balance Interest Rate can be applied to this balance to develop an OD interest charge. AFP code=00 00 03","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[23,"UCFU","UncollectedFundsUsed","That portion of the balance that is the difference between the average negative collected balance and the average negative ledger balance.  This is used to isolate that portion of the negative collected balance that represents the use of uncollected funds.  Balances are net of current period adjustments. Note that the Uncollected Funds Usage Rate can be applied to this balance to develop an Uncollected Funds OD interest charge.  AFP code=00 00 15","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]

{"sheet":"32-BillingCompensationType","index":36,"n_rows":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,4,2,7]],"flags":["formulas_cached_only"]}
[]
["ExternalBillingCompensationType1Code"]
["Identification",null,null,null,"Status"]
[null,"\nCode","\nName","\nDefinition","\nOrigin/Requester","Status","Status Date","Introduced Date"]
[1,"BACS","BalanceCompensableServices","Total amount of service charges that can be offset by an earnings allowance credit. Such services carry a Payment Method code of ”Balance Compensable”.  This amount is included in SettleChargeTtl-Current Period (AFP code 00 03 00). This value must be sent if the bank is providing an earnings credit based on deposit balances. AFP code=00 03 31","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[2,"CTND","ChargesAndTaxes-NetDueThisStmt","Amount due to the bank for the settlement period, after all adjustments and deductions. Includes both service and tax charges. If nothing is due this value must be sent as zero. AFP code=00 03 14","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[3,"DEAD","DeficitEarningsAllowanceDueThisStmt","Amount due to the bank for balance compensable service charges which exceed the earnings allowance for the settlement period. This amount should be equal to the absolute value of the ExcessDeficitEarningsAllowance-Adjusted (AFP code 00 02 44). This value must be sent if the bank is providing an earnings credit based on deposit balances. AFP code=00 02 47","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[4,"EALL","EarningsAllowance","Value of balances maintained during the statement period which can be used to offset balance compensable service charges. This value must be sent if the bank is providing an earnings credit based on deposit balances. AFP code=00 02 40","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[5,"EANA","EarningsAllowance-NetAdjustment","Net value of balance and/or rate adjustments for prior periods to be applied to the current excess/(deficit) allowance. AFP code=00 02 43","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[6,"EDAA","ExcessDeficitEarningsAllowance-Adjusted","Excess/(deficit) earnings allowance for the analysis period plus or minus any net earnings allowance and/or balance compensable service charge adjustments. Note that in the absence of any EarningsAllowance-NetAdjust (AFP code 00 02 43) this balance is preferred instead of the ExcessDeficitEarningsAllowance (AFP code 00 02 41). This value must be sent if the bank is providing an earnings credit based on deposit balances. AFP code=00 02 44","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[7,"EDAL","ExcessDeficitEarningsAllowance","The difference between the earnings allowance and the balance compensable service charges.  Excess allowance occurs when the earnings allowance exceeds the total balance compensable service charges.  A Deficit allowance occurs when the total balance compensable service charges exceed the earnings allowance. Excess allowances may be carried forward into future statement periods at the bank’s discretion. Deficit allowances are typically reflected as charges due to the bank in the form of DeficitEarningsAllowanceDueThisStmt (AFP code 00 02 47). This value must be sent if the bank is providing an earnings credit based on deposit balances. AFP code=00 02 41","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[8,"FESS","FeesPaid","Charges from a prior billing period which have been paid. AFP code=00 03 22","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[9,"FREE","FreeServices","Total amount of service charges as listed in the Service Sections that are provided free of charge. Such services carry a Payment Method code of \"FREE\" (Free). This amount is included in SettleChargetTL-Current Period (AFP code 00 03 00). Should be sent if there are any “Free” service charges in the Service Sections. It is assumed that “waived” and “free” services are not taxed. AFP code=00 03 36","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[10,"NBCS","Non-BalCompensableServices","Total amount of service charges due as of this statement that are not eligible to be offset by an earnings allowance credit. Such services carry a Payment Method code of “FLAT\" (HardCharge).  This amount is included in SettleChargeTtl-CurrentPeriod (AFP code 00 03 00 ). AFP code=00 03 00","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[11,"PVCS","PreviouslyChargedServices","Total amount of service charges as listed in the Service Sections but assessed previously and which, therefore, are not due.  Such services carry a Payment Method code of \"PVCH\" (PreviouslyCharged). This amount is included in SettleChargetTL-CurrentPeriod (AFP code 00 03 00). Should be sent if there are any \"Previously Charged\"  services in the Service Sections. AFP code=00 03 35","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[12,"SCAB","ServCharges-NetAdjust-BalCompensable","Net value of adjustments to balance compensable service charges for a prior period(s) to be applied to the current excess/(deficit) allowance. AFP cod=00 03 32","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[13,"SCAN","ServCharges-NetAdjust-Non-BalCompensable","Total of all service charge adjustments that are not eligible to be offset by an earnings allowance credit.  This can be a positive-signed or negative-signed number. AFP code=00 03 33","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[14,"SCBT","ServiceChargesDueBeforeTax","The total amount of service charges due exclusive of taxes due. AFP code=00 03 11","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[15,"SCCP","SettleChargeTtl- CurrentPeriod","Total charges before credit for services provided during the current statement period. This total is the arithmetic sum of all charges listed in the Settlement Amount element of the Service Sections in the statement regardless of the Payment Method code . It includes all Balance Compensable charges, Hard charges, Previously Charged charges, Waived charges and Free charges. It does not include any tax charges related to the services. AFP code=00 03 00","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[16,"SCDB","ServiceCharges–Debited","Amount of ChargesAndTaxes-NetDueThisStmt (AFP code 00 03 14 ) that are directly debited from the customer’s account. AFP code=00 03 50","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[17,"SCDI","ServiceCharges–Discount","The total amount of any service charge discount. AFP code=00 03 41","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[18,"SCIN","ServiceCharges–Invoiced","Amount of ChargesAndTaxes-NetDueThisStmt (AFP code 00 03 14 ) that are invoiced. AFP code=00 03 A0","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[19,"TICD","TtlInterestCredited","Total amount of hard interest credited to a designated account. The amount of hard interest credited, if any, is calculated by applying the Interest Credited rate against a negative balance as reported in the Balance Section with a Balance Identifier of  ExcessDeficitCollectedBal (AFP code 00 04 12). AFP code=00 00 76","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[20,"TXSC","TaxableServiceCharges","The total amount of service charges that were subject to taxes. AFP code=00 03 13","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[21,"TXTS","TaxTotalSum","The Sum of all the individual tax values as contained in either the individual Service Sections or Tax Sections. AFP code=00 03 60","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[22,"WAIV","WaivedServices","Amount of service charges otherwise due that are waived on this statement. Such services carry a Payment Method code of “WVED\" (Waived). Note that this amount does not include line item free services (AFP code 00 03 36). This amount is included in SettleChargetTL-Current Period (AFP code 00 03 00). Any such line item waivers or free services are not brought forward into the Compensation calculations. It is assumed that “waived” and “free” services are not taxed. afp CODE=00 03 40","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]

{"sheet":"33-BillingRateIdentification","index":37,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,4,2,7]],"flags":["formulas_cached_only"]}
[]
["ExternalBillingRateIdentification1Code"]
["Identification",null,null,null,"Status"]
[null,"\nCode","\nName","\nDefinition","\nOrigin/Requester","Status","Status Date","Introduced Date"]
[1,"AEAR","AdjustedEarningsAllowanceRate","Per annum earnings rate, adjusted for reserves, applied to the current analysis period’s investable balance for calculation of the earnings allowance credit.  The ECR, Net of Reserves, is calculated as:    ECR, Net of Reserves  =  ECR, Not Net (00 01 22) * (1 – Reserve Rate)","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[2,"ANXE","AdjustedNextMonthEarningsRate","The anticpated earnings allowance rate, as adjusted, to be used next month in the calculation of the earnings allowance. See AEAR AdjustedEarningsAllowance Rate","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[3,"CDRA","CDRate","The current CD (Certificate of Deposit) rate as published by the bank.","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[4,"DINR","DeficiencyInterestRate","The per annum rate used to calculate the Deficiency Interest amount to be paid to the bank. ","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[5,"DSCR","DeficiencySurchargeRate","The per annum rate used to calculate a surcharge based on the Deficiency Interest amount to be paid to the bank. ","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[6,"EALR","EarningsAllowanceRate","Per annum earnings rate applied to the current statement period’s investable balance for calculation of the earnings allowance credit. The earnings allowance credit is used to offset the charges for balance compensable services. This rate has NOT been adjusted for reserves. The ECR, Not Net of Reserves, is calculated as:    ECR, Not Net  =  ECR, Net of Reserves (00 01 20)  /  (1 – Reserve Rate)","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[7,"FDIC","FDICRate","The current FDIC rate used in the US to calculate the Federal Deposit Insurance premium paid by the banks to the FDIC.","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[8,"ICDR","InterestCreditedRate","Per annum interest rate used to calculate the interest amount credited to a designated account. The amount of interest credited, if any, is reported in a Compensation Section with a Compensation Identifier of TtlInterestCredited","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[9,"MULT","Multiplier","The collected balance required to offset $1.00 of balance compensable service charges.  This factor can be used to calculate the balance equivalent of balance compensable service charges.  The multiplier is calculated in one of three different ways depending on whether the Earnings Allowance Rate (ECR) is adjusted for reserves or not (net of reserves or not)  and, in the case where the ECR is not adjusted for reserves, whether the multiplier is adjusted for reserves or not.","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[10,"NCBO","NetCollectedBalanceOverdraftRate","Per annum interest rate used to calculate overdraft compensation on an average net collected balance which is negative (AFP balance 00 00 10).  An average NET balance is negative when the sum of the daily ending POSITIVE and NEGATIVE balances is negative.","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[11,"NGCO","NegativeCollectedOverdraftRate","Per annum interest rate applied to NEGATIVE collected balances (AFP balance 00 00 13) for calculation of overdraft compensation.","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[12,"NGLO","NegativeLedgerOverdraftRate","Per annum interest rate applied to NEGATIVE ledger balances (AFP balance 00 00 03) for calculation of overdraft compensation.","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[13,"NLBO","NetLedgerBalanceOverdraftRate","Per annum interest rate used to calculate overdraft compensation on an average net ledger balance which is negative (AFP balance 00 00 00).  An average NET balance is negative when the sum of the daily ending POSITIVE and NEGATIVE balances is negative.","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[14,"NXME","NextMonthEarningsAllowanceRate","The anticpated earnings allowance rate to be used next month in the calculation of the earnings allowance. See EALR EarningsAllowance Rate","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[15,"NXMU","NextMonthMultiplier","The anticipated Multiplier to be used next month. See MULT Multiplier.","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[16,"PRIR","PrimeRate","The current per annum Prime rate as published by the bank.","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[17,"RRQR","ReserveRequirementRate-NonDDA","The per annum reserve rate as applied to non demand deposit accounts such as time deposit or CD accounts.","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[18,"RSRV","ReserveRequirementRate","Per annum interest rate used to calculate that portion of the CollectedBal-AvgPositive that US banks must keep on deposit at the US Federal Reserve.","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]
[19,"UFUR","UncollectedFundsUsageRate","Per annum interest rate assessed on that portion of the account balance which is the difference between the average negative ledger and the average negative collected balance (AFP balance 00 00 15).  This rate is used to assess compensation on the portion of the negative collected balance that represents the use of uncollected funds.","BJ 56\nTWIST & SWIFT","New","13 July 2012","13 July 2012"]

{"sheet":"34-RePresentmentReason","index":38,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,5,2,8]],"flags":["formulas_cached_only"]}
[]
["ExternalRePresentmentReason1Code"]
[null,null,"Identification",null,"Information/Details","Status"]
[null,"\nCode","\nName","\nDefinition",null,"Origin/Requester","Status","Status Date","Introduced Date"]
[1,"AMCR","Amount Corrected","Amount corrected due to proof of transaction",null,"PaymentSD1V01/Berlin Group","New","30 January 2013","30 January 2013"]
[2,"CLSD","Card Authentication Liability Shift Denied","Liability Shift to acquirer due to missing card authentication method denied",null,"PaymentSD1V01/Berlin Group","New","30 January 2013","30 January 2013"]
[3,"CRPI","Credit Previously Issued","Credit previously issued",null,"PaymentSD1V01/Berlin Group","New","30 January 2013","30 January 2013"]
[4,"OTVA","Original Transaction Valid","Original transaction was valid",null,"PaymentSD1V01/Berlin Group","New","30 January 2013","30 January 2013"]
[5,"VLSD","Verification Liability Shift Denied","Liability Shift to acquirer due to missing cardholder verification method denied",null,"PaymentSD1V01/Berlin Group","New","30 January 2013","30 January 2013"]

{"sheet":"35-Channel","index":39,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,4,2,7]],"flags":["formulas_cached_only"]}
[]
["ExternalChannel1Code"]
["Identification",null,null,null,"Status"]
[null,"\nCode","\nName","\nDefinition","\nOrigin/Requester","Status","Status Date","Introduced Date"]
[1,"COUR","Courier","Delivery by courier.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[2,"EMAL","Email","Transmission by e-mail.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[3,"FAXI","Fax","Transmission by fax.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[4,"MESS","Messenger","Delivery by messenger.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[5,"POST","Post","Delivery by postal service.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[6,"REGM","RegisteredMail","Delivery by registered mail services.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[7,"SEMA","SecureEmail","Transfer via secure e-mail.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[8,"SWFA","SWIFTNetFileAct","Transmission by SWIFTNet FileAct.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[9,"SWIA","SWIFTNetInterAct","Transmission by SWIFTNet InterAct. ","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[10,"SWMT","SWIFTMT","Transmission by SWIFT (FIN).","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[11,"SWMX","SWIFTMX","Transmission by SWIFTNet.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[12,"TELE","Telecommunication","Transmission by telecommunications service.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[13,"WEBM","WebUploadDownload","Available via Web upload/download","BJ53/SWIFT","New","14 December 2012","14 December 2012"]

{"sheet":"36-DateFrequency","index":40,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,4,2,7]],"flags":["formulas_cached_only"]}
[]
["ExternalDateFrequency1Code"]
["Identification",null,null,null,"Status"]
[null,"\nCode","\nName","\nDefinition","\nOrigin/Requester","Status","Status Date","Introduced Date"]
[1,"MNTH","Monthly","Frequency is monthly.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[2,"QUTR","Quarterly","Frequency is quarterly (every three months).","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[3,"SEMI","SemiAnnual","Frequency is semi-annual (every six months).","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[4,"TOMN","TwoMonthly","Frequency is two-monthly (every two months).","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[5,"YEAR","Annual","Frequency is annual.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]

{"sheet":"37-DocumentFormat","index":41,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,4,2,7]],"flags":["formulas_cached_only"]}
[]
["ExternalDocumentFormat1Code"]
["Identification",null,null,null,"Status"]
[null,"\nCode","\nName","\nDefinition","\nOrigin/Requester","Status","Status Date","Introduced Date"]
[1,"DPDF","PDF","Document format is PDF.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[2,"DXML","XML","Document format is XML.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[3,"SDSH","Spreadsheet","Document format is a spreadsheet.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[4,"WORD","Word","Document format is Word.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[5,"XSLT","XSLT","Document format is XSLT.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]

{"sheet":"38-ModelFormIdentification","index":42,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,4,2,7]],"flags":["formulas_cached_only"]}
[]
["ExternalModelFormIdentification1Code"]
["Identification",null,null,null,"Status"]
[null,"\nCode","\nName","\nDefinition","\nOrigin/Requester","Status","Status Date","Introduced Date"]
[1,"ISP1","ISP98ModelForm1","ISP98 model form for standby incorporating annexed form of payment demand with statement.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[2,"ISP2","ISP98ModelForm2","ISP98 model form or standby providing for extension and incorporating annexed form of payment demand with alternative non-extension statement.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[3,"ISP3","ISP98ModelForm3","ISP98 model form or standby providing for reduction and incorporating annexed form of reduction demand. ","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[4,"ISP4","ISP98ModelForm4","ISP98 model form for standby providing for transfer and incorporating annexed form of transfer demand.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[5,"ISP5","ISP98ModelForm5","ISP98 model form for simplified demand only standby.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[6,"ISP6","ISP98ModelForm6","ISP98 model form for counter standby with annexed form of local bank undertaking.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[7,"ISP7","ISP98ModelForm7","ISP98 model form for standby requiring confirmation.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[8,"ISP8","ISP98ModelForm8","ISP98 model form for confirmation of standby.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[9,"UDG1","URDGDemandGuarantee","Model form for demand guarantee defined in the latest version of the ICC Uniform Rules For Demand Guarantees (URDG).","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[10,"UDG2","URDGCounterGuarantee","Model form for counter-guarantee defined in the latest version of the ICC Uniform Rules For Demand Guarantees (URDG).","BJ53/SWIFT","New","14 December 2012","14 December 2012"]

{"sheet":"39-NarrativeType","index":43,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,4,2,7]],"flags":["formulas_cached_only"]}
[]
["ExternalNarrativeType1Code"]
["Identification",null,null,null,"Status"]
[null,"\nCode","\nName","\nDefinition","\nOrigin/Requester","Status","Status Date","Introduced Date"]
[1,"ADDI","AdditionalTermsAndConditions","Narrative text describing the additional terms and conditions.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[2,"CHAR","ChargeDetails","Narrative text describing the charge details.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[3,"DRAW","DrawingDetails","Narrative text describing the drawing details.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[4,"PRAS","ProceedsAssignable","Narrative text describing the assignment of proceeds terms and conditions.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[5,"TEFF","TermsOfEffectiveness","Narrative text describing the terms of effectiveness.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[6,"TRNF","Transfer","Narrative text describing the transfer terms and conditions.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[7,"TVAR","TermsOfVariation","Narrative text describing the terms of variation.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]

{"sheet":"40-RelativeTo","index":44,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,4,2,7]],"flags":["formulas_cached_only"]}
[]
["ExternalRelativeTo1Code"]
["Identification",null,null,null,"Status"]
[null,"\nCode","\nName","\nDefinition","\nOrigin/Requester","Status","Status Date","Introduced Date"]
[1,"GOOD","ValueOfGoods","Percentage rate expressed relative to the value of goods.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[2,"PAYM","PaymentAmount","Percentage rate expressed relative to the payment amount.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[3,"UNDG","UndertakingAmount","Percentage rate expressed relative to the undertaking amount.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]

{"sheet":"41-TypeOfParty","index":45,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,4,2,7]],"flags":["formulas_cached_only"]}
[]
["ExternalTypeOfParty1Code"]
["Identification",null,null,null,"Status"]
[null,"\nCode","\nName","\nDefinition","\nOrigin/Requester","Status","Status Date","Introduced Date"]
[1,"ADVP","AdvisingParty","Party advising the undertaking.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[2,"ANYB","AnyBank","Any bank.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[3,"APPL","Applicant","Party named in the undertaking as the “applicant”. ","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[4,"BENE ","Beneficiary","Party in whose favour the undertaking (or counter-undertaking) is issued.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[5,"CONF","ConfirmationParty","Party that adds its undertaking to honour the undertaking.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[6,"CUB2","SecondCounterUndertakingBeneficiary","Beneficiary of the second counter-undertaking.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[7,"CUB3","ThirdCounterUndertakingBeneficiary","Beneficiary of the third counter-undertaking.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[8,"ISSU","Issuer","Party that issues the undertaking (or counter-undertaking). ","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[9,"OBLG ","Obligor","Party obligated to reimburse the issuer. ","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[10,"ORDR","OrderingParty","Party requested to issue an undertaking on behalf of the applicant. Also known as the ordering institution or applicant's bank.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[11,"PRES","PresentingParty","Party nominated to receive presentation. ","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[12,"SADV","SecondAdvisingParty","Second advising party.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[13,"SPEC","SpecifiedAddress","Party located at specified address.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]

{"sheet":"42-UnderlyingTradeTransactionTp","index":46,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,4,2,7]],"flags":["formulas_cached_only"]}
[]
["ExternalUnderlyingTradeTransactionType1Code"]
["Identification",null,null,null,"Status"]
[null,"\nCode","\nName","\nDefinition","\nOrigin/Requester","Status","Status Date","Introduced Date"]
[1,"CONT","Contract","Underlying transaction is a contract.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[2,"DELV","DeliveryOrder","Underlying transaction is a delivery order.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[3,"PROF","ProformaInvoice","Underlying transaction is a proforma invoice.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[4,"PROJ","Project","Underlying transaction is a project.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[5,"PUOR","PurchaseOrder","Underlying transaction is a purchase order.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[6,"QUOT","Quotation","Underlying transaction is a quotation.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[7,"TEND","Tender","Underlying transaction is a tender.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]

{"sheet":"43-UndertakingAmountType","index":47,"n_rows":6,"n_cols":8,"rows_kept":6,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,4,2,7]],"flags":["formulas_cached_only"]}
[]
["ExternalUndertakingAmountType1Code"]
["Identification",null,null,null,"Status"]
[null,"\nCode","\nName","\nDefinition","\nOrigin/Requester","Status","Status Date","Introduced Date"]
[1,"INCR","Increase","Amount is an increase.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[2,"REDC","Reduction","Amount is a reduction.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]

{"sheet":"44-UndertakingChargeType","index":48,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,4,2,7]],"flags":["formulas_cached_only"]}
[]
["ExternalUndertakingChargeType1Code"]
["Identification",null,null,null,"Status"]
[null,"\nCode","\nName","\nDefinition","\nOrigin/Requester","Status","Status Date","Introduced Date"]
[1,"AMND","Amendment","Charge related to the issuance of an amendment.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[2,"CLAM","Claim","Charge related to the processing of a claim.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[3,"COMM","Commission","Commission charge.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[4,"CONF","Confirmation","Charge for confirmation.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[5,"COUR","Courier","Courier charge.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[6,"ISSU","IssuanceCharge","Charge related to the issuance of an undertaking.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[7,"MISC","Miscellaneous","Miscellaneous charge.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[8,"PAYM","Payment","Charge related to the payment processing.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[9,"POST","Postage","Postage charge.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[10,"TELE","Telecommunication","Telecommunication charge.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]

{"sheet":"45-UndertakingDocumentType1","index":49,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,4,2,7]],"flags":["formulas_cached_only"]}
[]
["ExternalUndertakingDocumentType1Code"]
["Identification",null,null,null,"Status"]
[null,"\nCode","\nName","\nDefinition","\nOrigin/Requester","Status","Status Date","Introduced Date"]
[1,"BENS","BeneficiaryStatement","Document is a beneficiary statement.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[2,"CINV","CommercialInvoice","Document is an invoice.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[3,"CLAF","ClaimForm","Document is a claim form.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[4,"DEMD","Demand","Document is an undertaking demand.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[5,"TRAF","TransferForm","Document is a transfer form.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]

{"sheet":"46-UndertakingDocumentType2","index":50,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,4,2,7]],"flags":["formulas_cached_only"]}
[]
["ExternalUndertakingDocumentType2Code"]
["Identification",null,null,null,"Status"]
[null,"\nCode","\nName","\nDefinition","\nOrigin/Requester","Status","Status Date","Introduced Date"]
[1,"BENS","BeneficiaryStatement","Document is a beneficiary statement.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[2,"CINV","CommercialInvoice","Document is an invoice.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[3,"TRAF","TransferForm","Document is a transfer form.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]

{"sheet":"47-UndertakingStatusCategory","index":51,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,4,2,7]],"flags":["formulas_cached_only"]}
[]
["ExternalUndertakingStatusCategory1Code"]
["Identification",null,null,null,"Status"]
[null,"\nCode","\nName","\nDefinition","\nOrigin/Requester","Status","Status Date","Introduced Date"]
[1,"AMND","Amendment","Status is related to an undertaking amendment.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[2,"AMTC","CounterUndertakingAmountStatus","Status is related to a counter-undertaking amount.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[3,"AMTU","UndertakingAmountStatus","Status is related to an undertaking amount.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[4,"APPL ","Application","Status is related to an undertaking application.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[5,"BAMD","BeneficiaryAmendment","Status is related to an undertaking amendment requested by the beneficiary.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[6,"CONF","Confirmation","Status is related to an undertaking confirmation.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[7,"DEMD","Demand","Status is related to an undertaking demand.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[8,"NEXT","NonExtension","Status is related to an undertaking non-extension request.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[9,"TERM","Termination","Status is related to an undertaking termination.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]

{"sheet":"48-UndertakingType","index":52,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,4,2,7]],"flags":["formulas_cached_only"]}
[]
["ExternalUndertakingType1Code"]
["Identification",null,null,null,"Status"]
[null,"\nCode","\nName","\nDefinition","\nOrigin/Requester","Status","Status Date","Introduced Date"]
[1,"APAY","AdvancePayment","Undertaking in support of an advance payment obligation.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[2,"COMM","Commercial","Undertaking in support of a commercial obligation.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[3,"CUST","Customs","Undertaking in support of a customs duty obligation.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[4,"DPAY","DirectPay","Undertaking representing the primary means of payment.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[5,"FINC","Financial","Undertaking in support of a financial obligation.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[6,"INSU","Insurance","Undertaking in support of a insurance obligation.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[7,"IRBO","IndustrialRevenueBoard","Undertaking in support of an Industrial Revenue Board (IRB) obligation.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[8,"MAIN","Maintenance","Undertaking in support of a maintenance obligation.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[9,"PAYM","Payment","Undertaking in support of a payment obligation.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[10,"PERF","Performance","Undertaking in support of a performance obligation.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[11,"RETN","Retention","Undertaking in support of a monetary retention obligation.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[12,"SHIP","Shipping","Undertaking in support of a sea transportation obligation.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[13,"TEND","TenderOrBid","Undertaking in support of a tender or bid obligation.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]
[14,"WARR","Warranty","Undertaking in support of a warranty obligation.","BJ53/SWIFT","New","14 December 2012","14 December 2012"]

{"sheet":"49-DocumentLineType","index":53,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,4,2,7]],"flags":["formulas_cached_only"]}
[]
["ExternalDocumentLineType1Code"]
["Identification",null,null,null,"Status"]
[null,"\nCode","\nName","\nDefinition","Origin/Requester","Status","Status Date","Introduced Date"]
[1,"ADPI","Additional Product Identification Assigned by the Manufacturer","Line item reference is an additional product identification assigned by the manufacturer.","BJ 46 - RemittanceAdvice - IFX & OAGi","New","17 April 2014","17 April 2014"]
[2,"AISB","Alternate ISBN","Line item reference is an alternate International Standard Book Number (ISBN).","BJ 46 - RemittanceAdvice - IFX & OAGi","New","17 April 2014","17 April 2014"]
[3,"ASNB","Asset Number","Line item reference is an asset number.","BJ 46 - RemittanceAdvice - IFX & OAGi","New","17 April 2014","17 April 2014"]
[4,"CTNB","Catalog Number","Line item reference is a catalog number.","BJ 46 - RemittanceAdvice - IFX & OAGi","New","17 April 2014","17 April 2014"]
[5,"DBSP","Dun & Bradstreet Standard Product and Service Code","Line item reference is Dun & Bradstreet Standard Product and Service code.","BJ 46 - RemittanceAdvice - IFX & OAGi","New","17 April 2014","17 April 2014"]
[6,"EANN","European Article Number (EAN) (2-5-5-1)","Line item reference is an European Article Number (EAN).","BJ 46 - RemittanceAdvice - IFX & OAGi","New","17 April 2014","17 April 2014"]
[7,"EINB","Equipment Identification Number","Line item reference is an equipment identification number.","BJ 46 - RemittanceAdvice - IFX & OAGi","New","17 April 2014","17 April 2014"]
[8,"GSNB","General Specification Number","Line item reference is a general specification number.","BJ 46 - RemittanceAdvice - IFX & OAGi","New","17 April 2014","17 April 2014"]
[9,"HIBC","HIBC (Health Care Industry Bar Code)","Line item reference is a Health Care Industry Bar Code (HIBC)","BJ 46 - RemittanceAdvice - IFX & OAGi","New","17 April 2014","17 April 2014"]
[10,"ISBN","International Standard Book Number (ISBN)","Line item reference is an International Standard Book Number (ISBN).","BJ 46 - RemittanceAdvice - IFX & OAGi","New","17 April 2014","17 April 2014"]
[11,"LTNB","Lot Number","Line item reference is a lot number.","BJ 46 - RemittanceAdvice - IFX & OAGi","New","17 April 2014","17 April 2014"]
[12,"MDNB","Model Number","Line item reference is a model number","BJ 46 - RemittanceAdvice - IFX & OAGi","New","17 April 2014","17 April 2014"]
[13,"PRNB","Part Number","Line item reference is a part reference number.","BJ 46 - RemittanceAdvice - IFX & OAGi","New","17 April 2014","17 April 2014"]
[14,"PTCD","Product Type Code","Line item reference is a product type code.","BJ 46 - RemittanceAdvice - IFX & OAGi","New","17 April 2014","17 April 2014"]
[15,"SKNB","Stock Number","Line item reference is a stock number.","BJ 46 - RemittanceAdvice - IFX & OAGi","New","17 April 2014","17 April 2014"]
[16,"STNB","Style Number","Line item reference is a style number.","BJ 46 - RemittanceAdvice - IFX & OAGi","New","17 April 2014","17 April 2014"]
[17,"TONB","Technical Order Number","Line item reference is a technical order number.","BJ 46 - RemittanceAdvice - IFX & OAGi","New","17 April 2014","17 April 2014"]
[18,"UPCC","UPC Consumer Package Code","Line item reference is an UPC consumer package code.","BJ 46 - RemittanceAdvice - IFX & OAGi","New","17 April 2014","17 April 2014"]
[19,"UPNB","Universal Product Number","Line item reference is an Universal Product Number.","BJ 46 - RemittanceAdvice - IFX & OAGi","New","17 April 2014","17 April 2014"]

{"sheet":"50-GarnishmentType","index":54,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,4,2,7]],"flags":["formulas_cached_only"]}
[]
["ExternalGarnishmentType1Code"]
["Identification",null,null,null,"Status"]
[null,"\nCode","\nName","\nDefinition","Origin/Requester","Status","Status Date","Introduced Date"]
[1,"GNCS","GarnishmentForChildSupport","Garnishment from a third party payer for Child Support","BJ 46 - RemittanceAdvice - IFX & OAGi","New","17 April 2014","17 April 2014"]
[2,"GNDP","GarnishmentForChildSupportFromDirectPayer","Garnishment from a direct payer for Child Support","BJ 46 - RemittanceAdvice - IFX & OAGi","New","17 April 2014","17 April 2014"]
[3,"GTPP","GarnishmentToTaxingAgency","Garnishment from a third party payer to taxing agency","BJ 46 - RemittanceAdvice - IFX & OAGi","New","17 April 2014","17 April 2014"]

{"sheet":"51-TradeMarket","index":55,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
["ExternalTradeMarket1Code"]
[null,null,null,"Identification",null,null,"Status"]
[null,"\nCode","\nName","\nDefinition","Origin/Requester","Status","Status Date","Introduced Date"]
[1,"FDMS","FactoringDomestic","Factoring service provider, Factoring client and third party in the same country","BJ61/ASF","New","28 April 2015","28 April 2015"]
[2,"FEXP","FactoringExport","Factoring service provider, Factoring client in the same country, third party in another country","BJ61/ASF","New","28 April 2015","28 April 2015"]
[5,"FFDM","FactoringForeignDomestic","Factoring client and third party in the same country, Factoring service provider in another country","BJ61/ASF","New","28 April 2015","28 April 2015"]
[3,"FFDT","FactoringFrenchDomTom","Factoring service provider, Factoring client and third party in the same country, but factoring client has an exceptional VAT ruling, for example if it’s overseas","BJ61/ASF","New","28 April 2015","28 April 2015"]
[4,"FIMP","FactoringImport","Factoring service provider and third party in the same country, Factoring client in another country","BJ61/ASF","New","28 April 2015","28 April 2015"]
[6,"FREX","FactoringReexportedExport","Factoring service provider, Factoring client and third party in three different countries","BJ61/ASF","New","28 April 2015","28 April 2015"]

{"sheet":"52-MandateSetupReason","index":56,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,4,2,7]],"flags":["formulas_cached_only"]}
[]
["ExternalMandateSetupReason1Code"]
["Identification",null,null,null,"Status"]
[null,"\nCode","\nName","\nDefinition","\nOrigin/Requester","Status","Status Date","Introduced Date"]
[1,"Currently no codes have been defined."]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]