MSCM - Mobile Par and Cycle Count measures
Par and Cycle Count
Event Header
| Measure name | Source table / calculation |
|---|---|
| Event Header Number of Month | Distinct count of months based on MSCM_EVENT_HEADER.CREATION_DT |
| Event Header Count | Count of MSCM_EVENT_HEADER.EVENT_HEADER_ID |
Event Detail
| Measure name | Source table / calculation |
|---|---|
| Event Detail Count | Count of EventDetailKey |
| Event Detail Quantity | MSCM_EVENT_DETAIL.QUANTITY |
| Event Detail Cost | MSCM_EVENT_DETAIL.COST |
| Requested Quantity |
MSCM_EVENT_DETAIL.EVENT_DETAIL_GN_01 - MSCM_EVENT_DETAIL.QUANTITY When Event Type IN ('PAR count activities', 'PAR count additional quantity activities') |
Event Detail Par Location Item
| Measure name | Source table / calculation |
|---|---|
| Event Detail QOH | MSCM Event Detail.MSCM Event Detail Quantity When Event Header.Event Type = 'PAR count activities' |
| Event Detail Std Cost | MSCM Location Item.MSCM Loc Item Std Cost When Event Type IN ('PAR count activities', 'PAR count additional quantity activities') |
| On Hand Cost | MSCM Event Detail.MSCM Event Detail Quantity * MSCM Location Item.MSCM Loc Item Std Cost When Event Header.Event Type = 'PAR count activities' |
| Par Cost | MSCM Event Detail.Event Detail Number Col 1 * MSCM Location Item.MSCM Loc Item Std Cost When Event Header.Event Type = 'PAR count activities' |