NET_BANK_SEQ_VW(SQL View) |
Index Back |
|---|---|
CUR ROWS FROM VNDR_BANK_ACCT |
| SELECT a.setid , a.vendor_id , a.vndr_loc , a.bank_acct_seq_nbr , a.bank_account_num , a.bank_acct_type , a.branch_id , a.descr , a.default_ind FROM PS_VNDR_BANK_ACCT a WHERE a.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 a.bank_acct_seq_nbr = a1.bank_acct_seq_nbr 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 | BANK_ACCT_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
An account attribute that describes the ostensible purposes of a given bank/counterparty account.
01=Time Deposit 03=Checking Account 05=Stock 06=Bond 07=Life Insurance Value 08=Retirement Account 10=Business Account 11=Trust Fund Account 12=Stock & Bond Account 13=Life Insurance Acct CA=Current Account CH=Charges Account DA=Demand Deposit LN=Loan RD=Return Items on DDA RS=Return Items-Savings SA=Settlement Account SV=Savings Account Z=Mutually Defined |
| 7 | BRANCH_ID | Character(10) | VARCHAR2(10) NOT NULL | The local branch office identifier associated with a given bank/counterparty. |
| 8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 9 | DEFAULT_IND | Character(1) | VARCHAR2(1) NOT NULL |
Default Election
N=No Y=Yes |