2480 CSV Output

Overview

This file provides the customer with information on confirmed deliveries giving details of the products delivered and confirmed quantities.

PDF

Not Available

CSV

Available

XML

Not available

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_PODExtr_Datetime.     (csv or xml)

Limitations

Customers should be aware that this file is generated once the goods ARE confirmed as delivered 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 Name

Length

CSV

XML Segment

Notes

UID

8

Y

HD

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

Y

HD

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

Order Reference

8

Y

HD

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

Y

HD

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

Customer Code

6

Y

HD

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

Delivery Name

25

Y

HD

Delivery Address

25

Y

HD

Delivery Postcode

8

Y

HD

Actual Delivery Date

8

Y

HD

Physical Cases

6

Y

HD

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

Y

HD

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

Case Charge

6

Y

HD

The charge for the number of invoice cases for this delivery

Additional Charge

6

Y

HD

Additional Reason

30

Y

HD

Handling Charge

6

Y

HD

Total Charge

6

Y

HD

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

Delivery Problem Code

6

Y

HD

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

Y

LD

Rotation Number

10 or
15

Y

LD

Ordered Cases

6

Y

LD

Ordered Singles

6

Y

LD

Total Ordered Singles

6

Y

LD

Delivered Cases

6

Y

LD

Delivered Singles

6

Y

LD

Total Delivered Singles

6

Y

LD

Delivery Line Problem Code

6

Y

LD

Line Number

6

Y

LD

Our internal Line Number

Line Invoice Cases

6

Y

LD

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

Y

LD

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

Invoice To

6

Y

LD

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

Redelivery

3

Y

LD

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

Y

LD

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

Y

LD

Your line number as specified in your sales order file

Ignore Minimum

1

Y

LD

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

Y

LD

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

Consignment Number

11

Y

LD

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.