ASSET_LIAB_IDRBW_ASSET_C_VW(SQL View) |
Index Back |
|---|---|
View to return AssetThis view is used to return all assets of a client. |
| SELECT ' ' ,' ' ,' ' ,' ' ,' ' ,%CurrentDateOut ,' ' ,0 ,' ' ,' ' FROM PS_INSTALLATION |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ASSET_LIAB_ID |
Character(15) | VARCHAR2(15) NOT NULL | This is the primary key of the asset liability 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 | REGISTRATION_NAME | Character(50) | VARCHAR2(50) NOT NULL | Registration Name --------> FSI Account |
| 5 | WHERE_HELD | Character(50) | VARCHAR2(50) NOT NULL | Institution at which a certain asset is held |
| 6 | BEGIN_DATE | Date(10) | DATE | Begin Date |
| 7 | STOCK_SYMBOL | Character(10) | VARCHAR2(10) NOT NULL | This field is used to store the Stock Symbol |
| 8 | STOCK_QTY | Number(21,4) | DECIMAL(20,4) NOT NULL | This field is used to define the quantity of stock that a client owns. |
| 9 | CUST_ACCT_NBR | Character(20) | VARCHAR2(20) NOT NULL | This is the Customer defined Account Number for a financial account |
| 10 | FIN_ACCOUNT_ID | Character(20) | VARCHAR2(20) NOT NULL | Financial Account Number |