2341 CSV Output

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: “HO” Duty Paid Order or “EU” – European Underbond See Code Lists \| A Order Type for what can be used in this field
TotalSingles	10	The total number of singles confirmed picked for this order line
DP Reference