FCT_CMPS_TRANSACTION_HISTORY_DETAIL_INSIGHT

Database

INSNZP01_WEALTH

Schema

WEALTHPADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ACCOUNT_TYPE CHARACTER VARYING(16) 16
2 PARTY_TYPE_ID INTEGER 4
3 PARTY_NAME CHARACTER VARYING(40) 40
4 ACCOUNT_ID INTEGER 4
5 NAME CHARACTER VARYING(122) 122
6 TRANSACTION_ID INTEGER 4
7 PRODUCT_TYPE_ID INTEGER 4
8 ASSOCIATED_TRANSACTION_ID INTEGER 4
9 EFFECTIVE_DATETIME TIMESTAMP 8
10 TRANSACTION_TYPE_NAME CHARACTER VARYING(40) 40
11 AMOUNT NUMERIC(18,2) 19
12 NOTATION CHARACTER VARYING(255) 255
13 TRANSACTION_DATETIME TIMESTAMP 8
14 USER_NAME CHARACTER VARYING(40) 40
15 STATUS CHARACTER VARYING(16) 16
16 PORTSPL_PORTFOLIO_ID INTEGER 4
17 PORT_PORTFOLIO_ID INTEGER 4
18 PORTFOLIO_NAME CHARACTER VARYING(73) 73
19 PORTFOLIO_AMOUNT NUMERIC(18,2) 19
20 PORTFOLIO_UNITS NUMERIC(18,6) 19
21 COMPONENT_NAME CHARACTER VARYING(40) 40
22 COMPONENT_AMOUNT NUMERIC(18,2) 19
23 CONTRIBUTION_TYPE CHARACTER VARYING(40) 40
24 DISBURSEMENT_RULE_ID INTEGER 4
25 CORRESPONDENCE_ID INTEGER 4
26 PRESERVED_AMOUNT NUMERIC(18,2) 19
27 INSURANCE_COVER_ID INTEGER 4
28 INSURANCE_CLAIM_ID INTEGER 4
29 DISTRIBUTION_ID INTEGER 4
30 GST_AMOUNT NUMERIC(12,2) 19
31 ADVISER_ACCOUNT_ID INTEGER 4
32 CGT_PAYABLE_FLAG CHARACTER(1) 1
33 COMPLYING_FUND CHARACTER VARYING(80) 80
34 DEDUCTIBLE_AMOUNT NUMERIC(18,2) 19
35 NOTIONAL_DEDUCTIBLE_AMOUNT NUMERIC(18,2) 19
36 TAX_CATEGORY CHARACTER(38) 38
37 REBATE_AMOUNT NUMERIC(18,2) 19
38 EXTRA_TAX_AMOUNT NUMERIC(18,2) 19
39 SURCHARGE_FINANCIAL_YEAR INTEGER 4
40 SURCHARGE_ALLOCATED_SURPLUS NUMERIC(18,2) 19
41 SURCHARGE_OTHER_CONTS NUMERIC(18,2) 19
42 SURCHARGE_EMPLOYER_CONTS NUMERIC(18,2) 19
43 SURCHARGE_PERSONAL_CONTS NUMERIC(18,2) 19
44 SURCHARGE_ALL_CONTRIBUTIONS NUMERIC(18,2) 19
45 ROLLOVER_SPIN_CODE CHARACTER VARYING(9) 9
46 ROLLOVER_ACCOUNT_IDENT CHARACTER VARYING(16) 16
47 ROLLOVER_CLIENT_IDENT CHARACTER VARYING(16) 16