REMIT_SETIDREMIT_VENDORVNDR_LOCRMT_BANK_CD_VW(SQL View) |
Index Back |
|---|
| SELECT a.setid , a.vendor_id , a.vndr_loc , a.descr FROM PS_VNDR_BANK_ACCT a WHERE 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |