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..