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 |