PO_GNV_GTC_TBL

(SQL Table)
 Index Back

G Invoicing Terms & Conditions

G Invoicing Terms & Conditions MANINSRI 12/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 PO_EFFECTIVE_DTTM DateTime(26) TIMESTAMP Effective Date
4 GNV_GTC_AGREE_NUM Character(30) VARCHAR2(30) NOT NULL The internal Agency tracking number for the agreement. G-Invoicing.MANINSRI 06/06/2021
5 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
6 EFF_STATUS_C Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Yes
I=No
7 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
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_AGENCY_ID1 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 BUYER. G-Invoicing MANINSRI 05/06/2021
10 GNV_REQUEST_GRP_ID Character(36) VARCHAR2(36) NOT NULL Unique identifier for the Buyer organizational group. G-Invoicing MANINSRI 06/06/2021
11 GNV_REQUEST_GRP_NA Character(100) VARCHAR2(100) NOT NULL Rq Gp Nm
12 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
13 START_DATE Date(10) DATE Start Date for Gen Standing PO
14 END_DATE Date(10) DATE End Date
15 GNV_AGENCY_ID2 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
16 GNV_SERVICE_GRP_ID Character(36) VARCHAR2(36) NOT NULL Unique identifier for the Seller organizational group. G-invoicing MANINSRI 06/06/2021
17 GNV_SERVICE_GRP_NA Character(100) VARCHAR2(100) NOT NULL A unique and recognizable name for the Seller organizational group G-Invoicing MANINSRI 06/06/2021
18 GNV_PREPARE_NAME Character(100) VARCHAR2(100) NOT NULL Contains the full name of the person who prepared the GT&Cs.G-Invoicing MANINSRI 06/06/2021
19 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
20 GNV_PREPARE_EMAIL Character(100) VARCHAR2(100) NOT NULL Prepared Email
21 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
22 MODIFICATIONNUMBER Number(10,0) DECIMAL(10) NOT NULL Modification Number
23 GNV_OOPI Character(1) VARCHAR2(1) NOT NULL Identifies the trading partner that first introduces Orders to G-Invoicing under the GT&C agreement.
24 GNV_BIZ_APP_FEATUR Character(30) VARCHAR2(30) NOT NULL Unique code that ties a Business Application back to the Feature that manages it.
25 GNV_BIZ_APP_TYPE Character(20) VARCHAR2(20) NOT NULL Ginvoicing Business Application Type