X12 810 Invoice
This X12 Transaction Set contains the format and establishes the data contents of the Invoice Transaction Set (810) for use within the context of an Electronic Data Interchange (EDI) environment. The transaction set can be used to provide for customary and established business and industry practice relative to the billing for goods and services provided.
- ~ Segment
- * Element
- > Component
- ^ Repetition
- None included
Interchange Control Header
To start and identify an interchange of zero or more functional groups and interchange-related control segments
Code identifying the type of information in the Authorization Information
- 00
- No Authorization Information Present (No Meaningful Information in I02)
Information used for additional identification or authorization of the interchange sender or the data in the interchange; the type of information is set by the Authorization Information Qualifier (I01)
Code identifying the type of information in the Security Information
- 00
- No Security Information Present (No Meaningful Information in I04)
This is used for identifying the security information about the interchange sender or the data in the interchange; the type of information is set by the Security Information Qualifier (I03)
Code indicating the system/method of code structure used to designate the sender or receiver ID element being qualified
Identification code published by the sender for other parties to use as the receiver ID to route data to them; the sender always codes this value in the sender ID element
Code indicating the system/method of code structure used to designate the sender or receiver ID element being qualified
Identification code published by the receiver of the data; When sending, it is used by the sender as their sending ID, thus other parties sending to them will use this as a receiving ID to route data to them
Type is not applicable; the repetition separator is a delimiter and not a data element; this field provides the delimiter used to separate repeated occurrences of a simple data element or a composite data structure; this value must be different than the data element separator, component element separator, and the segment terminator
- ^
- Repetition Separator
Code specifying the version number of the interchange control segments
- 00501
- Standards Approved for Publication by ASC X12 Procedures Review Board through October 2003
A control number assigned by the interchange sender
Code indicating sender's request for an interchange acknowledgment
- 0
- No Interchange Acknowledgment Requested
- 1
- Interchange Acknowledgment Requested (TA1)
Code indicating whether data enclosed by this interchange envelope is test, production or information
- I
- Information
- P
- Production Data
- T
- Test Data
Type is not applicable; the component element separator is a delimiter and not a data element; this field provides the delimiter used to separate component data elements within a composite data structure; this value must be different than the data element separator and the segment terminator
- >
- Component Element Separator
Functional Group Header
To indicate the beginning of a functional group and to provide control information
Code identifying a group of application related transaction sets
- IN
- Invoice Information (810)
Code identifying party sending transmission; codes agreed to by trading partners
Code identifying party receiving transmission; codes agreed to by trading partners
Date expressed as CCYYMMDD where CC represents the first two digits of the calendar year
Time expressed in 24-hour clock time as follows: HHMM, or HHMMSS, or HHMMSSD, or HHMMSSDD, where H = hours (00-23), M = minutes (00-59), S = integer seconds (00-59) and DD = decimal seconds; decimal seconds are expressed as follows: D = tenths (0-9) and DD = hundredths (00-99)
Assigned number originated and maintained by the sender
Code identifying the issuer of the standard; this code is used in conjunction with Data Element 480
- T
- Transportation Data Coordinating Committee (TDCC)
- X
- Accredited Standards Committee X12
Code indicating the version, release, subrelease, and industry identifier of the EDI standard being used, including the GS and GE segments; if code in DE455 in GS segment is X, then in DE 480 positions 1-3 are the version number; positions 4-6 are the release and subrelease, level of the version; and positions 7-12 are the industry or trade association identifiers (optionally assigned by user); if code in DE455 in GS segment is T, then other formats are allowed
- 005010VICS
Heading
Transaction Set Header
To indicate the start of a transaction set and to assign a control number
Code uniquely identifying a Transaction Set
- 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).
- 810
- Invoice
Beginning Segment for Invoice
To indicate the beginning of an invoice transaction set and transmit identifying numbers and dates
Examples:
Traditional Invoice: BIG20050205646336720050202337603367
Credit Invoice: BIG20050205646336720050202337603367***CN
Date expressed as CCYYMMDD where CC represents the first two digits of the calendar year
- BIG01 is the invoice issue date.
Identifying number assigned by issuer
Walmart Accounts Payable will only accept a maximum of 15 digits for the invoice number and will only post numeric characters. (Example: If invoice number 123456AB is sent, it will post in accounts payable as 123456.)
Date expressed as CCYYMMDD where CC represents the first two digits of the calendar year
- BIG03 is the date assigned by the purchaser to purchase order.
Identifying number for Purchase Order assigned by the orderer/purchaser
Walmart's original 10-digit purchase order number.
Code specifying the type of transaction
- BIG07 is used only to further define the type of invoice when needed.
This element (BIG07) should only be included when sending a credit or expense invoice.
- CN
- Credit Invoice
Walmart Credit Invoice Note(s): To send an acceptable Walmart store credit invoice the BIG07 must be set to 'CN' (Credit Invoice).
- CT
- Cost Type Invoice
Walmart Note(s): Suppliers invoicing Department 99 with active items must send a 'CT' (Cost Type Invoice) in the BIG07.
Reference Information Department Number
To specify identifying information
Example: REFDP00017
Code qualifying the Reference Identification
- DP
- Department Number
Walmart Note(s): When sent, the Reference Identification (REF02) should contain the zero padded 5-digit Walmart department number.
Reference Information Internal Vendor Number
To specify identifying information
Example: REFIA123456170
Code qualifying the Reference Identification
- IA
- Internal Vendor Number
VICS Note(s): Identification number assigned to the vendor, by the retailer, for use within the retailer’s system
Walmart Note(s): At least one instance of the Reference Information (REF) segment with Internal Vendor Number (IA) qualifier is required by Walmart. When sent, the Reference Identification (REF02) should contain the Walmart assigned 9-digit vendor number.
Reference Information Merchandise Type Code
To specify identifying information
Example: REFMR0020
Code qualifying the Reference Identification
- MR
- Merchandise Type Code
Walmart Note(s): When sent, the Reference Identification (REF02) should contain the zero-padded 4-digit Walmart purchase order type.
This N1 loop may need to be sent multiple times with different listed N1 qualifiers (N101) to communicate all necessary invoice details.
Party Identification
To identify a party by type of organization, name, and code
One or more N1 segment iterations is required to meet Walmart requirements. See the N101 for details on which N1 qualifiers are needed.
Example: N1STWAL-MART 100UL0078742000992
Code identifying an organizational entity, a physical location, property or an individual
- ST
- Ship To
Walmart Note(s): At least on instance of the Party Identification (N1) segment with Ship To (ST) qualifier is required by Walmart.
When sent, the Name (N102), Identification Code Qualifier (N103), and Identification Code (N104) are required by Walmart.
Free-form name
When the Party Identification (N101) contains a Ship To qualifier (ST), the Name (N102) is required by Walmart and should contain a free-format description of the location including the 5-digit location number. (Example: WAL-MART WHSE# 06009 or WALMART STORE 00100)
SUPPLIER NAME
WAL-MART 100
WAL-MART WHSE# 06009
WALMART STORE 00100
Code designating the system/method of code structure used for Identification Code (67)
- UL
- Global Location Number (GLN)
Walmart Note(s): The Identification Code Qualifier (N103) must contain a Global Location Number (UL) qualifier when the Entity Identification Code (N101) contains a Ship To (ST) qualifier.
When sent, the Identification Code (N104) must contain a 13-digit Global Location Number for the Walmart Facility to which the product was initially delivered.
Code identifying a party or other code
- 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.
Party Location
To specify the location of the named party
The N3 (Party Location) is recommended when N101 is 'ST' (Ship To).
Example: N3*406 SOUTH WALTON BLVD
Geographic Location
To specify the geographic place of the named party
The N4 (Geographic Location) is recommended when N101 is 'ST' (Ship To).
Example: N4BENTONVILLEAR*72712
Free-form text for city name
- A combination of either N401 through N404, or N405 and N406 may be adequate to specify a location.
Code (Standard State/Province) as defined by appropriate government agency
- N402 is required only if city name (N401) is in the U.S. or Canada.
Code defining international postal zone code excluding punctuation and blanks (zip code for United States)
This N1 loop may need to be sent multiple times with different listed N1 qualifiers (N101) to communicate all necessary invoice details.
Party Identification
To identify a party by type of organization, name, and code
One or more N1 segment iterations is required to meet Walmart requirements. See the N101 for details on which N1 qualifiers are needed.
Example: N1SUSUPPLIER NAME
Code identifying an organizational entity, a physical location, property or an individual
- SU
- Supplier/Manufacturer
Walmart Note(s): Walmart requires an instance of the N1 be sent with a N101 of 'SU'. When sent, Walmart requires the Name (N102) contain the free-form vendor name.
Free-form name
SUPPLIER NAME
WAL-MART 100
WAL-MART WHSE# 06009
WALMART STORE 00100
Code designating the system/method of code structure used for Identification Code (67)
- UL
- Global Location Number (GLN)
Walmart Note(s): The Identification Code Qualifier (N103) must contain a Global Location Number (UL) qualifier when the Entity Identification Code (N101) contains a Ship To (ST) qualifier.
When sent, the Identification Code (N104) must contain a 13-digit Global Location Number for the Walmart Facility to which the product was initially delivered.
Code identifying a party or other code
- 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.
Party Location
To specify the location of the named party
Example: N3*406 SOUTH WALTON BLVD
Geographic Location
To specify the geographic place of the named party
Example: N4BENTONVILLEAR*72712
Free-form text for city name
- A combination of either N401 through N404, or N405 and N406 may be adequate to specify a location.
Code (Standard State/Province) as defined by appropriate government agency
- N402 is required only if city name (N401) is in the U.S. or Canada.
Code defining international postal zone code excluding punctuation and blanks (zip code for United States)
Terms of Sale/Deferred Terms of Sale
To specify terms of sale
Example: ITD0515*****45
Code identifying type of payment terms
- If the code in ITD01 is "04", then ITD07 or ITD09 is required and either ITD10 or ITD11 is required; if the code in ITD01 is "05", then ITD06 or ITD07 is required.
- 02
- End of Month (EOM)
- 05
- Discount Not Applicable
- 08
- Basic Discount Offered
Code identifying the beginning of the terms period
- 1
- Ship Date
- 3
- Invoice Date
- 7
- Effective Date
VICS Note(s): The date is specified in the DTM segment in the header area using code 007 in DTM01.
- 15
- Receipt of Goods
Terms discount percentage, expressed as a percent, available to the purchaser if an invoice is paid on or before the Terms Discount Due Date
VICS Note(s): The percent is sent with a decimal point only when needed, e.g., 10.5% is sent as ‘‘10.5’’, and 2% is sent as ‘‘2’’.
Number of days in the terms discount period by which payment is due if terms discount is earned
VICS Note(s): The end of the term period is derived by adding this value to the beginning of the term period, as qualified by ITD02.
Number of days until total invoice amount is due (discount not applicable)
VICS Note(s): The end of the term period is derived by adding this value to the beginning of the term period, as qualified by ITD02.
Date/Time Reference Effective
To specify pertinent dates and times
Walmart Note(s): This segment may need to be sent multiple times with different listed qualifiers (DTM01) to communicate all necessary invoice details.
Code specifying type of date or time, or both date and time
- 007
- Effective
VICS Note(s): For terms.
Walmart Note(s): At least one instance of the Date/Time Reference (DTM) segment with Effective (007) qualifier is required by Walmart when the Terms Basis Date Code (ITD02) contains an Effective Date (7) qualifier. When sent, the Date (DTM02) should contain the agreed upon effective date for the terms.
Date/Time Reference Shipped
To specify pertinent dates and times
Walmart Note(s): This segment may need to be sent multiple times with different listed qualifiers (DTM01) to communicate all necessary invoice details.
Example: DTM01120050205
Code specifying type of date or time, or both date and time
- 011
- Shipped
Walmart Note(s): At least one instance of the Date/Time Reference (DTM) segment with Shipped (011) qualifier is required by Walmart when the Terms Basis Date Code (ITD02) contains a Ship Date (1) qualifier.
When sent, the Date (DTM02) should contain the date the product being invoiced was shipped.
F.O.B. Related Instructions
To specify transportation instructions relating to shipment
Example: FOB*CC
Detail
Baseline Item Data (Invoice)
To specify the basic and most frequently used line item data for the invoice and related transactions
Examples:
Traditional Invoice: IT11080EA3.61IN001719653UP022108955228UK00221089552284
Credit Invoice: IT1-1080EA3.61**IN001719653UP022108955228UK00221089552284
Number of units invoiced (supplier units)
Walmart Credit Invoice Note(s): To send an acceptable Walmart store credit invoice the IT102 should be sent with a negative quantity equal to the quantity being credited. The quantity being credited cannot exceed the total amount that was invoiced.
1080
-1080
Code specifying the units in which a value is being expressed, or manner in which a measurement has been taken
- CA
- Case
- EA
- Each
Price per unit of product, service, commodity, etc.
VICS Note(s): The price is sent with a decimal point only when needed, e.g., $15.95 would be sent as ‘‘15.95’’, and $29.00 would be sent as ‘‘29’’. To indicate a no charge item or free goods, IT104 will contain a single zero (0) and IT105 will contain code NC.
Walmart Credit Invoice Note(s): To send an acceptable Walmart store credit invoice the IT104 should remain a positive value.
Code identifying the type/source of the descriptive number used in Product/Service ID (234)
- IT106 through IT125 provide for ten different product/service IDs for each item. For example: Case, Color, Drawing No., U.P.C. No., ISBN No., Model No., or SKU.
Walmart requires one or more of the following 'Product/Service ID Qualifier' elements (IT106-IT124 [Even]) be sent in the IT1:
. 'IN' (Buyer's Item Number)
. 'EN' (GTIN-13)
. 'UP' (GTIN-12)
- CH
- Country of Origin Code
US Country of Origin labeling (COOL) Act compliance requires:
. One 'Product/Service ID Qualifier' element (IT106-IT124 [Even]) containing a 'CH' (Country of Origin code) qualifier
. A corresponding 'Product/Service ID' element (IT107-IT125 [Odd]) containing a ISO-3133-1 2-character alpha country code - EN
- GTIN-13
A 13-digit GS1 Identification Key composed of a GS1 Company Prefix, Item Reference and Check Digit used to identify trade items
- IN
- Buyer's Item Number
Walmart 9-digit Item Number
- LT
- Lot Number
US Country of Origin labeling (COOL) Act compliance requires:
. One 'Product/Service ID Qualifier' element (IT106-IT124 [Even]) containing a 'LT' (Lot Number) qualifier
. A corresponding 'Product/Service ID' element (IT107-IT125 [Odd]) containing a Lot Number - UK
- GTIN-14
A 14-digit GS1 Identification Key composed of an Indicator Digit, GS1 Company Prefix, Item Reference and Check Digit used to identify trade items
- UP
- GTIN-12
A 12-digit GS1 Identification Key composed of a GS1 Company Prefix, Item Reference, and Check Digit used to identify trade items
- ZZ
- Mutually Defined
US Country of Origin labeling (COOL) Act compliance requires:
. One 'Product/Service ID Qualifier' element (IT106-IT124 [Even]) containing a 'ZZ' (Mutually Defined) qualifier
. A corresponding 'Product/Service ID' element (IT107-IT125 [Odd]) containing a one of the following Method of Catch types:
. FARM RAISED
. WILD CAUGHT
. NA (For non-seafood items only)
Identifying number for a product or service
Code identifying the type/source of the descriptive number used in Product/Service ID (234)
See Walmart Notes in the IT106.
- CH
- Country of Origin Code
- EN
- GTIN-13
- IN
- Buyer's Item Number
- LT
- Lot Number
- UK
- GTIN-14
- UP
- GTIN-12
- ZZ
- Mutually Defined
Identifying number for a product or service
Code identifying the type/source of the descriptive number used in Product/Service ID (234)
See Walmart Notes in the IT106.
- CH
- Country of Origin Code
- EN
- GTIN-13
- IN
- Buyer's Item Number
- LT
- Lot Number
- UK
- GTIN-14
- UP
- GTIN-12
- ZZ
- Mutually Defined
Identifying number for a product or service
Code identifying the type/source of the descriptive number used in Product/Service ID (234)
See Walmart Notes in the IT106.
- CH
- Country of Origin Code
- EN
- GTIN-13
- IN
- Buyer's Item Number
- LT
- Lot Number
- UK
- GTIN-14
- UP
- GTIN-12
- ZZ
- Mutually Defined
Identifying number for a product or service
Code identifying the type/source of the descriptive number used in Product/Service ID (234)
See Walmart Notes in the IT106.
- CH
- Country of Origin Code
- EN
- GTIN-13
- IN
- Buyer's Item Number
- LT
- Lot Number
- UK
- GTIN-14
- UP
- GTIN-12
- ZZ
- Mutually Defined
Identifying number for a product or service
Code identifying the type/source of the descriptive number used in Product/Service ID (234)
See Walmart Notes in the IT106.
- CH
- Country of Origin Code
- EN
- GTIN-13
- IN
- Buyer's Item Number
- LT
- Lot Number
- UK
- GTIN-14
- UP
- GTIN-12
- ZZ
- Mutually Defined
Identifying number for a product or service
Code identifying the type/source of the descriptive number used in Product/Service ID (234)
See Walmart Notes in the IT106.
- CH
- Country of Origin Code
- EN
- GTIN-13
- IN
- Buyer's Item Number
- LT
- Lot Number
- UK
- GTIN-14
- UP
- GTIN-12
- ZZ
- Mutually Defined
Identifying number for a product or service
Code identifying the type/source of the descriptive number used in Product/Service ID (234)
See Walmart Notes in the IT106.
- CH
- Country of Origin Code
- EN
- GTIN-13
- IN
- Buyer's Item Number
- LT
- Lot Number
- UK
- GTIN-14
- UP
- GTIN-12
- ZZ
- Mutually Defined
Identifying number for a product or service
Code identifying the type/source of the descriptive number used in Product/Service ID (234)
See Walmart Notes in the IT106.
- CH
- Country of Origin Code
- EN
- GTIN-13
- IN
- Buyer's Item Number
- LT
- Lot Number
- UK
- GTIN-14
- UP
- GTIN-12
- ZZ
- Mutually Defined
Identifying number for a product or service
Code identifying the type/source of the descriptive number used in Product/Service ID (234)
See Walmart Notes in the IT106.
- CH
- Country of Origin Code
- EN
- GTIN-13
- IN
- Buyer's Item Number
- LT
- Lot Number
- UK
- GTIN-14
- UP
- GTIN-12
- ZZ
- Mutually Defined
Product/Item Description
To describe a product or process in coded or free-form format
VICS Note(s): The PID segment is used to provide product/item descriptions in text and or coded formats. The codes in PID04 are published only in this guideline. This segment may be used to transmit semi-custom product descriptions, such as made-to-order window coverings, jewelry, furniture, apparel, automotive parts, and other customer specific products. When used for this purpose, PID04 will contain the multi-part VICS EDI Semi-Custom Product Description Code. The complete code list is contained in Section III. In addition to the VICS EDI Semi-Custom Product Description Code, PID05 may be used for text descriptions, PID06 for relative placement, and additional MEA segment(s) for actual measurement values.
Walmart Note(s): In addition to communicating Compliance detail the PID segment can be used to communicate Product descriptions using a PID01 qualifier of 'F' (Free-form) and PID05.
Walmart Compliance Note(s): For compliance with California Air Resource Board's Air Toxic Control Measure (CARB) or TSCA (Toxic Substances Control Act) Title VI for formaldehyde emissions a PID with a 'S' (Structured) in the PID01, 'VI' (VICS EDI) in the PID03, and the applicable selection from the codelist provided in the PID04 and PID05.
Examples:
PIDFITEM DESCRIPTION
PIDSVIGM04COMPFE2
PIDS**VIGM04COMPTS*5
Code indicating the format of a description
- If PID01 equals "F", then PID05 is used. If PID01 equals "S", then PID04 is used. If PID01 equals "X", then both PID04 and PID05 are used.
- F
- Free-form
Used along with free-format PID05 to send Product Descriptions.
- S
- Structured (From Industry Code List)
Used for compliance with California Air Resource Board's Air Toxic Control Measure (CARB) see segment note.
Code identifying the agency assigning the code values
- Use PID03 to indicate the organization that publishes the code list being referred to.
- VI
- Voluntary Inter-Industry Commerce Standard (VICS) EDI
Used for compliance with California Air Resource Board's Air Toxic Control Measure (CARB) see segment note.
A code from an industry code list which provides specific data about a product characteristic
- PID04 should be used for industry-specific product description codes.
- GM04COMPFE
- California Air Resources Board (CARB) Formaldehyde Act
Indication of compliance with CARB Rule.
Used for compliance with California Air Resource Board's Air Toxic Control Measure (CARB) see segment note.
- GM04COMPTS
- TSCA (Toxic Substances Control Act) Title VI
A free-form description to clarify the related data elements and their content
Free Format Item Description sent here. For compliance use see codelist:
Code Name
- 2: CARB Phase II Compliant
Description: All composite wood materials sold with the product are
compliant with Phase 2 of the CARB formaldehyde emissions rules. - 3: CARB No Additional Formaldehyde compliant
Description: Product is exempt from compliance testing because it is
fabricated using CARB approved "No Added Formaldehyde" materials. - 4: CARB Ultra Low Emission Formaldehyde compliant
Description: Product is exempt from compliance testing because it is
fabricated using CARB approved "Ultra Low Emission Formaldehyde"
material. - 5: TSCA Title VI Compliant
Item Physical Details
To specify the physical qualities, packaging, weights, and dimensions relating to the item
This segment is required when the IT103 contains a Unit of Measure of 'CA' (Cases) and is used to identify the number of selling units are in a case. Do not send if the IT103 contains a Unit of Measure in 'EA' (Eaches).
Example: PO412************1
Service, Promotion, Allowance, or Charge Information
To request or identify a service, promotion, allowance, or charge; to specify the amount or percentage for the service, promotion, allowance, or charge
Example: SACAI4102350****02
Code which indicates an allowance or charge for the service specified
- If SAC01 is "A" or "C", then at least one of SAC05, SAC07, or SAC08 is required.
- A
- Allowance
- C
- Charge
Code identifying the service, promotion, allowance, or charge
- A260
- Advertising Allowance
- B000
- Central Buy
- B270
- Collect Surcharge
Collection Allowance
- B720
- Cooperative Advertising/Merchandising Allowance (Performance)
- B950
- Damaged Merchandise
- C000
- Defective Allowance
- C220
- Development Charge
- C310
- Discount
- C320
- Display Allowance
- C490
- Drum Deposit
- C530
- Duty Charge
- C540
- Early Buy Allowance
- C550
- Early Payment Allowance
- C580
- Emergency Service
- D170
- Free Goods
- D240
- Freight
Accepted as an allowance only; charges not accepted with this code.
- D500
- Handling
- E720
- New Distribution Allowance
- E740
- New Store Allowance
- E750
- New Store Discount
- F180
- Pallet
- F210
- Parish/County Sales Tax (only)
County Excise Tax
- F330
- Pickup and Delivery
- F670
- Price and Marketing Allowance
- F800
- Promotional Allowance
- F910
- Quantity Discount
- F970
- Rebate
- G470
- Restocking Charge
Restocking Fee
- G970
- Small Order Charge
Order Quantity Fee
- H010
- Special Buy
- H420
- Storage in Transit
- H505
- Sugar Fee
Sugar Sweetened Beverage Tax
- H560
- Swell
- H750
- Tax - Sales Tax (State and Local)
Pre-collected/Prepaid Sales Tax
- H770
- Tax - State Tax
State Excise Tax
- H780
- Tax - Super Fund Excise Tax
Federal Superfund
- H910
- Temperature Protection
- H920
- Temporary Allowance
- I170
- Trade Discount
- I310
- Truckload Discount
- I410
- Unsaleable Merchandise Allowance
- I530
- Volume Discount
- I570
- Warehouse
Monetary amount
- SAC05 is the total amount for the service, promotion, allowance, or charge.
- If SAC05 is present with SAC07 or SAC08, then SAC05 takes precedence.
When a Service, Promotion, Allowance or Charge (SAC) segment is sent this element is required by Walmart.
Code indicating on what basis allowance or charge percent is calculated
- 1
- Item List Cost
- 2
- Item Net Cost
- 3
- Discount/Gross
All allowances are off the gross price including cash discount.
- 4
- Discount/Net
All allowances are off the gross price. Cash discounts are off the net.
- 5
- Base Price per Unit
Line item discount
- 6
- Base Price Amount
- 7
- Base Price Amount Less Previous Discount
Declining balance method
Percent given in decimal format (e.g., 0.0 through 100.0 represents 0% through 100%)
The percent is sent with a decimal point only when needed, e.g., 10.5% is sent as ‘‘10.5’’, and 2% is sent as ‘‘2’’.
Rate expressed in the standard monetary denomination for the currency specified
- SAC08 is the allowance or charge rate per unit.
Code specifying the units in which a value is being expressed, or manner in which a measurement has been taken
- CA
- Case
- EA
- Each
Numeric value of quantity
- SAC10 and SAC11 is the quantity basis when the allowance or charge quantity is different from the purchase order or invoice quantity.
- SAC10 and SAC11 used together indicate a quantity range, which could be a dollar amount, that is applicable to service, promotion, allowance, or charge.
- In some business applications, it is necessary to advise the trading partner of the actual dollar amount that a particular allowance, charge, or promotion was based on to reduce ambiguity. This amount is commonly referred to as "Dollar Basis Amount". It is represented in the SAC segment in SAC10 using the qualifier "DO" - Dollars in SAC09.
When SAC02 contains code D170, this data element is required and will contain the quantity of free goods. The unit of measure is in SAC09.
SAC10 alone is used to indicate a specific quantity which could be a dollar amount, that is applicable to the service, promotion, allowance, or charge.
Code indicating method of handling for an allowance or charge
- 02
- Off Invoice
The allowance or charge amount will be reflected in the total transaction amount, e.g., Total Invoice Amount = Merchandise Price + Charges - Allowances.
- 06
- Charge to be Paid by Customer
When the order/item is a direct ship to the customer, or end consumer of the retailer, the allowance or charge amount is the responsibility of the customer or end consumer. If it is not a drop ship to the customer of the retailer, then the allowance or charge amount is the responsibility of the retailer. The exact method of adjudication
has been agreed to by the trading partners. The amount will not be reflected in the total invoice amount.
Summary
Total Monetary Value Summary
To specify the total invoice discounts and amounts
Examples:
Traditional Invoice: TDS422169
Credit Invoice: TDS-422169
Monetary amount
- TDS01 is the total amount of invoice (including charges, less allowances) before terms discount (if discount is applicable).
Walmart Note(s): Two decimal places are assumed. Example: 1526 will be interpreted as 15.26
Walmart Credit Invoice Note(s): To send an acceptable Walmart store credit invoice the TDS01 (Amount) must be negative to offset the amount of the original invoice.
422169
-422169
Tax Information
To specify tax information
Only send tax(s) that apply. If multiple taxes apply multiple TXI segments may be sent. (Example Quebec QST and Canadian GST are commonly both sent.) If an item is sold in an area were tax is typically applied as a non-taxable or tax exempt the TXI is still required and should have a zero in the TXI02 and the typical tax percent in the TXI03. This applies to both Canadian and US Puerto Rico tax types.
Examples:
Canadian:
TXIGS222.296**687649098RT0001
TXIPG*294.547.5SPQST*1098765743TQ0001
US Puerto Rico: TXIST*294.546
Code specifying the type of tax
- BE
- Harmonized Sales Tax
Canadian HST
- GS
- Goods and Services Tax
Canadian GST
- PG
- State or Provincial Tax on Goods
Canadian QST must be accompanied by a State or Province (SP) qualifier in the Tax Jurisdiction Code Qualifier (TXI04) element and a Québec sales tax (QST) qualifier in the Tax Jurisdiction Code (TXI05) element.
- SE
- State Excise Tax
US Hawaii State tax must be accompanied by a State or Province (SP) qualifier in the Tax Jurisdiction Code Qualifier (TXI04) element and a Hawaii (HI) qualifier in the Tax Jurisdiction Code (TXI05) element.
- ST
- State Sales Tax
US Puerto Rico Sales & Use tax must be accompanied by a State or Province (SP) qualifier in the Tax Jurisdiction Code Qualifier (TXI04) element and a Puerto Rico (PR) qualifier in the Tax Jurisdiction Code (TXI05) element.
Monetary amount
- TXI02 is the monetary amount of the tax.
VICS Note(s): The amount is sent with a decimal point only when needed, e.g., $15.95 would be sent as ‘‘15.95’’, and $29.00 would be sent as ‘‘29’’.
222.29
294.54
Percentage expressed as a decimal (e.g., 0.0 through 1.0 represents 0% through 100%)
- TXI03 is the tax percent expressed as a decimal.
VICS Note(s): The percent is sent with a decimal point only when needed, e.g., 10.5% is sent as ‘‘10.5’’, and 2% is sent as ‘‘2’’.
6
7.5
Code identifying the source of the data used in tax jurisdiction code
See Walmart Notes in Tax Type Code (TXI01) element.
- SP
- State or Province
Code identifying the taxing jurisdiction
See Walmart Notes in Tax Type Code (TXI01) element.
- HI
- Hawaii
Send 'HI' for 'US Hawaii State Excise tax'.
- PR
- Puerto Rico
Send 'PR' for 'US Puerto Rico Sales & Use tax'.
- QST
- Québec sales tax
Send 'QST' for Canadian QST.
Dollar basis to be used in the percent calculation of the allowance, charge or tax
Number assigned to a purchaser (buyer, orderer) by a taxing jurisdiction (state, county, etc.); often called a tax exemption number or certificate number
The Tax Identification Number (TXI09) is required by Walmart when the Tax Type Code contains one of the following qualifiers: Harmonized Sales Tax (BE), Goods and Services Tax (GS), or State or Provincial Tax on Goods (PG)
687649098RT0001
1098765743TQ0001
Carrier Details
To specify transportation details for the transaction
The CAD segment is required for backhaul shipments, but is recommended for all shipments.
Example: CADTRDWT*ROADWAYBM*123456789
Code specifying the method or type of transportation for the shipment
- T
- Best Way (Shippers Option)
Free-form description of the routing or requested routing for shipment, or the originating carrier's identity
Code qualifying the Reference Identification
- BM
- Bill of Lading Number
For all NON-backhaul shipments the 'BM' (Bill of Lading) qualifier should be sent. When sent the CAD08 should contains the shipment Bill of Lading number.
- CN
- Carrier's Reference Number (PRO/Invoice)
The 'CN' (Carrier's Reference Number) is required for all backhaul shipments. When sent the CAD08 should contain the Walmart Load Number.
Service, Promotion, Allowance, or Charge Information
To request or identify a service, promotion, allowance, or charge; to specify the amount or percentage for the service, promotion, allowance, or charge
There is one segment for each Allowance, Charge, Service, or Promotion being specified. If this segment appears in the summary area of the transaction set, the data applies to the entire transaction set. If this segment appears in the detail area of the transaction set, the data applies only to that line item. The data specified in the summary area is exclusive of the data specified in the detail area; it is not the sum of the data in the detail area, i.e., allowances or charges. SAC04 contains special service requirement codes and special processing codes. This code list is maintained in Section III of this guideline.
Example: SACAI41019394****02
Code which indicates an allowance or charge for the service specified
- If SAC01 is "A" or "C", then at least one of SAC05, SAC07, or SAC08 is required.
- A
- Allowance
- C
- Charge
- N
- No Allowance or Charge
- R
- Allowance Request
Code identifying the service, promotion, allowance, or charge
- A260
- Advertising Allowance
- B000
- Central Buy
- B270
- Collect Surcharge
Collection Allowance
- B720
- Cooperative Advertising/Merchandising Allowance (Performance)
- B950
- Damaged Merchandise
- C000
- Defective Allowance
- C220
- Development Charge
Network Allowance
- C310
- Discount
- C320
- Display Allowance
- C490
- Drum Deposit
- C530
- Duty Charge
- C540
- Early Buy Allowance
- C550
- Early Payment Allowance
- C580
- Emergency Service
Emergency Order Fee
- D170
- Free Goods
- D240
- Freight
Accepted as an allowance only; charges not accepted with this code.
- D500
- Handling
- E720
- New Distribution Allowance
- E740
- New Store Allowance
- E750
- New Store Discount
- F180
- Pallet
- F210
- Parish/County Sales Tax (only)
- F910
- Quantity Discount
- F920
- Quantity Surcharge
- F970
- Rebate
- G470
- Restocking Charge
Restocking Fee
- G970
- Small Order Charge
Order Quantity Fee
- H010
- Special Buy
- H420
- Storage in Transit
- H560
- Swell
- H750
- Tax - Sales Tax (State and Local)
Pre-collected/Prepaid Sales Tax
- H770
- Tax - State Tax
State Excise Tax
- H780
- Tax - Super Fund Excise Tax
Federal Superfund
- H910
- Temperature Protection
- H920
- Temporary Allowance
- I170
- Trade Discount
- I310
- Truckload Discount
- I410
- Unsaleable Merchandise Allowance
- I530
- Volume Discount
- I570
- Warehouse
Monetary amount
- SAC05 is the total amount for the service, promotion, allowance, or charge.
- If SAC05 is present with SAC07 or SAC08, then SAC05 takes precedence.
When SAC01 contains code A or code C, then this data element is
required. This will resolve any differences between the sender’s and receiver’s system calculations of amounts, i.e., rounding errors when allowances or charges are expressed in percentages or rates.
Code indicating on what basis allowance or charge percent is calculated
- 1
- Item List Cost
- 2
- Item Net Cost
- 3
- Discount/Gross
All allowances are off the gross price including cash discount.
- 4
- Discount/Net
All allowances are off the gross price. Cash discounts are off the net.
- 5
- Base Price per Unit
Line item discount.
- 7
- Base Price Amount Less Previous Discount
Declining balance method.
Percent given in decimal format (e.g., 0.0 through 100.0 represents 0% through 100%)
Rate expressed in the standard monetary denomination for the currency specified
- SAC08 is the allowance or charge rate per unit.
Code specifying the units in which a value is being expressed, or manner in which a measurement has been taken
- CA
- Case
- EA
- Each
Numeric value of quantity
- SAC10 and SAC11 is the quantity basis when the allowance or charge quantity is different from the purchase order or invoice quantity.
- SAC10 and SAC11 used together indicate a quantity range, which could be a dollar amount, that is applicable to service, promotion, allowance, or charge.
- In some business applications, it is necessary to advise the trading partner of the actual dollar amount that a particular allowance, charge, or promotion was based on to reduce ambiguity. This amount is commonly referred to as "Dollar Basis Amount". It is represented in the SAC segment in SAC10 using the qualifier "DO" - Dollars in SAC09.
When SAC02 contains code D170, this data element is required and
will contain the quantity of free goods. The unit of measure is in SAC09.
SAC10 alone is used to indicate a specific quantity which could be a dollar amount, that is applicable to the service, promotion, allowance, or charge.
Code indicating method of handling for an allowance or charge
- 02
- Off Invoice
The allowance or charge amount will be reflected in the total transaction amount, e.g., Total Invoice Amount = Merchandise Price + Charges - Allowances.
- 06
- Charge to be Paid by Customer
When the order/item is a direct ship to the customer, or end consumer of the retailer, the allowance or charge amount is the responsibility of the customer or end consumer. If it is not a drop ship to the customer of the retailer, then the allowance or charge amount is the responsibility of the retailer. The exact method of adjudication has been agreed to by the trading partners. The amount will not be reflected in the total invoice amount.
Invoice Shipment Summary
To specify summary details of total items shipped in terms of quantity, weight, and volume
Example: ISS1080EA100LB
Numeric value of units shipped in manufacturer's shipping units for a line item or transaction set
Walmart cannot accept an ISS01 (Number of Units Shipped) of One Hundred Thousand or more units. Please use an appropriate Unit of Measure or do not send the ISS if this causes an issue on your Walmart invoice.
Code specifying the units in which a value is being expressed, or manner in which a measurement has been taken
- CA
- Case
- EA
- Each
Numeric value of weight
Walmart cannot accept an ISS03 (Weight) of One Hundred Thousand or more units. Please use an appropriate Unit of Measure or do not send the ISS if this causes an issue on your Walmart invoice.
Transaction Totals
To transmit a hash total for a specific element in the transaction set
- 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.
Example: CTT*1
Transaction Set Trailer
To indicate the end of the transaction set and provide the count of the transmitted segments (including the beginning (ST) and ending (SE) segments)
Total number of segments included in a transaction set including ST and SE segments
Functional Group Trailer
To indicate the end of a functional group and to provide control information
Total number of transaction sets included in the functional group or interchange (transmission) group terminated by the trailer containing this data element
Interchange Control Trailer
To define the end of an interchange of zero or more functional groups and interchange-related control segments
Stedi is a registered trademark of Stedi, Inc. All names, logos, and brands of third parties listed on this page are trademarks of their respective owners (including “X12”, which is a trademark of X12 Incorporated). Stedi, Inc. and its products and services are not endorsed by, sponsored by, or affiliated with these third parties. Use of these names, logos, and brands is for identification purposes only, and does not imply any such endorsement, sponsorship, or affiliation.