BNK_SDBAL_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.
2	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
3	RECON_CYCLE_NBR	Number(10,0)	DECIMAL(10) NOT NULL	The bank statement ID.
4	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
5	VALUE_DT	Date(10)	DATE	Equivalent to a deal transaction's settlement date. Default Value: %DATE
6	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: BNK_RCN_CYC.CURRENCY_CD
7	BALANCE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Balance
8	IMMEDIATE_BAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Available Balance
9	FLOAT1	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	One Day Float Balance
10	FLOAT2	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Two or More Days Float Balance
11	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.
12	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
13	ITEM_COUNT	Number(5,0)	INTEGER NOT NULL	Item Count