SETIDGNV_GTC_NUMPO_GNV_GTC_VW(SQL View) |
Index Back |
|---|---|
G-Invoicing GTC ViewG-invoicing GTC View |
| SELECT B.SETID , B.GNV_GTC_NUM , B.GNV_GTC_TITLE FROM PS_PO_GNV_GTC_TBL B WHERE B.EFF_STATUS_C = 'A' AND B.PO_EFFECTIVE_DTTM =( SELECT MAX(G.PO_EFFECTIVE_DTTM) FROM PS_PO_GNV_GTC_TBL G WHERE G.SETID = B.SETID AND G.GNV_GTC_NUM = B.GNV_GTC_NUM AND G.PO_EFFECTIVE_DTTM<=%CurrentDateTimeIn AND G.EFF_STATUS_C = 'A' ) |
| # | 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 | 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 |