...
Name | Description | Type | Example | Comment |
|---|---|---|---|---|
| order_line_number | The line number from the original order from the customer's system. | Integer | 1234567 | Unique per customer ERP system, not per customer order. |
| supplier_product_id | The product ID of the product in the supplier's system. | String | A1234 | |
| inner_barcode | The inner barcode the product. | String | 01234567890128 | |
| product_name | The name/description of the product. | String | A4 PAPER WHITE 100GSM | |
| qty | Unit quantity orderedinvoiced. | Integer | 6 | |
| pack_unit | Name of pack unit in which the invoice quantity is expressed. | String | BOX | |
| pack_quantity | Quantity of inners in each unit being ordered. | Integer | 10 | For example, if an order is being placed for 6 cartons and each carton contains 10 boxes (where a box is the sell/inner unit), this field will contain 10. |
| unit_price | The price for each unit ordered. | Decimal | 19.45 |
...
| Code Block | ||
|---|---|---|
| ||
D,type,account_number,po_number,invoice_number,invoice_date,delivery_date, H,Invoice,ABC123,12345,200001,2015-08-15,2015-08-21, D,order_line_number,supplier_product_id,inner_barcode,product_name,qty,pack_unit,pack_quantity,unit_price L,1234567,TESTPROD1,12345678938,THIS IS A TEST PRODUCT,10,BOX,8,12.95 L,1234568,TESTPROD2,12345678905,THIS IS ANOTHER TEST PRODUCT,20,EACH,1,3.95 L,1234569,TESTPROD3,12345678916,THIS IS A THIRD TEST PRODUCT,5,CARTON,100,39.95 L,1234570,TESTPROD4,12345678949,THIS IS A FOURTH TEST PRODUCT,16,EACH,1,2.45 L,1234571,TESTPROD5,12345678927,THIS IS A FIFTH TEST PRODUCT,12,PACK,2,64.95 |