BY ORDER OF THE SECRETARY OF THE AIR FORCE AIR FORCE HANDBOOK 23-123 VOLUME ...

1454 Pages·2016·14.53 MB·English

AIR FORCE HANDBOOK 23-123
BY ORDER OF THE SECRETARY
VOLUME TWO PART TWO
OF THE AIR FORCE
8 AUGUST 2013
Incorporating Change 3, 8 DECEMBER
2017
Certified Current, 20 December 2021
Material Management
INTEGRATED LOGISTICS SYSTEM-
SUPPLY (ILS-S), ILS-S, STANDARD
BASE SUPPLY SYSTEM OPERATIONS
ACCESSIBILITY: Publications and forms are available on the e-Publishing website at
www.e-publishing.af.mil.
RELEASABILITY: There are no releasability restrictions on this publication.
OPR: AF/A4LM Certified by: AF/A4L
(Maj Gen John B. Cooper)
Pages: 1454
This handbook facilitates the implementation of AFI 23-101, Air Force Materiel Management
and AFMAN 23-122, Materiel Management Procedures. It provides information regarding
Integrated Logistics System – Supply (ILS-S) and supports the execution of guidance in AFI 23-
101, Air Force Materiel Management and AFMAN 23-122, Materiel Management Procedures.
This guidance applies to all personnel (military, civilian, and contractors) working for the United
States Air Force (USAF) including major commands (MAJCOMs), direct reporting units (DRU),
field operating agencies (FOA) and other individuals or organizations as required by binding
agreement or obligation with the Department of the Air Force (DAF). This handbook should be
used in conjunction with AFI 23-101 and AFMAN 23-122 in the execution of materiel
management operations. Refer recommended changes and questions about this publication to the
Office of Primary Responsibility (OPR) using AF Form 847, Recommendation for Change of
Publication; route AF Forms 847 from the field through the appropriate functional’s chain of
command. Ensure that all records created as a result of processes prescribed in this publication
are maintained in accordance with Air Force Manual (AFMAN) 33-363, Management of
Records, and disposed of in accordance with the Air Force Records Disposition Schedule (RDS)
located in the Air Force Records Information Management System (AFRIMS)
https://www.my.af.mil/afrims/afrims/afrims/rims.cfm. In accordance with the Paperwork
Reduction Act and DoD policy, ensure that reports of information collections that are collected
and/or are compiled and transmitted from the general public are cleared and licensed by the
Office of Management and Budget prior to collection. Information that is collected from other
AFH23-123V2PT2 8 AUGUST 2013 2
DoD components or Federal agencies must be approved by DoD and licensed with a report
control symbol. See Attachment 1 for a glossary of references and supporting information

SUMMARY OF CHANGES
This interim change revises AFH 23-123 Volume 2, Part 2, by updating information pertaining to
the NGV842/ D31 report information and codes. Update/changes to the Table 8.122 Input
Format and Entry Requirements (TRIC “FRR”). In addition, the removal of Two-Level
Maintenance (2LM) identification. Administrative changes for references throughout to change
“AFMC SCM-R Activity” to “AFMC”.
.

Chapter 1— OVERVIEW 55
1.1. Purpose.................................................................................................................... 55
1.2. Publication information. ......................................................................................... 55
1.3. Overview of Chapters. ............................................................................................ 55
Chapter 2— RESERVED 56
2.1. Chapter 2 is reserved. .............................................................................................. 56
Chapter 3— RESERVED 57
3.1. Chapter 3 is reserved. .............................................................................................. 57
Chapter 4— INQUIRIES/FILE INTERROGATION 58
Section 4A— -SBSS Inquiries. 58
4.1. Chapter Summary. .................................................................................................. 58
4.2. Overview. ................................................................................................................ 58
4.3. Review and Printing of Inquiries. ........................................................................... 58
4.4. Input Formats - Four Major Types. ......................................................................... 59
4.5. Output Formats. ...................................................................................................... 60
4.6. Requirements Computation Capability. .................................................................. 60
4.7. Data Base Key/Set Tracing Capability. .................................................................. 61
AFH23-123V2PT2 8 AUGUST 2013 3
4.8. Bulk Inquiry Capability. ......................................................................................... 61
4.9. Processing Rejects. ................................................................................................. 61
Section 4B— - Consolidated Transaction History Inquiries (CTH). 61
4.10. Overview. ................................................................................................................ 61
4.11. Transaction History Master Inquiry Menu. ............................................................ 61
4.12. Programs. ................................................................................................................ 62
Table 4.1. Screen Management Notices. .................................................................................. 63
4.13. Output Buffer/Paging File....................................................................................... 64
Table 4.2. Option R Output file. .............................................................................................. 65
4.14. Output Formats. ...................................................................................................... 65
Table 4.3. Option B Output file. .............................................................................................. 66
Table 4.4. Option B Output File. ............................................................................................. 67
Section 4C— -ES-S 67
4.15. Overview. ................................................................................................................ 67
4.16. Access. .................................................................................................................... 68
4.17. Architecture. ........................................................................................................... 68
4.18. Types of Queries. .................................................................................................... 68
4.19. Paging of SBSS INQ and CTH Inquiries. ............................................................... 69
4.20. Inquiry Input Formats. ............................................................................................ 69
Table 4.5. Input Format and Entry Requirements. Screen INQSN/#233 or INQDN/#235. .... 70
Table 4.6. Input Format and Entry Requirements. ................................................................... 70
Table 4.7. Input Format and Entry Requirements. ................................................................... 70
Table 4.8. Input Format and Entry Requirements. ................................................................... 71
Table 4.9. Input Format and Entry Requirements. ................................................................... 71
Table 4.10. Item Records Retrieval Codes. ............................................................................... 73
Table 4.11. Detail Record Retrieval Codes. ............................................................................... 74
Table 4.12. Type Inquiry and Stock/Document Number Fields. ............................................... 75
Table 4.13. Number Records for Serial Numbers. ..................................................................... 75
Table 4.14. Number Records, for DIFM details. ....................................................................... 75
AFH23-123V2PT2 8 AUGUST 2013 4
4.21. Item Record (Type 1, 1IOS, 2, 6 Examples) - New Output .................................... 75
Table 4.15. Output Format. ........................................................................................................ 76
4.22. Serial Number Inquiry. ........................................................................................... 78
Table 4.16. Input Format and Entry Requirements. ................................................................... 79
Figure 4.1. Serialized Control Details. ...................................................................................... 79
4.23. Requirements Computation Data - Output ............................................................. 79
Figure 4.2. Requirements Computation Data Output. ............................................................... 80
Figure 4.3. Requirements Computation Data Output (TAC: K). .............................................. 80
Table 4.17. Requirements Computation Inquiry - Glossary of Terms. ...................................... 81
4.24. Format, Data Base Key/Set Trace. .......................................................................... 82
Figure 4.4. Format, Data Base Key/Set Trace. .......................................................................... 83
4.25. Repair Cycle Record (Type 5) – Output. ................................................................ 83
Figure 4.5. Repair Cycle Record (Type 5) – Output. ................................................................ 84
4.26. ISG Record (Type ISG) – Output. .......................................................................... 84
Figure 4.6. ISG Record (Type ISG) – Output. .......................................................................... 85
4.27. Stock Fund/Investment MACR – Output. .............................................................. 85
Figure 4.7. Stock Fund/Investment MACR – Output. .............................................................. 86
4.28. OCCR – Output. ..................................................................................................... 86
4.29. Project Fund Management Record (PFMR) – Output. ........................................... 86
4.30. Transaction History Record (Type 4) – Output. ..................................................... 86
Figure 4.8. Transaction History Record (Type 4) – Output. ..................................................... 87
4.31. Transaction History Master Inquiry Menu NGV202. ............................................. 87
Table 4.18. Input Format and Entry Requirements. ................................................................... 88
Figure 4.9. Screen Layout. ........................................................................................................ 88
4.32. CTH Stock Number Inquiry – Input. ...................................................................... 88
Figure 4.10. Option L Output. ..................................................................................................... 89
Table 4.19. Input Format and Entry Restrictions. ...................................................................... 90
Figure 4.11. Screen Layout. ........................................................................................................ 91
Table 4.20. Report Select Card. ................................................................................................. 91
AFH23-123V2PT2 8 AUGUST 2013 5
Table 4.21. Parameter Card 1. ................................................................................................... 91
Table 4.22. Parameter Card 2. ................................................................................................... 92
4.33. Transaction History Serial Number Inquiry – Input. .............................................. 92
Table 4.23. Input Format. .......................................................................................................... 92
Figure 4.12. TRIC CTHSER/864. ............................................................................................... 93
4.34. CTH Stock Number and Document Number Inquiry – Input. ................................ 93
Table 4.24. Report Select Card. ................................................................................................. 93
Table 4.25. Parameter Card 1. ................................................................................................... 94
Table 4.26. Parameter Card 2. ................................................................................................... 94
4.35. CTH Batch Miscellaneous Option Inquiry – Input. ................................................ 94
Table 4.27. Report Select Card. ................................................................................................. 95
Table 4.28. Parameter Card 1. ................................................................................................... 95
Table 4.29. Parameter Card 2. ................................................................................................... 96
Table 4.30. Sort Positions on the Parameter Card. .................................................................... 97
Figure 4.13. Screen Layout. ........................................................................................................ 97
4.36. CTH Batch Transaction Date and Serial Number Inquiry – Input.......................... 97
Table 4.31. Report Select Card. ................................................................................................. 98
Table 4.32. Parameter Card 1. ................................................................................................... 98
Table 4.33. Parameter Card 2. ................................................................................................... 99
Table 4.34. Sort Positions on the Parameter Card. .................................................................... 100
4.37. Short Inquiry Format – Output. .............................................................................. 100
Figure 4.14. Short Inquiry. .......................................................................................................... 100
4.38. Long Inquiry Format - Output (RPS/Main Site Only). ........................................... 101
Table 4.35. Input Select and Parameter Cards. .......................................................................... 102
Table 4.36. Header Lines. .......................................................................................................... 103
Table 4.37. Transaction History Record Lines (Data Lines). .................................................... 107
Table 4.38. Reject Numbers. ...................................................................................................... 109
4.39. Abbreviated Inquiry Format – Output. ................................................................... 110
Figure 4.15. Detailed Transaction Inquiry Screen – Output. ...................................................... 110
AFH23-123V2PT2 8 AUGUST 2013 6
4.40. Detailed Transaction Inquiry Screen – Output. ...................................................... 110
Figure 4.16. Detailed Transaction Inquiry Screen. ..................................................................... Error!
Bookmark not defined.
Chapter 5— BATCH MODE PROCESSING PROCEDURES DAILY, MONTHLY,
QUARTERLY, SEMIANNUAL, AND ANNUAL REPORTS AND
LISTINGS 112
Section 5A— - Batch Mode (End-Of-Day) Processing Procedures. 112
5.1. Chapter Summary. .................................................................................................. 112
5.2. Overview. ................................................................................................................ 112
Table 5.1. Discoverer Plus Reports. ......................................................................................... 113
5.3. Scheduling of Reports and Listings. ....................................................................... 113
5.4. Distribution of Reports and Listings. ...................................................................... 115
5.5. End-of-Night Report Processing. ............................................................................ 116
5.6. End-of-Month Cutoff. ............................................................................................. 116
5.7. Reports Mode Concurrent Processing. ................................................................... 116
5.8. Reports/Batch Production Report. .......................................................................... 116
5.9. End-of-Day (EOD) Subroutines. ............................................................................ 116
5.10. Mandatory Utility Programs. .................................................................................. 116
5.11. Computer Output Function-Satellite/End-of-Day. .................................................. 116
5.12. Mandatory Reports and Listings. ............................................................................ 116
Table 5.2. SBSS Activity Reports and Listings. ...................................................................... 117
5.13. SBSS Batch Processing Procedures. ....................................................................... 118
5.14. Creation of Data Files For Microcomputer Systems. ............................................. 118
Section 5B— -Daily Reports and Listings. 118
5.15. Overview. ................................................................................................................ 118
5.16. Daily Report Processing. ........................................................................................ 119
Section 5C— -Monthly Reports And Listings. 119
5.17. Overview. ................................................................................................................ 119
5.18. Monthly Report Processing..................................................................................... 119
5.19. Update of the Base Supply Management Data Records. ........................................ 119
AFH23-123V2PT2 8 AUGUST 2013 7
Section 5D— -Quarterly Reports And Listings. 120
5.20. Overview. ................................................................................................................ 120
5.21. Quarterly Report Processing. .................................................................................. 120
Section 5E— -Semiannual Reports And Listings. 120
5.22. Overview. ................................................................................................................ 120
5.23. Semiannual Report Processing. .............................................................................. 120
Section 5F— - Annual Reports And Listings. 120
5.24. Overview. ................................................................................................................ 120
5.25. Annual Report Processing....................................................................................... 120
5.26. Base Supply Computer Work Request. .................................................................. 120
5.27. Mandatory Utility Programs, .................................................................................. 122
Table 5.3. Local Mandatory Utility Programs. ........................................................................ 122
Table 5.4. AFMC SCM-R Information Technology Activity Produced Mandatory Utility
Programs. ................................................................................................................. 123
5.28. Batch Production Scheduling And Control. ............................................................ 123
Table 5.5. Run Dates For Programs NGV819/Q04 and NGV871/Q05. .................................. 126
Table 5.6. Run Dates For Program NGV815/S01. .................................................................. 126
Table 5.7. Program Function Codes and Their Purposes. ........................................................ 128
5.29. Batch Processing Common Subroutines ................................................................. 128
Figure 5.1. Response Required Line. ........................................................................................ 129
Table 5.8. Report Select Format. ............................................................................................. 130
Table 5.9. Report Select Format. ............................................................................................. 131
Figure 5.2. Response Display. ................................................................................................... 131
5.30. Sample Batch Runstreams. ..................................................................................... 132
Figure 5.3. Sample Batch Runstream. ....................................................................................... 133
5.31. Master Batch Production Schedule (BPS) Control Record. ................................... 133
Table 5.10. Record Format. ....................................................................................................... 134
5.32. Master Batch Production Schedule (BPS) Runstream Identifier/Prerequisite
Record. ..................................................................................................................... 134
AFH23-123V2PT2 8 AUGUST 2013 8
Table 5.11. Record Format. ....................................................................................................... 135
5.33. Local Batch Production Schedule (BPS) Control Record. ..................................... 135
Table 5.12. Record Format. ....................................................................................................... 135
5.34. Local Batch Production Schedule (BPS) Runstream Identifier/Prerequisite
Record. ..................................................................................................................... 136
Table 5.13. Record Format. ....................................................................................................... 136
Table 5.14. Record Format. ....................................................................................................... 137
5.35. Selects Table Record. ............................................................................................. 137
Table 5.15. Record Format. ....................................................................................................... 138
5.36. Master Batch Production File/Selects Table Data. ................................................. 138
5.37. Consolidated Sustainment Activity Group-Maintenance (CSAG-M) Daily
Report (RPTD02/NGV794) ..................................................................................... 139
Table 5.16. Program Select Format. .......................................................................................... 140
5.38. Daily Document Register (D04/NGV804) ............................................................. 141
Table 5.17. Selection Criteria for Transaction Phrases. ............................................................. 142
Table 5.18. Report Select Format. ............................................................................................. 145
Table 5.19. Part 2. ...................................................................................................................... 146
Figure 5.4. Part Code................................................................................................................. 147
Table 5.20. Print Image Data File Format. ................................................................................ 147
Table 5.21. Print Image Data File. ............................................................................................. 149
Table 5.22. Print Image Data File Format. ................................................................................ 149
Table 5.23. Print Image Data File Format. ................................................................................ 149
Table 5.24. Print Image Data File Format. ................................................................................ 149
Table 5.25. Print Image Data File Format. ................................................................................ 150
Table 5.26. Output Data File Format. ........................................................................................ 150
5.39. End-Of-Day IMR and GLAC Update (D07/NGV980). .......................................... 152
5.40. Stock Fund Materiel Acquisition Status Report (MACR) (D08/NGV975). ........... 152
5.41. Civil Engineering Work Information Management System (WIMS) Punch-out
(D10/NGV981). ....................................................................................................... 153
Table 5.27. Report Select Format. ............................................................................................. 153
AFH23-123V2PT2 8 AUGUST 2013 9
Table 5.28. CWM Output Format A. ......................................................................................... 154
Table 5.29. Note 1 to CWM Output Format A. ......................................................................... 155
Figure 5.5. Note 4 to CWM Output Format A. ......................................................................... 155
Table 5.30. CWM Output Format B. ......................................................................................... 156
Table 5.31. CW* Output Format. .............................................................................................. 157
5.42. Daily PFMR/OCCR Update And Reconciliation (D11/NGV969). ........................ 157
5.43. A&F End-Of-Day, End-Of-Month Punch-out (D12/NGV982). ............................. 158
Table 5.32. D12 Backup Files. ................................................................................................... 160
Table 5.33. Report Selection Transaction. ................................................................................. 164
Table 5.34. Receipt From Local Vendor (BK1/BK2) Transaction. ........................................... 165
Table 5.35. BK1/BK2 Transaction File Header Record. ........................................................... 165
Table 5.36. BK1/BK2 Transaction File Trailer Record. ............................................................ 166
Table 5.37. Materiel Reimbursable Sales and Creditable Sales Return (SZR/SZS)
Transaction............................................................................................................... 166
Table 5.38. Funding Code Variables. ........................................................................................ 167
Table 5.39. Stock Fund Detail Billing (DB1/2/3/4/5/6) Transaction. ........................................ 168
Table 5.40. Daily Control (DB*/SZ*) Transaction. ................................................................... 169
Table 5.41. FMS Materiel Issue and Turn-In (N) Transaction. ................................................. 169
Table 5.42. WRM Non-reimbursable Requisition (WTC) Transaction. .................................... 170
Table 5.43. ICL Text Trailer. ..................................................................................................... 170
5.44. Daily SRD Update (D13/NGV833). ....................................................................... 170
Table 5.44. Report Select Format. ............................................................................................. 171
Table 5.45. Edit Logic Table. .................................................................................................... 172
5.45. Base Supply Management Report (D14/NGV807). ............................................... 173
Table 5.46. Report Select Format. ............................................................................................. 174
Table 5.47. Pos 37-47 on D14 Report. ....................................................................................... 175
5.46. Line Item Reconciliation Report (D17/NGV817). ................................................. 175
Table 5.48. Report Select Format. ............................................................................................. 177
5.47. Surveillance Report (D20/NGV821) ...................................................................... 177
AFH23-123V2PT2 8 AUGUST 2013 10
Table 5.49. Report Select Format. ............................................................................................. 181
Table 5.50. Positions 61-64 of D20 Report. .............................................................................. 182
Table 5.51. Parts 1, 2, and 11 Format. ....................................................................................... 183
Table 5.52. Part 3. ...................................................................................................................... 184
Table 5.53. Part 4. ...................................................................................................................... 185
Table 5.54. Part 5. ...................................................................................................................... 186
Table 5.55. Category Header Information. ................................................................................ 187
Table 5.56. Budget Code Header Information. .......................................................................... 188
Table 5.57. Totals For Losses/Gains. ......................................................................................... 188
Table 5.58. Part 6. ...................................................................................................................... 189
Table 5.59. Part 7. ...................................................................................................................... 190
Table 5.60. Part 8. ...................................................................................................................... 191
Table 5.61. Total Reject Information. ........................................................................................ 191
Table 5.62. Part 9. ...................................................................................................................... 192
Table 5.63. Total Forced Cleared Information. ......................................................................... 192
Table 5.64. Part 10. .................................................................................................................... 193
Table 5.65. Part 12. .................................................................................................................... 194
Table 5.66. Part 13. .................................................................................................................... 195
Table 5.67. D20 Distribution Breakdown. ................................................................................. 196
5.48. Vehicle Integrated Management System (VIMS) (D22/NGV985). ....................... 196
Table 5.68. Report Select Format. ............................................................................................. 197
Table 5.69. VIMS Nonfuel Cost Transaction Format. ............................................................... 198
Table 5.70. VIMS Fuel Cost Transaction Format. ..................................................................... 198
5.49. Daily Equipment Transaction Report (D24/NGV787). .......................................... 199
Table 5.71. Report Select Format. ............................................................................................. 200
5.50. Consolidated Sustainment Activity Group-Supply (CSAG-S) Summary Report
(D26/NGV798) ........................................................................................................ 200
Table 5.72. Selection Criteria. ................................................................................................... 201
Table 5.73. Report Select Format. ............................................................................................. 203