ADC 360A Addendum

Attachment Page 1

Addendum TO ADC 360

Revised Catalog Data Support under Navy BRAC

to Add Catalog Transaction Purpose Codes and Drawing CAGE

1. ORIGINATOR:

a. Service/Agency: Defense Logistics Agency, DLA J3

2. FUNCTIONAL AREA: Primary: Supply/Logistics.

3. REFERENCES: 

 a. Functional Requirements for DLA’s implementation of Navy BRAC Retail Supply,

Storage, and Distribution (SS&D)/Inventory Management and Stock Positioning (IMSP) Spiral 2

b. Functional Requirements Pre-Design for DLA’s implementation of Marine Corps BRAC

Retail Storage and Distribution Interface (SDI).

c. Approved DLMS Supplement 832N, Catalog Data Support, on the DLMS internet site

eLibrary under DLMS Supplements to Federal Implementation Conventions - Transaction Sets,

available at: http://www.dla.mil/j-6/dlmso/elibrary/TransFormats/140_997.asp.

 d. DOD 4100.39-M, Federal Logistics Information System (FLIS) Procedures, available at:

http://www.dlis.dla.mil/flis_procedures.asp.

4. REQUESTED CHANGE: 

a. Description of Change: In support of Base Realignment and Closure (BRAC) Retail Supply, 

Storage And Distribution (SS&D)/Inventory Management and Stock Positioning (IMSP), the DLMS 

832N Catalog Data Support requires to updates data content and procedures beyond those contained in

ADC 360 to fully support Navy requirements. New requirements applicable to this addendum are 

highlighted in yellow. This addendum supplements, but does not replace the original ADC 360.

b. Background: As a result of the 2005 BRAC decision, retail supply, storage and distribution 

functions and associated infrastructure supporting the Navy industrial/maintenance sites will transfer to 

DLA. The intent of the directive is to significantly improve combat effectiveness while reducing costs by 

developing a world-class, cost-effective supply chain focused on readiness. In accordance with the 

signed Concept of Operations (CONOPS), DLA has agreed to provide SS&D/IMSP support to the Fleet 

Readiness Center (FRC) and Naval Shipyard (NSY) sites, including catalog data support which is 

supported via the DLMS 832N. As the result of integrated testing between DLA and the Navy, 

additional requirements have been identified to fully support catalog maintenance.

(1) Detailed Procedure: NSY sites will have the capability to create the 832N transactions 

identified as a query to determine if a National Stock Number (NSN) or Local Stock Number (LSN)

exists in EBS when there is no existing record on the internal table within the Naval Shipyard (NSY) 

application, Material Access Technology (MAT). The same transactions may be used to determine if a 

LSN or NSN exists for a specific CAGE and part number combination within EBS.

(a) If there is no material master in EBS for the inquired NSN, EBS will inquire the 

Federal Logistics Information System (FLIS) via the FLIS Portfolio Data Warehouse (FPDW).

1. If a match is found in FLIS, EBS will build a material master and return an 832N 
ADC 360A Addendum

Attachment Page 2

to MAT as an ‘ADD’ record

2. If a match is not found in FLIS, EBS will return an 832N identified as ‘no record 

exists’ and MAT will output the transaction for manual review.

3. If the connection between EBS and FPDW is down, EBS will initially respond 

with a ‘Response Delayed’ status to MAT and recycle the query until the FPDW connection resumes 

and then provide the appropriate status at that time.

4. If an unexpected error occurs that is not accounted for by existing response codes, 

a response of ‘Manual Action Required’ will be provided by EBS to MAT and the transaction will 

output for manual review.

(b) Navy Industrial Activity (IA) item drawing data will be accommodated by EBS via 

four new fields on the EBS material master and communicated to NSY/Fleet Readiness Center (FRC)

systems via the DLMS 832N. Three fields are already accommodated by ADC 360: Drawing Number, 

Detailed Drawing Piece Number, and Drawing Revision Number. An additional data element, 

Drawing Commercial and Government Entity (CAGE), will be added to the 832N to allow EBS to 

provide complete Navy IA drawing data.

(c) The ADC 360 data content table for the 832N, Catalog Data Support, is updated as 

shown. 

Item 

#

DS 832N Data 

Content

Usage Notes/

Cross-Reference to FLIS Data Record Number (DRN)2/

Definition for Unique or Non-Standard Data Elements

Field

Length

Applicability:

MCMC (M)

Navy IA (N)

1. Catalog 

Transaction

Purpose Code

Navy Only:

QU Site Query for Catalog Record (NSY)

MN Multiple NSNs for Part Number/CAGE

NN No record exists for NSN query (NSY)

NL No record exists for LSN query (NSY)

NP No NSN or LSN Found for Part Number/CAGE

(NSY)

RN NSN Replaced

RS Use NSN When Exhausted

SN NSN Substituted

NS NSN Superseded

DN NSN Discontinued; no Replacement

RD Response Delayed

AR Manual Action Required

2 New values 

applicable to 

Navy

2. Drawing 

CAGE

Identifies the CAGE associated with the part drawing

number

5 N
ADC 360A Addendum

Attachment Page 3

(d) The DLMS Supplement 832N, Catalog Data Support, is updated as shown:

# Location DS 832N, Catalog Data Support Reason

1. DLMS 

Introductory 

Notes

Add PDC 453 to DLMS Introductory Note 5:

- Approved Addendum to Approved Defense Logistics Management 

System (DLMS) Change (ADC) 360A Revised Catalog Data Support 

under Navy BRAC to Add Catalog Transaction Purpose Codes and 

Drawing Commercial and Government Entity (CAGE)

Identifies DLMS 

Changes included 

in the DS.

2. 2/LIN01/0100 Revise DLMS Note as shown to re-sequence code values and insert 

additional values.

Assigned Identification

DLMS Note: Must use to identify the purpose of the transaction. 

Cite the applicable Catalog Transaction Purpose Code:

AA: New Catalog Record Added.

AR: Manual Action Required

CC: Catalog Record Changed.

DD: Catalog Record Deleted.

DN: NSN Discontinued; no Replacement

MN: Multiple NSNs for Part Number/CAGE

NN: No record exists for NSN query

NL: No record exists for LSN query

NP: No NSN or LSN Found for Part Number/CAGE

NS: NSN Superseded

QU: Site Query for Catalog Record

RD: Response Delayed

RN: NSN Replaced

RS: Use NSN When Exhausted

SN: NSN Substituted

Adds new code 

values AR and RN.

Note: 

Administrative 

update to list code 

values in alphabetic 

sequence and to 

correct the name of 

the data element.

3. 2/REF01/0400 Add new qualifier ZM and associated note as shown:

ZM Manufacturer Number

DLMS Note: Use to identify the manufacturer’s CAGE Code associated 

with the drawing number.

Provides capability 

to include the 

manufacturer’s 

CAGE code when 

including part 

drawing 

information.

(e) ADC 360 DLMS manual procedures are updated to include the following new 

subparagraphs. 

C25.3.12 Unanticipated Situations Impacting Catalog Transaction Exchange

C25.3.12.1 If the connection between DLA EBS and Federal Logistics Information System 

(FLIS), via FLIS Portfolio Data Warehouse (FPDW) is down, EBS will initially respond with a 

‘Response Delayed’ status and recycle the query until the FPDW connection resumes and then provide 

the appropriate status at that time. This process is identified by a SS&D Catalog Data Support (832N) 

citing Catalog Transaction Purpose Code RD.
ADC 360A Addendum

Attachment Page 4

C25.3.12.2 If an unexpected error occurs that is not accounted for by existing response codes, a 

response of “Manual Action Required” will be provided by EBS and the transaction will output for 

manual review. This process is identified by a SS&D Catalog Data Support (832N) citing Catalog 

Transaction Purpose Code AR.

5. REASON FOR CHANGE: Allow EBS to comply with query processing time requirements while 

providing valid reason transaction purpose codes as a response. Additionally allow EBS to provide all 

Navy IA drawing fields via the 832N.

6. ADVANTAGES AND DISADVANTAGES: 

a. Advantages: Enterprise Business System (EBS) and Material Access Technology (MAT) will be 

able to reduce manual workload due to FPDW connection downtimes and provide more accurate query 

responses. Additionally, complete Navy IA drawing data can be exchanged.

b. Disadvantages: None identified.

7. ESTIMATED TIME LINE/IMPLEMENTATION TARGET: DLA and Navy planned 

implementation date is November 2011.

8. IMPACT: 

a. Publications: DLMS Manual update provided. Internal Service/Agency guidance as required.

b. DLA Transaction Services Mapping. Update DLA Transaction Services maps to allow new 

data to pass any applicable edits.

c. New Data Content. The DLMS 832N, Catalog Data Support, is a new transaction supporting 

both Navy and Marine Corps BRAC implementation. It introduces multiple new data elements and new 

code values to the DLMS dictionary. This addendum adds new code values AR and RD to the existing 

data element Catalog Transaction Purpose Code as shown above. Additionally, a new data element is 

established for the Drawing CAGE.