Opportunity, basic calcs
000015 ·
Sales & Pipeline Planning
SetupSources: ows_tabella
- Workspace
-
004· Sales & Pipeline Planning - Type
- Virtual Dataset
- Status
- online
Fields 44Sources: ows_tabella_campo
| # | Code | Description | Type | Length | Default | Time rollup | Conversion | Key | Req | Dimension |
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | ID |
Opportunity ID | Text | 255 | — | — | — | — | — | — |
| 1 | SCENARIO |
Scenario | Text | — | — | — | — | — | — | SCENARIO |
| 2 | SALES_REP |
Sales Rep | Text | — | — | — | — | — | — | OWNER |
| 3 | PRESALE |
Pre-Sales REP | Text | 255 | — | — | — | — | — | — |
| 4 | TYPE |
Type | Text | 255 | — | — | — | — | — | — |
| 5 | PROSPECT |
Target Client | Text | — | — | — | — | — | — | PROSPECT |
| 6 | ENTITY |
Entity | Text | — | — | — | — | — | — | Entity;fr=Entité |
| 7 | ENTID |
Entity numeric ID | Text | 255 | — | — | — | — | — | — |
| 8 | ITEM |
Product Item | Text | 255 | — | — | — | — | — | — |
| 9 | PRODUCT |
Products | Text | — | — | — | — | — | — | Products;fr=Produit |
| 10 | UNITS |
Quantity | Number | 27,9 | 0 | Sum | None | — | — | — |
| 11 | STAGE |
Opportunity Stage | Text | — | — | — | — | — | — | STAGE |
| 12 | CHANGE |
Last status change | Date | — | — | — | — | — | — | — |
| 13 | COMPETITOR |
Primary Competitor | Text | — | — | — | — | — | — | COMPETITOR |
| 14 | VALUEPROP_AGE |
Value Proposition Age | Number | 27,9 | 0 | Sum | None | — | — | — |
| 15 | VALUEPROP_DATE |
Value Proposition Date | Date | — | — | — | — | — | — | — |
| 16 | DEMO_AGE |
Solution Demo / POC Age | Number | 27,9 | 0 | Sum | None | — | — | — |
| 17 | DEMO_DATE |
Solution Demo / POC Date | Date | — | — | — | — | — | — | — |
| 18 | PROPOSAL_AGE |
Proposal Age | Number | 27,9 | 0 | Sum | None | — | — | — |
| 19 | PROPOSAL_DATE |
Proposal Date | Date | — | — | — | — | — | — | — |
| 20 | REFERENCE_AGE |
Reference Check Age | Number | 27,9 | 0 | Sum | None | — | — | — |
| 21 | REFERENCE_DATE |
Reference Check Date | Date | — | — | — | — | — | — | — |
| 22 | VOC_AGE |
VOC Age | Number | 27,9 | 0 | Sum | None | — | — | — |
| 23 | VOC_DATE |
Vendor of Choice Date | Date | — | — | — | — | — | — | — |
| 24 | NEGOTIATION_AGE |
Contract Negotiation Age | Number | 27,9 | 0 | Sum | None | — | — | — |
| 25 | NEGOTIATION_DATE |
Contract Negotiation Date | Date | — | — | — | — | — | — | — |
| 26 | LEAKED_STAGE |
Stage Leaked (Stage precedente prima di perdere) | Text | 255 | — | — | — | — | — | — |
| 27 | PROBABILITY |
Probability | Number | 27,9 | — | Sum | None | — | — | — |
| 28 | CREATION |
Creation Date | Date | — | — | — | — | — | — | — |
| 29 | ACTIVITY |
Last Sales Actvity Date | Date | — | — | — | — | — | — | — |
| 30 | VALUE |
Value | Number | 27,9 | — | Sum | None | — | — | — |
| 32 | CURRENCY |
Currency | Text | — | — | — | — | — | — | VALUTA |
| 33 | CLOSE_DATE |
Estimated Close date | Date | — | — | — | — | — | — | — |
| 34 | PUSH |
Push Counter | Number | 27,9 | 0 | Sum | None | — | — | — |
| 35 | WINLOS_DATE |
Win/Loss Date | Date | — | — | — | — | — | — | — |
| 36 | LOST_REASON |
Lost Reason | Text | 255 | — | — | — | — | — | — |
| 37 | LOST_REASON_DESC |
Lost Reason Description | Text | 255 | — | — | — | — | — | — |
| 38 | WINLOS_TO |
Win/Lost To | Text | 255 | — | — | — | — | — | — |
| 39 | CHANNEL |
Channel | Text | — | — | — | — | — | — | CHANNEL |
| 40 | PERIOD |
Budget Month | Text | — | — | — | — | — | — | PERIODO |
| 41 | FCT_VERSION |
Forecast Version | Text | — | — | — | — | — | — | CATEGORIA |
| 42 | AGING |
Opportunity Aging | Text | 255 | — | Sum | None | — | — | — |
| 43 | WINLOS |
Win / Los | Text | 255 | — | Sum | None | — | — | — |
| 44 | INACTIVITY |
Pre-sale Activity Aging | Text | 255 | — | Sum | None | — | — | — |
Lineage
Read by 1
Written by 0
No DTPs write to this dataset.