SETIDVENDOR_IDPrompt Table: VENDOR_AR
TXN_CURRENCY_CDBUSINESS_UNITVR_BAL_AR_VW(SQL View) |
Index Back |
|---|---|
Supplier Balance View For AR |
| select a.vendor_setid, a.vendor_id, a.txn_currency_cd, a.business_unit, sum(b.pymnt_gross_amt), count(*) from PS_VOUCHER_AR a, ps_pymnt_xref_ar b where a.business_unit = b.business_unit and a.voucher_id = b.voucher_id and b.pymnt_selct_status = 'N' group by a.vendor_setid, a.vendor_id, a.txn_currency_cd, a.business_unit |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: VENDOR_AR |
| 3 | TXN_CURRENCY_CD |
Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
| 4 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 5 | GROSS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Invoice Amount |
| 6 | VCHR_COUNT | Number(6,0) | INTEGER NOT NULL | Count of Vouchers |