GNV_ADV_FIL_OPT

#	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
3	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
4	GNV_ORDER_NUM	Character(20)	VARCHAR2(20) NOT NULL	G-INVOICING MANINSRI 15/06/2021
5	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
6	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
7	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
8	GNV_ADV_DEFAULT	Character(1)	VARCHAR2(1) NOT NULL	Defaults C=Complete I=Incomplete
9	GNV_IN_PROCESS	Character(1)	VARCHAR2(1) NOT NULL	G-Invoicing Advance/Advance Adjustment Processing status. C=Complete N=Not Started P=Processing
10	FROM_DT	Date(10)	DATE	From Date
11	TO_DT	Date(10)	DATE	To Date
12	GNV_ADV_ADJUSTMENT	Character(1)	VARCHAR2(1) NOT NULL	Adjustment N=No Y=Yes