TR_AVF_AC_VW (SQL View)	Index Back
AVF Actual View AVF Actual View

TR_AVF_AC_VW

(SQL View)

AVF Actual View

SELECT DISTINCT A1.BANK_CD , A1.BANK_ACCT_KEY , C1.BNK_ID_NBR , A1.BANK_ACCOUNT_NUM , D.STMT_BAL_AVAIL , D.STMT_BAL_CLOSE , D.STMT_BAL_OPEN , D.TARGET_BALANCE , D.TOTAL_RECEIPTS , D.TOTAL_PAYMENTS , D.CURRENCY_CD FROM PS_BANK_BRANCH_TBL B , PS_BANK_BAL_DAILY D LEFT OUTER JOIN PS_BANK_CD_TBL C1 ON D.BNK_ID_NBR = C1.BNK_ID_NBR , PS_BANK_BAL_DAILY E LEFT OUTER JOIN PS_BANK_ACCT_DEFN A1 ON E.BANK_ACCOUNT_NUM = A1.BANK_ACCOUNT_NUM WHERE B.SETID = A1.SETID AND B.BANK_CD = A1.BANK_CD AND B.BRANCH_NAME = A1.BRANCH_NAME AND D.BNK_ID_NBR = E.BNK_ID_NBR AND D.BANK_ACCOUNT_NUM = E.BANK_ACCOUNT_NUM AND C1.SETID = A1.SETID AND C1.BANK_CD = A1.BANK_CD AND A1.BANK_CD_CPTY = A1.BANK_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 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

3 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.

4 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.

5 STMT_BAL_AVAIL Signed Number(28,3) DECIMAL(26,3) NOT NULL The bank statement available balance as submitted by the bank.

6 STMT_BAL_CLOSE Signed Number(28,3) DECIMAL(26,3) NOT NULL The bank statement closing balance as submitted by the bank.

7 STMT_BAL_OPEN Signed Number(28,3) DECIMAL(26,3) NOT NULL The bank statement opening balance as submitted by the bank.

8 TARGET_BALANCE Signed Number(28,3) DECIMAL(26,3) NOT NULL The target bank account balance assigned to a given bank account.

9 TOTAL_RECEIPTS Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Receipts

10 TOTAL_PAYMENTS Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Payments

11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
2	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
3	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
4	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
5	STMT_BAL_AVAIL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The bank statement available balance as submitted by the bank.
6	STMT_BAL_CLOSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The bank statement closing balance as submitted by the bank.
7	STMT_BAL_OPEN	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The bank statement opening balance as submitted by the bank.
8	TARGET_BALANCE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The target bank account balance assigned to a given bank account.
9	TOTAL_RECEIPTS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Receipts
10	TOTAL_PAYMENTS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Payments
11	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code