X12 880 OFX Grocery Products Invoice

X12 Release 4010

Delimiters

• ~ Segment
• * Element
• > Component

ISA Interchange Control Header

Required · Max use 1

ISA-01 · I01 · Authorization Information Qualifier · Required · Identifier (ID)

• 00: No Authorization Information Present (No Meaningful Information in I02)

ISA-02 · I02 · Authorization Information · Required · String (AN) · Min 10 Max 10

ISA-03 · I03 · Security Information Qualifier · Required · Identifier (ID)

• 00: No Security Information Present (No Meaningful Information in I04)

ISA-04 · I04 · Security Information · Required · String (AN) · Min 10 Max 10

ISA-05 · I05 · Interchange ID Qualifier · Required · Identifier (ID) · Min 2 Max 2

Codes

• 01: Duns (Dun & Bradstreet)
• 02: SCAC (Standard Carrier Alpha Code)
• 03: FMC (Federal Maritime Commission)
• 04: IATA (International Air Transport Association)
• 08: UCC EDI Communications ID (Comm ID)
• 09: X.121 (CCITT)
• 10: Department of Defense (DoD) Activity Address Code
• 11: DEA (Drug Enforcement Administration)
• 12: Phone (Telephone Companies)
• 13: UCS Code (The UCS Code is a Code Used for UCS Transmissions; it includes the Area Code and Telephone Number of a Modem; it Does Not Include Punctuation, Blanks or Access Code)
• 14: Duns Plus Suffix
• 15: Petroleum Accountants Society of Canada Company Code
• 16: Duns Number With 4-Character Suffix
• 17: American Bankers Association (ABA) Transit Routing Number (Including Check Digit, 9 Digit)
• 18: Association of American Railroads (AAR) Standard Distribution Code
• 19: EDI Council of Australia (EDICA) Communications ID Number (COMM ID)
• 20: Health Industry Number (HIN)
• 21: Integrated Postsecondary Education Data System, or (IPEDS)
• 22: Federal Interagency Commission on Education, or FICE
• 23: National Center for Education Statistics Common Core of Data 12-Digit Number for Pre-K-Grade 12 Institutes, or NCES
• 24: The College Board's Admission Testing Program 4-Digit Code of Postsecondary Institutes, or ATP
• 25: American College Testing Program 4-Digit Code of Postsecondary Institutions, or ACT
• 26: Statistics of Canada List of Postsecondary Institutions
• 27: Carrier Identification Number as assigned by Health Care Financing Administration (HCFA)
• 28: Fiscal Intermediary Identification Number as assigned by Health Care Financing Administration (HCFA)
• 29: Medicare Provider and Supplier Identification Number as assigned by Health Care Financing Administration (HCFA)
• 30: U.S. Federal Tax Identification Number
• 31: Jurisdiction Identification Number Plus 4 as assigned by the International Association of Industrial Accident Boards and Commissions (IAIABC)
• 32: U.S. Federal Employer Identification Number (FEIN)
• 33: National Association of Insurance Commissioners Company Code (NAIC)
• 34: Medicaid Provider and Supplier Identification Number as assigned by individual State Medicaid Agencies in conjunction with Health Care Financing Administration (HCFA)
• 35: Statistics Canada Canadian College Student Information System Institution Codes
• 36: Statistics Canada University Student Information System Institution Codes
• 37: Society of Property Information Compilers and Analysts
• AM: Association Mexicana del Codigo de Producto (AMECOP) Communication ID
• NR: National Retail Merchants Association (NRMA) - Assigned
• SN: Standard Address Number
• ZZ: Mutually Defined

ISA-06 · I06 · Interchange Sender ID · Required · String (AN) · Min 15 Max 15

ISA-07 · I05 · Interchange ID Qualifier · Required · Identifier (ID) · Min 2 Max 2

Codes

• 01: Duns (Dun & Bradstreet)
• 02: SCAC (Standard Carrier Alpha Code)
• 03: FMC (Federal Maritime Commission)
• 04: IATA (International Air Transport Association)
• 08: UCC EDI Communications ID (Comm ID)
• 09: X.121 (CCITT)
• 10: Department of Defense (DoD) Activity Address Code
• 11: DEA (Drug Enforcement Administration)
• 12: Phone (Telephone Companies)
• 13: UCS Code (The UCS Code is a Code Used for UCS Transmissions; it includes the Area Code and Telephone Number of a Modem; it Does Not Include Punctuation, Blanks or Access Code)
• 14: Duns Plus Suffix
• 15: Petroleum Accountants Society of Canada Company Code
• 16: Duns Number With 4-Character Suffix
• 17: American Bankers Association (ABA) Transit Routing Number (Including Check Digit, 9 Digit)
• 18: Association of American Railroads (AAR) Standard Distribution Code
• 19: EDI Council of Australia (EDICA) Communications ID Number (COMM ID)
• 20: Health Industry Number (HIN)
• 21: Integrated Postsecondary Education Data System, or (IPEDS)
• 22: Federal Interagency Commission on Education, or FICE
• 23: National Center for Education Statistics Common Core of Data 12-Digit Number for Pre-K-Grade 12 Institutes, or NCES
• 24: The College Board's Admission Testing Program 4-Digit Code of Postsecondary Institutes, or ATP
• 25: American College Testing Program 4-Digit Code of Postsecondary Institutions, or ACT
• 26: Statistics of Canada List of Postsecondary Institutions
• 27: Carrier Identification Number as assigned by Health Care Financing Administration (HCFA)
• 28: Fiscal Intermediary Identification Number as assigned by Health Care Financing Administration (HCFA)
• 29: Medicare Provider and Supplier Identification Number as assigned by Health Care Financing Administration (HCFA)
• 30: U.S. Federal Tax Identification Number
• 31: Jurisdiction Identification Number Plus 4 as assigned by the International Association of Industrial Accident Boards and Commissions (IAIABC)
• 32: U.S. Federal Employer Identification Number (FEIN)
• 33: National Association of Insurance Commissioners Company Code (NAIC)
• 34: Medicaid Provider and Supplier Identification Number as assigned by individual State Medicaid Agencies in conjunction with Health Care Financing Administration (HCFA)
• 35: Statistics Canada Canadian College Student Information System Institution Codes
• 36: Statistics Canada University Student Information System Institution Codes
• 37: Society of Property Information Compilers and Analysts
• AM: Association Mexicana del Codigo de Producto (AMECOP) Communication ID
• NR: National Retail Merchants Association (NRMA) - Assigned
• SN: Standard Address Number
• ZZ: Mutually Defined

ISA-08 · I07 · Interchange Receiver ID · Required · String (AN) · Min 15 Max 15

ISA-09 · I08 · Interchange Date · Required · Date (DT) · YYMMDD format

ISA-10 · I09 · Interchange Time · Required · Time (TM) · HHMM format

ISA-11 · I10 · Interchange Control Standards Identifier · Required · Identifier (ID)

• U: U.S. EDI Community of ASC X12, TDCC, and UCS

ISA-12 · I11 · Interchange Control Version Number · Required · Identifier (ID)

• 00401: Draft Standards for Trial Use Approved for Publication by ASC X12 Procedures Review Board through October 1997

ISA-13 · I12 · Interchange Control Number · Required · Numeric (N0) · Min 9 Max 9

ISA-14 · I13 · Acknowledgment Requested · Required · Identifier (ID) · Min 1 Max 1

• 0: No Acknowledgment Requested
• 1: Interchange Acknowledgment Requested

ISA-15 · I14 · Usage Indicator · Required · Identifier (ID) · Min 1 Max 1

• I: Information
• P: Production Data
• T: Test Data

ISA-16 · I15 · Component Element Separator · Required · String (AN) · Min 1 Max 1

• >: Component Element Separator

GS Functional Group Header

Required · Max use 1

GS-01 · 479 · Functional Identifier Code · Required · Identifier (ID)

• GP: Grocery Products Invoice (880)

GS-02 · 142 · Application Sender's Code · Required · String (AN) · Min 2 Max 15

GS-03 · 124 · Application Receiver's Code · Required · String (AN) · Min 2 Max 15

GS-04 · 373 · Date · Required · Date (DT) · CCYYMMDD format

GS-05 · 337 · Time · Required · Time (TM) · HHMM, HHMMSS, HHMMSSD, or HHMMSSDD format

GS-06 · 28 · Group Control Number · Required · Numeric (N0) · Min 1 Max 9

GS-07 · 455 · Responsible Agency Code · Required · Identifier (ID) · Min 1 Max 2

• T: Transportation Data Coordinating Committee (TDCC)
• X: Accredited Standards Committee X12

GS-08 · 480 · Version / Release / Industry Identifier Code · Required · String (AN)

• 004010: Draft Standards Approved for Publication by ASC X12 Procedures Review Board through October 1997

Heading

010 Heading > ST

ST Transaction Set Header

Required · Max use 1

ST-01 · 143 · Transaction Set Identifier Code · Required · Identifier (ID)

• 880: Grocery Products Invoice

ST-02 · 329 · Transaction Set Control Number · Required · Numeric (N) · Min 4 Max 9

020 Heading > G01

G01 Invoice Identification

Required · Max use 1

G01-01 · 373 · Date · Required · Date (DT) · CCYYMMDD format

G01-02 · 76 · Invoice Number · Required · String (AN) · Min 1 Max 22

G01-03 · 373 · Date · Required · Date (DT) · CCYYMMDD format

G01-04 · 324 · Purchase Order Number · Required · String (AN) · Min 1 Max 22

G01-05 · 424 · Vendor Order Number · Optional · String (AN) · Min 1 Max 22

070 Heading > G27

G27 Carrier Detail

Optional · Max use 5

At least one of Standard Carrier Alpha Code (G27-04) or Routing (G27-05) is required

G27-01 · 91 · Transportation Method/Type Code · Required · Identifier (ID)

• H: Customer Pickup
• M: Motor (Common Carrier)

G27-02 · 206 · Equipment Initial · Optional · String (AN) · Min 1 Max 4

G27-03 · 207 · Equipment Number · Optional · String (AN) · Min 1 Max 10

G27-04 · 140 · Standard Carrier Alpha Code · Optional · Identifier (ID) · Min 2 Max 4

G27-05 · 387 · Routing · Optional · String (AN) · Min 1 Max 35

G27-06 · 368 · Shipment/Order Status Code · Optional · Identifier (ID) · Min 2 Max 2

0100 Loop Required Max >1

100 Heading > 0100 Loop > N1

N1 Name

Required · Max use 1

At least one of Name (N1-02) or Identification Code Qualifier (N1-03) is required

If either Identification Code Qualifier (N1-03) or Identification Code (N1-04) is present, then the other is required

N1-01 · 98 · Entity Identifier Code · Required · Identifier (ID)

• BT: Bill-to-Party
• RE: Party to receive commercial invoice remittance
• SH: Shipper
• ST: Ship To

N1-02 · 93 · Name · Optional · String (AN) · Min 1 Max 60

N1-03 · 66 · Identification Code Qualifier · Optional · Identifier (ID)

• 9: D-U-N-S+4, D-U-N-S Number with Four Character Suffix

N1-04 · 67 · Identification Code · Optional · String (AN) · Min 2 Max 80

0200 Loop Optional Max >1

140 Heading > 0200 Loop > G72

G72 Allowance or Charge

Required · Max use 1

If either Allowance or Charge Quantity (G72-06) or Unit or Basis for Measurement Code (G72-07) is present, then the other is required

If Option Number (G72-11) is present, then Allowance or Charge Number (G72-03) is required

G72-01 · 340 · Allowance or Charge Code · Required · Identifier (ID) · Min 1 Max 3

G72-02 · 331 · Allowance or Charge Method of Handling Code · Required · Identifier (ID) · Min 2 Max 2

G72-03 · 341 · Allowance or Charge Number · Optional · String (AN) · Min 1 Max 16

G72-04 · 769 · Exception Number · Optional · String (AN) · Min 1 Max 16

G72-05 · 359 · Allowance or Charge Rate · Optional · Decimal number (R) · Min 1 Max 15

G72-06 · 339 · Allowance or Charge Quantity · Optional · Decimal number (R) · Min 1 Max 10

G72-07 · 355 · Unit or Basis for Measurement Code · Optional · Identifier (ID) · Min 2 Max 2

G72-08 · 360 · Allowance or Charge Total Amount · Optional · Numeric (N2) · Min 1 Max 15

G72-11 · 770 · Option Number · Optional · String (AN) · Min 1 Max 20

Detail

0300 Loop Required Max >1

010 Detail > 0300 Loop > G17

G17 Item Detail - Invoice

Required · Max use 1

If either Product/Service ID Qualifier (G17-05) or Product/Service ID (G17-06) is present, then the other is required

If either Product/Service ID Qualifier (G17-07) or Product/Service ID (G17-08) is present, then the other is required

If either Number of Units Shipped (G17-10) or Unit or Basis for Measurement Code (G17-11) is present, then the other is required

G17-01 · 358 · Quantity Invoiced · Required · Decimal number (R) · Min 1 Max 10

G17-02 · 355 · Unit or Basis for Measurement Code · Required · Identifier (ID)

• CA: Case
• EA: Each
• LB: Pound
• UN: Unit

G17-03 · 237 · Item List Cost · Required · Decimal number (R) · Min 1 Max 9

G17-04 · 438 · U.P.C. Case Code · Required · String (AN) · Min 12 Max 12

G17-05 · 235 · Product/Service ID Qualifier · Optional · Identifier (ID)

• IN: Buyer's Item Number
• SK: Stock Keeping Unit (SKU)
• U2: U.P.C. Shipping Container Code (1-2-5-5)
• UA: U.P.C./EAN Case Code (2-5-5)
• UD: U.P.C./EAN Consumer Package Code (2-5-5)
• UK: U.P.C./EAN Shipping Container Code (1-2-5-5-1)

G17-06 · 234 · Product/Service ID · Optional · String (AN) · Min 1 Max 48

G17-07 · 235 · Product/Service ID Qualifier · Optional · Identifier (ID)

• UD: U.P.C./EAN Consumer Package Code (2-5-5)

G17-08 · 234 · Product/Service ID · Optional · String (AN) · Min 1 Max 48

G17-09 · 417 · Price Bracket Identifier · Optional · String (AN) · Min 1 Max 3

G17-10 · 382 · Number of Units Shipped · Optional · Decimal number (R) · Min 1 Max 10

G17-11 · 355 · Unit or Basis for Measurement Code · Optional · Identifier (ID) · Min 2 Max 2

020 Detail > 0300 Loop > G69

G69 Line Item Detail - Description

Required · Max use 5

G69-01 · 369 · Free-form Description · Required · String (AN) · Min 1 Max 45

030 Detail > 0300 Loop > G19

G19 Line Item Detail - Quantity/Unit of Measure/Price Differences

Optional · Max use 10

If either Number of Units Shipped (G19-01) or Unit or Basis for Measurement Code (G19-02) is present, then the other is required

If either Quantity Difference (G19-03) or Shipment/Order Status Code (G19-04) is present, then the other is required

If either Product/Service ID Qualifier (G19-08) or Product/Service ID (G19-09) is present, then the other is required

G19-01 · 382 · Number of Units Shipped · Optional · Decimal number (R) · Min 1 Max 10

G19-02 · 355 · Unit or Basis for Measurement Code · Optional · Identifier (ID) · Min 2 Max 2

G19-03 · 383 · Quantity Difference · Optional · Decimal number (R) · Min 1 Max 9

G19-04 · 368 · Shipment/Order Status Code · Optional · Identifier (ID) · Min 2 Max 2

G19-05 · 381 · Price Reason Code · Optional · Identifier (ID) · Min 1 Max 1

G19-06 · 445 · Terms Exception Code · Optional · Identifier (ID) · Min 2 Max 2

G19-07 · 438 · U.P.C. Case Code · Optional · String (AN) · Min 12 Max 12

G19-08 · 235 · Product/Service ID Qualifier · Optional · Identifier (ID)

• U2: U.P.C. Shipping Container Code (1-2-5-5)
• UK: U.P.C./EAN Shipping Container Code (1-2-5-5-1)

G19-09 · 234 · Product/Service ID · Optional · String (AN) · Min 1 Max 48

040 Detail > 0300 Loop > G20

G20 Item Packing Detail

Optional · Max use 1

If either Size (G20-02) or Unit or Basis for Measurement Code (G20-03) is present, then the other is required

If either Weight (G20-04) or Unit or Basis for Measurement Code (G20-05) is present, then the other is required

If either Volume (G20-06) or Unit or Basis for Measurement Code (G20-07) is present, then the other is required

G20-01 · 356 · Pack · Optional · Numeric (N0) · Min 1 Max 6

G20-02 · 357 · Size · Optional · Decimal number (R) · Min 1 Max 8

G20-03 · 355 · Unit or Basis for Measurement Code · Optional · Identifier (ID) · Min 2 Max 2

G20-04 · 81 · Weight · Optional · Decimal number (R) · Min 1 Max 10

G20-05 · 355 · Unit or Basis for Measurement Code · Optional · Identifier (ID) · Min 2 Max 2

G20-06 · 183 · Volume · Optional · Decimal number (R) · Min 1 Max 8

G20-07 · 355 · Unit or Basis for Measurement Code · Optional · Identifier (ID) · Min 2 Max 2

G20-08 · 397 · Color · Optional · String (AN) · Min 1 Max 10

0310 Loop Optional Max >1

070 Detail > 0300 Loop > 0310 Loop > G72

G72 Allowance or Charge

Required · Max use 1

If either Allowance or Charge Quantity (G72-06) or Unit or Basis for Measurement Code (G72-07) is present, then the other is required

If Option Number (G72-11) is present, then Allowance or Charge Number (G72-03) is required

G72-01 · 340 · Allowance or Charge Code · Required · Identifier (ID) · Min 1 Max 3

G72-02 · 331 · Allowance or Charge Method of Handling Code · Required · Identifier (ID) · Min 2 Max 2

G72-03 · 341 · Allowance or Charge Number · Optional · String (AN) · Min 1 Max 16

G72-04 · 769 · Exception Number · Optional · String (AN) · Min 1 Max 16

G72-05 · 359 · Allowance or Charge Rate · Optional · Decimal number (R) · Min 1 Max 15

G72-06 · 339 · Allowance or Charge Quantity · Optional · Decimal number (R) · Min 1 Max 10

G72-07 · 355 · Unit or Basis for Measurement Code · Optional · Identifier (ID) · Min 2 Max 2

G72-08 · 360 · Allowance or Charge Total Amount · Optional · Numeric (N2) · Min 1 Max 15

G72-11 · 770 · Option Number · Optional · String (AN) · Min 1 Max 20

Summary

010 Summary > G31

G31 Total Invoice Quantity

Required · Max use 1

If either Weight (G31-03) or Unit or Basis for Measurement Code (G31-04) is present, then the other is required

If either Volume (G31-05) or Unit or Basis for Measurement Code (G31-06) is present, then the other is required

If Order Sizing Factor (G31-07) is present, then Unit or Basis for Measurement Code (G31-04) is required

G31-01 · 382 · Number of Units Shipped · Required · Decimal number (R) · Min 1 Max 10

G31-02 · 355 · Unit or Basis for Measurement Code · Required · Identifier (ID)

• CA: Case

G31-03 · 81 · Weight · Optional · Decimal number (R) · Min 1 Max 10

G31-04 · 355 · Unit or Basis for Measurement Code · Optional · Identifier (ID) · Min 2 Max 2

G31-05 · 183 · Volume · Optional · Decimal number (R) · Min 1 Max 8

G31-06 · 355 · Unit or Basis for Measurement Code · Optional · Identifier (ID) · Min 2 Max 2

G31-07 · 398 · Order Sizing Factor · Optional · Decimal number (R) · Min 1 Max 10

G31-08 · 417 · Price Bracket Identifier · Optional · String (AN) · Min 1 Max 3

G31-09 · 107 · Payment Method Code · Optional · Identifier (ID) · Min 1 Max 2

020 Summary > G33

G33 Total Dollars Summary

Required · Max use 1

G33-01 · 610 · Amount · Required · Numeric (N2) · Min 1 Max 15

030 Summary > SE

SE Transaction Set Trailer

Required · Max use 1

SE-01 · 96 · Number of Included Segments · Required · Numeric (N0) · Min 1 Max 10

SE-02 · 329 · Transaction Set Control Number · Required · Numeric (N) · Min 4 Max 9

GE Functional Group Trailer

Required · Max use 1

GE-01 · 97 · Number of Transaction Sets Included · Required · Numeric (N0) · Min 1 Max 6

GE-02 · 28 · Group Control Number · Required · Numeric (N0) · Min 1 Max 9

IEA Interchange Control Trailer

Required · Max use 1

IEA-01 · I16 · Number of Included Functional Groups · Required · Numeric (N0) · Min 1 Max 5

IEA-02 · I12 · Interchange Control Number · Required · Numeric (N0) · Min 9 Max 9