BUSINESS_UNITVOUCHER_IDEM_ES_VCHWPP_VW(SQL View) |
Index Back |
|---|---|
eSettlements Voucher VieweSettlements Voucher View |
| SELECT a.business_unit , a.voucher_id FROM PS_VOUCHER a , ps_em_buy_reg_tbl b , ps_em_agreement c , ps_set_cntrl_rec d WHERE ((a.vchr_src IN ('SSI','XML','DCM','EXL') AND a.voucher_style = 'REG') OR (a.voucher_style = 'PPAY')) AND a.business_unit = b.business_unit AND a.business_unit = d.setcntrlvalue AND d.recname = 'EM_AGREEMENT' AND d.rec_group_id = 'EM_01' AND d.setid = c.setid AND c.vendor_setid = a.vendor_setid AND c.vendor_id = a.vendor_id AND c.vndr_loc = a.vndr_loc |
| # | 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 |