BNK_BAL_FLT_TBL (SQL Table)	Index Back
Bank Balance Float Table Bank Balance Float Table. Used for float analysis, a Treasury Cash Management feature for R8.

BNK_BAL_FLT_TBL

(SQL Table)

Bank Balance Float Table

Bank Balance Float Table. Used for float analysis, a Treasury Cash Management feature for R8.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
Default Value: BANK_CD_TBL.BNK_ID_NBR

2 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
Default Value: BNK_BAL_SRCH.BANK_ACCOUNT_NUM

3 BANK_STMT_DT Date(10) DATE NOT NULL "The bank statement date

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

5 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.

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty. Default Value: BANK_CD_TBL.BNK_ID_NBR
2	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account. Default Value: BNK_BAL_SRCH.BANK_ACCOUNT_NUM
3	BANK_STMT_DT	Date(10)	DATE NOT NULL	"The bank statement date
4	STMT_BAL_FLOAT_DT	Date(10)	DATE NOT NULL	Float date. Used for Cash Float Analysis, a Treasury Cash Management feature for R8.
5	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.
6	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code