Đăng ký Đăng nhập
Trang chủ Công nghệ thông tin Kỹ thuật lập trình Wm810invoice5010_with tax in page 46 and 47...

Tài liệu Wm810invoice5010_with tax in page 46 and 47

.PDF
77
413
50

Mô tả:

Electronic Data Interchange Implementation Guideline ANSI X12 Version 5010 5 0 1 0 810 Invoice Business Usage: Invoice EDI Direction: To Walmart Implementation Guide Version 2.2 Published October 2005 Last Changed August 2013 Table of Contents Walmart Stores, Inc. Introduction to the 810 Invoice Transaction Set................................... 4 Walmart Stores, Inc. Freight Charge Invoicing Overview........................................................ 6 810 Invoice – Walmart Stores, Inc. Implementation ................................................................. 7 Canada TXI Segment Usage for Invoices .................................................................................. 9 Puerto Rico TXI Segment Usage for Invoices ......................................................................... 10 ST Transaction Set Header........................................................................................................ 11 BIG Beginning Segment for Invoice ......................................................................................... 12 REF Reference Information - Vendor Number......................................................................... 13 REF Reference Information - Department Number................................................................. 14 REF Reference Information - Merchandise Type Code .......................................................... 15 Loop Party Identification - Supplier.......................................................................................... 16 N1 Party Identification - Supplier.......................................................................................... 17 Loop Party Identification - Ship To........................................................................................... 18 N1 Party Identification - Ship To ........................................................................................... 19 N3 Party Location ....................................................................................................................... 20 N4 Geographic Location ............................................................................................................ 21 ITD Terms of Sale/Deferred Terms of Sale .............................................................................. 22 DTM Date/Time Reference - Shipped........................................................................................ 24 DTM Date/Time Reference - Effective ....................................................................................... 25 FOB F.O.B. Related Instructions............................................................................................... 26 Loop Baseline Item Data (Invoice)............................................................................................ 27 IT1 Baseline Item Data (Invoice)................................................................................................ 28 Loop Product/Item Description ................................................................................................. 35 PID Product/Item Description................................................................................................ 36 Loop Product/Item Description ................................................................................................. 37 810 (5010) 2 Wal-Mart Stores, Inc., Sensitive PID Product/Item Description................................................................................................ 38 PO4 Item Physical Details .......................................................................................................... 40 Loop Service, Promotion, Allowance, or Charge Information .............................................. 41 SAC Service, Promotion, Allowance, or Charge Information................................................ 42 TDS Total Monetary Value Summary........................................................................................ 45 TXI Tax Information .................................................................................................................... 46 CAD Carrier Details..................................................................................................................... 48 Loop Service, Promotion, Allowance, or Charge Information .............................................. 49 SAC Service, Promotion, Allowance, or Charge Information................................................ 50 Loop Invoice Shipment Summary............................................................................................. 54 ISS Invoice Shipment Summary................................................................................................ 55 CTT Transaction Totals.............................................................................................................. 56 SE Transaction Set Trailer......................................................................................................... 57 Walmart Business Example of an 810 Document ................................................................... 58 Walmart Business Example of a Canada 810 Document ....................................................... 61 Walmart Business Example of a Puerto Rico 810 Document ............................................... 64 ANSI X12 Introduction to the 810 Invoice Transaction Set.................................................... 66 ANSI X12 Guidelines - 810 Invoice Transaction Set............................................................... 67 VICS Introduction to the 810 Invoice Transaction Set ........................................................... 70 VICS Guidelines - 810 Invoice Transaction Set....................................................................... 72 Conventions Used in This Implementation Guideline: .......................................................... 74 Example of Conventions:........................................................................................................... 76 Change History............................................................................................................................ 77 810 (5010) 3 Wal-Mart Stores, Inc., Sensitive Walmart Stores, Inc. Introduction to the 810 Invoice Transaction Set The purpose of this section is to present and explain the usage of the EDI 810 Invoice by Wal-Mart Stores, Inc. Methods Within the retail industry, two distinct methods for ordering and invoicing goods have been identified. The first, which we have named basic, is the most common. It is the billing of goods separately for each location, i.e., one store per invoice number assigned. The second, known as Spreadsheet, is not supported by Walmart. Wal-Mart Stores, Inc. only supports the basic method of invoicing. Functional Acknowledgments The 997 Functional Acknowledgment is used by Wal-Mart Stores, Inc. to verify receipt of documents sent by our suppliers. Walmart will create the 997 to acknowledge receipt of your documents within 24 hours. If a 997 is not received for invoice transmission(s), please contact EDI Supplier Support by email at [email protected] or by telephone at (479) 273-8888. Text Message If errors are found in the data at the application level, i.e., GLN numbers missing, Wal-Mart Stores, Inc. will create an 864 Text Message. The 864 will be sent within 24 hours and will communicate the error(s) detected along with the invoice number(s). Data should be corrected and resent as soon as possible. Pack/Inner Pack Usage The PO4 segment is used to specify the packaging of the item in the case or carton. There may be two levels of the packaging specified. The first level of packaging is always specified by using PO401 (Pack). The first level may be actual items, e.g., consumer units, or it may be the number of smaller containers within the case. The second level, specified using PO414 (Inner Pack), is the number of eaches in each inner container when PO401 is the number of smaller containers with the case. 810 (5010) 4 Wal-Mart Stores, Inc., Sensitive Business Changes To support our growing company, Wal-Mart Stores, Inc. will be incorporating the following business changes into the 5010 upgrade. Walmart will utilize the GTIN (Global Traded Item Number) in EDI X12 Version 5010. GTIN information will be sent in addition to the UPC code. It will be the suppliers' responsibility to handle the information as their systems become GTIN compliant. For more information regarding GTIN, please visit the UCC () in the U.S., the ECCC () in Canada, or the appropriate numbering organization for your country. Compliance Data using the VICS EDI Semi-Custom Product Description Code Matrix (Data Element 751) Walmart utilizes the VICS EDI Semi-Custom Product Description Code Matrix to communicate item specific information relating to specific compliance initiatives such as: • California Formaldehyde emissions standards (CARB Rule) This code matrix is found within the PID segment. Walmart utilizes this code to identify the particular compliance initiative that the PID segment is being sent to comply with. The ten (10) position code is structured into four (4) parts as follows: PART 1 POSITION 01-02 DESCRIPTION Product Category Code EXAMPLE GM (General Merchandise) 2 03-04 Format Option Code 3 05-08 Description Code 04 (Indicates that PID05 will be used) COMP (Compliance) 4 09-10 Locator Placement Code (Compliance Initiative) FE (California Formaldehyde Emissions) 810 (5010) 5 Wal-Mart Stores, Inc., Sensitive Walmart Stores, Inc. Freight Charge Invoicing Overview Freight changes must be invoiced separately from merchandise. Invoices for freight charges must be sent directly to the address listed below. Including freight charges on EDI invoices will cause your invoices to be rejected. A paid freight bill and/or bill of lading must accompany freight charge invoices. Walmart does not support a Prepaid or ADD freight process. Any shipments for which Walmart is responsible to pay freight must be shipped collect. Any invoice for freight billed by the supplier will be assessed a $50 handling fee. If the terms are prepaid, or if you have made special arrangements with the buyer or someone else at Walmart, please provide a written explanation of the arrangements. Include names, phone numbers, dates, and any written correspondence along with the invoice for freight charges. All invoices for freight charges must include a Walmart vendor number and must have a unique invoice number. Invoices should reference the merchandise invoice number in order to expedite payment and allow for easier research. Submit freight charges to the following address: In the US: Wal-Mart Transportation Services Supplier Claims - 8076 702 S.W. 8th Street Bentonville, AR 72716-8076 In Canada: Wal-Mart Canada Corporation Logistics Department - Supplier Claims 1940 Argentina Road Mississauga, Ontario L5N 1P9 If you have further questions: If you have any additional questions, comments, or concerns about freight charges and how to send them please contact the appropriate office listed below: Wal-Mart US Traffic Financial Services - Supplier Claims 479-204-9941 Vendor Canada AP Hotline 905-812-2111 x4339 810 (5010) 6 Wal-Mart Stores, Inc., Sensitive 810 Invoice – Walmart Stores, Inc. Implementation Invoice Functional Group=IN 810 Heading: Pos 0100 0200 Id ST BIG 0500 REF 0500 REF 0500 REF LOOP ID - N1 0700 N1 LOOP ID - N1 0700 N1 0900 N3 1000 N4 1300 ITD 1400 DTM 1400 DTM 1500 FOB Segment Name Transaction Set Header Beginning Segment for Invoice Reference Information Vendor Number Reference Information Department Number Reference Information Merchandise Type Code Req M M Max Use 1 1 Repeat Notes Usage Must use Must use O 12 Used O 12 Used O 12 Used Party Identification - Supplier O 1 Party Identification - Ship To Party Location Geographic Location Terms of Sale/Deferred Terms of Sale Date/Time Reference Shipped Date/Time Reference Effective F.O.B. Related Instructions O O O O 1 2 1 >1 Used Used Used Used O 10 Used O 10 Used M 1 Used Req Max Use M 1 200 Used 200 Detail: Pos Id LOOP ID - IT1 0100 IT1 LOOP ID - PID 0600 PID LOOP ID - PID 0600 PID 1000 PO4 LOOP ID - SAC 1800 SAC 810 (5010) Segment Name Baseline Item Data (Invoice) Repeat 200000 Notes Usage Used 1000 Product/Item Description O 1 Product/Item Description Item Physical Details O O 1 1 Service, Promotion, Allowance, or Charge Information O 1 Used 1000 Used Used >1 7 Used Wal-Mart Stores, Inc., Sensitive Summary: Pos 0100 Id TDS 0200 TXI 0300 CAD LOOP ID - SAC 0400 SAC LOOP ID - ISS 0600 ISS 0700 CTT 0800 SE Segment Name Total Monetary Value Summary Tax Information Carrier Details Req M Max Use 1 O O >1 1 Service, Promotion, Allowance, or Charge Information O 1 Invoice Shipment Summary Transaction Totals Transaction Set Trailer M O M 1 1 1 Repeat Notes Usage Must use Used Used >1 Used >1 N3/0700 Used Used Must use Notes: 3/0700 Number of line items (CTT01) is the accumulation of the number of IT1 segments. If used CTT02 is the hash total of the quantities invoiced (IT102) for each IT1 segment. 810 (5010) 8 Wal-Mart Stores, Inc., Sensitive Canada TXI Segment Usage for Invoices IF HST APPLIES TO YOUR INVOICE, YOU WILL NEED TO SEND THE FOLLOWING: TXI* BE*AMOUNT*Tax Rate Percent******9 DIGIT 2 ALPHA 4 DIGIT TAX REGISTRATION NUMBER IF QST APPLIES TO YOUR INVOICE AND YOU ARE REGISTERED FOR QST: YOU WILL NEED TO SEND TWO TXI SEGMENTS There is a limit of two TXI segments. These can only be sent at summary level. TXI*GS*AMOUNT* Tax Rate Percent ******9 DIGIT 2 ALPHA 4 DIGIT REGISTRATION NUMBER TXI*PG*AMOUNT*Tax Rate Percent*SP*QST****10 DIGIT 2 ALPHA 4 DIGIT REGISTRATION NUMBER IF YOU ARE NOT REGISTERED FOR QST: SEND ONLY ONE TXI SEGMENT WITH A GS QUALIFIER. TXI*GS*AMOUNT* Tax Rate Percent******9 DIGIT 2 ALPHA 4 DIGIT REGISTRATION NUMBER IF GST APPLIES TO YOUR INVOICE, YOU WILL NEED TO USE: TXI*GS*AMOUNT* Tax Rate Percent ******9 DIGIT 2 ALPHA 4 DIGIT REGISTRATION NUMBER Please Note: If the items are non-taxable, the TXI segment is still required. EXAMPLE: TXI*GS*0*Tax Rate Percent******9 DIGIT 2 ALPHA 4 DIGIT REGISTRATION NUMBER. For more information regarding current tax percentages, please visit the Canada Revenue Agency website: http://www.cra-arc.gc.ca/menueng.html 810 (5010) 9 Wal-Mart Stores, Inc., Sensitive Puerto Rico TXI Segment Usage for Invoices Effective August 16th those doing business within Walmart Puerto Rico may need to make changes to their invoices in order to comply with recent tax changes within Puerto Rico IF ST APPLIES TO YOUR INVOICE, YOU WILL NEED TO USE: TXI*ST*AMOUNT* Tax Rate Please Note: If the items are non-taxable, the TXI segment is still required.  Important Note - Walmart Puerto Rico, Inc. is a holder of the Provisional Reseller Certificate and as such is not subject to Municipal Sales Tax on merchandise for resale. EXAMPLE: TXI*ST*0*Tax Rate Percent For more information on the Tax Burden Adjustment and Redistribution Act #40 - 2013, please contact your company’s tax dept or outside consultant. 810 (5010) 10 Wal-Mart Stores, Inc., Sensitive Pos: 0100 Max: 1 Heading - Mandatory Loop: N/A Elements: 2 Transaction Set Header ST User Option (Usage): Must use Purpose: To indicate the start of a transaction set and to assign a control number Element Summary: Ref ST01 Id 143 Element Name Transaction Set Identifier Code Req M Type ID Min/Max 3/3 Usage Must use 4/9 Must use Description: Code uniquely identifying a Transaction Set CodeList Summary (Total Codes: 318, Included: 1) Code Name 810 Invoice ST02 329 Transaction Set Control Number M AN Description: Identifying control number that must be unique within the transaction set functional group assigned by the originator for a transaction set VICS Note: The numb er is sequentially assigned by the sender, starting with one within each functional group. For each functional group, the first transaction set control numb er will b e 0001 and incremented b y one for each additional transaction set within the group. Semantics: 1. The transaction set identifier (ST01) is used by the translation routines of the interchange partners to select the appropriate transaction set definition (e.g., 810 selects the Invoice Transaction Set). 2. The implementation convention reference (ST03) is used by the translation routines of the interchange partners to select the appropriate implementation convention to match the transaction set definition. When used, this implementation convention reference takes precedence over the implementation reference specified in the GS08. 810 (5010) 11 Wal-Mart Stores, Inc., Sensitive Beginning Segment for Invoice BIG Pos: 0200 Max: 1 Heading - Mandatory Loop: N/A Elements: 4 User Option (Usage): Must use Purpose: To indicate the beginning of an invoice transaction set and transmit identifying numbers and dates Element Summary: Ref BIG01 Id 373 Element Name Date Req M Type DT Min/Max 8/8 Usage Must use Description: Date expressed as CCYYMMDD where CC represents the first two digits of the calendar year BIG02 BIG03 BIG04 76 Invoice Number M AN 1/22 Must use 373 Description: Identifying number assigned by issuer Walmart Note: Walmart will only accept a maximum of 15 digits for the invoice numb er. The Accounts Payab le system will only post numeric characters. For example: if invoice numb er 123456AB is sent, it will post in accounts payab le as 123456. Date O DT 8/8 Used 324 Description: Date expressed as CCYYMMDD where CC represents the first two digits of the calendar year Walmart Note: The original Walmart purchase order date. Purchase Order Number O AN 1/22 Used Description: Identifying number for Purchase Order assigned by the orderer/purchaser Walmart Note: Walmart's original 10 digit purchase order numb er. Semantics: 1. BIG01 is the invoice issue date. 2. BIG03 is the date assigned by the purchaser to purchase order. 3. BIG10 is the consolidated invoice number associated with the invoice identified in BIG02. When BIG07 contains code CI (Consolidated Invoice), BIG02 will contain the consolidated invoice number and BIG10 is not used. Comments: 1. BIG07 is used only to further define the type of invoice when needed. 810 (5010) 12 Wal-Mart Stores, Inc., Sensitive Reference Information Vendor Number REF Pos: 0500 Max: 12 Heading - Optional Loop: N/A Elements: 2 User Option (Usage): Used Purpose: To specify identifying information Walmart Note: This segment is required b y Wal-Mart Stores, Inc. Element Summary: Ref REF01 Id 128 Element Name Reference Identification Qualifier Req M Type ID Min/Max 2/3 Usage Must use 1/50 Used Description: Code qualifying the Reference Identification CodeList Summary (Total Codes: 1731, Included: 1) Code Name IA Internal Vendor Number REF02 127 Reference Identification X AN Description: Reference information as defined for a particular Transaction Set or as specified by the Reference Identification Qualifier Walmart Note: This element contains the Walmart assigned 9-digit Vendor Number. Syntax Rules: 1. R0203 - At least one of REF02 or REF03 is required. Semantics: 1. REF04 contains data relating to the value cited in REF02. 810 (5010) 13 Wal-Mart Stores, Inc., Sensitive Reference Information Department Number REF Pos: 0500 Max: 12 Heading - Optional Loop: N/A Elements: 2 User Option (Usage): Used Purpose: To specify identifying information Walmart Note: This segment contains the Walmart Department Number. Element Summary: Ref REF01 Id 128 Element Name Reference Identification Qualifier Req M Type ID Min/Max 2/3 Usage Must use 1/50 Used Description: Code qualifying the Reference Identification CodeList Summary (Total Codes: 1731, Included: 1) Code Name DP Department Number REF02 127 Reference Identification X AN Description: Reference information as defined for a particular Transaction Set or as specified by the Reference Identification Qualifier Walmart Note: Walmart 5 digit Department Number. Must b e zero padded to 5 digits. Syntax Rules: 1. R0203 - At least one of REF02 or REF03 is required. Semantics: 1. REF04 contains data relating to the value cited in REF02. 810 (5010) 14 Wal-Mart Stores, Inc., Sensitive Reference Information Merchandise Type Code REF Pos: 0500 Max: 12 Heading - Optional Loop: N/A Elements: 2 User Option (Usage): Used Purpose: To specify identifying information Walmart Note: This segment contains the Walmart Order Type Element Summary: Ref REF01 Id 128 Element Name Reference Identification Qualifier Req M Type ID Min/Max 2/3 Usage Must use 1/50 Used Description: Code qualifying the Reference Identification CodeList Summary (Total Codes: 1731, Included: 1) Code Name MR Merchandise Type Code REF02 127 Reference Identification X AN Description: Reference information as defined for a particular Transaction Set or as specified by the Reference Identification Qualifier Walmart Note: Walmart 4 digit Order Type. Must b e zero padded to 4 digits. Syntax Rules: 1. R0203 - At least one of REF02 or REF03 is required. Semantics: 1. REF04 contains data relating to the value cited in REF02. 810 (5010) 15 Wal-Mart Stores, Inc., Sensitive Pos: 0700 Repeat: 200 Optional Loop: N1 Elements: N/A Loop Party Identification - Supplier User Option (Usage): Used Purpose: To identify a party by type of organization, name, and code Loop Summary: Pos 0700 810 (5010) Id N1 Segment Name Party Identification - Supplier Req O 16 Max Use 1 Repeat Usage Used Wal-Mart Stores, Inc., Sensitive Party Identification Supplier N1 Pos: 0700 Max: 1 Heading - Optional Loop: N1 Elements: 4 User Option (Usage): Used Purpose: To identify a party by type of organization, name, and code VICS Note: N103 and N104 are required except when N101 contains code CT or RI. When the ship to (N101 contains code ST) is the end consumer (customer of retailer), N103 and N104 are not required. In some EDI implementations, it may b e necessary to identify the sender and/or receiver of the transaction set. To identify the sender of the transaction set, N101 will contain code FR. To identify the receiver of the transaction set, N101 will contain code TO. When N101 contains code RI, N106 may b e used to indicate that the remit-to party is a factor. Walmart Note: This segment is required b y Wal-Mart Stores, Inc Element Summary: Ref N101 Id 98 Element Name Entity Identifier Code Req M Type ID Min/Max 2/3 Usage Must use Description: Code identifying an organizational entity, a physical location, property or an individual CodeList Summary (Total Codes: 1500, Included: 1) Code Name SU Supplier/Manufacturer N102 93 Name X AN 1/60 Used X ID 1/2 Used Description: Free-form name N103 66 Identification Code Qualifier Description: Code designating the system/method of code structure used for Identification Code (67) Walmart Note: This element is not required b y Wal-Mart Stores, Inc., b ut is recommended. CodeList Summary (Total Codes: 241, Included: 3) Code Name 1 D-U-N-S Number, Dun & Bradstreet 9 D-U-N-S+4, D-U-N-S Number with Four Character Suffix UL Global Location Number (GLN) Description: A glob ally unique 13 digit code for the identification of a legal, functional or physical location within the Uniform Code Council (UCC) and International Article Number Association (EAN) numbering system N104 67 Identification Code X AN 2/80 Used Description: Code identifying a party or other code VICS Note: This is the location code as defined b y N103. The location code may b e a formal numb er, e.g., DUNS, or it may b e assigned b y either the b uyer or seller. The location refers to a store, warehouse, distrib ution center, plant, etc. Location codes are used to alleviate the need to send complete names and addresses. Walmart Note: This element is not required b y Wal-Mart Stores, Inc., b ut is recommended. Syntax Rules: 1. R0203 - At least one of N102 or N103 is required. 2. P0304 - If either N103 or N104 is present, then the other is required. Comments: 1. This segment, used alone, provides the most efficient method of providing organizational identification. To obtain this efficiency the "ID Code" (N104) must provide a key to the table maintained by the transaction processing party. 2. N105 and N106 further define the type of entity in N101. 810 (5010) 17 Wal-Mart Stores, Inc., Sensitive Pos: 0700 Repeat: 200 Optional Loop: N1 Elements: N/A Loop Party Identification - Ship To User Option (Usage): Used Purpose: To identify a party by type of organization, name, and code Loop Summary: Pos 0700 0900 1000 810 (5010) Id N1 N3 N4 Segment Name Party Identification - Ship To Party Location Geographic Location Req O O O 18 Max Use 1 2 1 Repeat Usage Used Used Used Wal-Mart Stores, Inc., Sensitive Party Identification - Ship To N1 Pos: 0700 Max: 1 Heading - Optional Loop: N1 Elements: 4 User Option (Usage): Used Purpose: To identify a party by type of organization, name, and code Walmart Note: This segment is required b y Wal-Mart Stores, Inc Element Summary: Ref N101 Id 98 Element Name Entity Identifier Code Req M Type ID Min/Max 2/3 Usage Must use Description: Code identifying an organizational entity, a physical location, property or an individual CodeList Summary (Total Codes: 1500, Included: 1) Code Name ST Ship To N102 N103 93 Name X AN 1/60 Used 66 Description: Free-form name Walmart Note: The appropriate 4-digit store or warehouse location code should b e sent; for example, WAL-MART WHSE# 6009 or WAL-MART STORE 0100. Identification Code Qualifier X ID 1/2 Used Description: Code designating the system/method of code structure used for Identification Code (67) Walmart Note: This element is required b y Wal-Mart Stores, Inc. CodeList Summary (Total Codes: 241, Included: 3) Code Name 1 D-U-N-S Number, Dun & Bradstreet 9 D-U-N-S+4, D-U-N-S Number with Four Character Suffix UL Global Location Number (GLN) Description: A glob ally unique 13 digit code for the identification of a legal, functional or physical location within the Uniform Code Council (UCC) and International Article Number Association (EAN) numbering system N104 67 Identification Code X AN 2/80 Used Description: Code identifying a party or other code VICS Note: This is the location code as defined b y N103. The location code may b e a formal numb er, e.g., DUNS, or it may b e assigned b y either the b uyer or seller. The location refers to a store, warehouse, distrib ution center, plant, etc. Location codes are used to alleviate the need to send complete names and addresses. Walmart Note: This element is required b y Wal-Mart Stores, Inc. Syntax Rules: 1. R0203 - At least one of N102 or N103 is required. 2. P0304 - If either N103 or N104 is present, then the other is required. Comments: 1. This segment, used alone, provides the most efficient method of providing organizational identification. To obtain this efficiency the "ID Code" (N104) must provide a key to the table maintained by the transaction processing party. 2. N105 and N106 further define the type of entity in N101. 810 (5010) 19 Wal-Mart Stores, Inc., Sensitive N3 Pos: 0900 Max: 2 Heading - Optional Loop: N1 Elements: 2 Party Location User Option (Usage): Used Purpose: To specify the location of the named party Element Summary: Ref N301 Id 166 Element Name Address Information Req M Type AN Min/Max 1/55 Usage Must use O AN 1/55 Used Description: Address information N302 166 Address Information Description: Address information 810 (5010) 20 Wal-Mart Stores, Inc., Sensitive
- Xem thêm -

Tài liệu liên quan