BNK_BALANCE_TBL (SQL Table)	Index Back
Bank Balance Table Bank Balance Table RJB 01/11/2001 Added Field for Summing the Interest Accrued Since Last Payment Schedule Date for Internal Accounts

BNK_BALANCE_TBL

(SQL Table)

Bank Balance Table

Bank Balance Table RJB 01/11/2001 Added Field for Summing the Interest Accrued Since Last Payment Schedule Date for Internal Accounts

Parent Record Of BNK_BAL_FLT_TBL BNK_SDFLOAT_TBL

# 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_AVAIL Signed Number(28,3) DECIMAL(26,3) NOT NULL The bank statement available balance as submitted by the bank.

5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Default Value: BNK_BAL_SRCH.CURRENCY_CD

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

7 STMT_BAL_OPEN_DT Date(10) DATE The bank statement opening balance date as submitted by the bank.

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

9 STMT_BAL_CLOSE_DT Date(10) DATE The bank statement closing balance date as submitted by the bank.

10 INT_BEARING_BAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Balance on which interest will be calculated

11 INTEREST_ACCRUAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Interest calculated

12 INT_ACCRD_SINCE_LP Signed Number(28,3) DECIMAL(26,3) NOT NULL RJB 1/11/01 Need field contain sum of daily interest accruals for those accruals that are not paid on a daily schedule.

13 INTEREST_RECALC_SW Character(1) VARCHAR2(1) NOT NULL Flag to identify to calculate interest

14 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

15 DTTM_STAMP_SEC DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	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_AVAIL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The bank statement available balance as submitted by the bank.
5	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: BNK_BAL_SRCH.CURRENCY_CD
6	STMT_BAL_OPEN	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The bank statement opening balance as submitted by the bank.
7	STMT_BAL_OPEN_DT	Date(10)	DATE	The bank statement opening balance date as submitted by the bank.
8	STMT_BAL_CLOSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The bank statement closing balance as submitted by the bank.
9	STMT_BAL_CLOSE_DT	Date(10)	DATE	The bank statement closing balance date as submitted by the bank.
10	INT_BEARING_BAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Balance on which interest will be calculated
11	INTEREST_ACCRUAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Interest calculated
12	INT_ACCRD_SINCE_LP	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	RJB 1/11/01 Need field contain sum of daily interest accruals for those accruals that are not paid on a daily schedule.
13	INTEREST_RECALC_SW	Character(1)	VARCHAR2(1) NOT NULL	Flag to identify to calculate interest
14	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
15	DTTM_STAMP_SEC	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.