Sales Analysis sourced measures and KPIs
This table shows the Sales Analysis measures that are sourced directly in Data Warehouse.
These measures can be analyzed by different time series. For the list of available time series measures, see Time.
Aggregations available are Avg, Max, Min, and Sum. For cases where this does not apply, the available aggregations are indicated in this table:
| Measure | Description |
|---|---|
| Invcd Net Amt – Transaction | Invoiced net line amount in the order currency |
| Invcd Net Amt – Division | Invoiced net line amount in the division currency |
| Invcd Net Amt – Company | Invoiced net line amount in the company currency |
| Invcd Gross Amt – Transaction | Net line amount plus discount amounts 1-6 in the order currency |
| Invcd Gross Amt – Division | Net line amount plus discount amounts 1-6 in the division currency |
| Invcd Gross Amt – Company | Net line amount plus discount amounts 1-6 in the company currency |
| Disc Amt 1 – Transaction | Discount amount 1 in the order currency |
| Disc Amt 1 – Division | Discount amount 1 in the division currency |
| Disc Amt 1 – Company | Discount amount 1 in the company currency |
| Disc Amt 2 – Transaction | Discount amount 2 in the order currency |
| Disc Amt 2 – Division | Discount amount 2 in the division currency |
| Disc Amt 2 – Company | Discount amount 2 in the company currency |
| Disc Amt 3 – Transaction | Discount amount 3 in the order currency |
| Disc Amt 3 – Division | Discount amount 3 in the division currency |
| Disc Amt 3 – Company | Discount amount 3 in the company currency |
| Disc Amt 4 – Transaction | Discount amount 4 in the order currency |
| Disc Amt 4 – Division | Discount amount 4 in the division currency |
| Disc Amt 4 – Company | Discount amount 4 in the company currency |
| Disc Amt 5 – Transaction | Discount amount 5 in the order currency |
| Disc Amt 5 – Division | Discount amount 5 in the division currency |
| Disc Amt 5 – Company | Discount amount 5 in the company currency |
| Disc Amt 6 – Transaction | Discount amount 6 in the order currency |
| Disc Amt 6 – Division | Discount amount 6 in the division currency |
| Disc Amt 6 – Company | Discount amount 6 in the company currency |
| Total Disc Amt – Transaction | Sum of discount amounts 1-6 in the order currency |
| Total Disc Amt – Division | Sum of discount amounts 1-6 in the division currency |
| Total Disc Amt – Company | Sum of discount amounts 1-6 in the company currency |
| Promotional Disc Amt – Transaction | Total discount amount due to promotions in the order currency |
| Promotional Disc Amt – Division | Total discount amount due to promotions in the division currency |
| Promotional Disc Amt – Company | Total discount amount due to promotions in the company currency |
| Bonus and Comm Amt – Transaction | Reserved bonus and commission amount in the order currency |
| Bonus and Comm Amt – Division | Reserved bonus and commission amount in the division currency |
| Bonus and Comm Amt – Company | Reserved bonus and commission amount in the company currency |
| Issued Cost Amt – Transaction | Cost amount at stock issue in the order currency |
| Issued Cost Amt – Division | Cost amount at stock issue in the division currency |
| Issued Cost Amt – Company | Cost amount at stock issue in the company currency |
| Gross Profit 1 – Transaction | Invoiced net amount minus the cost price in the order currency |
| Gross Profit 1 – Division | Invoiced net amount minus the cost price in the division currency |
| Gross Profit 1 – Company | Invoiced net amount minus the cost price in the company currency |
| Gross Profit 2 – Transaction | Invoiced net amount minus cost price, net costs 1-5, and reserved bonus and commission in the order currency |
| Gross Profit 2 – Division | Invoiced net amount minus cost price, net costs 1-5, and reserved bonus and commission in the division currency |
| Gross Profit 2 – Company | Invoiced net amount minus cost price, net costs 1-5, and reserved bonus and commission in the company currency |
| COGS Standard – Transaction | Total standard cost of the order line in the order currency |
| COGS Standard – Division | Total standard cost of the order line in the division currency |
| COGS Standard – Company | Total standard cost of the order line in the company currency |
| Net Cost 1 – Transaction | Net cost 1 in the order currency |
| Net Cost 1 – Division | Net cost 1 in the division currency |
| Net Cost 1 – Company | Net cost 1 in the company currency |
| Net Cost 2 – Transaction | Net cost 2 in the order currency |
| Net Cost 2 – Division | Net cost 2 in the division currency |
| Net Cost 2 – Company | Net cost 2 in the company currency |
| Net Cost 3 – Transaction | Net cost 3 in the order currency |
| Net Cost 3 – Division | Net cost 3 in the division currency |
| Net Cost 3 – Company | Net cost 3 in the company currency |
| Net Cost 4 – Transaction | Net cost 4 in the order currency |
| Net Cost 4 – Division | Net cost 4 in the division currency |
| Net Cost 4 – Company | Net cost 4 in the company currency |
| Net Cost 5 – Transaction | Net cost 5 in the order currency |
| Net Cost 5 – Division | Net cost 5 in the division currency |
| Net Cost 5 – Company | Net cost 5 in the company currency |
| Total Cost – Transaction | Cost price plus the total net cost in the order currency |
| Total Cost – Division | Cost price plus the total net cost in the division currency |
| Total Cost – Company | Cost price plus the total net cost in the company currency |
| Total Net Cost – Transaction | Sum of net costs 1-5 in the order currency |
| Total Net Cost – Division | Sum of net costs 1-5 in the division currency |
| Total Net Cost – Company | Sum of net costs 1-5 in the company currency |
| Invcd Qty | Invoiced quantity in basic unit of measure |
| Invcd Qty Alt Unit | Invoiced quantity in alternate unit of measure |
| Invcd Qty Sales Price Unit | Invoiced quantity in sales price unit of measure |
| Invcd Qty Stat Unit | Invoiced quantity in statistical unit of measure |
| No. of Lines | Number of invoiced lines Aggregations: Avg, Sum |
| Promoted | Number of lines with promotions applied Aggregations: Avg, Sum |
| Net Weight | Net weight of the item multiplied by the invoiced quantity |
| Gross Weight | Gross weight of the item multiplied by the invoiced quantity |
| Gross Weight – Threshold Unit | Competitor erosion weight threshold as defined per warehouse |
| Volume | Volume of the item multiplied by the invoiced quantity |
| Volume – Threshold Unit | Competitor erosion volume threshold as defined per warehouse |