RMT_BANK_SEQ_VW

(SQL View)
 Index Back

Supplier Bank Accounts


SELECT A.SETID , A.VENDOR_ID , A.VNDR_LOC , A.BANK_ACCT_SEQ_NBR , A.BNK_ID_NBR , A.BANK_ACCOUNT_NUM , A.BRANCH_ID , A.DESCR , A.DEFAULT_IND , A.BENEF_BRANCH , A.BENEFICIARY_BANK , A.COUNTRY , A.BANK_ID_QUAL , A.BANK_ACCT_TYPE , A.CHECK_DIGIT , A.DFI_ID_QUAL , A.DFI_ID_NUM , A.IBAN_CHECK_DIGIT , A.IBAN_ID FROM PS_VNDR_BANK_ACCT A , PS_VENDOR_LOC B WHERE A.SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.VNDR_LOC = B.VNDR_LOC AND A.EFFDT = B.EFFDT AND B.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_VENDOR_LOC 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 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
6 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
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

Y/N Table Edit

10 BENEF_BRANCH Character(30) VARCHAR2(30) NOT NULL Beneficiary Branch field
11 BENEFICIARY_BANK Character(30) VARCHAR2(30) NOT NULL The bank/counterparty associated with a given beneficiary.
12 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
13 BANK_ID_QUAL Character(3) VARCHAR2(3) NOT NULL "A bank/counterparty attribute that determines
14 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
15 CHECK_DIGIT Character(2) VARCHAR2(2) NOT NULL Check Digit
16 DFI_ID_QUAL Character(2) VARCHAR2(2) NOT NULL A banking industry convention identifier utilized to drive data validation for a given bank/counterparty.
01=Transit Number
02=Swift ID/BIC
03=CHIPS Participant ID
04=Canadian Bank Branch/Institute
05=CHIPS Universal ID
ZZ=Mutually Defined
17 DFI_ID_NUM Character(12) VARCHAR2(12) NOT NULL A banking industry convention identifier utilized to drive electronic settlements processing for a given bank/coun
18 IBAN_CHECK_DIGIT Character(2) VARCHAR2(2) NOT NULL IBAN Check Digit
19 IBAN_ID Character(34) VARCHAR2(34) NOT NULL IBAN - Internation Bank Account Number is used in European countries to uniquely identify Bank accounts across borders