Export definition packingslip

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 If available else empty
Price per piece	# 9999,99 If available else empty
Price unit	@ Kg or Pc If available else empty

Delivery slip textrow (PT)

Delivery terms:	Kenmerken:
Text row identifier	PT
Packing slip no	@
Text/ comments	@

XML Example

<?xml version="1.0" encoding="utf-8"?>

<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>