Requisition Headers with No Assigned Lines Report
Report Series Name
C-U-PS-REQ-MAINT
Report Name
Requisition Headers with No Assigned Lines
Library
Source code is located in PSPUBLIC
Use
This report should be used to list requisitions that are incomplete, which may require manual deleting of the requisition header.
Content
This report lists all requisitions that consist of only a header, with no lines associated with the document. The headers may have been created and forgotten by requisitioners. These headers must be deleted manually, or they will remain on line indefinitely. This information is used to assist in cleanup activities as the end of a fiscal year approaches.
Totals
N/A
Column Headings
- BUY. ENT. - the buying entity under which this requisition was created
- REQ. NUMBER - the requisition number.
- STAT. - (Requisition Status) either open, closed, or delete
- DATE ENTERED - date the requisition header was entered
- REQUESTER NAME - the name associated with the requester ID that was used to set up this requisition header.
- REQUESTER PHONE - the telephone number associated with the requester ID that was used to set up this requisition header.
Run Statements
The run statement member name is C-U-PS-REQ-MAINT-RUN
000010 OPTION LIBRARY(PSPUBLIC)
000020 RUN C-U-PS-REQ-MAINT
000100 INTO LIBRARY XXXXXXXXX
000200 SELECT PUR-BUYING-ENTITY
000300 ('08BC' '14BS')
Type over the displayed variable values with your agencys values