BANK_BALANCES_E (SQL Table)	Index Back
BTF: Bank Balances This table will store the various types of balances we get on a Bank Statement. Eg; Opening , Closing , Available

BANK_BALANCES_E

(SQL Table)

BTF: Bank Balances

This table will store the various types of balances we get on a Bank Statement. Eg; Opening , Closing , Available

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TEST_CASE Character(30) VARCHAR2(30) NOT NULL BTF Test Case

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

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

4 RECON_CYCLE_NBR Number(10,0) DECIMAL(10) NOT NULL The bank statement ID.

5 BANK_STMT_CODE Character(8) VARCHAR2(8) NOT NULL Bank Statement code - used to identify the codes used on the bank statement for different entires of balances and transactions.
Prompt Table: BALANCE_CODE_VW

6 VALUE_DT Date(10) DATE Equivalent to a deal transaction's settlement date.

7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Default Value: BNK_RCN_CYC.CURRENCY_CD

8 BALANCE Signed Number(28,3) DECIMAL(26,3) NOT NULL Balance

9 IMMEDIATE_BAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Available Balance

10 FLOAT1 Signed Number(28,3) DECIMAL(26,3) NOT NULL One Day Float Balance

11 FLOAT2 Signed Number(28,3) DECIMAL(26,3) NOT NULL Two or More Days Float Balance

12 BANK_TRANS_CODE Character(20) VARCHAR2(20) NOT NULL A code that describes the type of transaction submitted by the bank via report or flat file.

13 FUNDS_TYPE Character(1) VARCHAR2(1) NOT NULL Funds Availability Type
0=Immediate Availability
1=One-day Availability
2=Two-or more-day Availability
D=Distributed Availability-vary
S=Distributed Availability-fixed
V=Value Dated
Z=unknown

14 ITEM_COUNT Number(5,0) INTEGER NOT NULL Item Count

15 DTTM_REFRESHED DateTime(26) TIMESTAMP Specifies the date and time of the last refresh of the expected results data. This field is used in the Batch Test Framework process.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TEST_CASE	Character(30)	VARCHAR2(30) NOT NULL	BTF Test Case
2	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
3	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
4	RECON_CYCLE_NBR	Number(10,0)	DECIMAL(10) NOT NULL	The bank statement ID.
5	BANK_STMT_CODE	Character(8)	VARCHAR2(8) NOT NULL	Bank Statement code - used to identify the codes used on the bank statement for different entires of balances and transactions. Prompt Table: BALANCE_CODE_VW
6	VALUE_DT	Date(10)	DATE	Equivalent to a deal transaction's settlement date.
7	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: BNK_RCN_CYC.CURRENCY_CD
8	BALANCE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Balance
9	IMMEDIATE_BAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Available Balance
10	FLOAT1	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	One Day Float Balance
11	FLOAT2	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Two or More Days Float Balance
12	BANK_TRANS_CODE	Character(20)	VARCHAR2(20) NOT NULL	A code that describes the type of transaction submitted by the bank via report or flat file.
13	FUNDS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Funds Availability Type 0=Immediate Availability 1=One-day Availability 2=Two-or more-day Availability D=Distributed Availability-vary S=Distributed Availability-fixed V=Value Dated Z=unknown
14	ITEM_COUNT	Number(5,0)	INTEGER NOT NULL	Item Count
15	DTTM_REFRESHED	DateTime(26)	TIMESTAMP	Specifies the date and time of the last refresh of the expected results data. This field is used in the Batch Test Framework process.