BUSINESS_UNITVOUCHER_ID011=Invoice
201=Accepted
324=Reversed
598=Rejected
AP_EZ_VCHR_VW(SQL View) |
Index Back |
|---|---|
EZ Reversed VouchersEZ Reversed Vouchers |
| SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.GNV_EZ_NUM , '598' , A.GNV_REQUEST_GRP_ID , A.GNV_SERVICE_GRP_ID , B.INVOICE_DT , A.GNV_ACCOUNT_PERIOD , A.GNV_PREPARER_NAME , A.GNV_PREPARER_EMAIL , A.GNV_PREPARER_PHONE , A.GNV_AUTHORZ_NAME , A.GNV_AUTHORZ_EMAIL , A.GNV_AUTHORZ_PHONE , B.LAST_UPDATE_DTTM FROM PS_AP_VCHR_EZ_TBL A , PS_VOUCHER B WHERE A.BUSINESS_UNIT=B.BUSINESS_UNIT AND A.VOUCHER_ID=B.VOUCHER_ID AND B.VOUCHER_STYLE='CORR' AND A.PROCESSED_FLG='N' AND B.BUDGET_HDR_STATUS='V' AND A.GNV_REJ_EZ_NUM= ' ' AND NOT EXISTS ( SELECT 'X' FROM PS_AP_GINV_EZ_TBL C WHERE A.SETID=C.SETID AND A.GNV_EZ_NUM=C.GNV_REF_EZ_NUM AND C.GNV_EZ_TRANS_TYPE='324') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | VOUCHER_ID |
Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 3 | GNV_REF_EZ_NUM | Character(20) | VARCHAR2(20) NOT NULL | EZ Invoice Reference EZ number |
| 4 | GNV_EZ_TRANS_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
EZ Invoice Transaction Type
011=Invoice 201=Accepted 324=Reversed 598=Rejected |
| 5 | GNV_REQUEST_GRP_ID | Character(36) | VARCHAR2(36) NOT NULL | Unique identifier for the Buyer organizational group. G-Invoicing MANINSRI 06/06/2021 |
| 6 | GNV_SERVICE_GRP_ID | Character(36) | VARCHAR2(36) NOT NULL | Unique identifier for the Seller organizational group. G-invoicing MANINSRI 06/06/2021 |
| 7 | 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 |
| 8 | GNV_ACCOUNT_PERIOD | Number(6,0) | INTEGER NOT NULL | The fiscal period that the transaction is reflected in the General Ledger, if applicable. G-INVOICING MANINSRI 16/06/2021 |
| 9 | GNV_PREPARER_NAME | Character(100) | VARCHAR2(100) NOT NULL | EZ Invoice Preparer Name |
| 10 | GNV_PREPARER_EMAIL | Character(100) | VARCHAR2(100) NOT NULL | EZ Invoice Preparer Email |
| 11 | GNV_PREPARER_PHONE | Character(20) | VARCHAR2(20) NOT NULL | EZ Invoice Preparer Phone |
| 12 | GNV_AUTHORZ_NAME | Character(100) | VARCHAR2(100) NOT NULL | EZ Invoice Authorized Name |
| 13 | GNV_AUTHORZ_EMAIL | Character(100) | VARCHAR2(100) NOT NULL | EZ Invoice Authorized Email |
| 14 | GNV_AUTHORZ_PHONE | Character(20) | VARCHAR2(20) NOT NULL | EZ Invoice Authorized Phone |
| 15 | EZPUSH_DTTM_UPDTD | DateTime(26) | TIMESTAMP | DateTime Updated |