Overview
TBC
Format
The report is in csv format, which means it can be read into your system or can be opened in excel.
Delivery & Scheduling
This report cannot be scheduled, it is emailed realtime as the warehouse generate the invoices.
...
The file will normally be emailed to your email address as an attachment to an existing message.
File Name Convention
The filename will be:
TransportInvoice_<InvoiceNumber>.csv
Limitations
There are no noted limitations
CSV Field Names & Content
Field Name | Size | Notes |
Invoice Number | 12 |
|
Invoice Date | 10 |
|
Customer Code | 8 |
|
Site Code | 6 | The site on which your goods reside. |
Customer Name | 30 |
|
DeliveryDate | 10 |
|
Order No | 8 |
|
Del Name | 40 |
|
PostCode | 10 |
|
Physical Cases | 6 |
|
Invoice Cases | 6 |
|
Rate Band | 15 |
|
Area | 6 |
|
Del Charge | 15 |
|
HandlingCharge | 15 |
|
Re-Delivery | 1 | Y or N |
Re-Del Reason | 4 |
|
Minimum Charge Applied | 1 | Y or N - Is there a minimum charge applied |
Fuel Surcharge | 15 |
|
...