Electronic Invoice Format - CSV1

This document describes version 1 of Landmark's electronic invoice format. This format is a standard comma-separated value file (csv) with data optionally enclosed in quotes ("). Invoice files can either be stored on Landmark's secure server for pickup or can be sent to the client's FTP.

Landmark invoices for 3 different services and depending on the service in the electronic file, the format will change slightly. Each service's format is listed below. Each invoice will always begin with a line starting with "I". Each invoice will have one or more detail lines (D1,D2,D3,L). Each detail line will have one or more charge lines (C).

Parcel Distribution

<!-- Invoice line -->

I, <Invoice Number>, <Client Name>, <Client Code>, <Service>, <Date>, <Due Date>, <Total Charge>, <Currency>

<! -- Detail Line, contains shipment detail -->

D1, <ShipmentReference>, <Landmark Tracking Number>, <Tracking Number>, <Processed Date>, <Postal Code>, <State/Province>, <Country>, <Weight Actual>, <Weight Chargeable>, <Service Used>, <Service Rated>, <Accessorial Type>

<!-- Line Item, additional charges added to the invoice (i.e. Credit for shipment 123) -->

L, <Description>

<!-- Charge Line -->

C, <Amount>, <Description>, <Rate>, <Quantity>

Sample Parcel Data:

Tax Remittance and Disbursement

<!-- Invoice line -->

I, <Invoice Number>, <Client Name>, <Client Code>, <Service>, <Date>, <Due Date>, <Total Charge>, <Currency>

<! -- Detail Line, contains shipment and item detail -->

D2, <ShipmentReference>, <Landmark Tracking Number>, <Clearance Number>, <Clearance Date>, <State/Province>, <Country>, <Sku>, <Description>, <Country of Origin>, <HS Code>, <Unit Value>, <Quantity>, <Total Value>

<!-- Line Item, additional charges added to the invoice (e.g. Brokerage charges) -->

L, <Description>

<!-- Charge Line -->

C, <Amount>, <Description>, <Rate>, <Quantity>

Sample Tax Data:

Fulfillment Services

<!-- Invoice line -->

I, <Invoice Number>, <Client Name>, <Client Code>, <Service>, <Date>, <Due Date>, <Total Charge>, <Currency>

<! -- Detail Line, contains the general category description of the charge -->

D3, <Description>

<!-- Charge Line -->

C, <Amount>, <Description>, <Rate>, <Quantity>

Fulfillment Sample Data: