MSCM replication
Data is produced by the MSCM application and stored in the tenant’s database. The MSCM Sync application periodically extracts the schema and data from the MSCM database. The schema is then sent to the ION data catalog through Data Catalog APIs. The extracted data is sent to ION through IMS REST APIs. The data received by ION is processed by the defined data flow. As defined by the data flow, the MSCM data is sent to Infor Data Lake. MSCM data is now available through ION for other applications to use, such as Infor Birst. The default run interval is every 4 hours. It can be configured by an application administrator, to be run for all tenants. It has a manual trigger capability that can be set by the tenant’s system administrator for the selected tenant. The replication process cannot have overlapping runs. Only new and changed data is sent to ION, determined by CreatedDate and UpdatedDate. Data sending is by batch and data is sent per tenant.
This table shows the tables available in MSCM:
| Table | Field |
|---|---|
| ACTIVITY_LOG | USER_ID |
| ACTIVITY_LOG_ID | |
| ACTIVITY_TYPE | |
| START_TIME | |
| END_TIME | |
| DURATION | |
| STATUS | |
| SOURCE_LOCATION_ID | |
| DESTINATION_LOCATION_ID | |
| QUANTITY | |
| SUB_UNIT | |
| CREATION_DT | |
| LAST_MODIFIED_DT | |
| ACTIVITY_TYPE | ACTIVITY_TYPE |
| ACTIVITY_NAME | |
| DESCRIPTION | |
| IS_ACTIVE | |
| MODULE | |
| CREATION_DT | |
| LAST_MODIFIED_DT | |
| ADDRESS | ADDRESS_ID |
| ADDRESS_LINE1 | |
| ADDRESS_LINE2 | |
| ADDRESS_LINE3 | |
| ADDRESS_LINE4 | |
| CITY_ADDR5 | |
| STATE_PROV | |
| POSTAL_CODE | |
| COUNTRY_CODE | |
| COUNTRY | |
| CREATION_DT | |
| LAST_MODIFIED_DT | |
| COMPANY | COMPANY_NO |
| ITEM_GROUP | |
| DESCRIPTION | |
| IS_ACTIVE | |
| ADDED_TO_MSC | |
| EXT_DATA_IND | |
| EXTERNAL_STATUS | |
| CREATION_DT | |
| LAST_MODIFIED_DT | |
| ID_CONFLICT_DT | |
| AUDIT_ITL_FL | |
| AUDIT_ITM_FL | |
| COST_METHOD | |
| PROCUREMENT_GRP | |
| ALLOW_MANUAL_POCODE | |
| DELIVERY_EVENT | DELIVERY_EVENT_ID |
| CREATED | |
| SIGNATURE_ID | |
| RECIPIENT_ID | |
| LOCATION_ID | |
| MANIFEST_ID | |
| ACTION | |
| USER_NAME | |
| PACKAGE_COUNT | |
| CREATION_DT | |
| LAST_MODIFIED_DT | |
| DELIVERY_TICKET | DELIVERY_TICKET_ID |
| RECV_LOCATION_ID | |
| RCV_USER_ID | |
| CREATION_DT | |
| DELIVERY_LOCATION_ID | |
| REQUISITION_NO | |
| PO_NO | |
| PO_CODE | |
| PO_RELEASE | |
| REQUESTED_DEL_DT | |
| FROM_LOCATION_ID | |
| RECEIVER_NO | |
| DELIVER_TO | |
| REQUESTOR_ID | |
| DELIVERY_TICKET_TYPE | |
| ACCEPT | |
| LAST_MODIFIED_DT | |
| VENDOR_SYSTEM_ID | |
| ALT_REQUESTOR | |
| DELIVERED | |
| SHIPMENT_NO | |
| NEED_TO_PRINT | |
| DOCUMENT_PRINTER_ID | |
| LABEL_PRINTER_ID | |
| DELIVERY_UNIT | DELIVERY_TICKET_ID |
| DELIVERY_UNIT_NO | |
| TRACKING_NO | |
| NUM_LABELS | |
| NOTE_ID | |
| IS_ACTIVE | |
| CREATION_DT | |
| LAST_MODIFIED_DT | |
| DISTRIB_LINE | DELIVERY_TICKET_ID |
| DELIVERY_UNIT_NO | |
| DISTRIB_LINE_NO | |
| SOURCE_LINE_NO | |
| PO_LINE_NO | |
| ITEM_NO | |
| DESCR | |
| VENDOR_ITEM_NO | |
| MFR_CAT_NO | |
| DELIVERY_QTY | |
| ORDERED_QTY | |
| UOM | |
| LAST_MODIFIED_DT | |
| STATUS | |
| STATE | |
| RECV_LINE_NO | |
| CURRENT_LOCATION_ID | |
| NEXT_LOCATION_ID | |
| NEXT_ACTION | |
| NOTE_ID | |
| BO_REM_QTY | |
| BO_CAN_BACK_ORD | |
| BIN | |
| CREATION_DT | |
| DOCKLOG | DOCKLOG_ID |
| CARRIER_VENDOR_SYSTEM_ID | |
| RECV_LOCATION_ID | |
| USER_ID | |
| CREATE_DT | |
| COUNT | |
| LAST_MODIFIED_DT | |
| DOCKLOG_LINE | DOCKLOG_ID |
| DOCKLOG_LINE_NO | |
| TRACKING_NO | |
| CREATION_DT | |
| LAST_MODIFIED_DT | |
| EVENT_DETAIL | EVENT_HEADER_ID |
| EVENT_DETAIL_SEQ | |
| ITEM_ID | |
| SOURCE_LOCATION_ID | |
| SOURCE_BIN_NO | |
| REQUESTING_LOCATION_ID | |
| REQUIRING_BIN_NO | |
| QUANTITY | |
| UOM | |
| LOT_NO | |
| SERIAL_NO | |
| EVENT_TIMESTAMP | |
| DETAIL_UPLOAD_IND | |
| TASK_ID | |
| EVENT_DETAIL_GT_01 | |
| EVENT_DETAIL_GT_02 | |
| EVENT_DETAIL_GT_03 | |
| EVENT_DETAIL_GT_04 | |
| EVENT_DETAIL_GT_05 | |
| EVENT_DETAIL_GT_06 | |
| EVENT_DETAIL_GN_01 | |
| EVENT_DETAIL_GN_02 | |
| EVENT_DETAIL_GN_03 | |
| EVENT_DETAIL_GN_04 | |
| EVENT_DETAIL_GD_01 | |
| EVENT_DETAIL_GD_02 | |
| RETRY_COUNT | |
| CREATION_DT | |
| LAST_MODIFIED_DT | |
| COST | |
| INSPECTION_FL | |
| EXP_DATE | |
| MFG_DATE | |
| GTIN | |
| EVENT_HEADER | EVENT_HEADER_ID |
| EVENT_TYPE | |
| USER_ID | |
| HEADER_UPLOAD_IND | |
| HH_SYNC_TIMESTAMP | |
| EVENT_HEADER_GT_01 | |
| EVENT_HEADER_GT_02 | |
| EVENT_HEADER_GT_03 | |
| EVENT_HEADER_GT_04 | |
| EVENT_HEADER_GT_05 | |
| EVENT_HEADER_GT_06 | |
| EVENT_HEADER_GN_01 | |
| EVENT_HEADER_GN_02 | |
| EVENT_HEADER_GN_03 | |
| EVENT_HEADER_GN_04 | |
| EVENT_HEADER_GD_01 | |
| EVENT_HEADER_GD_02 | |
| RETRY_COUNT | |
| NEED_TO_PRINT | |
| CREATION_DT | |
| LAST_MODIFIED_DT | |
| DOCUMENT_PRINTER_ID | |
| EVENT_STATUS_RANK | STATUS_CODE |
| DESCRIPTION | |
| RANK | |
| CREATION_DT | |
| LAST_MODIFIED_DT | |
| ITEM | ITEM_ID |
| ITEM_NO | |
| ITEM_GROUP | |
| EXT_DATA_IND | |
| PROCUREMENT_ITEM_ID | |
| DESCR | |
| MFR_CAT_NO | |
| MFR_ID | |
| MAJOR_CLASS | |
| MINOR_CLASS | |
| USAGE_IDENTIFIER | |
| IMGLNK | |
| UOM | |
| STATUS | |
| EXTERNAL_STATUS | |
| CREATION_DT | |
| LAST_MODIFIED_DT | |
| SERIAL_TRACKED_IND | |
| SER_TRACK_FL | |
| LOT_TRACK_FL | |
| USAGE_LIMIT | |
| ALT_DESC | |
| SDI_TRACKING_FL | |
| CONSIGNMENT_FL | |
| IMPLANT_FL | |
| REPLENISHMENT_MODE | |
| REPLENISH_NOTES | |
| SDI_UOM | |
| MIN_ORDER | |
| SDI_STATUS | |
| REQ_LINE_UOM | |
| ALT_UOM_FL | |
| ALT_UOM_CF | |
| DUPLICATE_SERIAL_FL | |
| IMG_ID | |
| UNIT_COST | |
| TOT_SHELF_LIFE | |
| SET_MAINTENANCE_PERIOD | |
| TRANS_UOM | |
| BUY_UOM | |
| TRANS_UOM_CF | |
| BUY_UOM_CF | |
| UDI_TRACK_FL | |
| DISCONTINUED | |
| PPE | |
| BNT_TRACK_FL | |
| ITEM_GROUP | ITEM_GROUP |
| DESCRIPTION | |
| CREATION_DT | |
| LAST_MODIFIED_DT | |
| ITEM_GROUP_UOM | ITEM_GROUP |
| UOM | |
| DESCRIPTION | |
| CREATION_DATE | |
| LAST_MODIFIED_DATE | |
| LOCATION | LOCATION_ID |
| LOCATION_CODE | |
| COMPANY_NO | |
| NAME | |
| IS_ACTIVE | |
| ADDED_TO_MSC | |
| EXT_DATA_IND | |
| EXTERNAL_STATUS | |
| ADDRESS_ID | |
| CREATION_DT | |
| LAST_MODIFIED_DT | |
| ID_CONFLICT_DT | |
| FROM_LOCATION_ID | |
| LOCATION_ITEM | LOCATION_ITEM_ID |
| ITEM_ID | |
| LOCATION_ID | |
| EXT_DATA_IND | |
| ALT_ITEM_DESCRIPTION | |
| ALT_IMGLNK | |
| STATUS | |
| ITEM_REPL_NO | |
| EXTERNAL_STATUS | |
| UOM | |
| PAR_LEVEL | |
| PREFER_BIN | |
| PAR_BIN_SEQ | |
| REPL_FROM_LOC_ID | |
| REPL_FROM_BIN | |
| LOT_TRACK_FL | |
| SER_TRACK_FL | |
| BIN_TRK_FL | |
| EACH_COST | |
| CREATION_DT | |
| LAST_MODIFIED_DT | |
| QUANTITY_OO | |
| SERIAL_TRACKED_IND | |
| MIN_ORDER | |
| BIN_LOCATION | |
| CHARGEABLE_FL | |
| ALLOW_ISS_FL | |
| TRACKING_FL | |
| AVG_COST | |
| STD_COST | |
| CRITICAL_LEVEL | |
| QOH | |
| PENDING_QTY | |
| REQUESTED_QTY | |
| ADDITIONAL_PND_QTY | |
| ADDITIONAL_REQ_QTY | |
| IMG_ID | |
| AVG_PAR_UTL | |
| SUG_PAR_LVL | |
| MAINTENANCE_FL_LOC | |
| UDI_TRACK_FL | |
| TRANS_UOM | |
| DISCONTINUED | |
| MFGR | MFR_ID |
| ITEM_GROUP | |
| MFG_CODE | |
| MFG_DIV | |
| NAME | |
| STATUS | |
| EXT_DATA_IND | |
| EXTERNAL_STATUS | |
| ADDED_TO_SIM | |
| CREATION_DT | |
| LAST_MODIFIED_DT | |
| ID_CONFLICT_DT | |
| PICKLIST_HEADER | PICKLIST_ID |
| FROM_LOC_ID | |
| REQ_LOC_ID | |
| DOC_NO | |
| SHIP_NO | |
| VENDOR | |
| REQ_DATE | |
| REQUESTER | |
| SHIP_DATE | |
| LAST_PICK_DATE | |
| LAST_ASSIGN_DATE | |
| UPLOAD_MSG | |
| TOTAL_LINES | |
| TOTAL_PICKED_LINES | |
| LINES_SHORT | |
| INT_STATUS | |
| EXT_STATUS | |
| DOCUMENT_PRINTER_ID | |
| LABEL_PRINTER_ID | |
| DELIVER_TO | |
| CREATION_DT | |
| LAST_MODIFIED_DT | |
| PICKLIST_LINE | PICKLIST_LINE_ID |
| PICKLIST_ID | |
| LOC_ITEM_ID | |
| OPEN_QTY | |
| OPEN_QTY_UOM | |
| PULLED_QTY | |
| PULLED_QTY_UOM | |
| UPLOAD_STATUS | |
| UPLOAD_MESSAGE | |
| LINE_NO | |
| SKIP_SCANNED | |
| LINE_TYPE | |
| SHORT_PICK | |
| BACKORDER_QTY | |
| CREATION_DT | |
| LAST_MODIFIED_DT | |
| AVAILABLE_SOH | |
| AVAILABLE_SOH_UOM | |
| PICKLIST_LINE_DETAIL | PICKLIST_LINE_ID |
| RECORD_SEQ | |
| PULLED_QTY | |
| PULLED_UOM | |
| TRACKING_NO | |
| PICKED_BY | |
| BIN | |
| SERIAL | |
| LOT | |
| SUB_LOT | |
| ALLOCATED_QTY | |
| ALLOCATED_UOM | |
| ALLOCATED_BIN | |
| ALLOCATED_SERIAL | |
| ALLOCATED_LOT | |
| ALLOCATED_SUB_LOT | |
| UPLOAD_STATUS | |
| UPLOAD_MESSAGE | |
| CREATION_DT | |
| LAST_MODIFIED_DT | |
| EXP_DATE | |
| MFG_DATE | |
| GTIN | |
| PICKLIST_LOG | PICKLIST_ID |
| USER_ID | |
| ACTIVITY | |
| ACTIVITY_DATE | |
| CREATION_DT | |
| LAST_MODIFIED_DT | |
| PO_HEADER | PO_ID |
| PO_NUMBER | |
| COMPANY_NO | |
| PO_RELEASE | |
| PO_CODE | |
| VENDOR | |
| CREATION_DATE | |
| DFLT_DATE | |
| LOC_ID | |
| TOTAL_LINES | |
| CLOSED_LINE | |
| IS_RELEASED | |
| IS_CANCELED | |
| IS_CLOSED | |
| IS_DROP_SHIP | |
| CLS_DATE | |
| INT_STATUS | |
| EXT_STATUS | |
| LAST_MODIFIED_DT | |
| PO_LINE | LINE_ID |
| PO_ID | |
| LINE_NO | |
| ITEM_NO | |
| ITEM_DESC | |
| TYPE | |
| SHIP_TO_LOC | |
| BIN_TRACKED | |
| LOT_TRACKED | |
| SER_TRACKED | |
| INV_TRACKED | |
| MFR_ID | |
| CATALOG_NO | |
| VENDOR | |
| TRANS_UOM | |
| ORD_QTY | |
| REC_QTY | |
| REM_QTY | |
| PREF_BIN | |
| NEED_INSP | |
| CAN_BACK_ORD | |
| IS_CANCELED | |
| IS_CLOSED | |
| INT_STATUS | |
| EXT_STATUS | |
| CTW | |
| NBR_DEC | |
| UND_SHP_TOL | |
| BO_REM_QTY | |
| CREATION_DT | |
| LAST_MODIFIED_DT | |
| UDI_TRACKED | |
| MSDS_REQUIRED | |
| PO_LINE_RECEIPT | LINE_ID |
| REC_ID | |
| UPLOAD_STATUS | |
| UPLOAD_MSG | |
| CREATION_DT | |
| LAST_MODIFIED_DT | |
| MSDS_RECEIVED | |
| MSDS_DOCUMENT | |
| MSDS_VERSION | |
| PO_LINE_RECEIPT_RECORD | LINE_ID |
| REC_ID | |
| SEQ | |
| BIN | |
| SERIAL | |
| LOT | |
| SUB_LOT | |
| TRK_NO | |
| RCV_LOC | |
| RCV_QTY | |
| RCV_UOM | |
| LOT_EXP | |
| UPLOAD_STATUS | |
| UPLOAD_MSG | |
| NEED_INSP | |
| CAN_BACK_ORD | |
| CREATION_DT | |
| LAST_MODIFIED_DT | |
| MFG_DATE | |
| GTIN | |
| PO_RECEIPT | REC_ID |
| REC_NO | |
| PO_ID | |
| RELEASED_BY | |
| CREAT_DATE | |
| BOL | |
| REC_DATE | |
| CARRIER | |
| REF_NO | |
| CARRIER_TRK_NO | |
| RCV_LOC | |
| UPLOAD_MSG | |
| UPLOAD_STATUS | |
| INT_STATUS | |
| EXT_STATUS | |
| LABEL_PRINT_ID | |
| DOC_PRINT_ID | |
| NEED_PRINT | |
| LAST_MODIFIED_DT | |
| RECEIPT_HEADER | RECEIPT_ID |
| ACCEPT_RECEIPT | |
| RECEIPT_TYPE | |
| STATUS | |
| RECV_LOCATION_ID | |
| USER_ID | |
| RETURN_TIME | |
| LAST_MODIFIED_DT | |
| VENDOR_SYSTEM_ID | |
| NOTE_ID | |
| DOCUMENT_PRINTER_ID | |
| LABEL_PRINTER_ID | |
| CREATION_DT | |
| RECEIPT_LINE | RECEIPT_ID |
| RECEIPT_LINE_NO | |
| QTY_RECEIVED | |
| RECEIVED_TIME | |
| PO_NO | |
| PACKING_SLIP_NO | |
| TRACKING_NO | |
| CARRIER_VENDOR_SYSTEM_ID | |
| CREATION_DT | |
| LAST_MODIFIED_DT | |
| RECIPIENT | RECIPIENT_ID |
| FIRST_NAME | |
| LAST_NAME | |
| EMPLOYEE_ID | |
| CREATION_DT | |
| LAST_MODIFIED_DT | |
| REPL_REQUEST_DTL | SEQ |
| TXN_DATE | |
| LOCATION_ITEM_ID | |
| TXN_TYPE | |
| TXN_QTY | |
| ADDITIONAL_QTY | |
| QOH | |
| PENDING_QTY | |
| REQUESTED_QTY | |
| PAR_LEVEL | |
| MIN_ORDER | |
| CRITICAL_LEVEL | |
| USER_ID | |
| CREATION_DT | |
| LAST_MODIFIED_DT | |
| REQUESTOR | REQUESTOR_ID |
| COMPANY_NO | |
| REQUESTOR | |
| REQUESTOR_NAME | |
| LOCATION_CODE | |
| ORGANIZATION | |
| HRORGANDREQUESTER | |
| CREATION_DT | |
| LAST_MODIFIED_DT | |
| GIVEN_NAME | |
| FAMILY_NAME | |
| USERS | USER_ID |
| NAME | |
| FIRST_NAME | |
| LAST_NAME | |
| PASSWORD | |
| STATUS | |
| REQUESTER | |
| EMPLOYEE_ID | |
| EXT_DATA_IND | |
| ADDED_TO_MSC | |
| GLOBAL_ROLE_IND | |
| CREATION_DT | |
| LAST_MODIFIED_DT | |
| ID_CONFLICT_DT | |
| SSOP | |
| EMP_ID_VARCHAR | |
| ENV_ID | |
| SHOW_DASHBOARD_FL | |
| DISPLAY_LOCATION_FL | |
| BLIND_COUNTING_FL | |
| SEND_TO_BILLING_FL | |
| EXPIRING_ITEM_DURATION | |
| LOCALE_LSF_NAME | |
| ADDED_TO_MSC_ADS | |
| USR_AUTHENTICATE_TYPE | |
| TIMEZONE | |
| ISOLOCALE | |
| VENDOR | VENDOR_SYSTEM_ID |
| VENDOR_ID | |
| VENDOR_NAME | |
| GROUP_ID | |
| IS_MISC_RECEIVING | |
| IS_CARRIER | |
| IS_PO_RECEIVING | |
| EXT_DATA_IND | |
| INTERNAL_STATUS | |
| EXTERNAL_STATUS | |
| POOL_OPTION | |
| CREATION_DT | |
| LAST_MODIFIED_DT | |
| PAR_LEVEL_UPDATES | EVENT_HEADER_ID |
| EVENT_DETAIL_SEQ | |
| ITEM_ID | |
| REQUESTING_LOCATION_ID | |
| PAR_LEVEL_OLD | |
| PAR_LEVEL_NEW | |
| NEED_TO_PRINT | |
| LABEL_PRINTER_ID | |
| CREATION_DT | |
| LAST_MODIFIED_DT | |
| USERPARFORM | LOCATION_ID |
| USER_ID | |
| CREATION_DT | |
| LAST_MODIFIED_DT | |
| TASK | TASK_ID |
| TASK_TYPE | |
| ITEM_ID | |
| REQUESTING_LOCATION_ID | |
| REQUESTING_BIN_NO | |
| REQUESTED_QTY | |
| REQUESTED_UOM | |
| REQUESTED_LOT_NO | |
| ACTUAL_QTY | |
| ACTUAL_UOM | |
| PARENT_TASK_ID | |
| TASK_GT_01 | |
| TASK_GT_02 | |
| TASK_GT_03 | |
| TASK_GT_04 | |
| TASK_GN_01 | |
| TASK_GN_02 | |
| TASK_GN_03 | |
| TASK_GN_04 | |
| TASK_GD_O1 | |
| TASK_GD_02 | |
| TASK_STATUS_CD | |
| CREATION_DT | |
| LAST_MODIFIED_DT | |
| COUNTFORM | COUNTFORM_ID |
| COMPANY_NO | |
| SELECT_ID | |
| TOTAL | |
| CREATION_DT | |
| LAST_MODIFIED_DT | |
| EXTERNAL_STATUS | |
| COUNTFORM_ITEMS | COUNTFORM_ITEM_ID |
| COUNTFORM_ID | |
| PAGE | |
| COUNTFORM_LINE_NO | |
| ITEM_ID | |
| LOCATION_ID | |
| BIN | |
| SQOH | |
| UOM | |
| LOT_SERIAL | |
| LOT_TRACK_FL | |
| SER_TRACK_FL | |
| EXTERNAL_STATUS | |
| CREATION_DT | |
| LAST_MODIFIED_DT | |
| KANBAN_BIN | LOCATION_ITEM_ID |
| BIN_ID | |
| BIN_CODE | |
| ACTIVE_FL | |
| CREATION_DT | |
| LAST_MODIFIED_DT | |
| KANBAN_CONFIG | LOCATION_ITEM_ID |
| KANBAN_UOM | |
| REORDER_POINT | |
| KANBAN_PER_BIN_QTY | |
| BIN_COUNT | |
| ACTIVE_FL | |
| EXPIRY_FL | |
| CONVERSION_FACTOR | |
| BIN_COUNT_UPLOAD_FL | |
| BIN_COUNT_UPLOAD_RETRY_COUNT | |
| CREATION_DT | |
| LAST_MODIFIED_DT | |
| KANBAN_COUNT_HEADER | KANBAN_COUNT_HEADER_ID |
| LOCATION_ID | |
| CREATE_DATE | |
| EVENT_HEADER_ID | |
| LAST_MODIFIED_DT | |
| KANBAN_COUNT_ITEM | KANBAN_COUNT_HEADER_ID |
| KANBAN_COUNT_ITEM_ID | |
| LOCATION_ITEM_ID | |
| CREATE_DATE | |
| CONVERSION_FACTOR | |
| KANBAN_UOM | |
| KANBAN_PER_BIN_QTY | |
| REORDER_POINT | |
| STATUS | |
| EVENT_HEADER_ID | |
| EVENT_DETAIL_SEQ | |
| LAST_MODIFIED_DT | |
| KANBAN_COUNT_ITEM_BIN | KANBAN_COUNT_ITEM_BIN_ID |
| KANBAN_COUNT_ITEM_ID | |
| BIN_ID | |
| SCAN_DATE | |
| CREATE_DATE | |
| LAST_MODIFIED_DT | |
| KANBAN_LOC_CONFIG | LOCATION_ID |
| KANBAN_FL | |
| EXPIRY_FL | |
| KANBAN_COUNT | |
| CREATION_DT | |
| LAST_MODIFIED_DT | |
| CHARGE_DETAIL | BIN |
| CHARGE_DTL_ID | |
| CHARGE_ID | |
| COST | |
| CREATE_DATE | |
| ITEM_ID | |
| LAST_UPDATE_DATE | |
| LOT_NBR | |
| ORIGINAL_QTY | |
| PATIENT_PRICE | |
| QTY | |
| REPLENISHMENT_TYPE | |
| SERIAL_NBR | |
| SPLIT_GROUP_NO | |
| SUBLOT | |
| SUPPLY_LOCATION_ID | |
| UOM | |
| UPLOAD_MSG | |
| UPLOAD_STATUS | |
| CHARGE_HEADER | BATCH_NO |
| CHARGE_DATE | |
| CHARGE_ID | |
| CREATION_DT | |
| DRAFT_NO | |
| IS_FLOOR_CHARGE | |
| LAST_UPDATE_DATE | |
| PATIENT_LOCATION_ID | |
| PATIENT_VISIT_ID | |
| REQ_LOC_ID | |
| REVENUE_CENTER_ID | |
| TXN_DATE | |
| TXN_TYPE | |
| USER_ID | |
| CHARGE_ISSUE | CHARGE_DTL_ID |
| CHARGE_ISSUE_SEQ | |
| CREATE_DATE | |
| LAST_UPDATE_DATE | |
| PAR_ISSUE_FLG | |
| PAR_ISSUE_ID | |
| UPLOAD_MSG | |
| CHARGE_SUPPLY_LOCATION | CHARGE_ID |
| CHARGE_SUP_LOC_SEQ | |
| CREATION_DT | |
| LAST_MODIFIED_DT | |
| SUPPLY_LOCATION_ID | |
| CLOVERLEAF_CHARGE_DETAIL | AMOUNT |
| BATCH_ID | |
| CHARGE_TRNSCTN_ID | |
| CREATION_DT | |
| ITEM_DESC | |
| ITEM_NO | |
| LAST_MODIFIED_DT | |
| QUANTITY | |
| REVENUE_CODE | |
| TRANS_CODE | |
| TRANS_DATE | |
| TRANS_TYPE | |
| DEFAULT_REVENUE_CENTER | CREATION_DT |
| LAST_MODIFIED_DT | |
| REVENUE_CENTER_ID | |
| USER_ID | |
| FACILITY | COMPANY_NO |
| CREATE_DATE | |
| FACILITY_CODE | |
| FACILITY_DESC | |
| FACILITY_ID | |
| IS_ACTIVE | |
| LAST_UPDATE_DATE | |
| SENDING_FACILITY | |
| LOCATION_SCHEDULE | CREATE_DATE |
| END_DATE | |
| FREQUENCY | |
| LAST_MODIFIED_DT | |
| SCHEDULE_ID | |
| START_DATE | |
| SUPPLY_LOC_ID | |
| LOCATION_SCHEDULED_DAYS | CREATE_DATE |
| IS_ACTIVE | |
| LAST_MODIFIED_DT | |
| PROCESSED | |
| SCHEDULE_ID | |
| SCHEDULED_DATE | |
| SCHEDULED_DATE_ID | |
| PATIENT_LOCATION | BED |
| CREATE_DATE | |
| FACILITY_ID | |
| IS_ACTIVE | |
| LAST_UPDATE_DATE | |
| PATIENT_LOCATION_ID | |
| ROOM_CODE | |
| POU_UOM | CREATE_DATE |
| ITEM_ID | |
| LAST_UPDATE_DATE | |
| POU_UOM | |
| REPL_REQUEST_DTL | ADDITIONAL_QTY |
| CREATION_DT | |
| CRITICAL_LEVEL | |
| LAST_MODIFIED_DT | |
| LOCATION_ITEM_ID | |
| MIN_ORDER | |
| PAR_LEVEL | |
| PENDING_QTY | |
| QOH | |
| REQUESTED_QTY | |
| SEQ | |
| TXN_DATE | |
| TXN_QTY | |
| TXN_TYPE | |
| USER_ID | |
| REQUEST_QUEUE | ADDITIONAL_QTY |
| CHARGE_DTL_ID | |
| CREATION_DT | |
| EVENT_HEADER_ID | |
| ITEM_ID | |
| LAST_UPDATE_DATE | |
| QTY | |
| REPLENISHMENT_TYPE | |
| REQUEST_QUEUE_SEQ | |
| SUPPLY_LOCATION_ID | |
| UOM | |
| UPLOAD_STATUS | |
| REVENUE_CENTER | COMPANY_NO |
| CREATE_DATE | |
| IS_ACTIVE | |
| LAST_UPDATE_DATE | |
| REV_CTR_CODE | |
| REV_CTR_DESC | |
| REVENUE_CENTER_ID | |
| REVENUE_CENTER_ITEM | CDM |
| CREATE_DATE | |
| IS_CHARGEABLE | |
| ITEM_ID | |
| LAST_UPDATE_DATE | |
| PATIENT_PRICE | |
| REV_CENTER_ITEM_SEQ | |
| REVENUE_CENTER_ID | |
| TXN_TYPE | CREATION_DT |
| LAST_MODIFIED_DT | |
| TXN_NAME | |
| TXN_TYPE | |
| USER_FACILITY_MAP | CREATION_DT |
| FACILITY_ID | |
| LAST_MODIFIED_DT | |
| USER_ID | |
| WORKSTATION | ALLOW_REVENUECENTER_SELECT |
| COMPANY_NO | |
| CREATE_DATE | |
| DEFAULT_PATIENT_SORT | |
| DEFAULT_REV_CTR_ID | |
| DESCRIPTION | |
| HOSTNAME | |
| IDLE_GLOBAL | |
| IDLE_TIME | |
| IS_ACTIVE | |
| LAST_UPDATE_DATE | |
| WORKSTATION_ID | |
| WORKSTATION_PATIENT_LOCATION | CREATE_DATE |
| LAST_UPDATE_DATE | |
| PATIENT_LOCATION_ID | |
| WORKSTATION_ID | |
| WS_PATIENT_LOC_ID | |
| CREATE_DATE | |
| LAST_UPDATE_DATE | |
| LOCATION_ID | |
| WORKSTATION_ID | |
| WS_SUPPLY_LOC_ID | |
| ACCEPT_HEADER | ACCEPT_ID |
| CREATE_DATE | |
| LAST_MODIFIED_DT | |
| REQUEST_HEADER_ID | |
| USER_ID | |
| ACCEPT_LINE | ACCEPT_ID |
| ACCEPT_LINE_ID | |
| CREATION_DT | |
| DEPT_LOC_ID | |
| ITEM_ID | |
| LAST_MODIFIED_DT | |
| QTY | |
| SDI_UOM | |
| ACCEPT_LINE_DETAIL | ACCEPT_LINE_DETAIL_ID |
| ACCEPT_LINE_ID | |
| CREATION_DT | |
| EXP_DATE | |
| LAST_MODIFIED_DT | |
| LOT_NO | |
| QTY | |
| SERIAL_NO | |
| TEMPERATURE | |
| BILLED_PROCEDURE | BILLED_DATE |
| BILLED_PROC_ID | |
| CASE_PROC_ID | |
| CHARGE_CODE | |
| CREATION_DT | |
| CREDIT_FL | |
| LAST_MODIFIED_DT | |
| SEQUENCE_NBR | |
| USER_ID | |
| BILLED_PROCEDURE_ITEM | BASE_QTY |
| BILLABLE_QTY | |
| BILLED_DATE | |
| BILLED_PROC_ITEM_ID | |
| CASE_PROC_ITEM_ID | |
| CHARGE_CODE | |
| CHARGEABLE_FL | |
| CREATION_DT | |
| LAST_MODIFIED_DT | |
| SEQUENCE_NBR | |
| USER_ID | |
| CASE_HEADER | CASE_ID |
| CASE_NO | |
| CASE_ORIGIN | |
| CONFIRM_DATE | |
| CREATE_DATE | |
| DEPT_ID | |
| DEPT_LOC_ID | |
| INBOUND_COMMENT | |
| LAST_UPDATE_DATE | |
| PATIENT_VISIT_ID | |
| PRACTITIONER_ID | |
| REVIEW_DATE | |
| SCHEDULE_DATE | |
| SENDING_APPLICATION | |
| STATUS | |
| USER_ID | |
| CASE_PERSONNEL | CASE_ID |
| CREATE_DATE | |
| LAST_MODIFIED_DT | |
| PERSONNEL_ID | |
| ROLE_ID | |
| SEQUENCE_NO | |
| CASE_PROCEDURE | CASE_ID |
| CASE_PROC_ID | |
| CREATE_DATE | |
| LAST_UPDATE_DATE | |
| PROCEDURE_ID | |
| PROCEDURE_MOD_ID | |
| CASE_PROCEDURE_ITEM | BILLED_FL |
| CASE_PROC_ID | |
| CASE_PROC_ITEM_ID | |
| CDM | |
| CHARGEABLE_FL | |
| CREATE_DATE | |
| DEPT_LOC_ID | |
| EXP_DATE | |
| HCPC | |
| IMPLANT_TYPE | |
| ITEM_ID | |
| LAST_UPDATE_DATE | |
| LOT_NO | |
| NON_LAWSON_ITEM_FL | |
| PARENT_ID | |
| PREF_QTY | |
| QTY_USED | |
| RETURNABLE_QTY | |
| SDI_UOM | |
| SERIAL_NO | |
| TEMPERATURE | |
| TRACKING_FL | |
| UNIT_COST | |
| WASTED_FL | |
| CLOVERLEAF_BILLING_TRNSCTN | BATCH_ID |
| BILLING_TRNSCTN_ID | |
| CHARGE_CODE | |
| CONFIRM_DATE | |
| CREATION_DT | |
| DEPT_CODE | |
| EMPLOYEE_FNAME | |
| EMPLOYEE_ID | |
| EMPLOYEE_LNAME | |
| LAST_MODIFIED_DT | |
| PROCEDURE_CODE | |
| PROCEDURE_DESC | |
| PROCEDURE_MOD_CODE | |
| QUANTITY | |
| SCHEDULE_DATE | |
| TRANS_CODE | |
| TRANS_TYPE | |
| CLOVERLEAF_CASE_PROC | CASE_HEADER_ID |
| CASE_PROC_ID | |
| CHARGE_CODE | |
| CREATION_DT | |
| LAST_MODIFIED_DT | |
| PROCEDURE_CODE | |
| PROCEDURE_DESC | |
| PROCEDURE_MOD_CODE | |
| PROCEDURE_STATUS | |
| CLOVERLEAF_CASE_PROC_ITEM | CASE_PROC_ID |
| CASE_PROC_ITEM_ID | |
| CREATION_DT | |
| DEPT_CODE | |
| EXP_DATE | |
| ITEM_NO | |
| LAST_MODIFIED_DT | |
| LOCATION_CODE | |
| LOT_NO | |
| PROCEDURE_CODE | |
| QUANTITY | |
| SERIAL_NO | |
| UOM | |
| CONTRACT_SPECIAL_ITEM | CONTRACT |
| CONTRACT_LINE | |
| CONTRACT_LINE_STATE | |
| CONTRACT_STATUS | |
| CREATION_DT | |
| EXPIRATION_DATE | |
| GTIN | |
| HBICCUPN | |
| ITEM_DESCRIPTION | |
| ITEM_GROUP | |
| ITEM_NUMBER | |
| LAST_MODIFIED_DT | |
| MAJOR_INVENTORY_CLASS | |
| MANUFACTURER_NUMBER | |
| MFR_ID | |
| MINOR_INVENTORY_CLASS | |
| UOM | |
| USE_FOR_COST_DEFAULTING | |
| DEPARTMENT | CREATE_DATE |
| DEPT_CODE | |
| DEPT_ID | |
| DESCRIPTION | |
| FACILITY_ID | |
| IS_ACTIVE | |
| IS_SHAREABLE | |
| LAST_UPDATE_DATE | |
| LOCATION_ID | |
| DEPARTMENT_ITEM | ACCT |
| ACCT_UNIT | |
| ALT_UOM_CF | |
| CDM | |
| CHARGEABLE_FL | |
| CREATE_DATE | |
| DEPT_ID | |
| DEPT_ITEM_ID | |
| EXPIRATION_AT_ISSUE | |
| EXPIRATION_AT_RECEIPT | |
| HCPC | |
| ITEM_ID | |
| ITEM_PRICE | |
| LAST_UPDATE_DATE | |
| PENDING_QTY | |
| REPLENISHMENT_TYPE | |
| REQ_LINE_UOM | |
| REQUESTED_QTY | |
| SDI_UOM | |
| STOCK_LOCATION_ID | |
| SUB_ACCT | |
| TRACKING_FL | |
| UNIT_COST | |
| VENDOR_LOC_ID | |
| VENDOR_SYSTEM_ID | |
| DEPARTMENT_LOCATION | BED |
| CREATE_DATE | |
| DEPT_ID | |
| DEPT_LOC_ID | |
| DEPT_LOC_TYPE | |
| DESCRIPTION | |
| IS_ACTIVE | |
| LAST_UPDATE_DATE | |
| LOCATION_ID | |
| ROOM | |
| DEPT_LOC_ITEM_BNT | CREATE_DATE |
| DEPT_LOCATION_ITEM_ID | |
| EXP_DATE | |
| LAST_UPDATE_DATE | |
| TEMPERATURE | |
| TOTAL_QTY | |
| DEPT_LOC_ITEM_EXPIRATION | CREATE_DATE |
| DEPT_LOCATION_ITEM_ID | |
| EXP_DATE | |
| LAST_UPDATE_DATE | |
| TEMPERATURE | |
| TOTAL_QTY | |
| DEPT_LOC_ITEM_LOT | CREATE_DATE |
| DEPT_LOCATION_ITEM_ID | |
| EXP_DATE | |
| LAST_UPDATE_DATE | |
| LOT_NO | |
| TEMPERATURE | |
| TOTAL_QTY | |
| DEPT_LOC_ITEM_SERIAL | CREATE_DATE |
| DEPT_LOCATION_ITEM_ID | |
| EXP_DATE | |
| LAST_UPDATE_DATE | |
| LOT_NO | |
| SERIAL_NO | |
| TEMPERATURE | |
| TOTAL_QTY | |
| DEPT_LOCATION_ITEM | CONSIGNMENT_FL |
| CREATE_DATE | |
| CRITICAL_LEVEL | |
| DEPT_LOC_ID | |
| DEPT_LOCATION_ITEM_ID | |
| ITEM_ID | |
| LAST_UPDATE_DATE | |
| NO_EXP_QTY | |
| PAR_LEVEL | |
| QOH | |
| QTY_TO_ORDER | |
| REPLENISH_QTY | |
| REQUESTED_QTY | |
| TEMPERATURE | |
| USED_QTY | |
| FACILITY_PRACTITIONER | CREATE_DATE |
| FACILITY_ID | |
| IS_ACTIVE | |
| LAST_UPDATE_DATE | |
| PRACTITIONER_ID | |
| ITEM_MAJOR_CLASS | ACTIVE_STATUS |
| CREATE_DATE | |
| DESCRIPTION | |
| ITEMGROUP | |
| LAST_UPDATE_DATE | |
| MAJOR_CLASS | |
| MAJOR_CLASS_ID | |
| ACTIVE_STATUS | |
| CREATE_DATE | |
| DESCRIPTION | |
| LAST_UPDATE_DATE | |
| MAJOR_CLASS_ID | |
| MINOR_CLASS | |
| MSCM_POCODE | ACTIVE_STATUS |
| CONSIGN_CODE | |
| CREATION_DT | |
| DESCRIPTION | |
| IN_USE | |
| LAST_MODIFIED_DT | |
| PO_CODE | |
| POCODE_ID | |
| PROCURE_GROUP | |
| USED_BY_TRANS | |
| PERSONNEL | CREATION_DT |
| LAST_MODIFIED_DT | |
| NAME | |
| PERSONNEL_ID | |
| PRACTITIONER | CREATE_DATE |
| EMPLOYEE_ID | |
| FIRST_NAME | |
| LAST_NAME | |
| LAST_UPDATE_DATE | |
| PRACTITIONER_ID | |
| PROCEDURE_MODIFIER | CREATE_DATE |
| IS_ACTIVE | |
| LAST_UPDATE_DATE | |
| PROCEDURE_MOD_CODE | |
| PROCEDURE_MOD_DESC | |
| PROCEDURE_MOD_ID | |
| PROCEDURE_TEMP_ITEM | CREATE_DATE |
| ITEM_ID | |
| LAST_UPDATE_DATE | |
| PROC_TEMP_ID | |
| QUANTITY | |
| SEQUENCE_NBR | |
| PROCEDURE_TEMPLATE | CREATE_DATE |
| FACILITY_ID | |
| IS_ACTIVE | |
| LAST_UPDATE_DATE | |
| NAME | |
| PRACTITIONER_ID | |
| PROC_TEMP_ID | |
| PROCEDURE_ID | |
| PROCEDURES | CHARGE_CODE |
| CHARGEABLE_FL | |
| CREATE_DATE | |
| DESCRIPTION | |
| IS_ACTIVE | |
| LAST_UPDATE_DATE | |
| PROCEDURE_CODE | |
| PROCEDURE_ID | |
| REASON_CODES | CREATION_DT |
| DESCRIPTION | |
| IS_ACTIVE | |
| LAST_MODIFIED_DT | |
| REASON_CODE_ID | |
| TRANSACTION_TYPE | |
| REQUEST_HEADER | CREATE_DATE |
| DEPT_LOC_ID | |
| EVENT_HEADER_ID | |
| LAST_UPDATE_DATE | |
| LEGACY_PO_SHIPMENT_NO | |
| PO_SHIPMENT_NO | |
| REQUEST_HEADER_ID | |
| REQUEST_TYPE | |
| STATUS | |
| STOCK_LOCATION_ID | |
| VENDOR_ID | |
| REQUEST_HEADER_COMMENTS | CREATION_DT |
| EVENT_HEADER_ID | |
| LAST_MODIFIED_DT | |
| PO_COMMENT | |
| PO_UF1 | |
| PO_UF3 | |
| PO_UF5 | |
| REQUEST_LINE | ACCEPTED_QTY |
| ALT_UOM_CF | |
| CANCELLED_QTY | |
| CREATE_DATE | |
| ITEM_ID | |
| LAST_UPDATE_DATE | |
| LINE_NBR | |
| ORDERED_QTY | |
| RECEIVED_QTY | |
| REJECTED_WITH_REPL_QTY | |
| REMAINING_QTY | |
| REPLACED_PO | |
| REQUEST_HEADER_ID | |
| RETURN_NBR | |
| STATUS | |
| UNIT_COST | |
| REQUEST_LINE_COMMENTS | BILL_CODE |
| CASE_ID | |
| CREATION_DT | |
| EVENT_DETAIL_ID | |
| EVENT_HEADER_ID | |
| LAST_MODIFIED_DT | |
| PO_CODE | |
| PO_COMMENT | |
| PO_UF2 | |
| PO_UF4 | |
| PO_UF6 | |
| ROLE | CREATION_DT |
| DESCRIPTION | |
| LAST_MODIFIED_DT | |
| ROLE_ID | |
| SDI_COUNT_HEADER | COUNT_ID |
| CREATION_DT | |
| DEPT_LOC_ID | |
| LAST_MODIFIED_DT | |
| SYNC_TIME | |
| USER_ID | |
| SDI_COUNT_LINE | ACTION |
| COUNT_ID | |
| COUNT_QTY | |
| CREATION_DT | |
| DEPT_LOCATION_ITEM_ID | |
| ITEM_PRICE | |
| LAST_MODIFIED_DT | |
| LINE_ID | |
| NO_EXP_QTY | |
| PRE_COUNT_QOH | |
| REASON_CODE_ID | |
| REMARKS | |
| SDI_UOM | |
| SEQ_NUMBER | |
| STATUS | |
| SDI_COUNT_LINE_BNT | ACTION |
| CREATION_DT | |
| EXP_DATE | |
| LAST_MODIFIED_DT | |
| LINE_ID | |
| REASON_CODE_ID | |
| REMARKS | |
| STATUS | |
| TEMPERATURE | |
| TOTAL_QTY | |
| SDI_COUNT_LINE_EXPIRATION | ACTION |
| CREATION_DT | |
| EXP_DATE | |
| LAST_MODIFIED_DT | |
| LINE_ID | |
| REASON_CODE_ID | |
| REMARKS | |
| STATUS | |
| TOTAL_QTY | |
| SDI_COUNT_LINE_LOT | ACTION |
| CREATION_DT | |
| EXP_DATE | |
| LAST_MODIFIED_DT | |
| LINE_ID | |
| LOT_NO | |
| REASON_CODE_ID | |
| REMARKS | |
| STATUS | |
| TEMPERATURE | |
| TOTAL_QTY | |
| SDI_COUNT_LINE_SERIAL | ACTION |
| CREATION_DT | |
| EXP_DATE | |
| LAST_MODIFIED_DT | |
| LINE_ID | |
| LOT_NO | |
| REASON_CODE_ID | |
| REMARKS | |
| SERIAL_NO | |
| STATUS | |
| TEMPERATURE | |
| TOTAL_QTY | |
| TRANS_ITEM_UOM | BUY_FL |
| CREATION_DT | |
| GTIN | |
| ITEM_ID | |
| LAST_MODIFIED_DT | |
| MULT_UOM | |
| TRACK_FL | |
| TRANS_TYPE | |
| UOM | |
| UPN_NBR | |
| TRANSFER_DETAILS | CREATION_DT |
| DEPT_LOC_ID | |
| EXP_DATE | |
| ITEM_ID | |
| LAST_MODIFIED_DT | |
| LOT_NO | |
| QTY | |
| SDI_UOM | |
| SERIAL_NO | |
| TEMPERATURE | |
| TRACKING_FL | |
| TRANSFER_ID | |
| TYPE | |
| TRANSFER_HEADER | CREATE_DATE |
| DEPT_LOC_ID | |
| LAST_MODIFIED_DT | |
| TRANSFER_ID | |
| USER_ID |