CSV Field Names & Content
Field Name | Size | Notes |
Customer Code | 8 | |
DP Account Ref | 8 | Normally your customers account code |
Document Reference | 30 | Your unique order reference |
ProductCode | 30 | |
RotationNumber | 15 | |
Cases | 10 | |
Singles | 10 | |
LineNumber | 6 | Your line number sent to the warehouse in your sales order file. |
OrderDate | 10 | |
ExciseDuty | 15 | 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 | 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 | 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 | 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 | This is the total invoice cases for the overall delivery |
LineInvoicecases | 12.3 | 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 | 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 | The total number of singles confirmed picked for this order line |
DP Reference | ||
Batch Ref | ||
SO Notes | ||
PCCN | This section can be repeated multiple times one time for each | |
PCName | ||
SSCC | A repeating element which will be provided one time for each SSCC for this product line |