EDI GUIDELINES - Iconnect-corp

2y ago
16 Views
3 Downloads
353.28 KB
32 Pages
Last View : 2m ago
Last Download : 2m ago
Upload by : Braxton Mach
Transcription

EDIGUIDELINESMERCHANDISE INVOICE8104010 VERSIONAugust 20, 1999TSC 810 4010 MERCHANDISE INVOICE DOCUMENT - PROPRIETARY AND CONFIDENTIAL - 9/20/2011Page 1

EDI GUIDELINESMERCHANDISE INVOICE 810VERSION 4010TABLE OF CONTENTSSECTION ONEINTRODUCTION . 3GENERAL GUIDELINES . . 4CONTACTS . 8TSC TRADING PARTNER EDI PROFILE . 9SECTION TWO810 MERCHANDISE INVOICE GUIDELINES . 10SECTION THREECHARGE AND ALLOWANCE LIST . 30TSC 810 EDI DATA EXAMPLE . 31TSC 810 4010 MERCHANDISE INVOICE DOCUMENT - PROPRIETARY AND CONFIDENTIAL - 9/20/2011Page 2

INTRODUCTIONThis document is to provide our Tractor Supply Company (TSC) Trading Partners with the business andtechnical information needed to upgrade or implement the 810 Invoice document. For a successful EDIimplementation, it is critical that you review these mapping guidelines and understand the EDIprocesses and procedures for Tractor Supply Company. Charts summarizing EDI envelopingsegments and the segment hierarchy are provided for the technical reader. This document, prepared byTSC, contains descriptions of only those segments and data elements used by TSC.TSC uses the VICS (retail/manufacturer) subset of the ANSI X12 standards as our guideline for EDImapping; however, we formally trade documents using the ANSI X12 standards. We do observe all VICSnotes. If you need a standards manual, contact GS1 US (formerly Uniform Code Council) at:GS1 USPrinceton Pike Corporation Center1009 Lenox Drive Suite 202Lawrenceville, New Jersey 08648609-620-0200Web site: http://www.gs1us.orgEmail: info@gs1us.orgTo obtain the CAD04 code list for all Carriers, contact:National Motor Freight Traffic Association1001 North Fairfax Street, Suite 600Alexandria VA 22314866-411-6632Web site: http://www.nmfta.orgEmail: customerservice@nmfta.orgPlease review these guidelines and contact Tractor Supply Company’s EDI department with any questions.TSC 810 4010 MERCHANDISE INVOICE DOCUMENT - PROPRIETARY AND CONFIDENTIAL - 9/20/2011Page 3

GENERAL GUIDELINESTransmission/Pickup TSC’s Value Added Network (VAN) is Sterling Commerce. If you choose to use a VAN other thanSterling, you may interconnect to Sterling. Please note that you are responsible for selecting an EDIsolution provider/VAN that has effective tools for managing and tracking your EDI data. You are alsoresponsible for data retention with your VAN. We recommend a minimum of 14 days of data retentionat your VAN in case of communications issues. TSC retrieves merchandise invoices (810’s) from Sterling Commerce at 11:30 a.m. (CT) Mondaythrough Friday and at 6:00 p.m. (CT) Sunday through Thursday. TSC returns Functional Acknowledgments (997’s) for all merchandise invoices (810’s). This allowsyou to verify internally which transmissions TSC has received. If you have not received an expected997, call TSC’s EDI Department. Please check first for a 997 before calling the TSC EDI departmentto verify receipt of invoices.Transmission Verification Every transmission you receive from TSC is numbered in sequence. If you show a gap in theinterchange (ISA) control numbers, contact the TSC EDI Analyst at (615) 440-4639. If you receivemultiple types of EDI documents from TSC, you should also check your group (GS) control numbers.GS control numbers are incremented individually by document, whereas ISA control numbersincrement globally for all documents. If the control numbers are out of sequence, you are most likelymissing an envelope of data. If you question the validity of your translated data, please compare your translated data to your rawdata (before translation). This process should identify from where the problem is originating, yourtranslation or TSC’s system.TSC 810 4010 MERCHANDISE INVOICE DOCUMENT - PROPRIETARY AND CONFIDENTIAL - 9/20/2011Page 4

Retransmission If you need data retransmitted, call your VAN and have them restore the data you need. Once the datahas been restored, you should pick up the data from the VAN. Based on your agreement with yourVAN, there may be a limited restoration window. You should check with your chosen VAN for theirindividual archiving procedures. Also, there may be a fee for restoration of data. It is yourresponsibility to choose appropriate archiving procedures based on your EDI processing schedule. If you are missing an interchange (ISA), call your VAN and provide the following information. Theyshould be able to find the data and restore it for you: Your qualifierYour sender/receiver IDTSC’s qualifier-----08TSC’s sender/receiver ID-----6120930000The interchange (ISA) control number you are missingInvoice Format TSC expects the basic invoice format. One invoice, detailing the items shipped and billed, should besent for each purchase order you receive. TSC does not accept credit or debit memos via EDI.Item Identification TSC requires the following product identifiers for invoices for regular PO’s: TSC Item Number (TSC SKU Number)Your Item Number (Vendor Part Number)Item UPC CodeTSC can provide a product cross-reference list containing the above information. To request this list,contact TSC’s EDI department at edi@TractorSupply.com. To request a change or an update to a vendorpart number or a UPC code, contact your TSC buyer. If you are transmitting an invoice for a TSC specialorder (phoned from the store), we request that you identify your items using vendor part numbers and UPCcodes.New Stores TSC is constantly adding new store locations. TSC will transmit a SAC header segment with a code of“OHNS” in the SAC04 on orders sent prior to the store opening date. Our trading partners areresponsible for having a process in place to identify new store orders using this flag. Also, the N3 andN4 segments will be transmitted on these orders giving you the address on the initial order. After thestore has opened, the address is no longer transmitted on the PO. If you need a new store address,contact TSC’s new store hot line @ (615)-440-4770 or contact your TSC buyer .TSC 810 4010 MERCHANDISE INVOICE DOCUMENT - PROPRIETARY AND CONFIDENTIAL - 9/20/2011Page 5

810 Testing Procedures Review the attached guidelines and call TSC’s EDI Analyst to schedule testing. Vendors beginningwith letters A-K, please call 615-440-4639. Vendors beginning with L-Z, please call 615-440-4808. While testing EDI invoicing, you must still send your paper merchandise invoices for payment to:Tractor Supply CompanyP O Box 7000Brentwood, TN 37024Test EDI invoices will not be forwarded for payment! Generate test data that complies with TSC’s 810 guidelines. Be sure to thoroughly test your datainternally. Your data should comply with ANSI X12 standards before it is sent to TSC for testing.Please do not send untested 810 transactions to TSC. When test 810 invoices are sent, the ISA15 (test indicator) should be a “T” for test. There are two phases for invoice testing with Tractor Supply:Phase I is syntax testing. A Tractor Supply EDI analyst will review your test invoices for syntaxcompliance. The analyst will verify that all mandatory data elements are populated according toVICS EDI standards and TSC mapping guidelines. The closer your syntax mirrors the businessexample on page 31, the sooner your test data will pass this phase of testing. If you havecompliance issues, you will be notified via email. This is an iterative process until your invoicesare syntactically compliant.Phase II is content testing. After completion of Phase I, your test EDI invoices will be forwardedto our application test system (SAP). Accounts Payable will review them for content against theoriginating purchase orders. AP will validate that the PO numbers are valid, terms match the PO’s,all product identification numbers match our system, the invoice totals are correct, etc. AP willprovide feedback to the EDI analyst and the analyst will communicate back to you. This, too, is aniterative process. AP may require 2 – 3 independent batches without content errors before givingthe approval for production. In addition to regular invoices, you may be requested to test special order invoices during the invoicetesting process. Special orders are phoned or faxed in from our stores and are not received via EDI.However we do expect to receive invoices for the special orders via EDI. Special order PO numbersare 7 digits in length and begin with an “8”. A sample special order invoice may be found on page 32of these guidelines. As part of invoice testing, we will go through the process of data alignment with your company. Wewill send you a file of everything we currently sell for your company that is assigned a Tractor Supplyarticle number and ask that you review the file for any changes needed for the vendor part number (youritem number) and/or the UPC number.TSC 810 4010 MERCHANDISE INVOICE DOCUMENT - PROPRIETARY AND CONFIDENTIAL - 9/20/2011Page 6

810 Implementation Procedures Once both TSC and you agree to move the invoices to a production status, you will receive aconfirmation letter from the EDI analyst. Hard copy merchandise invoices will no longer be needed. Production EDI invoices must be transmitted with a “P” in the ISA15. TSC’s EDI merchandise invoice process is monitored on a daily basis. If an invoice is rejected becauseit does not pass X12 Standards compliance checking, a TSC EDI analyst will contact you with thecontrol number(s) and error detail. If an invoice has content errors, the TSC AP Department willcontact you. You will need to resend the corrected invoice data so that your invoice(s) will be paid. X12 standards require you to monitor 997’s (Functional Acknowledgments) to ensure that yourinvoices have been received by TSC’s EDI system. 997’s will be sent for all transmissions received.TSC 810 4010 MERCHANDISE INVOICE DOCUMENT - PROPRIETARY AND CONFIDENTIAL - 9/20/2011Page 7

EDI CONTACTS AND SUMMARYGENERAL INFORMATIONEDI DepartmentTractor Supply Company200 Powell PlaceBrentwood, TN 37027PhoneFaxEmail(615) 440-4639 or (615) 440-4808(615) 484-4639 or (615) 484-4808edi@TractorSupply.comStandard:VAN:TSC’s Interchange ID Qualifier:TSC’s Sender ID:ANSI X12 (VICS subset)Sterling Commerce086120930000Terminator and Separators as Defined by VICS EDI GuidelinesSegment Terminator:NEW LINE –HEX “15” in EBCDICorCR HEX “0D” in EBCDIC and ASCIIWhichever character is used for the segment terminator must be used throughout the transmission.Element Separator:BELL HEX “2F” in EBCDIC (HEX “07” in ASCII)or“*”HEX “5C” in EBCDIC (HEX “2A” in ASCII)The element separator that is to be used in the transmission is defined by the first occurrence of the elementseparator in the ISA segment.Component Separator:“ ”HEX “6E” in EBCDIC (HEX “3E” in ASCII)CAUTION: Any time a printable character is used to indicate the separation of data elements or segments, thatcontrol character cannot be used as data within the transmission. Some systems/network protocols may translatecontrol characters when going from EBCDIC to ASCII and back.ISSUESINVOICE INQUIRY: Invoice payment date, amount or contentTRANSMISSION PROBLEM: Did not receive an expected transmission/997 Have a gap in interchange control numbersNEW STORE OR DC ADDRESSES:PURCHASE ORDER CONTENT: Pricing, ship/cancel dates, case pack, SKU’s, storelocation, quantities, ship to/ship from, FOB, terms,vendor part numbers, UPC code, etc.SHIPPING OR ROUTING:LABEL REQUIREMENTS:CONTACT TSC’s Accounts Payable Vendor Correspondence Your Network/VANTSC’s EDI Department (615) 440-4639 or 4808 New Store hot line (615) 440-4770Your TSC buyer or inventory management contactYour TSC buyer or inventory management contactYour Sales or Customer Service Representative Vendor Requirements Manual atwww.tractorsupply.com/vrm. Domestictransportation instructions are located on page 40.Vendor Requirements Manual atwww.tractorsupply.com/vrm TSC 810 4010 MERCHANDISE INVOICE DOCUMENT - PROPRIETARY AND CONFIDENTIAL - 9/20/2011Page 8

TRADING PARTNER EDI PROFILEPlease complete and send to appropriate contactDate: New Trading PartnerChange to existing partnershipVendor Company Name:Address:City: State: Zip:TSC Buyer: Primary EDI Contact (Should be an associate of the vendor company)Name:Title:Phone: Fax:Email: Secondary EDI ContactName:Title:Phone: Fax:Email: Your Communication/Network ID:Interchange ID Qualifier (01, 12, or 08): Interchange ID:Network/Van:EDI Platform (circle one):Mainframe / Midrange / PCEDI Software/Translator or EDI Third Party Provider: Tractor Supply EDI Information:Contacts:TEST: Marilyn Bryant (mbryant@tractorsupply.com) 615-440-4639/fax 615-484-4639PRODUCTION: Jason Flanary (jflanary@tractorsupply.com) 615-440-4808/fax 615-484-4808General e-mail:edi@tractorsupply.comInterchange ID Qualifier:08Interchange ID:6120930000Network/VAN:Sterling Collaboration NetworkANSI X.12 Version:004010Documents:850 Purchase Order (w/997 Functional Acknowledgment) **Required810 Merchandise Invoice (w/997 Functional Acknowledgment) **Required855 Purchase Order Acknowledgment (w/997 Functional Acknowledgment) **Used by TSCselected vendors onlyTSC 810 4010 MERCHANDISE INVOICE DOCUMENT - PROPRIETARY AND CONFIDENTIAL - 9/20/2011Page 9

ANSI X 12MERCHANDISE INVOICE810VERSION 4010TSC 810 4010 MERCHANDISE INVOICE DOCUMENT - PROPRIETARY AND CONFIDENTIAL - 9/20/2011Page 10

810MERCHANDISE INVOICE SEGMENT HIERARCHYENVELOPEISAINTERCHANGE HEADERGROUPGSGROUP HEADERTRANSACTIONSTTRANSACTION SET HEADERBIGBEGINNING SEGMENT FOR INVOICEN1NAMEITDTERMS OF SALEDTMDATE REFERENCEFOBF.O.B. RELATED INSTRUCTIONSDETAILIT1BASELINE ITEM DATAPIDPRODUCT/ITEM DESCRIPTIONSACSERVICE, PROMOTION, ALLOWANCE, OR CHARGE INFORMATIONSUMMARYSEGEIEATDSTOTAL MONETARY VALUE SUMMARYCADCARRIER DETAILSACSERVICE, PROMOTION, ALLOWANCE, OR CHARGE INFORMATIONCTTTRANSACTION TOTALSTRANSACTION SET TRAILERGROUP TRAILERINTERCHANGE TRAILERTSC 810 4010 MERCHANDISE INVOICE DOCUMENT - PROPRIETARY AND CONFIDENTIAL - 9/20/2011Page 11

ISA - INTERCHANGE CONTROL HEADERPurpose: To start and identify an interchange of one or more functional groups and interchange related controls.REF. DES.DATA ELEMENT # AND NAMEATTRIBUTESVALUE & COMMENTSISA01I01AUTHORIZATIONINFORMATION QUALIFIERM ID 2/2“00” (No Authorization Information)ISA02I02AUTHORIZATIONINFORMATIONM AN 10/10Ten blanksISA03I03SECURITY INFO QUALIFIERM ID 2/2“00” (No Security Information)ISA04I04SECURITY INFORMATIONM AN 10/10Ten blanksISA05I05SENDER ID QUALIFIERM ID 2/2TSC will accept:01 DUNS Number (9-digit)12 Phone Number (10-digit)08 VICS UCC Comm ID (10-digit)14 DUNS Suffix (9-digit plus suffix)ISA06I07INTERCHANGE SENDER IDM AN 15/15This value will match the qualifier in ISA05.ISA07I05RECEIVER ID QUALIFIERM ID 2/2“08”ISA08I06INTERCHANGE RECEIVER IDM AN 15/156120930000ISA09I08DATEM DT 6/6YYMMDDISA10I09TIMEM TM 4/4HHMMISA11I10INTERCHANGE CONTROLSTANDARDS IDENTIFIERM ID 1/1“U”ISA12I11INTERCHANGE CONTROLVERSION NUMBERM ID 5/5“00401”ISA13I12INTERCHANGE CONTROLNUMBERM N0 9/9The interchange control number will beassigned sequentially by the vendor.This enables TSC to recognize a missingTransmission or a duplicate transmission.ISA14I13ACKNOWLEDGMENTREQUESTEDM ID 1/1“0” No Interchange AcknowledgmentRequestedISA15I14USAGE INDICATORM ID 1/1“P” Production“T” TestISA16I15COMPONENT ELEMENTSEPARATORMHEX “6E” ( )1/1TSC 810 4010 MERCHANDISE INVOICE DOCUMENT - PROPRIETARY AND CONFIDENTIAL - 9/20/2011Page 12

GS - FUNCTIONAL GROUP HEADERPurpose: To indicate the beginning of a functional group and to provide control information.REF. DES.DATA ELEMENT # AND NAMEATTRIBUTESGS01479FUNCTIONAL IDENTIFIERCODEM ID 2/2“IN”GS02142APPLICATION SENDER’SCODEM AN 2/15This will be the same as thesender ID in ISA06. If any othervalue is to be sent here, it must beagreed upon between the TSC EDIAnalyst and the vendor prior tousage.GS03124APPLICATION RECEIVER’SCODEM AN 2/15“6120930000”GS0429DATEM DT 8/8CCYYMMDDGS0530TIMEM TM 4/8HHMMSSDDGS0628GROUP CONTROL NUMBERM N0 1/9This is assigned sequentially withineach group for each receiver. Itenables the receiver to recognize amissing functional group or aduplicate group.GS07455RESPONSIBLE AGENCY CODE M ID 1/2“X”GS08480VERSION/RELEASE“004010” - The version number isthe ANSI Version (first three digits)with the X12 release number (lastthree).M1/12VALUE & COMMENTSTSC 810 4010 MERCHANDISE INVOICE DOCUMENT - PROPRIETARY AND CONFIDENTIAL - 9/20/2011Page 13

ST - TRANSACTION SET HEADERPurpose: To indicate the start of a transaction set and to assign a control number.REF. DES.DATA ELEMENT # AND NAMEATTRIBUTESST01143TRANSACTION SET ID CODEST02329TRANSACTION SET CONTROL M AN 4/9NUMBERM ID 3/3VALUE & COMMENTS“810” InvoiceThe Transaction Set ControlNumber is sequentially assigned toeach transaction set for eachreceiver.TSC 810 4010 MERCHANDISE INVOICE DOCUMENT - PROPRIETARY AND CONFIDENTIAL - 9/20/2011Page 14

BIG - BEGINNING SEGMENT FOR INVOICEPurpose: To indicate the beginning of an invoice transaction set and to transmit identifying numbers and date.Usage:MandatoryREF. DES.DATA ELEMENT # AND NAMEATTRIBUTES (X12) VALUE & COMMENTSTSC REQUIREMENTSBIG01373INVOICE DATEM DT 8/8Invoice issue date, CCYYMMDD*** The exact date thatappears on the hard copy invoiceBIG0276INVOICE NUMBERM AN 1/22The exact invoice number thatappears on the hard copy invoice.BIG04324PURCHASE ORDER NUMBER(O AN 1/22)M N0 10/10TSC’s 10-digit PO number*** This data is found on the 850PO in the BEG03 data element.*If for a special order, the POnumber will be 7 digits in length andwill begin with an “8”.TSC 810 4010 MERCHANDISE INVOICE DOCUMENT - PROPRIETARY AND CONFIDENTIAL - 9/20/2011Page 15

N1 - NAMEPurpose: To identify a party by type of organization, name and code.TSC’S REQUIREMENT:MandatoryREF. DES.DATA ELEMENT # AND NAMEATTRIBUTES (X12) VALUE & COMMENTSTSC REQUIREMENTSN10198ENTITY IDENTIFIER CODEM ID 2/3“BY” Buying PartyN10366ID CODE QUALIFIER(C ID 1/2)M ID 2/2“92” Assigned by buyerN10467ID CODE(C AN 2/80)M NO 4/44 digit TSC store/DC code. If thestore/DC number is 3 digits inlength, a leading “0” should beused. Contact TSC inventorymanagement if you need an updatedstore listing.TSC 810 4010 MERCHANDISE INVOICE DOCUMENT - PROPRIETARY AND CONFIDENTIAL - 9/20/2011Page 16

ITD - TERMS OF SALEPurpose: To specify terms of sale.TSC’S REQUIREMENT: MandatoryREF. DES.DATA ELEMENT # AND NAMEATTRIBUTES (X12) VALUE & COMMENTSTSC REQUIREMENTSITD01336TERMS TYPE CODE(O ID 2/2)M ID 2/2“05” Discount Not Applicable“08” Basic Discount OfferedITD03338TERMS DISCOUNT PERCENTO R 1/6Terms discount percentage,expressed as a percent, availableto TSC if the invoice is paid onor before the Terms DiscountDue Date*** Terms Normal Terms New Store Terms if applicable*** Only use if ITD01 “08”ITD05351TERMS DISCOUNT DAYS DUE C N0 1/3Number of days in the termsdiscount period by which paymentis due if terms discount is earned*** Only use if ITD01 “08”ITD07386TERMS NET DAYSO N0 1/3M N0 1/3Number of days until invoiceamount is dueITD12352DESCRIPTIONO N0 1/80M AN 1/80A free-form description toclarify the related data elements andtheir contentTSC 810 4010 MERCHANDISE INVOICE DOCUMENT - PROPRIETARY AND CONFIDENTIAL - 9/20/2011Page 17

DTM - DATE/TIME REFERENCEPurpose: To specify pertinent dates and times.TSC’S REQUIREMENT: MandatoryREF. DES.DATA ELEMENT # AND NAMEATTRIBUTES (X12) VALUE & COMMENTSTSC REQUIREMENTSDTM01374DATE/TIME QUALIFIERM ID 3/3“011” Shipped dateDTM02373DATE(C DT 8/8)M DT 8/8Actual ship date CCYYMMDDTSC 810 4010 MERCHANDISE INVOICE DOCUMENT - PROPRIETARY AND CONFIDENTIAL - 9/20/2011Page 18

FOB - F. O. B. RELATED INSTRUCTIONSPurpose: To specify transportation instructions relating to shipment.TSC’S REQUIREMENT: MandatoryREF. DES.DATA ELEMENT # AND NAMEFOB01146SHIPMENT METHOD OFPAYMENTATTRIBUTES (X12) VALUE & COMMENTSTSC REQUIREMENTSM ID 2/2“CC” Collect“CF” Collect, freight creditedback to the customer“DF” Defined by buyer andseller“MX” Mixed“PC” Prepaid but charged tocustomer“PO” Prepaid only“PP” Prepaid by sellerNOTE: TSC will only accept a freight charge added to the invoice for code “PC”TSC 810 4010 MERCHANDISE INVOICE DOCUMENT - PROPRIETARY AND CONFIDENTIAL - 9/20/2011Page 19

IT1 - BASELINE ITEM DATA (INVOICE)Purpose: To specify the basic and most frequently used line item data for the invoice and related transactions.TSC’S REQUIREMENT: MandatoryREF. DES.DATA ELEMENT # AND NAMEATTRIBUTES (X12) VALUE & COMMENTSTSC REQUIREMENTS(O AN 1/20)Line item numberIT101350ASSIGNED IDIT102358QUANTITYC R 1/10M R 1/10Number of units invoicedIT103355UNIT OF MEASURE CODEC ID 2/2M ID 2/2*** The UOM must correspond tothe UOM on the TSC 850 POIT104212UNIT PRICEC R 1/17M R 1/17SKU cost price per unit of measure*** Maximum 2 decimal positionsIT106235PRODUCT ID QUALIFIERC ID 2/2M** ID 2/2“IN” Buyer’s Item Number (SKU)**If invoice is for a special order(TSC PO number beginning with“8”), there should not be a buyer’snumber; therefore, this informationmay be omitted from the invoice.IT107234PRODUCT IDC AN 1/48M** N0 7/7TSC’S 7 digit SKU number as itwas sent on the 850 PO documentIT108235PRODUCT ID QUALIFIERC ID 2/2M ID 2/2“VN” Vendor’s (Seller’sitem numberIT109234PRODUCT IDC AN 1/48M AN 1/48Vendor’s item/part numberIT1010235PRODUCT ID QUALIFIERC ID 2/2M ID 2/2“UP” UPC consumer packagecode (1-5-5-1)IT1011234PRODUCT ID(C AN 1/48)M N0 12/12UPC numberTSC 810 4010 MERCHANDISE INVOICE DOCUMENT - PROPRIETARY AND CONFIDENTIAL - 9/20/2011Page 20

PID - PRODUCT/ITEM DESCRIPTIONPurpose: To describe a product.TSC’S REQUIREMENT:Mandatory unless using a turn-around templateREF. DES.DATA ELEMENT # AND NAMEATTRIBUTES (X12) VALUE & COMMENTSTSC REQUIREMENTSPID01349ITEM DESCRIPTION TYPEM ID 1/1“F” Free- formPID05352DESCRIPTION(C AN 1/80)M AN 1/30A free-form description ofthe itemTSC 810 4010 MERCHANDISE INVOICE DOCUMENT - PROPRIETARY AND CONFIDENTIAL - 9/20/2011Page 21

SAC – SERVICE, PROMOTION, ALLOWANCE, OR CHARGE INFORMATIONPurpose: To request or identify a service, promotion, allowance, or charge; to specify the amount or percentage for the service,promotion, allowance or charge.TSC’S REQUIREMENT:OptionalREF. DES.DATA ELEMENT # AND NAMEATTRIBUTESTSC REQUIREMENTSVALUE & COMMENTSSAC01248ALLOWANCE OR CHARGEINDICATORM ID 1/1“A” Allowance“C” ChargeSAC021300SERVICE, PROMOTION,ALLOWANCE OR CHARGECODEC ID 4/4M ID 4/4SEE ATTACHED CODES LISTSAC05610AMOUNTO N2 1/15M N2 1/15SAC08118RATEO R 1/9SAC12331ALLOWANCE OR CHARGEMETHOD OF HANDLINGCODEO ID 2/2M ID 2/2“02” Off Invoice“06” Charge to be paid byCustomer***The SAC05 and SAC08 should always indicate positive values. SAC01 determines whether the amount is added toor deducted from the invoice. If SAC05 and SAC08 are sent, SAC05 will be used for the calculation.TSC 810 4010 MERCHANDISE INVOICE DOCUMENT - PROPRIETARY AND CONFIDENTIAL - 9/20/2011Page 22

TDS - TOTAL MONETARY VALUE SUMMARYPurpose: To specify the total invoice discounts and amounts.Usage: MandatoryREF. DES.DATA ELEMENT # AND NAMETDS01610ATTRIBUTES (X12) VALUE & COMMENTSTSC REQUIREMENTSTOTAL INVOICE AMOUNTM N2 1/15Amount of invoice (includingcharges, less allowances) beforeterms discount (if discount isapplicable).TSC 810 4010 MERCHANDISE INVOICE DOCUMENT - PROPRIETARY AND CONFIDENTIAL - 9/20/2011Page 23

CAD - CARRIER DETAILPurpose: To specify transportation details for the transaction.TSC’S REQUIREMENTS: MandatoryREF. DES.DATA ELEMENT # AND NAMEATTRIBUTES (X12) VALUE & COMMENTSTSC REQUIREMENTSCAD0191TRANSPORTATION METHOD(O ID 1/2)M ID L”“M”“P”“U”CAD04140STANDARD CARRIER ALPHACODEC ID 2/4M ID 2/4Carrier’s SCAC (StandardCarrier Alpha Code) -See NOTECAD05387ROUTINGC ID 1/35Free-form description – See NOTEAirAir ExpressConsolidationCustomer Pickup/Parcel PostCustomer PickupContract CarrierMotor (Common Carrier)Private CarrierPrivate Parcel ServiceNOTE: CAD04 is preferred, but if not available, CAD05 is mandatory.CAD06368SHIPMENT/ORDER STATUSCODEO ID 2/2M ID �“IS”“PR”“SS”Back Ordered FromPrevious OrderShipment Partial,Back Order To ShipShipment CompleteShipment Complete withAdditional QuantityPartial Shipment,Considered No BackorderShipment Complete withSubstitutionItem RepresentsSubstitution fromOriginal OrderPartial ShipmentSplit ShipmentCAD07128REFERENCE NUMBERQUALIFIER(O ID 2/3)M ID 2/2“BM”“CN”“08”CAD08127REFERENCE NUMBER(C AN 1/30)M AN 1/30Bill of lading, PRO #, or tracking #TSC 810 4010 MERCHANDISE INVOICE DOCUMENT - PROPRIETARY AND CONFIDENTIAL - 9/20/2011Bill of lading #PRO/Invoice #Carrier Assigned PackageID numberPage 24

SAC – SERVICE, PROMOTION, ALLOWANCE, OR CHARGE INFORMATIONPurpose: To request or identify a service, promotion, allowance, or charge; to specify the amount or percentage for the service,promotion, allowance or charge.TSC’S REQUIREMENT:OptionalREF. DES.DATA ELEMENT # AND NAMEATTRIBUTESTSC REQUIREMENTSVALUE & COMMENTSSAC01248ALLOWANCE OR CHARGEINDICATORM ID 1/1“A” Allowance“C” ChargeSAC021300SERVICE, PROMOTION,ALLOWANCE OR CHARGECODEC ID 4/4M ID 4/4SEE ATTACHED CODES LISTSAC05610AMOUNTO N2 1/15M N2 1/15SAC12331ALLOWANCE OR CHARGEMETHOD OF HANDLINGCODEO ID 2/2M ID 2/2“02” Off Invoice“06” Charge to be paid byCustomer***The SAC05 should always indicate positive values. SAC01 determines whether the amount is added to or deductedfrom the invoice.TSC 810 4010 MERCHANDISE INVOICE DOCUMENT - PROPRIETARY AND CONFIDENTIAL - 9/20/2011Page 25

CTT - TRANSACTION TOTALSPurpose: To transmit a hash total for a specific element in the transaction set.Usage: MandatoryREF. DES.DATA ELEMENT # AND NAMECTT01354NUMBER OF LINE ITEMSATTRIBUTES (X12) VALUE & COMMENTSM N0 1/6Total number of line items in thetransaction set (total number of IT1segments)TSC 810 4010 MERCHANDISE INVOICE DOCUMENT - PROPRIETARY AND CONFIDENTIAL - 9/20/2011Page 26

SE - TRANSACTION SET TRAILERPurpose: To indicate the end of the transaction set and provide the count of the transmitted segments (including the beginning(ST) and ending (SE) segments).REF. DES.DATA ELEMENT # AND NAMEATTRIBUTES (X12) VALUE & COMMENTSSE0196NUMBER OF INCLUDEDSEGMENTSM N0 1/10SE02329TRANSACTION SETCONTROL NUMBERM AN 4/9Must match ST02 valueTSC 810 4010 MERCHANDISE INVOICE DOCUMENT - PROPRIETARY AND CONFIDENTIAL - 9/20/2011Page 27

GE - FUNCTIONAL GROUP TRAILERPurpose: To indicate the end of functional group and to provide control information.REF. DES.DATA ELEMENT # AND NAMEATTRIBUTES (X12) VALUE & COMMENTSGE0197NUMBER OF TRANSACTIONSETSM NO 1/6Count of number of transaction setsin this groupGE0228GROUP CONTROL NUMBERM N0 1/9Must match GS06 valueTSC 810 4010 MERCHANDISE INVOICE DOCUMENT - PROPRIETARY AND CONFIDENTIAL - 9/20/2011Page 28

IEA - INTERCHANGE CONTROL TRAILERPurpose: To define the end of an interchange of one or more functional groups and interchange-related control segments.REF. DES.DATA ELEMENT # AND NAMEATTRIBUTES (X12) VALUE & COMMENTSIEA01I16NUMBER OF INCLUDEDFUNCTIONAL GROUPSM N0 1/5Number of GS SegmentsIEA02I12INTERCHANGE CONTROLNUMBERM N0 9/9Must match ISA13 valueTSC 810 4010 MERCHANDISE INVOICE DOCUMENT - PROPRIETARY AND CONFIDENTIAL - 9/20/2011Page 29

TRACTOR SUPPLY COMPANYACCEPTABLE CODESSPECIAL CHARGES OR ALLOWANCES(SAC02 data G870G970H000H390I390AdjustmentsAdvertising AllowanceAllowance AdvanceContainer AllowanceContainer/Trailer AllowanceCooperative Advertising/Merchandising Allowance (Performance)Defective AllowanceDiscount - IncentiveDiscount - SpecialDiscountEarly Ship AllowanceEmergency ServiceFreightHandlingHazardous Cargo ChargeInsuranceLoadingNew Store AllowanceNew Store DiscountNew Warehouse DiscountNo Return Credit AllowancePallet Exchange ChargePalletPick/UpPromotional AllowancePromotional DiscountRebateRecoveryRedistribution AllowanceRestocking ChargeScrap AllowanceShipping and HandlingShrink Wrap ChargeSmall Order ChargeSpecial AllowanceStop-Off ChargeUnloadingTSC 810 4010 MERCHANDISE INVOICE DOCUMENT - PROPRIETARY AND CONFIDENTIAL - 9/20/2011Page 30

EXAMPLE - MERCHANDISE 701*1856*U*00401*000001457*0*P* 32N1*BY**92*0275ITD*08**2**10**30*****2% 10 NET VN*CD-1234*UP*041234567892PID*F****PREMIUM CAT FOOD 10 5555*VN*FT-3333*UP*041235678787PID*F****LARGE LINK 2SE*17*14570001GE*1*1457IEA*1*000001457TSC 810 4010 MERCHANDISE INVOICE DOCUMENT - PROPRIETARY AND CONFIDENTIAL - 9/20/2011Page 31

EXAMPLE - SPECIAL ORDER MERCHANDISE 701*1856*U*00401*000001458*0*P* 1*BY**92*0275ITD*08**2**10**30*****2% 10 NET 9*UP*012345678912PID*F****BLUE BRAND CAT FOOD 5 4580001GE*1*1458IEA*1*000001458TSC 810 4010 MERCHANDISE INVOICE DOCUMENT - PROPRIET

TSC does not accept credit or debit memos via EDI. Item Identification for invoices for regular PO’sTSC requires the following product identifiers : TSC Item Number (TSC SKU Number) Your Item Number (Vendor Part Number) Item UPC Code TSC can provide a product cross-reference lis

Related Documents:

4010 EDI documents (note EDIFACT transaction sets will be required by Amazon EU divisions): EDI 753 - Request for Routing Instructions EDI 855 - PO Acknowledgement EDI 754 - Routing Instructions EDI 856 –Advance Ship Notice EDI 810 - Invoice EDI 860 –PO Change Request EDI 846 - Inventory Advice/Update EDI 865 –PO Change Seller

collection of EDI data is received in a batch. The batch of EDI data includes a plurality of EDI documents and each of the plurality of EDI documents has at least one EDI transaction corresponding to a transaction type. The EDI transactions included in the EDI documents are identified by decoding the received EDI data according to EDI standards.

4010 EDI documents (note EDIFACT transaction sets will be required by Amazon EU divisions): EDI 753 - Request for Routing Instructions EDI 855 - PO Acknowledgement EDI 754 - Routing Instructions EDI 856 – Advance Ship Notice EDI 810 - Invoice EDI 860 – PO Change Request

1. What is EDI? 2. What is the 'Omni-hannel' 3. Omni-Channel EDI solutions 4. Where does EDI fit into the marketplace? 5. Third Party Logistics (3PL) EDI 6. Online Retailers and CommerceHub EDI 7. eCommerce Platform EDI 8. B2BGateway EDI and QuickBooks Online 9. Pricing 10. Customer Service 11. B2BGateway Fact Sheet & Trading Partners 12 .

After connected to the iConnect By Timex 2, the watch will show local weather. The High and Low value of temperature will be displayed. 4.3.8 Relax Relax with iConnect Premium. Set the Relax mode to 1 or 2 minutes and the follow the instructions on the screen for guided breathing. 4.3.9 Music control

MAPPING Involves transforming an EDI document into another format (such as XML, a flat file, a delimited file, etc.) TRANSLATION The process of accepting in bound EDI data, or preparing an outbound file for transmission COMMUNICATIONS Refers to the transmission of the EDI transaction Accepted. The EDI message conforms to all agreed upon EDI .

TrueCommerce EDI Buyer's Guide As supply chains become more complex, EDI offers the technology . and provides all the components required for EDI, such as mapping, translation, and connectivity to trading partners. . h EDI 940 - Warehouse Shipping Order h EDI 945 - Warehouse Shipping Advice h EDI 997 - Functional Acknowledgement

EDI Notepad EDI Notepad is the ultimate EDI editor, providing all those clever features you've always wanted when working with EDI transactions. These features include several viewing modes, syntax validation for all EDI standards and versions, edit tools to edit or build EDI documents,