{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["Information","DebiCheck Bulk File Generator","Tracking Codes","Change Types","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":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Merchant"]
[]
[]
[]
[]
[]
[]
[{"$nulls":6},"Click on field heading for more information"]
[]
["mandateID","accessID","instalment","submitDate","amount","trackingIndicator","changeType"]
["Fill in Data"]

{"sheet":"Tracking Codes","index":2,"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":"Change Types","index":3,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["CHANGE TYPE"]
["Code","Description","Fields required"]
["IR","Recall Instalment","Mandate ID, Card Acceptor, Instalment Number, Change Type"]
["IA","Add Instalment","Mandate ID, Card Acceptor, Instalment Number, Change Type"]
["IM","Instalment Maintenance","Mandate ID, Card Acceptor, Instalment Number, Change Type (dependant on change required: Submit Date / Instalment Amount / Tracking Indicator)"]
["IC","Instalment Cancellation","Mandate ID, Card Acceptor, Instalment Number, Change Type"]
["RM","Reschedule Instalment","Mandate ID, Card Acceptor, Instalment Number, Submit Date, Amount, Tracking Indicator, Change Type"]

{"sheet":"Sheet2","index":4,"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"]