BS_BKBAL_PD_EC

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	STATEMENT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Statement ID for bank statements, key on Bank Statement Header
2	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
3	BRANCH_ID	Character(10)	VARCHAR2(10) NOT NULL	The local branch office identifier associated with a given bank/counterparty.
4	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
5	BANK_BALANCE_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Bank Balance Type code
6	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.
7	BALANCE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Balance
8	ITEM_COUNT	Number(5,0)	INTEGER NOT NULL	Item Count
9	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
10	IMMEDIATE_BAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Available Balance
11	FLOAT1	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	One Day Float Balance
12	FLOAT2	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Two or More Days Float Balance
13	BSP_STMT_DT	Date(10)	DATE	Bank Statement Date
14	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
15	VALUE_DT	Date(10)	DATE	Equivalent to a deal transaction's settlement date.
16	BSP_PRCS_DT	Date(10)	DATE	Bank Statement Process Date
17	LOADED_SW	Character(1)	VARCHAR2(1) NOT NULL	An internal work field that indicates whether a given treasury transaction successfully has been imp Default Value: N