A comma-separated file containing new tracking statuses on all in-transit packages for a client. The file will contain all new statuses received since the previous file was generated. The file will be placed on Landmark's SFTP server in the .../OUTBOUND/Tracking folder. Login credentials will be provided by Landmark Global. The file can also be transmitted by Landmark to a separately hosted SFTP server if desired.
File Name Convention (timezone is in American/Chicago)
TransitReport-<clientID>-yyyymmddhhiiss.csv
Example: TransitReport-218-20200729154801.csv
The file contains a header row. Below is a file format table.
| Headers | MySQL Type | Max Length / Set | Description / Notes |
|---|---|---|---|
| Client | smallint | 5 | Landmark client identification number |
| Reference | varchar | 50 | Client-provided customer reference |
| Landmark Tracking Number | varchar | ||
| Carrier Tracking Number | varchar | 50 | Assigned per package, carrier specific |
| Carrier | varchar | 8 | |
| To City | varchar | 20 | |
| To State | varchar | 40 | If country for original outbound shipment has states or provinces. Use 2- or 3-character abbreviations when possible |
| To Postal Code | varchar | 10 | If country for original outbound shipment uses postal codes. Canada format: "A9A9A9" // USA format: "12345" 4 digit suffix optional |
| Status Code | smallint | 5 | Numerical Landmark reference |
| Status | varchar | 255 | Description of tracking update |
| Time | datetime | 21 | DateTime stamp in US Central time |
| Location | varchar | 255 | Physical location relating to the update |
Possible tracking status codes include:
- 50 Shipment Data Uploaded
- 60 Shipment inventory allocated
- 75 Shipment Processed
- 80 Shipment Fulfilled
- 90 Shipment held for payment
- 100 Shipment information transmitted to carrier
- 125 Customs Cleared
- 135 Customs Issue
- 150 Crossing Border
- 155 Crossing Received
- 200 Item scanned at postal facility
- 225 Item grouped at Landmark or partner facility
- 250 Item scanned for crossing
- 275 Item in transit with carrier
- 300 Item out for delivery
- 400 Attempted delivery
- 410 Item available for pickup
- 450 Item re-directed to new address
- 500 Item successfully delivered
- 550 Return received at handling facility
- 570 Return Received
- 800 Claim Issued
- 900 Delivery failed
Note: These are general explanations of the meaning of each status code; the text of actual status updates may differ.