POS_BNK_FLT_VW (SQL View)	Index Back
Position Source

POS_BNK_FLT_VW

(SQL View)

Position Source

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, D.STMT_BAL_FLOAT, D.STMT_BAL_FLOAT_DT FROM PS_BANK_ACCT_TBL A, PS_BNK_BALANCE_TBL B, PS_BANK_CD_TBL C, PS_BNK_BAL_FLT_TBL D 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 AND B.BNK_ID_NBR=D.BNK_ID_NBR AND B.BANK_ACCOUNT_NUM=D.BANK_ACCOUNT_NUM AND B.BANK_STMT_DT=D.BANK_STMT_DT

# 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 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

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.

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.

14 STMT_BAL_FLOAT Signed Number(28,3) DECIMAL(26,3) NOT NULL Bank Statement balance float. Used for Cash Float Analysis, a Treasury Cash Management feature for R8.

15 STMT_BAL_FLOAT_DT Date(10) DATE Float date. Used for Cash Float Analysis, a Treasury Cash Management feature for R8.

#	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	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
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.
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.
14	STMT_BAL_FLOAT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Bank Statement balance float. Used for Cash Float Analysis, a Treasury Cash Management feature for R8.
15	STMT_BAL_FLOAT_DT	Date(10)	DATE	Float date. Used for Cash Float Analysis, a Treasury Cash Management feature for R8.