VENDOR_SETIDVENDOR_IDAP_DISCTAKEN_VW(SQL View) |
Index Back |
|---|---|
Discount Taken ViewDiscount Taken View |
| SELECT B.VENDOR_SETID , B.VENDOR_ID , B.BUSINESS_UNIT , B.TXN_CURRENCY_CD , SUM(A.DSCNT_PAY_AMT) , COUNT(DISTINCT A.VOUCHER_ID) FROM PS_PYMNT_VCHR_XREF A , PS_VOUCHER B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID AND A.DSCNT_PAY_AMT > 0 GROUP BY B.VENDOR_SETID, B.VENDOR_ID, B.BUSINESS_UNIT, B.TXN_CURRENCY_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | VENDOR_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 2 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 5 | DSCNT_PAY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Payment Discount Amount |
| 6 | TOTALROWS | Number(7,0) | INTEGER NOT NULL | Row number |