toyota motor sales usa inc -...

119
Toyota Motor Sales, USA Inc. North American Parts Operations Guidelines for EDI Trading Partners November 2003 TMS

Upload: ngominh

Post on 08-May-2018

234 views

Category:

Documents


2 download

TRANSCRIPT

Toyota Motor Sales, USA Inc.

North American Parts Operations

Guidelines for EDI Trading Partners

November 2003

TMS

2

Table of Contents

Introduction ......................................................................................................................................................................... 5

Summary of EDI Procedures .............................................................................................................................................. 5

Requirements for TMS Trading Partners ......................................................................................................................... 5

Communications .................................................................................................................................................................. 6

Required Delimiters ............................................................................................................................................................. 6

Mailbox Delivery and Retrieval ......................................................................................................................................... 7

How to Use the TMS Mailbox System ............................................................................................................................... 7

TMS EDI Testing Process ................................................................................................................................................... 9

Transactions Timing .......................................................................................................................................................... 10

Points of Contact at TMS .................................................................................................................................................. 10

ISA Segment ....................................................................................................................................................................... 11

GS Segment ........................................................................................................................................................................ 12

TRANSACTIONS SENT TO TMS .................................................................................................................................. 13

810 - Invoices ...................................................................................................................................................................... 14 BIG - Beginning Segment ............................................................................................................................................... 16 REF - Reference Numbers Segment................................................................................................................................ 17 N1 - Name Segment - Header Level ............................................................................................................................... 18 DTM - Date/Time Reference Segment ........................................................................................................................... 19 IT1 - Baseline Item Data Segment .................................................................................................................................. 20 TDS - Total Monetary Value Summary Segment ........................................................................................................... 21 TXI - Taxes ..................................................................................................................................................................... 22 ITA - Allowance, Charge, or Service Segment ............................................................................................................... 24 CTT - Transaction Totals Segment ................................................................................................................................. 27

856 - Advance Shipment Notice ........................................................................................................................................ 28 BSN - Beginning Segment .............................................................................................................................................. 30 DTM - Date/Time Reference Segment ........................................................................................................................... 31 HL - Hierarchical Level Segment – Shipment Level ...................................................................................................... 32 MEA - Measurement Segment -Shipment Level ............................................................................................................. 33 TD1 - Carrier Detail (Quantity) Segment – Shipment Level ........................................................................................... 34 TD5 - Carrier Detail (Routing Sequence) Segment – Shipment Level ........................................................................... 35 REF - Reference Numbers Segment - Shipment Level .................................................................................................. 36 N1 - Name – Shipment Level .......................................................................................................................................... 37 HL - Hierarchical Level Segment - Order Level ............................................................................................................. 38 PRF - Purchase Order Reference Segment – Order Level .............................................................................................. 39 REF - Reference Numbers Segment – Order Level ........................................................................................................ 40

3

N1 - Name Segment – Order Level ................................................................................................................................. 41 HL - Hierarchical Level Segment - Item Level ............................................................................................................... 42 LIN - Item Identification Segment – Item Level ............................................................................................................. 43 SN1 - Item Detail Shipment Segment – Item Level ........................................................................................................ 44 CTT - Transaction Totals Segment ................................................................................................................................. 45

TRANSACTIONS SENT FROM TMS ........................................................................................................................... 46

820 Remittance Advice ...................................................................................................................................................... 47 BPR - Beginning Segment for Remittance ...................................................................................................................... 49 REF - Reference Numbers Segment................................................................................................................................ 50 DTM - Date/Time Segment ............................................................................................................................................ 51 N1 - Name Segment ........................................................................................................................................................ 52 ENT - Entity Segment ..................................................................................................................................................... 53 ADX - Adjustment Segment ........................................................................................................................................... 54 IT1 - Baseline Item Data (Invoice) Segment ................................................................................................................... 55 RMR - Remittance Advice Segment ............................................................................................................................... 56 IT1 - Baseline Item Data (Invoice) ................................................................................................................................. 57 ITA - Allowance, Charge, Service Segment ................................................................................................................... 58

824 Application Advice ..................................................................................................................................................... 61 BGN - Application Advice Beginning Segment ............................................................................................................. 64 N1 - Name Segment ........................................................................................................................................................ 65 OTI - Original Transaction Identification Segment ........................................................................................................ 66 REF - Reference Numbers Segment................................................................................................................................ 67 DTM - Date/Time Reference Segment ........................................................................................................................... 68 QTY - Quantity Segment ................................................................................................................................................ 69 TED - Technical Error Segment ..................................................................................................................................... 70

830 Material Release ......................................................................................................................................................... 71 BFR - Beginning Planning Schedule Segment ................................................................................................................ 73 N1 - Name Segment ........................................................................................................................................................ 74 PER - Administrative Communication Contact Segment ................................................................................................ 75 LIN - Item Identification Segment .................................................................................................................................. 76 UIT - Unit Detail Segment .............................................................................................................................................. 77 N1 - Name Segment ........................................................................................................................................................ 78 N2 - Additional Name information Segment .................................................................................................................. 79 N3 - Address Information Segment ................................................................................................................................. 80 SDP - Ship/Delivery Pattern Segment ............................................................................................................................. 81 FST - Forecast Schedule Segment .................................................................................................................................. 82 CTT - Transaction Totals Segment ................................................................................................................................. 84

861 Receiving Advice ......................................................................................................................................................... 85 BRA - Receiving Advice Beginning Segment ................................................................................................................ 87 DTM - Date/Time Segment ............................................................................................................................................ 88 N1 - Name Segment ........................................................................................................................................................ 89 RCD - Receiving Conditions Segment ............................................................................................................................ 90 SN1 - Item Detail (Shipment) Segment ........................................................................................................................... 91 LIN - Item Identification Segment .................................................................................................................................. 92 PRF - Purchase Order Reference Segment ...................................................................................................................... 93 CTT - Transaction Total Segment ................................................................................................................................. 94

862 Shipping Schedule ....................................................................................................................................................... 95 BSS - Shipping Schedule Beginning Segment ................................................................................................................ 97 N1 - Name Segment ........................................................................................................................................................ 98

4

N2 - Additional Name information Segment ................................................................................................................ 100 N4 - Geographical Location Segment ........................................................................................................................... 101 REF - Reference Number .............................................................................................................................................. 102 LIN - Item Identification Segment ................................................................................................................................ 103 UIT - Unit Detail Segment ............................................................................................................................................ 104 REF - Reference Number .............................................................................................................................................. 105 FST - Forecast Schedule Segment ................................................................................................................................ 106 TD5 - Carrier Detail Segment ....................................................................................................................................... 107 CTT - Transaction Totals Segment ............................................................................................................................... 108

Samples of TMS Transactions ........................................................................................................................................ 109 856 Samples .................................................................................................................................................................. 110 861 Sample ................................................................................................................................................................... 115 820 Sample ................................................................................................................................................................... 116 824 Sample ................................................................................................................................................................... 117 830/862 Monthly Order Sample ................................................................................................................................... 118 830/862 Supplemental Order Sample ........................................................................................................................... 118 830/862 VOR Order Sample ......................................................................................................................................... 118 830/862 Daily Order Sample ........................................................................................................................................ 119 830 Monthly Preorder – Daily Order Part Sample ........................................................................................................ 119 830 Monthly Forecast – Monthly Ordered Part With No Firm Order Qty Sample ....................................................... 119

5

Introduction

This document describes the Electronic Data Interchange (EDI) concept and how it will be applied at

Toyota Motor Sales USA, Inc. (TMS). It includes data formats and communication specifications

which will be necessary for the transmittal of data between the supplier and TMS.

Summary of EDI Procedures

EDI refers to the electronic exchange of information which follows specific standards. When

interacting with TMS, EDI involves the following basic steps:

1. The sender transmits EDI data to the Connect mailbox that resides at TMS.

2. The receiver accesses the EDI Connect mailbox and retrieves the data that has been

transmitted by the sender.

3. The receiver then translates the retrieved EDI data into a format that is usable by

the appropriate application depending on the type of data transmitted.

Requirements for TMS Trading Partners

While many standards exist for data transmission, TMS will recognize only those which meet the

ANSI X12 standards for our EDI applications. Specifically, TMS uses the Automotive Industry

Action Group (AIAG) sub-standards of the ANSI X12 standards. The TMS transaction version

number correlates to the AIAG implementation guidelines used in developing each transaction set.

TMS may use any code specified in the AIAG standard as well as any additional codes that are not

specified in the AIAG standard as the need may arise.

6

Communications

All EDI transactions are based on an “Electronic Mailbox” concept. TMS and the supplier will have

an EDI Connect mailbox where data can be sent or received by either party.

TMS maintains an in-house central communications hub for all supplier communications. The TMS

communication network uses the Connect System. The following supplier capabilities are required:

1. Protocol: 3780 BISYNC

2. Call method: Supplier dial-up for both sending and receiving

3. Line speed: 4800 BPS on (310) 618-8303

9600 BPS on (310) 618-5072

19.2 BPS on (310) 782-6417 or 6418

For information about specific software programs which are compatible with AIAG standards, or for

further information or clarifications of the AIAG standards, please contact the AIAG directly at:

Automotive Industry Action Group

26200 Lahser Road Suite 200

Southfield, MI 48034

(248) 358-3570

Required Delimiters

Element *

Sub Element :

Segment Terminator ~

Note: If using Future3 EDI software, the default delimiters do not need to be changed.

7

Mailbox Delivery and Retrieval

Each supplier will be assigned a mailbox and a password when ready to begin communication testing.

The supplier may retrieve from and deliver to the Connect mailbox 24 hours a day except Saturday at

2:00pm through Sunday 7:00am PST.

How to Use the TMS Mailbox System

To send or receive documents, the supplier must dial-up TMS’s network and send a partner code and

a password. Following are the procedures for sending and receiving data.

Receiving Data from TMS, the supplier will have two options:

Option 1: Receiving specific EDI transactions

Use the following control card:

$$REQUEST ID=TMSXXX BATCHID=’TNNN,PASSWORD’

Where: TMS = constant

XXX=TMS assigned EDI partner ID

T = constant

NNN = Transaction code (i.e. = 830, etc.)

PASSWORD = the supplier’s password

Example: $$REQUEST ID=TMS286 BATCHID=’T830,MYPASSWORD’

Note: The above control card will retrieve all transaction sets 830 for partner 286.

Option 2: Receiving all EDI transactions

Use the following control card:

$$REQUEST ID=TMSXXX BATCHID=’PASSWORD’

Where: TMS = constant

XXX = TMS assigned EDI partner ID

PASSWORD = the supplier’s password

Example: $$REQUEST ID=TMS286 BATCHID=’MYPASSWORD’

Note: The above control card will retrieve all transaction sets for partner 286.

8

Sending data to TMS, the supplier will have two options:

Option 1: Sending specific EDI transactions to production

This method allows easier tracking of specific transactions at TMS’s Connect mailboxes.

This method also requires that separate ISA envelopes be created for each transaction set type

(mixing transaction set type i.e. 856 and 810, will not be supported).

Use the following control card for production:

$$ADD ID=TMSPARTS BATCHID=’TNNN,TMSXXX’

where: TMSPARTS = constant

T = constant

NNN = Transaction code

XXX = TMS assigned EDI partner ID

Example: $$ADD ID=TMSPARTS BATCHID=’T830,TMS286’

Note: The above control card will add transaction sets 830 to production from partner 286.

Option 2: Sending mixed EDI transactions to production

Use the following control card for production:

$$ADD ID=TMSPARTS BATCHID=’EDI,TMSXXX’

where: TMSPARTS = constant

EDI = constant

XXX = TMS assigned EDI partner ID

Example: $$ADD ID=TMSPARTS BATCHID=’EDI,TMS286’

The above control card will add any transaction sets to production from partner 286.

Option 3: Sending to test mailbox

When testing with TMS all transaction sets should be sent to EDITEST instead of TMSPARTS.

TMSPARTS should only be used after testing is complete and the supplier is ready to send and

receive production data.

$$ADD ID=EDITEST BATCHID=’EDI,TMSXXX’

where: EDITEST = constant

EDI = constant

XXX = TMS assigned EDI partner ID

Example: $$ADD ID=EDITEST BATCHID=’EDI,TMS286’

9

TMS EDI Testing Process

The following general guidelines will be followed during testing for EDI implementation:

Phase I – Communication and mapping test for documents sent from TMS.

830 (Purchase Order Monthly)

862 (Shipping Schedule)

824 (Application Advice)

861 (Receiving Advice) (TMS suppliers only not TMMNA or NUMMI suppliers)

820 (Remittance Advice) (TMS suppliers only not TMMNA or NUMMI suppliers)

Phase II – Communication and mapping test for all documents sent to TMS

856 (Advanced Shipment Notification).

810 (Invoice) (TMS suppliers only not TMM or NUMMI suppliers)

Phase III – Full production test for all documents

The following general guidelines will be followed during testing for EDI implementation:

1. Preparation for Testing: Complete and submit the TMS EDI Data Collection Form. Your

mailbox will then be created on the TMS mailbox system.

2. ID’s: Ask for your Partner ID, Mailbox ID and Password.

3. Communication Methods: You can choose one of the two communication methods:

a. Direct Connection - Using a 3780 BISYNC Modem (310) 618-5072

b. VAN – You contract with Sterling Commerce to dial out to TMS on your behalf to

send and receive transactions. You will need to provide them with your TMS

Partner ID

4. Communication Testing: This step will involve testing the delivery and retrieval of Test

transactions from and to the TMS network using the mailbox system.

5. Desk Check: You will provide TMS with an unwrapped file that can be emailed or faxed

back for each transaction prior to be transmitted to the test mailbox (EDITEST) at TMS. Hard

copies will be reviewed for possible mapping/formatting problems.

6. Mapping Testing: This step will verify the proper mapping of the records by transmittal and

analysis of actual data of each transaction set.

7. Sign Off Form: A signoff form will be faxed to you for approval after testing has been

completed. Live production dates are agreed upon for the integration testing to begin.

8. Integration Testing: During this step, transmissions will be sent through the actual

production environment and tracked to ensure proper processing.

Depending on the financial relationship, TMS will send the 861 – Receiving Advice, and

820 – Remittance Advice to either TMMNA or NUMMI.

If you should have any questions, feel free to contact Jeff Zeno directly at:

Phone: (310) 468-0660

Fax: (310) 381-4020

Email: [email protected] (for EDI implementation/recertification) only)

Email: [email protected] (for all EDI production support problems/questions)

10

Transactions Timing

EDI Transaction Supplier Type Available in Mailbox

830 Material Release All 5:00 A.M. PST *

862 Shipping Schedule All 5:00 A.M. PST *

820 Remittance Advice Direct Source 5:00 A.M. PST *

861 Receiving Advice Direct Source 5:00 A.M. PST *

824 Application Advice All 5:00 A.M. PST *

Note: TMM and NUMMI suppliers will not receive transaction set 820 and 861 from TMS.

*These times are approximate.

Points of Contact at TMS

Jeff Zeno (310) 468-0660

11

ISA Segment

Please use the following values in the ISA segment:

Sending to TMS Receiving from TMS

ISA01 00 ISA01 00

ISA02 10 spaces ISA02 10 spaces

ISA03 00 ISA03 00

ISA04 10 spaces ISA04 10 spaces

ISA05 01 ISA05 01

ISA06 Supplier DUNS number ISA06 009595505

ISA07 01 ISA07 01

ISA08 009595505 ISA08 Supplier DUNS number

ISA09 Creation date YYMMDD ISA09 Creation date YYMMDD

ISA10 Creation time HHMM ISA10 Creation time HHMM

ISA11 U ISA11 U

ISA12 00200 ISA12 00200

ISA13 Sequence number ISA13 Sequence number

ISA14 0 (No Ack Requested)

1 (Ack Requested)

ISA14 0 (No Ack Requested)

1 (Ack Requested)

ISA15 P (Production)

T (Test)

ISA15 P (Production)

T (Test)

You must have your duns # in the ISA06 field in

order for your data to process through our EDI

system.

12

GS Segment

Please use the following values in the GS segment:

Sending to TMS Receiving from TMS

GS01 Functional identifier code

(see AIAG standard for

element 479)

i.e. “SH” for 856

“IN” for 810

GS01 Functional identifier code

(see AIAG standard for

element 479)

i.e. “PS” for 830

“RA” for 820

“SS” for 862

“RC” for 861

“AG” for 824

GS02 Supplier DUNS+EDI

partner ID (i.e.

123456789666 where

123456789 is the DUNS

and 666 is the EDI partner

ID)

GS02 009595505

GS03 009595505 GS03 Supplier DUNS+EDI

partner ID (i.e.

123456789666 where

123456789 is the DUNS

and 666 is the EDI partner

ID)

GS04 Creation date YYMMDD GS04 Creation date YYMMDD

GS05 Creation time HHMM GS05 Creation time HHMM

GS06 Sequence number GS06 Sequence number

GS07 X GS07 X

GS08 Version (refer to

guidelines for specific

transaction)

GS08 Version (refer to

guidelines for specific

transaction)

You must have your duns # plus the 3 digit trading

partner number in the GS02 field in order for your

data to be processed through our EDI system.

13

TRANSACTIONS SENT TO TMS

810 INVOICES

856 ADVANCE SHIPMENT NOTIFICATION (ASN)

14

810 - Invoices

The shipment identification is required on transaction sets 810 (invoice), 856 (ship notice), and on the

Packing Slips. The requirement for the shipment identification are as follows:

1. Up to 15 alphanumeric characters assigned by supplier.

2. Must be unique for one year.

3. Mandatory of Packing Slips, Advance Shipment Notices and Invoices because shipment identification is the most important factor in ensuring appropriate

receipts.

4. Must generate one invoice for each shipment identification.

5. Can have multiple cases and purchase orders for each shipment identification.

15

Transaction Set 810 Invoice VERSION 003010

Segment ID Segment Name Description

ISA Interchange control

header.

Identifies sender and receiver and other key

transmission data.

GS Functional group

header.

Identifies specific application of sender and

receiver.

ST Transaction set header. Indicates start of transaction set and assigns control

number.

BIG Beginning segment for

invoice.

Indicates start of invoice transaction. Includes

invoice number and invoice date.

REF Reference number

shipment level.

Indicates reference qualifier and shipment ID, bill

of lading, and packing list.

N1 Name. Indicates ID code and qualifier and TMS assigned

vendor code.

DTM Date/time reference. Indicates date/time qualifiers. Includes shipment

date.

IT1 Baseline item data. Specifies invoice quantity, unit FOB, TMS

purchase order number, line item number, TMS

part number, and case numbers.

TDS Total monetary value

summary.

Specifies invoice amounts and discount amount.

TXI Tax type code and

dollar amount of tax.

Specifies which type of tax and the tax dollar

amount.

ITA Allowance, charges, or

services.

Specifies charge indicator, charge method.

CTT Transaction totals. Used to transmit a total for a specific element in

the transaction.

SE Transaction set trailer. Indicates the end of the transaction and provides a

count of the transmitted segments.

GE Functional group

trailer.

Indicates the end of a functional group.

IEA Interchange control

trailer.

Indicates the end of the interchange.

16

Transaction Set 810 Invoice VERSION 003010

BIG - Beginning Segment

Example:

A B

BIG*960105*123456789

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A BIG01 245 DT 06 Invoice date.

YYMMDD.

B BIG02 76 AN 15 Vendor invoice number.

This segment is mandatory.

17

Transaction Set 810 Invoice VERSION 003010

REF - Reference Numbers Segment

Example:

A B

REF*SI*0300032334 1ST

Occurrence to reference shipment-id.

A B

REF*BM*0300032334 2nd

Occurrence to reference bill-of-lading.

A B

REF*PK*8906005 3rd

Occurrence to reference packing list number.

A B

REF*VN*1232345545 4TH

Occurrence to reference telemarketing order.

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A REF01 128 ID 02 Reference number qualifier. TMS

uses “SI” to indicate shipment ID.

“SI” = Shipment ID.

B REF02 127 AN 15 Reference number. A shipment ID must be unique

for at least one year. This number must match the

BSN02 Segment from the 856 (Advanced

Shipment Notification).

A REF01 128 ID 02 Reference number. TMS uses “BM”

to indicate bill of lading.

“BM” = Bill –of- Lading.

B REF02 127 AN 15 Reference number. Bill of lading.

A REF01 128 ID 02 Reference number qualifier. TMS

uses “PK” to indicate a packing list

number.

“PK” = Packing List Number.

B REF02 127 AN 15 Reference number. Packing list

number.

A REF01 128 ID 02 Reference number qualifier.

“VN” = Vendor reference.

Used only to represent telemarketing

shipment to dealer.

B REF02 127 AN 15 Reference number. Vendor reference

number to represent telemarketing

order.

This segment is mandatory. Segment with a value of “VN” is paired with the following N1 segment

value of “ST” for telemarketing dealer code.

18

Transaction Set 810 Invoice VERSION 003010

N1 - Name Segment - Header Level

Example:

A B C

N1*SU**92*0123A

A B C

N1*ST**92*85345

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A N101 98 ID 02 Entity identifier code. TMS uses “SU”

to indicate a supplier/manufacturer.

“SU” = Supplier/Manufacturer.

B N103 66 ID 02 Identification code qualifier. TMS

uses “92” to indicate assigned by

buyer.

“92” = Assigned by buyer.

C N104 67 ID 05 Identification code. TMS assigned

vendor code.

A N101 98 ID 02 Entity identifier code. TMS uses “ST”

to indicate ship to code.

“ST” = Ship to Code.

B N103 66 ID 02 Identification code qualifier. TMS

uses “92” to indicate assigned by

buyer.

“92” = Assigned by buyer.

C N104 67 ID 05 Identification code. TMS assigned

dealer code. To be used only for

telemarketing and direct shipments to

a dealer.

This segment is mandatory.

19

Transaction Set 810 Invoice VERSION 003010

DTM - Date/Time Reference Segment

Example:

A B

DTM*011*960120

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A DTM01 374 ID 03 Date/time qualifier. TMS uses “011”

to indicate shipped.

“011” = Shipped

B DTM02 373 DT 06 Shipment date. YYMMDD.

This segment is mandatory.

20

Transaction Set 810 Invoice VERSION 003010

IT1 - Baseline Item Data Segment

Example 1 (Normal order):

A B C D E F G H I

IT1**3*PC*4.410**PO*OS303431*VN*01234*BP*8871633050

Example 2 (Telemarketing order):

A B C D E F G H I

IT1**5*PC*5.450**PO*TELE*VN*01234*BP*8871656052

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A IT102 358 R 07 Quantity invoiced.

B IT103 355 ID 02 Unit of measurement code. TMS uses

“PC” to indicate pieces.

“PC” = Pieces

C IT104 212 R 09 Unit price. Three decimal positions

implied.

D IT106 235 ID 02 Product qualifier. TMS uses “PO” to

indicate purchase order.

“P.O.” = Purchase Order Number

E IT107 234 AN 08 This field will contain “TELE” for

telemarketing orders. Otherwise it will

contain the TMS purchase order

number.

“TELE” = Telemarking

F IT108 235 ID 02 Product qualifier. TMS uses “VN” to

indicate item number.

“VN” = Item Number

G IT109 234 AN 05 Line item number. Line item number

comes from the 862 LIN07 segment.

H IT110 235 ID 02 Product qualifier. TMS uses “BP” to

indicate buyer part number.

“BP” = Buyer Part Number

I IT111 234 AN 15 TMS part number. No dashes (“-“)

allowed.

This segment is mandatory.

21

Transaction Set 810 Invoice VERSION 003010

TDS - Total Monetary Value Summary Segment

Example:

A B

TDS*5.860***175

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A TDS01 361 N2 10 Total invoice amount. 2 decimal

positions implied.

B TDS04 362 N2 10 Term discount amount (dollar

amount). 2 decimal positions implied.

This segment is mandatory.

22

Transaction Set 810 Invoice VERSION 003010

TXI - Taxes

Example:

A B

TXI*ZZ*3.00

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A TXI01 963 ID 02 TMS uses “CP” to indicate

County/parish sales tax.

“CP” = County/Parish sales tax.

B

TXI02 782 R 15 Dollar amount of tax. 2 decimal

positions implied.

A TXI01 963 ID 02 TMS uses “CS” to indicate city sales

tax.

“CS” = City sales tax.

B TXI02 782 R 15 Dollar amount of tax. 2 decimal

positions implied.

A TXI01 963 ID 02 TMS uses “CT” to indicate county tax.

“CT” = County tax.

B TXI02 782 R 15 Dollar amount of tax. 2 decimal

positions implied.

A TXI01 963 ID 02 TMS uses “FT” to indicate federal

excise tax.

“FT” = Federal excise tax.

B TXI02 782 R 15 Dollar amount of tax. 2 decimal

positions implied.

A TXI01 963 ID 02 TMS uses “LS” to indicate local sales

tax.

“LS” = Local sales tax.

B TXI02 782 R 15 Dollar amount of tax. 2 decimal

positions implied.

23

Transaction Set 810 Invoice VERSION 003010

A TXI01 963 ID 02 TMS uses “LT” to indicate local tax.

“LT” = Local tax.

B TXI02 782 R 15 Dollar amount of tax. 2 decimal

positions implied.

A TXI01 963 ID 02 TMS uses “MT” to indicate

metropolitan transit tax.

“MT” = Metropolitan transit tax.

B TXI02 782 R 15 Dollar amount of tax. 2 decimal

positions implied.

A TXI01 963 ID 02 TMS uses “ST” to indicate state sales

tax.

“ST” = State sales tax.

B TXI02 782 R 15 Dollar amount of tax. 2 decimal

positions implied.

A TXI01 963 ID 02 TMS uses “VA” to indicate value

added tax.

“VA” = Value added tax.

B TXI02 782 R 15 Dollar amount of tax. 2 decimal

positions implied.

A TXI01 963 ID 02 TMS uses “ZZ” to indicate a mutually

defined tax.

“ZZ” = Mutually defined tax.

B TXI02 782 R 15 Dollar amount of tax. 2 decimal

positions implied.

This segment is optional.

24

Transaction Set 810 Invoice VERSION 003010

ITA - Allowance, Charge, or Service Segment

Example:

A B C D

ITA*C**ZZ*06***2275

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A ITA01 248 ID 01 Allowance/charge indicator. TMS

uses “C” to indicate a charge.

“C” = Charge.

B ITA03 560 ID 10 Special services code. TMS uses “ZZ”

to indicate miscellaneous charges.

“ZZ” = Miscellaneous charges.

C ITA04 331 ID 02 Allowance or charge method code.

TMS uses “06" to indicate charge to be

paid by customer.

“06” = Paid by customer.

D ITA07 360 N2 09 Charge amount. 2 decimals implied.

A ITA01 248 ID 01 Allowance/charge indicator. TMS

uses “C” to indicate a charge.

“C” = Charge.

B ITA03 560 ID 10 Special services code. TMS uses

“S0022” to indicate sleeving charges.

“S0022” = Sleeving charges.

C ITA04 331 ID 02 Allowance or charge method code.

TMS uses “06" to indicate charge to be

paid by customer.

“06” = Paid by customer.

D ITA07 360 N2 09 Sleeving charge amount. 2 decimals

implied.

25

Transaction Set 810 Invoice VERSION 003010

A ITA01 248 ID 01 Allowance/charge indicator. TMS

uses “C” to indicate a charge.

“C” = Charge.

B ITA03 560 ID 10 Special services code. TMS uses “FC”

to indicate freight charges.

“FC” = Freight charges.

C ITA04 331 ID 02 Allowance or charge method code.

TMS uses “06" to indicate charge to be

paid by customer.

“06” = Paid by customer.

D ITA07 360 N2 09 Freight charge amount. 2 decimals

implied.

A ITA01 248 ID 01 Allowance/charge indicator. TMS

uses “C” to indicate a charge.

“C” = Charge

B ITA03 560 ID 10 Special services code. TMS uses “IN”

to indicate insurance charges.

“IN” = Insurance Charges.

C ITA04 331 ID 02 Allowance or charge method code.

TMS uses “06" to indicate charge to be

paid by customer.

“06” = Paid by customer.

D ITA07 360 N2 09 Insurance charge amount. 2 decimals

implied.

A ITA01 248 ID 01 Allowance/charge indicator. TMS

uses “C” to indicate a charge.

“C” = Charge

B ITA03 560 ID 10 Special services code. TMS uses “PC”

to indicate packaging charges.

“PC”= Packaging charges.

C ITA04 331 ID 02 Allowance or charge method code.

TMS uses “06" to indicate charge to be

paid by customer.

“06” = Paid by customer.

D ITA07 360 N2 09 Packaging charge amount. 2 decimals

implied.

26

Transaction Set 810 Invoice VERSION 003010

A ITA01 248 ID 01 Allowance/charge indicator. TMS

uses “C” to indicate a charge.

“C” = Charge

B ITA03 560 ID 10 Special services code. TMS uses

“240” to indicate brokerage charges.

“240” = Brokerage charges.

C ITA04 331 ID 02 Allowance or charge method code. TMS

uses “06" to indicate charge to be paid by

customer.

“06” = Paid by customer.

D ITA07 360 N2 09 Brokerage charge amount. 2 decimals

implied.

A ITA01 248 ID 01 Allowance/charge indicator. TMS

uses “C” to indicate a charge.

“C” = Charge

B ITA03 560 ID 10 Special services code. TMS uses

“315” to indicate duty charges.

“315” = Duty charges.

C ITA04 331 ID 02 Allowance or charge method code.

TMS uses “06" to indicate charge to be

paid by customer.

“06” = Paid by customer.

D ITA07 360 N2 09 Duty charge amount. “2” decimals

implied.

This segment is optional.

27

Transaction Set 810 Invoice VERSION 003010

CTT - Transaction Totals Segment

Example:

A

CTT*20

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A CTT01 354 N0 06 Number of line items

This segment is mandatory.

28

856 - Advance Shipment Notice

Shipment Identification:

When TMS receives a shipment, the shipment identification (refer to description in the beginning of

810 - Invoice section) is the most important factor in ensuring appropriate receipts. The PDC/PRC

initially reviews the transmitted 856 (Ship Notice) to identify whether the shipment was entered into

the system. They do this by matching the shipment identification on the Packing Slip to the shipment

identification transmitted on the 856 (Ship Notice). Please adhere to the following instructions:

1. It is imperative that the shipment identification be transmitted exactly as it appears

on the packing slip. If the transmitted shipment identification is 1234 and the shipment

identification of the packing slip is 01234, the warehouse will not be able

to identify the shipment when it arrives.

2. We require separate shipment identification for each final invoice.

Case Numbers:

When a shipment is received and an ASN is processed, receiving tickets are printed at the PDCs

based on transportation numbers. This allows the PDCs to receive by case and make the receiving

process more efficient. Bar coded case labels are required at NAPO.

Following are the Case Number requirements:

1. 8 character number:

First 3 characters (Trading Partner ID code) assigned to each supplier by NAPO used

to uniquely identify the case to the NAPO System.

Last 5 characters assigned by suppliers must be numeric.

2. Must be unique for 2 months.

3. Bar coded case label will be required on each case shipped from the supplier and will act

as an electronic packing list.

4. Must be transmitted on 856 (ASN) and printed on packing slip.

29

Transaction Set 856 ASN VERSION 002003

Segment ID Segment Name Description

ISA Interchange control

header.

Identifies sender and receiver and other key

transmission data.

GS Functional group

header.

Identifies specific application of sender and

receiver.

ST Transaction set header. Indicates start of transaction set and assigns control

number.

BSN Beginning segment for

shipment notice.

Indicates start of ship notice. Includes shipment

identification and transaction date and time.

DTM Date/time reference. Indicates date/time qualifiers. Includes shipment

date and time.

HL Hierarchical level;

shipment level.

Identifies the level of detail information; shipment.

MEA Measurement reference;

shipment level.

Identifies the gross and net weight.

TD1 Carrier details;

quantity.

Specifies lading quantity and package type.

TD5 Carrier details; routing

sequence.

SCAC and transportation method.

REF Reference number;

shipment level.

Indicates reference qualifier and bill of lading

number.

N1 Name; shipment level. Indicates ID code and qualifier and ship-to depot.

HL Hierarchical level;

order level.

Identified level of detail information; order.

PRF Purchase order; order

level.

Identifies TMS’s purchase order number..

REF Reference number;

shipment level.

Indicates reference qualifier and bill of lading

number.

N1 Name; order level. Indicates TMS assigned vendor code.

HL Hierarchical level; item. Identifies the level of detail information; item.

LIN Item identification. Identifies TMS’s assigned part number and line

item number.

SN1 Item detail. Identifies in transit quantity per part number/line

item.

CTT Transaction totals. Used to transmit a total for a specific element in

the transaction.

SE Transaction set trailer. Indicates the end of the transaction and provides a

count of the transmitted segments.

30

Transaction Set 856 ASN VERSION 002003

BSN - Beginning Segment

Example:

A B C D

BSN*00*0195569*960205*1300

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A BSN01 353 ID 02 Transaction set purpose code. TMS

uses “00” to indicate original.

“00” = Original.

B BSN02 396 AN 15 Shipment identification. Unique

supplier assigned number that should

not be repeated within 1 year. BOL

number may be used. This Shipment

ID number must match the REF02

Segment on the 810 (Invoice) if

doing direct invoicing to TMS.

C BSN03 373 DT 06 Transaction date. YYMMDD.

D BSN04 373 TM 04 Transaction time.

This segment is mandatory.

31

Transaction Set 856 ASN VERSION 002003

DTM - Date/Time Reference Segment

Example:

A B C

DTM*011*960220*1400

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A DTM01 374 ID 03 Date/time qualifier. TMS uses “011”

to indicate shipped.

“011” = Shipped.

B DTM02 373 DT 06 Shipment date. YYMMDD.

C DTM03 337 TM 04 Shipment time. HHMM.

This segment is mandatory.

32

Transaction Set 856 ASN VERSION 002003

HL - Hierarchical Level Segment – Shipment Level

Example:

A B C

HL*1**S*1

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A HL01 628 AN 12 Unique number incremented by 1 for

each occurrence of an HL segment.

B HL03 735 ID 02 Hierarchical level code. TMS uses

“S” to indicate shipment level.

“S” = Shipment Level.

C HL04 736 ID 01 Hierarchical child code. TMS uses

“1” to indicate that there are

subordinate segments.

This segment is mandatory.

33

Transaction Set 856 ASN VERSION 002003

MEA - Measurement Segment -Shipment Level

Example:

A B C D

MEA*PD*G*500*LB

MEA*PD*N*423*LB

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A MEA01 737 ID 02 Measurement ID code. TMS uses

“PD” to indicate physical dimensions.

“PD” = Physical Dimensions.

B MEA02 738 ID 03 Measurement qualifier. TMS uses:

“G” to represent gross weight

“N” to represent net weight.

C MEA03 739 R 10 Measurement value.

D MEA04 355 ID 02 Unit of measure.

This segment is mandatory.

34

Transaction Set 856 ASN VERSION 002003

TD1 - Carrier Detail (Quantity) Segment – Shipment Level

Example:

A B

TD1*PKG71*6

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A TD101 103 ID 05 Packaging code.

B TD102 80 N0 07 Lading quantity

This segment is mandatory.

35

Transaction Set 856 ASN VERSION 002003

TD5 - Carrier Detail (Routing Sequence) Segment – Shipment Level

Example:

A B C D

TD5*B*2*TOYOTA PARTS EXPR*T

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A TD501 133 ID 01 Routing sequence code. TMS uses

“B” to indicate any mode.

“B” = Any mode.

B TD502 66 ID 01 Identification code qualifier. TMS

uses “2” to indicate standard carrier

alpha code.

“2” = Standard Carrier

C TD503 67 ID 15 SCAC.

D TD504 91 ID 02 Transportation method.

This segment is mandatory.

Transportation method is optional.

36

Transaction Set 856 ASN VERSION 002003

REF - Reference Numbers Segment - Shipment Level

Example:

A B

REF*BM*0195569234

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A REF01 128 ID 02 Reference number qualifier. TMS

uses “BM” to indicate bill of lading.

“BM” = Bill-of-Lading.

B REF02 127 AN 15 Reference number. Bill of lading

number.

This segment is mandatory.

37

Transaction Set 856 ASN VERSION 002003

N1 - Name – Shipment Level

Example 1 (Normal order):

A B C

N1*ST**92*KY

Example 2 (VOR Order):

A B C

N1*ST**92*04136

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A N101 98 ID 02 Entity identifier code. TMS uses “ST”

to indicate ship to.

“ST” = Ship To.

B N103 66 ID 02 Identification code qualifier. TMS

uses “92” to indicate assigned by

buyer.

“92” = Assigned by buyer.

C N104 67 ID 05 Identification code. TMS assigned

depot/dealer codes. TMS uses the

following depot/dealer codes:

“51” to indicate Ontario

“KY” to indicate Kentucky

“NNNNN” to indicate Dealer Code

This segment is mandatory.

This segment identifies the location where the supplier will deliver the shipment.

The ship to destination comes from

The N1 segment (N101) in the 862 Shipping

Schedule.

38

Transaction Set 856 ASN VERSION 002003

HL - Hierarchical Level Segment - Order Level

Example:

A B C D

HL*2*1*O*1

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A HL01 628 AN 12 Unique number incremented by 1 for

each occurrence of an HL segment.

Use “2” for this occurrence.

B HL02 734 AN 12 Hierarchical parent ID.

C HL03 735 ID 02 Hierarchical level code. TMS uses

“O” to indicate order level.

D HL04 736 ID 01 Hierarchical child code. TMS uses

“1” to indicate that there are additional

subordinates.

This segment is mandatory.

39

Transaction Set 856 ASN VERSION 002003

PRF - Purchase Order Reference Segment – Order Level

Example:

A

PRF*OS123456

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A PRF01 324 AN 08 Toyota’s Purchase order number.

This segment is mandatory.

40

Transaction Set 856 ASN VERSION 002003

REF - Reference Numbers Segment – Order Level

Example:

01 02

REF*MH*0195569234

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

01 REF01 128 ID 02 Reference number qualifier. TMS

uses “MH” to indicate manufacturer

order number.

“MH” = Manufacturer Order

Number.

02 REF02 127 AN 15 Reference number. Work order

number. This number must be unique

per purchase order number.

This segment is mandatory.

41

Transaction Set 856 ASN VERSION 002003

N1 - Name Segment – Order Level

Example:

A B C

N1*SU**92*0236A

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A N101 98 ID 02 Entity identifier code. TMS uses “SU”

to indicate supplier/manufacturer.

“SU” = Supplier/Manufacturer.

B N103 66 ID 02 Identification code qualifier. TMS

uses “92” to indicate assigned by

buyer.

“92” = Assigned by buyer.

C N104 67 ID 05 Identification code. TMS assigned

vendor code.

This segment is mandatory.

The TMS assigned vendor code comes from the

N1 segment (N104) in the 862 Shipping

Schedule.

42

Transaction Set 856 ASN VERSION 002003

HL - Hierarchical Level Segment - Item Level

Example:

A B C D

HL*3*2*I*0

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A HL01 628 AN 12 Unique number incremented by 1 for

each occurrence of an HL segment.

Use “3” for this occurrence.

B HL02 734 AN 12 Hierarchical parent ID.

Use “2” for this occurrence.

C HL03 735 ID 02 Hierarchical level code.

TMS uses “I” to indicate item level.

“I” = Item Level.

D HL04 736 ID 01 Hierarchical child code.

TMS uses “0” to indicate that there are

no subordinates.

This segment is mandatory.

43

Transaction Set 856 ASN VERSION 002003

LIN - Item Identification Segment – Item Level

Example:

A B C D E F

LIN**BP*883200101184*VN*01234*CA*1239876

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A LIN02 235 ID 02 Product/service ID qualifier. TMS

uses “BP” to indicate buyer’s part

number.

“BP” = Buyer’s Part Number

B LIN03 234 AN 15 Part number. No dashes (“-“) allowed.

C LIN04 235 ID 02 Product/service ID qualifier. TMS

uses “VN” to indicate line item

number.

“VN” = Line item number.

D LIN05 234 AN 05 Line item number. Line item number

comes from the 862 LIN07 segment.

E LIN06 235 ID 02 Product/service ID qualifier. TMS

uses “CA” to indicate case number.

“CA” = Case Number.

F LIN07 234 AN 08 Case number. First 3 characters

(Trading Partner ID code) assigned to

each supplier by NAPO used to

uniquely identify the case to the NAPO

System. Last 5 characters assigned by

supplier MUST be numeric.

This segment is mandatory.

The LIN information comes from the LIN segment

in the 862 (Shipping Schedule)

44

Transaction Set 856 ASN VERSION 002003

SN1 - Item Detail Shipment Segment – Item Level

Example:

A B

SN1**10*PC

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A SN102 382 R 06 Number of units shipped. In transit

quantity.

B SN103 355 ID 02 Unit of measurement code.

TMS uses “PC” to indicate pieces.

“PC” = Pieces.

This segment is mandatory.

45

Transaction Set 856 ASN VERSION 002003

CTT - Transaction Totals Segment

Example:

A

CTT*20

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A CTT01 354 N0 06 Number of HL segments

This segment is mandatory.

46

TRANSACTIONS SENT FROM TMS

820 Remittance Advice

824 Application Advice

830 Material Release

861 Receiving Advice

862 Shipping Schedule

47

820 Remittance Advice

48

Transaction Set 820 Remittance Advice VERSION 003040

Segment ID Segment Name Description

ISA Interchange control

header.

Identifies sender and receiver and other key

transmission data.

GS Functional group

header.

Identifies specific application of sender and

receiver.

ST Transaction set header. Indicates start of transaction set and assigns control

number.

BPR Beginning segment for

remittance advice.

Indicates transaction handling code, credit/debit

flag, payment method code, and total pay amount

for a shipment.

REF Reference numbers. Indicates shipment ID and invoice numbers.

DTM Date/time reference. Indicates date/time qualifiers. Includes shipment

date, invoice date, and pay date.

N1 Name. Identifies the vendor code.

ENT Entity. Constant used to start the ENT loop.

ADX Adjustments. Specifies invoice price, adjustment reason code

and shipment ID.

IT1 Baseline item data

(invoice).

Specifies invoice quantity, invoice price, part

number, and TMS purchase order number.

RMR Remittance advice. Specifies shipment ID, evaluated receipt settlement

code and total payment amount.

IT1 Baseline item data

(invoice).

Specifies quantity received, quantity received

price, TMS part number, TMS purchase order

number.

ITA Allowance, charge, and

services.

Identifies miscellaneous charges, cash discount,

miscellaneous discount, vendor sleeving, packing

charges, freight charges, duty fees, brokerage fees,

vendor miscellaneous charges, and special taxes.

SE Transaction set trailer. Indicates the end of the transaction and provides a

count of the transmitted segments.

GE Functional group

trailer.

Indicates the end of a functional group.

IEA Interchange control

trailer.

Indicates the end of the interchange.

49

Transaction Set 820 Remittance Advice VERSION 003040

BPR - Beginning Segment for Remittance

Example:

A B C D

BPR*I*24332*C*ACH

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A BPR01 305 ID 01 Transaction handling code. TMS uses

“I” to indicate remittance information

only.

“I” = Remittance Information Only.

B BPR02 782 R 11 Monetary amount. The total amount

that TMS will pay. 2 decimals

implied.

C BPR03 478 ID 01 CR/DB flag code. TMS uses “C” to

indicate credit.

“C” = Credit.

D BPR04 591 ID 03 Payment method code. TMS uses the

following codes:

“ACH” to indicate Automatic

clearing house, and “CHK” to

indicate pay by check.

This segment is mandatory.

50

Transaction Set 820 Remittance Advice VERSION 003040

REF - Reference Numbers Segment

Example:

A B

REF*SI*616750954757463

REF*IV*AGX2670

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A REF01 128 ID 02 Reference number qualifier. TMS

uses “SI” to indicate shipment ID.

“SI” = Shipment ID.

B REF02 127 AN 15 Reference number. Shipment ID.

A REF01 128 ID 02 Reference number qualifier. TMS

uses “IV” to indicates invoice number.

“IV” = Invoice number.

B REF01 127 AN 15 Reference number. Invoice number.

This segment is mandatory.

51

Transaction Set 820 Remittance Advice VERSION 003040

DTM - Date/Time Segment

Example:

A B

DTM*011*960201

DTM*003*960202

DTM*020*960215

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A DTM01 374 ID 03 Date qualifier. TMS uses “011” to

indicate date shipped.

“011” = Shipped date.

B DTM02 373 DT 06 Date. Shipment date. YYMMDD.

A DTM01 374 ID 03 Date qualifier. TMS uses “003” to

indicate invoice date.

“003” = Invoice date.

B DTM02 373 DT 06 Date. Invoice date. YYMMDD.

A DTM01 374 ID 03 Date qualifier. TMS uses “020” to

indicate check date.

“020” = Check date.

B DTM02 373 DT 06 Date. The date the check was printed.

YYMMDD.

This segment is mandatory.

52

Transaction Set 820 Remittance Advice VERSION 003040

N1 - Name Segment

Example:

A B C

N1*VN**92*0123A

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A N101 98 ID 02 Entity identifier code. TMS uses

“VN” to indicate vendor code.

“VN” = Vendor Code.

B N103 66 ID 02 Identifier code qualifier. TMS uses

“92” to indicate assigned by buyer.

“92” = Assigned buyer.

C N104 67 AN 05 TMS assigned vendor code.

This segment is mandatory.

53

Transaction Set 820 Remittance Advice VERSION 003040

ENT - Entity Segment

Example:

A

ENT*999999

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A ENT01 554 N0 06 Assigned number. TMS uses a

constant “999999”.

This segment is mandatory.

54

Transaction Set 820 Remittance Advice VERSION 003040

ADX - Adjustment Segment

Example:

A B C D

ADX*50332*01*SI*616750954757463

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A ADX01 782 R 09 Monetary amount. Extended invoice

price. 2 decimals implied.

B ADX02 426 ID 02 Adjustment reason code.

C ADX03 128 ID 02 Reference number qualifier. TMS

uses “SI” to indicate the shipper’s

identification number.

“SI” = Shipper’s identification

number

D ADX04 127 AN 15 Reference number. Shipment

identification number.

This is optional and will occur only in case of a price adjustment.

55

Transaction Set 820 Remittance Advice VERSION 003040

IT1 - Baseline Item Data (Invoice) Segment

Example:

A B C D E F G

IT1**25*PC*20133**PO*OS123456***BP*A12345678901

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A IT102 358 R 07 Quantity invoiced.

B IT103 355 ID 02 Unit of measurement code. TMS uses

“PC” to indicate pieces.

“PC” = Pieces.

C IT104 212 R 09 Invoice unit price. 3 decimals implied.

D IT106 235 ID 02 Product qualifier. TMS uses “PO” to

indicate purchase order number.

“P.O” = Purchase Order Number.

E IT107 234 AN 08 TMS purchase order number.

F IT110 235 ID 02 Product qualifier. TMS uses “BP” to

indicate buyer part number.

“BP” = Buyer part number.

G IT111 234 AN 15 TMS part number.

This segment is optional. It will occur only in case of a unit price adjustment.

This segment is part of the ADX loop.

56

Transaction Set 820 Remittance Advice VERSION 003040

RMR - Remittance Advice Segment

Example:

A B C D

RMR*SI*616750954757463*ER*25332

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A RMR01 128 ID 02 Reference number qualifier. TMS

uses “SI” to indicate shipper’s

identification number.

“SI” = Shipper’s Identification

Number

B RMR02 127 AN 15 Reference number. Shipment ID.

C RMR03 482 ID 02 Payment action code. TMS uses “ER”

to indicate evaluated receipts

settlement. This code will be used for

all suppliers (Non ERS and ERS).

“ER” = Evaluated receipts

settlement.

D RMR04 782 R 11 Monetary amount. Extended pay

price. 2 decimals implied.

This segment is mandatory.

57

Transaction Set 820 Remittance Advice VERSION 003040

IT1 - Baseline Item Data (Invoice)

Example:

A B C D E F G

IT1**25*PC*10133**PO*OS123456***BP*A12345678901

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A IT102 358 R 07 Quantity received.

B IT103 355 ID 02 Unit of measurement code. TMS uses

“PC” to indicate pieces.

“PC” = Pieces.

C IT104 212 R 09 Purchase order unit price. 3 decimals

implied.

D IT106 235 ID 02 Product qualifier. TMS uses “PO” to

indicate purchase order number.

“P.O.” = Purchase order number.

E IT107 234 AN 08 TMS purchase order number.

F IT110 235 ID 02 Product qualifier. TMS uses “BP” to

indicate buyer part number.

“BP” = Buyer part number.

G IT111 234 AN 15 TMS part number.

This segment is mandatory.

This segment is part of the RMR loop.

58

Transaction Set 820 Remittance Advice VERSION 003040

ITA - Allowance, Charge, Service Segment

Example:

A B C D

ITA*A**C0020*02***10

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A ITA01 248 ID 01 Allowance/charge indicator. TMS uses

“A” to indicate an allowance.

“A” = Allowance.

B ITA03 560 ID 10 Special services code. TMS uses

“C0020” to indicate cash discount.

“C0020” = Cash discount.

C ITA04 331 ID 02 Allowance or charge method code. TMS

uses “02" to indicate off invoice.

“02” = Off Invoice.

D ITA07 360 N2 09 Cash discount amount. 2 decimals

implied.

A ITA01 248 ID 01 Allowance/charge indicator. TMS uses

“A” to indicate an allowance.

“A” = Allowance.

B ITA03 560 ID 10 Special services code. TMS uses “DI” to

indicate discount.

“DI” = Discount.

C ITA04 331 ID 02 Allowance or charge method code. TMS

uses “02” to indicate off invoice.

“02” = Off Invoice.

D ITA07 360 N2 09 Discount amount. 2 decimals implied.

A ITA01 248 ID 01 Allowance/charge indicator. TMS uses

“C” to indicate a charge.

“C” = Charge.

B ITA03 560 ID 10 Special services code. TMS uses “S0022”

to indicate sleeving charges.

“S0022” = Sleeving Charges.

C ITA04 331 ID 02 Allowance or charge method code. TMS

uses “06" to indicate charge to be paid by

customer.

“06” = Paid by customer.

D ITA07 360 N2 09 Sleeving charge amount. 2 decimals

implied.

59

01 ITA01 248 ID 01 Allowance/charge indicator. TMS uses

“C” to indicate a charge.

“C” = Charge.

03 ITA03 560 ID 10 Special services code. TMS uses “PC” to

indicate packaging charges.

“PC” = Packaging Charge.

04 ITA04 331 ID 02 Allowance or charge method code. TMS

uses “06" to indicate charge to be paid by

customer.

“06” = Paid by customer.

07 ITA07 360 N2 09 Packaging charge amount. 2 decimals

implied.

01 ITA01 248 ID 01 Allowance/charge indicator. TMS uses

“C” to indicate a charge.

“C” = Charge.

03 ITA03 560 ID 10 Special services code. TMS uses “FC” to

indicate freight charges.

“FC” = Freight charges.

04 ITA04 331 ID 02 Allowance or charge method code. TMS

uses “06" to indicate charge to be paid by

customer.

“06” = Paid by customer.

07 ITA07 360 N2 09 Freight charge amount. 2 decimals

implied.

01 ITA01 248 ID 01 Allowance/charge indicator. TMS uses

“C” to indicate a charge.

“C” = Charge.

03 ITA03 560 ID 10 Special services code. TMS uses “315” to

indicate duty charges.

“315” = Duty Charges.

04 ITA04 331 ID 02 Allowance or charge method code. TMS

uses “06" to indicate charge to be paid by

customer.

“06” = Paid by customer.

07 ITA07 360 N2 09 Duty charge amount. 2 decimals implied.

60

01 ITA01 248 ID 01 Allowance/charge indicator. TMS uses

“C” to indicate a charge.

“C” = Charge.

03 ITA03 560 ID 10 Special services code. TMS uses “240” to

indicate brokerage charges.

“240” = Brokerage Charges.

04 ITA04 331 ID 02 Allowance or charge method code. TMS

uses “06" to indicate charge to be paid by

customer.

“06” = Paid by customer.

07 ITA07 360 N2 09 Brokerage charge amount. 2 decimals

implied.

01 ITA01 248 ID 01 Allowance/charge indicator. TMS uses

“C” to indicate a charge.

“C” = Charge.

03 ITA03 560 ID 10 Special services code. TMS uses “ZZ” to

indicate special service code.

“ZZ” = Special Service Code.

04 ITA04 331 ID 02 Allowance or charge method code. TMS

uses “06" to indicate charge to be paid by

customer.

“06” = Paid by customer.

07 ITA07 360 N2 09 Special service charge amount. 2

decimals implied.

01 ITA01 248 ID 01 Allowance/charge indicator. TMS uses

“C” to indicate a charge.

“C” = Charge.

03 ITA03 560 ID 10 Special services code. TMS uses “TX” to

indicate special tax.

“TX” = Special Tax.

04 ITA04 331 ID 02 Allowance or charge method code. TMS

uses “06" to indicate charge to be paid by

customer.

“06” = Paid by customer.

07 ITA07 360 N2 09 Special tax amount. 2 decimals implied.

This segment is optional.

61

824 Application Advice

62

824’s (Application Advices) are not

rejection/error reports. They are used by TMS

to notify suppliers when they have missed a

delivery date for part(s). The delivery date

comes from the Forecast Schedule Segment of

the 862 (Shipping Schedule). 824’s will

continue to be sent until TMS receives an 856

for the parts.

Vendor Codes, Part numbers, purchase orders

and quantities are contained in the detail

section of the 824.

Your EDI system needs to be checked daily

for 824’s.

You need to research the 824’s in your system

and take action. If necessary contact your

TMS procurement analyst to verify this

information for these parts/PO and if

requested, send the parts/PO with an 856.

63

Transaction Set 824 Application Advice VERSION 003040

Segment ID Segment Name Description

ISA Interchange control

header.

Identifies sender and receiver and other key

transmission data.

GS Functional group

header.

Identifies specific application of sender and

receiver.

ST Transaction set header. Indicates start of transaction set and assigns control

number.

BGN Beginning segment for

application advice.

Identifies transaction set purpose code, vendor

code, and current date.

N1 Name. Identifies the vendor code.

OTI Original transaction

identification.

Identifies the TMS purchase order number.

REF Reference numbers. Identifies the TMS part number.

DTM Date/time reference. Identifies the original delivery due date and the

revise delivery due date.

QTY Quantity. Identifies the shipped quantity.

TED Technical error

description.

Identifies the application error.

SE Transaction set trailer. Indicates the end of the transaction and provides a

count of the transmitted segments.

GE Functional group

trailer.

Indicates the end of a functional group.

IEA Interchange control

trailer.

Indicates the end of the interchange.

64

Transaction Set 824 Application Advice VERSION 003040

BGN - Application Advice Beginning Segment

Example:

A B C

BGN*12*0123A*960202

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A BGN01 353 ID 02 Transaction purpose code. TMS uses

“12” to indicate not processed.

“12” = Not Processed.

B BGN02 127 AN 05 Reference number. TMS assigned

vendor code.

C BGN03 373 DT 06 Date. Process date. YYMMDD.

This segment is mandatory.

65

Transaction Set 824 Application Advice VERSION 003040

N1 - Name Segment

Example:

A B C

N1*VN**92*0123A

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A N101 98 ID 02 Entity identifier code. TMS uses

“VN” to indicate vendor code.

“VN” = Vendor Code.

B N103 66 ID 02 Identifier code qualifier. TMS uses

“92” to indicate assigned by buyer.

“92” = Assigned by buyer.

C N104 67 AN 05 TMS assigned vendor code.

This segment is mandatory.

You will need the TMS vendor

code to help resolve the 824

problems.

66

Transaction Set 824 Application Advice VERSION 003040

OTI - Original Transaction Identification Segment

Example:

A B C D

OTI*TR*PO*OS123456*******856

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A OTI01 110 ID 02 Application acknowledgment code.

TMS uses “TR” to indicate transaction

set reject.

“TR” = Transaction set reject.

B OTI03 128 ID 02 Reference number qualifier. TMS

uses “PO” to indicate purchase order

number.

“P.O.” = Purchase Order Number.

C OTI03 127 AN 08 Reference number. Purchase order

number.

D OTI10 143 ID 03 Transaction set identifier code. TMS

uses “856” to indicate ship notice.

This segment is mandatory.

The purpose of this segment is to notify the vendor that an 856 has not been received for the

following REF segment.

You will need the TMS Purchase

Order Number to help resolve the

824 problems.

67

Transaction Set 824 Application Advice VERSION 003040

REF - Reference Numbers Segment

Example:

A B

REF*BP*A12345678901234

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A REF01 128 ID 02 Reference number qualifier. TMS

uses “BP” to indicate part number.

“BP” = Part Number.

B REF02 127 AN 15 Reference number. Part number.

This segment is mandatory.

You will need the TMS Part

Number to help resolve the 824

problems.

68

Transaction Set 824 Application Advice VERSION 003040

DTM - Date/Time Reference Segment

Example:

A B

DTM*011*960301

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A DTM01 374 ID 03 Date/time qualifier. TMS uses “011"

to indicate shipped.

“011” = Shipped.

B DTM02 373 DT 06 Expected shipment date. YYMMDD.

This segment is mandatory.

69

Transaction Set 824 Application Advice VERSION 003040

QTY - Quantity Segment

Example:

A B

QTY*39*50

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A QTY01 673 ID 02 Quantity qualifier. TMS uses “39” to

indicate shipped quantity.

“39” = Shipped quantity.

B QTY02 380 R 07 Quantity.

This segment is mandatory.

You will need the TMS Quantity

to help resolve the 824 problems.

70

Transaction Set 824 Application Advice VERSION 003040

TED - Technical Error Segment

Example:

A

TED*007

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A TED01 354 N0 06 Application error condition code.

TMS uses “007” to indicate missing

data.

“007” = Missing Data.

This segment is optional.

The “007” Missing Data” error indicates

that these parts/PO are missing based on

the 862 Shipping Schedule. You need to

contact you TMS procurement analyst to

verify this information and send the

missing parts/PO and 856 if requested.

Once the 856 have been sent the 824 will

stop being transmitted to you.

71

830 Material Release

72

Transaction Set 830 Material Release VERSION 002003

Segment ID Segment Name Description

ISA Interchange control

header.

Identifies sender and receiver and other key

transmission data.

GS Functional group

header.

Identifies specific application of sender and

receiver.

ST Transaction set header. Indicates start of transaction set and assigns control

number.

BFR Beginning segment for

planning schedule.

Indicates start of planning schedule. Includes

beginning and ending dates.

N1 Name. Identifies material release issuer.

PER Administrative

communication contact.

Identifies the person to whom administrative

communication should be directed (TMS analyst).

LIN Item identification

detail.

Specifies basic item identification data: part

number, part description, supplier part number,

purchase order number.

UIT Unit detail. Unit of measurement.

N1 Name. Indicates whether to ship direct or use routing slip.

N2 Additional name and

address information.

Identifies the name and street address of the final

destination.

N3 Additional address

information.

Identifies the city, state, and zip code of the final

destination.

SDP Ship/delivery pattern. Identifies specific ship/delivery patterns.

FST Forecast schedule. In case of a firm order, this segment will be used to

specify order date, and order quantity. In case of a

forecast, it will be used to specify forecasts’ dates

and quantities.

CTT Transaction totals. Used to transmit a total for a specific element in

the transaction.

SE Transaction set trailer. Indicates the end of the transaction and provides a

count of the transmitted segments.

GE Functional group

trailer.

Indicates the end of a functional group.

IEA Interchange control

trailer.

Indicates the end of the interchange.

73

Transaction Set 830 Material Release VERSION 002003

BFR - Beginning Planning Schedule Segment

Example:

A B C D E F G

BFR*05*0236A**SH*A*960331*960331*960331

REF Element

ID

Element

Number

Data

Type

Max

Length

Description

A BFR01 353 ID 02 Transaction set purpose code. TMS

uses “05" which indicates replace.

“05” = Replace

B BFR02 127 AN 05 TMS assigned vendor code.

C BFR04 675 ID 02 Forecast type qualifier. TMS uses

“SH” which will indicate shipment

based.

“SH” = Shipment based

D BFR05 676 ID 01 Forecast quantity qualifier. TMS uses

“A” to indicate actual quantities.

“A” = Actual quantities.

E BFR06 373 DT 06 Start date. In case of a forecast, this is

the date when the forecast horizon

starts. In case of a firm order only (no

forecasts), this field will contain

current date.

YYMMDD.

F BFR07 373 DT 06 End date. In case of a forecast this is

the date when the forecast horizon

ends. In case of a firm order only (no

forecast), this field will contain current

date.

YYMMDD.

G BFR08 373 DT 06 Run date. This field will contain

current date.

This segment is mandatory.

74

Transaction Set 830 Material Release VERSION 002003

N1 - Name Segment

Example:

A B C D

N1*MI*TOYOTA MOTOR SALES, USA*01*009595505

REF Element

ID

Element

Number

Data

Type

Max

Length

Description

A N101 98 ID 02 Entity identifier code. TMS uses “MI”

to indicate planning schedule /

material release issuer.

“MI” = Planning schedule/material

release issuer.

B N102 93 AN 22 Release issuer’s name.

C N103 66 ID 02 Identification code qualifier. TMS

uses “01” to indicates DUNS number.

“01” = DUNS number to be used.

D N104 67 ID 09 Identification code. TMS uses DUNS

number.

This segment is mandatory.

75

Transaction Set 830 Material Release VERSION 002003

PER - Administrative Communication Contact Segment

Example:

A B C D

PER*SC*NANCY BORDEN*TE*310-618-4000

REF Element

ID

Element

Number

Data

Type

Max

Length

Description

A PER01 366 ID 02 Contact Function code. TMS uses

“SC” to indicate a schedule

contact/analyst.

“SC” = Schedule Contact/Analyst

B PER02 93 AN 20 Contact/analyst name.

C PER03 365 ID 02 Communication number qualifier.

TMS uses “TE” to indicate a

telephone number.

“TE” = Telephone Number.

D PER04 364 AN 12 Communication number. TMS maps

the phone number to this field.

This segment is mandatory

76

Transaction Set 830 Material Release VERSION 002003

LIN - Item Identification Segment

Example:

A B C D E F G H I J

LIN**BP*0488114040*VP*N/A*PD*GASKET KIT*PO*OS123456*ON*CC7183VE

REF Element

ID

Element

Number

Data

Type

Max

Length

Description

A LIN02 235 ID 02 Product/service ID qualifier. TMS

uses “BP” to indicate a buyers part.

“BP” = Buyers Part.

B LIN03 234 AN 15 TMS part number.

C LIN04 235 ID 02 Product/service ID qualifier. TMS

uses “VP” to indicate a vendor’s part

number.

“VP” = Vendor’s Part Number.

D LIN05 234 AN 20 Vendor’s part number. If a vendor’s

part number does not exist, this field

will contain “N/A”.

E LIN06 235 ID 02 Product/Service ID qualifier. TMS

uses “PD” to indicate part description.

“PD” = Part Description.

F LIN07 234 AN 20 TMS part description.

G LIN08 235 ID 02 Product/service ID qualifier. TMS

uses “PO” to indicate a purchase order.

“P.O.” = Purchase Order Number.

H LIN09 234 AN 08 Purchase order number. If this is a

forecast, P.O. Number will be “N/A”

I LIN10 235 ID 02 Product/service ID qualifier. TMS

uses “ON” to indicate a customer order

number.

“ON” = Customer Order Number.

J LIN11 234 AN 08 Distributor/dealer order number. If

none exists, this field will default to

spaces.

This is only for direct ship. Otherwise

it will contain a default value of

spaces.

This segment is mandatory.

77

Transaction Set 830 Material Release VERSION 002003

UIT - Unit Detail Segment

Example:

A

UIT*PC

REF Element

ID

Element

Number

Data

Type

Max

Length

Description

A UIT01 355 ID 02 Unit of measurement code. TMS uses

“PC” to indicate pieces.

“PC” = Pieces.

This segment is mandatory.

78

Transaction Set 830 Material Release VERSION 002003

N1 - Name Segment

Example 1 (Normal order):

A B C D

N1*ST*SEE ROUTING SLIP*92*99999

Example 2 (Direct ship/VOR order):

A B C D

N1*ST*SHIP DIRECT*92*04136

A B

N1*MA*E. JOHNSON

REF Element

ID

Element

Number

Data

Type

Max

Length

Description

A N101 98 ID 02 Entity Identifier code. TMS uses “ST”

to indicate a ship-to location.

“ST” = Ship-To Location

B N102 93 AN 20 Ship to name. This field will contain

“SEE ROUTING SLIP” for normal

orders and “SHIP DIRECT” for ship

direct orders.

C N103 66 ID 02 ID code qualifier. TMS uses “92” to

indicate a mutually defined ID code

between TMS and the vendor.

“92” = Mutually defined ID code

D N104 67 ID 05 In case of the direct ship order, this

field will contain the dealer code.

Otherwise it will default to “99999”.

A N101 98 ID 02 Entity identifier code. TMS uses

“MA” to indicate a customer name.

“MA” = Customer Name

B N102 93 AN 20 This field will contain the customer in

case of direct ship/VOR orders.

Otherwise it will default to spaces.

This segment is optional. It will occur only in case of a firm order or a combination of a firm and

forecast orders. It will not occur for forecast only orders.

79

Transaction Set 830 Material Release VERSION 002003

N2 - Additional Name information Segment

Example 1 (Normal order):

A B

N2*KY*KENTUCKY

Example 2 (Direct ship/VOR order):

A B

N2*LONGO TOYOTA*3534 NORTH PENN ROAD

REF Element

ID

Element

Number

Data

Type

Max

Length

Description

A N201 93 AN 35 Final destination. In case of a firm

order, this field will contain a TMS

depot code. Otherwise it will contain

the dealer name. Valid depot codes

are:

“51” = Ontario

“KY” = Kentucky

B N202 93 AN 35 In case of a firm order, this field will

contain the TMS depot name.

Otherwise it will contain the dealer

street address.

This must follow the N1 segment.

80

Transaction Set 830 Material Release VERSION 002003

N3 - Address Information Segment

Example:

A B

N3*EL MONTE CA*91731

REF Element

ID

Element

Number

Data

Type

Max

Length

Description

A N301 166 AN 35 Dealer city and state.

B N302 166 AN 35 Dealer zip code.

This segment is optional. It will occur only for ship direct orders. It must be preceded by an N1 and

an N2 segments.

81

Transaction Set 830 Material Release VERSION 002003

SDP - Ship/Delivery Pattern Segment

Example:

A B

SDP*N*F This example says to ship as directed according to the contract.

Example:

A B

SDP*Z*Z This example says that there is no shipping pattern. This will indicate that this is a

forecast.

REF Element

ID

Element

Number

Data

Type

Max

Length

Description

A SDP01 678 ID 01 Ship/delivery pattern code.

TMS uses “N” to indicate as directed.

This tells what time of week deliveries

occur.

“N” = As Directed

“Z” = Mutually Define

B SDP02 679 ID 01 Ship/delivery pattern time code.

TMS uses “F” to indicate the time of

day deliveries occur.

“F” = Time of Day

“Z” = Mutually Define

This segment is mandatory.

82

Transaction Set 830 Material Release VERSION 002003

FST - Forecast Schedule Segment

Example 1 (Firm order):

A B C D

FST*150*C*M*980401

FST* 50*D*M*980501

FST* 50*D*M*980601

FST* 50*D*M*980701

The above example indicates a Firm Order with three forecast segments. The firm order quantity of

150 represents the firm order quantity to the supplier for the month of April. The first FST is for a

quantity of 50 for the month of May. The second FST is for a quantity of 50 for the month of June

and the third is for a quantity of 50 for the month of July.

Example 2 (Forecast order):

A B C D

FST*25*D*M*980401

FST*25*D*M*980501

FST*25*D*M*980601

FST*25*D*M*980701

The above example indicates a Forecast Order with three forecast segments. The first FST is the

forecast order quantity of 25 for the month of April. The second FST is for a quantity of 25 for the

month of May. The third FST is for a quantity of 25 for the month of June, and the last FST is for a

quantity of 25 for the month of July. A FST segment will only be created if there is a forecast amount.

83

Transaction Set 830 Material Release VERSION 002003

REF Element

ID

Element

Number

Data

Type

Max

Length

Description

A FST01 380 R 07 Quantity.

B FST02 680 ID 01 Forecast qualifier. TMS use “C” to

indicate a firm order, and “D” to

indicate a forecast order.

“C” = Firm Order

“D” = Forecast Order

C FST03 681 ID 01 Forecast timing qualifier. TMS uses

“M” to indicate monthly orders, “W”

to indicate weekly orders, and “Z” to

indicate contract period.

“D” = Daily

“W” = Weekly

“M” = Monthly

“Z” = Contract Period

D FST04 373 DT 06 In case of a forecast this field will

contain the beginning date of the

forecast. Otherwise, it will contain

current date for firm orders.

YYMMDD.

This segment is mandatory.

84

Transaction Set 830 Material Release VERSION 002003

CTT - Transaction Totals Segment

Example:

A

CTT*01

REF Element

ID

Element

Number

Data

Type

Max

Length

Description

A CTT01 354 N0 06 Number of LIN segments

This segment is mandatory.

85

861 Receiving Advice

86

Transaction Set 861 Receiving Advice VERSION 003040

Segment ID Segment Name Description

ISA Interchange control

header.

Identifies sender and receiver and other key

transmission data.

GS Functional group

header.

Identifies specific application of sender and

receiver.

ST Transaction set header. Indicates start of transaction set and assigns control

number.

BRA Beginning segment for

receiving advice.

Contains shipment identification and shipment

date.

DTM Date/time reference. Identifies shipment date.

N1 Name. Identifies vendor code.

RCD Receiving condition. Identifies rejected quantity, damaged quantity,

overage quantity, shortage quantity and pay

quantity.

SN1 Item detail (shipment). Identifies vendor shipped quantity.

LIN Item identification. Indicates buyer part number.

PRF Purchase order

reference.

Identifies purchase order number and purchase

order date.

CTT Transaction totals. Contains a hash total for a specific segment.

Number of LIN segment.

SE Transaction set trailer. Indicates the end of the transaction and provides a

count of the transmitted segments.

GE Functional group

trailer.

Indicates the end of a functional group.

IEA Interchange control

trailer.

Indicates the end of the interchange.

87

Transaction Set 861 Receiving Advice VERSION 003040

BRA - Receiving Advice Beginning Segment

Example:

A B C D

BRA*616524367687622*960202*00*2

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A BRA01 127 AN 15 Reference number. Shipment

identification.

B BRA02 373 DT 06 Date. Shipment date.

YYMMDD.

C BRA03 353 ID 02 Transaction purpose code. TMS uses

“00” to indicate an original document.

“00” = Original.

D BRA04 962 ID 01 Receiving advice type code. TMS

uses “2” to indicate post receipt

advice.

“2” = Post receipt advice.

This segment is mandatory.

88

Transaction Set 861 Receiving Advice VERSION 003040

DTM - Date/Time Segment

Example:

A B

DTM*011*960202

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A DTM01 374 ID 03 Date qualifier. TMS uses “011” to

indicate date shipped.

“011” = Date shipped.

B DTM02 373 DT 06 Date. Shipment date.

YYMMDD.

This segment is mandatory.

89

Transaction Set 861 Receiving Advice VERSION 003040

N1 - Name Segment

Example:

A B C

N1*VN**92*0123A

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A N101 98 ID 02 Entity identifier code. TMS uses

“VN” to indicate vendor code.

“VN” = Vendor Code.

B N103 66 ID 02 Identification code qualifier. TMS

uses “92" to indicate assigned by

buyer.

“92” = Assigned by buyer.

C N104 67 ID 02 Identification code. TMS assigned

vendor code.

This segment is mandatory.

90

Transaction Set 861 Receiving Advice VERSION 003040

RCD - Receiving Conditions Segment

Example:

A B C D E F G H I J K L M N

RCD**50*PC***10*PC*01*10*PC*02*04*PC*03*10*PC*08

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A RCD02 663 R 07 Quantity received by the warehouse.

B RCD03 355 ID 02 Unit of measurement code. TMS uses

“PC” to indicate pieces.

“PC” = Pieces.

C RCD06 667 R 07 Quantity in question. Damaged

quantity.

D RCD07 355 ID 02 Unit of measurement code. TMS uses

“PC” to indicate pieces.

“PC” = Pieces.

E RCD08 412 ID 02 Receiving condition code. TMS uses

“01” to indicate damaged quantity.

F RCD09 667 R 07 Quantity in question. Shortage

quantity.

G RCD10 355 ID 02 Unit of measurement code. TMS uses

“PC” to indicate pieces.

“PC” = Pieces.

H RCD11 412 ID 02 Receiving condition code. TMS uses

“02” to indicate shortage quantity.

I RCD12 667 R 07 Quantity in question. Overage

quantity.

J RCD13 355 ID 02 Unit of measurement code. TMS uses

“PC” to indicate pieces.

“PC” = Pieces.

K RCD14 412 ID 02 Receiving condition code. TMS uses

“03” to indicate overage quantity.

L RCD15 667 R 07 Quantity in question. Rejected

quantity.

M RCD16 355 ID 02 Unit of measurement code. TMS uses

“PC” to indicate pieces.

“PC” = Pieces.

N RCD17 412 ID 02 Receiving condition code. TMS uses

“08” to indicate rejected quantity.

This segment is mandatory.

91

Transaction Set 861 Receiving Advice VERSION 003040

SN1 - Item Detail (Shipment) Segment

Example:

A B

SN1**80*PC

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A SN102 382 R 09 Number of unites shipped. Vendor

shipped quantity.

B SN103 355 ID 02 Unit of measurement code. TMS uses

“PC” to indicate pieces.

“PC” = Pieces.

This segment is mandatory.

92

Transaction Set 861 Receiving Advice VERSION 003040

LIN - Item Identification Segment

Example:

A B

LIN**BP*123456789012345

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A LIN02 233 ID 02 Product/service ID qualifier. TMS

uses “BP” to indicate part number.

“BP” = Part Number.

B LIN03 234 AN 15 Product/service ID. Part number.

This segment is mandatory.

93

Transaction Set 861 Receiving Advice VERSION 003040

PRF - Purchase Order Reference Segment

Example:

A B

PRF*OS123456***960125

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A PRF01 324 AN 08 Customer purchase order number.

B PRF03 323 DT 06 Purchase order date. YYMMDD.

This segment is mandatory.

94

Transaction Set 861 Receiving Advice VERSION 003040

CTT - Transaction Total Segment

Example:

A

CTT*01

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A CTT01 354 N0 06 Number of LIN segments.

This segment is mandatory.

95

862 Shipping Schedule

96

Transaction Set 862 Shipping Schedule VERSION 003040

Segment ID Segment Name Description

ISA Interchange control

header.

Identifies sender and receiver and other key

transmission data.

GS Functional group

header.

Identifies specific application of sender and

receiver.

ST Transaction set header. Indicates start of transaction set and assigns control

number.

BSS Beginning segment for

shipping schedule.

Indicates the start of shipping schedule. Includes

the process date.

N1 Name Identifies the ship-to depot, supplier, and vendor.

N2 Additional name

information.

Contains name and street address for direct-ship

orders.

N4 Geographical location. Contains that city, state, and zip code for direct-

ship orders.

REF Reference numbers. Contains the dealer/distributor order number for

direct-ship orders.

LIN Item identification

detail.

Indicates basic item identification data part

number, part description, purchase order number.

And line item number.

UIT Unit detail. Unit of measurement.

REF Reference numbers. Identifies the home position of a part at the

warehouse.

FST Forecast schedule. Indicates scheduled shipment quantity and

expected shipment date.

TD5 Carrier detail. Identifies transport method.

CTT Transaction totals. Indicates total number of LIN segments in the

transaction.

SE Transaction set trailer. Indicates the end of the transaction and provides a

count of the transmitted segments.

GE Functional group

trailer.

Indicates the end of a functional group.

IEA Interchange control

trailer.

Indicates the end of the interchange.

97

Transaction Set 862 Shipping Schedule VERSION 003040

BSS - Shipping Schedule Beginning Segment

Example:

A B C D E F G H

BSS*00*OS123456*960225*SH*960301*960315*OS123456***A

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A BSS01 353 ID 02 Transaction purpose code. TMS uses

“00” to indicate original.

“00” = Original.

B BSS02 127 AN 08 Reference number. TMS purchase

order number.

C BSS03 373 DT 06 Run date. YYMMDD.

D BSS04 675 ID 02 Forecast type qualifier. TMS uses

“SH” to indicate shipment based.

“SH” = Shipment based.

E BSS05 373 DT 06 Date. This field will contain the begin

shipment date. YYMMDD.

F BSS06 373 DT 06 Date. This field will contain the end

shipment date. YYMMDD.

G BSS07 328 AN 08 TMS Purchase order number.

H BSS11 676 ID 01 Forecast quantity qualifier. TMS uses

“A” to indicate actual discreet

quantities.

“A” = Actual discreet quantities.

This segment is mandatory.

98

Transaction Set 862 Shipping Schedule VERSION 003040

N1 - Name Segment

Example:

A B C

N1*ST**92*KY (normal order)

A B C

N1*BY**92*TMM

A B C

N1*SU**92*0234A

A B

N1*MA*JOHN DOE (Direct ship/VOR orders)

N1*ST*DIRECT SHIP*92*04136 (Direct Ship/VOR orders)

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A N101 98 ID 02 Entity identifier code. TMS uses “ST”

to indicate ship-to.

“ST” = Ship to.

The field will contain “DIRECT

SHIP” in case of a direct-ship/VOR

order.

B N103 66 ID 02 Identification code qualifier. TMS

uses “92” to indicate assigned by

buyer.

“92” = Assigned by buyer.

C N104 67 ID 05 Identification code. TMS assigned

depot code. Valid codes are:

“51” = Ontario

“KY” = Kentucky

In case of a direct ship/VOR order, this

field will contain the dealer code.

A N101 98 ID 02 Entity identifier code. TMS uses

“BY” to indicate buying party.

“BY” = Buying Party.

B N103 66 ID 02 Identification code qualifier. TMS

uses “92" to indicate assigned by

buyer.

“92” = Assigned by buyer.

C N104 67 ID 05 Identification code. TMS assigned

supplier code.

99

A N101 98 ID 02 Entity identifier code. TMS assigned

supplier code.

“SU” = Supplier Code.

B N103 66 ID 02 Identification code qualifier. TMS

uses “92" to indicate assigned by

buyer.

“92” = Assigned by buyer.

C N104 67 ID 05 Identification code. TMS assigned

vendor code.

A N101 98 ID 02 Entity identifier code. TMS uses

“MA” to indicate customer name.

“MA” = Customer Name

B N102 93 AN 20 Identifies the customer name (if

available) in case of direct-ship orders

only.

The first 3 iterations of this segment are mandatory. The fourth iteration is optional and can occur

only in case of direct-ship orders.

100

Transaction Set 862 Shipping Schedule VERSION 003040

N2 - Additional Name information Segment

Example:

A B

N2*POTAMKIN TOYOTA, INC*860 BALTIMORE PIKE

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A N201 93 AN 35 Dealer name.

B N202 93 AN 35 Dealer street address.

This segment is optional. It will be used with direct-ship/VOR orders only.

101

Transaction Set 862 Shipping Schedule VERSION 003040

N4 - Geographical Location Segment

Example:

A B C

N4*SPRINGFIELD*PA*19064

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A N401 19 AN 30 City.

B N402 156 ID 02 State.

C N403 116 ID 09 Zip code.

This segment is optional. It will be used with direct-ship/VOR orders only.

102

Transaction Set 862 Shipping Schedule VERSION 003040

REF - Reference Number

Example:

A B

REF*CR*MA1234

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A REF01 128 ID 02 Reference number qualifier. TMS

uses “CR” to indicate customer

reference number.

“CR” = Customer Reference

B REF02 127 AN 08 Reference number. Dealer/distributor

order number.

This segment is optional. It will be used with direct-ship orders only.

103

Transaction Set 862 Shipping Schedule VERSION 003040

LIN - Item Identification Segment

Example:

A B C D E F G H

LIN**BP*A12345678901*PD*FRONT BUMPER*PL*00001*PO*OS123456

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A LIN02 235 ID 02 Product/service ID qualifier. TMS

uses “BP” to indicate a buyers part.

“BP” = Buyers Part.

B LIN03 234 AN 15 TMS part number.

C LIN04 235 ID 02 Product/service ID qualifier. TMS

uses “PD” to indicate part description.

“PD” = Part description.

D LIN05 234 AN 20 Part description.

E LIN06 235 ID 02 Product/Service ID qualifier. TMS

uses “PL” to indicate line number.

“PL” = Line number.

F LIN07 234 AN 05 Line item number.

G LIN08 235 ID 02 Product/service ID qualifier. TMS

uses “PO” to indicate a purchase order.

“P.O.” = Purchase Order Number.

H LIN09 234 AN 08 Purchase order number.

This segment is mandatory.

104

Transaction Set 862 Shipping Schedule VERSION 003040

UIT - Unit Detail Segment

Example:

A

UIT*PC

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A UIT01 355 ID 02 Unit of measurement code. TMS uses

“PC” to indicate pieces.

“PC” = Pieces.

This segment is mandatory.

105

Transaction Set 862 Shipping Schedule VERSION 003040

REF - Reference Number

Example:

A B

REF*WS*AA

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A REF01 128 ID 02 Reference number qualifier. TMS

uses “WS” to indicate warehouse

storage location number.

“WS” = Warehouse Storage.

B REF02 127 AN 02 Reference number. Home position of

the part at the warehouse.

This segment is mandatory.

This segment is part of the LIN loop.

106

Transaction Set 862 Shipping Schedule VERSION 003040

FST - Forecast Schedule Segment

Example:

A B C D

FST*50*C*D*960301

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A FST01 380 R 07 Quantity. Scheduled quantity for this

shipment date.

B FST02 680 ID 01 Forecast qualifier. TMS use “C” to

indicate a firm order.

“C” = Firm Order.

C FST03 681 ID 01 Forecast timing qualifier. Indicates

type of period of shipment such as

weekly or monthly. Since this

information is specified in the contract,

TMS uses “D” to indicate that.

D FST04 373 DT 06 Date. Scheduled shipment date.

YYMMDD.

This segment is mandatory.

107

Transaction Set 862 Shipping Schedule VERSION 003040

TD5 - Carrier Detail Segment

Example :

A B

TD5*B***A

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A TD501 133 ID 01 Routing sequence code. TMS uses

“B” to indicate origin/delivery carrier

(any mode).

“B” = Any Mode.

B TD504 91 ID 02 Transportation method code. TMS

will use the following codes:

“A” for air

“D” for parcel post

“M” for motor

“R” for rail

“VE” for vessel.

This segment is mandatory.

108

Transaction Set 862 Shipping Schedule VERSION 003040

CTT - Transaction Totals Segment

Example:

A

CTT*01

Element

Position

Element

ID

Element

Number

Data

Type

Max

Length

Description

A CTT01 354 N0 06 Number of LIN segments.

This segment is mandatory.

109

Samples of TMS Transactions

110

856 Samples

4 types of approved TMS ASN (856) scenarios

Example 1:

1) One part number qty 10 going into a one case.

a. Part A qty 10 case # XXX00001

Example 2:

2) One part number qty 90 going into multiple cases.

a. Part B qty 20 case # XXX00002

b. Part B qty 20 case # XXX00003

c. Part B qty 20 case # XXX00004

d. Part B qty 20 case # XXX00005

e. Part B qty 10 case # XXX00006

Example 3:

3) More than one part number going into one case.

a. Part C qty 2 case # XXX00007

b. Part D qty 5 case # XXX00007

c. Part E qty 10 case #XXX00007

Example 4:

4) Multiple purchase order numbers on one ASN

a. Purchase order # TS212345

Part F qty 2 case # XXX00008

Part G qty 2 case # XXX00008

Part H qty 2 case # XXX00008

Part I qty 2 case # XXX00008

Purchase order # TA212360

Part J qty 2 case # XXX00009

Part K qty 2 case # XXX00009

Part L qty 2 case # XXX00009

Part M qty 2 case # XXX00009

See the following examples for detailed information:

111

856 Samples (continued)

ISA*00* *00* *01*999999999 *01*009595505 *011212*165

2*U*00200*000000003*1*P*:…

GS*SH*999999999219*009595505*011212*1652*3*X*002003…

ST*856*000000003…

BSN*00*3121282988*011212*1652…

DTM*011*011212*1651…

HL*1**S*1…

MEA*PD*G*287*LB…

MEA*PD*N*271*LB…

TD1*PAF94*15…

TD5*B*2*HMES*LT…

REF*BM*3121282988…

N1*ST**92*KY…

HL*2*1*O*1…

PRF*TS109388…

REF*MH*TS109388121201…

N1*SU**92*0219X…

HL*3*2*I*0…

LIN**BP*82641AB030*VN*26*CA*21900278…

SN1**10*PC…

HL*4*2*I*0…

LIN**BP*82641AB030*VN*26*CA*21900280…

SN1**10*PC…

HL*5*2*I*0…

LIN**BP*82641AB030*VN*26*CA*21900281…

SN1**10*PC…

HL*6*2*I*0…

LIN**BP*82641AB030*VN*26*CA*21900282…

SN1**10*PC…

HL*7*2*I*0…

LIN**BP*82641AB030*VN*26*CA*21900283…

SN1**10*PC…

HL*8*2*I*0…

LIN**BP*82641AB030*VN*26*CA*21900284…

SN1**10*PC…

HL*9*2*I*0…

LIN**BP*82641AB030*VN*26*CA*21900285…

SN1**10*PC…

HL*10*2*I*0…

LIN**BP*82641AB030*VN*26*CA*21900286…

SN1**10*PC…

HL*11*2*I*0…

LIN**BP*82641AB030*VN*26*CA*21900287…

SN1**10*PC…

HL*12*2*I*0…

LIN**BP*82641AB030*VN*26*CA*21900288…

SN1**10*PC…

Example # 2

112

856 Samples (continued)

HL*13*2*I*0…

LIN**BP*8824002040*VN*28*CA*21900274…

SN1**18*PC…

HL*14*2*I*0…

LIN**BP*8917002140*VN*30*CA*21900274…

SN1**66*PC…

HL*15*2*I*0…

LIN**BP*8917002140*VN*30*CA*21900275…

SN1**100*PC…

HL*16*2*I*0…

LIN**BP*8966102672*VN*32*CA*21900276…

SN1**8*PC…

HL*17*2*I*0…

LIN**BP*8966102682*VN*34*CA*21900276…

SN1**4*PC…

HL*18*2*I*0…

LIN**BP*8966102722*VN*35*CA*21900276…

SN1**2*PC…

HL*19*2*I*0…

LIN**BP*8966102811*VN*38*CA*21900277…

SN1**18*PC…

HL*20*2*I*0…

LIN**BP*8966102361*VN*40*CA*21900278…

SN1**4*PC…

HL*21*2*I*0…

LIN**BP*8966102551*VN*42*CA*21900279…

SN1**22*PC…

HL*22*2*I*0…

LIN**BP*8966102561*VN*44*CA*21900279…

SN1**62*PC…

CTT*22…

SE*76*000000003…

GE*1*3…

IEA*1*000000003…

Example # 3

Example # 1

Example # 3

Example # 1

Example # 3

113

856 Samples (continued)

ISA*00* *00* *01*999999999 *01*009595505

*020430*1240*U*00200*000019387*0*T*:~

GS*SH*999999999219*009595505*020430*1240*19538*X*002003~

ST*856*000086572~

BSN*00*000000000000014*020430*1239~

DTM*011*020430*1025~

HL*1**S*1~

MEA*PD*G*14500*LB~

MEA*PD*N*2000*LB~

TD1*BOX90*80~

TD5*B*2*RDWY*LT~

REF*BM*0000000029~

N1*ST**92*KY~

HL*2*1*O*1~

PRF*TS200001~

REF*MH*00130034~

N1*SU**92*0219X~

HL*3*2*I*0~

LIN**BP*861500W020*VN*0002*CA*21900001~

SN1**10*PC~

HL*4*2*I*0~

LIN**BP*861000W030*VN*0003*CA*21900002~

SN1**10*PC~

HL*5*2*I*0~

LIN**BP*861600W090*VN*0004*CA*21900003~

SN1**10*PC~

HL*6*2*I*0~

LIN**BP*86280AC043*VN*0005*CA*21900004~

SN1**10*PC~

HL*7*2*I*0~

LIN**BP*861600W240*VN*0006*CA*21900005~

SN1**10*PC~

HL*8*2*I*0~

LIN**BP*862800W070*VN*0001*CA*21900006~

SN1**10*PC~

HL*9*1*O*1~

PRF*TS200004~

REF*MH*00130034~

N1*SU**92*0219X~

HL*10*2*I*0~

LIN**BP*861500W020*VN*0002*CA*21900007~

SN1**10*PC~

CTT*10~

SE*44*000086572~

GE*1*19538~

IEA*1*000019387~

Example # 4

114

856 Samples (continued)

READ THE FOLLOWING INFORMATION VERY CAREFULLY!

If you transmit the ASN thru the TMS EDI system it will reject or suspend if you have not followed the ASN

Business Rules:

1. ASN Business Rules:

a. Looping for multiple purchase orders 2 Separate purchase orders that are on the same ASN: Incorrect Example:

Purchase order TS123456 Purchase order TS123457 Part 1234567895 Part 1234567896 Part 2234567891 Part 2234567892

Correct Example: Purchase order TS123456 Part 1234567895 Part 1234567896 Purchase order TA123457 Part 2234567891 Part 2234567892

b. Looping for multiple case numbers for same part number 50 qty of a part number going into 3 cases example: Incorrect Example:

1234567891 qty 50 case # 99900008 Correct Example:

1234567891 qty 20 case # 99900002 1234567891 qty 20 case # 99900003 1234567891 qty 10 case # 99900004

c. Looping for multiple part numbers in one case Part 1234567892, 1234567893, 1234567894 going into one case example: Incorrect Example:

1234567892 qty 2 case #99900010 1234567893 qty 4 case #99900011 1234567894 qty 6 case #99900012

Correct Example: 1234567892 qty 2 case #99900006 1234567893 qty 4 case #99900006 1234567894 qty 6 case #99900006

d. Case numbers that do not begin with your 3 digit trading partner ID Incorrect Example:

ZZZ12345 Correct Example

99912345 e. Case numbers that are not 8 digits

Incorrect Example: 999123

Correct Example 99912345

f. Part numbers should not contain ‘00’ on the end Incorrect Example:

123456789100 Correct Example:

1234567891 g. Part numbers should not contain any dashes

Incorrect Example: 123-456-7891

Correct Example: 1234567891

115

861 Sample

ST*861*000000003

BRA*SHIPID000000001*960220*00*2

DTM*011*960220

N1*VN**92*0424A

RCD**24*PC****PC*01**PC*02**PC*03*1*PC*08

SN1**25*PC

LIN**BP*1234567890AAAAA

PRF*TS111111***960215

RCD**23*PC***2*PC*01**PC*02**PC*03**PC*08

SN1**25*PC

LIN**BP*1234567890BBBBB

PRF*TS222222***960215

CTT*2

SE*14*000000003

116

820 Sample

`

ST 820 000000021

BPR I 49266 C ACH

REF SI SHIPID000000001

REF IV SHIPID000000001

DTM 011 960208

DTM 003 960210

DTM 020 960212

N1 VN 92 029AA

ENT 999999

ADX 50278 01 SI SHIPID000000001

IT1 25 PC 20111 PO TS111111 BP 1234567890AAAAA

RMR SI SHIPID000000001 ER 24266

IT1 24 PC 10111 PO TS111111 BP 1234567890AAAAA

RMR SI SHIPID000000001 ER 23000

IT1 23 PC 10000 PO TS222222 BP 1234567890BBBBB

ITA A C0020 02

ITA A DI 02

ITA C S0022 06

ITA C PC 06 1000

ITA C FC 06

ITA C 315 06 1000

ITA C 240 06

ITA C ZZ 06

ITA C TX 06

SE 25 000000021

117

824 Sample

ST*824*000000001

BGN*12*PS300*960223

N1*VN**92*0367A

OTI*TR*PO*TS999999*******856

REF*BP*1234567890AAAAA

DTM*011*960304

QTY*39*20

TED*007

SE*9*000000001

118

830/862 Monthly Order Sample

830/862 Supplemental Order Sample

830/862 VOR Order Sample

119

830/862 Daily Order Sample

830 Monthly Preorder – Daily Order Part Sample

830 Monthly Forecast – Monthly Ordered Part With No Firm Order Qty Sample