PO_GNV_ORDERS_L(SQL Table) |
Index Back |
---|---|
G-Invoicing Orders ListMANINSRI 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 |