Attachment_2_Definitions.xlsx
XLSX spreadsheet 10 KB Posted
- Attached to
- WR-ALC and WW Hub & Blade
- Solicitation number
- SPM4A213R0002
- Issued by
-
Defense Logistics Agency Aviation
About this file
Available Column Header Details for Attachments 2A 2B
View the file
Other files
Show all 29
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Req File Definitions Column Name Field Type Description
| ADJ_REQ_QTY | NUMBER(12) | Adjusted Requisition Quantity - source is 'BJ' status record |
| POR_QTY | NUMBER(12) | Total Pass or Refer Quantity - source is 'BM' status record |
| ADV_CD | CHAR(2) | Advice Code |
| BO_ESTABL_DT | DATE | The first date that a 'BV', 'BZ', or 'BB' status record is encountered |
| SHPD_DT | DATE | Last Ship Date |
| CAGE | CHAR(5) | |
| CANC_QTY | NUMBER(12) | Total Cancellation Quantity - source is 'BQ','BR','BS','B4' status records |
| DOB | DATE | Derived from the RDN |
| DODAAC | CHAR(6) | First 6 characters of the Requisition Number |
| SUPL_ADD | CHAR(6) | Supplemental Address |
| DODAAC_1 | CHAR(1) | First character of the Requisition Number |
| DATE_STAMP | DATE | Last date updated (usually a Monday) |
| REQ_DATE_STAMP | DATE | Date the requisition was received by DAASC |
| ESTIM_DELV_DT | DATE | Last known Estimated Delivery Date |
| FSC | CHAR(4) | Federal Supply Class |
| FSG | CHAR(2) | Federal Supply Group- The first 2 characters of the FSC |
| MILITARY_SERVICE | CHAR(6) | One of "AF", "AR", "MC", "NV", "AF FMS", "AR FMS", "NV FMS", "OTHER" |
| NIIN | CHAR(9) | |
| NSN_PN | CHAR(15) | |
| PRI_CD | CHAR(2) | Priority Code |
| PROJ_CD | CHAR(3) | Project Code |
| UNFILLED_QTY | NUMBER(12) | Any shipments, cancellations, pass or refer, and rejects will be applied to each requisition to determine if the requisition demand has been satisfied. If the demand has not been satisfied then the "UNFILLED_QTY" field will contain the demand quantity that has not been met. |
| RDD | CHAR(3) | Required Deliver Date |
| RDN | CHAR(14) | Requsition Number |
| REJ_QTY | NUMBER(12) | Total Reject Quantity - source is "C?" and "D?" status records with exception of "D7" |
| REQ_QTY | NUMBER(12) | Original Requisition Quantity |
| SFX_CD | CHAR(1) | Last Known Suffix Code |
| SHPD_QTY | NUMBER(12) | Total Shipped Quantity |
| SIG_CD | CHAR(1) | Signal Code |
| BO_STATUS_CD | CHAR(2) | One of "BB", "BV", "BZ" or NULL |
| REQ_STATUS | CHAR(1) | 1 = UNFILLED, 0 = FILLED - Set to '0' when UNFILLED_QTY is 0, otherwise set to '1' |
| STATUS_CD | CHAR(2) | Last Known Status Code |
File details come from the government source that posted it. Updated .