RBW_CHK_HSUM_L (SQL View)	Index Back
Checking Holding summary This view represents checking holding summary for a client

RBW_CHK_HSUM_L

(SQL View)

Checking Holding summary

This view represents checking holding summary for a client

SELECT AST.ASSET_CATEG_ID , LANGUAGE_CD ,ASTL.ASSET_CAT_DESCR FROM PS_RBW_ASSET_CATEG AST , PS_RBW_CATDEF_LNG ASTL WHERE AST.ASSET_TYPE2 = ASTL.ASSET_CAT_TYPE

Related Language Record for RBW_CHK_HSUM

# 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 ASSET_CAT_DESCR Character(40) VARCHAR2(40) NOT NULL Asset category Type description

#	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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	ASSET_CAT_DESCR	Character(40)	VARCHAR2(40) NOT NULL	Asset category Type description