fincompare_7

Database

prod_bank_wealth

Schema

sor_rdm

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 id integer 32
2 versionname character varying 150
3 versionnumber integer 32
4 version_id integer 32
5 versionflag character varying 150
6 name character varying 750
7 code character varying 750
8 changetrackingmask integer 32
9 gl_activity_code character varying 750
10 gl_activity_name character varying 750
11 gl_activity_id integer 32
12 gl_product_code character varying 750
13 gl_product_name character varying 750
14 gl_product_id integer 32
15 gl_class_code character varying 750
16 gl_class_name character varying 750
17 gl_class_id integer 32
18 gl_state_code character varying 750
19 gl_state_name character varying 750
20 gl_state_id integer 32
21 gl_channel_code character varying 750
22 gl_channel_name character varying 750
23 gl_channel_id integer 32
24 a_source_key1_code character varying 750
25 a_source_key1_name character varying 750
26 a_source_key1_id integer 32
27 a_source_key2_code character varying 750
28 a_source_key2_name character varying 750
29 a_source_key2_id integer 32
30 insfin05_l2_code character varying 750
31 insfin05_l2_name character varying 750
32 insfin05_l2_id integer 32
33 tm1_code character varying 750
34 tm1_name character varying 750
35 tm1_id integer 32
36 prod_struct1 character varying 300
37 prod_struct2 character varying 300
38 prod_struct3_code character varying 750
39 prod_struct3_name character varying 750
40 prod_struct3_id integer 32
41 prod_struct4_code character varying 750
42 prod_struct4_name character varying 750
43 prod_struct4_id integer 32
44 prod_struct5_code character varying 750
45 prod_struct5_name character varying 750
46 prod_struct5_id integer 32
47 prod_struct6_code character varying 750
48 prod_struct6_name character varying 750
49 prod_struct6_id integer 32
50 prod_lvlbal_code character varying 750
51 prod_lvlbal_name character varying 750
52 prod_lvlbal_id integer 32
53 prod_levbaldesc character varying 300
54 ccpp_l5_code character varying 750
55 ccpp_l5_name character varying 750
56 ccpp_l5_id integer 32
57 ccpp_l4 character varying 120
58 ccpp_l3 character varying 300
59 ccpp_l2 character varying 300
60 ccpp_l1 character varying 300
61 pcode_code character varying 750
62 pcode_name character varying 750
63 pcode_id integer 32
64 pcode_desc character varying 300
65 valuation_class character varying 300
66 comments character varying 300
67 validation_file_code character varying 750
68 validation_file_name character varying 750
69 validation_file_id integer 32
70 bv_ccpp_l3 character varying 150
71 bv_ccpp_l1 character varying 150
72 bv_ccpp_l4 character varying 150
73 bv_ccpp_l5_code character varying 750
74 bv_ccpp_l5_name character varying 750
75 bv_ccpp_l5_id integer 32
76 bv_ccpp_l2 character varying 150
77 policy_prefix_code character varying 9
78 enterdatetime timestamp without time zone
79 enterusername character varying 300
80 enterversionnumber integer 32
81 lastchgdatetime timestamp without time zone
82 lastchgusername character varying 300
83 lastchgversionnumber integer 32
84 validationstatus character varying 750