X12 880 Grocery Products Invoice
This X12 Transaction Set contains the format and establishes the data contents of the Grocery Products Invoice Transaction Set (880) for use within the context of an Electronic Data Interchange (EDI) environment. This transaction set can be used to provide for customary and established grocery industry practice relative to billing details for finished goods in a retail or wholesale consumer market. The transaction set can be used by the supplier or broker organization to request payment from a retailer or wholesaler organization. This transaction set is to be used for standalone detail billing and cannot be used for statement billing or credit/debit adjustments.
- ~ Segment
- * Element
- > Component
- ^ Repetition
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
- GP
- Grocery Products Invoice (880)
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
- 005010
- Standards Approved for Publication by ASC X12 Procedures Review Board through October 2003
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).
- 880
- Grocery Products Invoice
Identifying control number that must be unique within the transaction set functional group assigned by the originator for a transaction set
Invoice Identification
To transmit identifying dates and numbers for this transaction set
Date expressed as CCYYMMDD where CC represents the first two digits of the calendar year
- G0101 is the invoice issue date.
Date expressed as CCYYMMDD where CC represents the first two digits of the calendar year
- G0103 is the date assigned by the purchaser to the purchase order.
Identifying number for Purchase Order assigned by the orderer/purchaser
5 digit PO Number must be returned
Extended Reference Information
To transmit identifying information as specified by the Reference Identification Qualifier
Date/Time
To specify pertinent dates and times
Carrier Details
To specify transportation details for the transaction
Code specifying the method or type of transportation for the shipment
Free-form description of the routing or requested routing for shipment, or the originating carrier's identity
Terms of Sale
To specify the terms of sale
- The G23 segment can be used at the header level or detail level, but not both.
When it is used at the detail level, there must be at least one occurrence of the G23 segment for each iteration of the G17 segment.
Code identifying type of payment terms
- If G2301 equals "04" (deferred or installment) then either G2313 or G2314 is required and the data in the segment pertains only to the portion of the invoice described in G2313 or G2314. If G2301 equals "11" (elective) then G2304 is required. If G2301 is not equal to "05"' (discount not applicable) then (G2305 or G2310) and (G2306 or G2307) is required. If G2301 equals "ZZ" (other) then G2315 is required. Multiple use of this segment when G2301 equals "04" (deferred or installment) always implies an "AND" relationship. When G2301 equals "06" (mixed) or "11" (elective) an "OR" relationship is always implied.
Date from which payment terms are calculated expressed in format CCYYMMDD where CC represents the first two digits of the calendar year
Code identifying the method to be used for payment in conjunction with due date
Terms discount percentage, expressed as a percent, available to the purchaser if an invoice is paid on or before the Terms Discount Due Date
If G2305 list a discount% the G2310, 2311, and G2312 are required.
Date payment is due if discount is to be earned expressed in format CCYYMMDD where CC represents the first two digits of the calendar year
Number of days in the terms discount period by which payment is due if terms discount is earned
Date when total invoice amount becomes due expressed in format CCYYMMDD where CC represents the first two digits of the calendar year
Number of days until total invoice amount is due (discount not applicable)
Total amount of terms discount
- G2310 is a memo figure requiring specific payment performance and therefore should not be negative.
Amount of invoice due if paid by terms discount due date (total invoice or installment amount less cash discount)
Amount upon which the terms discount amount is calculated
F.O.B. Information
To transmit information pertaining to method of freight payment and transfer of title
Code identifying payment terms for transportation charges
- CC
- Collect
- PB
- Customer Pickup/Backhaul
- PP
- Prepaid (by Seller)
Code identifying type of F.O.B. point
- 02
- Destination
- 03
- Plant or Producing Location
- 04
- Point of Origin
Party Identification
To identify a party by type of organization, name, and code
- One occurrence of the N1 loop must be used to identify the party to whom the merchandise was shipped.
Code identifying an organizational entity, a physical location, property or an individual
- BT
- Bill-to-Party
- SF
- Ship From
- ST
- Ship To
Code designating the system/method of code structure used for Identification Code (67)
- 9
- D-U-N-S+4, D-U-N-S Number with Four Character Suffix
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.
Geographic Location
To specify the geographic place of the named party
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)
When sending N101 = ‘RI’; you must send N401, N402 and N403 When sending N101
Party Identification
To identify a party by type of organization, name, and code
- One occurrence of the N1 loop must be used to identify the party to whom the merchandise was shipped.
Code identifying an organizational entity, a physical location, property or an individual
- RI
- Remit To
Code designating the system/method of code structure used for Identification Code (67)
- 9
- D-U-N-S+4, D-U-N-S Number with Four Character Suffix
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.
Geographic Location
To specify the geographic place of the named party
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)
When sending N101 = ‘RI’; you must send N401, N402 and N403 When sending N101
Allowance or Charge
To specify allowances, charges, or services
Segment usage is optional but when sending adhere to the requirements. At header level for G72, G7208 is preferred, not G7205. Please include a minus sign in the element if the allowance is to be subtracted from the invoice.
Code identifying the type of allowance or charge
- 51
- Trade Discount
- 52
- Quantity Discount
- 54
- Pickup Allowance
- 80
- Combination Performance and Non-performance
- 90
- Performance Allowance
- 95
- Swell
- 97
- Cents Off
- 501
- Taxes
- 504
- Freight
- 526
- Beverage Tax
Code indicating method of handling for an allowance or charge
- 02
- Off Invoice
- 06
- Charge to be Paid by Customer
Quantity basis when allowance or charge quantity is different from the purchase order or invoice quantity
Code specifying the units in which a value is being expressed, or manner in which a measurement has been taken
Total dollar amount for the allowance or charge
Percent given in decimal format (e.g., 0.0 through 100.0 represents 0% through 100%)
- G7209 is the allowance or charge percent.
Dollar basis to be used in the percent calculation of the allowance, charge or tax
Detail
Item Detail - Invoice
To specify the basic and most frequently used line item data for the invoice and related transactions
- Either the 0300 loop or the 0400 loop must be used, but both loops cannot be used within a single transaction set.
G1710 should contain number of cases & G1711 = CA
Case Cost and Case U.P.C/GTIN are required for processing.
Random weight info:
G1701 should represent total weight to be invoiced.
G1702 should be sent as LB
G1710 REQUIRED when G1702 is other than CA, send # of cases
G1711 should be CA qualifier.
Code specifying the units in which a value is being expressed, or manner in which a measurement has been taken
- G1702 qualifies G1701.
Gross unit cost within the appropriate price bracket for a line item
Case Cost
Code (Universal Product Code - U.P.C.) including two high order digits identifying the "system" (U.S. Grocery = 00, 06 or 07; U.S. Drug = 03); using the U.S. Grocery system, the next ten digits are: Manufacturer (5) Case Code (5)
Only one of the G1704 or the G1705 & 06 should be sent.
Code identifying the type/source of the descriptive number used in Product/Service ID (234)
Only one of the G1704 or the G1705 & 06 should be sent.
- UK
- GTIN 14-digit Data Structure
Identifying number for a product or service
GTIN
Only one of the G1704 or the G1705 & 06 should be sent.
Code identifying the type/source of the descriptive number used in Product/Service ID (234)
Numeric value of units shipped in manufacturer's shipping units for a line item or transaction set
Code specifying the units in which a value is being expressed, or manner in which a measurement has been taken
- CA
- Case
Line Item Detail - Description
To describe an item in free-form format
Item Packing Detail
To specify packing details of the items shipped
The number of inner containers, or number of eaches if there are no inner containers, per outer container
Code specifying the units in which a value is being expressed, or manner in which a measurement has been taken
G2001 and G2002 are required if the information is not contained in the G69.
If G2002 is used, you must send the G2003.
Allowance or Charge
To specify allowances, charges, or services
G7205 is preferred. If G7208 is sent at G72 detail level, value will be determined by G7208 divided by G1701. However, G7205, G7206, G7207 or G7208 or G7209 and G7210 are required. Please include a minus sign in the element if the allowance is to be subtracted from the invoice.
Code identifying the type of allowance or charge
- 51
- Trade Discount
- 52
- Quantity Discount
- 54
- Pickup Allowance
- 80
- Combination Performance and Non-performance
- 90
- Performance Allowance
- 97
- Cents Off
- 501
- Taxes
- 504
- Freight
Code indicating method of handling for an allowance or charge
- 02
- Off Invoice
- 06
- Charge to be Paid by Customer
Allowance or Charge Rate per Unit
If an allowance, the rate should be negative (-)
Quantity basis when allowance or charge quantity is different from the purchase order or invoice quantity
Code specifying the units in which a value is being expressed, or manner in which a measurement has been taken
Total dollar amount for the allowance or charge
Percent given in decimal format (e.g., 0.0 through 100.0 represents 0% through 100%)
- G7209 is the allowance or charge percent.
Dollar basis to be used in the percent calculation of the allowance, charge or tax
Summary
Total Invoice Quantity
To specify summary details of total items shipped in terms of quantity, weight, and volume, and to specify payment method
Numeric value of units shipped in manufacturer's shipping units for a line item or transaction set
Code specifying the units in which a value is being expressed, or manner in which a measurement has been taken
- G3102 qualifies G3101.
- CA
- Case
Code specifying the units in which a value is being expressed, or manner in which a measurement has been taken
- LB
- Pound
- OZ
- Ounce - Av
Code specifying the units in which a value is being expressed, or manner in which a measurement has been taken
- CF
- Cubic Feet
Total Dollars Summary
To specify the total invoice amount, including charges less allowances, before terms discount
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
Identifying control number that must be unique within the transaction set functional group assigned by the originator for a transaction set
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
Assigned number originated and maintained by the sender
Interchange Control Trailer
To define the end of an interchange of zero or more functional groups and interchange-related control segments
SAMPLE with ALL ITEMS Converted to GTINs
N9*BM*123456~
G62*11*20050110~
CAD*****ROADWAY~
G23*05*3*20050110*02****20050131*21**1903914*1903914~
G25*PP*02*DEST~
N1*BT*KROGER*9*0079088090000~
N3*NASHVILLE - RASC*P.O. BOX 305103~
N4*NASHVILLE*TN*372305103~
N1*ST*FRED MEYER PUYALLUP WH*9*0079088091501~
N3*249 VALLEY AVE~
N4*PUYALLUP*WA*98972~
N1*RI*FOODS*9*1234567891234~
G17*52*CA*50.85**UK*10021000340799****10*CA~
G69*BTR QTR 1LB~
G17*120*LB*7.92**UK*00021000778699****22*CA~
G69*TRIM~
G17*24*LB*7.92**UK*20043000180629****15*CA~
G69*SC~
G31*1*CA*2*LB*3*CF~
G33*4~
SAMPLE with NO ITEMS Converted to GTINs
N9*BM*123456~
G62*11*20050110~
CAD*****ROADWAY~
G23*05*3*20050110*02****20050131*21**1903914*1903914~
G25*PP*02*DEST~
N1*BT*KROGER*9*0079088090000~
N3*NASHVILLE - RASC*P.O. BOX 305103~
N4*NASHVILLE*TN*372305103~
N1*ST*FRED MEYER PUYALLUP WH*9*0079088091501~
N3*249 VALLEY AVE~
N4*PUYALLUP*WA*98972~
N1*RI*FOODS*9*1234567891234~
G17*52*CA*50.85*002100034079******10*CA~
G69*BTR QTR 1LB~
G17*120*LB*7.92*002100077869******22*CA~
G69*TRIM~
G17*24*LB*7.92*004300018062******15*CA~
G69*SC~
G31*1*CA*2*LB*3*CF~
G33*4~
SAMPLE with SOME ITEMS Converted to GTINs
N9*BM*123456~
G62*11*20050110~ CAD*****ROADWAY~
G23*05*3*20050110*02****20050131*21**1903914*1903914~
G25*PP*02*DEST~
N1*BT*KROGER*9*0079088090000~
N3*NASHVILLE - RASC*P.O. BOX 305103~
N4*NASHVILLE*TN*372305103~
N1*ST*FRED MEYER PUYALLUP WH*9*0079088091501~
N3*249 VALLEY AVE~
N4*PUYALLUP*WA*98972~
N1*RI*FOODS*9*1234567891234~
G17*52*CA*50.85**UK*10021000340799****10*CA~
G69*BTR QTR 1LB~
G17*120*LB*7.92**UK*00021000778699****22*CA~
G69*TRIM~ G17*24*LB*7.92*004300018062******15*CA~
G69*SC~
G31*1*CA*2*LB*3*CF~
G33*4~
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.