| View Name: | cmp_lsc_opp |
| View Number: | 5071 |
| Group: | Sales Mgr |
| Description: | Used by forms Source (S) Detail (9511), S Description (9512), Campaign (C) Detail (9521), (C) Description (9522), (C) Lead Source (9523), (C) Contact Import (9526), Campaign (11950) and others |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| opp_objid | opportunity | objid | opportunity object internal record number | 3 (UNIQUE) |
| cmp_objid | campaign | objid | campaign object internal record number | |
| lsc_objid | lead_source | objid | lead_source object internal record number | |
| login_name | user | login_name | User login name | |
| stage | gbst_lst | title | Condition of opportunity | |
| frcst_cls_amt | opportunity | frcst_cls_amount | Forecasted close amount of the opportunity | |
| frcst_cls_dt | opportunity | frcst_cls_dt | Forecasted close amount of the opportunity | |
| name | opportunity | name | Name given to the opportunity | |
| frcst_cls_prb | opportunity | frcst_cls_prb | Forcasted close probability of the opportunity |
| Join From | Join To |
|---|---|
| (lead_source).source2campaign | (campaign).campaign2lead_source |
| (opportunity).opp_sts2gbst_elm | (gbst_elm).status2opportunity |
| (opportunity).opp2lead_source | (lead_source).source2opportunity |
| (opportunity).opp_owner2user | (user).owner2opportunity |
| (gbst_elm).gbst_elm2gbst_lst | (gbst_lst).gbst_lst2gbst_elm |
| cmp_lsc_opp | |||