GNV_ORDER_NUMPO_OPEN_ORD_VW(SQL View) |
Index Back |
|---|---|
G-Inv Order NumberA unique number used to identify the order created from the General Terms and Conditions. This field prompts from the G-Invoicing Orders table. Requesting ALC, Servicing ALC, and Order Number should appear as search criteria. Only Open orders (Status = REC) should be available for selection. |
| SELECT gnv_order_num , gnv_request_alc , gnv_service_alc FROM ps_PO_GNV_ORDERS_L L WHERE gnv_status = 'REC' AND EFF_STATUS_C = 'A' AND NOT EXISTS ( SELECT 'X' FROM PS_PO_HDR_GNV H WHERE H.gnv_order_num = L.gnv_order_num) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GNV_ORDER_NUM |
Character(20) | VARCHAR2(20) NOT NULL | G-INVOICING MANINSRI 15/06/2021 |
| 2 | 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 |
| 3 | 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 |