MSCM - Point of Use for Department Inventory measures
Accept Line Detail
| Measure name | Source table / calculation |
|---|---|
| POU Accept Line Detail Quantity | MSCM_ACCEPT_LINE_DETAIL.QTY |
Accept Line
| Measure name | Source table / calculation |
|---|---|
| POU Accept Line Quantity | MSCM_ACCEPT_LINE.QTY |
Billed Procedure Item
| Measure name | Source table / calculation |
|---|---|
| POU Billed Procedure Item Base Quantity | MSCM_BILLED_PROCEDURE_ITEM.BASE_QTY |
| POU Billed Procedure Item Billable Quantity | MSCM_BILLED_PROCEDURE_ITEM.BILLABLE_QTY |
Case Procedure Item
| Measure name | Source table / calculation |
|---|---|
| POU Case Procedure Item Preferred Quantity | MSCM_CASE_PROCEDURE_ITEM.PREF_QTY |
| POU Case Procedure Item Quantity Used | MSCM_CASE_PROCEDURE_ITEM.QTY_USED |
| POU Case Procedure Item Returnable Quantity | MSCM_CASE_PROCEDURE_ITEM.RETURNABLE_QTY |
| POU Case Procedure Item Unit Cost | MSCM_CASE_PROCEDURE_ITEM.UNIT_COST |
Cloverleaf Billing Transaction
| Measure name | Source table / calculation |
|---|---|
| POU Cloverleaf Billing Transaction Quantity | MSCM_CLOVERLEAF_BILLING_TRNSCTN.QUANTITY |
Cloverleaf Case Procedure Item
| Measure name | Source table / calculation |
|---|---|
| POU Cloverleaf Case Procedure Item Quantity | MSCM_CLOVERLEAF_CASE_PROC_ITEM.QUANTITY |
Cloverleaf Charge Detail
| Measure name | Source table / calculation |
|---|---|
| POU Cloverleaf Charge Detail Quantity | MSCM_CLOVERLEAF_CHARGE_DETAIL.QUANTITY |
| POU Cloverleaf Charge Detail Count | 1 |
Department Item
| Measure name | Source table / calculation |
|---|---|
| POU Department Item Item Price | MSCM_DEPARTMENT_ITEM.ITEM_PRICE |
| POU Department Item Pending Quantity | MSCM_DEPARTMENT_ITEM.PENDING_QTY |
| POU Department Item Requested Quantity | MSCM_DEPARTMENT_ITEM.REQUESTED_QTY |
| POU Department Item Unit Cost | MSCM_DEPARTMENT_ITEM.UNIT_COST |
Department Location Item
| Measure name | Source table / calculation |
|---|---|
| POU Department Location Item Consigned Quantity |
MSCM_DEPT_LOCATION_ITEM.QOH when MSCM_DEPT_LOCATION_ITEM.CONSIGNMENT_FL = ‘Y’ |
| POU Department Location Item Non-consigned Quantity |
MSCM_DEPT_LOCATION_ITEM.QOH when MSCM_DEPT_LOCATION_ITEM.CONSIGNMENT_FL = ‘N’ |
| POU Department Location Item Count | 1 |
| POU Department Location Item Critical Level | MSCM_DEPT_LOCATION_ITEM.CRITICAL_LEVEL |
| POU Department Location Item No Expiration Quantity | MSCM_DEPT_LOCATION_ITEM.NO_EXP_QTY |
| POU Department Location Item Par Level | MSCM_DEPT_LOCATION_ITEM.PAR_LEVEL |
| POU Department Location Item Quantity on Hand | MSCM_DEPT_LOCATION_ITEM.QOH |
| POU Department Location Item Quantity to Order | MSCM_DEPT_LOCATION_ITEM.QTY_TO_ORDER |
| POU Department Location Item Replenish Quantity | MSCM_DEPT_LOCATION_ITEM.REPLENISH_QTY |
| POU Department Location Item Requested Quantity | MSCM_DEPT_LOCATION_ITEM.REQUESTED_QTY |
| POU Department Location Item Unit Cost | MSCM_DEPARTMENT_ITEM.UNIT_COST |
| POU Department Location Item Cost |
When MSCM_DEPARTMENT_ITEM.REPLENISHMENT_TYPE = Vendor-replenished MSCM_DEPARTMENT_ITEM.UNIT_COST * MSCM_DEPT_LOCATION_ITEM.QOH * MSCM_ITEM.BUY_UOM_CF When MSCM_DEPARTMENT_ITEM.REPLENISHMENT_TYPE = Stock-replenished MSCM_DEPARTMENT_ITEM.UNIT_COST * MSCM_DEPT_LOCATION_ITEM.QOH * MSCM_ITEM. TRANSACTION_UOM_CF |
| POU Department Location Item Used Quantity | MSCM_DEPT_LOCATION_ITEM.USED_QTY |
| POU Department Location Item QOH below Critical Level | 1 when MSCM_DEPT_LOCATION_ITEM.QOH < MSCM_DEPT_LOCATION_ITEM.CRITICAL_LEVEL |
| POU Department Location Item QOH equals Critical Level] | 1 when MSCM_DEPT_LOCATION_ITEM.QOH = MSCM_DEPT_LOCATION_ITEM.CRITICAL_LEVEL |
Request Line
| Measure name | Source table / calculation |
|---|---|
| POU Request Line Ordered Quantity | MSCM_REQUEST_LINE.ORDERED_QTY |
| POU Request Line Received Quantity | MSCM_REQUEST_LINE.RECEIVED_QTY |
| POU Request Line Rejected with Replacement Quantity | MSCM_REQUEST_LINE.REJECTED_WITH_REPL_QTY |
| POU Request Line Remaining Quantity | MSCM_REQUEST_LINE.REMAINING_QTY |
| POU Request Line Unit Cost | MSCM_REQUEST_LINE.UNIT_COST |
Transfer Details
| Measure name | Source table / calculation |
|---|---|
| POU Transfer Details Quantity | MSCM_TRANSFER_DETAILS.QTY |