Sourced measures and KPIs

This table shows the measures that are sourced directly in Data Warehouse.

Available aggregations for the measures are Avg, Max, Min, and Sum.

Measure	Description
Amt Item File	Amount based on sales price in item file in the division currency
Bonus and Commission Amt	Reserved bonus and commission amount in the division currency
Cost Price	Standard cost of the item calculated per item/facility 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 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
Promotional Disc Amt	Total discount amount due to promotions in the division currency
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