SETIDGNV_EZ_NUMAP_VCHR_EZ_VW(SQL View) |
Index Back |
|---|---|
EZ Invoiced VouchersEZ Invoiced Vouchers |
| SELECT DISTINCT SETID , GNV_EZ_NUM , GNV_GTC_NUM , GNV_PERFM_DTTM , GNV_TRANS_DTTM , GNV_PERFORM_AMT FROM PS_AP_GINV_EZ_TBL WHERE BUSINESS_UNIT_AP=' ' AND VOUCHER_ID=' ' AND GNV_EZ_TRANS_TYPE='011' AND GNV_STATUS<>'XXX' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | GNV_EZ_NUM |
Character(20) | VARCHAR2(20) NOT NULL | EZ Invoice EZ Number |
| 3 | 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 |
| 4 | GNV_PERFM_DTTM | Date(10) | DATE | The date and time the performance transaction was received by a system, e.g G-Invoicing. MANINSRI 16/06/2021 |
| 5 | GNV_TRANS_DTTM | Date(10) | DATE | The date and time the performance transaction was received by a system, e.g G-Invoicing. MANINSRI 16/06/2021 |
| 6 | GNV_PERFORM_AMT | Signed Number(33,2) | DECIMAL(31,2) NOT NULL | EZ Invoice Performance Amount |