REMIT_SETIDREMIT_VENDORVNDR_LOCRMT_BANK_SET_VW(SQL View) |
Index Back |
|---|---|
Remit Bank Set Vw |
| SELECT a.setid , a.vendor_id , a.vndr_loc , ' ' , b.descr FROM PS_VNDR_BANK_ACCT a , ps_setid_tbl b WHERE a.setid = b.setid AND effdt = ( SELECT MAX(a1.effdt) FROM PS_VNDR_BANK_ACCT a1 WHERE a.setid = a1.setid AND a.vendor_id = a1.vendor_id AND a.vndr_loc = a1.vndr_loc AND a1.effdt <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | REMIT_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Remit SetID |
| 2 | REMIT_VENDOR |
Character(10) | VARCHAR2(10) NOT NULL | Remit Vendor |
| 3 | VNDR_LOC |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 4 | BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL | The PeopleSoft tableset ID associated with a given bank/counterparty. |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |