[Initial Page]

TPN - Legacy system

LABEL DESIGN (legacy)

Note: This label will be replaced by the TPN Live label format

Data format for import into the TPN Depot System (legacy)

The file is a CSV file.

The fields in this file need to be in the below order.

Docket (string * 8 characters)

Order No (string * 16 characters)

Despatch Date (string * 8 characters DDMMYYYY)

Requesting Depot (string * 3 characters)

Collecting Depot (string * 3 characters)

Consignor Name (string * 30 characters)

Consignor Postcode (string * 8 characters)

Consignee Name (string * 30 characters)

Consignee Address 1 (string * 30 characters)

Consignee Address 2 (string * 30 characters)

Consignee Address 3 (string * 30 characters)

Consignee Address 4 (string * 30 characters)

Consignee Postcode (string * 12 characters)

Delivery Depot (string * 3 characters)

Trunk (string * 4 characters)

Service (string * 4 characters)

Delivery Time (numeric 100's secs since Midnight)

Half Pallets (numeric)

Half Weight (numeric)

Full Pallets (numeric)

Full Weight (numeric)

Half Oversize Pallets (numeric)

Half Oversize Weight (numeric)

Full Oversize Pallets (numeric)

Full Oversize Weight (numeric)

Remarks Line 1 (string * 30 characters)

Remarks Line 2 (string * 30 characters)

Delivery Date (string * 8 characters DDMMYYYY)

Revenue (numeric)

Not Used (numeric)

Manifest Date (string * 8 characters DDMMYYYY)

Quarter Pallets (numeric)

Quarter Weight (numeric)

Customer Own Paperwork (numeric 0 or 1)

Consignor Account (string * 8 characters)

Consignee Contact (string * 30 characters)

Consignee Tel (string * 25 characters)

Consignor Email (string * 64 characters)

Daytime Freight (numeric 0 or 1)