dSaleNarrow (new 2014-05-09)
This is the data table used to extract case details. It is mostly based on the sale table. This is what it looks like when we ship it:
| Based on (table.column) | Type | Column alias | Localised english name | Comment |
| sale.sale_id | P | SaleId | No. of sales | May be used to show nr. of cases when grouping is applied |
| Amount & earning | ||||
| sale.amount, currency.rate, currency.units | E | Amount | Amount | The amount is shown in the selected currency |
| sale.earning, currency.rate, currency.units | E | Earning | Earnings | The earning is shown in the selected currency |
| sale.heading | P | Heading | Title | Heading of the case |
| Rates (%) | ||||
| sale.status,sale.probability | E | CaseProbability(%) | Case probability (%) | Probability of this specific case - may be different than stage probability. |
| sale.status,prob.probability | E | StageProbability(%) | Stage probability (%) | Probability based on the stage the case is in |
| Special | ||||
| sale.sale_id | E | LinkSale | Sale dialog URL | Owl link to the sale dialog. The system variabels client_type, url_web and url_windows control the format of the URL generated. |
| sale.contact_id | E | LinkContact | Company dialog URL | Owl link to the company dialog. The system variabels client_type, url_web and url_windows control the format of the URL generated. |
| Category (these columns are set to be categories for charts) | ||||
| associate.deleted, person.lastname, person.firstname, person.middleName | P | PersonName(Last,First) | Person (Last,First) | Name of associate |
| usergrouperson.name | P | UsergroupName | Created by Group | Primary group of associate when the case was created |
| usergrouperson.name | P | UsergroupName(Persons) | Person's group | Current primary group of the associate |
| contact.name | P | ContactName | Contact | Name of contact |
| sale.saledate | P | Saledate | Sale date | Sale date |
| sale.saledate | P | Saledate2 | Sale date 2 | Used to create pivoted visualizations like This year vs. last year.. |
| sale.registered | P | Registered | Registered | Registered |
| sale.registered | P | Registered2 | Registered2 | Used to create pivoted visualizations like This year vs. last year.. |
