POC Export

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

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

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.

CSV Field Name
(Reference Only)

XML
Segment Name

XML
Element Name

Length

Notes

<HD>

UID

<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

<DOCREF>

8

This is the reference supplied by the customer to uniquely identify the goods withdrawal

Order Reference

<ORDREF>

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

<CORDREF>

15

If the receiving customers has requested a “purchase reference” to be quoted then this is supplied.

Customer Code

<CustomerCode>

6

Your customer code at the warehouse used to identify which account the stocks came from.

Delivery Name

<DName>

25

Delivery Address

<DTown>

25

Delivery Postcode

<DPCode>

8

Actual Delivery Date

<DelDate>

8

Physical Cases

<PhyCse>

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

<InvCse>

6

Depending on case size, the amount of cases invoiced can be modified to give the total number of invoiced cases.

Case Charge

<CBand>

6

The charge for the number of invoice cases for this delivery

Additional Charge

<AddChg>

6

Additional Reason

<AddRsn>

30

Handling Charge

<HChg>

6

Total Charge

<TChg>

6

This is the addition of the case charge, additional charge, handling charge for the delivery

Delivery Problem Code

<DProbCode>

6

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”

</HD>

<LD>

Product Code

<PCode>

20

Rotation Number

<Rotation>

10 or 15

Ordered Cases

<OrdCase>

6

Ordered Singles

<OrdSgl>

6

Total Ordered Singles

<TOrdSgl>

6

Delivered Cases

<DelCase>

6

Delivered Singles

<DelSgl>

6

Total Delivered Singles

<TDelSgl>

6

Delivery Line Problem Code

<LProbCode>

6

Line Number

<Line>

6

Our internal Line Number

Line Invoice Cases

<LIC>

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

<ConfirmDate>

8

This is the date when this was confirmed on the system, to ensure that items are no duplicated.

Invoice To

<InvTo>

6

If the delivery is being invoiced to another account, then the code of the other account will be shown here.

Redelivery

<ReDel>

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

<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

<SOLN>

6

Your line number as specified in your sales order file

Ignore Minimum

<IM>

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

<LoadRef>

4

This is the warehouse load reference number to aid tracking for customers.

Consignment Number

<PCConsignNo>

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.

</LD>