MSCM - Receiving and Delivery measures
Dock Logging
Dock Log
| Measure name | Source table / calculation |
|---|---|
| Dock Log Count | Count of MSCM_DOCKLOG.DOCKLOG_ID |
| Dock Log Package Count | MSCM_DOCKLOG.COUNT |
| Dock Log Number of Operator | Distinct count of MSCM_DOCKLOG.USER_ID |
| Dock Log Number of Month | Distinct count of months based on MSCM_DOCKLOG.CREATE_DT |
Dock Log Line
| Measure name | Source table / calculation |
|---|---|
| Dock Log Line Count | Count of DockLogLineKey |
| Dock Log Number of Month | Distinct count of months based on MSCM_DOCKLOG.CREATE_DT |
Purchase Order Receiving
PO Header
| Measure name | Source table / calculation |
|---|---|
| Closed Line Count | MSCM_PO_HEADER.CLOSED_LINE |
| PO Count | Count of MSCM_PO_HEADER.PO_ID |
| Total Line Count | MSCM_PO_HEADER.TOTAL_LINES |
PO Line
| Measure name | Source table / calculation |
|---|---|
| PO Line Count | Count of MSCM_PO_LINE.LINE_ID |
| PO Line Remaining Quantity | MSCM_PO_LINE.REM_QTY |
| PO Line Received Quantity | MSCM_PO_LINE.REC_QTY |
| PO Line Ordered Quantity | MSCM_PO_LINE.ORD_QTY |
PO Line Receipt Record
| Measure name | Source table / calculation |
|---|---|
| PO Line Receipt Record Count | Count of PurchaseOrderLineReceiptRecordKey |
| Received Quantity | MSCM_PO_LINE_RECEIPT_RECORD.RCV_QTY |
PO Receipt
| Measure name | Source table / calculation |
|---|---|
| Number of Months | Distinct count of months based on MSCM_PO_RECEIPT.REC_DATE |
| PO Receipt Count | Count of PurchaseOrderReceiptKey |
| No of Operator | Count of distinct MSCM_PO_RECEIPT.RELEASED_BY |
Miscellaneous Receiving
Receipt Header
| Measure name | Source table / calculation |
|---|---|
| Miscellaneous Receipt Count | Count of MSCM_RECEIPT_HEADER.RECEIPT_ID |
| Miscellaneous Receipt Number of Month | Count of distinct months based on MSCM_RECEIPT_HEADER.RETURN_TIME |
| Miscellaneous Receipt Number of Operator | Count of distinct MSCM_RECEIPT_HEADER.USER_ID |
Receipt Line
| Measure name | Source table / calculation |
|---|---|
| Miscellaneous Receipt Line Count | Count of ReceiptLineKey |
| Miscellaneous Received Quantity | MSCM_RECEIPT_LINE.QTY_RECEIVED |
All Receipts
| Measure name | Source table / calculation |
|---|---|
| Total Receipt Count | Total Count of PO Receipt and Miscellaneous Receipt from MSCM_PO_RECEIPT and MSCM_RECEIPT_HEADER |
Delivery and Tracking
Delivery Event
| Measure name | Source table / calculation |
|---|---|
| Delivery Event Count | Count of MSCM_DELIVERY_EVENT.DELIVERY_EVENT_ID |
| Package Count | MSCM_DELIVERY_EVENT.PACKAGE_COUNT |
Delivery Ticket
| Measure name | Source table / calculation |
|---|---|
| Delivery Ticket Count | Count of MSCM_DELIVERY_TICKET.DELIVERY_TICKET_ID |
| Undelivered Ticket Count | Ticket Count when MSCM_DELIVERY_TICKET.DELIVERED = 'F' AND MSCM_DELIVERY_TICKET.DELIVERY_TICKET_TYPE <> 'D' |
Distribution Line
| Measure name | Source table / calculation |
|---|---|
| Distribution Delivery Quantity | MSCM_DISTRIB_LINE.DELIVERY_QTY |
| Distribution Line Count | Count of DistributionLineKey |
| Distribution Ordered Quantity | MSCM_DISTRIB_LINE.ORDERED_QTY |
Picking
Picklist Header
| Measure name | Source table / calculation |
|---|---|
| Lines Short Picked | MSCM_PICKLIST_HEADER.LINES_SHORT |
| Picking Number of Month | Count of distinct months based on MSCM_PICKLIST_HEADER.LAST_PICK_DATE |
| Picklist Count | Count of MSCM_PICKLIST_HEADER.PICKLIST_ID |
| Total Picked Lines | MSCM_PICKLIST_HEADER.TOTAL_PICKED_LINES |
| Total Shipment Lines | MSCM_PICKLIST_HEADER.TOTAL_LINES |
Picklist Line
| Measure name | Source table / calculation |
|---|---|
| Picklist Line Pulled Quantity | MSCM_PICKLIST_LINE_DETAIL.PULLED_QTY |
| Picklist Line Count | Count of MSCM_PICKLIST_LINE.PICKLIST_LINE_ID |
| Open Quantity | MSCM_PICKLIST_LINE.OPEN_QTY |
Picklist Line Detail
| Measure name | Source table / calculation |
|---|---|
| Allocated Quantity | MSCM_PICKLIST_LINE_DETAIL.ALLOCATED_QTY |
| Picklist Line Detail Count | Count of PicklistLineDetailKey |
| Pulled Quantity | MSCM_PICKLIST_LINE_DETAIL.PULLED_QTY |
Picklist Log
| Measure name | Source table / calculation |
|---|---|
| Picklist Log Count | Count of MSCM_PICKLIST_LOG.PICKLIST_ID |
Issue and Return
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 |