PO_PFM_FLTR_OPT(SQL Table) |
Index Back |
---|---|
Performance Filter Work recordPerformance 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 |