BUSINESS_UNITVOUCHER_IDVCHR_INQ_PAY_VW(SQL View) |
Index Back |
|---|---|
Voucher Inquiry Work ViewVoucher Inquiry work view |
| SELECT DISTINCT A.BUSINESS_UNIT , A.VOUCHER_ID FROM PS_VOUCHER A , PS_PYMNT_VCHR_XREF B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID AND A.VOUCHER_STYLE <> 'PPAY' AND B.PYMNT_SELCT_STATUS NOT IN ('P', 'S') AND B.PYMNT_TYPE <> 'W' AND NOT EXISTS ( SELECT 'X' FROM PS_PYMNT_VCHR_XREF P WHERE P.BUSINESS_UNIT = B.BUSINESS_UNIT AND P.VOUCHER_ID = B.VOUCHER_ID AND P.PYMNT_SELCT_STATUS = 'P') |
| # | 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 |