FCT_CMPS_UNIT_PRICE_DETAIL_INSIGHT

Database

INSNZP01_WEALTH

Schema

WEALTHPADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PORTFOLIO_ID INTEGER 4
2 NAME CHARACTER VARYING(40) 40
3 AS_AT_DATE TIMESTAMP 8
4 BUY_UNIT_PRICE NUMERIC(18,6) 19
5 SELL_UNIT_PRICE NUMERIC(18,6) 19
6 NAV_UNIT_PRICE NUMERIC(18,6) 19
7 NAV_COST_UNIT_PRICE NUMERIC(18,6) 19
8 FEE_FREE_UNIT_PRICE NUMERIC(18,6) 19
9 TRANSFER_UNIT_PRICE NUMERIC(18,6) 19
10 GROSS_YIELD NUMERIC(7,4) 19
11 NET_YIELD NUMERIC(7,4) 19