{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["FORM","Enclosed attachments","CONTROL","DATA"],"not_rendered":{"images":4,"macros":1,"defined_names":24},"read":"whole","date_system":"1900"}

{"sheet":"FORM","index":0,"n_rows":445,"n_cols":32,"rows_kept":445}
[{"$nulls":5},"Updated 2018-11-15","Company Code","DK12",null,"THTR98","Document Currency","DKK",{"$nulls":3},"Currency Rate:",null," "]
["GL Document, Global Journal Voucher Template",{"$nulls":4},"Version: 1.54","Document Date",null,"Posting Date",null,"Document Type","SB",{"$nulls":4}," "," "]
["Document Text",null,null,{"$f":"\"Doc text length is \" & LEN(B3) &\" chars\" & IF(LEN(B3)>25,\". Please note only the first 25 chars are uploaded to SAP\",\"\")","v":"Doc text length is 0 chars"},null,"Please note Macro must be enabled, see sheet \"Required Settings\" for more information!"]
["Long Text \n(unlimited number of char)",{"$nulls":4},"G/L Indicator Type","No Indicator","Balance control",{"v":0,"d":"0.00"},null,"Signed-off for supporting documentation","NO",{"$nulls":3},"COPA-Accounting",{"$nulls":15},"COPA-Accounting"]
["Posting Key \n(Set automatically)","Due On \n(Set automatically)","G/L Indicator\n(1 char)","Account \n(between 5-10 char)","Amount in Document Currency \n(max 15 char)","Amount in Local Currency \n(NOTE: Not for normal use)","TAX Code\n(only 2 char)","Assignment\n(max 18 char)","Line Item Text \n(max 50 char)","Cost Center \n(only 8 char)","WBS \n(only 14 char)","Network","Network Activity","Internal Order","Profit Center \n(only 6 char)","Financial Material\n(only 7 char)","Product\n(TSA + 7 char)","Offering\n(TSF + 7 char)","Customer","Reseller","Contract","Trading Partner\n(only 3 char)","Partner Profit Center\n(only 6 char)","Material BSEG-MATNR\n(only 7 char)","Ref key 2 ","Ref key 3","Transaction (Consolidation) type ","Quantity","Measure of Unit","Value Date","Ref key 1","Sales Channel"]
[]
[]
[]
[""]
[]
[]
[""]
[]
[""]
{"$rows_empty":9}
[""]
[]
[]
[]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]

{"sheet":"Enclosed attachments","index":1,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"CONTROL","index":2,"n_rows":39,"n_cols":19,"rows_kept":39,"hidden":true}
["CompCodes","CurrCodes","DocTypes","HeaderRanges","GLIndicatorType","PostingKeys",null,null,"CAPEX",null,"SGLICodes","VendorCodes","TrueVendor","CustomerCodes","TrueCustomer","ForbiddenChars","InternalVendors","RPAUserIDs","DK12acc"]
["DK02","EUR","SB","H1","No Indicator","09",null,"Lower range",381010,null,"C","C","C","B","B",")","AT","F11595",101142]
["DK07","DKK","SC","H2","Vendor",19,null,"Higher range",385091,null,"D","D","D","E","H","(","AZ","R00192",101892]
["DK12","NOK","SF","J1","Customer",29,{"$nulls":4},"T","T","T","H","I","}","BE"]
["DK15","SEK","SG","J2",null,39,{"$nulls":4},"E","E",null,"J","M","{","BG"]
["DK21","GBP","SI","L1",null,40,{"$nulls":4},"J","J",null,"K","N","&","CA"]
["FI02","USD",null,"L2",null,50,{"$nulls":4},"K","K",null,"L","O","+","CH"]
["FI11","AUD",null,"B3",null,"07",{"$nulls":4},"L","L",null,"M","Q","[","CY"]
["FI14","BGN",null,"G4",null,"17",{"$nulls":4},"R","R",null,"N","U","]","CZ"]
["FI15","BRL",{"$nulls":8},"S","S",null,"O",null,null,"DE"]
["FI17","CAD",{"$nulls":8},"B",null,null,"Q",null,null,"DK"]
["FI25","CHF",{"$nulls":8},"H",null,null,"R",null,null,"EE"]
["FI55","CNY",{"$nulls":8},"M",null,null,"S",null,null,"ES"]
["FI83 ","CYP",{"$nulls":8},"N",null,null,"U",null,null,"FI"]
["LT12","CZK",{"$nulls":8},"O",null,null,"I",null,null,"FR"]
["NO07","EEK",{"$nulls":8},"Q",{"$nulls":5},"GB"]
["NO29","HKD",{"$nulls":8},"U",{"$nulls":5},"GE"]
["NO34","HUF",{"$nulls":8},"I",{"$nulls":5},"HK"]
["NO45","IDR",{"$nulls":14},"HU"]
["SE02","INR",{"$nulls":14},"IE"]
["SE03","INR",{"$nulls":14},"IN"]
["SE11","ISK",{"$nulls":14},"IT"]
["SE13","JPY",{"$nulls":14},"KZ"]
["SE15","KZT",{"$nulls":14},"LT"]
["SE16","LTL",{"$nulls":14},"LV"]
["SE17","LVL",{"$nulls":14},"MD"]
["SE59","MAD",{"$nulls":14},"NL"]
["SE60","MTL",{"$nulls":14},"NO"]
["SEC2","MXN",{"$nulls":14},"PL"]
[null,"NZD",{"$nulls":14},"RO"]
[null,"PLN",{"$nulls":14},"RU"]
[null,"RON",{"$nulls":14},"SE"]
[null,"RUB",{"$nulls":14},"SG"]
[null,"SAR",{"$nulls":5},"After update, please save, close and reopen workbook for changes to kick in.",{"$nulls":8},"SK"]
[null,"SDR",{"$nulls":5},"Do not put anything under the lists in column A to F.",{"$nulls":8},"TJ"]
[null,"SGD",{"$nulls":14},"TR"]
[null,"SKK",{"$nulls":14},"UA"]
[null,"THB",{"$nulls":14},"US"]
[null,"TRY",{"$nulls":14},"UZ"]

{"sheet":"DATA","index":3,"n_rows":2,"n_cols":16,"rows_kept":2,"hidden":true}
["Rows (f) (5000 Rows)",{"$f":"COUNT(FORM!E6:E4983)","v":0},"Rows (5000 Rows)",2,"Debet amount (f) (5000 Rows)",{"$f":"SUMIF(FORM!A6:A4983,\"09\",FORM!E6:E4983)+SUMIF(FORM!A6:A4983,\"29\",FORM!E6:E4983)+SUMIF(FORM!A6:A4983,\"40\",FORM!E6:E4983)+SUMIF(FORM!A6:A4983,\"07\",FORM!E6:E4983)","v":0},"Debit amount (5000 Rows)",1,"CAPEX","FALSE","MACRO",{"$f":"IF(B1=D1,IF(F1=H1,\"Y\",\"N\"),\"N\")","v":"N"},"Total Debet",1,"Total Rows",2]
[{"$nulls":14},"Template Version","1.54"]