RBW_BALSHTS4_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ASSET_CATEG_ID	Character(15)	VARCHAR2(15) NOT NULL	This field is the primary key for Asset category table
2	ASSET_LIAB_ID	Character(15)	VARCHAR2(15) NOT NULL	This is the primary key of the asset liability table
3	FIN_ACCOUNT_ID	Character(20)	VARCHAR2(20) NOT NULL	Financial Account Number
4	ASSET_TYPE3	Character(4)	VARCHAR2(4) NOT NULL	This is the asset type3 of the asset category table.
5	REGISTRATION_NAME	Character(50)	VARCHAR2(50) NOT NULL	Registration Name --------> FSI Account
6	WHERE_HELD	Character(50)	VARCHAR2(50) NOT NULL	Institution at which a certain asset is held
7	CUST_ACCT_NBR	Character(20)	VARCHAR2(20) NOT NULL	This is the Customer defined Account Number for a financial account
8	BEGIN_DATE	Date(10)	DATE	Begin Date
9	STOCK_SYMBOL	Character(10)	VARCHAR2(10) NOT NULL	This field is used to store the Stock Symbol
10	STOCK_QTY	Number(21,4)	DECIMAL(20,4) NOT NULL	This field is used to define the quantity of stock that a client owns.
11	CURRENT_BALANCE	Signed Number(30,4)	DECIMAL(28,4) NOT NULL	this field is used to reflect Current Balance of a FSI account
12	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Currency Code value.
13	YES_NO	Character(1)	VARCHAR2(1) NOT NULL	Indicator flag -- Yes (Y) or No (N) N=No Y=Yes