Measures

This table shows the production material measures:

Measure	Mapping	Note
Actual Amount	ticst001.aamt
Actual Amount Customer Owned	ticst001.aamu
Actual Quantity	ticst001.qucs
Actual Standard Cost	ticst001.cpcs
Actual Standard Cost Customer Owned	ticst001.cpcu
Amount Customer Owned Negative Variance	-1 * Amount Customer Owned Variance if negative else 0
Amount Customer Owned Positive Variance	Amount Customer Owned Variance if positive, else 0
Amount Customer Owned Variance	Estimate Amount Customer – Owned Actual Amount Customer Owned
Amount Negative Variance	-1 * Amount Variance if negative, else 0
Amount Positive Variance	Amount Variance if positive, else 0
Amount Variance	Estimate Amount – Actual Amount
Estimated Amount	Estimated Quantity * Estimated Unit Cost 0 if material is Floor Stock
Estimated Amount Customer Owned	Estimated Quantity * Estimated Cost Customer Owned 0 if material is Floor Stock
Estimated Cost Customer Owned	ticst001.cues
Estimated Quantity	ticst001.ques
Estimated Unit Cost	ticst001.cpes
Material Count Distinct	Distinct material count
Net Quantity	ticst001.qune
Production Material Count	Always 1 but 0 for null records
Production Order Count Distinct	Distinct production order count
Quantity Backflushed	ticst001.qbfd
Quantity Quarantined	ticst001.qqar
Quantity Rejected	ticst001.qtor
Quantity Scrapped	ticst001.qscr
Subsequent Delivery	ticst001.subd
To Issue	ticst001.issu
To Issue by Warehousing	ticst001.iswh
deleted	1 if deleted in LN, else 0	(1)

• (1) Deleted is a measure in this fact table; for production order and operation, deleted is an attribute in their dimensions.