RBF_CMP_CHK_HLD

(SQL View)
 Index Back

Checking Holding

This view displays Checking holdings of a Company in Customer Summary page (RBF_CUST_SUM_PGT)

SELECT AST.ASSET_CATEG_ID , AST.ASSET_TYPE2 ,ASSET_TYPE3 , ' ' ,OWN.FIN_ACCOUNT_ID ,OWN.REGISTRATION_NAME ,OWN.WHERE_HELD ,OWN.BEGIN_DATE , BO_ID_OWNER , AVAIL_BALANCE ,OWN.CURRENCY_CD , 0 , OWN.CUST_ACCT_NBR ,'Y' FROM PS_RBF_CHECK_ACCT CHK , PS_RBW_ASSET_CATEG AST , PS_RBF_FACT_CMP_VW OWN WHERE OWN.FIN_ACCOUNT_ID = CHK.FIN_ACCOUNT_ID AND CHK.ASSET_CATEG_ID = AST.ASSET_CATEG_ID

# 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 ASSET_TYPE3 Character(4) VARCHAR2(4) NOT NULL This is the asset type3 of the asset category table.
4 STOCK_SYMBOL Character(10) VARCHAR2(10) NOT NULL This field is used to store the Stock Symbol
5 FIN_ACCOUNT_ID Character(20) VARCHAR2(20) NOT NULL Financial Account Number
6 REGISTRATION_NAME Character(50) VARCHAR2(50) NOT NULL Registration Name --------> FSI Account
7 WHERE_HELD Character(50) VARCHAR2(50) NOT NULL Institution at which a certain asset is held
8 BEGIN_DATE Date(10) DATE Begin Date
9 BO_ID_OWNER Number(31,0) DECIMAL(31) NOT NULL Financial Account Business Object ID
10 CURRENT_BALANCE Signed Number(30,4) DECIMAL(28,4) NOT NULL this field is used to reflect Current Balance of a FSI account
11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.
12 STOCK_QTY Number(21,4) DECIMAL(20,4) NOT NULL This field is used to define the quantity of stock that a client owns.
13 CUST_ACCT_NBR Character(20) VARCHAR2(20) NOT NULL This is the Customer defined Account Number for a financial account
14 YES_NO Character(1) VARCHAR2(1) NOT NULL Indicator flag -- Yes (Y) or No (N)
N=No
Y=Yes