{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Sheet2"],"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":"Sheet2","index":0,"n_rows":19,"n_cols":33,"rows_kept":19,"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: Quote, Order, Invoice, Credit Note"]
["#","> Customer Full Name"]
["#","> Service date only applicable in Service Invoices"]
["#","> Terms: Days of Credit Term in Invoices"]
["#","> Due Date: Applicable for invoices and is required, Expiry Date applicable for Quotes and is optional, delivery date applicable for order and is optional"]
["#","> Export No., Export Country, Special Scheme No. only applicable in Invoices"]
["#","> 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 *","Customer *","Transaction No*","Date *","Service Date","Terms +","Due Date / Expiry Date/Delivery Date +","Reference","Export No.","Export Country","Special Scheme No.","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","Tariff Code","Job No","Location Code","UOM Code","Transaction Note","Delivery Note","Journal Memo"]
[null,"Quote","Contact 1","Q1001","2020-07-01",null,30,"2020-07-15","REF1001Q",null,null,null,"Person 1","KA3-2-13","Kuchai Avenue","39 Jalan Kuchai Maju 13","58200 Kuala Lumpur","MYR",null,"Item 1","Item Description",2,100,10,"ST05",5,687,"Job 1","KL","Unit","Note","Delivery Note","Memo"]
[null,"Order","Contact 1","SO1001","2020-07-01",null,30,"2020-07-15","REF1001SO",null,null,null,"Person 1","KA3-2-13","Kuchai Avenue","39 Jalan Kuchai Maju 13","58200 Kuala Lumpur","MYR",null,"Item 1","Item Description",2,100,10,"ST05",5,687,"Job 1","Selangor","Dozen","Note","Delivery Note","Memo"]
[null,"Invoice","Contact 1","INV1001","2020-07-01","2020-07-01",30,"2020-07-15","REF1001INV","EXP1001INV","MY","SSN1001INV","Person 1","KA3-2-13","Kuchai Avenue","39 Jalan Kuchai Maju 13","58200 Kuala Lumpur","MYR",null,"Item 1","Item Description",2,100,10,"ST05",5,687,"Job 1","Main Warehouse","Box","Note","Delivery Note","Memo"]
[null,"Credit Note","Contact 1","CN1001","2020-07-01",null,30,null,"REF1001CN",null,null,null,"Person 1","KA3-2-13","Kuchai Avenue","39 Jalan Kuchai Maju 13","58200 Kuala Lumpur","MYR",null,"Item 1","Item Description",2,100,10,"ST05",5,687,"Job 1","Store","Carton","Note","Delivery Note","Memo"]