BUSINESS_UNITVOUCHER_IDPYMNT_CNTINT_UNIT_PMT_VW(SQL View) |
Index Back |
|---|---|
Interunit Payment viewView that shows only those interunit payment PYMNT_VCHR_XREF rows - Source is BILL, Supplier is Interunit Supplier, Bank is a Netting Bank. |
| SELECT a.business_unit ,a.voucher_id ,a.pymnt_cnt FROM ps_pymnt_vchr_xref a , PS_VENDOR B , PS_VOUCHER C , PS_BANK_CD_TBL D WHERE A.REMIT_SETID = B.SETID AND A.REMIT_VENDOR = B.VENDOR_ID AND B.INTERUNIT_VNDR_FLG = 'Y' AND a.business_unit = c.business_unit AND a.voucher_id = c.voucher_id AND C.VCHR_SRC = 'BILL' AND A.BANK_SETID = D.SETID AND A.BANK_CD = D.BANK_CD AND D.BANK_TYPE = 'N' |
| # | 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 | PYMNT_CNT |
Number(5,0) | INTEGER NOT NULL | Payments |