BUSINESS_UNITVOUCHER_IDAP_VCHR_AVAL_VW(SQL View) |
Index Back |
|---|---|
Sum voucher paid amountThis view is used in voucher inquiry component |
| SELECT C.BUSINESS_UNIT , C.VOUCHER_ID , SUM(C.AVAILABLE_AMT) FROM PS_PYMNT_VCHR_XREF B , PS_VCHR_PPAY_XREF C WHERE B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.VOUCHER_ID = C.VOUCHER_ID AND B.PYMNT_CNT = C.PYMNT_CNT AND C.PPAY_SEQNUM = ( SELECT MAX(CC.PPAY_SEQNUM) FROM PS_VCHR_PPAY_XREF CC WHERE CC.BUSINESS_UNIT = C.BUSINESS_UNIT AND CC.VOUCHER_ID = C.VOUCHER_ID AND CC.PYMNT_CNT = C.PYMNT_CNT) GROUP BY C.BUSINESS_UNIT, C.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 | AVAILABLE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Prepayment Available Amount |