2480 CSV Output

Field Name	Length	Notes
UID	8	The warehousing unique reference, can be used to provide a full trace within the system, supplied to customers to aid with investigation work and to assist identification of unique goods withdrawal.
Document Reference	30	This is the reference supplied by the customer to uniquely identify the goods withdrawal
Order Reference	8	Normally supplied by the customer and used to provide a unique delivery point identifier for the delivery. For example your customer account code for the delivery point.
Customer Order Reference	15	If the receiving customers has requested a “purchase reference” to be quoted then this is supplied.
Customer Code	6	Your customer code at the warehouse used to identify which account the stocks came from.
Delivery Name	25
Delivery Address	25
Delivery Postcode	8
Actual Delivery Date	8
Physical Cases	6	The total number of physical cases on the delivery, if there are singles also with the delivery it is rounded up to the next whole case.
Invoice Cases	6	Depending on case size, the amount of cases invoiced can be modified to give the total number of invoiced cases.
Case Charge	6	The charge for the number of invoice cases for this delivery
Additional Charge	6
Additional Reason	30
Handling Charge	6
Total Charge	6	This is the addition of the case charge, additional charge, handling charge for the delivery
Delivery Problem Code	6	See Code List C If there has been an issue with the entire delivery, then there will be a code in here. Whilst there is a list below of possible codes, this is only and example of what could be used so please consult your warehouse for full information. Where this field is used it normally means the entire delivery is effected, such as “Customer Refused Delivery” or “Customer Not In”
Product Code	20
Rotation Number	10 or 15
Ordered Cases	6
Ordered Singles	6
Total Ordered Singles	6
Delivered Cases	6
Delivered Singles	6
Total Delivered Singles	6
Delivery Line Problem Code	6	See Code list D
Line Number	6	Our internal Line Number
Line Invoice Cases	6	This is used for the calculation of the total case_charge in the header of this delivery, the sume of this figure for all lines rounded up gives the total charge
Confirmed Delivery On	8	This is the date when this was confirmed on the system, to ensure that items are no duplicated.
Invoice To	6	If the delivery is being invoiced to another account, then the code of the other account will be shown here.
Redelivery	3	A Yes or No field, to determine whether this is a second or subsequent charge for a delivery. For example where a customer is not available and redelivery is made then thiscould be chargeable, as such you will receive two references to the same delivery to potentially increase the charges / costs for the delivery.
Status	1	This should indicate the current status of the order, it should be status “D” Delivered or “I” Invoiced however it could potentially be “X” Cancelled.
Your Line Number	6	Your line number as specified in your sales order file
Ignore Minimum	1	Where a customers charging structure imposses a minimum charge, this field is used to indicate when the minimum charge is being ignored and the case rate is purely multiplied with the number of cases.
Load Number	4	This is the warehouse load reference number to aid tracking for customers.
Consignment Number	11	This field is used to indicate the parcel carriers information for the delivery and is used to show their consignment reference, and where the parcel carrier offers online information this number can be used to trace the information on the parcel carriers web site, or potentially give to your customer.