PO_GNV_ORDERS_L

(SQL Table)
Index Back

G-Invoicing Orders List

MANINSRI 15/06/2021

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 GNV_ORDER_NUM Character(20) VARCHAR2(20) NOT NULL G-INVOICING MANINSRI 15/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
5 GNV_STATUS Character(3) VARCHAR2(3) NOT NULL Status Code The current status of the requested document. G-INVOICING MANINSRI 15/06/2021
CLZ=Closed
REC=Open
STL=Settled
6 LASTUPDDT_SINCE Date(10) DATE Last Update Date Since
7 EFF_STATUS_C Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Yes
I=No
8 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
9 PO_GNV_FOB Character(1) VARCHAR2(1) NOT NULL Specifies at what point the seller transfers ownership of the goods to the buyer. G-Invoicing MANINSRI 19/02/2022 FOB Point
D=Destination
S=Source