Listing of Requisitions by Account Distribution Report
Report Series Name
C-U-PS-COMMITMENT-LISTING
Report Name
LISTING OF REQUISITIONS
BY ACCOUNT DISTRIBUTION
Library
Source code is located in
PSPUBLIC
Use
Use this report to identify
the open requisition lines included in the Available Funds File (AFF) committed
funds balance. This report should be generated whenever questions arise
concerning the transactions affecting the AFF committed funds balance.
Content
The report lists the amount
of the commitment remaining on the AFF for each requisition line, sorted
by company, account, center, and requisition. Each account distribution
is listed on a separate page.
Totals
This report gives totals
for account distribution and report.
Column Headings
- REQUISITION NUMBER- a number which uniquely identifies a requisition within this buying entity
- LINE NBR - requisition line number, identifies a particular line on a requisition. This number is unique within each requisition.
- SPL NBR - requisition line split number. A maximum of 5 splits are allowed per requisition.
- REQ LINE STATUS -indicates the status of the requisition line. (unresolved, unapproved, approved, split, delete, request for quote pending or closed)
- REQ ID - the requisitioner identification code
- REQUIRED SKU - the quantity required in stock keeping units.
- ITEM DESCRIPTION - description of the item being requisitioned.
- UNIT PRICE - the unit price of the item being ordered in stock keeping units.
- EXT LINE VALUE - extended line value.
The run statement member name is C-U-PS-COMMITMENT-LISTING-RUN
000010 OPTION LIBRARY(PSPUBLIC)
000020 RUN C-U-PS-COMMITMENT-LISTING
000100 INTO LIBRARY XXXXXXXX
000200 *SELECT PUR-REQ-GL-COMPANY-ID
000300 *SELECT PUR-REQ-GL-ACCOUNT-ID
000400 *SELECT PUR-REQ-GL-CENTER-ID
Type over the displayed variable values with your agencys values.