{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["CashBook"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"CashBook","index":0,"n_rows":6,"n_cols":41,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,1,0,9],[0,10,0,27],[0,28,0,40]],"flags":["formulas_cached_only"]}
[null,"Master Column",{"$nulls":8},"Cash Book Detail",{"$nulls":17},"Payment Detail Column"]
[null,"(20 chars)","(Date: dd/MM/yyyy)","(2 chars, PV for Payment Voucher, OR for Receipt Voucher)","(80 chars)","(100 chars)","(5 chars)","(Number, use System Currency Rate Decimal)","(Rich Text)","(Boolean: T or F)","(12 chars)","(Number, use System Currency Rate Decimal)","(10 chars)","(10 chars)","(8 chars)","(100 chars)","(Rich Text)","(12 chars)","(25 chars)","(80 chars)","(30 chars)","(20 chars)","(50 chars)","(Number, use System Currency Decimal)","(Number, use System Currency Decimal)","(Number, use System Currency Decimal)","(Number, use System Currency Decimal)","(Number, use System Currency Decimal)","(20 chars)","(20 chars)","(Number, use System Currency Decimal)","(Number, use System Currency Decimal)","(Number, use System Currency Rate Decimal)","(14 chars)","(30 chars)","(10 chars)","(10 chars)","(20 chars)","(Integer)","(Boolean. Indicate T for Returned Cheque or F otherwise)","(Returned Cheque Date: dd/MM/yyyy)"]
["Bold column are mandate fields.","DocNo","DocDate","DocType","DealWith","Description","CurrencyCode","CurrencyRate","Note","InclusiveTax","AccNo","ToAccountRate","ProjNo","DeptNo","TaxType","DetailDescription","FurtherDescription","SalesAgent","TaxBRNo","TaxBName","TaxRefNo","TaxPermitNo","TaxExportCountry","Amount","TaxableAmt","TaxAdjustment","Tax","RCHQAmount","PaymentMethod","ChequeNo","PaymentAmt","BankCharge","ToBankRate","BankChargeTaxType","BankChargeTaxRefNo","BankChargeProjNo","BankChargeDeptNo","PaymentBy","FloatDay","IsRCHQ","RCHQDate"]
["Sample","<<New>>","24/05/2015","PV","Tenaga Nasional Bhd","Cash Payment","MYR",1,null,"F","200-2000",1,null,null,"TX_S","Water Bill for Month of",{"$nulls":7},100,null,0.01,null,null,"UOB",445713,106.01,null,1,{"$nulls":4},"Cheque",2,"F"]
[{"$nulls":10},"202-02002",1,null,null,"SR_S","Phone Bill",{"$nulls":7},200,null,null,11.99,null,"UOB",445714,211.99,null,1,{"$nulls":4},"Cheque",2,"F"]
[null,"<<New>>","24/07/2012","OR","Property Management Services","Cash Receipt","SGD",2.6,null,"F","100-0000",2.6,null,null,null,"Rental Received for month of",{"$nulls":7},1500,{"$nulls":4},"MBB",586123,1500,null,1,{"$nulls":4},"Cheque",2,"F"]