VCHR_AF_SCHD_VW(SQL View) |
Index Back |
|---|---|
Scheduled Pay Date viewVoucher minimum scheduled pay date view |
| SELECT a.business_unit , a.voucher_id , MIN(b.scheduled_pay_dt) FROM PS_VOUCHER a , ps_pymnt_vchr_xref b WHERE a.business_unit = b.business_unit AND a.voucher_id = b.voucher_id GROUP BY a.business_unit, 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 |
| 3 | SCHEDULED_PAY_DT | Date(10) | DATE | Scheduled to Pay |