BANK_BALANCES_C

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TEST_CASE	Character(30)	VARCHAR2(30) NOT NULL	BTF Test Case
2	COMPARE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Compare report type 1=Delta (Results v.s Expected) 2=Expected data not in Results 3=Unexpected data in Results
3	COMPARE_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Compare data source (Actuals or Expected results). A=Actuals E=Expected
4	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
5	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
6	RECON_CYCLE_NBR	Number(10,0)	DECIMAL(10) NOT NULL	The bank statement ID.
7	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
8	VALUE_DT	Date(10)	DATE	Equivalent to a deal transaction's settlement date.
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: BNK_RCN_CYC.CURRENCY_CD
10	BALANCE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Balance
11	IMMEDIATE_BAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Available Balance
12	FLOAT1	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	One Day Float Balance
13	FLOAT2	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Two or More Days Float Balance
14	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.
15	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
16	ITEM_COUNT	Number(5,0)	INTEGER NOT NULL	Item Count