ATTACHMENT 4 STORES EDI Implementation Guidelines.pdf

PDF 8 MB Posted

Attached to
Subsistence Prime Vendor - Europe Zone 4 (Afloat Customers)
Solicitation number
SPE300-26-R-0017
Issued by

About this file

Written by GovTribe AI ·

This document is an EDI (Electronic Data Interchange) Implementation Guidelines manual for the Subsistence Total Ordering and Receipt Electronic System (STORES) used by the Defense Logistics Agency (DLA) Troop Support to manage food and supply ordering and invoicing between DLA and vendor systems.

The guidelines establish technical specifications for three primary EDI transaction sets: the 832 Catalog (vendor to DLA) for submitting product catalogs with pricing, the 850 Purchase Order (customer to vendor) for placing orders, and the 810 Invoice (vendor to DLA) for billing. Vendors must support all three transaction types using EDI version 3040 and transmit through DLA Transaction Services. The 832 catalog requires mandatory fields including stock numbers, descriptions, prices, economic indicators, and unit measurements, with weekly updates submitted before noon EST on Fridays. The 850 purchase order accommodates multiple daily orders with delivery location specified by Department of Defense Activity Address Code (DoDAAC), including required elements such as line item numbers, quantities, units of measure, and vendor part numbers. The 810 invoice must include contract numbers, invoice dates, line item quantities, units of measurement, and pricing information. The document also includes specifications for 864 text messages for internal rations processing and 997 functional acknowledgements confirming transaction receipt. Vendors must complete EDI testing with designated DLA contacts prior to contract go-live, and catalog updates during production are normally sent weekly for changed items only. The guidelines note an upcoming migration from EDI X12 maps to version 4010, with vendor notification to follow.

View the file

Other files

File Type Posted
ATTACHMENT 1 Zone 4 Pricing Spreadsheet (Updated 7.28).xlsx XLSX spreadsheet
SPE30026R0017 - Amendment 0004.PDF PDF
SPE30026R0017 - Amendment 0003.PDF PDF
ATTACHMENT 1 Zone 4 Pricing Spreadsheet (Updated 7.24).xlsx XLSX spreadsheet
ATTACHMENT 2 Official DLA Troop Support OCONUS Subsistence Price Quote Sheet (Updated).pdf PDF
SPE30026R0017 Pre-Proposal Questions and Answers.pdf PDF
Conformed Statement of Work.pdf PDF
ATTACHMENT 1 Zone 4 Pricing Spreadsheet (Updated).xlsx XLSX spreadsheet
SPE30026R0017 - Amendment 0002.PDF PDF
SPE30026R0017 - Amendment 0001.pdf PDF
ATTACHMENT 3 DIBBS and DoD Safe Proposal Instructions.pdf PDF
ATTACHMENT 1 Zone 4 Pricing Spreadsheet.xlsx XLSX spreadsheet
ATTACHMENT 2 Official DLA Troop Support OCONUS Subsistence Price Quote Sheet.pdf PDF
Statement of Work Europe Zone 4.pdf PDF
ATTACHMENT 5 New Item Request Process and Vendor Item Initiation Process 2022.pdf PDF
SPE30026R0017-Europe Zone 4.PDF PDF
ATTACHMENT 6 US AFRICOM Foreign Vendor Information Sheet (FVIS).pdf PDF
Show all 17

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Subsistence 864 Inventory Reporting

Example of 864 Transaction and MSG Segment Layout

Data delimited with the pipe (|) symbol.

ST*864*000000001

BMG*00*INVENTORY REPORT

DTM*097*20110330*064640

N1*FR*COMPANY A*33*CAGEC

N1*TO**10*SC0500

MIT*001*INVENTORY REPORT

MSG*895001E098779|PV|123A|6|0|1|1|13.00|12.42|11.87|12.04|645|FT9455|1531413|080098099878 787|Y|343|R|156|TEST DESCRIPTION 890123456789012345|23.43|145|Y|A|CS|Y|61414187001121 MSG*894001E591135|PV|234B|2|108|324|17|10.50|9.87|8.88|9.01|78|FT9455|1481169|09800399333 667|Y|265|X|129|TEST DESCRIPTION 890123456789012345|263.87|4351|N|A|CS|N|64264441772555 MSG*894001E190210|PV|675C|151|50|0|22|12.75|12.34|11.99|12.10|193|FT9455|800078|009877668 844|N|110|X|98|TEST DESCRIPTION 890123456789012345|45.1|98325|N|I|CS|Y|621466552286 MSG*891501E297578|PV|189D|3|0|0|3|9.15|8.88|8.05|8.55|67|FT9455|820100|090069996057585058 58|Y|65|R|33 |TEST DESCRIPTION 890123456789012345|421.65|145|Y|A|CS|N|624472266451

SE*11*000000001

864 MSG Segment Format:

Column Name

Column Length DEFINITION VALID ENTRIES

1 NSN 13 National Stock Number

Government Stock Number

2 Item Category 3 Type Category Code

Either PV, GFM or

LMR

3 Distribution Fee Category

4 Vendor Internal Category

Vendor Internal Reference Number NTE 4 positions

4 Stock-On- Hand

10 Quantity of Item On-Hand

Numeric NTE 10 positions, No Commas

5 In-Transit 10 Quantity In- Transit

Numeric NTE 10 positions, No Commas

6 On-Order 10 Quantity On-Order Numeric NTE 10positions, No Commas

7 In-Demand 10 Quantity Demand Numeric NTE 10 positions, No Commas

8 Item Unit Price 7 Item Unit Price Numeric NTE 7 positions, No Commas

Column Name

Column Length DEFINITION VALID ENTRIES

9 Product Price 7 Product Price of Item

Numeric NTE 7 positions, No Commas.

Decimal explicit (must be sent)

10 Distributor Price

7 Distributor Unit Price of Item

Numeric NTE 7 positions, No Commas.

Decimal explicit (must be sent)

11 Premium Distributor Price

7 Premium Distributor Unit Price of Item

Numeric NTE 7 positions, No Commas.

Decimal explicit (must be sent)

12 Cases Filled 10 Number of Cases Filled this period

Numeric NTE 10 positions, No Commas

13 Inventory Location

6 Actual Location of Items (DODAAC)

Alpha/numeric data

14 Vendor Code 15 Vendor Internal Item Number

Alpha/numeric data NTE 15 positions

15 SKU Field 25 SKU Number Alpha/numeric data NTE 25 positions

16 MLL 1 Master Load List Number

Alpha/numeric data NTE 1 position; Y or N

17 Stock on Hold 10 Quantity on Hold Alpha/numeric data NTE 10 position

18 Hold Reason Code

1 Hold Reason R = recalled; X = expired

19 In Transfer 10 Quantity in Transfer

Alpha/numeric data NTE 10 position

20 Item Description

35 Item Descriptive Data

Alpha/numeric data NTE 35 positions

21 Cube 5 Item cubic size Numeric NTE 5 positions. No Commas.

Decimal explicit (must be sent)

22 Gross Weight 5 Item weight Numeric NTE 5 positions

23 Category 1 New Item Y = yes; N = no

Column Name

Column Length DEFINITION VALID ENTRIES

Category

24 Item Status 1 Status of item A = active; I = inactive

25 Unit of Measure

2 Item’s Unit of Measurement Code

CS = cases (always reported in cases)

26 Mandatory Status

1 Item’s Mandatory Status Code

Y = yes; N = no

27 Global Trade Item Number

14 Item’s Global Trade Item Number

Numeric data NTE 14 positions

Example Format of Output File

DTM02|N104|N102|MSG01|MSG02|MSG03|MSG04|MSG05|MSG06|MSG07|MSG08|MSG09|MS

G10|MSG11|MSG12|MSG13|MSG14|MSG15|MSG16|MSG16|MSG17|

MSG18|MSG19|MSG20|MSG21|MSG22|MSG23|MSG24|MSG25|MSG26|MSG27

Translated Output would look similar to this:

Output file data delimited with the pipe (|) symbol.

20110330| CAGEC| COMPANY A|895001E098779|PV|123A|6|0|1|1|13.00|12.42|11.87|12.04|645|

FT9455|1531413|080098099878787|Y|343|R|156|TEST DESCRIPTION

890123456789012345|23.43|145|Y|A|CS|Y|61414187001121

20110330| CAGEC| COMPANY A|894001E591135|PV|234B|2|108|324|17|10.50|9.87|8.88|9.01|78|

FT9455|1481169|09800399333667|Y|265|X|129|TEST DESCRIPTION

893456789012345|263.87|4351|N|A|CS|N|64264441772555

20110330| CAGEC| COMPANY

A|894001E190210|PV|675C|151|50|0|22|12.75|12.34|11.99|12.10|193|FT9455|800078|009877668844

|N|110|X|98|TEST DESCRIPTION 890123456789012345|45.1|98325|N|I|CS|Y|621466552286

20110330| CAGEC| COMPANY

A|891501E297578|PV|189D|3|0|0|3|9.15|8.88|8.05|8.55|67|FT9455|820100|09006999605758505858|

Y|65|R|33|TEST DESCRIPTION890123456789012345|421.65|145|Y|A|CS|N|624472266451

Document Changes:

Version Date Purpose

1.0 4/2011 Initial Document

2.0 7/7/2011 Addition of columns 15, 16, 17, 18, 19

2.1 7/8/2011 Addition of column 20

2.2 9/13/2011 Addition of columns 21, 22, 23, 24

2.3 11/2/2011 Clarification of column 18, Hold Reason Code

2.4 08/01/2012 Addition of columns 25, 26, 27

Attachment 4 STORES EDI Requirements.pdf
EDI

File details come from the government source that posted it. Updated .