Attachment 10a1 1-CICP Imp Guide v2_7-3 App_E.xlsx

Table of Contents

Revision History Appendix E Revision History

-832N Catalog Data to include changes from ADC 1227A, and the addition of default values, -Addition of 832N business rules tab, -Corrections to 846P Transaction Hist Request, -Split 832N Catalog Data into two tabs: Catalog Data_New for adding new items to the DPAS catalog and Catalog Data_Update for updating item indicative data associated with existing items in the DPAS catalog, -Split 527R into four tabs: Receipt (D4_), Receipt (D6_), Disposition Services Turn-In Receipt Acknowledgement (CJ), and Receipt Acknowledgment Advice (TH)

2.7.2 10-Jan-19 Updated:

-527R (D4_, D6_, CJ and TH tabs) to add N901/W8 and N902 for suffix code -945A (changed N1/N101 from Z4 to OW)

2.7.3 21-May-19 Updated:

-Added worksheet "Data Format" provides: Name, Description, Format, Length, Type and associated DLMS transactions.

Data Format

Authorization Number format:

o Positions 1-6 is the FQ series DoDAAC o Positions 7-14 is the YYYYMMDD o Positions 15-18 are numbers 001-9999 867I (Issue) --88 - Disposal Authority Code 947I (Inventory Adjustment --43 - Supporting Document Number Contract Number Number found on a legal agreement between two or more parties for the delivery of goods and/or services. Character 50 Allows:

A-Z, a-z, 0-9 and “ ”

Contract Nbr consists of 13 pos: pos 1-6 = DODAAC, pos 7-8 numeric, pos 9 alpha except "I" or "O" and pos 10-13 alphanumeric. 527R (Reciept D4/D6) 846D (LR-Transfer) 846S (LR-Stor Info Order Reply)

846R (LR-EOD/EOM

867I (Issue) 945A (Material Release) 947I (Inventory Adjustment) Document Number The document number is a nonduplicative number throughout the system. DLM 4000.25-1, April 29, 2016 Change 7, AP2.7 Appendix 2.7 Document number.

Character 14 Transactions that create document numbers will do so using the following formula: ICP DoDAAC + 4 digit Ordinal Date + 4 Digit Serial Number Document Number format:

o Position 1-6 is the DoDAAC of the activity initiating the document o Position 7-10 is the four digit ordinal date that the document was created on o Position 11-14 is the four digit sequence number starting with ‘0001’ and incremented for every additional document created for the same DoDAAC and ordinal date. 527R (Reciept D4/D6)

527R (MRA/TRA)

846D (LR-Transfer) 846S (LR-Stor Info Order Reply)

846R (LR-EOD/EOM

867I (Issue) 945A (Material Release) 947I (Inventory Adjustment) Stock Number The Stock Number for the materiel that is associated to the contract.

Additional Details:

Whether an NSN or a Mfr Part Nbr and Cage Cd, DPAS treats them as the same thing, a Stock Number. Like other systems, DPAS will treat those different types as “flavors” of a Stock Number. In the case of a Mfr Part Nbr and Cage Cd, the standard is to concatenate the Cage Cd with the Mfr Part Nbr

DPAS limitation to only allow lengths of 15 characters for the Stock Number. Character 15 Allows: A-Z, a-z, 0-9 and “ ” Must start with an alphanumeric character.

Format of Stock Number by Stock Item Code

NSN format is:

13 numeric positions.

First 4 positions must match FSC field and be a valid FSC.

Part Number format is:

up to 15 characters that comply with the basic rules outlined above.

MCN format is:

13 positions of alphanumeric characters.

First 4 positions must match FSC field and be a valid FSC.

Positions 5 and 6 must be a valid "NCB" (National Codification Bureau) code Position 7 must be alphabetic.

Position 8 and 9 must be numeric.

Position 10 - 13 either numeric or "XXXX" 527R (Reciept D4/D6)

527R (MRA/TRA)

832N (Catalog) 846D (LR-Transfer) 846S (LR-Stor Info Order Reply)

846R (LR-EOD/EOM

867I (Issue) 945A (Material Release) 947I (Inventory Adjustment)

527R Receipt D4_ 527R: Materiel Due-In & Receipt:

When the APSR receives the 527R Materiel Due-In and Receipt (Receipt) Transaction Set, it will add/subtract the Qty from inventory, thus increasing / decreasing the Available On hand Inventory. If it is unable to perform the update, it will generate a DLMS 824 Reject Advice notifying the CICP that it was not able to perform the action. Upon receipt of the DLMS 824 Reject Transaction from the APSR, the CICP is responsible for researching the problem with the original 527R Transaction Set, and resubmitting a revised 527R, if applicable. Use this transaction set for new acquisitions of materiel.

MG - Manufacturers Part Nbr

<Part Nbr>

Reference Data Format tab

527R Receipt D6_ 527R: Materiel Due-In & Receipt:

When the APSR receives the 527R Materiel Due-In and Receipt (Receipt) Transaction Set, it will add/subtract the Qty from inventory, thus increasing / decreasing the Available On hand Inventory. If it is unable to perform the update, it will generate a DLMS 824 Reject Advice notifying the CICP that it was not able to perform the action. Upon receipt of the DLMS 824 Reject Transaction from the APSR, the CICP is responsible for researching the problem with the original 527R Transaction Set, and resubmitting a revised 527R, if applicable. Use this transaction set for customer returns of materiel.

MG - Manufacturers Part Nbr

<Part Nbr>

DLM 4000.25-1, April 29, 2016 Change 7, AP2.7 Appendix 2.7 Document number.

(Conditional - if assets have GFM Contract Nbr)

527R Disp Serv Acknowledgement 527R Receipt Acknowledgement:

This 527R format is intended for formatting a Receipt Confirmation for Materiel turned into DLA Disposition Services to the Air Force APSR.

For all reported materiel Turn Ins where the Mode of Shipment is not equal to ‘X’ (ANSI Standard) or not equal to ‘CE’ (X12 Standard), the Government APSR supporting the C-ICP will establish an In transit. The codes ‘X’ and ‘CE” are used to indicate a bearer walkthrough (customer pickup of material) transaction. These types of transactions immediately reduce inventory and do not trigger an in-transit. Financial accountability for the materiel will remain with the Program until which time the 527R TRA is received from the C-ICP.

When the Contractor Inventory Control Point (C-ICP) receives the 527R Materiel Due-In and Receipt (Receipt) Transaction Set (TRA) from the DLA Disposition Services confirming the receipt of the materiel that was turned into them, the C-ICP will process the DLMS 527R closing the materiel in transit. Upon successful processing of the DLMS 527R, the C-ICP will generate an image of the ‘like’ DLMS 527R to send to the Government’s Accountable Property System of Record (APSR).

It is unlikely the 527R received from DLA Disposition Services will contain the Reference Identification loop that contains the specific UII/Serial Nbr/Batch Lot that was received, but if it should contain this information, perpetuate the data to the Government APSR.

MG - Manufacturer's Part Nbr

<Part Nbr>

DLM 4000.25-1, April 29, 2016 Change 7, AP2.7 Appendix 2.7 Document number.

527R Receipt Acknowledgement 527R Receipt Acknowledgement:

This 527R format is intended for formatting a Receipt Confirmation for Materiel issued to Customers to the Air Force APSR.

For all reported materiel issues where the Mode of Shipment is not equal to ‘X’ (ANSI Standard) or not equal to ‘CE’ (X12 Standard), the Government APSR supporting the C-ICP will establish an In transit. The codes ‘X’ and ‘CE” are used to indicate a bearer walkthrough (customer pickup of material) transaction. These types of transactions immediately reduce inventory and do not trigger an in-transit. Financial accountability for the materiel will remain with the Program until which time the 527R MRA is received from the C-ICP.

When the Contractor Inventory Control Point (C-ICP) receives the 527R Materiel Due-In and Receipt (Receipt) Transaction Set (MRA) from the customer confirming receipt of the materiel, the C-ICP will process the DLMS 527R closing the materiel in transit. Upon successful processing of the DLMS 527R, the C-ICP will generate an image of the ‘like’ DLMS 527R to send to the Government’s Accountable Property System of Record (APSR).

It is unlikely the 527R received from the customer will contain the Reference Identification loop that contains the specific UII/Serial Nbr/Batch Lot that was received, but if it should contain this information, perpetuate the data to the Government APSR.

MG - Manufacturer's Part Nbr

<Part Nbr>

DLM 4000.25-1, April 29, 2016 Change 7, AP2.7 Appendix 2.7 Document number.

824R Reject Advice 824R Reject Advice:

DLMS Transactions that are not able to be processed by the APSR will be returned to the CICP application via the 824R Application Advice (Reject Advice) Transaction Set. The 824R Transaction Set will only be used report those transactions that are not able to be processed due to functional issues (e.g. Issue when there is insufficient quantity on hand, as opposed to the DLMS transaction being ill-formatted.

The APSR will have the capability to reject the following Transaction Sets:

527 D4_/D6_ FI Receipt 527 TH FI Receipt Acknowledgement Advice 867 01 FI Issue 945 NJ FI Materiel Release Confirmation 945 NM FI Disposal Release Confirmation 947 NU FI Inventory Adjustment

When the CICP receives the 824R Reject Advice, the CICP is responsible for researching the problem with the original Transaction Set contained within the 824R transaction set, then resubmitting a corrected transaction set, if applicable.

MF - Part Nbr