| Table Name: | opp_analysis |
| Table Number: | 5152 |
| Group: | Sales Mgr |
| Description: | Competitive analysis for a single bus_org in an opportunity as of a particular date |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| as_of_date | CLK_TIME | datetime | As of date of the analysis | Search (1) | ||||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (2) |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| analysis2anyls_rspns | OTM | anlys_rspns | anlys_rspns2opp_analysis | Related data for the analysis | |||
| analysis2bus_org | MTO | bus_org | bus_org2opp_analysis | Organization being analyzed | Search (1) | ||
| analysis2opportunity | MTO | opportunity | opp2opp_analysis | Opportunity being analyzed | Search (1) |
| Index Name | Fields | Flags |
|---|
| Index Name | Fields | Additional Information |
|---|---|---|
| a2bo5152 | analysis2bus_org, analysis2opportunity | nonclustered located on PRIMARY |
| ind_analysis2opportunity | analysis2opportunity, analysis2bus_org | nonclustered located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 5168 | oppanly_v | bus_org, opp_analysis, opportunity |
| 5169 | anlysrspn_v | anlys_rspns, opp_analysis, question |
| opp_analysis | |||