---
title: "Tracking File Specifications"
slug: "tracking-file-specifications"
updated: 2024-05-16T00:38:20Z
published: 2024-05-16T00:38:20Z
canonical: "mercurydocs.landmarkglobal.com/tracking-file-specifications"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://mercurydocs.landmarkglobal.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Tracking File Specifications

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.*

## Attachments

- [TransitReport-2260-20251008060302.csv](https://cdn.document360.io/f8bd1df0-b4a6-434a-89a6-6c42736ea472/Images/Documentation/TransitReport-2260-20251008060302.csv)