BNK_BAL_AAA_VW

(SQL View)
 Index Back

Bank Account Register View


SELECT A.SETID , A.BANK_CD , A.BANK_ACCT_KEY , B.BANK_STMT_DT , B.BNK_ID_NBR , A.BANK_ACCOUNT_NUM , A.BUSINESS_UNIT_GL , B.STMT_BAL_AVAIL , A.CURRENCY_CD , B.STMT_BAL_OPEN , B.STMT_BAL_OPEN_DT , B.STMT_BAL_CLOSE , B.STMT_BAL_CLOSE_DT FROM PS_BANK_ACCT_TBL A , PS_BNK_BALANCE_TBL B , PS_BANK_CD_TBL C WHERE A.BANK_CD = C.BANK_CD AND A.SETID = C.SETID AND C.BNK_ID_NBR = B.BNK_ID_NBR AND A.SETID = C.SETID AND A.BANK_ACCOUNT_NUM=B.BANK_ACCOUNT_NUM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

2 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code

Prompt Table: BANK_CD_TBL

3 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
4 BANK_STMT_DT Date(10) DATE "The bank statement date

Default Value: %DATE

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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
8 STMT_BAL_AVAIL Signed Number(28,3) DECIMAL(26,3) NOT NULL The bank statement available balance as submitted by the bank.
9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
10 STMT_BAL_OPEN Signed Number(28,3) DECIMAL(26,3) NOT NULL The bank statement opening balance as submitted by the bank.
11 STMT_BAL_OPEN_DT Date(10) DATE The bank statement opening balance date as submitted by the bank.

Default Value: %DATE

12 STMT_BAL_CLOSE Signed Number(28,3) DECIMAL(26,3) NOT NULL The bank statement closing balance as submitted by the bank.
13 STMT_BAL_CLOSE_DT Date(10) DATE The bank statement closing balance date as submitted by the bank.

Default Value: %DATE