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 |