{"text_format":"2","workbook":"xlsx","n_sheets":7,"sheets":["Information","DebiCheck Bulk File Generator","Debtor Bank ID","Frequency&Collection Day Table","Tracking Codes","Entry Class ","Sheet2"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Information","index":0,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[[1,0,1,7],[2,0,1048575,7],[0,0,0,7]]}
["Information"]
["Please click on the header of a column for more information regarding the fields"]
["Please save this document in \"My Documents\" before trying to use the tool"]

{"sheet":"DebiCheck Bulk File Generator","index":1,"n_rows":12,"n_cols":21,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Merchant"]
[]
[]
[]
[]
[]
[{"$nulls":9},"Click on field heading for more information"]
[]
["cardAcceptor","debtorAccountNumber","debtorBranchNumber","debtorBankId","debtorName","debtorAccountType","debtorAuthenticationRequired","authenticationType","startDate","instalmentAmount","maxCollectionAmount","frequency","collectionDay","debitValueTypeId","instalments","entryClass","dateAdjustmentRule","debtorIdType","debtorId","clientReference","trackingIndicator"]
["Fill in Data"]

{"sheet":"Debtor Bank ID","index":2,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Financial Institution ID"]
["Code","Bank","Universal Branch Code"]
["1","SBSA","051001"]
["2","Nedbank","198765"]
["3","FNB","250655"]
["6","GroBank (BOA)","410506"]
["7","African Bank","450905"]
["9","Mercantile","450105"]
["10","Capitec","470010"]
["16","ABSA","632005"]
["19","Ubank","431010"]
[44,"Bidvest","462005"]
[55,"Finbond","589000"]
["61","Tyme Bank ","678910"]

{"sheet":"Frequency&Collection Day Table","index":3,"n_rows":34,"n_cols":12,"rows_kept":34,"cut":false,"hidden":false,"merged":[[25,5,33,10],[17,7,24,10],[1,7,16,7],[1,10,16,10],[19,11,19,12],[20,11,20,12],[33,11,33,12],[32,11,32,12],[15,11,15,12],[11,11,11,12],[12,11,12,12],[13,11,13,12],[14,11,14,12],[16,11,16,12],[17,11,17,12],[18,11,18,12],[0,0,0,1],[2,5,2,6],[2,8,2,9],[10,5,10,6],[1,11,2,12],[3,11,3,12],[0,5,0,12],[4,11,4,12],[5,11,5,12],[6,11,6,12],[7,11,7,12],[8,11,8,12],[9,11,9,12],[10,11,10,12],[27,11,27,12],[21,11,21,12],[30,11,30,12],[31,11,31,12],[22,11,22,12],[23,11,23,12],[24,11,24,12],[25,11,25,12],[26,11,26,12],[28,11,28,12],[29,11,29,12]]}
["Frequency",{"$nulls":4},"Collection Day"]
["Code","Description",null,null,null,"Code","Description",null,"Code","Description",null,"Monthly (MNTH) ; Quarterly (QURT)\nAnnually (YEAR) ; Bi-Annually (MIAN)"]
["WEEK","Weekly",null,null,null,"Weekly (WEEK)",null,null,"Monthly by Rule (ADHO)"]
["MNTH","Monthly",null,null,null,"01","Monday",null,"01","Last Monday",null,1]
["QURT","Quarterly",null,null,null,"02","Tuesday",null,"02","Last Tuesday",null,2]
["YEAR","Annually",null,null,null,"03","Wednesday",null,"03","Last Wednesday",null,3]
["MIAN","BiAnnually",null,null,null,"04","Thursday",null,"04","Last Thursday",null,4]
["FRTN","Fortnightly",null,null,null,"05","Friday",null,"05","Last Friday",null,5]
["ADHO","MonthlyByRule",null,null,null,"06","Saturday",null,"06","Last Saturday",null,6]
[{"$nulls":5},"07","Sunday",null,"07","First Monday",null,7]
[{"$nulls":5},"Fortnightly (FRTN)",null,null,"08","First Tuesday",null,8]
[{"$nulls":5},"01","1st Monday",null,"09","First Wednesday",null,9]
[{"$nulls":5},"02","1stTuesday",null,10,"First Thursday",null,10]
[{"$nulls":5},"03","1st Wednesday",null,11,"First Friday",null,11]
[{"$nulls":5},"04","1st Thursday",null,12,"First Saturday",null,12]
[{"$nulls":5},"05","1st Friday",null,14,"2nd Last Day",null,13]
[{"$nulls":5},"06","1st Saturday",null,99,"Last Day",null,14]
[{"$nulls":5},"07","1st Sunday",{"$nulls":4},15]
[{"$nulls":5},"08","2nd Monday",{"$nulls":4},16]
[{"$nulls":5},"09","2nd Tuesday",{"$nulls":4},17]
[{"$nulls":5},10,"2nd Wednesday",{"$nulls":4},18]
[{"$nulls":5},11,"2nd Thursday",{"$nulls":4},19]
[{"$nulls":5},12,"2nd Friday",{"$nulls":4},20]
[{"$nulls":5},13,"2nd Saturday",{"$nulls":4},21]
[{"$nulls":5},14,"2nd Sunday",{"$nulls":4},22]
[{"$nulls":11},23]
[{"$nulls":11},24]
[{"$nulls":11},25]
[{"$nulls":11},26]
[{"$nulls":11},27]
[{"$nulls":11},28]
[{"$nulls":11},29]
[{"$nulls":11},30]
[{"$nulls":11},"99 (Last Day)"]

{"sheet":"Tracking Codes","index":4,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["TRACKING"]
["Code","Description"]
["01","1 Days Tracking"]
["02","2 Days Tracking"]
["03","3 Days Tracking"]
["04","4 Days Tracking"]
["05","5 Days Tracking"]
["06","6 Days Tracking"]
["07","7 Days Tracking"]
["08","8 Days Tracking"]
["09","9 Days Tracking"]
["10","10 Days Tracking"]
["99","Default Tracking (only for merchants opted in)"]

{"sheet":"Entry Class ","index":5,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Entry Class Codes","Description"]
["0021","Insurance Premium"]
["0022","Pension Fund Contribution"]
["0023","Medical Aid Fund Contribution"]
["0026","Unit Trust Purchase"]
["0028","Charitable or religious contributions"]
["0031","H.P. Repayment"]
["0032","Account Repayment"]
["0033","Loan Repayment (other than Mortgage)"]
["0034","Rental-Lease (other than Property)"]
["0035","Service Charge (Maintenance of Service Agreements, etc.)"]
["0036","Service Charge (Variable Amounts)"]
["0037","Value Added Tax (Vat collection)"]
["0041","Rent (Property)"]
["0042","Bond Repayment"]
["0044","Bank Use - Debit Transfer"]
["0046","Bank use – Cheque Card Debits"]

{"sheet":"Sheet2","index":6,"n_rows":31,"n_cols":26,"rows_kept":31,"cut":false,"hidden":true,"merged":[[0,0,0,1],[15,5,15,6],[15,8,15,9]]}
["ID Type",{"$nulls":6},"Frequency",null,"Weekly","Monday","Fortnightly","01 Monday","Monthly",1,"Quarterly",1,"Bi-Annually",1,"Annually",1,"Monthly by Rule","01 Last Monday",null,"N","Never"]
["ID Document",{"$nulls":6},"Weekly",null,null,"Tuesday",null,"02 Tuesday",null,2,null,2,null,2,null,2,null,"02 Last Tuesday",null,"Q","Quarterly"]
["Passport",{"$nulls":6},"Monthly",null,null,"Wednesday",null,"03 Wednesday",null,3,null,3,null,3,null,3,null,"03 Last Wednesday",null,"A","Annually"]
["Temporary Residence ID",{"$nulls":6},"Quarterly",null,null,"Thursday",null,"04 Thursday",null,4,null,4,null,4,null,4,null,"04 Last Thursday",null,"B","BiAnnually"]
[{"$nulls":7},"Annually",null,null,"Friday",null,"05 Friday",null,5,null,5,null,5,null,5,null,"05 Last Friday",null,"R","Repo"]
["Account Type",{"$nulls":6},"BiAnnually",null,null,"Saturday",null,"06 Saturday",null,6,null,6,null,6,null,6,null,"06 Last Saturday"]
["Current",{"$nulls":6},"Fortnightly",null,null,"Sunday",null,"07 Sunday",null,7,null,7,null,7,null,7,null,"07 First Monday",null,1.5]
["Savings",{"$nulls":6},"MonthlyByRule",{"$nulls":4},"08 Monday",null,8,null,8,null,8,null,8,null,"08 First Tuesday"]
["Transmission",{"$nulls":11},"09 Tuesday",null,9,null,9,null,9,null,9,null,"09 First Wednesday"]
[{"$nulls":12},"10 Wednesday",null,10,null,10,null,10,null,10,null,"10 First Thursday"]
["Debit Value Type",{"$nulls":11},"11 Thursday",null,11,null,11,null,11,null,11,null,"11 First Friday"]
["FIXED",{"$nulls":11},"12 Friday",null,12,null,12,null,12,null,12,null,"12 First Saturday"]
["VARIABLE",{"$nulls":11},"13 Saturday",null,13,null,13,null,13,null,13,null,"14 2nd Last Day"]
["USAGE BASED",{"$nulls":11},"14 Sunday",null,14,null,14,null,14,null,14,null,"99 Last Day"]
[{"$nulls":14},15,null,15,null,15,null,15]
[{"$nulls":5},"Frequency",null,null,"Frequency",{"$nulls":5},16,null,16,null,16,null,16]
["Adjustment Category",{"$nulls":4},"Code","Description",null,"Code","Description",{"$nulls":4},17,null,17,null,17,null,17]
["Annually",{"$nulls":4},"01","Weekly",null,"01","Weekly",{"$nulls":4},18,null,18,null,18,null,18]
["Bi-Annually",{"$nulls":4},"02","Monthly",null,"02","Monthly",{"$nulls":4},19,null,19,null,19,null,19]
["Never",{"$nulls":4},"03","Quarterly",null,"03","Quarterly",{"$nulls":4},20,null,20,null,20,null,20,null,{"$f":"U19*1.5","v":28.5}]
["Quarterly",{"$nulls":4},"04","Annually",null,"04","Annually",{"$nulls":4},21,null,21,null,21,null,21]
["Repo",{"$nulls":4},"05","BiAnnually",null,"05","BiAnnually",{"$nulls":4},22,null,22,null,22,null,22]
[{"$nulls":5},"06","Fortnightly",null,"06","Fortnightly",{"$nulls":4},23,null,23,null,23,null,23]
["Instalment Occurrence",{"$nulls":4},"07","MonthlyByRule",null,"07","MonthlyByRule",{"$nulls":4},24,null,24,null,24,null,24]
["Once-Off",{"$nulls":13},25,null,25,null,25,null,25]
["Recurring",{"$nulls":13},26,null,26,null,26,null,26]
[{"$nulls":14},27,null,27,null,27,null,27]
[{"$nulls":14},28,null,28,null,28,null,28]
[{"$nulls":14},29,null,29,null,29,null,29]
[{"$nulls":14},30,null,30,null,30,null,30]
[{"$nulls":14},"Last Day",null,"Last Day",null,"Last Day",null,"Last Day"]