• No results found

Required EDI Documents – Maps

In document VDP Program Vendor Guidelines (Page 13-47)

This section describes AutoZone's file formats for these EDI documents:

850 Purchase Order 846 Inventory Inquiry/Advice 856 Advance Shipping Notices 810 Invoice

EDI Document 850 -- AutoZone Purchase Order (pg. 1 of 7)

ISA -- Interchange Control Header Segment ISA01 I01 Authorization Information

Qualifier

'00' = No meaningful data in ISA02.

ISA02 I02 Authorization Information May contain any 10 characters including 10 spaces or 10 zeros.

ISA03 I03 Security Information Qualifer 00' = No meaningful data in ISA04.

ISA04 I04 Security Information May contain any 10 characters including 10 spaces or 10 zeros.

ISA05 I05 Interchange ID Qualifier (Sender)

May contain any valid ANSI code for this element.

ISA06 I06 Interchange Sender ID AutoZone's ID depending on the code in ISA05.

ISA07 I05 Interchange ID Qualifier (Receiver)

May contain any valid ANSI code for this element.

ISA08 I07 Interchange Receiver ID Your ID depending on the code in ISA07.

ISA09 I08 Interchange Date The date the envelope was created in YYMMDD format.

ISA10 I09 Interchange Time The time the envelope was created in HHMM format.

ISA11 I10 Interchange Control

Standards ID

'U' = U.S. EDI community.

ISA12 I11 Interchange Control Version Number

'00400'

ISA13 I12 Interchange Control Number The number AutoZone has assigned to the transaction which uniquely identifies this transmission.

ISA14 I13 Acknowledgement Requested 0' = No Acknowledgement Requested '1' = Acknowledgement Requested (Not the 997 transaction set).

ISA15 I14 Test Indicator T' = Test Data

'P' = Production Data.

ISA16 I15 Sub-Element '>' Greater Than Relational Operator.

EDI Document 850 -- AutoZone Purchase Order (pg. 2 of 7)

Element Position

Data Element Number

Data Element Name Remarks

GS -- Functional Group Header

GS01 479 Functional ID Code 'PO' = Purchase Order.

GS02 142 Application Sender Code AutoZone's ID (Our DUNS number).

GS03 124 Application Receiver code Your ID (Usually your DUNS number).

GS04 373 Group Date Date a functional group of transaction sets was generated in CCYYMMDD format.

GS05 337 Group Time Time a functional group of transaction sets was generated in HHMM format.

GS06 28 Group Control Number Number AutoZone assigned to this functional group;

this same number will be in GE02 and in the 997 functional acknowledgement for this functional group.

GS07 455 Responsible Agency Code 'X' = ANSI X12.

GS08 480 Version/Release Industry ID Code

004010' to represent the ANSI X12 version we are sending.

ST -- Transaction Set Header

ST01 143 Transaction Set ID Code '850' = Purchase Order.

ST02 329 Transaction Set Control Number

A unique number AutoZone assigns to this transaction set; also appears in SE02.

EDI Document 850 -- AutoZone Purchase Order (pg. 3 of 7)

Element Position

Data Element Number

Data Element Name Remarks

BEG -- Beginning Segment of Purchase Orders BEG01 353 Transaction Set Purpose

Code

'00' = Original Purchase Order.

BEG02 92 Purchase Order Type

Code

'NE' = New order.

BEG03 324 Purchase Order Number A unique number for this order.

BEG04 328 Purchase Order Release Number

00' = Original release of a purchase order Greater than '00' = Backorder.

BEG05 373 Purchase Order Date The date the purchase order was created in CCYYMMDD format.

DTM -- Date/Time Information

DTM01 374 Date/Time Qualifier 074' = Requested for delivery (prior to and including) the date in DTM02.

'068' = Current scheduled ship date.

This code will represent the date merchandise should be ready to ship.

DTM02 373 Date If DTM01 is '074': This date represents the

requested delivery date (on or before) that AutoZone expects the merchandise to be at the AutoZone distribution center.

If DTM01 is '068': This date indicates the shipment date AutoZone expects the merchandise to be ready to be shipped.

DTM Note: The DTM with the 074 qualifier will be sent to all vendors. The DTM with the 068 Qualifier can ONLY be sent to vendors participating in the AutoZone logistics or

Direct Import programs. It will be sent unless requested by the participating vendor.

N9-- Reference Identification

N901 128 Reference ID Qualifier ZZ' = Mutually defined field between AutoZone and trading partner.

N902 127 Reference ID 'AutoZone PO'

MSG -- Message Text

MSG01 933 Freeform message text Purchase order note as entered by the AutoZone buyer.

N9/MSG Note: The N9 and MSG segments are optional and will only occur when an actual message is present.

EDI Document 850 -- AutoZone Purchase Order (pg. 4 of 7)

Element Position

Data Element Number

Data Element Name Remarks

N1 -- Name Information

N101 98 Entity Code ST' = Ship to'

BT' = Bill to'

VN' = Vendor Number (See N1 note).

N102 93 Name Either ‘ship to’ or ‘bill to’ name depending on code in N101 (Not used if N101 = 'VN').

N103 66 ID Code Qualifier 93' = Code assigned by AutoZone (only if N101 is 'VN').

'ZZ' = Mutually defined (Only if N101 is 'ST').

N104 67 ID Code If N103 = '93', this is the AutoZone internal vendor number (this value will be returned on the 856 advance ship notice).

If N103 = 'ZZ', this is the AutoZone warehouse location code or the VDP indicator. A warehouse code is two digits such as 11, 22, 33, etc. The VDP indicator is the two character string 'DS'.

N1 Note: AutoZone will send three occurrences of the N1 loop in a Purchase Order. The N1 loop qualified by an `ST' in N101 will contain the N3 and N4 segments in addition to the N1. The N1 loop qualified by `BT' in N101 will also contain N3 and N4 segments. The N1 loop qualified by `VN' in N101 will only contain the N1 segment.

N3 -- Address Information

N301 166 Address ‘Ship to’ or ‘bill to’ address depending on code in N101.

N3 Note: The ‘Ship To’ and the ‘Bill To’ loops will contain the appropriate address in N301. The ‘Vendor Number’ will not contain an N3 segment.

EDI Document 850 -- N1 Loop Examples

N1 *ST* AUTOZONE STORE# *ZZ* DS N3 *1700 DUNN AVE.

N4 *MEMPHIS*TN*38106

N1 *BT* AUTOZONE, INC.

N3 *PO BOX 2198

N4 *MEMPHIS*TN*381019842 Ship to address loop

Bill to address loop

Vendor number loop

N1 *VN**93*12345

EDI Document 850 -- AutoZone Purchase Order (pg. 5 of 7)

Element Position

Data Element Number

Data Element Name Remarks

N4 -- Geographic Information

N401 19 City Name ‘Ship to’ or ‘bill to’ city depending on code in N101.

N402 156 State Code ‘Ship to’ or ‘bill to’ state depending on code in N101.

N403 116 Postal (Zip) Code ‘Ship to’ or ‘bill to’ zip code depending on code in N101.

N1 Note: The ‘Ship To’ and the ‘Bill To’ loops will contain the appropriate city, state, and zip in the N4 segment. The ‘Vendor Number’ loop will not contain an N4 segment.

REF -- Reference Numbers

REF01 128 Reference Number

Qualifier

A code of 'ST' designating store number.

REF02 127 Reference Number The 4-digit AutoZone store number.

Note: This segment will only be sent to vendors participating in the AutoZone DSD or VDP program.

EDI Document 850 -- AutoZone Purchase Order (pg. 6 of 7)

Element Position

Data Element Number

Data Element Name Remarks

PO1 -- Purchase Order Item Information PO101 350 Assigned Identification

(Occurrence Number)

A unique number for each occurrence of a PO segment. For example, the first PO segment would contain a '1', the second would contain a '2', etc.

PO102 330 Quantity Ordered The number ordered of this item.

PO103 355 Unit of Measure Code Any X12 standard unit of measure value.

PO106 235 Product/Service ID Qualifier

'VP' = Vendor part number.

PO107 234 Product/Service ID Your part number.

PO108 235 Product/Service ID Qualifier

'SK' = SKU number.

PO109 234 Product/Service ID AutoZone's item number.

PID-- Product/Item Description

PID01 349 Item Description Type 'F' = Freeform item description.

PID05 352 Item Description AutoZone's item description.

PO4 -- Item Physical Details

PO401 356 Pack Number of inner pack units per outer pack unit.

TD5 – Carrier Details (Routing Sequence/Transit Time)

TD503 67 Identification Code This will always be FEDX.

TD505 387 Routing Shipping codes are F06, F11, R02, F01.

TD512 “SD” Saturday delivery if applicable.

Note: This information will only be sent to vendors participating in the AutoZone VDP program.

EDI Document 850 -- AutoZone Purchase Order (pg. 7 of 7)

Element Position

Data Element Number

Data Element Name Remarks

CTT -- Transaction Totals

CTT01 354 Number of Line Items The total of PO1 segments in this purchase order.

CTT02 347 Hash Total Total quantity ordered in this purchase order.

CTT03 81 Weight Total weight ordered in this purchase order.

CTT04 355 Unit of Measurement Code

'01' = Actual pounds.

SE -- Transaction Set Trailer

SE01 96 Number of Included

Segments

Total number of X12 segments in this transaction set (including the ST and SE segments).

SE02 329 Transaction Set Control Number

The same number that is in the ST02 element.

GE-- Functional Group Trailer

GE01 97 Number of Included Sets Total number of ST segments in this functional group.

GE02 28 Group Control Number The same number that is in the GS06 element.

IEA -- Interchange Control Trailer Segment IEA01 I16 Number of Included

Groups

A count of the number of functional groups included in this transmission (the number of GS segments).

IEA02 I12 Interchange Control Number

The same number that is in the ISA13 element.

Purchase Order -- VDP Order Example BEG*00*NE*91748316*00*19990107 DTM*074*19990108

N1*BT*AUTOZONE, INC.

N3*PO BOX 2198

N4*MEMPHIS*TN*381019842 N1*VN**93*00026

N1*ST*AUTOZONE #1343*ZZ*DS N3*2502 STATELINE

N4*TEXARKANA*AR*75502 REF*ST*1343

PO1*1*1*EA***VP*123-456*SK*987654 PID*F****ITEM 1 DESCRIPTION PO4*1

CTT*1*1*17*01

EDI Document 846 -- AutoZone Inventory Inquiry/Advice (pg. 1 of 4)

Element Position

Data Element Number

Data Element Name Remarks

ISA -- Interchange Control Header Segment ISA01 I01 Authorization Information

Qualifier

'00' = No meaningful data in ISA02.

ISA02 I02 Authorization Information May contain any 10 characters including 10 spaces or 10 zeros.

ISA03 I03 Security Information Qualifier

'00' = No meaningful data in ISA04.

ISA04 I04 Security Information May contain any 10 characters including 10 spaces or 10 zeros.

ISA05 I05 Interchange ID Qualifier (Sender)

May contain any valid ANSI code for this element.

ISA06 I06 Interchange Sender ID Your ID depending on the code in ISA05.

ISA07 I05 Interchange ID Qualifier (Receiver)

May contain any valid ANSI code for this element.

ISA08 I07 Interchange Receiver ID AutoZone's ID depending on the code in ISA07.

ISA09 I08 Interchange Date The date the envelope was created in YYMMDD format.

ISA10 I09 Interchange Time The time the envelope was created in HHMM format.

ISA11 I10 Interchange Control Standards ID

'U' = U.S. EDI community.

ISA12 I11 Interchange Control Version Number

'00400' ISA13 I12 Interchange Control

Number

The number AutoZone has assigned to the transaction which uniquely identifies this transmission.

ISA14 I13 Acknowledgement

Requested

0' = No Acknowledgement Requested '1' = Acknowledgement Requested (Not the 997 transaction set).

ISA15 I14 Test Indicator T' = Test Data.

'P' = Production Data.

ISA16 I15 Sub-Element '>' Greater Than Relational Operator.

EDI Document 846 -- AutoZone Inventory Inquiry/Advice (pg. 2 of 4)

Element Position

Data Element Number

Data Element Name Remarks

GS -- Functional Group Header

GS01 479 Functional ID Code 'IB' = Inventory Inquiry.

GS02 142 Application Sender Code The sender's identification (same as found in ISA06).

GS03 124 Application Receiver code AutoZone's DUNS number (same as found in ISA08).

GS04 373 Group Date Date a functional group of transaction sets was generated in CCYYMMDD format.

GS05 337 Group Time Time a functional group of transaction sets was generated in HHMM format.

GS06 28 Group Control Number Number AutoZone assigned to this functional group;

this same number will be in GE02 and in the 997 functional acknowledgement for this functional group.

GS07 455 Responsible Agency Code 'X' = ANSI X12.

GS08 480 Version/Release Industry ID Code

004010' to represent the ANSI X12 version we are sending.

ST -- Transaction Set Header

ST01 143 Transaction Set ID Code '846' = Inventory Inquiry/Advice.

ST02 329 Transaction Set Control Number

A unique number AutoZone assigns to this transaction set; also appears in SE02.

EDI Document 846 -- AutoZone Inventory Inquiry/Advice (pg. 3 of 4)

Element Position

Data Element Number

Data Element Name Remarks

BIA -- Beginning Segment for Inventory Inquiry/Advice

BIA01 353 Purpose Code Send a value of '08', meaning this document contains inventory information.

BIA02 755 Report Type Code Send a value of 'DD', meaning this document is a distributor inventory report.

BIA03 127 Reference Number This number is the transaction set reference number as assigned by the sender. This number can be used to reference a particular document between the send and AutoZone.

BIA04 373 Date Date a functional group of transaction sets was

generated in CCYYMMDD format.

LIN -- Item Identification

LIN02 235 Product Identity Qualifier Send a value of 'IN', meaning the product identifier in the next element contains the buyer's item number.

LIN03 234 Product Identifier AutoZone's item number for this product. NOTE:

This number must be a six-digit numeric. Leading zeros are required.

QTY -- Quantity

QTY01 673 Quantity Qualifier 33' = The quantity in QTY02 is the quantity available for sale.

'37' = The quantity in QTY02 is the quantity available for remanufacture.

QTY02 380 Quantity If QTY01 = '33', this is the actual quantity of a particular item available for sale.

If QTY01 = '37', this is the actual quantity of a particular item available for remanufacture. This value must be specified relative to the unit of measure as required by AutoZone.

QTY03 355 Unit of Measure Unit of measure for the quantity found in QTY02.

The unit of measure included must be the code specified by AutoZone.

QTY Note: AutoZone will determine which code will be used for a QTY loop.

EDI Document 846 -- AutoZone Inventory Inquiry/Advice (pg. 4 of 4)

Element Position

Data Element Number

Data Element Name Remarks

CTT -- Transaction Totals

CTT01 354 Number of Line Items The total of LIN segments in this purchase order.

CTT02 347 Hash Total Total quantity available (sum of all QTY02 elements).

SE -- Transaction Set Trailer

SE01 96 Number of Included

Segments

Total number of X12 segments in this transaction set (including the ST and SE segments).

SE02 329 Transaction Set Control Number

The same number that is in the ST02 element.

GE-- Functional Group Trailer

GE01 97 Number of Included Sets Total number of ST segments in this functional group.

GE02 28 Group Control Number The same number that is in the GS06 element.

IEA -- Interchange Control Trailer Segment IEA01 I16 Number of Included

Groups

A count of the number of functional groups included in this transmission (the number of GS segments).

IEA02 I12 Interchange Control Number

The same number that is in the ISA13 element.

EDI Document 856 -- AutoZone Advance Shipping Notices (pg. 1 of 10)

Element Position

Data Element Number

Data Element Name Remarks

ISA -- Interchange Control Header Segment ISA01 I01 Authorization Information

Qualifier

AutoZone will use code '00', meaning no authorization information present.

ISA02 I02 Authorization Information Will contain 10 spaces if ISA01 contains code of 00.

ISA03 I03 Security Information Qualifier

AutoZone will use code '00' -- no security information present.

ISA04 I04 Security Information Will contain 10 spaces if ISA03 contains code of 00.

ISA05 I05 Interchange Sender ID Qualifier

May contain any valid ANSI code for this element.

ISA06 I06 Interchange Sender Identification

Contains the identification of the sender.

ISA07 I05 Interchange Receiver ID Qualifier

May contain any valid ANSI code for this element.

ISA08 I07 Interchange Receiver ID AutoZone's ID depending on the code in ISA07.

ISA09 I08 Interchange Date Date the envelope was created, in YYMMDD format.

ISA10 I09 Interchange Time Time the envelope was created, in HHMM format.

ISA11 I10 Interchange Standards ID Code of 'U', meaning US EDI community.

ISA12 I11 Interchange Control Version Contains '00400'

ISA13 I12 Interchange Control Number A number assigned by the sender to uniquely identify the transmission.

ISA14 I13 Acknowledgement Request Code of '0', meaning no envelope acknowledgement requested.

ISA15 I14 Test Indicator Code of 'T' for Test data.

Code of 'P' for Production data.

ISA16 I15 Sub-element Separator Character used to separate sub-elements. AutoZone will use a '>' sign.

EDI Document 856 -- AutoZone Advance Shipping Notices (pg. 2 of 10)

Element Position

Data Element Number

Data Element Name Remarks

GS -- Functional Group Header

GS01 479 Functional ID Code Code of 'SH' to indicate ship notice.

GS02 142 Application Sender's Code The sender's identification (same as found in ISA06).

GS03 124 Application Receiver's Code AutoZone's DUNS number (same as found in ISA08).

GS04 373 Group Date Date the functional group was created, in CCYYMMDD format.

GS05 337 Group Time Time the functional group was created, in HHMM format.

GS06 28 Group Control Number Assigned number created by the sender. This same number must be used in GE02.

GS07 455 Responsible Agency Code Code of 'X' to indicate ASC X12.

GS08 480 Version/Release/Industry ID Code

004010' to represent the ANSI X12 version you are sending.

EDI Document 856 -- AutoZone Advance Shipping Notices (pg. 3 of 10)

Element Position

Data Element Number

Data Element Name Remarks

ST -- Transaction Set Header

ST01 143 Transaction Set ID Code Code uniquely identifying a transaction set. '856' for shipping notices.

ST02 329 Transaction Set Control Number

Number assigned by the sender to uniquely identify the transaction set.

BSN -- Beginning Segment for Ship Notice BSN01 353 Transaction Set Purpose

Code

Code of '00' to indicate original document.

BSN02 396 Shipment Identifier A number or code to identify the ASN document to the sender. May use bill of lading number or pro bill if no other shipment ID exists.

BSN03 373 Date Create date of the ASN, in CCYYMMDD format.

BSN04 337 Time Create time of the ASN in HHMM format.

DTM -- Date/Time Reference (two DTM segments are needed)

DTM01 374 Date/Time Qualifier Code of '011', meaning the date the shipment was initiated and a code of '017’, meaning the expected arrival date at AutoZone.

DTM02 373 Date If DTM01 is '011' -- actual ship date;

If DTM01 is '017' -- expected arrival date;

in CCYYMMDD format.

DTM03 337 Time If DTM01 is '011' -- actual ship time.

If DTM01 is '017' -- element is not used.

DTM Note: There are two DTM segments required for this mapping. The first occurrence should contain a code of '011’ in element 374. The second occurrence should contain a code of `017'. The segment with the `017' qualifier does not need to contain a time in element 337. The time will be ignored if sent on the `017' DTM.

EDI Document 856 -- AutoZone Advance Shipping Notices (pg. 4 of 10)

Element Position

Data Element Number

Data Element Name Remarks

HL -- Hierarchical Level Segment (Shipment Level)

HL01 628 Hierarchical ID Number A unique number for each occurrence of an HL segment. For example, the first HL segment would contain a '1', the second would contain a '2', etc.

HL03 735 Hierarchical Level Code A code of "S' to indicate that shipment information is contained within this particular HL segment loop.

HL04 736 Hierarchical Child Code A code of '1', indicating that there are more HL levels subordinate to this one.

H Notes: 1. This is the first of four levels of HL segments in the AutoZone Advance

MEA01 737 Measurement Reference ID Code

Use a code of 'PD', meaning physical dimensions.

MEA03 739 Measurement Value The value contained in this element represents the measurement of the shipment, whether it is in weight, cases, pallets, cubic feet, etc.

MEA04 355 Unit of Measure Code The unit of measure code for the value found in MEA03.

TD5 -- Carrier Details (Routing Sequence/Transit Time)

TD504 91 Transportation Method Type Code

A code representing how the shipment will be transported -- i.e., 'M' = Motor (common carrier).

TD505 387 Routing The originating carrier's identity.

EDI Document 856 -- AutoZone Advance Shipping Notices (pg. 5 of 10)

Element Position

Data Element Number

Data Element Name Remarks

TD3 -- Carrier Details (Equipment) TD301 40 Equipment Description

Code

A code representing the type of equipment used for the shipment -- i.e., 'TL' = Trailer

TD303 207 Equipment Number Identification number of the shipping equipment -- i.e., the trailer number.

REF -- Reference Numbers (two occurrences needed)

REF01 128 Reference Number Qualifier BM' code (bill of lading) is the first occurrence.

'CN' code is the second occurrence.

REF02 127 Reference Number If REF01 is 'BM' = bill of lading number.

If REF01 is 'CN' = pro bill number.

REF note: This segment can be ignored if the REF segment following the PRF segment will be sent.

N1 -- Name

N101 98 Entity ID Code Code of 'VN', meaning vendor information.

N103 66 ID Code Qualifier Code of '92', meaning N104 information was assigned by AutoZone.

N104 67 ID Code AutoZone's internal vendor number for supplier. This number is contained in the N1 segment in the purchase order.

EDI Document 856 -- AutoZone Advance Shipping Notices (pg. 6 of 10)

Element Position

Data Element Number

Data Element Name Remarks

HL -- Hierarchical Level Segment (Tare Level) HL01 628 Hierarchical ID Number

(Occurrence Number)

A unique number for each occurrence of an HL segment. For example, the first HL segment would contain a '1', the second would contain a '2', etc.

HL02 734 Hierarchical Parent ID Identifies the HL level (by ID number) to which this HL level is subordinate.

HL03 735 Hierarchical Level Code A code of 'T' to indicate that tare information is contained within this particular HL segment loop.

IF APPLICABLE.

HL04 736 Hierarchical Child Code A code of '1', indicating that there are more HL levels subordinate to this one.

Hl Notes: 1. This is the second of four levels of HL segments in the AutoZone Advance

MAN -- Marks and Numbers Segment

MAN01 88 Marks and Numbers

Qualifier

Code specifying the application or source of marks and numbers. AutoZone will use a code of 'UC' to indicate a UCC-128 barcode.

MAN02 87 Marks and Numbers Marks and numbers used to identify a shipment or

MAN02 87 Marks and Numbers Marks and numbers used to identify a shipment or

In document VDP Program Vendor Guidelines (Page 13-47)

Related documents