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
EMAIL
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