BUSINESS_UNITOPRIDVOUCHER_IDLANGUAGE_CDEM_VCHRLOG_LNG(SQL View) |
Index Back |
|---|---|
Match Exception Log SearchMatch Exception Log Search RSR MarketPay Development |
| SELECT DISTINCT a.business_unit , f.oprid , a.voucher_id , el.language_cd , el.vendor_name_short FROM ps_ap_mtch_excptn a , PS_VOUCHER d , ps_vendor e , ps_vendor_lang el , ps_sec_bu_opr f WHERE a.business_unit = d.business_unit AND a.business_unit = f.business_unit AND a.voucher_id = d.voucher_id AND d.vendor_setid = e.setid AND d.vendor_id = e.vendor_id AND e.setid = el.setid AND e.vendor_id = el.vendor_id |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | VOUCHER_ID |
Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | VENDOR_NAME_SHORT | Character(14) | VARCHAR2(14) NOT NULL | Short Vendor Name |