PO_PFM_FLTR_OPT

(SQL Table)
Index Back

Performance Filter Work record

Performance Filter Work record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

3 GNV_PERFORM_TYPE Character(3) VARCHAR2(3) NOT NULL Identifies the nature of the performance in the reported transaction. G-INVOICING MANINSRI 16/06/2021
014=Deferred Payment
035=Delivered/Performed
050=Received/Accepted
548=Advance
4 GNV_PERFORM_NBR Character(20) VARCHAR2(20) NOT NULL A number for a Performance transaction, assigned by G-Invoicing (GINV) at the time the transaction is recorded in GINV. MANINSRI 16/06/2021
5 GNV_ORDER_NUM Character(20) VARCHAR2(20) NOT NULL G-INVOICING MANINSRI 15/06/2021
6 GNV_GTC_NUM Character(20) VARCHAR2(20) NOT NULL The unique agreement number that must be established between the Requesting Agency and Servicing Agency which will track each General Terms and Conditions (GT&C) agreement from the origination through the completion or termination. G-Invoicing MANINSRI 05/06/2021

Prompt Table: PO_GNV_GTC_TBL

7 GNV_REQUEST_ALC Character(8) VARCHAR2(8) NOT NULL The identifier for the accounting office within an agency that reports disbursements and collections to Treasury for the BUYER. G-Invoicing MANINSRI 05/06/2021
8 GNV_SERVICE_ALC Character(8) VARCHAR2(8) NOT NULL The identifier for the accounting office within an agency that reports disbursements and collections to Treasury for the SELLER. G-Invoicing MANINSRI 05/06/2021
9 FROMDATE Date(10) DATE From Date
10 TO_DATE Date(10) DATE To Date
11 GNV_PO_STATUS Character(1) VARCHAR2(1) NOT NULL Indicator that shows the following: � For Advances (�548�) whether an Advance has been created. � For Delivered/Performend (�035�) whether a receipt (ASN) has been created. G-INVOICING MANINSRI 16/06/2021
C=Complete
N=Not Started
P=Processing
12 GNV_ADV_ADJUSTMENT Character(1) VARCHAR2(1) NOT NULL Adjustment
N=No
Y=Yes