Measures

This table shows the service coverage term measures:

Measure Mapping
Actual Margin Spent Sales Amount - Spent Cost Amount
Allocated Cost Amount tsctm120.alco
Allocated Sales Amount tsctm120.alsa
Budgeted Cost Amount tsctm120.camt
Budgeted Sales Amount tsctm120.amnt
Estimated Allocated Cost Amount tsctm120.ealc
Estimated Allocated Sales Amount tsctm120.eals
Estimated Margin Budgeted Sales Amount - Budgeted Cost Amount
Percentage Actual Margin Actual Margin / Spent Sales Amount
Percentage Estimated Margin Estimated Margin / Budgeted Sales Amount
Percentage Spent Cost (Spent Cost Amount + Estimated Allocated Cost Amount + Allocated Cost Amount) / Budgeted Cost Amount
Percentage Spent Sales (Spent Sales Amount + Estimated Allocated Sales Amount + Allocated Sales Amount) / Budgeted Sales Amount
Service Coverage Term Count Always 1, but 0 for null records
Spent Cost Amount tsctm120.spco
Spent Sales Amount tsctm120.spsa
deleted 1 if deleted in LN, else 0