PO_GNV_PER_HDR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	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
3	GNV_ORDER_NUM	Character(20)	VARCHAR2(20) NOT NULL	G-INVOICING MANINSRI 15/06/2021
4	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
5	GNV_PERFRM_REF_NBR	Character(20)	VARCHAR2(20) NOT NULL	A number that links a new Performance Transaction to an existing one. G-INVOICING MANINSRI
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
7	GNV_TRANS_ID	Character(50)	VARCHAR2(50) NOT NULL	The identifier an agency provides for a transaction. G-INVOICING MANINSRI 16/06/2021
8	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
9	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
10	GNV_TRANS_DTTM	Date(10)	DATE	The date and time the performance transaction was received by a system, e.g G-Invoicing. MANINSRI 16/06/2021
11	GNV_ACCOUNT_PERIOD	Number(6,0)	INTEGER NOT NULL	The fiscal period that the transaction is reflected in the General Ledger, if applicable. G-INVOICING MANINSRI 16/06/2021
12	GNV_COMMENT	Long Character	CLOB	Additional information, particularly for adjustments. G-INVOICING MANINSRI 17/06/2021
13	GNV_PREPAREDBY_NAM	Character(60)	VARCHAR2(60) NOT NULL	The full name of the user submitting the performance transaction. G-INVOICING MANINSRI
14	GNV_PREPARE_PHONE	Character(20)	VARCHAR2(20) NOT NULL	A number assigned to a telephone line for a specific location that is used to call that location. G-Invoicing MANINSRI 06/06/2021
15	GNV_PREPAREDB_MAIL	Character(60)	VARCHAR2(60) NOT NULL	The e-mail address of the user submitting the performance transaction. G-INVOICING MANINSRI 16/06/2021
16	GNV_BUY_SELL_IND	Character(1)	VARCHAR2(1) NOT NULL	Designates whether the Performance transaction or Attachment originated from the Requesting or Servicing agency. G-INVOICING MANINSRI 16/06/2021 R=Buyer S=Seller
17	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
18	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
19	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
20	RECEIVER_ID	Character(10)	VARCHAR2(10) NOT NULL	Receiver number
21	GNV_ADV_DEFAULT	Character(1)	VARCHAR2(1) NOT NULL	Defaults C=Complete I=Incomplete
22	GNV_PERFM_DTTM	Date(10)	DATE	The date and time the performance transaction was received by a system, e.g G-Invoicing. MANINSRI 16/06/2021
23	GNV_ADV_ADJUSTMENT	Character(1)	VARCHAR2(1) NOT NULL	Adjustment N=No Y=Yes