Master Cross Reference List-1 (Mcrl-1)

MASTER CROSS REFERENCE LIST-1 (MCRL-1)

DRN DATA ELEMENT POSITION

3570 Reference Number, Logistics 1-32 (1)

9250 Commercial And Government Entity (CAGE) 33-37

Code

3994 Assigned Federal Supply Group (FSG) 38-39

3996 Assigned Federal Supply Class (FSC) 40-41

Within FSG 4130 National Codification Bureau (NCB) Code 42-43

4131 Item Identification Number 44-50 (2)

2650 Item Standardization Code (ISC) 51

4780 Reference Number Variation Code (RNVC) 52

2910 Reference Number Category Code (RNCC) 53

4672 Service Agency Designator Code (SADC) 54 (3)

Description Availability (DA) Code 55 (4)

2301 Short Name 56-74

and

2517 Name Root Remainder 75-87

5020 Non-Approved Item Name 56-74

and

2177 Item Name Non Approved Remainder 75-87

MCRL-1 NOTES

(1) Reference Number, Logistics (DRN 3570) has a maximum length of 32 characters for all MCRL parts/products. In actuality, DRN 3570 can have more than 32 characters but the MCRL only uses the first 32 characters. If DRN 3570 contains more than 32 characters, then the 32nd position will be a dash (-). The first 31 positions will be filled with the actual values for DRN 3570. The dash in position 32 will notify the user that there are more than 32 positions for this Reference Number, Logistics. For the MCRL-1, DRN 3570 must be sorted using a specific criteria, see the Detailed Functional Requirements section - "Reference Number, Logistics Sorting Criteria - paragraph 1.b.

(2) A Reference Number, Logistic (DRN 3570) can only be assigned to one active NSN. The MCRL-1 will not only display the active NSN that DRN 3570 is assigned to, but will also display all the cancelled/replaced NSNs it is assigned to. The active NSN that DRN 3570 is assigned to will be the first NSN. Cancelled/replaced NSNs which are assigned to DRN 3570 will then follow the active NSN. An active NSN can be identified by having a NIIN Status Code (DRN 2670) equal to zero (0) or one (1).

(3) If a Reference Number, Logistics (DRN 3570) and CAGE Code (DRN 9250) combination contains more than 1 Service Agency Designator Code (SADC - DRN 4672) then a continuation record must be used. The continuation record is identical to the record layout displayed above.

(4) Print position 56 contains the Description Availability (DA) Code. The DA Code does not possess a DRN. This data is derived based on the value of the Type of Item Identification Code, DRN 4820. If the value of DRN 4820 equals "2", then the DA Code equals "N". If the value for DRN 4820 does not equal "2", then DA Code equals " " (blank).

MASTER CROSS REFERENCE LIST-2 (MCRL-2)

DRN DATA ELEMENT POSITION

3994 Assigned Federal Supply Group (FSG) 1-2

3996 Assigned Federal Supply Class (FSC) 3-4

Within FSG

4130 National Codification Bureau (NCB) Code 5-6

4131 Item Identification Number 7-13 (1)

2650 Item Standardization Code (ISC) 14

9250 Commercial And Government Entity (CAGE) 15-19

Code

3570 Reference Number, Logistics 20-51 (2)

4780 Reference Number Variation Code (RNVC) 52

2910 Reference Number Category Code (RNCC) 53

4672 Service Agency Designator Code (SADC) 54 (3)

Description Availability (DA) Code 55 (4)

2301 Short Name 56-74

and

2517 Name Root Remainder 75-87

5020 Non-Approved Item Name 56-74

and

2177 Item Name Non Approved Remainder 75-87

MCRL-2 NOTES

(1) An active NSN not only has Reference Number Logistics assigned to it but it also has cancelled NSNs assigned to it. When an active NSN appears in the MCRL-2 it will display all the NSNs which are cancelled and replaced by that active NSN. The NSNs which are cancelled and replaced by an active NSN will appear in the Reference Number Logistics field, positions 21 - 52. An active NSN can be identified if it has a NIIN Status Code (DRN 2670) equal to zero (0) or one (1).

(2) Reference Number, Logistics (DRN 3570) has a maximum length of 32 characters for all MCRL parts/products. In actuality, DRN 3570 can have more than 32 characters but the MCRL only uses the first 32 characters. If DRN 3570 contains more than 32 characters, then the 32nd position will be a dash (-). The first 31 positions will be filled with the actual values for DRN 3570. The dash in position 32 will notify the user that there are more than 32 positions for this Reference Number, Logistics.

(3) If a NSN (DRNs 3994/3996/3040/3041) contains more than 1 Service Agency Designator Code (SADC - DRN 4672) then a continuation record must be used. The continuation record is identical to the record layout displayed above.

MASTER CROSS REFERENCE LIST-3 (MCRL-3)

DRN DATA ELEMENT POSITION

9250 Commercial And Government Entity (CAGE) 1-5

Code 3570 Reference Number, Logistics 6-37 (1)

3994 Assigned Federal Supply Group (FSG) 38-39

3996 Assigned Federal Supply Class (FSC) 40-41

Within FSG

4130 National Codification Bureau (NCB) Code 42-43

4131 Item Identification Number 44-50

2650 Item Standardization Code (ISC) 51

4780 Reference Number Variation Code (RNVC) 52

2910 Reference Number Category Code (RNCC) 53

4672 Service Agency Designator Code (SADC) 54 (2)

Description Availability (DA) Code 55 (3)

2301 Short Name 56-74

and

2517 Name Root Remainder 75-87

5020 Non-Approved Item Name 56-74

and

2177 Item Name Non Approved Remainder 75-87

MCRL-3 NOTES

(1) Reference Number, Logistics (DRN 3570) has a maximum length of 32 characters for all MCRL parts/products. In actuality, DRN 3570 can have more than 32 characters but the MCRL only uses the first 32 characters. If DRN 3570 contains more than 32 characters, then the 32nd position will be a dash (-). The first 31 positions will be filled with the actual values for DRN 3570. The dash in position 32 will notify the user that there are more than 32 positions for this Reference Number, Logistics. For the MCRL-3, DRN 3570 must be sorted using a specific criteria, see the Detailed Functional Requirements section - "Reference Number, Logistics Sorting Criteria - paragraph 1.b.

(2) If a CAGE Code and Reference Number Logistics combination contains more than 1 Service Agency Designator Code (SADC - DRN 4672) then a continuation record must be used. The continuation record is identical to the record layout displayed above.

(3) Print position 56 contains the Description Availability (DA) Code. The DA Code does not possess a DRN. This data is derived based on the value of the Type of Item Identification Code, DRN 4820. If the value of DRN 4820 equals "2", then the DA Code equals "N". If the value for DRN 4820 does not equal "2", then DA Code equals " " (blank).