{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"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"}

{"sheet":"Sheet1","index":0,"n_rows":17,"n_cols":30,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["#","ALL LINES START WITH HASH ARE COMMENTS AND WILL BE IGNORED"]
["#","Notes:"]
["#","1) Columns with asterisk (*) are required."]
["#","2) Columns with plus (+) are required with conditions."]
["#","3) Options / Explanations:"]
["#","> Type: Order, Bill, Debit Note, "]
["#","> Supllier Full Name"]
["#","> Terms: Days of Credit Term in Bills"]
["#","> Due Date: Applicable for  bills and is required, Delivery date applicable for PO and is optional"]
["#","> Import No., Import Country only applicable in Bill"]
["#","> Currency: ISO Currency code, eg. MYR, USD, SGD…"]
["#","> Discount: If in percent format, put '%' at the end"]
["#","> Unit of Measurements (UOM) Code: Code that represent the unit"]
["#","Type *","Supplier *","Transaction No*","Date *","Service Date","Terms +","Due Date / Delivery Date +","Reference","Import No.","Import Country","Contact Person","Address Line 1","Address Line 2","Address Line 3","Address Line 4","Currency Code *","Currency Exchange Rate +","Item/ Account Name *","Item / Account Description","Quantity *","Unit Price *","Discount","Tax Code","Tax Rate","Job No","Location Code","UOM Code","Transaction Note","Journal Memo"]
[null,"Order","Contact 1","PO1001","2020-07-01",null,30,"2020-07-15","REF1001PO",null,null,"Person 1","KA3-2-13","Kuchai Avenue","39 Jalan Kuchai Maju 13","58200 Kuala Lumpur","SGD",3,"Product 1","Product Description",1,100,10,"SR",7,"Job 1","KL","Unit","Note","Memo"]
[null,"Bill","Contact 1","BIL1001","2020-07-01",null,30,"2020-07-15","REF1001BIL","IMPNO1001BIL","SG","Person 1","KA3-2-13","Kuchai Avenue","39 Jalan Kuchai Maju 13","58200 Kuala Lumpur","SGD",3,"Product 1","Product Description",1,100,10,"SR",7,"Job 1","Selangor","Dozen","Note","Memo"]
[null,"Debit Note","Contact 1","DN1001","2020-07-01",null,30,null,"REF1001DN",null,null,"Person 1","KA3-2-13","Kuchai Avenue","39 Jalan Kuchai Maju 13","58200 Kuala Lumpur","SGD",3,"Product 1","Product Description",1,100,10,"SR",7,"Job 1","Main Warehouse","Box","Note","Memo"]