Sourced measures and KPIs
This table shows the measures that are sourced directly in Data Warehouse:
| Measure | Description |
|---|---|
| Bonus & Commission Amt | Reserved bonus and commission amount in the division currency |
| COGS Standard | Total standard cost of the order line in the division currency |
| Disc Amt 1 | Discount amount 1 |
| Disc Amt 2 | Discount amount 2 |
| Disc Amt 3 | Discount amount 3 |
| Disc Amt 4 | Discount amount 4 |
| Disc Amt 5 | Discount amount 5 |
| Disc Amt 6 | Discount amount 6 |
| Gross Profit 1 | Invoiced net amount minus the cost price |
| Gross Profit 2 | Invoiced net amount minus cost price, net costs 1-5, and reserved bonus and commission |
| Gross Weight | Gross weight of the item in the order line |
| Invcd Gross Amt | Net line amount plus discount amounts 1-6 in the division currency |
| Invcd Net Amt | Invoiced net line amount in the division currency |
| 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 |
| Invoiced Qty | Invoiced quantity in basic unit of measure |
| Issued Cost Amt | Cost amount at stock issue in the division currency |
| Net Cost 1 | Net cost 1 |
| Net Cost 2 | Net cost 2 |
| Net Cost 3 | Net cost 3 |
| Net Cost 4 | Net cost 4 |
| Net Cost 5 | Net cost 5 |
| Net Weight | Net weight of the item in the order line |
| No. of Lines | Number of invoiced lines |
| Order Currency Amt | Recorded amount in the order currency |
| Promoted | Number of lines with promotions applied |
| Promotional Disc Amt | Total discount amount due to promotions |
| Total Cost | Cost price plus the total net cost |
| Total Disc Amt | Sum of discount amounts 1-6 in the division currency |
| Total Net Cost | Sum of net costs 1-5 in the division currency |
| Volume | Volume of the item in the order line |