RBW_BALSHTS1_VW (SQL View)	Index Back
Dummy View for Balance Sheet This view is used for Scroll Level 1 of the Balance Sheet

RBW_BALSHTS1_VW

(SQL View)

Dummy View for Balance Sheet

This view is used for Scroll Level 1 of the Balance Sheet

SELECT ' ' ,' ' ,0 ,' ' FROM PS_INSTALLATION

# 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_TYPE2 Character(4) VARCHAR2(4) NOT NULL This is the asset type2 of the asset category table.

3 NET_WORTH Signed Number(30,4) DECIMAL(28,4) NOT NULL Net Worth of A Client in Wealth Management,

4 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.

#	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_TYPE2	Character(4)	VARCHAR2(4) NOT NULL	This is the asset type2 of the asset category table.
3	NET_WORTH	Signed Number(30,4)	DECIMAL(28,4) NOT NULL	Net Worth of A Client in Wealth Management,
4	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Currency Code value.