Extension: Advance Shipping Notice Interface - Default
The CSV file
The CSV file is received from a supplier and from the file goods that are received against purchase orders and purchase invoices can be imported to SAP Business One with the Produmex Interfacing Tool.
The CSV file must contain 14 columns with predefined column names that can be present in any order and it can contain two additional optional columns (see table below).
CSV Custom Header
If the supplier sets different column names in the header of the CSV file (for example Object Type instead of ObjType, Document Number instead of DocNum, etc.), the Interfacing Tool is not able to match the columns to the correct fields. In this case the header of the CSV file is overwritten by the CSV Custom Header.
|Column name |
|ObjType||The object type of the document, it is either a purchase order or a purchase invoice.|
|DocNum||The document number of the purchase order/purchase invoice|
|LineNum||The correct line of the item in the purchase order|
|ItemCode||The item code of the product|
|Quantity||The quantity of the item to be received|
|SSCC||The SSCC of the logistic unit|
|MasterSSCC||The SSCC number of the master logistic unit|
|Batch||The batch number of the product|
|Batch2||The second batch number of the product|
|BBD||The best before date of the product|
|SerialNumber||The serial number of the product|
|BeasItemVersion (optional column)||Item version number in case of Produmex WMS - Beas Manufacturing integration|
|SupplierRefNo (optional column)||Supplier reference number|