PO_GTC_FLTR_OPT

(SQL Table)
Index Back

GTC Filter Work record

GTC 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_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

4 GNV_GTC_TITLE Character(200) VARCHAR2(200) NOT NULL The title which is applied to a given General Terms and Conditions (GT&C). G-Invoicing MANINSRI 05/06/2021
5 GNV_GTC_STATUS Character(3) VARCHAR2(3) NOT NULL The Treasury Account Symbol (TAS) component that identifies the department, agency or establishment of the U.S. Government that is responsible for the TAS of the SELLER. G-Invoicing MANINSRI 05/06/2021
CLZ=Closed
REC=Open For Orders
6 GNV_GTC_START_DTTM Date(10) DATE The date the agreement will begin. G-Invoicing MANINSRI 05/06/2021
7 GNV_GTC_END_DTTM Date(10) DATE Agreement End Date
8 GNV_BIZ_APP_FEATUR Character(30) VARCHAR2(30) NOT NULL Unique code that ties a Business Application back to the Feature that manages it.
9 GNV_BIZ_APP_TYPE Character(20) VARCHAR2(20) NOT NULL Ginvoicing Business Application Type