REMIT_SETIDREMIT_VENDORVNDR_LOCRMT_BNK_ACCT_VW(SQL View) |
Index Back |
|---|
| SELECT a.setid , a.vendor_id , a.vndr_loc , a.bank_acct_seq_nbr , a.bank_account_num , 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 | BANK_ACCT_SEQ_NBR | Number(3,0) | SMALLINT NOT NULL | Bank Account Sequence Number |
| 5 | BANK_ACCOUNT_NUM | Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given bank/counterparty account. |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |