Description
Unable to accurately pull and report information regarding shipment and document transactions.  In the Inquiries > Documents view a document number that has been canceled or a document number that has been completed both display a status of code of C-Closed.  Additional information is needed to properly analyze and report transactions associated to document numbers. The transaction detail records including the “doc transaction status” field is needed to properly determine if the transaction was completed or canceled.  

Recommended
Recommend a monthly data extract of the CSP enterprise shipment/document transactions to be provided.  This would include all transactions internal and external shipment and document number transactions that occurred during the month. 
The following columns are required in this data set.  See attached data dictionary for reference.
From Warehouse
From DoDAAC
To Warehouse
To DoDAAC
Document Type
Document Number
Established Date
Established User_ID
Document Status
Document Stage Code
NSN
Serial Number
Lot Number
Contract Number
Expire Date
Maintenance Date
Maint Due Date
Calibration Date
Cal Due Date
Nomenclature
Unit Price
Qty Ordered
Qty Received
Qty Verified
Qty Accepted
Qty in QC
Doc Transaction Status
Last Transaction Date
Transaction Qty
Condition Code
User_ID
Comments

Mission Critical
Yes, this data is needed for monthly and ad-hoc reporting requirements, to help maintain inventory accuracy and assist the CSP Program Management Office personnel in operational decisions. 

Benefits
Having this data will reduce time/cost by preventing users from having to complete multiple steps to get the information needed to fulfill monthly and ad-hoc reports, and also improves reporting accuracy by preventing users from manually manipulating large data sets to achieve the required results.

Users
All IIF/UIF

11 Mar 2021 – cancelled per Jack Sanders
No Longer Needed.