BUSINESS_UNITVOUCHER_IDVMMT_REPLAC_VW2(SQL View) |
Index Back |
|---|---|
Vchr Mass Mnt "Replace" View"Vouchers that can be Field Replaced" filter view for Voucher Mass Maintenance Search Results; i.e., selects all eligible vouchers not currently in process with posting/payment statuses such that vouchers can be Field Replaced. (Note: references existing Search view for single voucher delete component, VCHR_SRCH_DEL, as mass maintenance field replacement is subject to same restrictions as single voucher deletion.) |
| SELECT A.BUSINESS_UNIT , A.VOUCHER_ID FROM PS_VOUCHER A , PS_VCHR_DEL_ELIG B WHERE A.VOUCHER_STYLE IN ('ADJ', 'CORR', 'JRNL', 'PPAY', 'REG', 'RGTR', 'SGLP') AND NOT (A.VCHR_SRC = 'PROC' AND A.VAT_ENTITY <> ' ') AND NOT (A.VOUCHER_STYLE = 'RGTR' AND EXISTS ( SELECT 'X' FROM PS_VCHR_REG_LC I WHERE I.BUSINESS_UNIT = A.BUSINESS_UNIT AND I.VOUCHER_ID = A.VOUCHER_ID AND I.REG_CMPL_FLAG = 'N')) AND NOT EXISTS ( SELECT 'X' FROM PS_GRP_AP J WHERE J.BUSINESS_UNIT = A.BUSINESS_UNIT AND J.GRP_AP_ID = A.GRP_AP_ID AND J.GRP_AP_STATUS = 'V') AND B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.VOUCHER_ID = A.VOUCHER_ID |
| # | 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 |