| Notes | |
|---|---|
| Overview | This file provides the customer with information on confirmed |
| collections |
| Formats |
| XML | |
| Delivery & Scheduling | The report can be scheduled to run automatically on a daily, weekly or monthly basis or it can be requested via the web site on an ad-hoc real time basis. It is up to the customers whether this is scheduled. |
| File Name Convention | SiteCode_CustomerCode_POCExtr_Datetime. (csv or xml) |
| XML Identifier | <POCExtr> |
| Limitations | Customers should be aware that this file is generated once the goods ARE confirmed as |
collected within our system and we will normally only send this information on one occasion on the next file generated after the confirmation has been made. From VW v5 this will no longer include collections |
Field Names & Content for CSV File
The fields in the file are as follows :-
...
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.
Field Names & Content for XML File
File Identifier <PODExtract>
...
CSV Field Name
(Reference Only)
...
XML
Segment Name
...
XML
Element Name
...
Length
...
Notes
...
<HD>
...
Segment and Element Information
XMLSegment Name | XMLSub Segment | XMLElement Name | MAXLength | Notes |
|---|---|---|---|---|
<HD> | ||||
<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
<DRef> | 8 | This is the reference supplied by the customer to uniquely identify the goods withdrawal |
, called Document Reference |
<ORef> | 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. |
Known as Order Reference |
<DPRef> | 15 | If the receiving customers has requested a “purchase reference” to be quoted then this is supplied, this is known as Delivery Point reference. |
Customer Code
<CustomerCode>
<CCode> | 12 | Your customer code at the warehouse used to identify which account the stocks came from. |
Delivery Name
| <Site> | 6 | Site Code | ||
<DPName> | 25 |
Delivery Address
<DPTown> | 25 |
<DPCode> | 8 |
<CStatus> |
6 |
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
Collection Status This will use a number of codes to identify whether the collection was successful or whether there was an issue
| ||||||||
| <CDate> | 10 | Date field format dd/mm/yyyy | ||||||
| <CTime> | 5 | Time field hh:mm | ||||||
| <CName> | 50 | Name of the person collecting and ultimately the signatory | ||||||
</HD> | ||||||||
<LD> |
Product Code
<PCode> | 20 |
<Rtn> |
<Rotation>
10 |
Ordered Cases
| <RtnLn> | 6 |
Ordered Singles
<OCse> | 6 |
Ordered |
<TOrdSgl>
6
Cases |
<OSgl> | 6 |
Ordered Singles |
<TOSgl> | 6 | Total |
Ordered quantity in singles | |||
<CCse> | 6 |
Delivery Line Problem Code
Collected Cases | |||
<CSgl> | 6 |
Collected Singles |
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.
<TCSgl> | 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.
Total Collected quantity in singles | ||||
<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
</LD> |
Summary of some Abbreviated Codes Used within Files
...