INVOICE_IDOPRIDEM_INV_APPR_VW(SQL View) |
Index Back |
|---|---|
Invoices ready to be approvedInvoices that are ready to be approved |
| SELECT DISTINCT a.invoice_id , c.oprid FROM PS_VOUCHER a , ps_vendor b , ps_sec_bu_opr c , ps_em_vchr_apr_dat d WHERE a.vendor_setid = b.setid AND a.vendor_id = b.vendor_id AND a.appr_status <> 'A' AND a.entry_status ='P' AND a.vchr_apprvl_flg = 'S' AND a.match_status_vchr IN ('M','N','O') AND a.close_status <> 'C' AND a.process_man_close <> 'Y' AND a.business_unit = c.business_unit AND a.business_unit = d.business_unit AND a.voucher_id = d.voucher_id AND d.current_status='Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INVOICE_ID |
Character(30) | VARCHAR2(30) NOT NULL | Invoice Number |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |