...
Overview | This file provides the customer with information on confirmed |
...
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.
collections | |
File Name Convention | SiteCode_CustomerCode_POCExtr_Datetime. |
...
XML | ||
XML Identifier | <POCExtr> | |
Limitations | Customers should be aware that this file is generated once the goods ARE confirmed as | |
...
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>
...
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
...
Last Updates
We will only show entries highlighting changes which are less than 2 years old
Date | Change |
|---|---|
|
|
|
|
Example Output
Not available
CSV
Not available
XML
| View file | ||
|---|---|---|
|
XML Specification
Segment | Segment L1 | Segment L2 | Notes |
|---|---|---|---|
<POCExtr> | |||
<HD> | Can repeat within the <POCExtr> multiple times, relating to seperate orders | ||
<LD> | Can repeat within the <HD> multiple times, relating to lines on an order | ||
</LD> | |||
</HD> | |||
<POCExtr> |
XML Segment Name | XML L1 Sub Segment | XML L2 Sub | XML Element Name | MAX Length | 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 |
...
Point Name |
...
<DPTown> | 25 | Delivery |
...
Point Town |
...
<DPPC> | 8 |
...
Delivery |
...
Point Postal Code |
...
<CTrans> |
...
8
...
Physical Cases
...
</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>
30 | Advised Collection Transport Company | |||
<CStatus> | 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”
Collection Status This will use a number of codes to identify whether the collection was successful or whether there was an issue 1 - Collection Complete without issue 2 - Collection re-landed in Full to stock 3 - Collections partially re-landed to stock | |||||
<CDate> | 10 | At the time of collection Date field format dd/mm/yyyy. | |||
<CTime> | 5 | At the time of collection Time field hh:mm. | |||
<CName> | 50 | At the time of collection Name of the person collecting and ultimately the signatory | |||
<CReg> | 30 | At the time of collection Collection Vehicle Registration Number | |||
</HD> | |||||
<DO> | |||||
<PCon> | (this section can repeat one time for each consignment no) | ||||
<PConNo> | 50 | Parcel Consignment Number | |||
</PCon> | |||||
</DO> | |||||
<LD> | |||||
<PC> | 20 | Product Code | |||
<Rtn> | 10 | Rotation Number | |||
<RtnLn> | 6 | Rotation Line Number | |||
<OCse> | 6 | Ordered Cases | |||
<OSgl> | 6 | Ordered Singles | |||
<TOSgl> | 6 | Total Ordered quantity in singles | |||
<CCse> | 6 | Collected Cases | |||
<CSgl> | 6 | Collected Singles | |||
<TCSgl> | 6 | Total Collected quantity in singles | |||
<SOLn> | 6 | Your line number as specified in your sales order file |
...
Ignore Minimum
...
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.
...
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.
</LD> |
...
Summary of some Abbreviated Codes Used within Files
...