With the delivery of goods packing slips are created by the supplier. These packing slips can be supplied to you by inONE on a FTP directory.
About the deliveryslip
· Format of the export / import files is .csv or .xml.
· Filenames are always unique (packingslipno_Date-Time-Key).
· If fields are not used by supplier (Like portion, discount etc.) will be left empty.
· In the Header (PH) all meta information about the packing slip will be stored.
· In de Packing slip Rows (PL) all product-order information will be stored.
· In de Packing slip Text Rows (PT) all comments will be stored.
Export method
· Export will be done by FTP. FTP directory will be hosted by inONE. External FTP is not possible.
Comments about CSV format
· Seperator will be semicolon (;).
· Header row will always start with PH as first value.
· Packing slip row will always start with FL as first value.
Comment about XML format
· Every label within one packing slip will be unique. E.g. <price_piece></price_piece> en <price_emb><price_emb>
· All header data will be supplied with an header tag <delivery_header></delivery_header> and all product rows will be preceded with a main row tag <delivery_rows></delivery_rows>.
· Naming convention can be changed at request
Header items (PH)
Delivery terms: |
Characteristics: |
Deliveryslip Header row identifier |
PH |
Order Reference no |
@ the order number/reference to the order. This will be the inONE orderno Explicit if reference to the original order is necessary. |
Packing slip no Supplier |
@ The packing slip number created in the backendsystem of the supplier. |
Customer no Supplier |
@ The customer number / debitor id from the bakcend system of the supplier. |
Customer no Purveyor |
@ The customer number supplierd in the orderfiles |
Deliverydate () |
DD-MM-YYYY |
Packing slip row items (PL)
Delivery terms: |
Characteristics: |
Packing slip row identifier |
PL |
Order row no |
# if supplied the rownno from the original order |
Packing slip no |
@ |
Product no |
@ the product number of the supplier |
Order unit |
@ CASE, BAG, PIECE, KG |
Portion |
# 9999 Always in gramms If non weight article then left empty |
Quantity |
# 9999,99 |
Total row price |
# 9999,99 |
Price per piece |
# 9999,99 |
Price unit |
@ Kg or Pc |
Delivery slip textrow (PT)
Delivery terms: |
Kenmerken: |
Text row identifier |
PT |
Packing slip no |
@ |
Text/ comments |
@ |
XML Example
<Deliverys>
<DeliveryHead>
<OrderReference>EOWH_16-20977</OrderReference>
<DeliveryNumber>16098</DeliveryNumber>
<DeliveryDate>20-04-2016</DeliveryDate>
<Debitorid_Supplier></Debitorid_Supplier>
<Debitorid_Purveyor></Debitorid_Purveyor>
</DeliveryHead>
<DeliveryRows>
<DeliveryRow>
<RowNumber>1</RowNumber>
<ProductNumber>1045</ProductNumber>
<ProductUnit>CASE</ProductUnit>
<Portion></Portion>
<Quantity>5.00</Quantity>
<PiecePrice>4.00</PiecePrice>
<TotalRowPrice>20.00</TotalRowPrice>
<PriceUnit>Pc</PriceUnit>
</DeliveryRow>
<DeliveryRow>
<RowNumber>2</RowNumber>
<ProductNumber>1022</ProductNumber>
<ProductUnit>Gr/portion</ProductUnit>
<Portion>100</Portion>
<Quantity>1.00</Quantity>
<PiecePrice>5.50</PiecePrice>
<TotalRowPrice>0.55</TotalRowPrice>
<PriceUnit>Kg</PriceUnit>
</DeliveryRow>
</DeliveryRow>
<DeliveryHead>
...
...
</Deliverys>
Comments
0 comments
Please sign in to leave a comment.