Planned Mark. Campaigns
000004 ·
Sales & Pipeline Planning
SetupSources: ows_tabella
- Workspace
-
004· Sales & Pipeline Planning - Type
- Dataset
- Status
- online
Fields 9Sources: ows_tabella_campo
| # | Code | Description | Type | Length | Default | Time rollup | Conversion | Key | Req | Dimension |
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | SCENARIO |
Scenario | Text | — | — | — | — | — | — | SCENARIO |
| 1 | ENTITY |
Entity name | Text | — | — | — | — | — | — | Entity;fr=Entité |
| 2 | CAMPAIGN |
Marketing Campaign | Text | 255 | — | — | — | — | — | — |
| 3 | TYPE |
Type of Campaign | Text | 30 | — | — | — | — | — | — |
| 4 | PROD_CATEGORY |
Product category | Text | 30 | — | — | — | — | — | — |
| 5 | REGION |
Region | Text | 30 | — | — | — | — | — | — |
| 6 | START_DATE |
Start Date | Date | — | — | — | — | — | — | — |
| 7 | DURATION |
Duration | Number | 27,9 | — | Sum | None | — | — | — |
| 8 | COST |
Expected Cost | Number | 27,9 | — | Sum | None | — | — | — |
Lineage
Read by 0
No DTPs read this dataset.
Written by 0
No DTPs write to this dataset.
Used in Forms 1
Sources: prospetto_xml
| Form | Form description | Sheet | Matrix |
|---|---|---|---|
AW_004_000004 |
Planned Mark. Campaigns | DATASET | Matrix |
Quick Data Loader Mappings 1
Sources: qdl_mapping
| QDL Code | Description | Type | Options |
|---|---|---|---|
DB_AW_000004_000001 |
Retrieving planned Campaigns | DB_AW |
SOURCE_FILE_LOCATION=UPLOAD, SOURCE_DB_OBJECT=SPL_05, TARGET_TYPE=AW, SOURCE_FILE_TYPE=XLSX, SOURCE_FILE_SEPARATOR=COMMA, LOADING_POLICY=DELETE_FOR_FILTER_AND_INSERT, TARGET_AW=XSCCFICEZJSIWGO, TARGET_AW_TABLE=QRSXQUGPANSGCOB, SOURCE_TYPE=DATABASE
|