BY ORDER OF THE COMMANDER AIR FORCE MATERIEL COMMAND AIR FORCE MATERIEL ...

702 Pages·2017·6.2 MB·English

BY ORDER OF THE COMMANDER AIR FORCE MATERIEL COMMAND
AIR FORCE MATERIEL COMMAND MANUAL 23-501, VOLUME 1
11 APRIL 2017
Materiel Management
D035A, D035B, RAMP AND WHSL
MODULE DATA SUBSYSTEMS

COMPLIANCE WITH THIS PUBLICATION IS MANDATORY

ACCESSIBILITY: Publications and forms are available for downloading or ordering on the
e-Publishing website at www.e-publishing.af.mil
RELEASABILITY: There are no releasability restrictions on this publication

OPR: HQ AFMC/A4RM Certified by: HQ AFMC/A4R
(Col Deirdre A. Mahon)
Supersedes: AFMCMAN23-5V1 Pages: 702

This publication implements Air Force Instruction (AFI) 23-101, Air Force Materiel
Management. This volume prescribes stock control guidance, procedures and utilization of
the Item Manager Wholesale Requisition Process (IMWRP) (D035A); Wholesale
Management and Efficiency Reports (WMER) (D035B); Reportable Asset Management
Process (RAMP) (D035C); and the Wholesale (WHSL) module of the Stock Control
System (SCS) Midtier data subsystem. It applies to Headquarters (HQ) Air Force Materiel
Command (AFMC), the Air Force Sustainment Center (AFSC), Air Force Life Cycle
Management Center (AFLCMC) and Air Force (AF) logistics organizations whose
missions require stock control functions. It also applies to other Department of Defense
(DoD) personnel requiring “Read Only” access to D035A, D035B, RAMP and WHSL. It
does not apply to Inventory Management Specialists (IMS)/Materiel Managers (MM) using
off-line data systems, the Combat Ammunition System (CAS) or to contractors performing
IMS/MM duties for Contractor Supported Weapon Systems (CSWS). This publication
does not apply to Air National Guard (ANG) or Air Force Reserve Command (AFRC) and
their units. Refer recommended changes and questions about this publication to the Office
of Primary Responsibility (OPR) using an AF Form 847, Recommendation for Change of
Publication; route AF Forms 847 from the field through the appropriate functional’s chain
of command. This publication may be supplemented at any level, but must be routed to the
OPR for coordination prior to certification and approval. The authorities to waive
wing/unit level requirements in this publication are identified with a Tier (“T-0, T-1, T-2,
T-3”) number following the compliance statement. Submit requests for waivers using AF
Form 679, Air Force Publication Compliance Item Waiver Request/Approval, through the
2 AFMCMAN23-501V1 11 APRIL 2017
chain of command to the appropriate Tier waiver approval authority, or alternately, to the
Publication OPR for non-tiered compliance items. Request for waivers must be approved
by the publication OPR prior to implementation. Ensure that all records created as a result
of processes prescribed in this publication are maintained in accordance with (IAW) Air
Force Manual (AFMAN) 33-363, Management of Records, and disposed of IAW the Air
Force Records Information Management System (AFRIMS) Records Disposition Schedule
(RDS). The use of the name or mark of any specific manufacturer, commercial product,
commodity, or service in this publication does not imply endorsement by the Air Force.
SUMMARY OF CHANGES
AFMCMAN 23-5, Volume 1 renumbered to AFMCMAN 23-501, Volume 1. Waivers to
this publication must be submitted using an AF Form 679. Major changes include
reconciliation procedures, including End of Month (EOM) data package data
requirements/storage/reporting as identified in the Air Force Sustainment Center’s
corrective action plans to support Financial Improvement Audit Readiness (FIAR). This
revision also establishes Supply Condition Code (SCC) X assets in response to Approved
Defense Logistics Management Standards (DLMS) Change (ADC) 1159. It incorporates
AFSC-initiated AF Form 847 (control ID AFMC 15-003). Inventory Management
Specialist roles with regard to adjusting Required Availability Dates (RAD) have been
clarified. It removes all references to the Government Furnished Material Transaction
Reporting System (G009). It inserts Management Review Code (MRC) assignment and
retention decision criteria. Lastly, it updates cited references.

Chapter 1— GENERAL AND ADMINISTRATIVE 17
1.1. Overview. ................................................................................................................ 17
1.2. Purpose.................................................................................................................... 17
1.3. Subsystem (D035A, D035B, RAMP and WHSL) Descriptions. ............................ 17
Table 1.1. AFMC ICP Mainframe Domains. ........................................................................... 18
1.4. System Access. ....................................................................................................... 20
Table 1.2. Alternate Stock Control Research Applications. .................................................... 22
Table 1.3. Requestor Types and Authorizations. ..................................................................... 23
Figure 1.1. Sample “Signed” LOR. ........................................................................................... 24
Table 1.4. User Authorization Groups. .................................................................................... 27
Table 1.5. Screen Designator Cross Reference. ....................................................................... 28
Table 1.6. D035A-Unique SAAR Instructions ........................................................................ 40
Figure 1.2. Sample Sponsor Letter ............................................................................................ 41
AFMCMAN23-501V1 11 APRIL 2017 3
Figure 1.3. Sample Non-Disclosure Letter ................................................................................ 42
Table 1.7. D035A Access Approving Authority. ..................................................................... 43
Table 1.8. User Authorizations ................................................................................................ 45
Table 1.9. Page Designator Cross Reference. .......................................................................... 46
Table 1.10. RAMP/WHSL-Unique SAAR instructions. ........................................................... 51
Figure 1.4. SCS-Midtier Addendum to SAAR. ......................................................................... 53
Table 1.11. RAMP/WHSL Access Approving Authority .......................................................... 56
1.5. Contingency Plan. ................................................................................................... 58
1.6. System Health and User Compliance. .................................................................... 60
Chapter 2— INTERFACES, DATABASE RECORDS AND KEY DATA ELEMENTS 61
2.1. Systems Interfaces. ................................................................................................. 61
Table 2.1. Data System Designator (DSD) to System Name Cross Reference ....................... 61
2.2. Key Data Elements. ................................................................................................ 62
Table 2.2. I&SG NPPCs. ......................................................................................................... 64
Table 2.3. D035A File Maintenance Codes ............................................................................. 65
Table 2.4. D035A Reserved Serial Number Codes (Record Position [rp] 40) ........................ 70
2.3. Maintaining Audit Trail. ......................................................................................... 71
Chapter 3— REQUISITION PROCESSING 72
3.1. Overview. ................................................................................................................ 72
3.2. Ordering. ................................................................................................................. 72
3.3. Initial Processing of a Requisition. ......................................................................... 73
Table 3.1. Valid Values for Requisition DIC Type Codes ...................................................... 75
Table 3.2. Valid Values for Requisition Suffix Codes ............................................................ 76
Table 3.3. AF Management Codes .......................................................................................... 82
Table 3.4. Manager-Forced Shipments .................................................................................... 83
Table 3.5. Reject Status Codes ................................................................................................ 86
3.4. Follow-on Requisition Processing. ......................................................................... 91
Table 3.6. Backorder (BO) Status Codes ................................................................................. 92
Table 3.7. Release for Shipment Processes .............................................................................. 94
4 AFMCMAN23-501V1 11 APRIL 2017
Table 3.8. Action Codes Usable on the BOAA Screen ........................................................... 98
Table 3.9. Customer-Requested Cancellation DICs and Cancellation Response DICs ........... 100
Table 3.10. D035A Edits on Customer-Requested Cancellations ............................................. 101
Table 3.11. D035A Action Taken on Customer-Requested Cancellations ................................ 102
Table 3.12. Restrictions to IM Manual Cancellations ............................................................... 103
Table 3.13. IM Manual Cancellation Status Codes ................................................................... 104
Table 3.14. Options for Mass Cancellation of Backorders ........................................................ 106
Table 3.15. Cross-Reference of Backorder Data Elements to Screens Used for
Modification............................................................................................................. 108
Table 3.16. Edits on Inbound Requisition Modifier Transactions ............................................. 111
Table 3.17. MOV Inclusions and Exclusions ............................................................................ 113
Table 3.18. D035A MOV Initiation and Follow-up Processes .................................................. 114
Table 3.19. MOV Generation Cycles......................................................................................... 115
Table 3.20. Managing MOV Response and Non-Response ...................................................... 116
Table 3.21. DIC APR Processing .............................................................................................. 118
Table 3.22. Confirmation Transactions...................................................................................... 120
Table 3.23. Denial Transactions ................................................................................................ 127
Table 3.24. ICP Follow-up and MRA Transactions .................................................................. 132
Table 3.25. DIC AE1, AE3 and AE6 D035A Unique Status Code Descriptions ...................... 141
Table 3.26. DIC AF_ and AT_ Requisition Follow-ups ............................................................ 144
3.5. FMS Requisitions. .................................................................................................. 147
Table 3.27. FMS Document Number DoDAAC and Supplementary Address Layouts ............ 148
Table 3.28. Types of FMS Requisitions .................................................................................... 148
Table 3.29. Programmed and Non-Programmed Requisitions .................................................. 149
Table 3.30. Scenarios When FMS Requisitions Are Suspended as Controlled
Exception ................................................................................................................. 150
Table 3.31. Disposition Codes ................................................................................................... 152
Table 3.32. FMS Backorder Follow-on Actions ........................................................................ 155
Table 3.33. Special Processing – FMS Follow-on Actions. ...................................................... 159
AFMCMAN23-501V1 11 APRIL 2017 5
Table 3.34. Fund Codes for Support of H-Coded Requisitions ................................................. 161
Table 3.35. Fund Codes for Support of Programmed Non-H-Coded Requisitions ................... 161
Table 3.36. Fund Codes for Support of Non-Programmed Non-H-Coded Requisitions
Received with Fund Code NU ................................................................................. 162
Table 3.37. Fund Codes for Support of Non-Programmed Non-H-Coded Requisitions
Received with Fund Code “4F” ............................................................................... 162
3.6. Contractor Requisitions for AF-Managed Items. .................................................... 163
Table 3.38. CFM Requisition Format ........................................................................................ 166
3.7. LP and LM Requisitions. ........................................................................................ 168
Table 3.39. Table 3.39. Requisitions for LP and LM Items....................................................... 169
3.8. Routed Item Repair Quantity (RIRQ) Requisitions. ............................................... 170
3.9. Asset Release Sequences. ....................................................................................... 171
Table 3.40. LL Codes................................................................................................................. 172
Table 3.41. Table 3.41. D035A LL Code Interfaces .................................................................. 173
3.10. Pre-positioning Backorders in D035K. ................................................................... 175
Table 3.42. Methods to Pre-position Backorders in D035A ...................................................... 176
3.11. Asset Selection Process. ......................................................................................... 178
Table 3.43. Base Excess Codes .................................................................................................. 179
3.12. ESD Computation. .................................................................................................. 181
Table 3.44. ESD Computation for Non-MICAP Requisitions ................................................... 182
Table 3.45. ESD Computation for MICAP Requisitions. .......................................................... 185
3.13. MICAP Requisition Procedures. ............................................................................. 185
Table 3.46. IM Options for Support of MICAP Requisitions. ................................................... 187
3.14. Points of Sale (POS) or Transfer. ........................................................................... 188
Table 3.47. Five CSAG Points of Sale or Transfer. ................................................................... 189
3.15. Requisitions For Items Coded For Disposal. .......................................................... 193
Table 3.48. Disposal Item Requisition Processing. ................................................................... 194
3.16. Programmed vs. Non-Programmed Requisitions.................................................... 195
Table 3.49. Programmed and Non-Programmed Requisition Processing. ................................. 196
6 AFMCMAN23-501V1 11 APRIL 2017
3.17. Requisitions for Items with DoD I&SG Relationships. .......................................... 198
Table 3.50. Example Basic I&SG Family.................................................................................. 198
Table 3.51. Example I&SG Family With Two Subgroups. ....................................................... 199
Table 3.52. I&SG Family With a Jump to Code Function......................................................... 199
Table 3.53. I&SG Family With NPPC 9. ................................................................................... 200
Table 3.54. I&SG Family With NPPC 4. ................................................................................... 200
Table 3.55. I&SG Family with a Non-Registered User. ............................................................ 200
Table 3.56. I&SG Family With a Registered User. ................................................................... 201
Table 3.57. AF is PICA and Manages I&SG Items for Use by Other Services. ........................ 201
Table 3.58. Table 3.58. Processing Requisitions With Advice Codes on Items in an
I&SG Family............................................................................................................ 202
3.18. Readiness Spares Packages (RSP) Requisitions. .................................................... 204
3.19. Backorder Processing for Items Changing Between Non-Stock Fund and
Stock Fund. .............................................................................................................. 204
3.20. SICA Requisitions for Other Service Managed Investment Items. ........................ 204
3.21. Supply and Shipment Status Processing. ................................................................ 205
Table 3.59. Supply and Shipment Status Processing ................................................................. 207
Chapter 4— PART NUMBERS 209
4.1. General. ................................................................................................................... 209
4.2. DLA Customer Interaction Center (CIC). .............................................................. 209
4.3. Customer Requirement. .......................................................................................... 209
Table 4.1. Determining P/N Requisition Destination .............................................................. 211
4.4. AFMC ICP P/N Requisition Processes. .................................................................. 212
Table 4.2. Processing Requisitions for Non-Logical Spares.................................................... 215
Table 4.3. AF Managed Logical Spares. .................................................................................. 217
Table 4.4. Non-AF Managed Logical Spares. ......................................................................... 218
Table 4.5. “1C” Exception and Follow-on Requisition Processing by PICA/SICA and
NIMSC ..................................................................................................................... 219
Table 4.6. P/N and CAGE Unmatched to Existing NSN ......................................................... 221
Table 4.7. Support Decision Table (P/N Unmatched to NSN) ................................................ 224
AFMCMAN23-501V1 11 APRIL 2017 7
4.5. PNCR Management. ............................................................................................... 226
Table 4.8. PNCR Database Record Types ............................................................................... 227
Chapter 5— WHOLESALE ASSET BALANCE MANAGEMENT 229
5.1. Overview. ................................................................................................................ 229
5.2. Due-in Process. ....................................................................................................... 229
5.3. Receipt Process. ...................................................................................................... 229
Table 5.1. D035A Processing of Receipts Failing Edits .......................................................... 230
Table 5.2. Procurement Receipt Types Processed by D035A ................................................. 233
Table 5.3. Non-Procurement Receipt Types Processed by D035A ......................................... 235
5.4. Asset Visibility. ...................................................................................................... 237
Table 5.4. D035A/RAMP Actions for Items Added to NWRM List ....................................... 241
Table 5.5. D035A/RAMP Actions for Items Deleted From NWRM List ............................... 244
Table 5.6. IM Actions on Classified Items .............................................................................. 246
Table 5.7. DSM Record Layout ............................................................................................... 249
5.5. Changes to Asset Records. ...................................................................................... 249
Table 5.8. Due-in Balance Records ......................................................................................... 250
Table 5.9. Actions That Effect On-Hand Balance Records ..................................................... 253
5.6. Asset-Related Interfaces with Other Data Systems. ............................................... 270
Table 5.10. Transactions D035A Sends to D035J ..................................................................... 272
Table 5.11. EOM Data Package Data Requirements/Storage/Reporting Matrix ....................... 277
Table 5.12. Transactions D035A Sends to D035J ..................................................................... 279
Table 5.13. Non-ALC DSS Storage Facilities ........................................................................... 281
Table 5.14. DSS/D035A Monthly Asset Balance Reconciliation Process ................................ 283
Table 5.15. DSS/D035A Reconciliation Menu Options ............................................................ 288
Table 5.16. (Added) Adjustment Approval and Signature Levels .............................................. 299
5.7. Removing Assets From Worldwide Inventory. ...................................................... 300
Table 5.17. Options for Initiating Disposal................................................................................ 301
8 AFMCMAN23-501V1 11 APRIL 2017
Chapter 6— REPORTABLE ASSET MANAGEMENT PROCESS (RAMP) 308
Section 6A— -General. 308
6.1. Purpose.................................................................................................................... 308
Table 6.1. Types of Items Reportable to RAMP ...................................................................... 309
6.2. Items Record Database Maintenance for RAMP. ................................................... 309
6.3. DoDAAC/RI Validation. ........................................................................................ 310
Section 6B— -Assets, Levels and Orders. 310
6.4. Overview. ................................................................................................................ 310
6.5. In-Bound Transaction Process. ............................................................................... 311
Table 6.2. RAMP In-bound Transaction Types ....................................................................... 312
Table 6.3. Document Identifiers by Originating System ......................................................... 313
Table 6.4. RAMP Edits for Inbound Transactions. .................................................................. 314
Table 6.5. Reject Advice Code To Type Transaction Cross-Reference. ................................. 315
6.6. Assets. ..................................................................................................................... 318
Table 6.6. User Ability to View/Update/Establish Base & Depot Balances Manually. .......... 319
6.7. Levels. ..................................................................................................................... 319
Table 6.7. Document Identifier to Level .................................................................................. 320
6.8. Excess Computation. .............................................................................................. 320
Table 6.8. Excess Computation I&SG and Exclusion Logic ................................................... 322
Table 6.9. Decision Matrix for Changes to Excess Computation Criteria ............................... 324
6.9. Impact of Retail Requisitioning on RAMP. ............................................................ 325
6.10. Intransit Control. ..................................................................................................... 325
6.11. RAMP Table Updates. ............................................................................................ 327
Table 6.10. RAMP Database Tables .......................................................................................... 327
Table 6.11. Materiel Assets Table ............................................................................................. 328
Table 6.12. Stock Materiel Allowance Line Item Table (Levels) .............................................. 330
Table 6.13. Requisition Assets Summary Data Table (Due-In/Due-Out) ................................. 330
Table 6.14. Materiel Assets Statistics Table (Usage Data) ........................................................ 331
Table 6.15. Report Assets Summary Event Table ..................................................................... 332
AFMCMAN23-501V1 11 APRIL 2017 9
Table 6.16. O/P Code Conversion Table ................................................................................... 333
Table 6.17. RAMP Reports ........................................................................................................ 334
6.12. Stock Balance & Consumption Reporting (SB&CR). ............................................ 335
Section 6C— Reparable Item Movement Control System (RIMCS). 335
6.13. Overview. ................................................................................................................ 335
6.14. RIMCS Process. ...................................................................................................... 336
Table 6.18. AFMC ICP Codes ................................................................................................... 337
Table 6.19. Default RIMCS Values for AF SIC NIMSC 5 Items .............................................. 338
Table 6.20. RIMCS Control Codes ............................................................................................ 339
6.15. RIMCS Data Flow. ................................................................................................. 340
Chapter 7— D035A, RAMP AND WHSL PROCESSES RELATED TO REPAIR 343
7.1. General. ................................................................................................................... 343
7.2. DMISA Repair. ....................................................................................................... 343
Table 7.1. DMISA Storage/Repair Sites. ................................................................................. 344
7.3. Contractor Repair. ................................................................................................... 353
7.4. Depot Organic Repair. ............................................................................................ 365
7.5. Centralized Repair Facility (CRF) and Base Repair. .............................................. 365
Chapter 8— CONTROLLED EXCEPTIONS AND NOTICES 366
Section 8A— -General. 366
8.1. Overview ................................................................................................................. 366
8.2. Research Resources. ............................................................................................... 367
Table 8.1. Controlled Exception Process Options. .................................................................. 368
Section 8B— -Controlled Exception and Notice Processing. 369
8.3. Controlled Exception Processing. ........................................................................... 369
Table 8.2. Cross Reference of DIC to Transaction Type. ........................................................ 370
Table 8.3. Exception Code Processing Matrix. ........................................................................ 371
8.4. Notice Processing. .................................................................................................. 442
Table 8.4. Notice Descriptions and Required Actions. ............................................................ 443
10 AFMCMAN23-501V1 11 APRIL 2017
Chapter 9— ACCUMULATION OF REQUIREMENTS DATA 474
9.1. General. ................................................................................................................... 474
9.2. Stock Balance and Consumption Report (SB&CR) Data for Reparable
(ERRC “T”) Items. .................................................................................................. 474
Table 9.1. D035A Quarterly Stock Balance and Consumption Report ................................... 477
9.3. Stock Balance and Demand Data for Consumable (ERRC “N” and “P”)
Items. ....................................................................................................................... 478
Table 9.2. SBSS and D035K Quarterly Consumption History ................................................ 479
9.4. Quarterly Process Overview. .................................................................................. 480
Table 9.3. Quarterly Intransit Data .......................................................................................... 481
Table 9.4. SBSS Quarterly Asset and Levels Data .................................................................. 482
Table 9.5. D035K Quarterly Asset and Levels Data ................................................................ 483
Chapter 10— MATERIEL RETURNS PROGRAM (MRP) 486
10.1. Overview. ................................................................................................................ 486
10.2. Reports of Excess. ................................................................................................... 486
Table 10.1. MRP Transaction Initiators ..................................................................................... 487
Figure 10.1. Flowchart of ‘FT_’ Transaction Processing (5 Charts) .......................................... 488
Table 10.2. Reporting Activity Initial Processing for AF PICA Items ...................................... 493
Table 10.3. Continued ‘FT_’ Transaction Processing for AF PICA Items ................................ 494
Table 10.4. Follow-up ‘FT_’ Transaction Processing for AF PICA Items ................................ 496
Table 10.5. AF SICA Processing Procedures for NIMSC 5 Items ............................................ 498
10.3. Non-DoD PICA Activities. ..................................................................................... 501
10.4. Solicitation of Foreign Country Owned Assets for AF Use. .................................. 502
Chapter 11— MANAGING ITEM RECORD DATA 504
11.1. Overview. ................................................................................................................ 504
11.2. Establishing an Item Record. .................................................................................. 504
11.3. Maintaining an Item Record. .................................................................................. 504
Table 11.1. Data Elements Originating in D035A, RAMP or WHSL. ...................................... 505
Table 11.2. D035A-Assigned MRCs. ........................................................................................ 515