2370 Despatched Orders

 

Notes

 

 

Notes

 

Overview

Based on stock movements being made within the warehouse system.

This will only contain movements where stock has left the warehouse for either a despatch or a stock management process, any depletions of stock will be included.

It will not include items where the status has changed or the stock has been moved within the warehouse.

File Name Convention

NA - API Only

 

Limitations

You can only request a maximum of 60 days in the past due to data archiving and for performance issues.

 

Notes

Avoid pulling for the same day as a further extract later in the same day will provide the same information plus anything new since the last time of the extract.

Last Updates

We will only show entries highlighting changes which are less than 2 years old

Date

Change

Date

Change

 Q4,2024

New 

 

 

Example Output

PDF

Not available

CSV

Not Available

XML

XSD

 

2370 XML Specifications

Record

Segment

Element

Sub Element

Notes

Record

Segment

Element

Sub Element

Notes

<DESORD>

 

 

 

Repeats for each picked order

 

<HD>

 

 

Appears one time for each order

 

 

<CustCode>

 

Stock holding warehouse customer code.

 

 

<OURef>

 

Warehouse unique order reference.

 

 

<PURef>

 

Warehouse Uniqur Picking Reference
(it is possible to pick an order over multiple picks)

 

 

<DocRef>

 

The doc ref you provided for the order

 

 

<DPCRef>

 

Customer Delivery Point Reference

 

 

<Type>

 

Type of Movement - see code list A

Code Lists | A Order Type

 

 

<ODate>

 

Order Date (Entry date onto the warehouse system)

 

 

<MDate>

 

Stock Movement Date (this is the date you requested)

 

 

<XDate>

 

Date/time when this was requested

 

 

<PCon>

 

Parcel carrier consignment section - only appears if a collection group is specified, can be repeated as some carriers issue multiple numbers per item

 

 

 

<PCCN>

Consignment Number

 

 

 

<PCName>

Parcel carrier name

 

 

</PCon>

 

EOS

 

</HD>

 

 

EOS

 

<LD>

 

 

This repeats for each stock movement on the order. You may find you sent a single order line to the warehouse but they picked it from multiple rotations to fulfill the order

 

 

<PCode>

 

Product Code

 

 

<Rtn>

 

Rotation Number - this will include the line number if there is one applicable. Format YY/nnnnnnn/nnnn
If you only wish the bsde rotation then this is a fixed length of 10 characters. [LEFT 10]

 

 

<Cs>

 

Quantity of Cases

 

 

<Sgl>

 

Quantity of Single items.

 

 

<TSgl>

 

Total quantity in single items
(Cases x SPC) + Single Items

 

 

<CLineNo>

 

Customer Line number, this is supplied to the warehouse within the sales order file from the customers system, so it can be used to identify your line number from your original order.

 

 

<PDate>

 

Date/Time that picking was confirmed

(this is different to the stock movement date/time which is what this extract is based on)

 

 

<Batch>

 

The batch number field from the stock receipt into the warehouse, will only be populated if recorded on the warehouse receipt.

If there are multiple it will seperate each by a comma

 

 

<SOLnNt>

 

Output of the SO Incoming EDI field LO1 which contains - SO Line Notes - As per SO XML Structure | XML LO (Line Options) Segment

 

 

<SSCC>

 

This element will repeat for each SSCC on the order with a comma seperating each of the SSCC codes. This field is MAX length so no restriction on the size of it.

 

</LD>

 

 

EOS

</DESORD>

 

 

 

EO can be followed by another <DESORD>

 

 



Copyright Ontech Solutions 2017-2024. All rights reserved, no part may be replicated or distributed without the express permission of the owner.