Grocery Products Invoice 880

Documentation

Untitled 880 Grocery Products Invoice (Outbound) 
 
   
  Functional Group ID=GP
 
 
Introduction: 
 
This MARS Inc. Standard contains the format and establishes the data contents of the Outbound Grocery Products Invoice Transaction Set (880) for use within the context of an Electronic Data Interchange (EDI) environment. This transaction set is used to provide for customary and established grocery industry practice relative to billing details for finished goods in a retail or wholesale consumer market. This transaction set is used for standalone detail billing and cannot be used for statement billing or credit/debit adjustments. 
 
Notes: 
 
  * is used as a data delimiter to separate and maintain element position.
 
  MARS Inc. will send selected qualifiers that have been approved for use in this version of the EDI Standards.
                                                       
 
  Heading:
 
 
    Pos. Seg. Req. Loop   Notes and
  No. ID Name Des. Max.Use Repeat Comments
 
  Must Use   010   ST   Transaction Set Header   M   1
  Must Use   020   G01   Invoice Identification   M   1
      030   N9   Reference Identification   O   10
      050   G62   Date/Time   O   5
      070   G27   Carrier Detail   O   5
      080   G23   Terms of Sale   O   20   n1
      090   G25   F.O.B. Information   O   1
        LOOP ID - 0100   10    
  Must Use   100   N1   Name   M   1   n2    
      120   N3   Address Information   O   2    
      130   N4   Geographic Location   O   1    
 
        LOOP ID - 0200   100    
      140   G72   Allowance or Charge   O   1    
 
 
  Detail:
 
 
    Pos. Seg. Req. Loop   Notes and
  No. ID Name Des. Max.Use Repeat Comments
 
        LOOP ID - 0300   9999    
      010   G17   Item Detail - Invoice   O   1   n3    
      020   G69   Line Item Detail - Description   O   5    
        LOOP ID - 0310   100      
      070   G72   Allowance or Charge   O   1      
      080   G73   Allowance or Charge Description   O   10      
 
 
  Summary:
 
 
    Pos. Seg. Req. Loop   Notes and
  No. ID Name Des. Max.Use Repeat Comments
 
  Must Use   010   G31   Total Invoice Quantity   M   1
  Must Use   020   G33   Total Dollars Summary   M   1
  Must Use   030   SE   Transaction Set Trailer   M   1
 
Transaction Set Notes 
 
       
  1. 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.
  2. One occurrence of the N1 loop must be used to identify the party to whom the merchandise was shipped.
  3. Either the 0300 loop or the 0400 loop must be used, but both loops cannot be used within a single transaction set.
 

           
  Segment:   ST Transaction Set Header
  Position:   010
  Loop:
  Level:   Heading
  Usage:   Mandatory
  Max Use:   1
  Purpose: To indicate the start of a transaction set and to assign a control number
  Syntax Notes:
Semantic Notes:   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).
  Comments:
  Notes:   Example: 
 
ST*880*100010001 
 
The Transaction Set Identifer (ST01) is intended for use by the translation routines of the interchange partners to select the appropriate transaction set definition. 
 
880 is the code used to identify the Grocery Products Invoice Transaction Set.
 
Data Element Summary 
                               
      Ref.   Data
    Des.   Element   Name   Attributes
  >>   ST01   143   Transaction Set Identifier Code   M   ID 3/3
      Code uniquely identifying a Transaction Set
     
      880 X12.287 Grocery Products Invoice
 
  >>   ST02   329   Transaction Set Control Number   M   AN 4/9
      Identifying control number that must be unique within the transaction set functional group assigned by the originator for a transaction set
      ST Control Number must be the same as the Control Number (SE02) in the SE segment.

           
  Segment:   G01 Invoice Identification
  Position:   020
  Loop:
  Level:   Heading
  Usage:   Mandatory
  Max Use:   1
  Purpose:   To transmit identifying dates and numbers for this transaction set
  Syntax Notes:   1   If either G0106 or G0107 is present, then the other is required.
Semantic Notes:   1 G0101 is the invoice issue date.
    2 G0103 is the date assigned by the purchaser to the purchase order.
  Comments:
  Notes:   Example: 
 
G01*20010129*604132*20010122*W73327 
 
 
Data Element Summary 
                               
      Ref.   Data
    Des.   Element   Name   Attributes
  >>   G0101   373   Date   M   DT 8/8
      Date expressed as CCYYMMDD
  >>   G0102   76   Invoice Number   M   AN 1/22
      Identifying number assigned by issuer
      G0103   373   Date   O   DT 8/8
      Date expressed as CCYYMMDD
      G0104   324   Purchase Order Number   O   AN 1/22
      Identifying number for Purchase Order assigned by the orderer/purchaser

           
  Segment:   N9 Reference Identification
  Position:   030
  Loop:
  Level:   Heading
  Usage:   Optional
  Max Use:   10
  Purpose: To transmit identifying information as specified by the Reference Identification Qualifier
  Syntax Notes:   1   At least one of N902 or N903 is required.
      2   If N906 is present, then N905 is required.
      3   If either C04003 or C04004 is present, then the other is required.
      4   If either C04005 or C04006 is present, then the other is required.
Semantic Notes:   1 N906 reflects the time zone which the time reflects.
    2 N907 contains data relating to the value cited in N902.
  Comments:
  Notes:   Example: 
 
N9*BK*123456 
 
 
Data Element Summary 
                               
      Ref.   Data
    Des.   Element   Name   Attributes
  >>   N901   128   Reference Identification Qualifier   M   ID 2/3
      Code qualifying the Reference Identification
     
      BK Broker's Order Number
      BM   Bill of Lading Number
      BR   Broker or Sales Office Number
      IT   Internal Customer Number
 
      N902   127   Reference Identification   X   AN 1/30
      Reference information as defined for a particular Transaction Set or as specified by the Reference Identification Qualifier

           
  Segment:   G62 Date/Time
  Position:   050
  Loop:
  Level:   Heading
  Usage:   Optional
  Max Use:   5
  Purpose: To specify pertinent dates and times
  Syntax Notes:   1   At least one of G6201 or G6203 is required.
      2   If either G6201 or G6202 is present, then the other is required.
      3   If either G6203 or G6204 is present, then the other is required.
  Semantic Notes:
  Comments:
  Notes:   Example: 
 
G62*11*20011015 
 
 
Data Element Summary 
                               
      Ref.   Data
    Des.   Element   Name   Attributes
      G6201   432   Date Qualifier   X   ID 2/2
      Code specifying type of date
     
      11 Shipped on This Date
 
      G6202   373   Date   X   DT 8/8
      Date expressed as CCYYMMDD

           
  Segment:   G27 Carrier Detail
  Position:   070
  Loop:
  Level:   Heading
  Usage:   Optional
  Max Use:   5
  Purpose: To specify details of the transportation equipment and carrier routing details
  Syntax Notes:   1   At least one of G2704 or G2705 is required.
  Semantic Notes:
  Comments:
  Notes:   Example: 
 
G27*H****CUSTOMER PICKUP 
 
 
Data Element Summary 
                               
      Ref.   Data
    Des.   Element   Name   Attributes
  >>   G2701   91   Transportation Method/Type Code   M   ID 1/2
      Code specifying the method or type of transportation for the shipment
     
      H Customer Pickup
      M   Motor (Common Carrier)
 
      G2705   387   Routing   X   AN 1/35
      Free-form description of the routing or requested routing for shipment, or the originating carrier's identity

           
  Segment:   G23 Terms of Sale
  Position:   080
  Loop:
  Level:   Heading
  Usage:   Optional
  Max Use:   20
  Purpose: To specify the terms of sale
  Syntax Notes:   1   At least one of G2308 or G2309 is required.
  Semantic Notes:
Comments:   1 The G23 segment may be used for the detail or the total transaction set level. Refer to the transaction set assumptions for details on proper usage.
    2 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.
    3 G2310 is a memo figure requiring specific payment performance and therefore should not be negative.
    4 When elective terms are offered in a deferred or installment situation, G2316 (Installment Group Indicator - DE 713) must be used to properly group the terms within each installment.
  Notes:   Example: 
 
G23*03*3***2.5*20010110*5*20010204*30*10*978.10 
 
Data Element Summary 
                               
      Ref.   Data
    Des.   Element   Name   Attributes
  >>   G2301   336   Terms Type Code   M   ID 2/2
      Code identifying type of payment terms
     
      03 Fixed Date
 
  >>   G2302   333   Terms Basis Date Code   M   ID 1/2
      Code identifying the beginning of the terms period
     
      3 Invoice Date
 
      G2305   338   Terms Discount Percent   O   R 1/6
      Terms discount percentage, expressed as a percent, available to the purchaser if an invoice is paid on or before the Terms Discount Due Date
      G2306   370   Terms Discount Due Date   O   DT 8/8
      Date payment is due if discount is to be earned expressed in format CCYYMMDD
      G2307   351   Terms Discount Days Due   O   N0 1/3
      Number of days in the terms discount period by which payment is due if terms discount is earned
      G2308   446   Terms Net Due Date   X   DT 8/8
      Date when total invoice amount becomes due expressed in format CCYYMMDD
      G2309   386   Terms Net Days   X   N0 1/3
      Number of days until total invoice amount is due (discount not applicable)
      G2310   362   Terms Discount Amount   O   N2 1/10
      Total amount of terms discount

           
  Segment:   G25 F.O.B. Information
  Position:   090
  Loop:
  Level:   Heading
  Usage:   Optional
  Max Use:   1
  Purpose: To transmit information pertaining to method of freight payment and transfer of title
  Syntax Notes:
  Semantic Notes:
  Comments:
  Notes:   Example: 
 
G25*PP*04*ANY CITY USA 
 
 
Data Element Summary 
                               
      Ref.   Data
    Des.   Element   Name   Attributes
  >>   G2501   146   Shipment Method of Payment   M   ID 2/2
      Code identifying payment terms for transportation charges
     
      PB Customer Pick-up/Backhaul
      PP   Prepaid (by Seller)
      PU   Pickup
 
  >>   G2502   433   F.O.B. Point Code   M   ID 2/2
      Code identifying type of F.O.B. point
     
      04 Point of Origin
 
      G2503   434   F.O.B. Point   O   AN 1/30
      Descriptive name of F.O.B. point

           
  Segment:   N1 Name
  Position:   100
  Loop:   0100 Mandatory
  Level:   Heading
  Usage:   Mandatory
  Max Use:   1
  Purpose: To identify a party by type of organization, name, and code
  Syntax Notes:   1   At least one of N102 or N103 is required.
      2   If either N103 or N104 is present, then the other is required.
  Semantic Notes:
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.
  Notes:   Example: 
 
N1*BT*BILL TO NAME*9*1234567890000 
 
 
Data Element Summary 
                               
      Ref.   Data
    Des.   Element   Name   Attributes
  >>   N101   98   Entity Identifier Code   M   ID 2/3
      Code identifying an organizational entity, a physical location, property or an individual
     
      BO Broker or Sales Office
      BT   Bill-to-Party
      RE   Party to receive commercial invoice remittance
      ST   Ship To
      VN   Vendor
 
      N102   93   Name   X   AN 1/60
      Free-form name
      N103   66   Identification Code Qualifier   X   ID 1/2
      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
 
      N104   67   Identification Code   X   AN 2/80
      Code identifying a party or other code

           
  Segment:   N3 Address Information
  Position:   120
  Loop:   0100 Mandatory
  Level:   Heading
  Usage:   Optional
  Max Use:   2
  Purpose:   To specify the location of the named party
  Syntax Notes:
  Semantic Notes:
  Comments:
  Notes:   Example: 
 
N3*ANY STREET 
 
 
Data Element Summary 
                               
      Ref.   Data
    Des.   Element   Name   Attributes
  >>   N301   166   Address Information   M   AN 1/55
      Address information

           
  Segment:   N4 Geographic Location
  Position:   130
  Loop:   0100 Mandatory
  Level:   Heading
  Usage:   Optional
  Max Use:   1
  Purpose:   To specify the geographic place of the named party
  Syntax Notes:   1   If N406 is present, then N405 is required.
  Semantic Notes:
Comments:   1 A combination of either N401 through N404, or N405 and N406 may be adequate to specify a location.
    2 N402 is required only if city name (N401) is in the U.S. or Canada.
  Notes:   Example: 
 
N4*ANY CITY*NJ*07000 
 
Data Element Summary 
                               
      Ref.   Data
    Des.   Element   Name   Attributes
      N401   19   City Name   O   AN 2/30
      Free-form text for city name
      N402   156   State or Province Code   O   ID 2/2
      Code (Standard State/Province) as defined by appropriate government agency
      N403   116   Postal Code   O   ID 3/15
      Code defining international postal zone code excluding punctuation and blanks (zip code for United States)

           
  Segment:   G72 Allowance or Charge
  Position:   140
  Loop:   0200 Optional
  Level:   Heading
  Usage:   Optional
  Max Use:   1
  Purpose:   To specify allowances, charges, or services
  Syntax Notes:   1   At least one of G7203 G7205 G7208 or G7209 is required.
      2   Only one of G7205 G7208 or G7209 may be present.
      3   If either G7206 or G7207 is present, then the other is required.
      4   If either G7209 or G7210 is present, then the other is required.
      5   If G7211 is present, then G7203 is required.
Semantic Notes:   1 G7209 is the allowance or charge percent.
Comments:   1 The G73 segment is required when G7201 contains code "499" or "999"; however, the use of these codes is discouraged.
  Notes:   Example: 
 
G72*53*02******1068 
 
 
Data Element Summary 
                               
      Ref.   Data
    Des.   Element   Name   Attributes
  >>   G7201   340   Allowance or Charge Code   M   ID 1/3
      Code identifying the type of allowance or charge
     
      53 Freight Allowance
      54   Pick-up Allowance
      504   Freight
      515   Stopcharge
 
  >>   G7202   331   Allowance or Charge Method of Handling Code   M   ID 2/2
      Code indicating method of handling for an allowance or charge
     
      02 Off Invoice
 
      G7208   360   Allowance or Charge Total Amount   X   N2 1/15
      Total dollar amount for the allowance or charge

           
  Segment:   G17 Item Detail - Invoice
  Position:   010
  Loop:   0300 Optional
  Level:   Detail
  Usage:   Optional
  Max Use:   1
  Purpose: To specify the basic and most frequently used line item data for the invoice and related transactions
  Syntax Notes:   1   At least one of G1703 or G1714 is required.
      2   At least one of G1704 or G1705 is required.
      3   If either G1705 or G1706 is present, then the other is required.
      4   If either G1707 or G1708 is present, then the other is required.
      5   If either G1710 or G1711 is present, then the other is required.
Semantic Notes:   1 G1714 contains the cumulative monetary amount of unsaleable merchandise.
Comments:   1 G1702 qualifies G1701.
  Notes:   Example: 
 
G17*100*CA*10.25*002310001105*****A 
 
 
Data Element Summary 
                               
      Ref.   Data
    Des.   Element   Name   Attributes
  >>   G1701   358   Quantity Invoiced   M   R 1/10
      Number of units invoiced (supplier units)
  >>   G1702   355   Unit or Basis for Measurement Code   M   ID 2/2
      Code specifying the units in which a value is being expressed, or manner in which a measurement has been taken
     
      BA Bale
      BG   Bag
      CA   Case
      PL   Pallet/Unit Load
 
      G1703   237   Item List Cost   X   R 1/9
      Gross unit cost within the appropriate price bracket for a line item
      G1704   438   U.P.C. Case Code   X   AN 12/12
      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)
      G1709   417   Price Bracket Identifier   O   AN 1/3
      Identifier assigned by the vendor for a specific price bracket

           
  Segment:   G69 Line Item Detail - Description
  Position:   020
  Loop:   0300 Optional
  Level:   Detail
  Usage:   Optional
  Max Use:   5
  Purpose: To describe an item in free-form format
  Syntax Notes:
  Semantic Notes:
  Comments:
  Notes:   Example: 
 
G69*ITEM DESCRIPTION 
 
Data Element Summary 
                               
      Ref.   Data
    Des.   Element   Name   Attributes
  >>   G6901   369   Free-form Description   M   AN 1/45
      Free-form descriptive text

           
  Segment:   G72 Allowance or Charge
  Position:   070
  Loop:   0310 Optional
  Level:   Detail
  Usage:   Optional
  Max Use:   1
  Purpose: To specify allowances, charges, or services
  Syntax Notes:   1   At least one of G7203 G7205 G7208 or G7209 is required.
      2   Only one of G7205 G7208 or G7209 may be present.
      3   If either G7206 or G7207 is present, then the other is required.
      4   If either G7209 or G7210 is present, then the other is required.
      5   If G7211 is present, then G7203 is required.
Semantic Notes:   1 G7209 is the allowance or charge percent.
Comments:   1 The G73 segment is required when G7201 contains code "499" or "999"; however, the use of these codes is discouraged.
  Notes:   Example: 
 
G72*97*02*ABC900**1.25 
 
 
Data Element Summary 
                               
      Ref.   Data
    Des.   Element   Name   Attributes
  >>   G7201   340   Allowance or Charge Code   M   ID 1/3
      Code identifying the type of allowance or charge
     
      97 Cents Off
 
  >>   G7202   331   Allowance or Charge Method of Handling Code   M   ID 2/2
      Code indicating method of handling for an allowance or charge
     
      02 Off Invoice
 
      G7203   341   Allowance or Charge Number   X   AN 1/16
      The number assigned by a vendor referencing an allowance, promotion, deal or charge
      6 digit Promotion Code
      G7205   359   Allowance or Charge Rate   X   R 1/15
      Allowance or Charge Rate per Unit

           
  Segment:   G73 Allowance or Charge Description
  Position:   080
  Loop:   0310 Optional
  Level:   Detail
  Usage:   Optional
  Max Use:   10
  Purpose: To describe the allowance or charge in free-form format
  Syntax Notes:
  Semantic Notes:
Comments:   1 Use of the G73 segment requires concurrent use of a corresponding allowance/charge segment.
  Notes:   Example: 
 
G73*FREIGHT CHARGE 
 
 
Data Element Summary 
                               
      Ref.   Data
    Des.   Element   Name   Attributes
  >>   G7301   369   Free-form Description   M   AN 1/45
      Free-form descriptive text

           
  Segment:   G31 Total Invoice Quantity
  Position:   010
  Loop:
  Level:   Summary
  Usage:   Mandatory
  Max Use:   1
  Purpose: To specify summary details of total items shipped in terms of quantity, weight, and volume, and to specify payment method
  Syntax Notes:   1   If either G3103 or G3104 is present, then the other is required.
      2   If either G3105 or G3106 is present, then the other is required.
      3   If G3107 is present, then G3104 is required.
Semantic Notes:   1 G3110 should only be used to express the quantity of third party pallets
    2 G3111 is the gross weight of third party pallets in pounds.
Comments:   1 G3102 qualifies G3101.
  Notes:   Example: 
 
G31*52*CA*6969*LB****Q2 
 
 
Data Element Summary 
                               
      Ref.   Data
    Des.   Element   Name   Attributes
  >>   G3101   382   Number of Units Shipped   M   R 1/10
      Numeric value of units shipped in manufacturer's shipping units for a line item or transaction set
  >>   G3102   355   Unit or Basis for Measurement Code   M   ID 2/2
      Code specifying the units in which a value is being expressed, or manner in which a measurement has been taken
     
      CA Case
 
      G3103   81   Weight   X   R 1/10
      Numeric value of weight
      G3104   355   Unit or Basis for Measurement Code   X   ID 2/2
      Code specifying the units in which a value is being expressed, or manner in which a measurement has been taken
     
      LB Pound
 
      G3108   417   Price Bracket Identifier   O   AN 1/3
      Identifier assigned by the vendor for a specific price bracket

           
  Segment:   G33 Total Dollars Summary
  Position:   020
  Loop:
  Level:   Summary
  Usage:   Mandatory
  Max Use:   1
  Purpose: To specify the total invoice amount, including charges less allowances, before terms discount
  Syntax Notes:
  Semantic Notes:
  Comments:
  Notes:   Example: 
 
G33*482508 
 
 
Data Element Summary 
                               
      Ref.   Data
    Des.   Element   Name   Attributes
  >>   G3301   610   Amount   M   N2 1/15
      Monetary amount

           
  Segment:   SE Transaction Set Trailer
  Position:   030
  Loop:
  Level:   Summary
  Usage:   Mandatory
  Max Use:   1
  Purpose:   To indicate the end of the transaction set and provide the count of the transmitted segments (including the beginning (ST) and ending (SE) segments)
  Syntax Notes:
  Semantic Notes:
Comments:   1 SE is the last segment of each transaction set.
  Notes:   Example: 
 
SE*29*100010001 
 
SE is the last segment of each transaction set.
 
Data Element Summary 
                               
      Ref.   Data
    Des.   Element   Name   Attributes