Carrier. Invoice. EDI 210 Format X12 Version Inbound. Revised: August 25, 2011 Version:

(1)

Carrier

Invoice

EDI–210 Format

X12 Version 004020

Inbound

Revised:

August 25, 2011

Version:

2.01.21

(2)

EXECUTIVE SUMMARY

The Invoice is used to electronically communicate shipment cost information to the Shipper. The Invoice includes information about the load such as reference numbers, actual pickup and delivery times, locations, line-haul rate and charge, accessorial rates and charges, etc.

Freight Invoice EDI documents in Sterling TMS use the ANSI X12 – 210 (Motor Carrier Load Freight Details and Invoice) specification version 004020. This specification is included as well as examples of its use.

Three types of inbound Freight Invoice messages are supported by Sterling TMS: 1. Original – First invoice for a particular shipment.

2. Adjustment – An invoice that contains only new charges, not included on the original invoice. 3. Rebilling – A complete replacement invoice for a particular shipment.

Sterling TMS will send 997 Functional Acknowledgments for this EDI transaction upon request. Sterling TMS sends both positive and negative acknowledgements. If a 210 transaction does not adhere to this spec, it will be rejected and the reason for the rejection will be included in the 997.

Special Characters

Delimiters

Sterling TMS uses the asterisk (*) for the element separator, the tilde (~) for the segment terminator, and the vertical bar (|) for the sub-element separator. Please do not use any other delimiters.

Handling of Other Special Characters

 Sterling TMS will change the following characters to spaces: \ |

 Sterling TMS will change the pound sign (#) to be „NO. ‟

(3)

2

EDI FORMAT

210 Motor Carrier Freight Details and Invoice

Functional Group ID=

IM

Introduction:

This Draft Standard for Trial Use contains the format and establishes the data contents of the Motor Carrier Freight Details and Invoice Transaction Set (210) for use within the context of an Electronic Data Interchange (EDI) environment. The transaction set can be used to provide detail information for charges for services rendered by a motor carrier. It is used both as a motor carrier invoice to request payment or as details pertaining to motor freight shipment(s) charges.

Heading:

Pos. Seg. Req. Loop Notes and No. ID Name Des. Max.Use Repeat Comments

M 0010 ISA Interchange Control Header M 1 M 0020 GS Functional Group Header M 1 M 0100 ST Transaction Set Header M 1 M 0200 B3 Beginning Segment for Carrier's Invoice M 1 R 0400 C3 Currency O 1 0500 ITD Terms of Sale/Deferred Terms of Sale O 1 0600 N9 Reference Identification O 300 0800 R3 Route Information - Motor O 12 1000 K1 Remarks O 10 LOOP ID - 0100 10 M 1100 N1 Name O 1 1300 N3 Address Information O 2 1400 N4 Geographic Location O 1 LOOP ID - 0200 10 1600 N7 Equipment Details O 1

Detail:

LOOP ID - 0300 999 0100 S5 Stop-off Details O 1 n1 0200 N9 Reference Identification O 10 0300 G62 Date/Time O 10 LOOP ID - 0310 2 0500 N1 Name O 1 0700 N3 Address Information O 2 0800 N4 Geographic Location O 1 0900 N9 Reference Identification O 5 LOOP ID - 0400 9999 M 1200 LX Assigned Number O 1 1300 N9 Reference Identification O 5 1400 L5 Description, Marks and Numbers O 30 1700 L0 Line Item - Quantity and Weight O 10 R 1800 L1 Rate and Charges O 10

(4)

M 0200 SE Transaction Set Trailer M 1 M 0210 GE Functional Group Trailer M 1 M 0220 IEA Interchange Control Trailer M 1

Transaction Set Notes

(5)

4

Segment:

ISA

Interchange Control Header Position: 0010

Loop:

Level: Heading

Usage: Mandatory

Max Use: 1

Purpose: To start and identify an interchange of zero or more functional groups and interchange-related control segments

Syntax Notes: Semantic Notes: Comments:

Data Element Summary Ref. Data

Des. Element Name Attributes M ISA01 I01 Authorization Information Qualifier M ID 2/2

Code to identify the type of information in the Authorization Information

00 No Authorization Information Present (No Meaningful

Information in I02)

M ISA02 I02 Authorization Information M AN 10/10 Information used for additional identification or authorization of the interchange sender or the data in the interchange; the type of information is set by the Authorization Information Qualifier (I01)

M ISA03 I03 Security Information Qualifier M ID 2/2 Code to identify the type of information in the Security Information

00 No Security Information Present (No Meaningful

Information in I04)

M ISA04 I04 Security Information M AN 10/10 This is used for identifying the security information about the interchange sender or the data in the interchange; the type of information is set by the Security Information Qualifier (I03)

M ISA05 I05 Interchange ID Qualifier M ID 2/2 Qualifier to designate the system/method of code structure used to designate the sender or receiver ID element being qualified

02 SCAC (Standard Carrier Alpha Code)

M ISA06 I06 Interchange Sender ID M AN 15/15 Identification code published by the sender for other parties to use as the receiver ID to route data to them; the sender always codes this value in the sender ID element

Carrier‟s Legal SCAC.

M ISA07 I05 Interchange ID Qualifier M ID 2/2 Qualifier to designate the system/method of code structure used to designate the sender or receiver ID element being qualified.

ZZ for test (Sandbox)

(6)

M ISA08 I07 Interchange Receiver ID M AN 15/15 Identification code published by the receiver of the data; When sending, it is used by the sender as their sending ID, thus other parties sending to them will use this as a receiving ID to route data to them

NISTEVO or NVTxxxxxxxxx for Test (Sandbox) 048599448 or NVOxxxxxxxxx for production

Note: use NVTxxxxxxxxx or NVOxxxxxxxxx to create unique Trading Partner relationships per Shipper (our TMS Customer) where xxxxxxxxx is usually the Shipper‟s DUNS Number.

M ISA09 I08 Interchange Date M DT 6/6 Date of the interchange

M ISA10 I09 Interchange Time M TM 4/4 Time of the interchange

M ISA11 I65 Repetition Separator M AN 1/1

Type is not applicable; the repetition separator is a delimiter and not a data element; this field provides the delimiter used to separate repeated occurrences of a simple data element or a composite data structure; this value must be different than the data element separator, component element separator, and the segment terminator

The repetition separator is "^"

M ISA12 I11 Interchange Control Version Number M ID 5/5 This version number covers the interchange control segments

00402 Standard Issued as ANSI X12.5-1997

M ISA13 I12 Interchange Control Number M N0 9/9 A control number assigned by the interchange sender

M ISA14 I13 Acknowledgment Requested M ID 1/1 Code sent by the sender to request an interchange acknowledgment (TA1)

0 No Acknowledgment Requested

M ISA15 I14 Usage Indicator M ID 1/1 Code to indicate whether data enclosed by this interchange envelope is test, production or information

P Production Data

T Test Data

M ISA16 I15 Component Element Separator M AN 1/1 Type is not applicable; the component element separator is a delimiter and not a data element; this field provides the delimiter used to separate component data elements within a composite data structure; this value must be different than the data element separator and the segment terminator

(7)

6

Segment:

GS

Functional Group Header Position: 0020

Loop:

Level: Heading

Max Use: 1

Purpose: To indicate the beginning of a functional group and to provide control information

Syntax Notes:

Semantic Notes: 1 GS04 is the group date.

2 GS05 is the group time.

3 The data interchange control number GS06 in this header must be identical to the same data

element in the associated functional group trailer, GE02.

Comments: 1 A functional group of related transaction sets, within the scope of X12 standards, consists of a collection of similar transaction sets enclosed by a functional group header and a functional group trailer.

Des. Element Name Attributes M GS01 479 Functional Identifier Code M ID 2/2

IM Motor Carrier Freight Details and Invoice (210)

M GS02 142 Application Sender's Code M AN 2/15 Code identifying party sending transmission; codes agreed to by trading partners Carrier‟s Legal SCAC code.

M GS03 124 Application Receiver’s Code M AN 2/15 Code identifying party receiving transmission; codes agreed to by trading partners NISTEVO or NVTxxxxxxxxx for Test (Sandbox)

048599448 or NVOxxxxxxxxx for production

M GS04 373 Date M DT 8/8 Date expressed as CCYYMMDD

M GS05 337 Time M TM 4/8 Time expressed in 24-hour clock time as follows: HHMM, or HHMMSS, or HHMMSSD, or HHMMSSDD, where H = hours (00-23), M = minutes (00-59), S = integer seconds (00-59) and DD = decimal seconds; decimal seconds are expressed as follows: D = tenths (0-9) and DD = hundredths (00-99)

M GS06 28 Group Control Number M N0 1/9 Assigned number originated and maintained by the sender

M GS07 455 Responsible Agency Code M ID 1/2

X Accredited Standards Committee X12

M GS08 480 Version / Release / Industry Identifier Code M AN 1/12

004020 Draft Standards Approved for Publication by ASC X12

(8)

Segment:

ST

Transaction Set Header Position: 0100 Loop: Level: Heading Usage: Mandatory Max Use: 1

Purpose: To indicate the start of a transaction set and to assign a control number

Syntax Notes:

Semantic Notes: 1 The transaction set identifier (ST01) is used by the translation routines of the interchange partners to select the appropriate transaction set definition (e.g., 810 selects the Invoice Transaction Set).

1 The implementation convention reference (ST03) is used by the translation routines of the interchange partners to select the appropriate implementation convention to match the transaction set definition.

Comments:

Des. Element Name Attributes M ST01 143 Transaction Set Identifier Code M ID 3/3

Code uniquely identifying a Transaction Set

210 Motor Carrier Freight Details and Invoice

M ST02 329 Transaction Set Control Number M AN 4/9 Identifying control number that must be unique within the transaction set functional group assigned by the originator for a transaction set.

THIS NUMBER SHOULD BE UNIQUE! We recommend following the

UCS guidelines by concatenating a 5-digit GS control number with a 4-digit incremental counter. For example, if your GS control number is 00123 and this is the third occurrence of the ST loop in this document, the value in ST02 would be 001230003.

(9)

8

Segment:

B3

Beginning Segment for Carrier’s Invoice Position: 0200

Loop:

Level: Heading

Max Use: 1

Purpose: To transmit basic data relating to the carrier‟s invoice

Syntax Notes: 1 If either B309 or B310 is present, then the other is required.

Semantic Notes: 1 B306 is the billing date.

1 On collect freight bills the data in B309 will be the actual delivery date. For the shipments invoiced prior to delivery, the B309 will be the estimated date of delivery.

1 If B314 is used, B304 will indicate the party or parties responsible for payment of the transportation terms identified in B314.

Comments:

Des. Element Name Attributes M B302 76 Invoice Number M AN 1/22

Identifying number assigned by issuer

M B303 145 Shipment Identification Number O AN 1/30 Identification number assigned to the shipment by the shipper that uniquely identifies the shipment from origin to ultimate destination and is not subject to modification; (Does not contain blanks or special characters)

Must match the SID in the Sterling TMS system to be processed.

M B304 146 Shipment Method of Payment M ID 2/2 Code identifying payment terms for transportation charges

CC Collect

CF Collect, Freight Credited Back to Customer

PC Prepaid but Charged to Customer

PP Prepaid (by Seller)

TP Third Party Pay

M B306 373 Date M DT 8/8 Date expressed as CCYYMMDD where CC represents the first two digits of the calendar year

Current Invoice Date

M B307 193 Net Amount Due M N2 1/12 Total charges to be paid by the receiver of this transaction set expressed in the standard monetary denomination for the currency specified

B308 202 Correction Indicator O ID 2/2 Code used to indicate that the transaction set contains information which corrects previous information

AD Adjustment of Previous Freight Bill Charges

This should be sent after the first invoice if there are new accessorial charges or changes to previous charges.

RB Rebilling (Ignore Previous Bill)

Rebillings are treated as replacements and should contain all freight invoice detail information.

M B311 140 Standard Carrier Alpha Code M ID 2/4 Standard Carrier Alpha Code

(10)

B312 373 Date O DT 8/8 Date expressed as CCYYMMDD where CC represents the first two digits of the calendar year

(11)

10

Segment:

C3

Currency Position: 0400

Loop:

Level: Heading

Usage: Optional (Recommended for Sterling TMS)

Max Use: 1

Purpose: To specify the currency being used in the transaction set

Syntax Notes:

Semantic Notes: 1 C301 is the billing currency.

2 C303 is the payment currency. 3 C304 is the rated currency.

Comments: 1 Currency is implied by the code for the country in whose currency the monetary amounts are specified.

Notes: This segment is recommended for Sterling TMS and should be sent when possible.

Note that if this segment is not supplied then the applicable “Contract” currency will be assumed.

Des. Element Name Attributes M C301 100 Currency Code M ID 3/3

Code (Standard ISO) for country in whose currency the charges are specified Any valid code may be placed in this element.

CAD Canadian Dollars

USD United States Dollars

MXN Mexican Pesos

(12)

Segment:

ITD

Terms of Sale/Deferred Terms of Sale Position: 0500 Loop: Level: Heading Usage: Optional Max Use: 1

Purpose: To specify terms of sale

Syntax Notes: 1 If ITD03 is present, then at least one of ITD04 ITD05 or ITD13 is required.

2 If ITD08 is present, then at least one of ITD04 ITD05 or ITD13 is required. 3 If ITD09 is present, then at least one of ITD10 or ITD11 is required.

Semantic Notes: 1 ITD15 is the percentage applied to a base amount used to determine a late payment charge.

Comments: 1 If the code in ITD01 is "04", then ITD07 or ITD09 is required and either ITD10 or ITD11 is required; if the code in ITD01 is "05", then ITD06 or ITD07 is required.

Notes: In general this segment is for backwards compatibility.

Des. Element Name Attributes ITD01 336 Terms Type Code O ID 2/2

Code identifying type of payment terms

Refer to 004020 Data Element Dictionary for acceptable code values.

ITD02 333 Terms Basis Date Code O ID 1/2

Code identifying the beginning of the terms period

ITD03 338 Terms Discount Percent O R 1/6

Terms discount percentage, expressed as a percent, available to the purchaser if an invoice is paid on or before the Terms Discount Due Date

ITD05 351 Terms Discount Days Due X N0 1/3 Number of days in the terms discount period by which payment is due if terms discount is earned

ITD07 386 Terms Net Days O N0 1/3

(13)

12

Segment:

N9

Reference Identification Position: 0600

Loop:

Level: Heading

Usage: Optional

Max Use: 300

Purpose: To transmit identifying information as specified by the Reference Identification Qualifier

Syntax Notes: 1 At least one of N902 or N903 is required.

2 If N906 is present, then N905 is required.

3 If either C04003 or C04004 is present, then the other is required. 4 If either C04005 or C04006 is present, then the other is required. Semantic Notes: 1 N906 reflects the time zone which the time reflects.

2 N907 contains data relating to the value cited in N902. Comments:

Des. Element Name Attributes M N901 128 Reference Identification Qualifier M ID 2/3

Code qualifying the Reference Identification

Refer to 004020 Data Element Dictionary for acceptable code values. See Appendix 1 for list of supported reference qualifiers.

N902 127 Reference Identification X AN 1/50 Reference information as defined for a particular Transaction Set or as specified by the Reference Identification Qualifier

N903 369 Free-form Description X AN 1/45

(14)

Segment:

R3

Route Information - Motor Position: 0800 Loop: Level: Heading Usage: Optional Max Use: 12

Purpose: To specify carrier and routing sequences and details

Syntax Notes: 1 If R311 is present, then R310 is required.

2 If R312 is present, then R311 is required.

Semantic Notes: 1 R303 is the station or city name at which carriers interchange shipments

2 R307 is the carrier's billing date. 3 R308 is the amount due the carrier. Comments:

Des. Element Name Attributes M R301 140 Standard Carrier Alpha Code M ID 2/4

Standard Carrier Alpha Code

M R302 133 Routing Sequence Code M ID 1/2

Code describing the relationship of a carrier to a specific shipment movement Refer to 004020 Data Element Dictionary for acceptable code values.

R304 91 Transportation Method/Type Code O ID 1/2

Code specifying the method or type of transportation for the shipment

A Air

H Customer Pickup

LT Less Than Trailer Load (LTL)

M Motor (Common Carrier)

O Containerized Ocean

R Rail

U Private Parcel Service

X Intermodal (Piggyback)

(15)

14 Segment:

K1

Remarks Position: 1000 Loop: Level: Heading Usage: Optional Max Use: 10

Purpose: To transmit information in a free-form format for comment or special instruction

Des. Element Name Attributes M K101 61 Free-Form Message M AN 1/30

Free-form information

K102 61 Free-Form Message O AN 1/30

(16)

Segment:

N1

Name Position: 1100

Loop: 0100 Optional

Level: Heading

Usage: Optional (Mandatory for Sterling TMS)

Max Use: 1

Purpose: To identify a party by type of organization, name, and code

2 If either N103 or N104 is present, then the other is required. Semantic Notes:

Comments: 1 This segment, used alone, provides the most efficient method of providing organizational identification. To obtain this efficiency the "ID Code" (N104) must provide a key to the table maintained by the transaction processing party.

2 N105 and N106 further define the type of entity in N101.

Notes: The N1 “SH” segment is used to identify the Sterling TMS‟s Subscriber Organization Id.

Sterling TMS often refers to its subscriber as the “Shipper” or the “Shipment Owner”.

Des. Element Name Attributes M N101 98 Entity Identifier Code M ID 2/3

Code identifying an organizational entity, a physical location, property or an individual

BT Bill-to-Party

Optional N1 Segment Usage

Used to indicate the Bill-to-Party Name, Bill-to-Party Organization Id, and Bill-to-Party Address Information.. N104 contains the DUNS Number of the Party that should be Billed for this Freight Invoice. Note that the N104 will also be used as the Shipment Owner Organization if it is not supplied in the N1 “SH” or “PR” segments.

PE Payee

N104 contains the SCAC or DUNS Number of the Party that should be paid for this Freight Invoice.

PF Party to Receive Freight Bill

(17)

16

PR Payer

N104 contains the DUNS Number of the Party that should be Paying for this Freight Invoice. Note that the N104 will also be used as the Shipment Owner Organization if it is not supplied in the N1 “SH” segment.

SH Shipper

Mandatory N1 Segment Usage

N104 contains the DUNS Number of the Shipper. If the Shipper is Multi-Org Shipper then this is their Child-Org DUNS Number. Note that it is mandatory to provide the Shipment Owner Organization Id.

This is the Shipment Owner Organization.

N102 93 Name X AN 1/60 Free-form name

N103 66 Identification Code Qualifier X ID 1/2 Code designating the system/method of code structure used for Identification Code (67)

1 D-U-N-S Number, Dun & Bradstreet

2 Standard Carrier Alpha Code (SCAC)

N104 67 Identification Code X AN 2/80 Code identifying a party or other code

(18)

Segment:

N3

Address Information Position: 1300 Loop: 0100 Optional Level: Heading Usage: Optional Max Use: 2

Purpose: To specify the location of the named party

Notes: Use the N3 to identify Bill-to-party Address.

Des. Element Name Attributes M N301 166 Address Information M AN 1/55

Address information

(19)

18

Segment:

N4

Geographic Location Position: 1400

Level: Heading

Usage: Optional

Max Use: 1

Purpose: To specify the geographic place of the named party

Syntax Notes: 1 Only one of N402 or N407 may be present.

2 If N406 is present, then N405 is required. 3 If N407 is present, then N404 is required. Semantic Notes:

Comments: 1 A combination of either N401 through N404, or N405 and N406 may be adequate to specify a location.

2 N402 is required only if city name (N401) is in the U.S. or Canada. Notes: Use the N4 to identify Bill-to-party City, State, and Postal Code.

Des. Element Name Attributes N401 19 City Name O AN 2/30

Free-form text for city name

N402 156 State or Province Code X ID 2/2 Code (Standard State/Province) as defined by appropriate government agency

N403 116 Postal Code O ID 3/15 Code defining international postal zone code excluding punctuation and blanks (zip code for United States)

(20)

Segment:

N7

Equipment Details Position: 1600 Loop: 0200 Optional Level: Heading Usage: Optional Max Use: 1

Purpose: To identify the equipment

Syntax Notes: 1 If either N703 or N704 is present, then the other is required.

2 If either N705 or N716 is present, then the other is required. 3 If either N708 or N709 is present, then the other is required. Semantic Notes: 1 N712 is the owner of the equipment.

2 N723 is the operator or carrier of the rights of the equipment. Comments: 1 N701 is mandatory for rail transactions.

2 N720 and N721 are expressed in inches.

Des. Element Name Attributes N701 206 Equipment Initial O AN 1/4

Prefix or alphabetic part of an equipment unit's identifying number

M N702 207 Equipment Number M AN 1/10

Sequencing or serial part of an equipment unit's identifying number (pure numeric form for equipment number is preferred)

N711 40 Equipment Description Code O ID 2/2

Code identifying type of equipment used for shipment

N715 567 Equipment Length O N0 4/5

Length (in feet and inches) of equipment ordered or used to transport shipment (The format is FFFII where FFF is feet and II is inches; the range for II is 00 through 11)

N722 24 Equipment Type O ID 4/4

(21)

20

Segment:

S5

Stop-off Details Position: 0100

Level: Detail

Usage: Optional

Max Use: 1

Purpose: To specify stop-off detail reference numbers and stop reason

Syntax Notes: 1 If either S503 or S504 is present, then the other is required.

2 If either S505 or S506 is present, then the other is required. 3 If either S507 or S508 is present, then the other is required. Semantic Notes: 1 S509 is the stop reason description.

Comments:

Notes: In general this segment is for backwards compatibility only.

Des. Element Name Attributes M S501 165 Stop Sequence Number M N0 1/3

Identifying number for the specific stop and the sequence in which the stop is to be performed

M S502 163 Stop Reason Code M ID 2/2

Code specifying the reason for the stop

(22)

Segment:

N9

Reference Identification Position: 0200 Loop: 0300 Optional Level: Detail Usage: Optional Max Use: 10

(23)

22 Segment:

G62

Date/Time Position: 0300 Loop: 0300 Optional Level: Detail Usage: Optional Max Use: 10

Purpose: To specify pertinent dates and times

Syntax Notes: 1 At least one of G6201 or G6203 is required.

2 If either G6201 or G6202 is present, then the other is required. 3 If either G6203 or G6204 is present, then the other is required. Semantic Notes:

Comments:

Des. Element Name Attributes G6201 432 Date Qualifier X ID 2/2

Code specifying type of date

G6202 373 Date X DT 8/8 Date expressed as CCYYMMDD

G6203 176 Time Qualifier X ID 1/2 Code specifying the reported time

G6204 337 Time X TM 4/8 Time expressed in 24-hour clock time as follows: HHMM, or HHMMSS, or HHMMSSD, or HHMMSSDD, where H = hours (00-23), M = minutes (00-59), S = integer seconds (00-59) and DD = decimal seconds; decimal seconds are expressed as follows: D = tenths (0-9) and DD = hundredths (00-99)

G6205 623 Time Code O ID 2/2

Code identifying the time. In accordance with International Standards

Organization standard 8601, time can be specified by a + or - and an indication in hours in relation to Universal Time Coordinate (UTC) time; since + is a restricted character, + and - are substituted by P and M in the codes that follow

(24)

Segment:

N1

Name Position: 0500 Loop: 0310 Optional Level: Detail Usage: Optional Max Use: 1

Purpose: To identify a party by type of organization, name, and code

2 If either N103 or N104 is present, then the other is required. Semantic Notes:

Comments: 1 This segment, used alone, provides the most efficient method of providing organizational identification. To obtain this efficiency the "ID Code" (N104) must provide a key to the table maintained by the transaction processing party.

2 N105 and N106 further define the type of entity in N101. Notes: In general this segment is for backwards compatibility only.

Des. Element Name Attributes M N101 98 Entity Identifier Code M ID 2/3

Code identifying an organizational entity, a physical location, property or an individual

SF Ship From

ST Ship To

N102 93 Name X AN 1/60 Free-form name

N103 66 Identification Code Qualifier X ID 1/2 Code designating the system/method of code structure used for Identification Code (67)

N104 67 Identification Code X AN 2/80 Code identifying a party or other code

(25)

24

Segment: Segment:

N3

Address Information Position: 0700

Level: Detail

Usage: Optional

Max Use: 2

Purpose: To specify the location of the named party

Des. Element Name Attributes M N301 166 Address Information M AN 1/55

Address information

N302 166 Address Information O AN 1/55

(26)

Segment:

N4

Geographic Location Position: 0800 Loop: 0310 Optional Level: Detail Usage: Optional Max Use: 1

Purpose: To specify the geographic place of the named party

Syntax Notes: 1 Only one of N402 or N407 may be present.

2 If N406 is present, then N405 is required. 3 If N407 is present, then N404 is required. Semantic Notes:

Comments: 1 A combination of either N401 through N404, or N405 and N406 may be adequate to specify a location.

2 N402 is required only if city name (N401) is in the U.S. or Canada. Notes: In general this segment is for backwards compatibility only.

Des. Element Name Attributes N401 19 City Name O AN 2/30

Free-form text for city name

N402 156 State or Province Code X ID 2/2 Code (Standard State/Province) as defined by appropriate government agency

N403 116 Postal Code O ID 3/15

Code defining international postal zone code excluding punctuation and blanks (zip code for United States)

(27)

26

Segment:

N9

Level: Detail

Usage: Optional

Max Use: 5

(28)

Segment:

LX

Assigned Number Position: 1200

Level: Detail

Usage: Optional (Mandatory for Sterling TMS)

Max Use: 1

Purpose: To reference a line number in a transaction set

Des. Element Name Attributes M LX01 554 Assigned Number M N0 1/6

(29)

28

Segment:

N9

Level: Detail

Usage: Optional

Max Use: 5

Notes: This segment is used to indicate the Location of the Freight Cost Detail

See Appendix 1 for a list of valid reference qualifiers.

LU Location Number

Used to indicate the Location of the Freight Cost Detail

N903 369 Free-form Description X AN 1/45

(30)

Segment:

L5

Description, Marks and Numbers Position: 1400 Loop: 0400 Optional Level: Detail Usage: Optional Max Use: 30

Purpose: To specify the line item in terms of description, quantity, packaging, and marks and numbers

Syntax Notes: 1 If either L503 or L504 is present, then the other is required.

2 If L507 is present, then L506 is required.

3 If either L508 or L509 is present, then the other is required. Semantic Notes:

Comments: 1 L502 may be used to send quantity information as part of the product description.

Des. Element Name Attributes L501 213 Lading Line Item Number O N0 1/3

Sequential line number for a lading item

L502 79 Lading Description O AN 1/50

Description of an item as required for rating and billing purposes

L503 22 Commodity Code X AN 1/30

Code describing a commodity or group of commodities

L504 23 Commodity Code Qualifier X ID 1/1

Code identifying the commodity coding system used for Commodity Code Refer to 004020 Data Element Dictionary for acceptable code values.

L508 23 Commodity Code Qualifier X ID 1/1

Code identifying the commodity coding system used for Commodity Code Refer to 004020 Data Element Dictionary for acceptable code values.

L509 22 Commodity Code X AN 1/30

(31)

30

Segment:

L0

Line Item - Quantity and Weight Position: 1700

Level: Detail

Usage: Optional

Max Use: 10

Purpose: To specify quantity, weight, volume, and type of service for a line item including applicable "quantity/rate-as" data

2 If either L004 or L005 is present, then the other is required. 3 If either L006 or L007 is present, then the other is required. 4 If either L008 or L009 is present, then the other is required. 5 If L011 is present, then L004 is required.

6 If either L013 or L015 is present, then the other is required.

Semantic Notes: 1 L008 is the number of handling units of the line item tendered to the carrier.

2 L013 can only be used if the code in L009 is PLT, SKD, or SLP.

3 L015 designates whether the carrier will be required to verify the number of units contained

on a pallet, slip sheet or skid. Code "Y" indicates that the carrier will be required to verify. Code "N" indicates that the carrier will not be required to verify.

Comments: 1 L013 is used to convey the total number of boxes, cartons, or pieces contained on a pallet, skid, or slip sheet for the line item.

Des. Element Name Attributes L001 213 Lading Line Item Number O N0 1/3

L002 220 Billed/Rated-as Quantity X R 1/11 Basis for rating (miles, value, volume, etc.); Note: Weight may be defined by either data element 220 or 81

L003 221 Billed/Rated-as Qualifier X ID 2/2 Code identifying the type of quantity or value on which the rate or item pricing is based

(32)

Segment:

L1

Rate and Charges Position: 1800

Loop: 0400

Level: Detail

Usage: Optional (Recommended for Sterling TMS)

Max Use: 10

Purpose: To specify rate and charges detail relative to a line item including freight charges, advances, special charges, and entitlements

2 At least one of L104 L105 or L106 is required.

3 If either L114 or L115 is present, then the other is required. 4 If either L117 or L118 is present, then the other is required. Semantic Notes: 1 L119 is the percent used to determine the charge in L104.

2 L120, if used, indicates the currency for all monetary amounts in this L1 segment. 3 L121 is the origin rated as charge amount.

Comments:

Notes: This segment is used to indicate the Invoice Line Detail Rated Quantity, Charge Rate, and

Charge Amount. Its usage is preferred and recommended over the L0 segment.

Des. Element Name Attributes L101 213 Lading Line Item Number O N0 1/3

L102 60 Freight Rate X R 1/9 Rate that applies to the specific commodity

Invoice Line Detail – Charge Rate

L103 122 Rate/Value Qualifier X ID 2/2 Code qualifying how to extend charges or interpret value

See your Shipper‟s List of accepted and valid codes.

AG Percentage

AV Ad Valorum (Per Cent of Value) [Percentage]

BR Per Barrel

CM Per Cubic Meter

CW Per Hundred Weight

Describes a transportation rate that applies to every one hundred pounds of total weight of an individual shipment

FR Flat Rate

FT Per Foot

KG Per Kilograms

KP Per Kilometer

LB Per Pound

(33)

32

L104 58 Charge X N2 1/12 For a line item: freight or special charge; for the total invoice: the total charges -- expressed in the standard monetary denomination for the currency specified Invoice Line Detail – Charge Amount

L108 150 Special Charge or Allowance Code O ID 3/3 Code identifying type of special charge or allowance

Used to indicate whether the Invoice Line Detail refers to an additional Special Charge or Allowance (the L108 is supplied) or to the Standard Line Haul Charge (when the L108 is not present). Always supply the L108 element to indicate a

Special Charge or Allowance accessorial.

See your Shipper‟s List of accepted and valid codes. Also see Appendix 2 for list of supported code values.

L112 276 Special Charge Description O AN 2/25 Identification of special charge; this data element is used whenever an applicable code cannot be found in data element 150

Invoice Line Detail – Charge Description

L117 220 Billed/Rated-as Quantity X R 1/11 Basis for rating (miles, value, volume, etc.); Note: Weight may be defined by either data element 220 or 81

Invoice Line Detail – Rated Quantity

L118 221 Billed/Rated-as Qualifier X ID 2/2 Code identifying the type of quantity or value on which the rate or item pricing is based

See your Shipper‟s List of accepted and valid codes.

BA Barrels

Identifies a billable unit expressed as a type of container

CF Cubic Foot DK Kilometers DM Miles EA Each FR Flat Rate FT Foot GL Gallon KG Kilogram LB Pound LC 100 Pounds MV Monetary Value NP Piece NU Unit

A specific measurement in rating shipments

SP Stops

Identifies a billable unit expressed as stops that are authorized as part of a shipment of goods

TD Days

TH Hours

TN Tons

(34)

L120 100 Currency Code O ID 3/3 Code (Standard ISO) for country in whose currency the charges are specified Use only if the currency for this specific charge is different than specified in the C3 segment at the heading level of the transaction.

Note that any valid code may be placed in this element.

CAD Canadian Dollars

USD United States Dollars

MXN Mexican Pesos

(35)

34

Segment:

SE

Transaction Set Trailer Position: 0200

Loop:

Level: Summary

Max Use: 1

Purpose: To indicate the end of the transaction set and provide the count of the transmitted segments (including the beginning (ST) and ending (SE) segments)

Syntax Notes: Semantic Notes:

Comments: 1 SE is the last segment of each transaction set.

Des. Element Name Attributes M SE01 96 Number of Included Segments M N0 1/10

Total number of segments included in a transaction set including ST and SE segments

(36)

Segment:

GE

Functional Group Trailer Position: 0210 Loop: Level: Summary Usage: Mandatory Max Use: 1

Purpose: To indicate the end of a functional group and to provide control information

Syntax Notes:

Semantic Notes: 1 The data interchange control number GE02 in this trailer must be identical to the same data element in the associated functional group header, GS06.

Comments: 1 The use of identical data interchange control numbers in the associated functional group header and trailer is designed to maximize functional group integrity. The control number is the same as that used in the corresponding header.

Des. Element Name Attributes M GE01 97 Number of Transaction Sets Included M N0 1/6 Total number of transaction sets included in the functional group or interchange (transmission) group terminated by the trailer containing this data element

(37)

36

Segment:

IEA

Interchange Control Trailer Position: 0220

Loop:

Level: Summary

Max Use: 1

Purpose: To define the end of an interchange of zero or more functional groups and interchange-related control segments

Des. Element Name Attributes M IEA01 I16 Number of Included Functional Groups M N0 1/5

A count of the number of functional groups included in an interchange

(38)

APPENDIX 1 Reference Number Qualifiers

This section lists all the valid reference number qualifiers allowed by Sterling TMS. SI Shippers Identifying Number for Shipment (SID)

12 Billing Account 1P Accessorial Status Code 2I Tracking Number

4M Special Move Reference Number 6A Consignee Reference Number AO Appointment Number

BL Government Bill of Lading Number BM Bill of Lading Number

BN Booking Number CB Combined Shipment CG Consignee's Order Number CK Check Number

CMN Continuous Move Id

CN Carrier's Reference Number (PRO/Invoice) CO Customer Order Number

CR Customer Reference Number CT Contract Number

DJ Delivery Ticket Number

DK Dock Number

DO Delivery Order Number DP Department Number EV Receiving Number F8 Original Reference Number FR Freight Bill Number

GD Return Goods Bill of Lading Number GZ General Ledger Account

HO Shipper's Hazardous Number IA Internal Vendor Number IF Issue Number

IK Invoice Number IL Internal Order Number IN Consignee's Invoice Number IT Internal Customer Number K0 Approval Code

(39)

38 PO Purchase Order Number

PU Previous Bill of Lading Number PV Receiving Number

RE Release Number

RF Export Reference Number

RN Run Number

RP Repetitive Pattern Code S8 Seal Off Number S9 Seal On Number

SCA Standard Carrier Alpha Code (SCAC) SN Seal Number

SO Shipper's Sales Order Number [Shipper's Order (Invoice Number)] ST Store Number

TB Trucker's Bill of Lading

TK Tank Number

VN Vendor Order Number WY Waybill Number

(40)

APPENDIX 2 Special Charge or Allowance Code values

This section lists all the valid Special Charge or Allowance code values allowed by Sterling TMS. 020 Address Correction

045 Advance Fee

105 Acknowledgment of Delivery Fee (AOD) 140 Call Tag

160 Canadian Reconsignment Fee 240 Customs Broker Fee

250 Customs Invoice - Additional Page 275 Discount - Incentive

280 Discount - Multiple Shipment 295 Discount - Special 300 Distribution Fee 400 Freight 405 Fuel Surcharge 445 Insurance Fee 455 Insurance Premium 485 Messenger Service 520 Oversized Premium 665 Saturday Delivery 675 Security Signature Service 705 Stamp Fee

735 Tracing Inbound Via Other Carriers ADH Advance Charges Handling

AFB Additional Copies of Freight Bill AIR Air Freight

APT Appointment (Notification)

ARB Arbitrary (In Addition to Through Rates and Charges) BEY Beyond Freight Charges

BLC Bill of Lading Charge BLK Blocking and Bracing Charge BND Bond Charges

BOB Bobtail Charges BUA Bunker Adjustment

CHE Chassis Equipment Lease Charge CLN Cleaning Charge

CNS Consolidation

COD COD Amount

COF Ocean Freight

(41)

40 DEL Delivery Charge

DEM Demurrage

DEP Detention of Power Units DER Derrick Charge

DES Demurrage - Special DET Detention of Trailers DIS Distribution Service

DIV Diversion and Reconsignment DLH Drayage/Line Haul

DMC Deadhead Mileage Charge DOC Documentation Charge

DRC Drayage

DSC Discount

DSF Detention - Special Type Flat Car DST Container Destuffing

DTD Destination Duty

DTF Destination Inland Freight DTL Detention Loading DTU Detention Unloading DTV Detention (Vehicle)

ECR Escort/Courier Service Charge EIC Export/Import Charge ELS Extra Lights

ERS Empty Return

EVC Excessive Value Charge EXC Exclusive Use Charge EXM Excess Mileage Charge EXP Expedited Service Charge EXW Excess Weight

FAH Freight Surcharge FUE Fuel Charge

FWA Forwarding Agent Commission GST Goods and Services Tax Charge

HAN Handling Charges on Distribution Freight Forwarded Beyond HAZ Hazardous Cargo Charge

HHB Handling

HOL Sunday or Holiday Pick-up or Delivery HOS Hose Charge

HOX Hose Charge Special IDL Inside Delivery

IFC Inbound Freight Charges IHT Interstate/Highway Toll IIA Invoice Adjustment INC Insurance Surcharge INS Insurance

IPU Inside Pick-up

LAB Extra Labor (Helper Service) LAY Layover Charges

LDG Loading

LEC Less than Container

LFT Lift Gate (Truck) or Forklift Service at Pick-up/Delivery LMC Labor, Modify

(42)

MEN Escort Service with Overnight Subsistence MET Escort Service (Telephone)

MFC Manifest Charge MIN Minimum Guarantee MNC Notify Consignee

MPC Miscellaneous Parts Charge MRK Marking or Tagging Charge MSC Other Accessorial Service Charge MSG Miscellaneous Charge

NFY Carrier Notification Charge OVR Over Dimension

PBE Permits Bonds Escort Attendant PEC Pallet Exchange Charge

PER Permit Charge

PIR Pier Pick-up and/or Delivery PLT Pallets/Skids/Platforms PMU Normal Pump Charge PMX Special Pump Charge POD Proof of Delivery POS Positioning at Origin PRS Stuffing Charge

PSC Protective Service - Cold PSH Protective Service - Heat PUC Pick-up Charge

PUD Pick-up and Delivery PUK Pack and Unpack PWH Pier Charges - Wharfage RCC Reconsignment Charge RCL Redelivery

REE Regulatory Fee REP Residential Pick-up RES Residential Delivery

RFD Refund

SAT Saturday Pick-up or Delivery Charge SCL Scale Charge

SCU Scale Charge Unloading SDC Special Detention Charge SDL Split Delivery

(43)

42 TAA Telephone Charge

TAX Tax Charge TDT Truck Detention TER Terminal Charge TRA Travel Charge TRC Trailer Rental Charge TRF Transfer Charge UND Unloading

UNL Unloading (Labor Charges) URC Unloading/Reloading Charge USW Unabsorbed Switching VOR Vehicle Ordered but Not Used

WFG Wharfage

WFH Wharfage & Handling WHC Warehouse Charge WRC Load Weighing Charge WRE Empty Weighing Charge WTG Waiting Time

(44)

(45)

44

EDI SAMPLE USAGE

Example 1

Description

 This example is for a shipment that has two charges o Line-haul is $300 for 200 miles at $1.50 per mile. o Detention charge of $100 for 2 hours at $50.00 per hour.

EDI Transaction

ISA*00* *00* *02*SCAC *ZZ*NISTEVO *030818*2300*^*00402*000000001*0*P*|~ GS*IM*SCAC*NISTEVO*20030818*2300*00001*X*004020~ ST*210*000000001~ B3**CARRIER-INVOICE-01*SID*PP**20030818*40000****SCAC~ C3*USD~ N9*CN*CARRIER-PRO-NUM~ N1*SH*SHIPPER*1*DUNS~ N1*BT*SENDBILLHERE*1*DUNS~ N3*123 FIRST AVENUE~ N4*MPLS*MN*55402*USA~ LX*1~

L1**1.5*PM*30000********LINE HAUL CHARGE*****200*DM~ LX*2~

L1**50*PR*10000****DET****DETENTION CHARGE*****2*TH~ SE*13*000000001~

(46)

Example 2

Description

 This invoice is a second invoice for the same shipment used in Example 1. In this case, there has been a new accessorial charge added to the shipment.

o Unloading charge of $70 for 2 hours at $35.00 per hour.

EDI Transaction

(47)

46

Example 3

Description

 This invoice is a third invoice for the same shipment used in Example 1and 2. In this case the line-haul charge has been re-rated at a new rate.

o Line-haul was $300 for 200 miles at $1.50 per mile. o Line-haul is now $350 for 200 miles at $1.75 per mile. o Difference is $50 for 200 miles at $0.25 per mile.

EDI Transaction

ISA*00* *00* *02*SCAC *ZZ*NISTEVO *030818*2300*^*00402*000000003*0*P*|~ GS*IM*SCAC*NISTEVO*20030818*2300*00003*X*004020~ ST*210*000000001~ B3**CARRIER-INVOICE-02*SID*PP**20030818*40000*AD***SCAC~ C3*USD~ N9*CN*CARRIER-PRO-NUM~ N1*SH*SHIPPER*1*DUNS~ N1*BT*SENDBILLHERE*1*DUNS~ N3*123 FIRST AVENUE~ N4*MPLS*MN*55402*USA~ LX*1~

L1**0.25*PM*5000******** LINE HAUL CHARGE *****200*DM~ SE*11*000000001~

(48)

Carrier. Invoice. EDI 210 Format X12 Version Inbound. Revised: August 25, 2011 Version:

Carrier

Invoice

EDI–210 Format

X12 Version 004020

Inbound

Revised:

August 25, 2011

Version:

2.01.21

EXECUTIVE SUMMARY

Special Characters

EDI FORMAT

210 Motor Carrier Freight Details and Invoice

IM

Introduction:

Heading:

Detail:

Transaction Set Notes

ISA

GS

ST

B3

C3

ITD

N9

R3

K1

N1

N3

N4

N7

S5

N9

G62

N1

N3

N4

N9

LX

N9

L5

L0

L1

SE

GE

IEA

APPENDIX 1

Reference Number Qualifiers

APPENDIX 2

Special Charge or Allowance Code values

EDI SAMPLE USAGE

Example 1

Example 2

Example 3

Document Change Log

2.01.2

04/08/2003 New Document.

2.01.3

04/10/2003 Removed ID code lists for L1 segment – direct carrier to get this from the shipper.

Corrected a number of incorrect codes and comments.

2.01.4

05/31/2005 Added Appendix 2 – Special Charge or Allowance Code values

2.01.5

08/03/2005 Added list of Sterling TMS supported L103 and L118 values.

2.01.6

09/15/2005 Added new B308 Correction Indicator value – Rebilling (RB)

2.01.7

01/10/2006 Added new Location Number Reference – LU, etc.

2.01.8

05/31/2006 Added new Special Charge or Allowance Code values.

2.01.9

04/27/2007 Added ISA08/GS03 options.

2.01.10

07/25/2007 Added new Special Charge or Allowance Code values.

2.01.11

07/30/2007 Rebranded references from Nistevo to Sterling TMS where appropriate.

2.01.12

11/05/2007 Update Currency Codes and added some “undocumented” segments.

2.01.13