FCT_CMPS_TRANSHIST_SUPER_DETAIL_INSIGHT

Database

INSNZP01_WEALTH

Schema

WEALTHPADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ACCOUNT_ID INTEGER 4
2 TRANSACTION_ID INTEGER 4
3 COMPONENT_ID INTEGER 4
4 NAME CHARACTER VARYING(40) 40
5 PRE_DAYS INTEGER 4
6 POST_DAYS INTEGER 4
7 EARLIEST_FUND_START_DATE TIMESTAMP 8
8 EARLIEST_SERVICE_DATE TIMESTAMP 8
9 MIN_MAX_RECALC_FLAG CHARACTER(1) 1
10 PRE94_FLAG CHARACTER(1) 1
11 PRESERVED_AMOUNT NUMERIC(18,2) 19
12 RESTRICTED_AMOUNT NUMERIC(18,2) 19
13 UNRESTRICTED_AMOUNT NUMERIC(18,2) 19
14 AMOUNT NUMERIC(18,2) 19
15 COMPONENT_AMOUNT NUMERIC(18,2) 19