{"text_format":"3","workbook":"xls","n_sheets":33,"sheets":["Intro&History","PAYMENTS","TRADE","SECURITIES","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"],"not_rendered":{"external_links":1,"defined_names":53},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Intro&History","index":0,"n_rows":38,"n_cols":2,"rows_kept":38,"flags":["formulas_cached_only"]}
["Subject","Inventory of External Code Lists - Required by (but external to) the ISO 20022 XML Message Schemas"]
[]
["Publication date","16 July, 2012 - 2Q2012"]
["Source","ISO20022.org"]
[null,"See this site for the latest version of these code lists."]
[]
["Related Messages  ","Payments messages: See PAYMENTS inventory sheet.    "]
[null,"Trade Services messages: See TRADE inventory sheet."]
[null,"Securities messages: See SECURITIES inventory sheet"]
[]
["Details","All external code lists required to fully use the ISO 20022 Message Schemas are included in this document but 3."]
[null,"An additional 3 code lists (Bank Transaction Code) can be found separately on ISO20022.org."]
[]
["Description","These codes are required by some of 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.  "]
[]
["Content","External code lists 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 lists are maintained on a quarterly basis. Updated lists are published by end February, end of May, end of August and end of November. Requests for changes must be submitted using the form:"]
[null,"\"Change Request for the update of an External Code List\" 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 lists:  LocalInstrument, Purpose, ReturnReason.  Reformatted to include 'introduced date'. "]
["03 Feb, 2010","Revised proposed code value for CoreNoRefund per submitter request (CR0005, code list 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 lists"]
["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 list.  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 lists (DocumentPurpose, DocumentType, Incoterms, InformationType, PackagingType)  \nFor the Securities SEG - addition of code list 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 list 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 lists 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 lists: 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: CR243 - EPC - ReturnReasonCode & StatusReasonCode. CR244 - Bank Association of Slovenia - PurposeCode. Code lists 28-DiscountAmountType and 29-TaxAmountType: code values for the lists created as external code lists but unpopulated during the last message maintenance cycle."]

{"sheet":"PAYMENTS","index":1,"n_rows":50,"n_cols":63,"rows_kept":50,"merged":[[0,1,0,60],[3,1,5,1],[3,2,5,2],[3,21,4,60],[3,62,4,62],[35,2,37,2],[35,62,37,62]],"flags":["formulas_cached_only"]}
[null,"OVERVIEW EXTERNAL CODE LISTS USED IN PAYMENTS MESSAGES"]
[]
[]
[null,"Data Element Name","SEG",{"$nulls":18},"Used in"]
[]
[{"$nulls":3},"acmt.007.001.01","acmt.008.001.01","acmt.009.001.01","acmt.010.001.01","acmt.011.001.01","acmt.012.001.01","acmt.013.001.01","acmt.014.001.01","acmt.015.001.01","acmt.016.001.01","acmt.017.001.01","acmt.018.001.01","acmt.019.001.01","acmt.020.001.01","acmt.021.001.01","acmt.022.001.01","acmt.023.001.01","acmt.024.001.01","pain.001.001.04","pain.008.001.03","pain.002.001.04","pain.007.001.03","pain.009.001.02","pain.010.001.02","pain.011.001.02","pain.012.001.02","pain.013.001.02","pain.014.001.02","pacs.003.001.03","pacs.008.001.03","pacs.009.001.03","pacs.002.001.04","pacs.004.001.03","pacs.007.001.03","camt.007.002.03","camt.026.001.03","camt.027.001.03","camt.028.001.03","camt.029.001.03","camt.030.001.03","camt.031.001.03","camt.032.001.02","camt.033.001.03","camt.034.001.03","camt.035.001.02","camt.036.001.02","camt.037.001.03","camt.038.001.02","camt.039.001.03","camt.052.001.03","camt.053.001.03","camt.054.001.03","camt.055.001.02","camt.056.001.03","camt.057.001.03","camt.058.001.03","camt.059.001.03","camt.060.001.03","camt.087.001.01","Last Publication Date"]
[1,"ExternalAccountIdentification1Code","Payments","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√",null,"√","√","√",{"$nulls":10},"√","√","√","√","√","√","√","√","√",null,"2009-06-09"]
[2,"ExternalBalanceSubType1Code","Payments",{"$nulls":49},"√","√",{"$nulls":6},"√",null,"2011-05-31"]
[3,"ExternalCashClearingSystem1Code","Payments",{"$nulls":20},"√","√",{"$nulls":5},"√","√","√","√","√","√","√","√",null,null,"√","√",{"$nulls":13},"√","√",{"$nulls":5},"2010-08-16"]
[4,"ExternalCategoryPurpose1Code","Payments",{"$nulls":18},"√","√","√","√",{"$nulls":4},"√","√","√","√","√","√","√","√","√",null,null,"√","√",{"$nulls":13},"√","√",{"$nulls":5},"2012-02-09"]
[5,"ExternalClearingSystemIdentification1Code ","Payments","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√",null,"2011-05-31"]
[6,"ExternalFinancialInstitutionIdentification1Code","Payments","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√",null,"2009-06-09"]
[7,"ExternalLocalInstrument1Code ","Payments",{"$nulls":18},"√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√",null,null,"√","√","`",{"$nulls":12},"√","√",{"$nulls":5},"2012-06-22"]
[8,"ExternalMandateReason1Code","Payments",{"$nulls":23},"√","√","√",{"$nulls":33},"2010-11-30"]
[9,"ExternalOrganisationIdentification1Code","Payments","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√",null,"2011-02-17"]
[10,"ExternalPersonIdentification1Code","Payments","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√",null,"2009-06-09"]
[11,"ExternalPurpose1Code ","Payments",{"$nulls":18},"√","√",{"$nulls":6},"√",null,"√","√",{"$nulls":4},"√",{"$nulls":3},"√",{"$nulls":10},"√","√","√",null,null,"√","√","√",null,null,"2012-07-16"]
[12,"ExternalReportingSource1Code","Payments",{"$nulls":49},"√","√","√",{"$nulls":7},"2009-06-09"]
[13,"ExternalReturnReason1Code","Payments",{"$nulls":32},"√",{"$nulls":16},"√","√","√",{"$nulls":7},"2012-07-16"]
[14,"ExternalReversalReason1Code","Payments",{"$nulls":21},"√",{"$nulls":11},"√",{"$nulls":25},"2009-06-09"]
[15,"ExternalServiceLevel1Code","Payments",{"$nulls":18},"√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√",null,null,"√","√",{"$nulls":13},"√","√",{"$nulls":5},"2009-06-09"]
[16,"ExternalStatusReason1Code","Payments",{"$nulls":20},"√",{"$nulls":6},"√",{"$nulls":3},"√",{"$nulls":27},"2012-07-16"]
[17,"ExternalTechnicalInputChannel1Code","Payments",{"$nulls":49},"√","√","√",{"$nulls":7},"2009-06-09"]
[18,"ExternalVerificationReason1Code","Payments",{"$nulls":17},"√",{"$nulls":41},"2010-08-16"]
[19,"ExternalDocumentPurpose1Code","Trade",{"$nulls":59},"2010-11-30"]
[20,"ExternalDocumentType1Code","Trade",{"$nulls":59},"2010-11-30"]
[21,"ExternalIncoterms1Code","Trade",{"$nulls":59},"2010-11-30"]
[22,"ExternalInformationType1Code","Trade",{"$nulls":59},"2010-11-30"]
[23,"ExternalPackagingType1Code","Trade",{"$nulls":59},"2010-11-30"]
[24,"ExternalFinancialInstrumentIdentificationType1Code","Securities",{"$nulls":59},"2010-11-30"]
[25,"ExternalTradeTransactionConditions1Code","Securities",{"$nulls":59},"2011-08-31"]
[26,"ExternalChargeType1Code","Payments",{"$nulls":49},"√","√","√",{"$nulls":7},"2012-05-31"]
[27,"ExternalCashAccountType1Code","Payments",{"$nulls":18},"√","√","√","√","√","√","√","√","√","√",null,"√","√","√","√","√",null,null,"√","√","√",{"$nulls":10},"√","√","√","√","√","√","√","√","√","√","2012-05-31"]
[28,"ExternalDiscountAmountType1Code","Payments",{"$nulls":18},"√",null,"√","√",{"$nulls":4},"√","√","√","√","√","√","√","√",{"$nulls":3},"√","√",{"$nulls":10},"√","√","√","√","√","√","√","√","√","√","2012-07-16"]
[29,"ExternalTaxAmountType1Code","Payments",{"$nulls":18},"√",null,"√","√",{"$nulls":4},"√","√","√","√","√","√","√","√",{"$nulls":3},"√","√",{"$nulls":10},"√","√","√","√","√","√","√","√","√","√","2012-07-16"]
[null,"ExternalBankTransactionDomain1Code 1","Payments","√","√",{"$nulls":5},"√",null,null,"√","√",{"$nulls":37},"√","√","√",{"$nulls":7},"2009-06-16"]
[null,"ExternalBankTransactionFamily1Code 1",null,"√","√",{"$nulls":5},"√",null,null,"√","√",{"$nulls":37},"√","√","√"]
[null,"ExternalBankTransactionSubFamily1Code 1",null,"√","√",{"$nulls":5},"√",null,null,"√","√",{"$nulls":37},"√","√","√"]
[]
[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 "]

{"sheet":"TRADE","index":2,"n_rows":40,"n_cols":5,"rows_kept":40,"merged":[[3,1,5,1],[3,2,5,2],[3,3,4,3],[3,4,4,4],[35,2,37,2],[35,4,37,4]],"flags":["formulas_cached_only"]}
[null,"OVERVIEW EXTERNAL CODE LISTS USED IN TRADE SERVICES MESSAGES"]
[]
[]
[null,"Data Element Name","SEG","Used in"]
[]
[{"$nulls":3},"tsin.004.001.01","Last Publication Date"]
[1,"ExternalAccountIdentification1Code","Payments","√","2009-06-09"]
[2,"ExternalBalanceSubType1Code","Payments",null,"2011-05-31"]
[3,"ExternalCashClearingSystem1Code","Payments",null,"2010-08-16"]
[4,"ExternalCategoryPurpose1Code","Payments","√","2012-02-09"]
[5,"ExternalClearingSystemIdentification1Code ","Payments","√","2011-05-31"]
[6,"ExternalFinancialInstitutionIdentification1Code","Payments","√","2009-06-09"]
[7,"ExternalLocalInstrument1Code ","Payments","√","2012-06-22"]
[8,"ExternalMandateReason1Code","Payments",null,"2010-11-30"]
[9,"ExternalOrganisationIdentification1Code","Payments","√","2011-02-17"]
[10,"ExternalPersonIdentification1Code","Payments","√","2009-06-09"]
[11,"ExternalPurpose1Code ","Payments",null,"2012-07-16"]
[12,"ExternalReportingSource1Code","Payments",null,"2009-06-09"]
[13,"ExternalReturnReason1Code","Payments",null,"2012-07-16"]
[14,"ExternalReversalReason1Code","Payments",null,"2009-06-09"]
[15,"ExternalServiceLevel1Code","Payments","√","2009-06-09"]
[16,"ExternalStatusReason1Code","Payments",null,"2012-07-16"]
[17,"ExternalTechnicalInputChannel1Code","Payments",null,"2009-06-09"]
[18,"ExternalVerificationReason1Code","Payments",null,"2010-08-16"]
[19,"ExternalDocumentPurpose1Code","Trade","√","2010-11-30"]
[20,"ExternalDocumentType1Code","Trade","√","2010-11-30"]
[21,"ExternalIncoterms1Code","Trade","√","2010-11-30"]
[22,"ExternalInformationType1Code","Trade","√","2010-11-30"]
[23,"ExternalPackagingType1Code","Trade","√","2010-11-30"]
[24,"ExternalFinancialInstrumentIdentificationType1Code","Securities",null,"2010-11-30"]
[25,"ExternalTradeTransactionConditions1Code","Securities",null,"2011-08-31"]
[26,"ExternalChargeType1Code","Payments",null,"2012-05-31"]
[27,"ExternalCashAccountType1Code","Payments",null,"2012-05-31"]
[28,"ExternalDiscountAmountType1Code","Payments",null,"2012-07-16"]
[29,"ExternalTaxAmountType1Code","Payments",null,"2012-07-16"]
[null,"ExternalBankTransactionDomain1Code 1","Payments",null,"2009-06-16"]
[null,"ExternalBankTransactionFamily1Code 1"]
[null,"ExternalBankTransactionSubFamily1Code 1"]
[null,"Legend"]
[null,"1.  The Bank Transaction Code documentation is available separately on ISO20022.org"]

{"sheet":"SECURITIES","index":3,"n_rows":40,"n_cols":48,"rows_kept":40,"merged":[[0,0,0,3],[3,1,5,1],[3,2,5,2],[3,3,4,44],[3,47,4,47],[35,2,37,2],[35,47,37,47]],"flags":["formulas_cached_only"]}
["OVERVIEW EXTERNAL CODE LISTS USED IN SECURITIES MESSAGES"]
[]
[]
[null,"Data Element Name","SEG","Used in"]
[]
[{"$nulls":3},"seev.031.001.02 ","seev.032.001.02","seev.033.001.02 ","seev.034.001.02 ","seev.035.001.02 ","seev.036.001.02 ","seev.037.001.02 ","seev.038.001.02 ","seev.039.001.02 ","seev.040.001.02 ","seev.041.001.02 ","seev.042.001.02 ","seev.044.001.02 ","semt.002.001.04","semt.003.001.04","semt.013.001.02","semt.014.001.02","semt.015.001.02","semt.016.001.02","semt.017.001.02","semt.018.001.02","semt.019.001.02","semt.020.001.02","semt.021.001.02","sese.020.001.02","sese.021.001.02","sese.022.001.02","sese.023.001.02","sese.024.001.02","sese.025.001.02","sese.026.001.02","sese.027.001.02","sese.028.001.02","sese.029.001.02","sese.030.001.02","sese.031.001.02","sese.032.001.02","sese.033.001.02","sese.034.001.02","sese.035.001.02","sese.036.001.02","sese.037.001.02","setr.027.001.01","setr.044.001.01","Last Publication Date"]
[1,"ExternalAccountIdentification1Code","Payments",{"$nulls":44},"2009-06-09"]
[2,"ExternalBalanceSubType1Code","Payments",{"$nulls":44},"2011-05-31"]
[3,"ExternalCashClearingSystem1Code","Payments",{"$nulls":44},"2010-08-16"]
[4,"ExternalCategoryPurpose1Code","Payments",{"$nulls":44},"2012-02-09"]
[5,"ExternalClearingSystemIdentification1Code ","Payments",{"$nulls":44},"2011-05-31"]
[6,"ExternalFinancialInstitutionIdentification1Code","Payments",{"$nulls":44},"2009-06-09"]
[7,"ExternalLocalInstrument1Code ","Payments",{"$nulls":44},"2012-06-22"]
[8,"ExternalMandateReason1Code","Payments",{"$nulls":44},"2010-11-30"]
[9,"ExternalOrganisationIdentification1Code","Payments",{"$nulls":44},"2011-02-17"]
[10,"ExternalPersonIdentification1Code","Payments",{"$nulls":44},"2009-06-09"]
[11,"ExternalPurpose1Code ","Payments",{"$nulls":44},"2012-07-16"]
[12,"ExternalReportingSource1Code","Payments",{"$nulls":44},"2009-06-09"]
[13,"ExternalReturnReason1Code","Payments",{"$nulls":44},"2012-07-16"]
[14,"ExternalReversalReason1Code","Payments",{"$nulls":44},"2009-06-09"]
[15,"ExternalServiceLevel1Code","Payments",{"$nulls":44},"2009-06-09"]
[16,"ExternalStatusReason1Code","Payments",{"$nulls":44},"2012-07-16"]
[17,"ExternalTechnicalInputChannel1Code","Payments",{"$nulls":44},"2009-06-09"]
[18,"ExternalVerificationReason1Code","Payments",{"$nulls":44},"2010-08-16"]
[19,"ExternalDocumentPurpose1Code","Trade",{"$nulls":44},"2010-11-30"]
[20,"ExternalDocumentType1Code","Trade",{"$nulls":44},"2010-11-30"]
[21,"ExternalIncoterms1Code","Trade",{"$nulls":44},"2010-11-30"]
[22,"ExternalInformationType1Code","Trade",{"$nulls":44},"2010-11-30"]
[23,"ExternalPackagingType1Code","Trade",{"$nulls":44},"2010-11-30"]
[24,"ExternalFinancialInstrumentIdentificationType1Code","Securities","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√","√",null,"2010-11-30"]
[25,"ExternalTradeTransactionCondition1Code","Securities",{"$nulls":42},"√","√","2011-08-31"]
[26,"ExternalChargeType1Code","Payments",{"$nulls":44},"2012-05-31"]
[27,"ExternalCashAccountType1Code","Payments",{"$nulls":44},"2012-05-31"]
[28,"ExternalDiscountAmountType1Code","Payments",{"$nulls":44},"2012-07-16"]
[29,"ExternalTaxAmountType1Code","Payments",{"$nulls":44},"2012-07-16"]
[null,"ExternalBankTransactionDomain1Code 1","Payments",{"$nulls":44},"2009-06-16"]
[null,"ExternalBankTransactionFamily1Code 1"]
[null,"ExternalBankTransactionSubFamily1Code 1"]
[null,"Legend"]
[null,"1.  The Bank Transaction Code documentation is available separately on ISO20022.org"]

{"sheet":"1-AccountIdentification","index":4,"n_rows":7,"n_cols":9,"rows_kept":7,"merged":[[1,0,1,8],[2,0,2,3],[2,5,2,8]],"flags":["formulas_cached_only"]}
[]
["ExternalAccountIdentification1Code"]
["Identification",{"$nulls":3},"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":5,"n_rows":25,"n_cols":9,"rows_kept":25,"merged":[[1,0,1,8],[2,0,2,3],[2,5,2,8]],"flags":["formulas_cached_only"]}
[]
["ExternalBalanceSubType1Code"]
["Identification",{"$nulls":3},"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":6,"n_rows":87,"n_cols":9,"rows_kept":87,"merged":[[1,0,1,8],[2,0,2,3],[2,5,2,8]],"flags":["formulas_cached_only"]}
[]
["ExternalCashClearingSystem1Code"]
["Identification",{"$nulls":3},"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"]
[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"]
[3,"AIP","Albania","AL (Albania) -  Albania Interbank Payment System.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[4,"ART","Austrian","AT (Austria) - Austrian RTGS (ARTIS).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[5,"AVP","NewZealand","NZ (New Zealand) - New Zealand Assured Value Payments.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[6,"AZM","Azerbaijan","AZ (Azerbaijan) - Azerbaijan Interbank Payment System (AZIPS).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[7,"BAP","BosniaHerzegovina","BA (Bosnia and Herzegovina).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[8,"BCC","SwedenBGC","SE (Sweden) - Sweden BGC Clearing CUG.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[9,"BDS","Barbados","BB (Barbados) - Barbados RTGS (CBRTGS).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[10,"BEL","Belgium","BE (Belgium) - Belgium RTGS (ELLIPS).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[11,"BGN","Bulgaria","BG (Bulgaria) - Bulgaria RTGS.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[12,"BHS","Bahamas","BS (Bahamas) - Bahamas RTGS.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[13,"BIS","Botswana","BW (Botswana) - Botswana Interbank Settlement System.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[14,"BOF","Finland","FI (Finland) - RTGS (BOF).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[15,"BOJ","BankOfJapanNet","the Bank of Japan clearing system.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[16,"BRL","Italy","IT (Italy) - Italy RTGS (BIREL).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[17,"BSP","Philippines","PH (Philippines) - Philippines Payment System.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[18,"CAD","Canada","CA (Canada) - Canadian Large Value Transfer System (LVTS) ",null,"Maintenance SR2009","New","April 2009","April 2009"]
[19,"CAM","SpainCAM","ES (Spain).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[20,"CBJ","Ireland","IE (Ireland) - Irish RTGS (IRIS).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[21,"CHI ","USTCHChips ","US - The Clearing House CHIPS",null,"Maintenance SR2009","New","April 2009","April 2009"]
[22,"CHP","UnitedKingdom","GB (UK) - British Euro RTGS (CHAPS).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[23,"COE","Columbia","CO (Columbia) - Colombian Electronic Cheque System named CEDEC (Compensación Electrónica De Cheques).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[24,"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"]
[25,"COU","Columbia","CO (Columbia) - Colombian RTGS System named CUD (Cuentas de Depósito).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[26,"DDK","DenmarkDDK","DK (Denmark) - Danish Krone RTGS (KRONOS)",null,"Maintenance SR2009","New","April 2009","April 2009"]
[27,"DKC","Denmark","DK (Denmark) - Danish Euro RTGS (KRONOS)",null,"Maintenance SR2009","New","April 2009","April 2009"]
[28,"EBA","EBAEuro1","EBA Euro1.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[29,"ELS","GermanyELS","DE (Germany).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[30,"EPM","ECB","ECB (European Central Bank) - ECB Payment Mechanism.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[31,"EPN ","USTCHEPN ","US - The Clearing House EPN",null,"Maintenance SR2009","New","April 2009","April 2009"]
[32,"ERP","EBAStep1","EBA step 1 (members).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[33,"FDA ","USFedACH ","US (United States) - FED-ACH",null,"Maintenance SR2009","New","April 2009","April 2009"]
[34,"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"]
[35,"FDW ","USFedwire ","US (United States) – FEDWIRE",null,"Maintenance SR2009","New","April 2009","April 2009"]
[36,"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"]
[37,"GIS","Ghana","GH (Ghana) - Ghana Interbank Settlement System (GISS).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[38,"HRK","Croatia","HR (Croatia) - HSVP.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[39,"HRM","Greece","GR (Greece) - Greek RTGS (HERMES).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[40,"HUF","Hungary","HU (Hungary) - VIBER.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[41,"INC ","DEandNLEquens ","DE and NL - Equens ",null,"Maintenance SR2009","New","April 2009","April 2009"]
[42,"JOD","Jordan","JO (Jordan) - Jordan RTGS.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[43,"KPS","Kenya","KE (Kenya) - Kenyan Electronic Payment Settlement System.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[44,"LGS","Luxemburg","LU (Luxemburg) - Luxembourg RTGS (LIPS).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[45,"LKB","SriLanka","LK (Sri Lanka) - Sri Lanka (Lankasettle).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[46,"LVL","Latvia","LV (Latvia).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[47,"MEP","Singapore","SG (Singapore) - Singapore RTGS (MEPS+).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[48,"MOS","SouthAfrica","ZA (South Africa) - South-African Multiple Option Settlement.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[49,"MRS","Malta","MT (Malta) - Malta Realtime Interbank Settlement System.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[50,"MUP","Mauritius","MU (Mauritius).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[51,"NAM","Namibia","NA (Namibian) - Namibian Interbank Settlement System.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[52,"NOC","Norway","NO (Norway).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[53,"PCH","Switzerland","CH (Switzerland).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[54,"PDS","Australia","AU (Australia).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[55,"PEG","Egypt","EG (Egypt).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[56,"PNS","FrancePNS","FR (France).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[57,"PTR","Angola","AO (Angola) - Angola RTGS.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[58,"PVE","Venezuela","Ve (Venezuela).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[59,"ROL","RomaniaEPO","RO (Romania) - Romanian Electronic Payment Operations RT.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[60,"ROS","RomaniaGSRS","RO (Romania) - Romanian GSRS.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[61,"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"]
[62,"RTP","GermanyRTGSPlus","DE (Germany).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[63,"SCL","RPS SEPA-Clearer ","DE – SEPA-Clearer of the Retail Payment System operated by Deutsche Bundesbank ",null,"Deutsche Bundesbank (2Q2010-CR0015)","New","August 2010","August 2010"]
[64,"SCP","Chili","CL (Chile) - Chilean Interbank Payment System.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[65,"SEC","SwedenSEC","SE (Sweden) - Swedish Euro RTGS (SEC).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[66,"SIT","Slovania","SI (Slovenia).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[67,"SLB","SpainES","ES (Spain) - Spanish RTGS (SLBE).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[68,"SPG","Portugal","PT (Portugal) - Portuguese RTGS (SPGT).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[69,"SSK","SwedenSSK","SE (Sweden) - SEK RTGS (RIX).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[70,"ST2","EBAStep2","EBA Clearing STEP 2",null,"Maintenance SR2009","New","April 2009","April 2009"]
[71,"STG","UnitedKingdomGBP","UK (United Kingdom) - CHAPS Sterling RTGS.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[72,"TBF","FranceFR","FR (France) - French RTGS (TBF).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[73,"TGT","Target","Target.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[74,"THB","Thailand","TH (Thailand) - Thailand Payment System (Bahtnet/2).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[75,"TIS","Tanzania","TZ (Tanzania) - Tanzania Interbank Settlement System (TISS).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[76,"TOP","Netherlands","NL (Netherlands) - Dutch RTGS (TOP) ",null,"Maintenance SR2009","New","April 2009","April 2009"]
[77,"TTD","TrinidadAndTobago","TT (Trinidad and Tobago ) - Trinidad and Tobago SAFE-TT.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[78,"UIS","Uganda","UG (Uganda) - Uganda National Interbank Settlement System.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[79,"VCS","VocaLink","VocaLink Clearing System",null,"Maintenance SR2009","New","April 2009","April 2009"]
[80,"XCT","EBAStep2","EBA step 2.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[81,"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"]
[82,"ZET","Zimbabwe","ZW (Zimbabwe) - Zimbabwe Electronic Transfer & Settlement System.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[83,"ZIS","Zambia","ZM (Zambia) - Zambian Interbank Payment &Settlement System.",null,"Maintenance SR2009","New","April 2009","April 2009"]

{"sheet":"4-CategoryPurpose","index":7,"n_rows":32,"n_cols":9,"rows_kept":32,"merged":[[1,0,1,8],[2,0,2,3],[2,5,2,8],[29,0,29,1],[29,2,29,8]],"flags":["formulas_cached_only"]}
[]
["ExternalCategoryPurpose1Code"]
["Identification",{"$nulls":3},"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,"CCRD","Credit Card Payment","Transaction is related to a payment of credit card.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[4,"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"]
[5,"DCRD","Debit Card Payment","Transaction is related to a payment of debit card.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[6,"DIVI","Dividend","Transaction is the payment of dividends.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[7,"EPAY","Epayment","Transaction is related to ePayment via Online-Banking",null,"CR0063/Stuzza","New","23 May 2011","23 May 2011"]
[8,"GOVT","GovernmentPayment","Transaction is a payment to or from a government department.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[9,"HEDG","Hedging","Transaction is related to the payment of a hedging operation.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[10,"ICCP","Irrevocable Credit Card Payment","Transaction is reimbursement of credit card payment.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[11,"IDCP","Irrevocable Debit Card Payment","Transaction is reimbursement of debit card payment.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[12,"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"]
[13,"INTE","Interest","Transaction is the payment of interest.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[14,"LOAN","Loan","Transaction is related to the transfer of a loan to a borrower.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[15,"OTHR","OtherPayment","Other payment purpose.",null,"CR0156/CGI Group","New","9 February 2012","9 February 2012"]
[16,"PENS","PensionPayment","Transaction is the payment of pension.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[17,"SALA","SalaryPayment","Transaction is the payment of salaries.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[18,"SECU","Securities","Transaction is the payment of securities.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[19,"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"]
[20,"SUPP","SupplierPayment","Transaction is related to a payment to a supplier.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[21,"TAXS","TaxPayment","Transaction is the payment of taxes.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[22,"TRAD","Trade","Transaction is related to the payment of a trade finance transaction.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[23,"TREA","TreasuryPayment","Transaction is related to treasury operations.  E.g. financial contract settlement.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[24,"VATX","ValueAddedTaxPayment","Transaction is the payment of value added tax.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[25,"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":8,"n_rows":29,"n_cols":11,"rows_kept":29,"merged":[[1,0,1,10],[2,0,2,3],[2,4,2,6],[2,7,2,10]],"flags":["formulas_cached_only"]}
[]
["ExternalClearingSystemIdentification1Code"]
["Identification",{"$nulls":3},"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}","ATBLZ12345","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}","AUBSB123456","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}","CACPA123456789","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}","CHBCC12345","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}","CHSIC123456","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}","CNAPS123456789012","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}","DEBLZ12345678","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}","ESNCC12345678","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}","GBDSC123456","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}","GRBIC1234567","Payments Harmonisation 2006 External Code List","Example corrected","May 2011","September 2007"]
[11,"HKNCC","Hong Kong Bank Code ","Bank Branch code used in Hong Kong","Hong Kong","[0-9]{3,3}","HKNCC123","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}","IENCC123456","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}","INFSC123AZ456789","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}","ITNCC1234567890","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}","JPZGN1234567","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}","NZNCC123456","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}","PLKNR12345678","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}","PTNCC12345678","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}","RUCBC123456789","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}","SESBA1234","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}","SGIBG1234567","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[22,"TWNCC","Financial Institution Code","Bank Branch code used in Taiwan","Taiwan","[0-9]{7,7}                                  ","TWNCC1234567","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[23,"USABA","United States Routing Number (Fedwire, NACHA)","Routing Transit number assigned by the ABA for US financial institutons","US","[0-9]{9,9}","USABA123456789","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[24,"USPID","CHIPS Participant Identifier","Bank identifier used by CHIPs in the US","US","[0-9]{4,4}","USPID1234","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[25,"ZANCC","South African National Clearing Code","Bank Branch code used in South Africa","South Africa","[0-9]{6,6}","ZANCC123456","Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]

{"sheet":"6-FinancialInstitutionIdentif","index":9,"n_rows":22,"n_cols":9,"rows_kept":22,"merged":[[2,0,2,3],[2,5,2,8]],"flags":["formulas_cached_only"]}
[]
["ExternalFinancialInstitutionIdentification1Code"]
["Identification",{"$nulls":3},"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":"7-LocalInstrument","index":10,"n_rows":89,"n_cols":14,"rows_kept":89,"merged":[[2,0,2,3],[2,4,2,9],[2,10,2,13]],"flags":["formulas_cached_only"]}
[]
["ExternalLocalInstrument1Code"]
["Identification",{"$nulls":3},"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,"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"]
[3,"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"]
[4,"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"]
[5,"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"]
[6,"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"]
[7,"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"]
[8,"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"]
[9,"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"]
[10,"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"]
[11,"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"]
[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,"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"]
[14,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"]
[15,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"]
[16,"CARD","Card Clearing","Transaction is related to card clearing.","EMEA","DE","EUR","All","Both",null,"Maintenance SR2009","New","April 2009","April 2009"]
[17,"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"]
[18,"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"]
[19,"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"]
[20,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"]
[21,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"]
[22,"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"]
[23,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"]
[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,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"]
[26,"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"]
[27,"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"]
[28,"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"]
[29,"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"]
[30,"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"]
[31,"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"]
[32,"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"]
[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,"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"]
[35,"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"]
[36,"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"]
[37,"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"]
[38,"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"]
[39,"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"]
[40,"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"]
[41,"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"]
[42,"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"]
[43,"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"]
[44,"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"]
[45,"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"]
[46,"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"]
[47,"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"]
[48,"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"]
[49,"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"]
[50,"ONCL","Overnight","Transaction is related to overnight clearing.","EMEA","SEPA","EUR","Corporate banking","CT","B2B","CGI-4Q2010 CR0053","New","December 2010","December 2010"]
[51,"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"]
[52,"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"]
[53,"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"]
[54,"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"]
[55,"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"]
[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,"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"]
[58,"DDFA","DirectDebitFixedAmount","SEPA Fixed Amount Direct Debit","EMEA","SEPA","EUR","PEACH","DD","B2B","EPC-1Q2010 CR0016","New","August 2010","August 2010"]
[59,"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"]
[60,"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"]
[61,"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"]
[62,"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"]
[63,"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"]
[64,"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"]
[65,"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"]
[66,"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"]
[67,"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"]
[68,"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"]
[69,"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"]
[70,"FFR","Fed Funds Returned","Transaction is related to Fed funds returned.","WHEM","US","USD","Fedwire","CT","B2B","Maintenance SR2009","New","April 2009","April 2009"]
[71,"FFS","Fed Funds Sold","Transaction is related to Fed funds sold.","WHEM","US","USD","Fedwire","CT","B2B","Maintenance SR2009","New","April 2009","April 2009"]
[72,"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"]
[73,"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"]
[74,"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"]
[75,"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"]
[76,"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"]
[77,"IAT","International ACH","Transaction is related to international ACH.","WHEM","US","USD","NACHA","Both","Both","US NACHA/Susan Colles","New","April 2009","April 2009"]
[78,"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"]
[79,"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"]
[80,"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"]
[81,"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"]
[82,"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"]
[83,"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"]
[]
[null,"* the codes are sorted according to the first four columns of the \"information details\", then by alphabetical order"]

{"sheet":"8-MandateReason","index":11,"n_rows":43,"n_cols":9,"rows_kept":43,"merged":[[1,0,1,8],[2,0,2,3],[2,5,2,8]],"flags":["formulas_cached_only"]}
[]
["ExternalMandateReason1Code"]
["Identification",{"$nulls":3},"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,"CR 52 3Q2010/EPC","New","Oct 2010","November 2010"]
[2,"AC04","ClosedAccountNumber","Account number specified has been closed on the Receiver's books",null,"CR 52 3Q2010/EPC","New","Oct 2010","November 2010"]
[3,"AC06","BlockedAccount","Account specified is blocked, prohibiting posting of transactions against it.",null,"CR 52 3Q2010/EPC","New","Oct 2010","November 2010"]
[4,"AG01","TransactionForbidden","Transaction forbidden on this type of account (formerly NoAgreement)",null,"CR 52 3Q2010/EPC","New","Oct 2010","November 2010"]
[5,"AG02","InvalidBankOperationCode","Bank Operation code specified in the message is not valid for receiver",null,"CR 52 3Q2010/EPC","New","Oct 2010","November 2010"]
[6,"AM02","NotAllowedAmount","Specific transaction/message amount is greater than allowed maximum",null,"CR 52 3Q2010/EPC","New","Oct 2010","November 2010"]
[7,"AM03","NotAllowedCurrency","Specified message amount is a non processable currency outside of existing agreement",null,"CR 52 3Q2010/EPC","New","Oct 2010","November 2010"]
[8,"AM05","Duplication","Duplication ",null,"CR 52 3Q2010/EPC","New","Oct 2010","November 2010"]
[9,"BE01","InconsistenWithEndCustomer","Identification of end customer is not consistent with associated account number. (formerly CreditorConsistency).",null,"CR 52 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,"CR 52 3Q2010/EPC","New","Oct 2010","November 2010"]
[11,"BE05","UnrecognisedInitiatingParty","Party who initiated the message is not recognised by the end customer",null,"CR 52 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,"CR 52 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,"CR 52 3Q2010/EPC","New","Oct 2010","November 2010"]
[14,"DT01","InvalidDate","Invalid date (eg, wrong settlement date)",null,"CR 52 3Q2010/EPC","New","Oct 2010","November 2010"]
[15,"FF01","InvalidFileFormat","File format incomplete or invalid",null,"CR 52 3Q2010/EPC","New","Oct 2010","November 2010"]
[16,"MD01","NoMandate","No Mandate",null,"CR 52 3Q2010/EPC","New","Oct 2010","November 2010"]
[17,"MD02","MissingMandatoryInformationInMandate","Mandate related information data required by the scheme is missing.",null,"CR 52 3Q2010/EPC","New","Oct 2010","November 2010"]
[18,"MD07","EndCustomerDeceased","End customer is deceased.",null,"CR 52 3Q2010/EPC","New","Oct 2010","November 2010"]
[19,"MD08","NoMandateServiceByAgent","Receiving agent does not offer specified Mandate services",null,"CR 52 3Q2010/EPC","New","Oct 2010","November 2010"]
[20,"MD09","NoMandateServiceOnCustomer","Account is not open to specified Mandates services",null,"CR 52 3Q2010/EPC","New","Oct 2010","November 2010"]
[21,"MD10","NoMandateServiceForSpecified","Account is not open to specified Mandates services for this particular creditor",null,"CR 52 3Q2010/EPC","New","Oct 2010","November 2010"]
[22,"MD11","UnrecognisedAgent","Agent to whom the message needs to be forwarded cannot be located",null,"CR 52 3Q2010/EPC","New","Oct 2010","November 2010"]
[23,"MD12","NotUniqueMandateReference","Mandate identification is not unique to the creditor",null,"CR 52 3Q2010/EPC","New","Oct 2010","November 2010"]
[24,"MD13","IncorrectCustomerAuthentication","There is a problem with the customer authentication",null,"CR 52 3Q2010/EPC","New","Oct 2010","November 2010"]
[25,"MD14","IncorrectAgent","Agent in the payment workflow is incorrect",null,"CR 52 3Q2010/EPC","New","Oct 2010","November 2010"]
[26,"MD15","IncorrectCurrency","Currency of the transaction is incorrect",null,"CR 52 3Q2010/EPC","New","Oct 2010","November 2010"]
[27,"MD16","RequestedByCustomer","Cancellation/amendment requested by the debtor",null,"CR 52 3Q2010/EPC","New","Oct 2010","November 2010"]
[28,"MD17","RequestedByInitiatingParty","Cancellation/amendment requested by the creditor",null,"CR 52 3Q2010/EPC","New","Oct 2010","November 2010"]
[29,"MD18","RequestedByInitiatingPartyAndCustomer","Cancellation/amendment requested by the creditor and the debtor",null,"CR 52 3Q2010/EPC","New","Oct 2010","November 2010"]
[30,"MS02","NotSpecifiedReasonCustomer Generated","Reason has not been specified by end customer",null,"CR 52 3Q2010/EPC","New","Oct 2010","November 2010"]
[31,"MS03","NotSpecifiedReasonAgentGenerated","Reason has not been specified by agent.",null,"CR 52 3Q2010/EPC","New","Oct 2010","November 2010"]
[32,"NARR","Narrative","Reason is provided as narrative information in the additional reason information.",null,"CR 52 3Q2010/EPC","New","Oct 2010","November 2010"]
[33,"RC01","BankIdentifierIncorrect","Bank Identifier code specified in the message has an incorrect format (formerly IncorrectFormatForRoutingCode).",null,"CR 52 3Q2010/EPC","New","Oct 2010","November 2010"]
[34,"RF01","NotUniqueTransactionReference","Transaction reference is not unique within the message.",null,"CR 52 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,"CR 52 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,"CR 52 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,"CR 52 3Q2010/EPC","New","Oct 2010","November 2010"]
[38,"RR04","Regulatory Reason ","Regulatory Reason",null,"CR 52 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,"CR 52 3Q2010/EPC","New","Oct 2010","November 2010"]

{"sheet":"9-OrganisationIdentification","index":12,"n_rows":15,"n_cols":9,"rows_kept":15,"merged":[[1,0,1,8],[2,0,2,3],[2,5,2,8]],"flags":["formulas_cached_only"]}
[]
["ExternalOrganisationIdentification1Code"]
["Identification",{"$nulls":3},"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":13,"n_rows":12,"n_cols":9,"rows_kept":12,"merged":[[2,0,2,3],[2,5,2,8]],"flags":["formulas_cached_only"]}
[]
["ExternalPersonIdentification1Code"]
["Identification",{"$nulls":3},"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":14,"n_rows":142,"n_cols":10,"rows_kept":142,"merged":[[2,0,2,4],[2,6,2,9]],"flags":["formulas_cached_only"]}
[]
["ExternalPurpose1Code"]
["Identification",{"$nulls":5},"Status"]
[null,"\nCode","Classification1","\nName","\nDefinition",null,"Origin/Requester","Status","Status Date","Introduced Date"]
[1,"CDCB","Card Settlement","CardPayment with CashBack","Purchase of Goods and Services with additional Cash disbursement at the POI (Cashback)",null,"Berlin Group","New","January 2010","January 2010"]
[2,"CDCD","Card Settlement","CashDisbursement","ATM Cash Withdrawal in an unattended or Cash Advance in an attended environment (POI or bank counter)",null,"Berlin Group","New","January 2010","January 2010"]
[3,"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.",null,"CR0153/Berlin Group","New","9 February 2012","9 February 2012"]
[4,"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.",null,"Berlin Group","New","January 2010","January 2010"]
[5,"CDQC","Card Settlement","QuasiCash ","Purchase of Goods which are equivalent to cash like coupons in casinos.",null,"Berlin Group","New","January 2010","January 2010"]
[6,"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","CR0170/Berlin Group","New","31 May 2012","31 May 2012"]
[7,"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.",null,"CR0153/Berlin Group","New","9 February 2012","9 February 2012"]
[8,"ACCT","Cash Mgmt","AccountManagement","Transaction moves funds between 2 accounts of same account holder at the same bank.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[9,"CASH","Cash Mgmt","CashManagementTransfer","Transaction is a general cash management instruction.",null,"Payments Harmonisation 2006 External Code List","Definition updated","April 2009","September 2007"]
[10,"COLL","Cash Mgmt","CollectionPayment","Transaction is a collection of funds initiated via a credit transfer or direct debit.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[11,"CSDB","Cash Mgmt","CashDisbursement","Transaction is related to cash disbursement.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[12,"DEPT","Cash Mgmt","Deposit","Transaction is releted to a payment of deposit.",null,"US NACHA/Susan Colles","New","April 2009","April 2009"]
[13,"INTC","Cash Mgmt","IntraCompanyPayment","Transaction is an intra-company payment, ie, a payment between two companies belonging to the same group.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[14,"LIMA","Cash Mgmt","LiquidityManagement","Bank initiated account transfer to support zero target balance management, pooling or sweeping.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[15,"NETT","Cash Mgmt","Netting","Transaction is related to a netting operation.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[16,"AGRT","Commercial","AgriculturalTransfer","Transaction is related to the agricultural domain.",null,"Payments Harmonisation 2006 External Code List","Definition updated","April 2009","September 2007"]
[17,"AREN","Commercial","Accounts Receivables Entry","Transaction is related to a payment associated with an Account Receivable Entry",null,"US NACHA/Susan Colles","New","April 2009","April 2009"]
[18,"BEXP","Commercial","BusinessExpenses","Transaction is related to a payment of business expenses.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[19,"BOCE","Commercial","Back Office Conversion Entry","Transaction is related to a payment associated with a Back Office Conversion Entry",null,"US NACHA/Susan Colles","New","April 2009","April 2009"]
[20,"COMC","Commercial","CommercialPayment","Transaction is related to a payment of commercial credit or debit. (formerly CommercialCredit)",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[21,"CPYR","Commercial","Copyright","Transaction is payment of copyright.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[22,"GDDS","Commercial","PurchaseSaleOfGoods","Transaction is related to purchase and sale of goods.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[23,"GDSV","Commercial","PurchaseSaleOfGoodsAndServices","Transaction is related to purchase and sale of goods and services.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[24,"GSCB","Commercial","PurchaseSaleOfGoodsAndServicesWithCashBack","Transaction is related to purchase and sale of goods and services with cash back.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[25,"LICF","Commercial","LicenseFee","Transaction is payment of a license fee.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[26,"POPE","Commercial","Point of Purchase Entry","Transaction is related to a payment associated with a Point of Purchase Entry.",null,"US NACHA/Susan Colles","New","April 2009","April 2009"]
[27,"ROYA","Commercial","Royalties","Transaction is the payment of royalties.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[28,"SCVE","Commercial","PurchaseSaleOfServices","Transaction is related to purchase and sale of services.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[29,"SUBS","Commercial","Subscription","Transaction is related to a payment of information or entertainment services either in printed or electronic form.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[30,"SUPP","Commercial","SupplierPayment","Transaction is related to a payment to a supplier.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[31,"TRAD","Commercial","TradeServices","Transaction is related to a trade services operation.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[32,"CHAR","Consumer","CharityPayment","Transaction is a payment for charity reasons.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[33,"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.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[34,"CLPR","Finance","CarLoanPrincipalRepayment","Transaction is a payment of car loan principal payment.",null,"Payments Harmonisation 2006 External Code List","Definition updated","April 2009","September 2007"]
[35,"DBTC","Finance","DebitCollectionPayment","Collection of funds initiated via a debit transfer.",null,"Initial Schema Internal Code List - September 2005","New","April 2009","April 2009"]
[36,"GOVI","Finance","GovernmentInsurance","Transaction is related to a payment of government insurance.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[37,"HLRP","Finance","HousingLoanRepayment","Transaction is related to a payment of housing loan.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[38,"INPC","Finance","InsurancePremiumCar","Transaction is a payment of car insurance premium.",null,"Initial Schema Internal Code List - September 2005","New","April 2009","April 2009"]
[39,"INSU","Finance","InsurancePremium","Transaction is payment of an insurance premium.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[40,"INTE","Finance","Interest","Transaction is payment of interest.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[41,"LBRI","Finance","LaborInsurance","Transaction is a payment of labor insurance.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[42,"LIFI","Finance","LifeInsurance","Transaction is a payment of life insurance.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[43,"LOAN","Finance","Loan","Transaction is related to transfer of loan to borrower.",null,"Payments Harmonisation 2006 External Code List","Definition updated","April 2009","September 2007"]
[44,"LOAR","Finance","LoanRepayment","Transaction is related to repayment of loan to lender.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[45,"PENO","Finance","PaymentBasedOnEnforcementOrder","Payment based on enforcement orders except those arising from judicial alimony decrees.",null,"CodeEval 2Q2012 (CR0244.The Bank Association of Slovenia)","New","16 July 2012","16 July 2012"]
[46,"PPTI","Finance","PropertyInsurance","Transaction is a payment of property insurance.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[47,"RINP","Finance","RecurringInstallmentPayment","Transaction is related to a payment of a recurring installment made at regular intervals.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[48,"TRFD","Finance","TrustFund","Transaction is related to a payment of a trust fund.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[49,"ADMG","General","AdministrativeManagement","Transaction is related to a payment associated with administrative management.",null,"CR0155/CGI Group","New","9 February 2012","9 February 2012"]
[50,"ADVA","General","AdvancePayment","Transaction is an advance payment.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[51,"BLDM","General","BuildingMaintenance","Transaction is related to a payment associated with building maintenance.",null,"CR0155/CGI Group","New","9 February 2012","9 February 2012"]
[52,"CBFF","General","CapitalBuilding","Transaction is related to capital building fringe fortune, ie capital building for retirement.",null,"Initial Schema Internal Code List - September 2005","New","April 2009","April 2009"]
[53,"CCRD ","General","CreditCardPayment ","Transaction is related to a payment of credit card account.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[54,"CDBL","General","CreditCardBill","Transaction is related to a payment of credit card bill.",null,"Initial Schema Internal Code List - September 2005","New","April 2009","April 2009"]
[55,"CFEE","General","CancellationFee","Transaction is related to a payment of cancellation fee.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[56,"COST","General","Costs","Transaction is related to payment of costs.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[57,"DCRD","General","Debit Card Payment","Transaction is related to a debit card payment.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[58,"FAND","General","FinancialAidInCaseOfNaturalDisaster","Financial aid by State authorities for abolition of consequences of natural disasters.",null,"CodeEval 2Q2012 (CR0244.The Bank Association of Slovenia)","New","16 July 2012","16 July 2012"]
[59,"GOVT","General","GovernmentPayment","Transaction is a payment to or from a government department.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[60,"ICCP","General","IrrevocableCreditCardPayment","Transaction is reimbursement of credit card payment.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[61,"IDCP","General","IrrevocableDebitCardPayment","Transaction is reimbursement of debit card payment.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[62,"IHRP","General","InstalmentHirePurchaseAgreement","Transaction is payment for an installment/hire-purchase agreement.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[63,"INSM","General","Installment","Transaction is related to a payment of an installment.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[64,"MSVC","General","MultipleServiceTypes","Transaction is related to a payment for multiple service types.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[65,"NOWS","General","NotOtherwiseSpecified","Transaction is related to a payment for type of services not specified elsewhere.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[66,"OFEE","General","OpeningFee","Transaction is related to a payment of opening fee.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[67,"OTHR","General","Other","Other payment purpose.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[68,"PADD","General","Preauthorized debit","Transaction is related to a pre-authorized debit origination",null,"Payments Harmonisation 2006 External Code List","Definition updated","April 2009","September 2007"]
[69,"PTSP","General","PaymentTerms","Transaction is related to payment terms specifications",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[70,"RCKE","General","Re-presented Check Entry","Transaction is related to a payment associated with a re-presented check entry",null,"US NACHA/Susan Colles","New","April 2009","April 2009"]
[71,"RCPT","General","ReceiptPayment","Transaction is related to a payment of receipt.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[72,"REFU","General","Refund","Transaction is the payment of a refund.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[73,"RENT","General","Rent","Transaction is the payment of rent.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[74,"STDY","General","Study","Transaction is related to a payment of study/tuition costs.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[75,"TELI","General","Telephone-Initiated Transaction","Transaction is related to a payment initiated via telephone.",null,"US NACHA/Susan Colles","New","April 2009","April 2009"]
[76,"WEBI","General","Internet-Initiated Transaction","Transaction is related to a payment initiated via internet.",null,"US NACHA/Susan Colles","New","April 2009","April 2009"]
[77,"ANNI","Investment","Annuity","Transaction settles annuity related to credit, insurance, investments, other.n",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[78,"CMDT","Investment","CommodityTransfer","Transaction is payment of commodities.",null,"Payments Harmonisation 2006 External Code List","Definition updated","April 2009","September 2007"]
[79,"DERI","Investment","Derivatives","Transaction is related to a derivatives transaction",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[80,"DIVD","Investment","Dividend","Transaction is payment of dividends.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[81,"FREX","Investment","ForeignExchange","Transaction is related to a foreign exchange operation.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[82,"HEDG","Investment","Hedging","Transaction is related to a hedging operation.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[83,"PRME","Investment","PreciousMetal","Transaction is related to a precious metal operation.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[84,"SAVG","Investment","Savings","Transfer to savings/retirement account.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[85,"SECU","Investment","Securities","Transaction is the payment of securities.",null,"Payments Harmonisation 2006 External Code List","Definition updated","April 2009","September 2007"]
[86,"TREA","Investment","TreasuryPayment","Transaction is related to treasury operations.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[87,"ANTS","Medical","AnesthesiaServices","Transaction is a payment for anesthesia services.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[88,"CVCF","Medical","ConvalescentCareFacility","Transaction is a payment for convalescence care facility services.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[89,"DMEQ","Medical","DurableMedicaleEquipment","Transaction is a payment is for use of durable medical equipment.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[90,"DNTS","Medical","DentalServices","Transaction is a payment for dental services.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[91,"HLTC","Medical","HomeHealthCare","Transaction is a payment for home health care services.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[92,"HLTI","Medical","HealthInsurance","Transaction is a payment of health insurance.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[93,"HSPC","Medical","HospitalCare","Transaction is a payment for hospital care services.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[94,"ICRF","Medical","IntermediateCareFacility","Transaction is a payment for intermediate care facility services.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[95,"LTCF","Medical","LongTermCareFacility","Transaction is a payment for long-term care facility services.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[96,"MDCS","Medical","MedicalServices","Transaction is a payment for medical care services.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[97,"VIEW","Medical","VisionCare","Transaction is a payment for vision care services.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[98,"ALMY","Salary & Benefits","AlimonyPayment","Transaction is the payment of alimony.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[99,"AEMP","Salary&Benefits","ActiveEmploymentPolicy","Payment concerning active employment policy.",null,"CodeEval 2Q2012 (CR0244.The Bank Association of Slovenia)","New","16 July 2012","16 July 2012"]
[100,"BECH","Salary & Benefits","ChildBenefit","Transaction is related to a payment made to assist parent/guardian to maintain child.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[101,"BENE","Salary & Benefits","UnemploymentDisabilityBenefit","Transaction is related to a payment to a person who is unemployed/disabled.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[102,"BONU","Salary & Benefits","BonusPayment.","Transaction is related to payment of a bonus.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[103,"COMM","Salary & Benefits","Commission","Transaction is payment of commission.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[104,"CSLP","Salary & Benefits","CompanySocialLoanPaymentToBank","Transaction is a payment by a company to a bank for financing social loans to employees.",null,"Initial Schema Internal Code List - September 2005","New","April 2009","April 2009"]
[105,"GFRP","Salary&Benefits","GuaranteeFundRightsPayment","Compensation to unemployed persons during insolvency procedures.",null,"CodeEval 2Q2012 (CR0244.The Bank Association of Slovenia)","New","16 July 2012","16 July 2012"]
[106,"GVEA","Salary & Benefits","Austrian Government Employees Category A","Transaction is payment to category A Austrian government employees.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[107,"GVEB","Salary & Benefits","Austrian Government Employees Category B","Transaction is payment to category B Austrian government employees.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[108,"GVEC","Salary & Benefits","Austrian Government Employees Category C","Transaction is payment to category C Austrian government employees.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[109,"GVED","Salary & Benefits","Austrian Government Employees Category D","Transaction is payment to category D Austrian government employees.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[110,"GWLT","Salary&Benefits","GovermentWarLegislationTransfer","Payment to victims of war violence and to disabled soldiers.",null,"CodeEval 2Q2012 (CR0244.The Bank Association of Slovenia)","New","16 July 2012","16 July 2012"]
[111,"PAYR","Salary & Benefits","Payroll","Transaction is related to the payment of payroll.",null,"Initial Schema Internal Code List - September 2005","New","April 2009","April 2009"]
[112,"PENS","Salary & Benefits","PensionPayment","Transaction is the payment of pension.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[113,"PRCP","Salary & Benefits","PricePayment","Transaction is related to a payment of a price.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[114,"RHBS","Salary&Benefits","RehabilitationSupport","Benefit for the duration of occupational rehabilitation.",null,"CodeEval 2Q2012 (CR0244.The Bank Association of Slovenia)","New","16 July 2012","16 July 2012"]
[115,"SALA","Salary & Benefits","SalaryPayment","Transaction is the payment of salaries.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[116,"SSBE","Salary & Benefits","SocialSecurityBenefit","Transaction is a social security benefit, ie payment made by a government to support individuals.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[117,"ESTX","Tax","EstateTax","Transaction is related to a payment of estate tax.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[118,"HSTX","Tax","HousingTax","Transaction is related to a payment of housing tax.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[119,"INTX","Tax","IncomeTax","Transaction is related to a payment of income tax.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[120,"NITX","Tax","NetIncomeTax","Transaction is related to a payment of net income tax.",null,"Initial Schema Internal Code List - September 2005","New","April 2009","April 2009"]
[121,"TAXS","Tax","TaxPayment","Transaction is the payment of taxes.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[122,"VATX","Tax","ValueAddedTaxPayment","Transaction is the payment of value added tax.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[123,"WHLD","Tax","WithHolding","Transaction is related to a payment of withholding tax.",null,"Initial Schema Internal Code List - September 2005","New","April 2009","April 2009"]
[124,"TAXR","Tax ","TaxRefund","Transaction is the refund of a tax payment or obligation.",null,"CR0155/CGI Group","New","9 February 2012","9 February 2012"]
[125,"AIRB","Transport","Air","Transaction is a payment for air transport related business.",null,"Payments Harmonisation 2006 External Code List","Definition updated","April 2009","April 2009"]
[126,"BUSB","Transport","Bus","Transaction is a payment for bus transport related business.",null,"Payments Harmonisation 2006 External Code List","Definition updated","April 2009","April 2009"]
[127,"FERB","Transport","Ferry","Transaction is a payment for ferry related business.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[128,"RLWY","Transport","Railway","Transaction is a payment for railway transport related business.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[129,"CBTV","Utilities","CableTVBill","Transaction is related to a payment of cable TV bill.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[130,"ELEC","Utilities","ElectricityBill","Transaction is related to a payment of electricity bill.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[131,"ENRG","Utilities","Energies","Transaction is related to a utility operation.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[132,"GASB","Utilities","GasBill","Transaction is related to a payment of gas bill.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[133,"NWCH","Utilities","NetworkCharge","Transaction is related to a payment of network charges.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[134,"NWCM","Utilities","NetworkCommunication","Transaction is related to a payment of network communication.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[135,"OTLC","Utilities","OtherTelecomRelatedBill","Transaction is related to a payment of other telecom related bill.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[136,"PHON","Utilities","TelephoneBill","Transaction is related to a payment of telephone bill.",null,"Payments Harmonisation 2006 External Code List","New","September 2007","September 2007"]
[137,"WTER","Utilities","WaterBill","Transaction is related to a payment of water bill.",null,"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":15,"n_rows":13,"n_cols":9,"rows_kept":13,"merged":[[2,0,2,3],[2,5,2,8]],"flags":["formulas_cached_only"]}
[]
["ExternalReportingSource1Code"]
["Identification",{"$nulls":3},"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":16,"n_rows":51,"n_cols":9,"rows_kept":51,"merged":[[2,0,2,3],[2,5,2,8]],"flags":["formulas_cached_only"]}
[]
["ExternalReturnReason1Code"]
["Identification",{"$nulls":3},"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,"AC04","ClosedAccountNumber","Account number specified has been closed on the bank of account's books",null,"Maintenance SR2009","New","April 2009","April 2009"]
[3,"AC06","BlockedAccount","Account specified is blocked, prohibiting posting of transactions against it.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[4,"AG01","TransactionForbidden","Transaction forbidden on this type of account (formerly NoAgreement)",null,"Maintenance SR2009","New","April 2009","April 2009"]
[5,"AG02","InvalidBankOperationCode","Bank Operation code specified in the message is not valid for receiver",null,"Maintenance SR2009","New","April 2009","April 2009"]
[6,"AM01","ZeroAmount","Specified message amount is equal to zero",null,"Maintenance SR2009","New","April 2009","April 2009"]
[7,"AM02","NotAllowedAmount","Specific transaction/message amount is greater than allowed maximum",null,"Maintenance SR2009","New","April 2009","April 2009"]
[8,"AM03","NotAllowedCurrency","Specified message amount is an non processable currency outside of existing agreement",null,"Maintenance SR2009","New","April 2009","April 2009"]
[9,"AM04","InsufficientFunds","Amount of funds available to cover specified message amount is insufficient.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[10,"AM05","Duplication","Duplication",null,"Maintenance SR2009","New","April 2009","April 2009"]
[11,"AM06","TooLowAmount","Specified transaction amount is less than agreed minimum.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[12,"AM07","BlockedAmount","Amount of funds available to cover specified message amount is insufficient.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[13,"AM09","WrongAmount","Amount received is not the amount agreed or expected",null,"Maintenance SR2009","New","April 2009","April 2009"]
[14,"AM10","InvalidControlSum","Sum of instructed amounts does not equal the control sum.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[15,"BE01","InconsistenWithEndCustomer","Identification of end customer is not consistent with associated account number (formerly CreditorConsistency).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[16,"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"]
[17,"BE05","UnrecognisedInitiatingParty","Party who initiated the message is not recognised by the end customer",null,"Maintenance SR2009","New","April 2009","April 2009"]
[18,"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"]
[19,"BE07","MissingDebtorAddress","Specification of debtor's address, which is required for payment, is missing/not correct.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[20,"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"]
[21,"CURR","IncorrectCurrency","Currency of the payment is incorrect",null,"Maintenance SR2009","New","April 2009","April 2009"]
[22,"CUST","RequestedByCustomer","Cancellation requested by the Debtor",null,"Maintenance SR2009","New","April 2009","April 2009"]
[23,"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"]
[24,"DT01","InvalidDate","Invalid date (eg, wrong settlement date)",null,"Maintenance SR2009","New","April 2009","April 2009"]
[25,"ED01","CorrespondentBankNotPossible","Correspondent bank not possible.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[26,"ED03","BalanceInfoRequest","Balance of payments complementary info is requested",null,"Maintenance SR2009","New","April 2009","April 2009"]
[27,"ED05","SettlementFailed","Settlement of the transaction has failed.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[28,"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"]
[29,"FOCR","FollowingCancellationRequest","Return following a cancellation request",null,"4Q2009 CR0006/EPC","New","January 2010","January 2010"]
[30,"MD01","NoMandate","No Mandate",null,"Maintenance SR2009","New","April 2009","April 2009"]
[31,"MD02","MissingMandatoryInformationIn Mandate","Mandate related information data required by the scheme is missing.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[32,"MD06","RefundRequestByEndCustomer","Return of funds requested by end customer",null,"Maintenance SR2009","New","April 2009","April 2009"]
[33,"MD07","EndCustomerDeceased","End customer is deceased.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[34,"MS02","NotSpecifiedReasonCustomer Generated","Reason has not been specified by end customer",null,"Maintenance SR2009","New","April 2009","April 2009"]
[35,"MS03","NotSpecifiedReasonAgent     Generated","Reason has not been specified by agent.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[36,"NARR","Narrative","Reason is provided as narrative information in the additional reason information.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[37,"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"]
[38,"RC01","BankIdentifierIncorrect","Bank Identifier coe specified in the message has an incorrect format (formerly IncorrectFormatForRoutingCode).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[39,"RF01","NotUniqueTransactionReference","Transaction reference is not unique within the message.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[40,"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"]
[41,"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"]
[42,"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"]
[43,"RR04","Regulatory Reason ","Regulatory Reason",null,"Maintenance SR2009","New","April 2009","April 2009"]
[44,"SL01","Specific Service offered by Debtor Agent","Due to specific service offered by the Debtor Agent",null,"Maintenance SR2009","New","April 2009","April 2009"]
[45,"SL02","Specific Service offered by Creditor Agent","Due to specific service offered by the Creditor Agent",null,"Maintenance SR2009","New","April 2009","April 2009"]
[46,"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"]
[47,"TM01","CutOffTime","Associated message was received after agreed processing cut-off time.",null,"Maintenance SR2009","New","April 2009","April 2009"]

{"sheet":"14-ReversalReason ","index":17,"n_rows":12,"n_cols":9,"rows_kept":12,"merged":[[2,0,2,3],[2,5,2,8]],"flags":["formulas_cached_only"]}
[]
["ExternalReversalReason1Code"]
["Identification",{"$nulls":3},"Information/Details","Status"]
[null,"\nCode","\nName","\nDefinition",null,"Origin/Requester","Status","Status Date","Introduced Date"]
[1,"AC04","ClosedAccountNumber","Account number specified has been closed on the Receiver's books",null,"Maintenance SR2009","New","April 2009","April 2009"]
[2,"AG02","InvalidBankOperationCode","Bank Operation code specified in the message is not valid for receiver",null,"Maintenance SR2009","New","April 2009","April 2009"]
[3,"AM05","Duplication","Duplication",null,"Maintenance SR2009","New","April 2009","April 2009"]
[4,"MD01","NoMandate","No Mandate",null,"Maintenance SR2009","New","April 2009","April 2009"]
[5,"MD05","CollectionNotDue","Creditor or creditor's agent should not have collected the direct debit",null,"Maintenance SR2009","New","April 2009","April 2009"]
[6,"MS02","NotSpecifiedReasonCustomerGenerated","Reason has not been specified by end customer",null,"Maintenance SR2009","New","April 2009","April 2009"]
[7,"MS03","NotSpecifiedReasonAgentGenerated","Reason has not been specified by agent.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[8,"TM01","CutOffTime","Associated message was received after agreed processing cut-off time.",null,"Maintenance SR2009","New","April 2009","April 2009"]

{"sheet":"15-ServiceLevel","index":18,"n_rows":12,"n_cols":9,"rows_kept":12,"merged":[[2,0,2,3],[2,5,2,8]],"flags":["formulas_cached_only"]}
[]
["ExternalServiceLevel1Code"]
["Identification",{"$nulls":3},"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,"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"]
[8,"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":19,"n_rows":175,"n_cols":9,"rows_kept":175,"merged":[[1,0,1,8],[2,0,2,3],[2,5,2,8]],"flags":["formulas_cached_only"]}
[]
["ExternalStatusReason1Code"]
["Identification",{"$nulls":3},"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,"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"]
[65,"CURR","IncorrectCurrency","Currency of the payment is incorrect",null,"Maintenance SR2009","New","April 2009","April 2009"]
[66,"CUST","RequestedByCustomer","Cancellation requested by the Debtor",null,"Maintenance SR2009","New","April 2009","April 2009"]
[67,"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"]
[68,"DS01","ElectronicSignaturesCorrect","The electronic signature(s) is/are correct",null,"CodeEval 1Q2011 (CR0059/EBICS)","New","14 Feb 2011","14 Feb 2011"]
[69,"DS02","OrderCancelled","An authorized user has cancelled the order",null,"CodeEval 1Q2011 (CR0059/EBICS)","New","14 Feb 2011","14 Feb 2011"]
[70,"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"]
[71,"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"]
[72,"DS05","OrderForwardedForPostprocessing","The order was correct and could be forwarded for postprocessing",null,"CodeEval 1Q2011 (CR0059/EBICS)","New","14 Feb 2011","14 Feb 2011"]
[73,"DS06","TransferOrder","The order was transferred to VEU",null,"CodeEval 1Q2011 (CR0059/EBICS)","New","14 Feb 2011","14 Feb 2011"]
[74,"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"]
[75,"DS08","DecompressionError","The decompression of the file was not successful",null,"CodeEval 1Q2011 (CR0059/EBICS)","New","14 Feb 2011","14 Feb 2011"]
[76,"DS09","DecryptionError","The decryption of the file was not successful",null,"CodeEval 1Q2011 (CR0059/EBICS)","New","14 Feb 2011","14 Feb 2011"]
[77,"DS0A","DataSignRequested","Data signature is required.",null,"France/Stella Petiot & Isabelle DeMendonca","New","April 2009","April 2009"]
[78,"DS0B","UnknownDataSignFormat","Data signature for the format is not available or invalid.",null,"France/Stella Petiot & Isabelle DeMendonca","New","April 2009","April 2009"]
[79,"DS0C","SignerCertificateRevoked","The signer certificate is revoked.",null,"France/Stella Petiot & Isabelle DeMendonca","New","April 2009","April 2009"]
[80,"DS0D","SignerCertificateNotValid","The signer certificate is not valid (revoked or not active).",null,"France/Stella Petiot & Isabelle DeMendonca","New","April 2009","April 2009"]
[81,"DS0E","IncorrectSignerCertificate","The signer certificate is not present.",null,"France/Stella Petiot & Isabelle DeMendonca","New","April 2009","April 2009"]
[82,"DS0F","SignerCertificationAuthoritySignerNotValid","The authority of the signer certification sending the certificate is unknown.",null,"France/Stella Petiot & Isabelle DeMendonca","New","April 2009","April 2009"]
[83,"DS0G","NotAllowedPayment","Signer is not allowed to sign this operation type.",null,"France/Stella Petiot & Isabelle DeMendonca","New","April 2009","April 2009"]
[84,"DS0H","NotAllowedAccount","Signer is not allowed to sign for this account.",null,"France/Stella Petiot & Isabelle DeMendonca","New","April 2009","April 2009"]
[85,"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"]
[86,"DS10","Signer1CertificateRevoked","The certificate is revoked for the first signer.",null,"France/Stella Petiot & Isabelle DeMendonca","New","April 2009","April 2009"]
[87,"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"]
[88,"DS12","IncorrectSigner1Certificate","The certificate is not present for the first signer.",null,"France/Stella Petiot & Isabelle DeMendonca","New","April 2009","April 2009"]
[89,"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"]
[90,"DS14","UserDoesNotExist","The user is unknown on the server",null,"CodeEval 1Q2011 (CR0059/EBICS)","New","14 Feb 2011","14 Feb 2011"]
[91,"DS15","IdenticalSignatureFound","The same signature has already been sent to the bank",null,"CodeEval 1Q2011 (CR0059/EBICS)","New","14 Feb 2011","14 Feb 2011"]
[92,"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"]
[93,"DS17","DifferentOrderDataInSignatures","Order data and signatures don’t match",null,"CodeEval 1Q2011 (CR0059/EBICS)","New","14 Feb 2011","14 Feb 2011"]
[94,"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"]
[95,"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"]
[96,"DS20","Signer2CertificateRevoked","The certificate is revoked for the second signer.",null,"France/Stella Petiot & Isabelle DeMendonca","New","April 2009","April 2009"]
[97,"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"]
[98,"DS22","IncorrectSigner2Certificate","The certificate is not present for the second signer.",null,"France/Stella Petiot & Isabelle DeMendonca","New","April 2009","April 2009"]
[99,"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"]
[100,"DS24","WaitingTimeExpired","Waiting time expired due to incomplete order",null,"CodeEval 1Q2011 (CR0059/EBICS)","New","14 Feb 2011","14 Feb 2011"]
[101,"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"]
[102,"DS26","UserSignedMultipleTimes","The same user has signed multiple times",null,"CodeEval 1Q2011 (CR0059/EBICS)","New","14 Feb 2011","14 Feb 2011"]
[103,"DS27","UserNotYetActivated","The user is not yet activated (technically)",null,"CodeEval 1Q2011 (CR0059/EBICS)","New","14 Feb 2011","14 Feb 2011"]
[104,"DT01","InvalidDate","Invalid date (eg, wrong or missing settlement date)",null,"Maintenance SR2009","Definition updated (CR0010)","August 2010","April 2009"]
[105,"DT02","InvalidCreationDate","Invalid creation date and time in Group Header (eg, historic date)",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[106,"DT03","InvalidNonProcessingDate","Invalid non bank processing date (eg, weekend or local public holiday)",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[107,"DT04","FutureDateNotSupported","Future date not supported",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[108,"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"]
[109,"DT06","ExecutionDateChanged","Execution Date has been modified in order for transaction to be processed",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[110,"DU01","DuplicateMessageID","Message Identification is not unique.",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[111,"DU02","DuplicatePaymentInformationID","Payment Information Block is not unique.",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[112,"DU03","DuplicateTransaction","Transaction is not unique.",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[113,"DU04","DuplicateEndToEndID","End To End ID is not unique.",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[114,"DU05","DuplicateInstructionID","Instruction ID is not unique.",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[115,"DUPL","DuplicatePayment","Payment is a duplicate of another payment",null,"Maintenance SR2009","New","April 2009","April 2009"]
[116,"ED01","CorrespondentBankNotPossible","Correspondent bank not possible.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[117,"ED03","BalanceInfoRequest","Balance of payments complementary info is requested",null,"Maintenance SR2009","New","April 2009","April 2009"]
[118,"ED05","SettlementFailed","Settlement of the transaction has failed.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[119,"FF01","Invalid File Format","File Format incomplete or invalid",null,"Maintenance SR2009","New","April 2009","April 2009"]
[120,"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"]
[121,"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"]
[122,"FF04","InvalidServiceLevelCode","Service Level code is missing or invalid",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[123,"FF05","InvalidLocalInstrumentCode","Local Instrument code is missing or invalid",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[124,"FF06","InvalidCategoryPurposeCode","Category Purpose code is missing or invalid",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[125,"FF07","InvalidPurpose","Purpose is missing or invalid",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[126,"FF08","InvalidEndToEndId","End to End Id missing or invalid",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[127,"FF09","InvalidChequeNumber","Cheque number missing or invalid",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[128,"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"]
[129,"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"]
[130,"MD01","NoMandate","No Mandate",null,"Maintenance SR2009","New","April 2009","April 2009"]
[131,"MD02","MissingMandatoryInformationIn Mandate","Mandate related information data required by the scheme is missing.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[132,"MD05","CollectionNotDue","Creditor or creditor's agent should not have collected the direct debit",null,"Maintenance SR2009","New","April 2009","April 2009"]
[133,"MD06","RefundRequestByEndCustomer","Return of funds requested by end customer",null,"Maintenance SR2009","New","April 2009","April 2009"]
[134,"MD07","EndCustomerDeceased","End customer is deceased.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[135,"MS02","NotSpecifiedReasonCustomer Generated","Reason has not been specified by end customer",null,"Maintenance SR2009","New","April 2009","April 2009"]
[136,"MS03","NotSpecifiedReasonAgent  Generated","Reason has not been specified by agent.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[137,"NARR","Narrative","Reason is provided as narrative information in the additional reason information.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[138,"RC01","BankIdentifierIncorrect","Bank identifier code specified in the message has an incorrect format (formerly IncorrectFormatForRoutingCode).",null,"Maintenance SR2009","New","April 2009","April 2009"]
[139,"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"]
[140,"RC03","InvalidDebtorBankIdentifier","Debtor bank identifier is invalid or missing",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[141,"RC04","InvalidCreditorBankIdentifier","Creditor bank identifier is invalid or missing",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[142,"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"]
[143,"RC06","InvalidDebtorBICIdentifier","Debtor BIC identifier is invalid or missing",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[144,"RC07","InvalidCreditorBICIdentifier","Creditor BIC identifier is invalid or missing",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[145,"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"]
[146,"RC09","InvalidDebtorClearingSystemMemberIdentifier","Debtor ClearingSystemMember identifier is invalid or missing",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[147,"RC10","InvalidCreditorClearingSystemMemberIdentifier","Creditor ClearingSystemMember identifier is invalid or missing",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[148,"RC11","InvalidIntermediaryAgent","Intermediary Agent is invalid or missing",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[149,"RC12","MissingCreditorSchemeId","Creditor Scheme Id is invalid or  missing",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[150,"RF01","NotUniqueTransactionReference","Transaction reference is not unique within the message.",null,"Maintenance SR2009","New","April 2009","April 2009"]
[151,"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"]
[152,"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"]
[153,"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"]
[154,"RR04","RegulatoryReason ","Regulatory Reason",null,"Maintenance SR2009","New","April 2009","April 2009"]
[155,"RR05","RegulatoryInformationInvalid","Regulatory or Central Bank Reporting information missing, incomplete or invalid.",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[156,"RR06","TaxInformationInvalid","Tax information missing, incomplete or invalid.",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[157,"RR07","RemittanceInformationInvalid","Remittance information structure does not comply with rules for payment type.",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[158,"RR08","RemittanceInformationTruncated","Remittance information truncated to comply with rules for payment type.",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[159,"RR09","InvalidStructuredCreditorReference","Structured creditor reference invalid or missing.",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[160,"RR10","InvalidCharacterSet","Character set supplied not valid for the country and payment type.",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[161,"RR11","InvalidDebtorAgentServiceID","Invalid or missing identification of a bank proprietary service.",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[162,"RR12","InvalidPartyID","Invalid or missing identification required within a particular country or payment type.",null,"CodeEval 1Q2010 (CR0010/CGI)","New","August 2010","August 2010"]
[163,"SL01","Specific Service offered by Debtor Agent","Due to specific service offered by the Debtor Agent",null,"Maintenance SR2009","New","April 2009","April 2009"]
[164,"SL02","Specific Service offered by Creditor Agent","Due to specific service offered by the Creditor Agent",null,"Maintenance SR2009","New","April 2009","April 2009"]
[165,"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"]
[166,"TD01","NoDataAvailable","There is no data available (for download)",null,"CodeEval 1Q2011 (CR0059/EBICS)","New","14 Feb 2011","14 Feb 2011"]
[167,"TD02","FileNonReadable","The file cannot be read (e.g. unknown format)",null,"CodeEval 1Q2011 (CR0059/EBICS)","New","14 Feb 2011","14 Feb 2011"]
[168,"TD03","IncorrectFileStructure","The file format is incomplete or invalid",null,"CodeEval 1Q2011 (CR0059/EBICS)","New","14 Feb 2011","14 Feb 2011"]
[169,"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"]
[170,"TS01","TransmissionSuccessful","The (technical) transmission of the file was successful.",null,"CodeEval 1Q2011 (CR0059/EBICS)","New","14 Feb 2011","14 Feb 2011"]
[171,"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":20,"n_rows":8,"n_cols":8,"rows_kept":8,"merged":[[2,0,2,3],[2,4,2,7]],"flags":["formulas_cached_only"]}
[]
["ExternalTechnicalInputChannel1Code"]
["Identification",{"$nulls":3},"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":21,"n_rows":22,"n_cols":9,"rows_kept":22,"merged":[[2,0,2,3],[2,5,2,8]],"flags":["formulas_cached_only"]}
[]
["ExternalVerificationReason1Code"]
["Identification",{"$nulls":3},"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":22,"n_rows":6,"n_cols":9,"rows_kept":6,"merged":[[2,0,2,3],[2,5,2,8]],"flags":["formulas_cached_only"]}
[]
["ExternalDocumentPurpose1Code"]
["Identification",{"$nulls":3},"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":23,"n_rows":21,"n_cols":9,"rows_kept":21,"merged":[[2,0,2,3],[2,5,2,8]],"flags":["formulas_cached_only"]}
[]
["ExternalDocumentType1Code"]
["Identification",{"$nulls":3},"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":24,"n_rows":15,"n_cols":9,"rows_kept":15,"merged":[[2,0,2,3],[2,5,2,8]],"flags":["formulas_cached_only"]}
[]
["ExternalIncoterms1Code"]
["Identification",{"$nulls":3},"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)",null,"FinancialInvoiceV01 Trade Services SEG","New","2010-11-30","2010-11-30"]
[2,"CIF","CostInsuranceAndFreight","Cost, Insurance and Freight (sea and inland waterway transport)",null,"FinancialInvoiceV01 Trade Services SEG","New","2010-11-30","2010-11-30"]
[3,"CIP","CarriageAndInsurancePaid","Carriage and Insurance Paid To (any mode of transport, including multimodal)",null,"FinancialInvoiceV01 Trade Services SEG","New","2010-11-30","2010-11-30"]
[4,"CPT","CarriagePaid","Carriage Paid To (any mode of transport, including multimodal)",null,"FinancialInvoiceV01 Trade Services SEG","New","2010-11-30","2010-11-30"]
[5,"DAP","DeliveredAtPlace","Delivered at Place (any mode of transport, including multimodal)",null,"FinancialInvoiceV01 Trade Services SEG","New","2010-11-30","2010-11-30"]
[6,"DAT","DeliveredAtTerminal","Delivered at Terminal (any mode of transport, including multimodal)",null,"FinancialInvoiceV01 Trade Services SEG","New","2010-11-30","2010-11-30"]
[7,"DDP","DeliveredDutyPaid","Delivered Duty Paid (any mode of transport, including multimodal)",null,"FinancialInvoiceV01 Trade Services SEG","New","2010-11-30","2010-11-30"]
[8,"EXW","ExWorks","Ex Works (any mode of transport, including multimodal)",null,"FinancialInvoiceV01 Trade Services SEG","New","2010-11-30","2010-11-30"]
[9,"FAS","FreeAlongsideShip","Free Alongside Ship (sea and inland waterway transport)",null,"FinancialInvoiceV01 Trade Services SEG","New","2010-11-30","2010-11-30"]
[10,"FCA","FreeCarrier","Free Carrier (any mode of transport, including multimodal)",null,"FinancialInvoiceV01 Trade Services SEG","New","2010-11-30","2010-11-30"]
[11,"FOB","FreeOnBoard","Free On Board (sea and inland waterway transport)",null,"FinancialInvoice Trade Services SEG","New","2010-11-30","2010-11-30"]

{"sheet":"22-InformationType","index":25,"n_rows":10,"n_cols":9,"rows_kept":10,"merged":[[2,0,2,3],[2,5,2,8]],"flags":["formulas_cached_only"]}
[]
["ExternalInformationType1Code"]
["Identification",{"$nulls":3},"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":26,"n_rows":8,"n_cols":9,"rows_kept":8,"merged":[[2,0,2,3],[2,5,2,8]],"flags":["formulas_cached_only"]}
[]
["ExternalPackagingType1Code"]
["Identification",{"$nulls":3},"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":27,"n_rows":23,"n_cols":9,"rows_kept":23,"merged":[[2,0,2,3],[2,5,2,8]],"flags":["formulas_cached_only"]}
[]
["ExternalFinancialInstrumentIdentificationType1Code"]
["Identification",{"$nulls":3},"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":28,"n_rows":51,"n_cols":9,"rows_kept":51,"merged":[[2,0,2,3],[2,5,2,8]],"flags":["formulas_cached_only"]}
[]
["ExternalTradeTransactionCondition1Code"]
["Identification",{"$nulls":3},"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":29,"n_rows":8,"n_cols":9,"rows_kept":8,"merged":[[2,0,2,3],[2,5,2,8]],"flags":["formulas_cached_only"]}
[]
["ExternalChargeType1Code"]
["Identification",{"$nulls":3},"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":30,"n_rows":22,"n_cols":9,"rows_kept":22,"merged":[[2,0,2,3],[2,5,2,8]],"flags":["formulas_cached_only"]}
[]
["ExternalCashAccountType1Code"]
["Identification",{"$nulls":3},"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":31,"n_rows":7,"n_cols":9,"rows_kept":7,"merged":[[2,0,2,3],[2,5,2,8]],"flags":["formulas_cached_only"]}
[]
["ExternalDiscountAmountType1Code"]
["Identification",{"$nulls":3},"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 2012","New","16 July 2012","16 July 2012"]
[2,"STDS","StandingDiscount","Discount based on volume purchased.",null,"Maintenance 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 2012","New","16 July 2012","16 July 2012"]

{"sheet":"29-TaxAmountType","index":32,"n_rows":9,"n_cols":9,"rows_kept":9,"merged":[[2,0,2,3],[2,5,2,8]],"flags":["formulas_cached_only"]}
[]
["ExternalTaxAmountType1Code"]
["Identification",{"$nulls":3},"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 2012","New","16 July 2012","16 July 2012"]
[2,"CNTY","CountyTax","Tax accessed by county jurisdications within a country.",null,"Maintenance 2012","New","16 July 2012","16 July 2012"]
[3,"LOCL","LocalTax","Tax accessed by local jurisdications within a country.",null,"Maintenance 2012","New","16 July 2012","16 July 2012"]
[4,"PROV","ProvinceTax","Tax accessed by province jurisdications within a country.",null,"Maintenance 2012","New","16 July 2012","16 July 2012"]
[5,"STAT","StateTax","Tax accessed by state jurisdications within a country.",null,"Maintenance 2012","New","16 July 2012","16 July 2012"]