X12 894 Delivery/Return Base Record
This X12 Transaction Set contains the format and establishes the data contents of the Delivery/Return Base Record Transaction Set (894) for use within the context of an Electronic Data Interchange (EDI) environment. The transaction set can be used to enable a Direct Store Delivery (DSD) vendor to communicate the details of a DSD delivery and is to be used during the check-in procedure.
- ~ 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
- DX
- Direct Exchange Delivery and Return Information (894, 895)
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).
- 894
- Delivery/Return Base Record
Identifying control number that must be unique within the transaction set functional group assigned by the originator for a transaction set
Delivery/Return Base Record Identifier
To transmit identifying numbers, dates, and other basic data relating to the transaction set
Code indicating whether amount is a credit or debit
- When G8201 equals "D" (debit), information in this segment is for a delivery.
When G8201 equals "C" (credit), information in this segment is for a return.
- C
- Credit
- D
- Debit
Identifying number assigned by the supplier to the transaction
Invoice # (debit) Credit Memo # (credit).
Identifying number assigned by Dun & Bradstreet (Data Universal Numbering System)
- G8203 is the receiver's DUNS number.
Identifying nine digit number assigned by Dun & Bradstreet for the recipient Kroger division. Some Kroger divisions' D&B numbers begin with a 0 which must be included in this field. Every digit is significant.
- 006942882
- 615 Dillons
- 007908809
- 701 Fred Meyer
- 021732409
- 024 Kroger Mid-South, 025 Kroger Delta, 026 Kroger Nashville
- 027464700
- 705 QFC
- 031971594
- 620/625 King Soopers/City Market
- 035902444
- 660 Fry's
- 038176921
- 703/704/708 - Ralph's/Food 4 Less
- 043700194
- 706 Smith's
- 078226081
- 011 Kroger Atlanta
- 096509112
- 014 Kroger Cincinnati
- 099391542
- 034/035 Kroger Southwest
- 108473851
- 021 Kroger Central
- 119079788
- 029 Kroger Mid-Atlantic
- 146522628
- 016 Kroger Columbus, 018 Kroger Michigan
Number assigned by the customer that when combined with receiver Duns number uniquely identifies the receiving location
Number assigned by Kroger that when combined with Receiver's DUNS Number (G8203) uniquely identifies the receiving location (store). Format is "DDDSSS" where DDD = Division Number and SSS = Store Number. For store numbers less than 100, insert leading zero(s).
Example Data: '011002' for 011 Atlanta store #002
Division Code List:
011 Kroger Atlanta
014 Kroger Cincinnati
016 Kroger Columbus
018 Kroger Michigan
021 Kroger Central (a.k.a. Indianapolis)
024 Kroger Mid-South (a.k.a. Louisville)
025 Kroger Delta (a.k.a. Memphis)
026 Kroger Nashville
029 Kroger Mid-Atlantic (a.k.a. Roanoke)
034 Kroger Southwest (a.k.a. Houston)
035 Kroger Southwest (a.k.a. Dallas)
615 Dillons
620 King Soopers
620 City Market
660 Fry's
701 Fred Meyer
703 Ralphs
704 Food 4 Less West
705 QFC
706 Smith's
708 Food 4 Less Midwest (a.k.a. Chicago)
Identifying number assigned by Dun & Bradstreet (Data Universal Numbering System)
- G8205 is the supplier's DUNS number.
Suppliers Duns# must be set up on Kroger’s VNDS system. Separate Duns number must be given for each set of terms a vendor offers to Kroger.
Number assigned by supplier that provides uniqueness when combined with sender Duns number
Actual or intended date of physical delivery or return expressed in format CCYYMMDD where CC represents the first two digits of the calendar year
Physical Delivery or return date of product (at the Store).
Date which is meaningful for both supplier and distributor for various mutually defined purposes (i.e., date of product ownership transfer) expressed in format CCYYMMDD where CC represents the first two digits of the calendar year
Identifying number for Purchase Order assigned by the orderer/purchaser
Date assigned by the purchaser to Purchase Order expressed in format CCYYMMDD where CC represents the first two digits of the calendar year
Detail
The loop ID number given on the transaction set diagram is the value for this data element in segments LS and LE
Line Item Detail/Direct Store Delivery
To specify the basic, and most frequently used line item data for the delivery record transaction
Direct Store Delivery sequential number of the line item detail or a new line item detail
Sequential number unique for each line item in the 894.
Code specifying the units in which a value is being expressed, or manner in which a measurement has been taken
- G8303 qualifies G8302.
Code (Universal Product Code - U.P.C.) identifying the retail shelf unit; consists of 2 high order digits identifying the system (U.S. Grocery = 00, 06 or 07, U.S. Drug = 03); the next ten digits are manufacturer ID: 5, Item ID: 5
It needs to be sent in 2-5-5 format.
Gross unit cost within the appropriate price bracket for a line item
Gross unit cost of a line item.
The number of inner containers, or number of eaches if there are no inner containers, per outer container
Number of inner packs items per pack unit.
The cash register description of an item
Vendor’s description of the item.
Code specifying pre-pricing option selected
- If G2201 equals "A", then G2202 and G2203 are required.
- If G2201 equals "Y", then G2202 is required.
- If G2201 equals "Z" or G2201 equals "N", then neither G2202 nor G2203 are required.
Not used by Kroger.
The consumer package price or retail unit price associated with the product applicable on or after an effective price date
Manufacturer’s suggested retail price
Quantity of units for a given price, e.g., 3 for $10.00
Allowance or Charge
To specify allowances, charges, or services
Code indicating method of handling for an allowance or charge
All values are interpreted as allowances except “06” charge and “15” information only – not used in calculating total net.
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
Terms of Sale
To specify the terms of sale
Used for verification during pilot only. Terms used by production processing are defined on Kroger’s (VNDS) system
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
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.
Summary
Allowance or Charge
To specify allowances, charges, or services
Code identifying the type of allowance or charge
All valid standard codes are used.
Code indicating method of handling for an allowance or charge
All valid standard codes are used.
All values are interpreted as allowance except”06” charge and “15” information only – not used in calculating net.
Quantity basis when allowance or charge quantity is different from the purchase order or invoice quantity
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
Terms of Sale
To specify the terms of sale
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.
All valid standard codes are used.
Code identifying the beginning of the terms period
All valid standard codes are used.
Date from which payment terms are calculated expressed in format CCYYMMDD where CC represents the first two digits of the calendar year
Terms discount percentage, expressed as a percent, available to the purchaser if an invoice is paid on or before the Terms Discount Due Date
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
Deferred or installment portion of the total invoice (including charges, less allowances) before terms discount (if discount is applicable)
The installment group indicator is a 2-digit serial number beginning with 01 (i.e., 01, 02, 03 or 04); it is used to group "elective" terms types in an installment payment situation; the same indicator must be used for all segments in the same installment
- 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.
Delivery/Return Record of Totals
To specify summary details of total items in terms of quantity or amount
Amount of invoice (including charges, less allowances) before terms discount (if discount is applicable)
Must match the system’s calculation of detail a vendor sent +/- allowance or charge.
Electronic identity. Calculation algorithm obtained from the Uniform Code Council
Record Integrity Check
To provide a secure method of identifying authenticity of record content
Data element providing secure method for identifying authenticity of content.
Value calculated by using CRC 16 algorithm
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
LS*0100~
G83*1*2028.85*EA*040102569813****1.00**MAGAZINE KPC~
LE*0100~
G84*2028.85*202885~
G86*ANCO~
G85*OKAY~
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.