PO_GTC_VW (SQL View)	Index Back
GTC Prompt on PO Header The unique agreement number that must be established between the Requesting Agency and Servicing Agency which will track each GT&C agreement from the origination through the completion or termination. Prompt from the GT&C Data page using SetID, GT&C Number, Requesting ALC, and Servicing ALC as criteria

PO_GTC_VW

(SQL View)

GTC Prompt on PO Header

The unique agreement number that must be established between the Requesting Agency and Servicing Agency which will track each GT&C agreement from the origination through the completion or termination. Prompt from the GT&C Data page using SetID, GT&C Number, Requesting ALC, and Servicing ALC as criteria

select SETID, GNV_GTC_NUM, GNV_REQUEST_ALC, GNV_SERVICE_ALC from PS_PO_GNV_GTC_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 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

3 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

4 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	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
3	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
4	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