crmd_opportunities

Database

prod_bank_wealth

Schema

sor_crmd

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 crmd_oppor_hiid bigint 64
2 run_date timestamp without time zone
3 delta_type character varying 3
4 opportunity_id character varying 90
5 assoc_campaign character varying 90
6 assoc_contact character varying 90
7 contact_id character varying 90
8 product_interest character varying 150
9 approved character varying 3
10 approved_by character varying 90
11 business_customer character varying 90
12 customer_segment character varying 90
13 consent character varying 15
14 description character varying 48000
15 enterprise_owner_id character varying 120
16 enterprise_owner_name character varying 120
17 expected_close_date timestamp without time zone
18 fee_quote character varying 60
19 lead_source character varying 90
20 next_step character varying 12000
21 opportunity_name character varying 600
22 opportunity_type character varying 120
23 owner character varying 300
24 contact_last_name character varying 150
25 priority character varying 90
26 probability character varying 60
27 reason_won_lost_1 character varying 90
28 reason_won_lost_2 character varying 90
29 rate_quote character varying 60
30 submit_for_approval character varying 3
31 take_ownership character varying 3
32 sales_amount character varying 60
33 sales_stage character varying 90
34 created_by character varying 300
35 created_user character varying 60
36 created_ts timestamp without time zone
37 modified_ts timestamp without time zone
38 modified_user character varying 60
39 effective_strt_dt timestamp without time zone
40 effective_end_dt timestamp without time zone