| View Name: | opp_summary_v |
| View Number: | 5742 |
| Group: | iSales opportunity |
| Description: | Opportunity overview page, to improve performance by cutting database round trips. |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
(double-click a column header to select column text)
View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| curr_objid | currency | objid | currency internal record number | |
| currency | currency | name | Name of the currency | |
| cycle_stage_objid | cycle_stage | objid | Cycle_stage internal record number | |
| frcst_cls_amt | opportunity | frcst_cls_amount | Forecasted close amount | |
| frcst_cls_dt | opportunity | frcst_cls_dt | Forecasted close date | |
| frcst_cls_prb | opportunity | frcst_cls_prb | Forecasted close probability | |
| id | opportunity | id | Opportunity ID number | |
| lead_source_objid | lead_source | objid | Lead_source internal record number | |
| life_cycle_objid | life_cycle | objid | Life_cycle internal record number | |
| name | opportunity | name | Name given to the opportunity | |
| objid | opportunity | objid | Opportunity internal record number | 3 (UNIQUE) |
| process_name | life_cycle | name | Name of the life cycle | |
| purch_date | opportunity | purch_date | When the opportunity is expected to close | |
| source_name | lead_source | name | Name of the lead source | |
| stage | cycle_stage | name | Name of the stage | |
| terr_name | territory | name | Name of the territory | |
| territory_objid | territory | objid | Territory internal record number |
Join From | Join To |
|---|---|
| (opportunity).opp2cycle_stage | (cycle_stage).stage2opportunity |
| (opportunity).opp2lead_source | (lead_source).source2opportunity |
| (opportunity).opp2territory | (territory).terr2opportunity |
| (opportunity).opp2currency | (currency).curr2opportunity |
| (opportunity).opp2life_cycle | (life_cycle).cycle2opportunity |
| opp_summary_v | |||