RCN_BANK_ACCT

(SQL View)
Index Back

Bank Account Recon

This view is used in Force Reconciliation

SELECT A.SETID ,A.BANK_CD ,A.BRANCH_NAME ,A.BANK_ACCT_KEY ,C.BNK_ID_NBR ,B.BRANCH_ID ,A.BANK_ACCOUNT_NUM ,A.CURRENCY_CD ,A.BUSINESS_UNIT_GL ,B.COUNTRY ,A.RECON_TYPE_FLG ,A.RCN_ACCTG_SW FROM PS_BANK_ACCT_DEFN A ,PS_BANK_BRANCH_TBL B ,PS_BANK_CD_TBL C WHERE B.SETID=A.SETID AND B.BANK_CD=A.BANK_CD AND B.BRANCH_NAME=A.BRANCH_NAME AND C.SETID=A.SETID AND C.BANK_CD=A.BANK_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
3 BRANCH_NAME Character(10) VARCHAR2(10) NOT NULL Branch Name
4 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank
5 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
6 BRANCH_ID Character(10) VARCHAR2(10) NOT NULL The local branch office identifier associated with a given bank/counterparty.
7 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
9 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
10 COUNTRY_BANK Character(3) VARCHAR2(3) NOT NULL Bank Country
11 RECON_TYPE_FLG Character(1) VARCHAR2(1) NOT NULL Indicates which method has been utilized to reconcile a given source system transaction.
A=Automatic
M=Manual
N=None
S=Semi Manual
12 RCN_ACCTG_SW Character(1) VARCHAR2(1) NOT NULL Allows the user to indicate that the subject bank account's eligible transactions will generate ac