Notes | ||
|---|---|---|
Overview | This output is used to show the previous picked order lines, also the amount or value that was charged for the excise and customs duty etc. If you duty defer your order you will still see an entry here as this shows what was picked from YOUR stocks. Operationally an order could be picked over more than a single output file, as this is based on the pick confirmation of each line of the order, also bear in mind you may order a product but we may be picking this across several rotations so several lines may appear in the output for the same one product line you sent to the warehouse. Order picked confirmation is generated when the stock movement takes place, this is slightly different depending on whether Distribution is in use, if this is not in use then it is generated when the order is marked as collected or despatched and in the event that you have underbond activities then the duty has to be posted onto the bond system. In the event you use distribution then anything being picked is for onward delivery and the pick confirmation point is used to trigger the stock movement posting and bond posting (where applicable) Only when the stock movement posting is complete will the orders picked confirmation be produced. | |
Available | ||
CSV | Available | |
XML | Available | |
File Name Convention | SiteCode_CustomerCode_OrdPckd_datetime | |
Limitations | None | |
Notes | You should be aware that when the picking confirmation file is returned to you that there can be multiple lines for a single product ordered, as the picking stage may pick from multiple rotations. All lines will have the same sales order line number and the overall quantity will be what you ordered. | |
CSV Field Names & Content
Field Name | Size | CSV | XML Segment | Notes |
Customer Code | 8 | Y | HD | |
DP Account Ref | 8 | Y | HD | Normally your customers account code |
Document Reference | 30 | Y | HD | Your unique order reference |
ProductCode | 30 | Y | LD | |
RotationNumber | 15 | Y | LD | |
Cases | 10 | Y | LD | |
Singles | 10 | Y | LD | |
LineNumber | 6 | Y | LD | Your line number sent to the warehouse in your sales order file. |
OrderDate | 10 | Y | HD | |
ExciseDuty | 15 | Y | LD | How much excise duty for this line Shown for all lines which could have duties applicable, use in conjunction with delivery type to assess whether applicable |
CustomsDuty | 15 | Y | LD | How much customs duty for this line Shown for all lines which could have duties applicable, use in conjunction with delivery type to assess whether applicable |
VAT | 15 | Y | LD | How much VAT was calculated for this line Shown for all lines which could have duties applicable, use in conjunction with delivery type to assess whether applicable |
TotalCharge | 15 | Y | LD | The delivery charge for the goods from this line of the delivery, it takes the overall value, number of overall cases and proportions the charge equally on each line |
InvoiceCases | 10 | Y | HD | This is the total invoice cases for the overall delivery |
LineInvoicecases | 12.3 | Y | LD | When calculating the transport charge each line is calculated and then added together to provide an overall total invoice cases value. This is the individual line value |
DeliveryType | 6 | Y | HD | This will be HMRC order types shown in this field, such as: Only those lines which are HO will have duty calculated on the W5 the others are for informational purposes only |
TotalSingles | 10 | Y | LD | The total number of singles confirmed picked for this order line |
DP Reference | HD | |||
Batch Ref | LD | |||
SO Notes | LD | |||
PCCN | HD/PC | This section can be repeated multiple times one time for each | ||
PCName | HD/PC | |||
SSCC | LD/SSCC | A repeating element which will be provided one time for each SSCC for this product line |
XML Format
Segment / Element | Notes |
|---|---|
<PICK> | Repeats for each picked order |
<HD> | Appears one time for each order |
<CustCode> | |
<OrdRef> | |
<DocRef> | |
<Type> | |
<ODate> | |
<ICase> | |
<DPCRef> | |
<PC> | Parcel carrier confignment section - only appears if needed, can be repeated as some carriers issue multiple numbers per item |
<PCCN> | Consignment Number |
<PCName> | Parcel carrier name |
</PC> | EOS |
</HD> | EOS |
<LD> | This repeats for each pick item 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> | |
<Rotation> | |
<Case> | |
<Single> | |
<TSingle> | |
<CLineNo> | |
<ExciseD> | |
<CDuty> | |
<VAT> | |
<DCharge> | |
<LICase> | |
<Batch> | |
<SOLnNt> | |
<SSCC> | This element will repeat for each SSCC on the order. |
</LD> | EOS |
</PICK> | EO can be followed by another <PICK> |