SchemaSpy Analysis of lawprod.MSCM - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Wed May 18 12:10 CDT 2011
Legend:
Primary key columns
Columns with indexes
 

lawprod.MSCM contains 1956 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
ACCOUNT_DIST ACCOUNT_NO number 6
ACCOUNT_DIST ACCOUNT_UNIT varchar2 15
ACCOUNT_DIST DELIVERY_TICKET_ID varchar2 40
ACCOUNT_DIST DELIVERY_UNIT_NO number 4
ACCOUNT_DIST DISTRIB_LINE_NO number 5
ACTIVITY_LOG ACTIVITY_LOG_ID number 22
ACTIVITY_LOG ACTIVITY_TYPE number 3
ACTIVITY_LOG DESTINATION_LOCATION_ID number 22  √  null
ACTIVITY_LOG DURATION number 9,2  √  null
ACTIVITY_LOG END_TIME date 7  √  null
ACTIVITY_LOG QUANTITY number 9  √  null
ACTIVITY_LOG SOURCE_LOCATION_ID number 22  √  null
ACTIVITY_LOG START_TIME date 7
ACTIVITY_LOG STATUS varchar2 3  √  null
ACTIVITY_LOG SUB_UNIT number 22  √  null
ACTIVITY_LOG USER_ID number 22
ACTIVITY_TYPE ACTIVITY_NAME varchar2 50  √  null
ACTIVITY_TYPE ACTIVITY_TYPE number 3
ACTIVITY_TYPE DESCRIPTION varchar2 50  √  null
ACTIVITY_TYPE IS_ACTIVE varchar2 1  √  null
ACTIVITY_TYPE MODULE varchar2 10  √  null
ADDRESS ADDRESS_ID number 22
ADDRESS ADDRESS_LINE1 varchar2 30  √  null
ADDRESS ADDRESS_LINE2 varchar2 30  √  null
ADDRESS ADDRESS_LINE3 varchar2 30  √  null
ADDRESS ADDRESS_LINE4 varchar2 30  √  null
ADDRESS CITY_ADDR5 varchar2 18  √  null
ADDRESS COUNTRY varchar2 30  √  null
ADDRESS COUNTRY_CODE varchar2 2  √  null
ADDRESS POSTAL_CODE varchar2 10  √  null
ADDRESS STATE_PROV varchar2 2  √  null
APP_CONFIG APP_ID number 22
APP_CONFIG APP_NAME varchar2 30
APP_CONFIG IS_DEPLOYED char 1
APP_CONFIG VERSION varchar2 20  √  null
ASSEMBLY ACTIVITY number 22
ASSEMBLY ASM_ID number 22
ASSEMBLY ASM_LOC_NO number 22
ASSEMBLY ASM_TIME date 7
ASSEMBLY ASM_TYPE number 22
ASSEMBLY TS_NO varchar2 10
ASSEMBLY USER_ID number 22
ASSEMBLY_DECONTAM_VW ACTIVITY number 22
ASSEMBLY_DECONTAM_VW ASM_LOC_NO number 22
ASSEMBLY_DECONTAM_VW ASSM_DT date 7
ASSEMBLY_DECONTAM_VW CREAT_DT date 7  √  null
ASSEMBLY_DECONTAM_VW NO_EXP number 22  √  null
ASSEMBLY_DECONTAM_VW STATUS number 22
ASSEMBLY_DECONTAM_VW TL_DESCR varchar2 100
ASSEMBLY_DECONTAM_VW TL_NO varchar2 6
ASSEMBLY_DECONTAM_VW TOTAL number 22
ASSEMBLY_DECONTAM_VW TRAY_NO varchar2 5
ASSEMBLY_DECONTAM_VW TS_NO varchar2 10
ASSEMBLY_DECONTAM_VW USER_ID number 22
ATTRIBUTE ATTRIBUTE_ID number 22
ATTRIBUTE ATTRIBUTE_TYPE_ID number 22
ATTRIBUTE BOOLEAN_VALUE char 1  √  null
ATTRIBUTE FLOAT_VALUE number 13,4  √  null
ATTRIBUTE INT_VALUE number 22  √  null
ATTRIBUTE OBJECT_ID number 22
ATTRIBUTE OBJECT_TYPE_ID number 22
ATTRIBUTE STRING_VALUE varchar2 1000  √  null
ATTRIBUTE_TYPE ATTRIBUTE_TYPE_ID number 22
ATTRIBUTE_TYPE DATATYPE varchar2 30  √  null
ATTRIBUTE_TYPE DISPLAY_LABEL1 varchar2 255  √  null
ATTRIBUTE_TYPE DISPLAY_LABEL2 varchar2 255  √  null
ATTRIBUTE_TYPE GROUP_NO varchar2 30  √  null
ATTRIBUTE_TYPE HAS_VALUE_LIST char 1  √  null
ATTRIBUTE_TYPE MAX_LENGTH number 10  √  null
ATTRIBUTE_TYPE MAX_VALUE varchar2 30  √  null
ATTRIBUTE_TYPE MIN_VALUE varchar2 30  √  null
ATTRIBUTE_TYPE NAME varchar2 255  √  null
ATTRIBUTE_TYPE PRECSION number 20  √  null
ATTRIBUTE_VALUE_LIST ATTRIBUTE_TYPE_ID number 22
ATTRIBUTE_VALUE_LIST DISPLAY_LABEL varchar2 100
ATTRIBUTE_VALUE_LIST SEQUENCE number 22  √  null
ATTRIBUTE_VALUE_LIST VALUE varchar2 100
BATCH BATCH_DATE date 7
BATCH BATCH_ID number 22
BATCH BATCH_NO varchar2 20
BATCH TEMP_BATCH_ID varchar2 20  √  null
BATCH TOTAL number 22
BATCH USER_ID number 22
BATCH_ITEMS ACTIVITY number 22
BATCH_ITEMS ACTIVITY_LOC_NO number 22
BATCH_ITEMS BATCH_NO varchar2 20
BATCH_ITEMS BI_ID number 22
BATCH_ITEMS BI_NO varchar2 20
BATCH_ITEMS TS_NO varchar2 10
CARRIER_TRACKING_FORMAT BARCODE_LENGTH number 2
CARRIER_TRACKING_FORMAT CARRIER_TRACKING_FORMAT_ID number 22
CARRIER_TRACKING_FORMAT END_POSITION number 2
CARRIER_TRACKING_FORMAT MAPTYPE char 1  √  null
CARRIER_TRACKING_FORMAT NAME varchar2 30  √  null
CARRIER_TRACKING_FORMAT START_POSITION number 2
CARRIER_TRACKING_FORMAT STARTS_WITH varchar2 20  √  null
CARRIER_TRACKING_FORMAT SUPPLIER_END_POSITION number 2  √  null
CARRIER_TRACKING_FORMAT SUPPLIER_START_POSITION number 2  √  null
CARRIER_TRACKING_FORMAT TRACKING_NO_LENGTH number 2
CASE_CART_HISTORY_VW ACTIVITY number 22
CASE_CART_HISTORY_VW ASSM_DATE date 7
CASE_CART_HISTORY_VW CASECART_ASSEMBLY_ACTIVITY varchar2 17  √  null
CASE_CART_HISTORY_VW CASECART_NO varchar2 8
CASE_CART_HISTORY_VW COMPANY_NO number 4
CASE_CART_HISTORY_VW DESCRIPTION varchar2 30  √  null
CASE_CART_HISTORY_VW FIRST_NAME varchar2 55  √  null
CASE_CART_HISTORY_VW LAST_NAME varchar2 55  √  null
CASE_CART_HISTORY_VW LOCATION_CODE varchar2 5
CASE_CART_HISTORY_VW LOCATION_ID number 22
CASE_CART_HISTORY_VW NAME varchar2 50
CASE_CART_HISTORY_VW PICK_LIST_NO varchar2 6  √  null
CASECART CASECART_ID number 22
CASECART CASECART_NO varchar2 8
CASECART LOC_BIN varchar2 7  √  null
CASECART LOC_NO number 22
CASECART_ASSEMBLY ASM_TIME date 7
CASECART_ASSEMBLY ASSM_LOC_NO number 22
CASECART_ASSEMBLY CARTSET_ASSM_ID number 22
CASECART_ASSEMBLY CARTSET_ASSM_NO varchar2 10
CASECART_ASSEMBLY CASECART_NO varchar2 8
CASECART_ASSEMBLY TOTAL number 22  √  null
CASECART_ASSEMBLY USER_ID number 22
CASECART_ASSEMBLY_LOG ACTIVITY number 22
CASECART_ASSEMBLY_LOG ASSM_DATE date 7
CASECART_ASSEMBLY_LOG CARTSET_ASSM_LOGID number 22
CASECART_ASSEMBLY_LOG CARTSET_ASSM_LOGNO varchar2 20
CASECART_ASSEMBLY_LOG CARTSET_ASSM_NO varchar2 10
CASECART_ASSEMBLY_LOG LOC_NO number 22
CASECART_ASSEMBLY_LOG TOTAL number 22  √  null
CASECART_ASSEMBLY_LOG USER_ID number 22
CASECART_ITEMS ACT_DATE date 7
CASECART_ITEMS ACTIVITY number 22
CASECART_ITEMS ACTIVITY_LOC_NO number 22
CASECART_ITEMS ASM_ID varchar2 10  √  null
CASECART_ITEMS CARTITEM_ID number 22
CASECART_ITEMS CARTITEM_NO varchar2 20
CASECART_ITEMS CARTSET_ASSM_NO varchar2 10
CASECART_ITEMS TS_NO varchar2 10
CHARGE_DETAIL BIN varchar2 7  √  null
CHARGE_DETAIL CHARGE_DTL_ID number 22
CHARGE_DETAIL CHARGE_ID number 22
CHARGE_DETAIL COST number 13,5  √  null
CHARGE_DETAIL CREATE_DATE date 7
CHARGE_DETAIL ITEM_ID number 22
CHARGE_DETAIL LAST_UPDATE_DATE date 7  √  null
CHARGE_DETAIL LOT_NBR varchar2 10  √  null
CHARGE_DETAIL ORIGINAL_QTY number 13
CHARGE_DETAIL PATIENT_PRICE number 13,2  √  null
CHARGE_DETAIL QTY number 13
CHARGE_DETAIL REPLENISHMENT_TYPE char 1 '0'
CHARGE_DETAIL SERIAL_NBR varchar2 16  √  null
CHARGE_DETAIL SPLIT_GROUP_NO number 22  √  0
CHARGE_DETAIL SUBLOT varchar2 6  √  null
CHARGE_DETAIL SUPPLY_LOCATION_ID number 22  √  null
CHARGE_DETAIL UOM varchar2 4
CHARGE_DETAIL UPLOAD_MSG varchar2 150  √  null
CHARGE_DETAIL UPLOAD_STATUS number 1  √  null
CHARGE_HEADER BATCH_NO number 22  √  null
CHARGE_HEADER CHARGE_DATE date 7
CHARGE_HEADER CHARGE_ID number 22
CHARGE_HEADER DRAFT_NO number 4  √  null
CHARGE_HEADER IS_FLOOR_CHARGE char 1
CHARGE_HEADER LAST_UPDATE_DATE date 7  √  null
CHARGE_HEADER PATIENT_LOCATION_ID number 22  √  null
CHARGE_HEADER PATIENT_VISIT_ID number 22  √  null
CHARGE_HEADER REQ_LOC_ID number 22
CHARGE_HEADER REVENUE_CENTER_ID number 22
CHARGE_HEADER TXN_DATE date 7
CHARGE_HEADER TXN_TYPE char 1
CHARGE_HEADER USER_ID number 22
CHARGE_ISSUE CHARGE_DTL_ID number 22
CHARGE_ISSUE CHARGE_ISSUE_SEQ number 22
CHARGE_ISSUE CREATE_DATE date 7
CHARGE_ISSUE LAST_UPDATE_DATE date 7  √  null
CHARGE_ISSUE PAR_ISSUE_FLG char 1
CHARGE_ISSUE PAR_ISSUE_ID number 22
CHARGE_ISSUE UPLOAD_MSG varchar2 150  √  null
CHARGE_SUPPLY_LOCATION CHARGE_ID number 22
CHARGE_SUPPLY_LOCATION CHARGE_SUP_LOC_SEQ number 22
CHARGE_SUPPLY_LOCATION SUPPLY_LOCATION_ID number 22
CODE CODE_DESCR varchar2 100  √  null
CODE CODE_ID number 3
CODE CODE_SHORT varchar2 20
COLOR COLOR_NO number 4
COLOR NAME varchar2 40
COMPANY ADDED_TO_MSC char 1
COMPANY AUDIT_ITL_FL char 1  √  null
COMPANY AUDIT_ITM_FL char 1  √  null
COMPANY COMPANY_NO number 4
COMPANY COST_METHOD varchar2 4  √  null
COMPANY CREATION_DT date 7
COMPANY DESCRIPTION varchar2 30  √  null
COMPANY EXT_DATA_IND char 1
COMPANY EXTERNAL_STATUS char 1  √  null
COMPANY ID_CONFLICT_DT date 7  √  null
COMPANY IS_ACTIVE char 1
COMPANY ITEM_GROUP varchar2 5
COMPANY LAST_MODIFIED_DT date 7
CONFIGURATION DESCRIPTION varchar2 50  √  null
CONFIGURATION MODULE varchar2 20
CONFIGURATION NAME varchar2 20
CONFIGURATION VALUE varchar2 20
CONTENT_RESULT ASID varchar2 10  √  null
CONTENT_RESULT COMMENTS varchar2 50  √  null
CONTENT_RESULT DB_ID number 22
CONTENT_RESULT LOAD_ID number 22
CONTENT_RESULT RECORD_VALUE varchar2 50  √  null
CONTENT_RESULT RECORDED_BY number 22
CONTENT_RESULT RECORDED_DATE date 7
CONTENT_RESULT TEST_ID number 22
CONTENT_RESULT_LOG ACTION_DESC varchar2 50  √  null
CONTENT_RESULT_LOG ASID varchar2 10  √  null
CONTENT_RESULT_LOG DB_ID number 22
CONTENT_RESULT_LOG LOAD_ID number 22  √  null
CONTENT_RESULT_LOG LOG_DATE date 7  √  null
CONTENT_RESULT_LOG NEW_VALUE varchar2 50  √  null
CONTENT_RESULT_LOG OLD_VALUE varchar2 50  √  null
CONTENT_RESULT_LOG PARAM_ID number 22  √  null
CONTENT_RESULT_LOG USER_ID number 22  √  null
COUNTFORM COMPANY_NO number 4
COUNTFORM COUNTFORM_ID number 20
COUNTFORM CREATION_DT date 7
COUNTFORM EXTERNAL_STATUS char 1
COUNTFORM LAST_MODIFIED_DT date 7  √  null
COUNTFORM SELECT_ID varchar2 5
COUNTFORM TOTAL number 6
COUNTFORM_ITEMS BIN varchar2 7  √  null
COUNTFORM_ITEMS COUNTFORM_ID number 20
COUNTFORM_ITEMS COUNTFORM_ITEM_ID number 20
COUNTFORM_ITEMS COUNTFORM_LINE_NO number 4
COUNTFORM_ITEMS CREATION_DT date 7
COUNTFORM_ITEMS EXTERNAL_STATUS char 1
COUNTFORM_ITEMS ITEM_ID number 22
COUNTFORM_ITEMS LAST_MODIFIED_DT date 7  √  null
COUNTFORM_ITEMS LOCATION_ID number 22  √  null
COUNTFORM_ITEMS LOT_SERIAL varchar2 16  √  null
COUNTFORM_ITEMS LOT_TRACK_FL varchar2 1  √  null
COUNTFORM_ITEMS PAGE number 4
COUNTFORM_ITEMS SER_TRACK_FL varchar2 1  √  null
COUNTFORM_ITEMS SQOH number 13,4  √  null
COUNTFORM_ITEMS UOM varchar2 4  √  null
DECONTAM_DETAILS ACT_DATE date 7
DECONTAM_DETAILS ASID varchar2 10
DECONTAM_DETAILS CARTSET_ASSM_NO varchar2 10
DECONTAM_DETAILS CASECART_NO varchar2 8
DECONTAM_DETAILS TL_NO varchar2 6
DECONTAM_DETAILS TRAYLIST_NAME varchar2 100
DECONTAM_DETAILS_HELP ASM_LOC_NO number 22
DECONTAM_DETAILS_HELP NUMBER_OF_TRAYSET number 22  √  null
DECONTAM_DETAILS_HELP USER_ID number 22
DECONTAMINATION_METHOD DECONTAM_METHOD_ID number 4
DECONTAMINATION_METHOD DECONTAM_METHOD_NAME varchar2 80
DECONTAMINATION_UNIT DECONTAM_ID number 4
DECONTAMINATION_UNIT DECONTAM_METHOD_ID number 4
DECONTAMINATION_UNIT DECONTAM_NAME varchar2 80  √  null
DECONTAMINATION_UNIT LOCATION_ID number 22
DEFAULT_REVENUE_CENTER REVENUE_CENTER_ID number 22
DEFAULT_REVENUE_CENTER USER_ID number 22
DEFAULT_SCHEDULE_TRACKER LAST_UPDATE_DATE date 7
DEFAULT_SCHEDULE_TRACKER NEXT_RUN_TIME date 7
DEFAULT_USER_LOCATION_TYPE LOCATION_ID number 22  √  null
DEFAULT_USER_LOCATION_TYPE LOCATION_TYPE_ID number 22
DEFAULT_USER_LOCATION_TYPE USER_ID number 22
DELIVERY_EVENT ACTION varchar2 10
DELIVERY_EVENT CREATED date 7
DELIVERY_EVENT DELIVERY_EVENT_ID number 20
DELIVERY_EVENT LOCATION_ID number 22
DELIVERY_EVENT MANIFEST_ID number 22  √  null
DELIVERY_EVENT PACKAGE_COUNT number 4  √  null
DELIVERY_EVENT RECIPIENT_ID number 22  √  null
DELIVERY_EVENT SIGNATURE_ID number 22  √  null
DELIVERY_EVENT USER_NAME varchar2 20
DELIVERY_EVENT_LINE DELIVERY_EVENT_ID number 20
DELIVERY_EVENT_LINE DELIVERY_TICKET_ID varchar2 40
DELIVERY_EVENT_LINE DELIVERY_UNIT_NO number 4
DELIVERY_EVENT_LINE DISTRIB_LINE_NO number 5
DELIVERY_TICKET ACCEPT char 1
DELIVERY_TICKET ALT_REQUESTOR varchar2 10  √  null
DELIVERY_TICKET CREATION_DT date 7
DELIVERY_TICKET DELIVER_TO varchar2 30  √  null
DELIVERY_TICKET DELIVERED varchar2 1 'F'
DELIVERY_TICKET DELIVERY_LOCATION_ID number 22
DELIVERY_TICKET DELIVERY_TICKET_ID varchar2 40
DELIVERY_TICKET DELIVERY_TICKET_TYPE char 1
DELIVERY_TICKET FROM_LOCATION_ID number 22  √  null
DELIVERY_TICKET LAST_MODIFIED_DT date 7  √  null
DELIVERY_TICKET PO_CODE varchar2 4  √  null
DELIVERY_TICKET PO_NO varchar2 20  √  null
DELIVERY_TICKET PO_RELEASE number 4  √  null
DELIVERY_TICKET RCV_USER_ID varchar2 80  √  null
DELIVERY_TICKET RECEIVER_NO number 10  √  null
DELIVERY_TICKET RECV_LOCATION_ID number 22
DELIVERY_TICKET REQUESTED_DEL_DT date 7  √  null
DELIVERY_TICKET REQUESTOR_ID number 22  √  null
DELIVERY_TICKET REQUISITION_NO varchar2 10  √  null
DELIVERY_TICKET SHIPMENT_NO number 20  √  null
DELIVERY_TICKET VENDOR_SYSTEM_ID number 22  √  null
DELIVERY_UNIT DELIVERY_TICKET_ID varchar2 40
DELIVERY_UNIT DELIVERY_UNIT_NO number 4
DELIVERY_UNIT IS_ACTIVE char 1  √  'T'
DELIVERY_UNIT NOTE_ID number 20  √  null
DELIVERY_UNIT NUM_LABELS number 7
DELIVERY_UNIT TRACKING_NO varchar2 50  √  null
DISTRIB_LINE BIN varchar2 7  √  null
DISTRIB_LINE BO_CAN_BACK_ORD char 1  √  'B'
DISTRIB_LINE BO_REM_QTY number 15,4  √  null
DISTRIB_LINE CURRENT_LOCATION_ID number 22
DISTRIB_LINE DELIVERY_QTY number 15,4
DISTRIB_LINE DELIVERY_TICKET_ID varchar2 40
DISTRIB_LINE DELIVERY_UNIT_NO number 4
DISTRIB_LINE DESCR varchar2 30  √  null
DISTRIB_LINE DISTRIB_LINE_NO number 5
DISTRIB_LINE ITEM_NO varchar2 32  √  null
DISTRIB_LINE LAST_MODIFIED_DT date 7
DISTRIB_LINE MFR_CAT_NO varchar2 35  √  null
DISTRIB_LINE NEXT_ACTION varchar2 10  √  null
DISTRIB_LINE NEXT_LOCATION_ID number 22  √  null
DISTRIB_LINE NOTE_ID number 20  √  null
DISTRIB_LINE ORDERED_QTY number 15,4  √  null
DISTRIB_LINE PO_LINE_NO number 6  √  null
DISTRIB_LINE RECV_LINE_NO number 6  √  null
DISTRIB_LINE SOURCE_LINE_NO number 6  √  null
DISTRIB_LINE STATE varchar2 10
DISTRIB_LINE STATUS varchar2 10
DISTRIB_LINE UOM varchar2 4  √  null
DISTRIB_LINE VENDOR_ITEM_NO varchar2 32  √  null
DOCKLOG CARRIER_VENDOR_SYSTEM_ID number 22  √  null
DOCKLOG COUNT number 6  √  null
DOCKLOG CREATE_DT date 7  √  null
DOCKLOG DOCKLOG_ID number 20
DOCKLOG RECV_LOCATION_ID number 22
DOCKLOG USER_ID number 22
DOCKLOG_LINE DOCKLOG_ID number 20
DOCKLOG_LINE DOCKLOG_LINE_NO number 4
DOCKLOG_LINE TRACKING_NO varchar2 50  √  null
ERROR_LOG CREATION_DT date 7  √  null
ERROR_LOG ERROR_ID number 20
ERROR_LOG EVT_DETAIL_SEQ number 6  √  null
ERROR_LOG EVT_HEADER_ID number 20  √  null
ERROR_LOG FORM_NAME varchar2 20  √  null
ERROR_LOG MESSAGE_TEXT varchar2 2000  √  null
ERROR_LOG RETURN_ERROR_CD varchar2 20  √  null
ERROR_LOG TYPE varchar2 20  √  null
EVENT_DETAIL CREATION_DT date 7
EVENT_DETAIL DETAIL_UPLOAD_IND varchar2 8
EVENT_DETAIL EVENT_DETAIL_GD_01 date 7  √  null
EVENT_DETAIL EVENT_DETAIL_GD_02 date 7  √  null
EVENT_DETAIL EVENT_DETAIL_GN_01 number 36,4  √  null
EVENT_DETAIL EVENT_DETAIL_GN_02 number 36,4  √  null
EVENT_DETAIL EVENT_DETAIL_GN_03 number 32  √  null
EVENT_DETAIL EVENT_DETAIL_GN_04 number 32  √  null
EVENT_DETAIL EVENT_DETAIL_GT_01 varchar2 100  √  null
EVENT_DETAIL EVENT_DETAIL_GT_02 varchar2 100  √  null
EVENT_DETAIL EVENT_DETAIL_GT_03 varchar2 100  √  null
EVENT_DETAIL EVENT_DETAIL_GT_04 varchar2 100  √  null
EVENT_DETAIL EVENT_DETAIL_GT_05 varchar2 100  √  null
EVENT_DETAIL EVENT_DETAIL_GT_06 varchar2 100  √  null
EVENT_DETAIL EVENT_DETAIL_SEQ number 6
EVENT_DETAIL EVENT_HEADER_ID number 20
EVENT_DETAIL EVENT_TIMESTAMP date 7
EVENT_DETAIL ITEM_ID number 22  √  null
EVENT_DETAIL LAST_MODIFIED_DT date 7
EVENT_DETAIL LOT_NO varchar2 10  √  null
EVENT_DETAIL QUANTITY number 13,4  √  null
EVENT_DETAIL REQUESTING_LOCATION_ID number 22  √  null
EVENT_DETAIL REQUIRING_BIN_NO varchar2 7  √  null
EVENT_DETAIL RETRY_COUNT number 4  √  null
EVENT_DETAIL SERIAL_NO varchar2 16  √  null
EVENT_DETAIL SOURCE_BIN_NO varchar2 7  √  null
EVENT_DETAIL SOURCE_LOCATION_ID number 22  √  null
EVENT_DETAIL TASK_ID number 20  √  null
EVENT_DETAIL UOM varchar2 4  √  null
EVENT_HEADER CREATION_DT date 7
EVENT_HEADER DOCUMENT_PRINTER_ID number 8  √  null
EVENT_HEADER EVENT_HEADER_GD_01 date 7  √  null
EVENT_HEADER EVENT_HEADER_GD_02 date 7  √  null
EVENT_HEADER EVENT_HEADER_GN_01 number 32  √  null
EVENT_HEADER EVENT_HEADER_GN_02 number 32  √  null
EVENT_HEADER EVENT_HEADER_GN_03 number 32  √  null
EVENT_HEADER EVENT_HEADER_GN_04 number 32  √  null
EVENT_HEADER EVENT_HEADER_GT_01 varchar2 100  √  null
EVENT_HEADER EVENT_HEADER_GT_02 varchar2 100  √  null
EVENT_HEADER EVENT_HEADER_GT_03 varchar2 100  √  null
EVENT_HEADER EVENT_HEADER_GT_04 varchar2 100  √  null
EVENT_HEADER EVENT_HEADER_GT_05 varchar2 100  √  null
EVENT_HEADER EVENT_HEADER_GT_06 varchar2 100  √  null
EVENT_HEADER EVENT_HEADER_ID number 20
EVENT_HEADER EVENT_TYPE varchar2 10
EVENT_HEADER HEADER_UPLOAD_IND varchar2 8
EVENT_HEADER HH_SYNC_TIMESTAMP date 7
EVENT_HEADER LAST_MODIFIED_DT date 7
EVENT_HEADER NEED_TO_PRINT number 1  √  -1
EVENT_HEADER RETRY_COUNT number 4  √  null
EVENT_HEADER USER_ID number 22
EVENT_STATUS_RANK DESCRIPTION varchar2 30
EVENT_STATUS_RANK RANK number 22
EVENT_STATUS_RANK STATUS_CODE varchar2 8
FACILITY CREATE_DATE date 7
FACILITY FACILITY_CODE varchar2 80
FACILITY FACILITY_DESC varchar2 256  √  null
FACILITY FACILITY_ID number 22
FACILITY IS_ACTIVE char 1
FACILITY LAST_UPDATE_DATE date 7  √  null
FACILITY SENDING_FACILITY varchar2 80
ICAUDIT_TRACKER LAST_PULL_DT date 7  √  null
INSTRUMENT_BY_LOCATION_VIEW ASID varchar2 10  √  null
INSTRUMENT_BY_LOCATION_VIEW COMMENTS varchar2 40  √  null
INSTRUMENT_BY_LOCATION_VIEW COMPANY_NAME varchar2 30  √  null
INSTRUMENT_BY_LOCATION_VIEW COMPANY_NO number 4
INSTRUMENT_BY_LOCATION_VIEW DESCR varchar2 100  √  null
INSTRUMENT_BY_LOCATION_VIEW INSTRUMENT_ID varchar2 32  √  null
INSTRUMENT_BY_LOCATION_VIEW ITEM_DESCRIPTION varchar2 100  √  null
INSTRUMENT_BY_LOCATION_VIEW ITEM_NO varchar2 32
INSTRUMENT_BY_LOCATION_VIEW LOCATION_CODE varchar2 5
INSTRUMENT_BY_LOCATION_VIEW LOCATION_ID number 22
INSTRUMENT_BY_LOCATION_VIEW LOCATION_NAME varchar2 50
INSTRUMENT_BY_LOCATION_VIEW MOD_DATE date 7
INSTRUMENT_BY_LOCATION_VIEW PATIENT_ID varchar2 14  √  null
INSTRUMENT_BY_LOCATION_VIEW STATUS char 1  √  null
INSTRUMENT_BY_LOCATION_VIEW TRAY_NO varchar2 5  √  null
INSTRUMENT_BY_LOCATION_VIEW TS_STATUS number 22  √  null
INSTRUMENT_BY_LOCATION_VIEW USAGE_COUNT number 22  √  null
INSTRUMENT_HISTORY_VIEW ACTIVITY varchar2 19  √  null
INSTRUMENT_HISTORY_VIEW COMPANY_NAME varchar2 30  √  null
INSTRUMENT_HISTORY_VIEW COMPANY_NO number 4
INSTRUMENT_HISTORY_VIEW COMPANY_NO_NAME varchar2 73  √  null
INSTRUMENT_HISTORY_VIEW DT_TIME date 7
INSTRUMENT_HISTORY_VIEW ID_NBR varchar2 16  √  null
INSTRUMENT_HISTORY_VIEW ID_TYPE varchar2 18  √  null
INSTRUMENT_HISTORY_VIEW INSTRUMENT_ID varchar2 32  √  null
INSTRUMENT_HISTORY_VIEW LOCATION_CODE varchar2 5
INSTRUMENT_HISTORY_VIEW LOCATION_CODE_NAME varchar2 58  √  null
INSTRUMENT_HISTORY_VIEW LOCATION_ID number 22
INSTRUMENT_HISTORY_VIEW LOCATION_NAME varchar2 50
INSTRUMENT_HISTORY_VIEW USER_NAME varchar2 112  √  null
INSTRUMENT_ID_ASSEMBLY_VIEW EX_NO number 22  √  null
INSTRUMENT_ID_ASSEMBLY_VIEW INSTRUMENT_TRACK_ID number 22  √  null
INSTRUMENT_ID_ASSEMBLY_VIEW TS_ID number 22
INSTRUMENT_ID_ASSEMBLY_VIEW TS_INST_TK_DATA_ID number 20
INSTRUMENT_TRACK ACTIVITY number 22  √  null
INSTRUMENT_TRACK BIN_LOCATION varchar2 7  √  null
INSTRUMENT_TRACK CREATION_DT date 7
INSTRUMENT_TRACK DT_TIME date 7
INSTRUMENT_TRACK INSTRUMENT_ID varchar2 32  √  null
INSTRUMENT_TRACK INSTRUMENT_TRACK_ID number 20
INSTRUMENT_TRACK LOCATION_ID number 22
INSTRUMENT_TRACK LOCATION_ITEM_ID number 20
INSTRUMENT_TRACK MFG_SR_NBR varchar2 16  √  null
INSTRUMENT_TRACK STATUS char 1  √  null
INSTRUMENT_TRACK USAGE_COUNT number 22 0
INSTRUMENT_TRACK USER_ID number 22  √  null
INSTRUMENT_TRACK_LOG ACTIVITY number 22  √  null
INSTRUMENT_TRACK_LOG BIN_LOCATION varchar2 7  √  null
INSTRUMENT_TRACK_LOG DT_TIME date 7
INSTRUMENT_TRACK_LOG ID_NBR varchar2 16  √  null
INSTRUMENT_TRACK_LOG INST_TRACK_LOG_ID number 20
INSTRUMENT_TRACK_LOG INSTRUMENT_TRACK_ID number 20
INSTRUMENT_TRACK_LOG LOCATION_ID number 22
INSTRUMENT_TRACK_LOG OLD_MFG_SR_NBR varchar2 16  √  null
INSTRUMENT_TRACK_LOG USER_ID number 22  √  null
ITEM CREATION_DT date 7
ITEM DESCR varchar2 100  √  null
ITEM EXT_DATA_IND char 1  √  null
ITEM EXTERNAL_STATUS char 1  √  null
ITEM IMGLNK varchar2 255  √  null
ITEM ITEM_GROUP varchar2 5  √  null
ITEM ITEM_ID number 22
ITEM ITEM_NO varchar2 32
ITEM LAST_MODIFIED_DT date 7
ITEM LOT_TRACK_FL char 1  √  ('N')
ITEM MAJOR_CLASS varchar2 4  √  null
ITEM MFR_CAT_NO varchar2 35  √  null
ITEM MFR_ID number 22  √  null
ITEM MINOR_CLASS varchar2 4  √  null
ITEM PROCUREMENT_ITEM_ID number 22  √  null
ITEM SER_TRACK_FL char 1  √  ('N')
ITEM SERIAL_TRACKED_IND char 1  √  ('N')
ITEM STATUS char 1
ITEM UOM varchar2 4  √  null
ITEM USAGE_IDENTIFIER varchar2 1  √  null
ITEM USAGE_LIMIT number 22 0
ITEM_GROUP DESCRIPTION varchar2 30  √  null
ITEM_GROUP ITEM_GROUP varchar2 5
ITEM_INFO_VIEW INSTRUMENT_ID varchar2 32  √  null
ITEM_INFO_VIEW ITEM_DESCRIPTION varchar2 100  √  null
ITEM_INFO_VIEW ITEM_NO varchar2 32
ITEM_ON_TRAY_LIST_HELP ITEM_ID number 22
ITEM_ON_TRAY_LIST_HELP QTY number 22
ITEM_ON_TRAY_LIST_HELP SOURCE_LOCATION_NO number 22  √  null
ITEM_ON_TRAY_LIST_HELP TL_ID number 22
ITEM_ON_TRAY_LIST_HELP TL_NO varchar2 6
ITEMS_IN_TRAY_LISTS COMPANY_NAME varchar2 30  √  null
ITEMS_IN_TRAY_LISTS COMPANY_NO number 4
ITEMS_IN_TRAY_LISTS IMAGEPATH varchar2 255  √  null
ITEMS_IN_TRAY_LISTS ITEM_DESCRIPTION varchar2 100  √  null
ITEMS_IN_TRAY_LISTS ITEM_ID number 22
ITEMS_IN_TRAY_LISTS ITEM_NO varchar2 32
ITEMS_IN_TRAY_LISTS LAST_MODIFIED_DT date 7
ITEMS_IN_TRAY_LISTS LOCATION_CODE varchar2 5
ITEMS_IN_TRAY_LISTS LOCATION_ID number 22
ITEMS_IN_TRAY_LISTS LOCATION_NAME varchar2 50
ITEMS_IN_TRAY_LISTS MANUFACTURER_CODE varchar2 4  √  null
ITEMS_IN_TRAY_LISTS MANUFACTURER_DIV varchar2 4  √  null
ITEMS_IN_TRAY_LISTS MANUFACTURER_NAME varchar2 30  √  null
ITEMS_IN_TRAY_LISTS MFR_NO varchar2 35  √  null
ITEMS_IN_TRAY_LISTS NUMBER_OF_TRAYLISTS number 22  √  null
ITEMS_IN_TRAY_LISTS PROC_ITEM_NO varchar2 32  √  null
ITEMS_IN_TRAY_LISTS QUANTITY_IN_SERVICE number 22  √  null
LAWSON_BINGRPDTL BIN varchar2 7
LAWSON_BINGRPDTL BIN_GROUP varchar2 7
LAWSON_BINGRPDTL BIN_SEQ number 6  √  null
LAWSON_BINGRPDTL COMPANY number 4
LAWSON_BINGRPDTL CREATION_DT date 7
LAWSON_BINGRPDTL LAST_MODIFIED_DT date 7  √  null
LAWSON_BINGRPDTL LOCATION varchar2 5
LAWSON_COMPANY AUDIT_ITL_FL char 1  √  null
LAWSON_COMPANY AUDIT_ITM_FL char 1  √  null
LAWSON_COMPANY COMPANY number 4
LAWSON_COMPANY COST_METHOD varchar2 4  √  null
LAWSON_COMPANY CREATION_DT date 7
LAWSON_COMPANY ITEM_GROUP varchar2 5
LAWSON_COMPANY LAST_MODIFIED_DT date 7  √  null
LAWSON_COMPANY NAME varchar2 30  √  null
LAWSON_ICAUDIT AFTER_IMAGE varchar2 32  √  null
LAWSON_ICAUDIT BEFORE_IMAGE varchar2 32  √  null
LAWSON_ICAUDIT COMPANY number 4
LAWSON_ICAUDIT CREATION_DT date 7
LAWSON_ICAUDIT DB_FILE varchar2 3
LAWSON_ICAUDIT FLD_NBR number 4  √  null
LAWSON_ICAUDIT ITEM varchar2 32
LAWSON_ICAUDIT ITEM_GROUP varchar2 5  √  null
LAWSON_ICAUDIT LAST_MODIFIED_DT date 7  √  null
LAWSON_ICAUDIT LOCATION varchar2 5
LAWSON_ICAUDIT TXN_DATE date 7
LAWSON_ICAUDIT TXN_TIME varchar2 8
LAWSON_ICFREEZE BIN varchar2 7  √  null
LAWSON_ICFREEZE COMPANY number 4
LAWSON_ICFREEZE CREATION_DT date 7
LAWSON_ICFREEZE FREEZE_QTY number 13,4  √  null
LAWSON_ICFREEZE ITEM varchar2 32  √  null
LAWSON_ICFREEZE LAST_MODIFIED_DT date 7  √  null
LAWSON_ICFREEZE LINE number 4
LAWSON_ICFREEZE LOCATION varchar2 5  √  null
LAWSON_ICFREEZE LOT_SERIAL varchar2 16  √  null
LAWSON_ICFREEZE PAGE number 4
LAWSON_ICFREEZE SELECT_ID varchar2 5
LAWSON_ICFREEZE UOM varchar2 4  √  null
LAWSON_ICSELECT COMPANY number 4
LAWSON_ICSELECT CREATION_DT date 7
LAWSON_ICSELECT LAST_MODIFIED_DT date 7  √  null
LAWSON_ICSELECT SELECT_ID varchar2 5
LAWSON_ITEM ACTIVE_STATUS char 1  √  null
LAWSON_ITEM ALT_UOM varchar2 80  √  null
LAWSON_ITEM ALT_UOM_MULT varchar2 200  √  null
LAWSON_ITEM CREATION_DT date 7
LAWSON_ITEM DESCRIPTION varchar2 30  √  null
LAWSON_ITEM DESCRIPTION2 varchar2 30  √  null
LAWSON_ITEM ITEM varchar2 32
LAWSON_ITEM ITEM_GROUP varchar2 5
LAWSON_ITEM LAST_MODIFIED_DT date 7  √  null
LAWSON_ITEM LOT_TRACK_FL char 1  √  ('N')
LAWSON_ITEM MAJOR_CLASS varchar2 4  √  null
LAWSON_ITEM MANUF_CODE varchar2 4  √  null
LAWSON_ITEM MANUF_DIV varchar2 4  √  null
LAWSON_ITEM MANUF_NBR varchar2 35  √  null
LAWSON_ITEM MINOR_CLASS varchar2 4  √  null
LAWSON_ITEM SER_TRACK_FL char 1  √  ('N')
LAWSON_ITEM STOCK_UOM varchar2 4  √  null
LAWSON_ITEM TRACKING_FL varchar2 20  √  null
LAWSON_ITEM TRANS_FL varchar2 20  √  null
LAWSON_ITEM USE_IDENTIFIER char 1  √  null
LAWSON_ITEM_GROUP CREATION_DT date 7
LAWSON_ITEM_GROUP DESCRIPTION varchar2 30  √  null
LAWSON_ITEM_GROUP ITEM_GROUP varchar2 5
LAWSON_ITEM_GROUP LAST_MODIFIED_DT date 7  √  null
LAWSON_ITEMLOC ACTIVE_STATUS char 1  √  null
LAWSON_ITEMLOC ALLOW_ISS_FL char 1 'Y'
LAWSON_ITEMLOC AVG_COST number 13,5  √  null
LAWSON_ITEMLOC BIN_TRACK_FL char 1  √  null
LAWSON_ITEMLOC CHARGEABLE_FL char 1 'N'
LAWSON_ITEMLOC COMPANY number 4
LAWSON_ITEMLOC CREATION_DT date 7
LAWSON_ITEMLOC ITEM varchar2 32
LAWSON_ITEMLOC LAST_MODIFIED_DT date 7  √  null
LAWSON_ITEMLOC LOCATION varchar2 5
LAWSON_ITEMLOC LOT_TRACK_FL char 1  √  null
LAWSON_ITEMLOC MIN_ORDER number 17,4  √  0
LAWSON_ITEMLOC PREFER_BIN varchar2 7  √  null
LAWSON_ITEMLOC REORDER_POINT number 13,4  √  null
LAWSON_ITEMLOC SER_TRACK_FL char 1  √  null
LAWSON_ITEMLOC STD_COST number 13,5  √  null
LAWSON_ITEMLOC TRACKING_FL char 1  √  null
LAWSON_ITEMLOC UOM varchar2 4  √  null
LAWSON_ITEMSRC COMPANY number 4
LAWSON_ITEMSRC CREATION_DT date 7
LAWSON_ITEMSRC ITEM varchar2 32
LAWSON_ITEMSRC LAST_MODIFIED_DT date 7  √  null
LAWSON_ITEMSRC LOCATION varchar2 5
LAWSON_ITEMSRC REPL_FROM_BIN varchar2 7  √  null
LAWSON_ITEMSRC REPL_FROM_CO number 4  √  null
LAWSON_ITEMSRC REPL_FROM_LOC varchar2 5  √  null
LAWSON_ITEMSRC REPLENISH_PRI number 6
LAWSON_ITEMSRC STATUS number 1  √  0
LAWSON_LOCATION COMPANY number 4
LAWSON_LOCATION CREATION_DT date 7
LAWSON_LOCATION LAST_MODIFIED_DT date 7  √  null
LAWSON_LOCATION LOCATION varchar2 5
LAWSON_LOCATION LOCATION_TYPE varchar2 1  √  null
LAWSON_LOCATION NAME varchar2 30  √  null
LAWSON_LOCATION_BIN BIN varchar2 7
LAWSON_LOCATION_BIN COMPANY number 4
LAWSON_LOCATION_BIN CREATION_DT date 7
LAWSON_LOCATION_BIN LAST_MODIFIED_DT date 7  √  null
LAWSON_LOCATION_BIN LOCATION varchar2 5
LAWSON_LOCATION_GROUP COMPANY number 4
LAWSON_LOCATION_GROUP CREATION_DT date 7
LAWSON_LOCATION_GROUP LAST_MODIFIED_DT date 7  √  null
LAWSON_LOCATION_GROUP LOCATION varchar2 5
LAWSON_LOCATION_GROUP REPORT_GRP varchar2 5
LAWSON_LOCATION_ITEM_BIN BIN varchar2 7  √  null
LAWSON_LOCATION_ITEM_BIN COMPANY number 4
LAWSON_LOCATION_ITEM_BIN CREATION_DT date 7
LAWSON_LOCATION_ITEM_BIN ITEM varchar2 32
LAWSON_LOCATION_ITEM_BIN LAST_MODIFIED_DT date 7  √  null
LAWSON_LOCATION_ITEM_BIN LOCATION varchar2 5
LAWSON_LOCATION_ITEM_BIN UOM varchar2 4  √  null
LAWSON_LOCATION_ITEM_COST COMPANY number 4
LAWSON_LOCATION_ITEM_COST CREATION_DT date 7
LAWSON_LOCATION_ITEM_COST EARLY_DL_DT date 7
LAWSON_LOCATION_ITEM_COST EBUY_UOM_MULT number 15,4  √  null
LAWSON_LOCATION_ITEM_COST ENT_UNIT_CST number 15,4  √  null
LAWSON_LOCATION_ITEM_COST ITEM varchar2 32
LAWSON_LOCATION_ITEM_COST LAST_MODIFIED_DT date 7  √  null
LAWSON_LOCATION_ITEM_COST LOCATION varchar2 5
LAWSON_LOCATION_ITEM_LOT BIN varchar2 7  √  null
LAWSON_LOCATION_ITEM_LOT COMPANY number 4
LAWSON_LOCATION_ITEM_LOT CREATION_DT date 7  √  null
LAWSON_LOCATION_ITEM_LOT EXPIRE_DATE varchar2 10  √  null
LAWSON_LOCATION_ITEM_LOT ITEM varchar2 32
LAWSON_LOCATION_ITEM_LOT LAST_MODIFIED_DT date 7  √  null
LAWSON_LOCATION_ITEM_LOT LOCATION varchar2 5
LAWSON_LOCATION_ITEM_LOT LOT varchar2 10
LAWSON_LOCATION_ITEM_LOT SUBLOT varchar2 6  √  null
LAWSON_LOCATION_ITEM_LOT UOM varchar2 4
LAWSON_LOCATION_ITEM_SERIAL BIN varchar2 7  √  null
LAWSON_LOCATION_ITEM_SERIAL COMPANY number 4
LAWSON_LOCATION_ITEM_SERIAL CREATION_DT date 7  √  null
LAWSON_LOCATION_ITEM_SERIAL ITEM varchar2 32
LAWSON_LOCATION_ITEM_SERIAL LAST_MODIFIED_DT date 7  √  null
LAWSON_LOCATION_ITEM_SERIAL LOCATION varchar2 5
LAWSON_LOCATION_ITEM_SERIAL SERIAL varchar2 16
LAWSON_MFGR CREATION_DT date 7
LAWSON_MFGR DESCRIPTION varchar2 30  √  null
LAWSON_MFGR ITEM_GROUP varchar2 5
LAWSON_MFGR LAST_MODIFIED_DT date 7  √  null
LAWSON_MFGR MANUF_CODE varchar2 4
LAWSON_MFGR MANUF_DIVISION varchar2 4  √  null
LAWSON_PICKLIST COMPANY number 4
LAWSON_PICKLIST CREATION_DT date 7  √  null
LAWSON_PICKLIST DOC_NBR varchar2 10  √  null
LAWSON_PICKLIST LAST_MODIFIED_DT date 7  √  null
LAWSON_PICKLIST LOCATION varchar2 5
LAWSON_PICKLIST REQHEADER_COMPANY number 4  √  null
LAWSON_PICKLIST REQHEADER_CREATION_DATE date 7  √  null
LAWSON_PICKLIST REQHEADER_DELIVER_TO varchar2 30  √  null
LAWSON_PICKLIST REQHEADER_REQ_LOCATION varchar2 5  √  null
LAWSON_PICKLIST REQHEADER_REQUESTER varchar2 10  √  null
LAWSON_PICKLIST SHIP_DATE date 7  √  null
LAWSON_PICKLIST SHIPMENT_NBR number 10
LAWSON_PICKLIST STATUS number 1  √  null
LAWSON_PICKLIST VENDOR varchar2 9  √  null
LAWSON_PICKLIST_LINE COMPANY number 4
LAWSON_PICKLIST_LINE CREATION_DT date 7  √  null
LAWSON_PICKLIST_LINE DESCRIPTION varchar2 30  √  null
LAWSON_PICKLIST_LINE ITEM varchar2 32  √  null
LAWSON_PICKLIST_LINE ITEM_GROUP varchar2 5  √  null
LAWSON_PICKLIST_LINE LAST_MODIFIED_DT date 7  √  null
LAWSON_PICKLIST_LINE LINE_NBR number 6
LAWSON_PICKLIST_LINE LINE_TYPE char 1  √  null
LAWSON_PICKLIST_LINE LOCATION varchar2 5
LAWSON_PICKLIST_LINE OPEN_QUANTITY varchar2 14  √  null
LAWSON_PICKLIST_LINE REQLINE_FILL_OR_KILL char 1  √  null
LAWSON_PICKLIST_LINE SHIPMENT_NBR number 10
LAWSON_PICKLIST_LINE TRAN_UOM varchar2 4  √  null
LAWSON_PICKLIST_LINE TRAN_UOM_MULT varchar2 14  √  null
LAWSON_PICKLIST_LINE_DETAIL BIN varchar2 7  √  null
LAWSON_PICKLIST_LINE_DETAIL COMPANY number 4
LAWSON_PICKLIST_LINE_DETAIL CREATION_DT date 7  √  null
LAWSON_PICKLIST_LINE_DETAIL LAST_MODIFIED_DT date 7  √  null
LAWSON_PICKLIST_LINE_DETAIL LINE_NBR number 6
LAWSON_PICKLIST_LINE_DETAIL LOCATION varchar2 5
LAWSON_PICKLIST_LINE_DETAIL LOT varchar2 10  √  null
LAWSON_PICKLIST_LINE_DETAIL QUANTITY varchar2 14  √  null
LAWSON_PICKLIST_LINE_DETAIL SERIAL varchar2 16  √  null
LAWSON_PICKLIST_LINE_DETAIL SHIPMENT_NBR number 10
LAWSON_PICKLIST_LINE_DETAIL SUBLOT varchar2 6  √  null
LAWSON_PICKLIST_LINE_DETAIL UOM varchar2 4  √  null
LAWSON_PO_CONFIG BLIND_RECEIVING char 1
LAWSON_PO_CONFIG COMPANY number 4
LAWSON_PO_CONFIG CREATION_DT date 7
LAWSON_PO_CONFIG LAST_MODIFIED_DT date 7  √  null
LAWSON_PO_CONFIG PKG_TRK_LVL char 1  √  null
LAWSON_PO_CONFIG RECEIVE_ALL char 1  √  null
LAWSON_PO_VENDOR CREATION_DT date 7
LAWSON_PO_VENDOR LAST_MODIFIED_DT date 7  √  null
LAWSON_PO_VENDOR VENDOR varchar2 9
LAWSON_PO_VENDOR VENDOR_GROUP varchar2 4
LAWSON_POLINE COMPANY number 4
LAWSON_POLINE CREATION_DT date 7
LAWSON_POLINE CXL_QTY number 15,4  √  null
LAWSON_POLINE ITEM varchar2 32
LAWSON_POLINE LAST_MODIFIED_DT date 7  √  null
LAWSON_POLINE PO_CODE varchar2 4  √  null
LAWSON_POLINE PO_LINE_NO number 6
LAWSON_POLINE PO_NO varchar2 14
LAWSON_POLINE PO_RELEASE number 4  √  null
LAWSON_POLINE QUANTITY number 15,4  √  null
LAWSON_POLINE REC_QTY number 15,4  √  null
LAWSON_POLINE_SRC COMPANY number 4
LAWSON_POLINE_SRC CREATION_DT date 7
LAWSON_POLINE_SRC DELIVERED_QTY number 15,4  √  null
LAWSON_POLINE_SRC LAST_MODIFIED_DT date 7  √  null
LAWSON_POLINE_SRC OPER_COMPANY number 4  √  null
LAWSON_POLINE_SRC ORIGIN_CD varchar2 2  √  null
LAWSON_POLINE_SRC PO_CODE varchar2 4  √  null
LAWSON_POLINE_SRC PO_LINE_NO number 6
LAWSON_POLINE_SRC PO_NO varchar2 14
LAWSON_POLINE_SRC PO_RELEASE number 4  √  null
LAWSON_POLINE_SRC QUANTITY number 15,4  √  null
LAWSON_POLINE_SRC REQ_LOC varchar2 5
LAWSON_POLINE_SRC SOURCE_DOC_A varchar2 10  √  null
LAWSON_POLINE_SRC SOURCE_DOC_N number 8  √  null
LAWSON_POLINE_SRC SRC_LINE_NBR number 6
LAWSON_POLINESRC BO_REM_QTY number 15,4  √  null
LAWSON_POLINESRC COMPANY varchar2 4
LAWSON_POLINESRC DELIVERED_QTY number 15,4  √  null
LAWSON_POLINESRC OPER_COMPANY varchar2 4  √  null
LAWSON_POLINESRC ORDERED_QTY number 15,4  √  null
LAWSON_POLINESRC ORIGIN_CD varchar2 4  √  null
LAWSON_POLINESRC PO_CODE varchar2 4  √  null
LAWSON_POLINESRC PO_LINE_NO varchar2 6
LAWSON_POLINESRC PO_NO varchar2 14
LAWSON_POLINESRC PO_RELEASE varchar2 4  √  null
LAWSON_POLINESRC SOURCE_DOC_A varchar2 10  √  null
LAWSON_POLINESRC SOURCE_DOC_N varchar2 8  √  null
LAWSON_POLINESRC SRC_LINE_NBR varchar2 6  √  null
LAWSON_REQUESTER COMPANY number 4
LAWSON_REQUESTER CREATION_DT date 7
LAWSON_REQUESTER LAST_MODIFIED_DT date 7  √  null
LAWSON_REQUESTER NAME varchar2 30  √  null
LAWSON_REQUESTER REQUESTER varchar2 10
LAWSON_RQLOC ADDR1 varchar2 30  √  null
LAWSON_RQLOC ADDR2 varchar2 30  √  null
LAWSON_RQLOC ADDR3 varchar2 30  √  null
LAWSON_RQLOC ADDR4 varchar2 30  √  null
LAWSON_RQLOC CITY_ADDR5 varchar2 18  √  null
LAWSON_RQLOC COMPANY number 4
LAWSON_RQLOC COUNTRY varchar2 30  √  null
LAWSON_RQLOC COUNTRY_CODE varchar2 2  √  null
LAWSON_RQLOC CREATION_DT date 7
LAWSON_RQLOC LAST_MODIFIED_DT date 7  √  null
LAWSON_RQLOC NAME varchar2 30  √  null
LAWSON_RQLOC POSTAL_CODE varchar2 10  √  null
LAWSON_RQLOC REQ_LOCATION varchar2 5
LAWSON_RQLOC STATE_PROV varchar2 2  √  null
LAWSON_USER CREATION_DT date 7
LAWSON_USER ID varchar2 20
LAWSON_USER LAST_MODIFIED_DT date 7  √  null
LAWSON_USER NAME_FIRST_MX_VALUE varchar2 55  √  null
LAWSON_USER NAME_LAST_MX_VALUE varchar2 55  √  null
LAWSON_USER SSOP varchar2 20  √  null
LAWSON_USER WEB_USER varchar2 80
LAWSON_USER WEBUSER_COMPANY number 4  √  null
LAWSON_USER WEBUSER_EMAIL varchar2 100  √  null
LAWSON_USER WEBUSER_EMPLOYEE varchar2 191  √  null
LAWSON_USER WEBUSER_REQUESTER varchar2 10  √  null
LAWSON_USER WEBUSER_STATUS number 1  √  null
LAWSON_VENDOR CREATION_DT date 7
LAWSON_VENDOR LAST_MODIFIED_DT date 7  √  null
LAWSON_VENDOR POOL_OPTION char 1  √  null
LAWSON_VENDOR VENDOR varchar2 9
LAWSON_VENDOR VENDOR_GROUP varchar2 4
LAWSON_VENDOR VENDOR_VNAME varchar2 30  √  null
LAWSON_VENDOR_CLASS CREATION_DT date 7
LAWSON_VENDOR_CLASS DESCRIPTION varchar2 30
LAWSON_VENDOR_CLASS LAST_MODIFIED_DT date 7  √  null
LAWSON_VENDOR_CLASS RETAIL_FLAG number 1  √  null
LAWSON_VENDOR_CLASS VEN_CLASS varchar2 3
LAWSON_VENDOR_CLASS VENDOR_GROUP varchar2 4
LAWSON_VENDOR_GROUP CREATION_DT date 7
LAWSON_VENDOR_GROUP DESCRIPTION varchar2 30  √  null
LAWSON_VENDOR_GROUP LAST_MODIFIED_DT date 7  √  null
LAWSON_VENDOR_GROUP VENDOR_GROUP varchar2 4
LAWSON_VENDOR_GROUP_AP_COMPANY COMPANY number 4
LAWSON_VENDOR_GROUP_AP_COMPANY CREATION_DT date 7
LAWSON_VENDOR_GROUP_AP_COMPANY LAST_MODIFIED_DT date 7  √  null
LAWSON_VENDOR_GROUP_AP_COMPANY VENDOR_GROUP varchar2 4
LAWSON_VENDOR_GROUP_COMPANY COMPANY number 4
LAWSON_VENDOR_GROUP_COMPANY CREATION_DT date 7
LAWSON_VENDOR_GROUP_COMPANY LAST_MODIFIED_DT date 7  √  null
LAWSON_VENDOR_GROUP_COMPANY VENDOR_GROUP varchar2 4
LOAD_CONTENT ADDED_BY number 22
LOAD_CONTENT ADDED_DATE date 7
LOAD_CONTENT ASID varchar2 10
LOAD_CONTENT BATCH_NO varchar2 20  √  null
LOAD_CONTENT COMMENTS varchar2 50  √  null
LOAD_CONTENT DB_ID number 22
LOAD_CONTENT DESCRIPTION varchar2 100  √  null
LOAD_CONTENT LOAD_ID number 22
LOAD_CONTENT_LOG ACTION_DESC varchar2 50  √  null
LOAD_CONTENT_LOG DB_ID number 22
LOAD_CONTENT_LOG LOAD_ID number 22  √  null
LOAD_CONTENT_LOG LOG_DATE date 7  √  null
LOAD_CONTENT_LOG NEW_VALUE varchar2 50  √  null
LOAD_CONTENT_LOG OLD_VALUE varchar2 50  √  null
LOAD_CONTENT_LOG USER_ID number 22  √  null
LOAD_RESULT COMMENTS varchar2 50  √  null
LOAD_RESULT DB_ID number 22
LOAD_RESULT LOAD_ID number 22
LOAD_RESULT PARAM_ID number 22
LOAD_RESULT RECORD_VALUE varchar2 50  √  null
LOAD_RESULT RECORDED_BY number 22
LOAD_RESULT RECORDED_DATE date 7
LOAD_RESULT_LOG ACTION_DESC varchar2 50  √  null
LOAD_RESULT_LOG DB_ID number 22
LOAD_RESULT_LOG LOAD_ID number 22  √  null
LOAD_RESULT_LOG LOG_DATE date 7  √  null
LOAD_RESULT_LOG NEW_VALUE varchar2 50  √  null
LOAD_RESULT_LOG OLD_VALUE varchar2 50  √  null
LOAD_RESULT_LOG PARAM_ID number 22  √  null
LOAD_RESULT_LOG USER_ID number 22  √  null
LOAD_STER COMMENTS varchar2 100  √  null
LOAD_STER CREATED_BY number 22
LOAD_STER CREATED_DATE date 7
LOAD_STER CYCLE_NO varchar2 50  √  null
LOAD_STER END_DATE date 7  √  null
LOAD_STER LOAD_ID number 22
LOAD_STER PROC_NO number 22
LOAD_STER STATUS number 22
LOAD_STER STERILIZER_EQ_NO number 8
LOAD_TRACKING_INFO CREATED_DATE date 7
LOAD_TRACKING_INFO CYCLE_NO varchar2 50  √  null
LOAD_TRACKING_INFO END_DATE date 7  √  null
LOAD_TRACKING_INFO FACILITY_NAME varchar2 30  √  null
LOAD_TRACKING_INFO FACILITY_NO number 4
LOAD_TRACKING_INFO LOAD_ID number 22
LOAD_TRACKING_INFO NUMBER_OF_TRAYS number 22  √  null
LOAD_TRACKING_INFO PROCESS_NAME varchar2 50
LOAD_TRACKING_INFO STER_LOCATION number 22
LOAD_TRACKING_INFO STER_LOCATION_NAME varchar2 50
LOAD_TRACKING_INFO STER_NAME varchar2 100
LOAD_TRACKING_INFO STERILIZER_EQ_NO number 8
LOAD_TRACKING_INFO USER_ID number 22
LOAD_TRACKING_INFO USER_NAME varchar2 80
LOAD_TRACKING_INFO_TRAY COMMENTS varchar2 100  √  null
LOAD_TRACKING_INFO_TRAY CREATED_DATE date 7
LOAD_TRACKING_INFO_TRAY CYCLE_NO varchar2 50  √  null
LOAD_TRACKING_INFO_TRAY DESCR varchar2 100
LOAD_TRACKING_INFO_TRAY END_DATE date 7  √  null
LOAD_TRACKING_INFO_TRAY FACILITY_NAME varchar2 30  √  null
LOAD_TRACKING_INFO_TRAY FACILITY_NO number 4
LOAD_TRACKING_INFO_TRAY IS_TRAY_STER_AGAIN char 3  √  null
LOAD_TRACKING_INFO_TRAY IS_TRAY_USED_AGAIN char 3  √  null
LOAD_TRACKING_INFO_TRAY LOAD_ASID varchar2 10
LOAD_TRACKING_INFO_TRAY LOAD_ID number 22
LOAD_TRACKING_INFO_TRAY PROCESS_NAME varchar2 50
LOAD_TRACKING_INFO_TRAY STER_AGAIN_DATE date 7  √  null
LOAD_TRACKING_INFO_TRAY STER_LOCATION number 22  √  null
LOAD_TRACKING_INFO_TRAY STER_LOCATION_CODE varchar2 5
LOAD_TRACKING_INFO_TRAY STER_LOCATION_NAME varchar2 50
LOAD_TRACKING_INFO_TRAY STER_NAME varchar2 100
LOAD_TRACKING_INFO_TRAY STER_NO number 4
LOAD_TRACKING_INFO_TRAY STERILIZER_EQ_NO number 8
LOAD_TRACKING_INFO_TRAY TRAY_FACILITY_NAME varchar2 30  √  null
LOAD_TRACKING_INFO_TRAY TRAY_FACILITY_NO number 4
LOAD_TRACKING_INFO_TRAY TRAY_LOCATION_NAME varchar2 50
LOAD_TRACKING_INFO_TRAY TRAY_LOCATION_NO number 22  √  null
LOAD_TRACKING_INFO_TRAY TRAY_NO varchar2 5
LOAD_TRACKING_INFO_TRAY TYPE_NAME varchar2 40
LOAD_TRACKING_INFO_TRAY USED_AGAIN_TIME date 7  √  null
LOAD_TRACKING_INFO_TRAY USER_ID number 22
LOAD_TRACKING_INFO_TRAY USER_NAME varchar2 80
LOC_GROUP_TYPE ACTIVITY_TYPE number 3
LOC_GROUP_TYPE CREATE_DATE date 7
LOC_GROUP_TYPE GROUP_TYPE_DESC varchar2 100  √  null
LOC_GROUP_TYPE GROUP_TYPE_NAME varchar2 40  √  null
LOC_GROUP_TYPE IS_ACTIVE char 1
LOC_GROUP_TYPE LAST_UPDATE_DATE date 7  √  null
LOC_GROUP_TYPE LOC_GROUP_TYPE_ID number 22
LOCAL_ITEM_VW CREATION_DT date 7
LOCAL_ITEM_VW DESCR varchar2 100  √  null
LOCAL_ITEM_VW IMGLNK varchar2 255  √  null
LOCAL_ITEM_VW ITEM_GROUP varchar2 5  √  null
LOCAL_ITEM_VW ITEM_ID number 22
LOCAL_ITEM_VW ITEM_NO varchar2 32
LOCAL_ITEM_VW LAST_MODIFIED_DT date 7
LOCAL_ITEM_VW MAJOR_CLASS varchar2 4  √  null
LOCAL_ITEM_VW MFR_CAT_NO varchar2 35  √  null
LOCAL_ITEM_VW MFR_ID number 22  √  null
LOCAL_ITEM_VW MINOR_CLASS varchar2 4  √  null
LOCAL_ITEM_VW PROC_DESCR varchar2 100  √  null
LOCAL_ITEM_VW PROC_ITEM_NO varchar2 32  √  null
LOCAL_ITEM_VW STATUS char 1
LOCAL_ITEM_VW USAGE_IDENTIFIER varchar2 1  √  null
LOCATION ADDED_TO_MSC char 1
LOCATION ADDRESS_ID number 22  √  null
LOCATION COMPANY_NO number 4
LOCATION CREATION_DT date 7
LOCATION EXT_DATA_IND char 1  √  null
LOCATION EXTERNAL_STATUS char 1  √  null
LOCATION ID_CONFLICT_DT date 7  √  null
LOCATION IS_ACTIVE char 1
LOCATION LAST_MODIFIED_DT date 7
LOCATION LOCATION_CODE varchar2 5
LOCATION LOCATION_ID number 22
LOCATION NAME varchar2 50
LOCATION_APP_MAP_VW APP_NAME varchar2 30
LOCATION_APP_MAP_VW LOCATION_ID number 22
LOCATION_BIN BIN varchar2 7
LOCATION_BIN CREATION_DT date 7
LOCATION_BIN EXT_DATA_IND char 1
LOCATION_BIN LOCATION_ID number 22
LOCATION_GROUP LOCATION_ID number 22
LOCATION_GROUP REPORT_GROUP varchar2 5
LOCATION_GROUP_DTLS CREATE_DATE date 7
LOCATION_GROUP_DTLS LAST_UPDATE_DATE date 7  √  null
LOCATION_GROUP_DTLS LOC_GROUP_DTLS_SEQ number 22
LOCATION_GROUP_DTLS LOC_GROUP_ID number 22
LOCATION_GROUP_DTLS LOCATION_ID number 22
LOCATION_GROUP_HDR CREATE_DATE date 7
LOCATION_GROUP_HDR GROUP_DESC varchar2 50  √  null
LOCATION_GROUP_HDR GROUP_NAME varchar2 20  √  null
LOCATION_GROUP_HDR IS_ACTIVE char 1
LOCATION_GROUP_HDR LAST_UPDATE_DATE date 7  √  null
LOCATION_GROUP_HDR LOC_GROUP_ID number 22
LOCATION_GROUP_HDR LOC_GROUP_TYPE_ID number 22
LOCATION_ITEM ALLOW_ISS_FL char 1 'Y'
LOCATION_ITEM ALT_IMGLNK varchar2 255  √  null
LOCATION_ITEM ALT_ITEM_DESCRIPTION varchar2 60  √  null
LOCATION_ITEM AVG_COST number 13,5  √  null
LOCATION_ITEM BIN_LOCATION varchar2 7  √  ''
LOCATION_ITEM BIN_TRK_FL varchar2 1  √  null
LOCATION_ITEM CHARGEABLE_FL char 1 'N'
LOCATION_ITEM CREATION_DT date 7
LOCATION_ITEM EACH_COST number 15,4  √  null
LOCATION_ITEM EXT_DATA_IND char 1
LOCATION_ITEM EXTERNAL_STATUS char 1  √  null
LOCATION_ITEM ITEM_ID number 22
LOCATION_ITEM ITEM_REPL_NO number 22  √  null
LOCATION_ITEM LAST_MODIFIED_DT date 7
LOCATION_ITEM LOCATION_ID number 22
LOCATION_ITEM LOCATION_ITEM_ID number 20
LOCATION_ITEM LOT_TRACK_FL varchar2 1  √  null
LOCATION_ITEM MIN_ORDER number 17,4  √  0
LOCATION_ITEM PAR_BIN_SEQ number 6  √  null
LOCATION_ITEM PAR_LEVEL number 13,4  √  null
LOCATION_ITEM PREFER_BIN varchar2 7  √  null
LOCATION_ITEM QUANTITY_OO number 15,4  √  null
LOCATION_ITEM REPL_FROM_BIN varchar2 7  √  null
LOCATION_ITEM REPL_FROM_LOC_ID number 22  √  null
LOCATION_ITEM SER_TRACK_FL varchar2 1  √  null
LOCATION_ITEM SERIAL_TRACKED_IND char 1  √  ('N')
LOCATION_ITEM STATUS char 1
LOCATION_ITEM STD_COST number 13,5  √  null
LOCATION_ITEM TRACKING_FL char 1 'Y'
LOCATION_ITEM UOM varchar2 4  √  null
LOCATION_ITEM_BIN BIN varchar2 7
LOCATION_ITEM_BIN CREATION_DT date 7
LOCATION_ITEM_BIN LAST_MODIFIED_DT date 7
LOCATION_ITEM_BIN LOCATION_ID number 22
LOCATION_ITEM_BIN LOCATION_ITEM_ID number 20
LOCATION_ITEM_BIN UOM varchar2 4
LOCATION_ITEM_LOT BIN varchar2 7  √  null
LOCATION_ITEM_LOT EXPIRE_DATE date 7  √  null
LOCATION_ITEM_LOT LOCATION_ITEM_ID number 20
LOCATION_ITEM_LOT LOT varchar2 10
LOCATION_ITEM_LOT SUBLOT varchar2 6  √  null
LOCATION_ITEM_LOT UOM varchar2 4
LOCATION_ITEM_SERIAL BIN varchar2 7  √  null
LOCATION_ITEM_SERIAL LOCATION_ITEM_ID number 20
LOCATION_ITEM_SERIAL SERIAL varchar2 16
LOCATION_ITEM_SERIAL STATUS number 22  √  null
LOCATION_SCHEDULE CREATE_DATE date 7
LOCATION_SCHEDULE END_DATE date 7
LOCATION_SCHEDULE FREQUENCY char 1
LOCATION_SCHEDULE SCHEDULE_ID number 22
LOCATION_SCHEDULE START_DATE date 7
LOCATION_SCHEDULE SUPPLY_LOC_ID number 22
LOCATION_SCHEDULED_DAYS CREATE_DATE date 7
LOCATION_SCHEDULED_DAYS IS_ACTIVE char 1
LOCATION_SCHEDULED_DAYS PROCESSED char 1
LOCATION_SCHEDULED_DAYS SCHEDULE_ID number 22
LOCATION_SCHEDULED_DAYS SCHEDULED_DATE date 7
LOCATION_SCHEDULED_DAYS SCHEDULED_DATE_ID number 22
LOCATION_TYPE APP_ID number 22
LOCATION_TYPE DESCRIPTION varchar2 50
LOCATION_TYPE LOCATION_TYPE_ID number 22
LOCATION_TYPE NAME varchar2 20
LOCATION_TYPE_MAP ALT_LOCATION_NAME varchar2 30  √  null
LOCATION_TYPE_MAP EXT_DATA_IND char 1
LOCATION_TYPE_MAP LOCATION_ID number 22
LOCATION_TYPE_MAP LOCATION_TYPE_ID number 22
LOCATION_TYPE_MAP STATUS varchar2 1  √  null
MANIFEST DESCRIPTION varchar2 40  √  null
MANIFEST IS_ACTIVE char 1
MANIFEST LAST_MODIFIED_DT date 7
MANIFEST MANIFEST_ID number 22
MANIFEST USER_ID number 22
MANIFEST_LINE DELIVERY_TICKET_ID varchar2 40
MANIFEST_LINE DELIVERY_UNIT_NO number 4
MANIFEST_LINE DISTRIB_LINE_NO number 5
MANIFEST_LINE MANIFEST_ID number 22
MFGR ADDED_TO_SIM char 1
MFGR CREATION_DT date 7
MFGR EXT_DATA_IND char 1
MFGR EXTERNAL_STATUS char 1  √  null
MFGR ID_CONFLICT_DT date 7  √  null
MFGR ITEM_GROUP varchar2 5
MFGR LAST_MODIFIED_DT date 7
MFGR MFG_CODE varchar2 4
MFGR MFG_DIV varchar2 4  √  null
MFGR MFR_ID number 22
MFGR NAME varchar2 30
MFGR STATUS char 1
MSCM9_LMGR DISABLED varchar2 254  √  null
MSCM9_LMGR LEASE_EXPIRE_TIME number 19  √  null
MSCM9_LMGR LEASENAME varchar2 254
MSCM9_LMGR LEASEOWNER varchar2 254  √  null
MSCM9_LMPR LEASENAME varchar2 254
MSCM9_LMPR NAME varchar2 254
MSCM9_LMPR VALUE varchar2 254
MSCM9_TASK AUTOPURGE number 10
MSCM9_TASK CANCELLED number 1
MSCM9_TASK CREATETIME number 19
MSCM9_TASK FAILUREACTION number 10  √  null
MSCM9_TASK MAXATTEMPTS number 10  √  null
MSCM9_TASK MAXREPEATS number 10
MSCM9_TASK NAME varchar2 254  √  null
MSCM9_TASK NEXTFIRETIME number 19
MSCM9_TASK OWNERTOKEN varchar2 200
MSCM9_TASK PARTITIONID number 10  √  null
MSCM9_TASK QOS number 10  √  null
MSCM9_TASK REPEATINTERVAL varchar2 254  √  null
MSCM9_TASK REPEATSLEFT number 10
MSCM9_TASK ROW_VERSION number 10
MSCM9_TASK STARTBYINTERVAL varchar2 254  √  null
MSCM9_TASK STARTBYTIME number 19  √  null
MSCM9_TASK TASKID number 19
MSCM9_TASK TASKINFO blob 4000  √  null
MSCM9_TASK TASKSUSPENDED number 1
MSCM9_TASK TASKTYPE number 10
MSCM9_TASK VALIDFROMTIME number 19  √  null
MSCM9_TASK VALIDTOTIME number 19  √  null
MSCM9_TASK VERSION varchar2 5
MSCM9_TREG REGKEY varchar2 254
MSCM9_TREG REGVALUE varchar2 254  √  null
NOTE CREATION_DT date 7  √  null
NOTE LOCATION_ID number 22
NOTE NOTE_CONTENT varchar2 1000  √  null
NOTE NOTE_ID number 20
NOTE NOTE_TYPE varchar2 10
NOTE_TYPE APP_ID number 22
NOTE_TYPE DESCRIPTION varchar2 50  √  null
NOTE_TYPE IS_ACTIVE char 1 'A'
NOTE_TYPE NOTE_TYPE varchar2 10
NOTE_TYPE SEQUENCE_NO number 22  √  null
OBJECT_TYPE NAME varchar2 100  √  null
OBJECT_TYPE OBJECT_TYPE_ID number 22
OPERATOR_ACTIVITY_CYCLE_C COMPANY_NO number 4
OPERATOR_ACTIVITY_CYCLE_C FIRST_SCAN date 7  √  null
OPERATOR_ACTIVITY_CYCLE_C LAST_SCAN date 7  √  null
OPERATOR_ACTIVITY_CYCLE_C LINE_ITEMS_COUNTED number 22  √  null
OPERATOR_ACTIVITY_CYCLE_C SELECT_ID varchar2 5
OPERATOR_ACTIVITY_CYCLE_C TOTAL_QTY_COUNTED number 22  √  null
OPERATOR_ACTIVITY_CYCLE_C USER_ID number 22
OPERATOR_ACTIVITY_PAR COMPANY_NO number 4
OPERATOR_ACTIVITY_PAR FIRST_SCAN date 7  √  null
OPERATOR_ACTIVITY_PAR LAST_SCAN date 7  √  null
OPERATOR_ACTIVITY_PAR LINE_ITEMS_ADD_QTY number 22  √  null
OPERATOR_ACTIVITY_PAR LINE_ITEMS_COUNTED number 22  √  null
OPERATOR_ACTIVITY_PAR LINE_ITEMS_PROCESSED number 22  √  null
OPERATOR_ACTIVITY_PAR PAR_LOCATION_DESCRIPTION varchar2 50
OPERATOR_ACTIVITY_PAR PAR_LOCATION_ID varchar2 5
OPERATOR_ACTIVITY_PAR TOTAL_QTY_REQUESTED number 22  √  null
OPERATOR_ACTIVITY_PAR USER_ID number 22
OPERATOR_ACTIVITY_PFP FIRST_SCAN date 7  √  null
OPERATOR_ACTIVITY_PFP LAST_SCAN date 7  √  null
OPERATOR_ACTIVITY_PFP LINE_ITEMS_PICKED number 22  √  null
OPERATOR_ACTIVITY_PFP LOCATION_DESCRIPTION varchar2 50
OPERATOR_ACTIVITY_PFP PAR_COM_ID number 4
OPERATOR_ACTIVITY_PFP PAR_LOC_ID varchar2 5
OPERATOR_ACTIVITY_PFP PICK_COM_ID number 4
OPERATOR_ACTIVITY_PFP PICK_LOC_ID varchar2 5
OPERATOR_ACTIVITY_PFP PICKLIST_ID varchar2 100  √  null
OPERATOR_ACTIVITY_PFP TOTAL_QTY_PICKED number 22  √  null
OPERATOR_ACTIVITY_PFP USER_ID number 22
OPERATOR_ACTIVITY_POU ACTION varchar2 10  √  null
OPERATOR_ACTIVITY_POU COMPANY_NO number 22  √  null
OPERATOR_ACTIVITY_POU DESCRIPTION varchar2 50  √  null
OPERATOR_ACTIVITY_POU DURATION number 9,2  √  null
OPERATOR_ACTIVITY_POU END_TIME varchar2 18  √  null
OPERATOR_ACTIVITY_POU LOCATION_CODE varchar2 5  √  null
OPERATOR_ACTIVITY_POU NAME varchar2 50  √  null
OPERATOR_ACTIVITY_POU PULL_QTY number 22  √  null
OPERATOR_ACTIVITY_POU RETURN_QTY number 22  √  null
OPERATOR_ACTIVITY_POU START_TIME varchar2 18  √  null
OPERATOR_ACTIVITY_POU USER_ID number 22
PATIENT BIRTHDATE date 7  √  null
PATIENT CREATE_DATE date 7
PATIENT FIRST_NAME varchar2 28
PATIENT IS_ACTIVE char 1
PATIENT LAST_NAME varchar2 20
PATIENT LAST_UPDATE_DATE date 7  √  null
PATIENT MIDDLE_NAME varchar2 20  √  null
PATIENT PATIENT_CODE varchar2 20
PATIENT PATIENT_ID number 22
PATIENT_LOCATION BED varchar2 80  √  null
PATIENT_LOCATION CREATE_DATE date 7
PATIENT_LOCATION FACILITY_ID number 22
PATIENT_LOCATION IS_ACTIVE char 1
PATIENT_LOCATION LAST_UPDATE_DATE date 7  √  null
PATIENT_LOCATION PATIENT_LOCATION_ID number 22
PATIENT_LOCATION ROOM_CODE varchar2 80
PATIENT_VISIT ADMIT_DATE date 7
PATIENT_VISIT CREATE_DATE date 7
PATIENT_VISIT DISCHARGE_DATE date 7  √  null
PATIENT_VISIT LAST_UPDATE_DATE date 7  √  null
PATIENT_VISIT PATIENT_ACCT_NO varchar2 20  √  null
PATIENT_VISIT PATIENT_CLASS char 1
PATIENT_VISIT PATIENT_ID number 22
PATIENT_VISIT PATIENT_LOCATION_ID number 22
PATIENT_VISIT PATIENT_VISIT_ID number 22
PATIENT_VISIT SENDING_APPLICATION varchar2 20
PATIENT_VISIT VISIT_NBR varchar2 20  √  null
PICK ACTIVITY number 22
PICK CARTSET_ASSM_NO varchar2 10
PICK PATIENT_ID varchar2 12  √  null
PICK PICK_ID number 22
PICK PICK_LOC_NO number 22
PICK PICK_NO varchar2 20
PICK PICKLIST_NO varchar2 6
PICK PICKTIME date 7
PICK USER_ID number 22
PICK_ACTIVITY END_TIME date 7  √  null
PICK_ACTIVITY FACILITY_ID number 4
PICK_ACTIVITY FACILITY_NAME varchar2 30  √  null
PICK_ACTIVITY NUMBER_OF_CASECARTS number 22  √  null
PICK_ACTIVITY NUMBER_OF_PICKED_TRAYS number 22  √  null
PICK_ACTIVITY PICK_LOC_NO number 22
PICK_ACTIVITY PICK_LOCATION varchar2 50
PICK_ACTIVITY PICK_LOCATION_CODE varchar2 5
PICK_ACTIVITY PICK_LOCATION_ID number 22
PICK_ACTIVITY PICKLIST_NO varchar2 6
PICK_ACTIVITY START_TIME date 7  √  null
PICK_ACTIVITY USER_ID number 22
PICKING_DETAILS ACT_DATE date 7
PICKING_DETAILS ASID varchar2 10
PICKING_DETAILS CARTSET_ASSM_NO varchar2 10
PICKING_DETAILS CASECART_NO varchar2 8
PICKING_DETAILS CREAT_DT date 7
PICKING_DETAILS FACILITY varchar2 30  √  null
PICKING_DETAILS FACILITY_NO number 4
PICKING_DETAILS FIRST_NAME varchar2 55  √  null
PICKING_DETAILS LAST_NAME varchar2 55  √  null
PICKING_DETAILS PATIENT_ID varchar2 12  √  null
PICKING_DETAILS PICK_LOC_NO varchar2 5
PICKING_DETAILS PICK_LOCATION varchar2 50
PICKING_DETAILS PICK_LOCATION_ID number 22
PICKING_DETAILS PICKLIST_NO varchar2 6
PICKING_DETAILS PICKTIME date 7
PICKING_DETAILS TL_NO varchar2 6
PICKING_DETAILS TRAY_NO varchar2 5  √  null
PICKING_DETAILS TRAYLIST_NAME varchar2 100
PICKING_DETAILS USER_ID number 22
PICKLIST CREAT_DT date 7
PICKLIST PICKLIST_ID number 22
PICKLIST PICKLIST_NO varchar2 6
PICKLIST USER_ID number 22
PICKLIST_CARTSET_MAP_VW CARTSET_ASSM_NO varchar2 10
PICKLIST_CARTSET_MAP_VW PICKLIST_NO varchar2 6
PICKLIST_HEADER DELIVER_TO varchar2 30  √  null
PICKLIST_HEADER DOC_NO varchar2 10
PICKLIST_HEADER DOCUMENT_PRINTER_ID number 8  √  null
PICKLIST_HEADER EXT_STATUS char 1  √  null
PICKLIST_HEADER FROM_LOC_ID number 22
PICKLIST_HEADER INT_STATUS char 2  √  null
PICKLIST_HEADER LABEL_PRINTER_ID number 8  √  null
PICKLIST_HEADER LAST_ASSIGN_DATE date 7  √  null
PICKLIST_HEADER LAST_PICK_DATE date 7  √  null
PICKLIST_HEADER LINES_SHORT number 22  √  null
PICKLIST_HEADER PICKLIST_ID number 20
PICKLIST_HEADER REQ_DATE date 7  √  null
PICKLIST_HEADER REQ_LOC_ID number 22
PICKLIST_HEADER REQUESTER varchar2 10  √  null
PICKLIST_HEADER SHIP_DATE date 7  √  null
PICKLIST_HEADER SHIP_NO number 10
PICKLIST_HEADER TOTAL_LINES number 22  √  null
PICKLIST_HEADER TOTAL_PICKED_LINES number 22  √  null
PICKLIST_HEADER UPLOAD_MSG varchar2 150  √  null
PICKLIST_HEADER VENDOR varchar2 9  √  null
PICKLIST_LINE LINE_NO number 6  √  null
PICKLIST_LINE LINE_TYPE char 1  √  null
PICKLIST_LINE LOC_ITEM_ID number 20
PICKLIST_LINE OPEN_QTY number 15,4
PICKLIST_LINE OPEN_QTY_UOM varchar2 4
PICKLIST_LINE PICKLIST_ID number 20
PICKLIST_LINE PICKLIST_LINE_ID number 20
PICKLIST_LINE PULLED_QTY number 15,4  √  null
PICKLIST_LINE PULLED_QTY_UOM varchar2 4  √  null
PICKLIST_LINE SHORT_PICK char 1  √  null
PICKLIST_LINE SKIP_SCANNED char 1  √  null
PICKLIST_LINE UPLOAD_MESSAGE varchar2 150  √  null
PICKLIST_LINE UPLOAD_STATUS char 1  √  null
PICKLIST_LINE_DETAIL ALLOCATED_BIN varchar2 7  √  null
PICKLIST_LINE_DETAIL ALLOCATED_LOT varchar2 10  √  null
PICKLIST_LINE_DETAIL ALLOCATED_QTY number 15,4  √  null
PICKLIST_LINE_DETAIL ALLOCATED_SERIAL varchar2 16  √  null
PICKLIST_LINE_DETAIL ALLOCATED_SUB_LOT varchar2 6  √  null
PICKLIST_LINE_DETAIL ALLOCATED_UOM varchar2 4  √  null
PICKLIST_LINE_DETAIL BIN varchar2 7  √  null
PICKLIST_LINE_DETAIL LOT varchar2 10  √  null
PICKLIST_LINE_DETAIL PICKED_BY number 22  √  null
PICKLIST_LINE_DETAIL PICKLIST_LINE_ID number 20
PICKLIST_LINE_DETAIL PULLED_QTY number 15,4  √  null
PICKLIST_LINE_DETAIL PULLED_UOM varchar2 4  √  null
PICKLIST_LINE_DETAIL RECORD_SEQ number 22
PICKLIST_LINE_DETAIL SERIAL varchar2 16  √  null
PICKLIST_LINE_DETAIL SUB_LOT varchar2 6  √  null
PICKLIST_LINE_DETAIL TRACKING_NO varchar2 40  √  null
PICKLIST_LINE_DETAIL UPLOAD_MESSAGE varchar2 150  √  null
PICKLIST_LINE_DETAIL UPLOAD_STATUS char 1  √  null
PICKLIST_LOG ACTIVITY char 1
PICKLIST_LOG ACTIVITY_DATE date 7
PICKLIST_LOG PICKLIST_ID number 20
PICKLIST_LOG USER_ID number 22
PO_HEADER CLOSED_LINE number 22
PO_HEADER CLS_DATE date 7  √  null
PO_HEADER COMPANY_NO number 4
PO_HEADER CREATION_DATE date 7  √  null
PO_HEADER DFLT_DATE date 7  √  null
PO_HEADER EXT_STATUS char 1
PO_HEADER INT_STATUS char 1
PO_HEADER IS_CANCELED char 1
PO_HEADER IS_CLOSED char 1
PO_HEADER IS_DROP_SHIP char 1
PO_HEADER IS_RELEASED char 1
PO_HEADER LOC_ID number 38  √  null
PO_HEADER PO_CODE varchar2 4  √  null
PO_HEADER PO_ID number 20
PO_HEADER PO_NUMBER varchar2 14
PO_HEADER PO_RELEASE number 4  √  null
PO_HEADER TOTAL_LINES number 22
PO_HEADER VENDOR varchar2 9  √  null
PO_LINE BIN_TRACKED char 1
PO_LINE BO_REM_QTY number 30,4  √  null
PO_LINE CAN_BACK_ORD char 1 'B'
PO_LINE CATALOG_NO varchar2 35  √  null
PO_LINE CTW char 1
PO_LINE EXT_STATUS char 1
PO_LINE INT_STATUS char 1
PO_LINE INV_TRACKED char 1
PO_LINE IS_CANCELED char 1
PO_LINE IS_CLOSED char 1
PO_LINE ITEM_DESC varchar2 32
PO_LINE ITEM_NO varchar2 32
PO_LINE LINE_ID number 20
PO_LINE LINE_NO number 6
PO_LINE LOT_TRACKED char 1
PO_LINE MFR_ID number 22  √  null
PO_LINE NBR_DEC number 22  √  null
PO_LINE NEED_INSP char 1
PO_LINE ORD_QTY number 30,4
PO_LINE PO_ID number 20
PO_LINE PREF_BIN varchar2 7  √  null
PO_LINE REC_QTY number 30,4
PO_LINE REM_QTY number 30,4
PO_LINE SER_TRACKED char 1
PO_LINE SHIP_TO_LOC number 38
PO_LINE TRANS_UOM varchar2 4
PO_LINE TYPE char 1
PO_LINE UND_SHP_TOL number 22  √  null
PO_LINE VENDOR varchar2 40  √  null
PO_LINE_DEL DEL_DATE date 7  √  null
PO_LINE_DEL DEL_LOC_ID number 38  √  null
PO_LINE_DEL LINE_ID number 20
PO_LINE_DEL MSG varchar2 100  √  null
PO_LINE_DEL ORIGIN_CD varchar2 5  √  null
PO_LINE_DEL PRIORITY number 5  √  null
PO_LINE_DEL REQ_QTY number 30,4
PO_LINE_DEL REQUISITION_NO varchar2 10  √  null
PO_LINE_DEL SRC_LINE_NO number 6
PO_LINE_RECEIPT LINE_ID number 20
PO_LINE_RECEIPT REC_ID number 20
PO_LINE_RECEIPT UPLOAD_MSG varchar2 100  √  null
PO_LINE_RECEIPT UPLOAD_STATUS char 1
PO_LINE_RECEIPT_RECORD BIN varchar2 7  √  null
PO_LINE_RECEIPT_RECORD CAN_BACK_ORD char 1 'B'
PO_LINE_RECEIPT_RECORD LINE_ID number 20
PO_LINE_RECEIPT_RECORD LOT varchar2 16  √  null
PO_LINE_RECEIPT_RECORD LOT_EXP date 7  √  null
PO_LINE_RECEIPT_RECORD NEED_INSP char 1
PO_LINE_RECEIPT_RECORD RCV_LOC number 38
PO_LINE_RECEIPT_RECORD RCV_QTY number 10,4  √  null
PO_LINE_RECEIPT_RECORD RCV_UOM varchar2 4  √  null
PO_LINE_RECEIPT_RECORD REC_ID number 20
PO_LINE_RECEIPT_RECORD SEQ number 20
PO_LINE_RECEIPT_RECORD SERIAL varchar2 16  √  null
PO_LINE_RECEIPT_RECORD SUB_LOT varchar2 6  √  null
PO_LINE_RECEIPT_RECORD TRK_NO varchar2 40  √  null
PO_LINE_RECEIPT_RECORD UPLOAD_MSG varchar2 100  √  null
PO_LINE_RECEIPT_RECORD UPLOAD_STATUS char 1
PO_RECEIPT BOL varchar2 22  √  null
PO_RECEIPT CARRIER varchar2 19  √  null
PO_RECEIPT CARRIER_TRK_NO varchar2 40  √  null
PO_RECEIPT CREAT_DATE date 7
PO_RECEIPT DOC_PRINT_ID number 8  √  null
PO_RECEIPT EXT_STATUS char 1
PO_RECEIPT INT_STATUS char 1
PO_RECEIPT LABEL_PRINT_ID number 8  √  null
PO_RECEIPT NEED_PRINT char 1
PO_RECEIPT PO_ID number 20
PO_RECEIPT RCV_LOC number 38  √  null
PO_RECEIPT REC_DATE date 7  √  null
PO_RECEIPT REC_ID number 20
PO_RECEIPT REC_NO number 10
PO_RECEIPT REF_NO varchar2 10  √  null
PO_RECEIPT RELEASED_BY number 38  √  null
PO_RECEIPT UPLOAD_MSG varchar2 100  √  null
PO_RECEIPT UPLOAD_STATUS char 1
PO_TRANSDTL BIN varchar2 7  √  null
PO_TRANSDTL DELIVERY_TICKET_ID varchar2 40
PO_TRANSDTL DELIVERY_UNIT_NO number 4
PO_TRANSDTL DISTRIB_LINE_NO number 5
PO_TRANSDTL EXPIRE_DATE date 7  √  null
PO_TRANSDTL LOT_SERIAL varchar2 16  √  null
PO_TRANSDTL QUANTITY number 15,4  √  null
PO_TRANSDTL SECONDARY_QTY number 15,4  √  null
PO_TRANSDTL SUBLOT varchar2 6  √  null
PO_TRANSDTL TRANS_SEQ number 6
POU_UOM CREATE_DATE date 7
POU_UOM ITEM_ID number 22
POU_UOM LAST_UPDATE_DATE date 7  √  null
POU_UOM POU_UOM varchar2 4
PRINTER COMPANY_NO number 4
PRINTER HOST varchar2 256
PRINTER IS_DEFAULT varchar2 1  √  null
PRINTER LANGUAGE varchar2 20  √  null
PRINTER LPRSERVER varchar2 30  √  null
PRINTER MAKE varchar2 20  √  null
PRINTER MAX_RETRIES number 2  √  null
PRINTER MODEL varchar2 20  √  null
PRINTER PASSWORD varchar2 1024  √  null
PRINTER PORT number 6  √  null
PRINTER PRINTER_ID number 8
PRINTER PRINTER_NAME varchar2 30
PRINTER PRINTER_USER varchar2 30  √  null
PRINTER PROTOCOL_NAME varchar2 30  √  null
PRINTER STATUS varchar2 1  √  null
PRINTER TIMEOUT number 5  √  null
PRINTER TYPE varchar2 20
PRINTER_LOCATION_MAP LOCATION_ID number 22
PRINTER_LOCATION_MAP PRINTER_ID number 8
PRINTER_PROTOCOL DESCR varchar2 60  √  null
PRINTER_PROTOCOL PROTOCOL_NAME varchar2 30
PRINTER_USER_MAP LOCATION_ID number 22
PRINTER_USER_MAP PRINTER_ID number 8
PRINTER_USER_MAP STATUS char 1  √  'A'
PRINTER_USER_MAP USER_ID number 22
PROC_LOCATION DB_ID number 22
PROC_LOCATION IS_DEFAULT number 22  √  null
PROC_LOCATION LOC_NO number 8
PROC_LOCATION PROC_NO number 22
PROC_STAGE COMMENTS varchar2 50  √  null
PROC_STAGE DB_ID number 22
PROC_STAGE ORDER_IN_PROC number 22  √  null
PROC_STAGE PROC_NO number 22
PROC_STAGE STAGE_NO number 22
PROC_STAGE_SETTING APPLIED_TO_CONTENT number 22
PROC_STAGE_SETTING DB_ID number 22
PROC_STAGE_SETTING DESCRIPTION varchar2 50  √  null
PROC_STAGE_SETTING EXPECTED_RESULT varchar2 50  √  null
PROC_STAGE_SETTING INCLUDE_IN_SETUP number 22  √  null
PROC_STAGE_SETTING ORDER_IN_STAGE number 22  √  null
PROC_STAGE_SETTING PROC_STAGE_DBID number 22
PROC_STAGE_SETTING SETTING_NO number 22
PROC_STAGE_SETTING SHOW_VALUE number 22  √  null
PROCESS CYCLE_NO_REQUIRED number 22
PROCESS DESCRIPTION varchar2 100  √  null
PROCESS NAME varchar2 50
PROCESS PROCESS_NO number 22
PROCESS SHOW_SET_UP number 22
PROCESS STER_NO number 4
RECEIPT_HEADER ACCEPT_RECEIPT char 1
RECEIPT_HEADER CARRIER_VENDOR_SYSTEM_ID number 22  √  null
RECEIPT_HEADER COMMENTS varchar2 200  √  null
RECEIPT_HEADER DOCUMENT_PRINTER_ID number 8  √  null
RECEIPT_HEADER LABEL_PRINTER_ID number 8  √  null
RECEIPT_HEADER LAST_MODIFIED_DT date 7
RECEIPT_HEADER NOTE_ID number 20  √  null
RECEIPT_HEADER RECEIPT_ID number 20
RECEIPT_HEADER RECEIPT_TYPE number 2
RECEIPT_HEADER RECV_LOCATION_ID number 22
RECEIPT_HEADER RETURN_TIME date 7
RECEIPT_HEADER STATUS number 2  √  null
RECEIPT_HEADER TRACKING_NO varchar2 40  √  null
RECEIPT_HEADER USER_ID number 22
RECEIPT_HEADER VENDOR_SYSTEM_ID number 22  √  null
RECEIPT_LINE PACKING_SLIP_NO varchar2 40  √  null
RECEIPT_LINE PO_NO varchar2 20  √  null
RECEIPT_LINE QTY_RECEIVED number 6
RECEIPT_LINE RECEIPT_ID number 20
RECEIPT_LINE RECEIPT_LINE_NO number 4
RECEIPT_LINE RECEIVED_TIME date 7
RECEIPT_LINE_DISTRIB DELIVERY_COMPANY_NO number 4  √  null
RECEIPT_LINE_DISTRIB DELIVERY_LOCATION_ID number 22  √  null
RECEIPT_LINE_DISTRIB DELIVERY_TICKET_ID varchar2 40  √  null
RECEIPT_LINE_DISTRIB DELIVERY_UNIT_NO number 4  √  null
RECEIPT_LINE_DISTRIB DISTRIB_LINE_NO number 5  √  null
RECEIPT_LINE_DISTRIB QTY_DISTRIB number 10  √  null
RECEIPT_LINE_DISTRIB RECEIPT_ID number 20
RECEIPT_LINE_DISTRIB RECEIPT_LINE_DISTRIB_NO number 4
RECEIPT_LINE_DISTRIB RECEIPT_LINE_NO number 4
RECEIPT_LOG_VW ACCEPT_RECEIPT char 1
RECEIPT_LOG_VW CARRIER_VENDOR_SYSTEM_ID number 22  √  null
RECEIPT_LOG_VW DELIV_COMP_NO number 4  √  null
RECEIPT_LOG_VW DELIV_LOC_ID number 22  √  null
RECEIPT_LOG_VW DELIVERY_TICKET_ID varchar2 40  √  null
RECEIPT_LOG_VW DELIVERY_UNIT_NO number 4  √  null
RECEIPT_LOG_VW DISTRIB_LINE_ID number 5  √  null
RECEIPT_LOG_VW LAST_MODIFIED_DT date 7
RECEIPT_LOG_VW NOTE_ID number 20  √  null
RECEIPT_LOG_VW PACKING_SLIP_NO varchar2 40  √  null
RECEIPT_LOG_VW PO_NO varchar2 20  √  null
RECEIPT_LOG_VW RECEIPT_ID number 20
RECEIPT_LOG_VW RECEIVED_TIME date 7
RECEIPT_LOG_VW RECEIVING_LOC_DESC varchar2 50  √  null
RECEIPT_LOG_VW RECEIVING_LOC_EXT_ID varchar2 5
RECEIPT_LOG_VW RECEIVING_LOC_ID number 22
RECEIPT_LOG_VW TRACKING_ID varchar2 40  √  null
RECEIPT_LOG_VW USER_ID number 22
RECEIPT_LOG_VW USER_NAME varchar2 80
RECEIPT_LOG_VW VENDOR_SYSTEM_ID number 22  √  null
RECIPIENT EMPLOYEE_ID varchar2 10  √  null
RECIPIENT FIRST_NAME varchar2 20  √  null
RECIPIENT LAST_NAME varchar2 20  √  null
RECIPIENT RECIPIENT_ID number 22
REPORT_SETTINGS CONTEXT varchar2 20
REPORT_SETTINGS DESCRIPTION varchar2 40
REPORT_SETTINGS REPORT_SETTINGS_ID number 22
REPORT_SETTINGS USER_ID number 22
REPORT_SETTINGS_PARAMETER PARAM_DISPLAY varchar2 2000  √  null
REPORT_SETTINGS_PARAMETER PARAM_ID number 22
REPORT_SETTINGS_PARAMETER PARAM_NAME varchar2 20  √  null
REPORT_SETTINGS_PARAMETER PARAM_VALUE varchar2 2000  √  null
REPORT_SETTINGS_PARAMETER REPORT_SETTINGS_ID number 22
REQUEST_QUEUE CHARGE_DTL_ID number 22
REQUEST_QUEUE ITEM_ID number 22
REQUEST_QUEUE LAST_UPDATE_DATE date 7
REQUEST_QUEUE QTY number 13
REQUEST_QUEUE REPLENISHMENT_TYPE char 1 '0'
REQUEST_QUEUE REQUEST_QUEUE_SEQ number 22
REQUEST_QUEUE SUPPLY_LOCATION_ID number 22
REQUEST_QUEUE UOM varchar2 4
REQUESTOR COMPANY_NO number 4
REQUESTOR REQUESTOR varchar2 10
REQUESTOR REQUESTOR_ID number 22
REQUESTOR REQUESTOR_NAME varchar2 30
REVENUE_CENTER COMPANY_NO number 4
REVENUE_CENTER CREATE_DATE date 7
REVENUE_CENTER IS_ACTIVE char 1
REVENUE_CENTER LAST_UPDATE_DATE date 7  √  null
REVENUE_CENTER REV_CTR_CODE varchar2 5
REVENUE_CENTER REV_CTR_DESC varchar2 30  √  null
REVENUE_CENTER REVENUE_CENTER_ID number 22
REVENUE_CENTER_ITEM CDM varchar2 80  √  null
REVENUE_CENTER_ITEM CREATE_DATE date 7
REVENUE_CENTER_ITEM IS_CHARGEABLE char 1
REVENUE_CENTER_ITEM ITEM_ID number 22
REVENUE_CENTER_ITEM LAST_UPDATE_DATE date 7  √  null
REVENUE_CENTER_ITEM PATIENT_PRICE number 13,2  √  null
REVENUE_CENTER_ITEM REV_CENTER_ITEM_SEQ number 22
REVENUE_CENTER_ITEM REVENUE_CENTER_ID number 22
ROUTE COMPANY number 4
ROUTE IS_DEFAULT_ROUTE char 1  √  null
ROUTE NAME varchar2 30
ROUTE ROUTE_ID number 22
ROUTE SEQUENCE_NO number 5
ROUTE TRANSFER_LOCATION_ID number 22  √  null
ROUTE_SOURCE_LOC LOCATION_ID number 22
ROUTE_SOURCE_LOC ROUTE_ID number 22
ROUTE_STOP LOCATION_ID number 22
ROUTE_STOP ROUTE_ID number 22
ROUTE_STOP SEQUENCE_NO number 5
SEQUENCES DESCRIPTION varchar2 50  √  null
SEQUENCES INCREMENT_VAL number 3
SEQUENCES SEQUENCE_NAME varchar2 30
SEQUENCES VALUE number 20
SERVICE NAME varchar2 40
SERVICE SERV_NO number 4
SETTING DESCRIPTION varchar2 50  √  null
SETTING NAME varchar2 50
SETTING RESULT_TYPE number 22
SETTING SETTING_NO number 22
SETTING TYPE number 22
SETTING UOM varchar2 50  √  null
SIGNATURE IMAGE_DATA long 0  √  null
SIGNATURE IMAGE_TYPE varchar2 20  √  null
SIGNATURE SIGNATURE_ID number 22
STAGE NAME varchar2 50
STAGE STAGE_NO number 22
STER_LOAD_HISTORY_VW LOAD_CREAT_DT date 7
STER_LOAD_HISTORY_VW LOAD_CYCLE_NO varchar2 50  √  null
STER_LOAD_HISTORY_VW LOAD_ID number 22
STER_LOAD_HISTORY_VW PICK_COMPANY_NO number 4
STER_LOAD_HISTORY_VW PICKLIST_NO varchar2 6
STERILIZATION_TYPE NAME varchar2 40
STERILIZATION_TYPE STER_NO number 4
STERILIZATION_TYPE TYPE number 22
STERILIZER_EQUIPMENT LOC_NO number 22
STERILIZER_EQUIPMENT NAME varchar2 100
STERILIZER_EQUIPMENT STER_NO number 4
STERILIZER_EQUIPMENT STERILIZER_EQ_NO number 8
SYNC CHECKSUM varchar2 30  √  null
SYNC DATA long 0
SYNC STATUS char 1
SYNC SYNC_ID number 20
SYNC SYNC_TYPE number 22
SYNC TIMESTAMP date 7
SYNC USER_ID number 22
TASK ACTUAL_QTY number 13,4  √  null
TASK ACTUAL_UOM varchar2 4  √  null
TASK CREATION_DT date 7
TASK ITEM_ID number 22  √  null
TASK LAST_MODIFIED_DT date 7
TASK PARENT_TASK_ID number 20  √  null
TASK REQUESTED_LOT_NO varchar2 10  √  null
TASK REQUESTED_QTY number 13,4  √  null
TASK REQUESTED_UOM varchar2 4  √  null
TASK REQUESTING_BIN_NO varchar2 7  √  null
TASK REQUESTING_LOCATION_ID number 22  √  null
TASK TASK_GD_02 date 7  √  null
TASK TASK_GD_O1 date 7  √  null
TASK TASK_GN_01 number 32  √  null
TASK TASK_GN_02 number 32  √  null
TASK TASK_GN_03 number 36,4  √  null
TASK TASK_GN_04 number 32  √  null
TASK TASK_GT_01 varchar2 100  √  null
TASK TASK_GT_02 varchar2 100  √  null
TASK TASK_GT_03 varchar2 100  √  null
TASK TASK_GT_04 varchar2 100  √  null
TASK TASK_ID number 20
TASK TASK_STATUS_CD varchar2 3
TASK TASK_TYPE varchar2 3
TEST_PARAMETER_NAME ID number 20
TEST_PARAMETER_NAME NAME varchar2 50
TEST_PARAMETER_NAME TYPE number 22
TL_GROUP FOOTER varchar2 200  √  null
TL_GROUP HEADER varchar2 200  √  null
TL_GROUP SEQ number 22
TL_GROUP SUB_TOTAL number 22  √  null
TL_GROUP TL_GRP_ID number 22
TL_GROUP TL_GRP_NO varchar2 10
TL_GROUP TL_ID number 22
TL_GROUP TS_GRP_NO number 4
TL_ITEM COMMENTS varchar2 200  √  null
TL_ITEM DISPLAYMFR number 1  √  null
TL_ITEM ITEM_ID number 22
TL_ITEM QTY number 22
TL_ITEM SEQ number 22
TL_ITEM TL_GRP_ID number 22
TL_ITEM TL_ITEM_ID number 22
TL_ITEM TL_ITEM_NO varchar2 6
TRACKING_LABEL_SEQ TRACKING_DT date 7
TRACKING_LABEL_SEQ VALUE number 5
TRANS_ITEM_UOM ITEM_ID number 22
TRANS_ITEM_UOM MULT_UOM number 15,5  √  null
TRANS_ITEM_UOM TRACK_FL varchar2 1
TRANS_ITEM_UOM TRANS_TYPE varchar2 1
TRANS_ITEM_UOM UOM varchar2 4
TRANSFER BATCH_NO varchar2 20  √  null
TRANSFER CARTSET_ASSM_NO varchar2 10  √  null
TRANSFER COMMENTS varchar2 40  √  null
TRANSFER END_TIME date 7
TRANSFER FROM_BIN varchar2 7  √  null
TRANSFER FROM_LOC_NO number 22  √  null
TRANSFER INSTRUMENT_TRACK_ID number 20  √  null
TRANSFER PATIENT_ID varchar2 14  √  null
TRANSFER START_TIME date 7
TRANSFER STAT_DESCR varchar2 200  √  null
TRANSFER STATUS number 22
TRANSFER TO_BIN varchar2 7  √  null
TRANSFER TO_LOC_NO number 22  √  null
TRANSFER TRANSFER_ID number 22
TRANSFER TRANSFER_NO varchar2 20
TRANSFER TS_NO varchar2 10  √  null
TRANSFER TYPE number 22
TRANSFER USER_ID number 22
TRANSFER_DETAILS_VW END_TIME date 7
TRANSFER_DETAILS_VW NUM_CASECARTS number 22  √  null
TRANSFER_DETAILS_VW NUM_TRAYS number 22  √  null
TRANSFER_DETAILS_VW TO_LOC_NO number 22  √  null
TRANSFER_DETAILS_VW TRANSFER_FACILITY_NUMBER number 4
TRANSFER_DETAILS_VW TRANSFER_ID number 22
TRANSFER_DETAILS_VW TRANSFER_LOCATION_CODE varchar2 5
TRANSFER_DETAILS_VW TRANSFER_LOCATION_NAME varchar2 50
TRANSFER_DETAILS_VW TRANSFER_NO varchar2 20
TRANSFER_DETAILS_VW TRANSFER_USER_FIRST_NAME varchar2 55  √  null
TRANSFER_DETAILS_VW TRANSFER_USER_LAST_NAME varchar2 55  √  null
TRANSFER_DETAILS_VW USER_ID number 22
TRANSFER_LOG FROM_BIN varchar2 7  √  null
TRANSFER_LOG FROM_LOC_NO number 22  √  null
TRANSFER_LOG STATUS number 22
TRANSFER_LOG TIME date 7
TRANSFER_LOG TO_BIN varchar2 7  √  null
TRANSFER_LOG TO_LOC_NO number 22  √  null
TRANSFER_LOG TR_LOG_ID number 22
TRANSFER_LOG TR_LOG_NO varchar2 30
TRANSFER_LOG TRANSFER_ITEM varchar2 30  √  null
TRANSFER_LOG TRANSFER_NO varchar2 20
TRANSFER_LOG TYPE number 22
TRAY HOT_TRAY_IND char 1
TRAY TL_NO varchar2 6  √  null
TRAY TRAY_ID number 22
TRAY TRAY_NO varchar2 5
TRAY TRAY_TYPE number 22  √  null
TRAY_ACTIVITY_VW ACTIVITY varchar2 15  √  null
TRAY_ACTIVITY_VW ACTIVITY_DT date 7  √  null
TRAY_ACTIVITY_VW ID_NO varchar2 50  √  null
TRAY_ACTIVITY_VW ID_TYPE varchar2 12  √  null
TRAY_ACTIVITY_VW LOCATION_ID number 22  √  null
TRAY_ACTIVITY_VW TRAY_NO varchar2 5  √  null
TRAY_ACTIVITY_VW TS_NO varchar2 10  √  null
TRAY_ACTIVITY_VW USER_ID number 22  √  null
TRAY_GROUP NAME varchar2 40
TRAY_GROUP TS_GRP_NO number 4
TRAY_IN_LOCATION_VW EXCEPTION_IND number 22  √  null
TRAY_IN_LOCATION_VW LOCATION_ID number 22  √  null
TRAY_IN_LOCATION_VW SERVICE_NAME varchar2 40  √  null
TRAY_IN_LOCATION_VW STER_DT date 7  √  null
TRAY_IN_LOCATION_VW SUBLOCATION_CODE varchar2 7  √  null
TRAY_IN_LOCATION_VW TL_DESCR varchar2 100
TRAY_IN_LOCATION_VW TL_NO varchar2 6
TRAY_INV_REP_VW ASSEMBLED_TRAY_STATUS varchar2 18  √  null
TRAY_INV_REP_VW ASSEMBLY_TIME_MINUTE number 22  √  null
TRAY_INV_REP_VW ASSEMBLY_TIME_SEC number 22  √  null
TRAY_INV_REP_VW COMPANY_NAME varchar2 30  √  null
TRAY_INV_REP_VW COMPANY_NO number 4
TRAY_INV_REP_VW INSTR_SRC_LOCATION number 22  √  null
TRAY_INV_REP_VW SERVICE_NAME varchar2 40  √  null
TRAY_INV_REP_VW SERVICE_NO number 4  √  null
TRAY_INV_REP_VW TOTAL_ITEMS number 22
TRAY_INV_REP_VW TRAY_ASID varchar2 10
TRAY_INV_REP_VW TRAY_LIST_NAME varchar2 100
TRAY_INV_REP_VW TRAY_LIST_NO varchar2 6
TRAY_INV_REP_VW TRAY_NO varchar2 5
TRAY_INV_REP_VW TRAYSET_ASSEMBLY_END_DT date 7  √  null
TRAY_INV_REP_VW TRAYSET_ASSEMBLY_START_DT date 7  √  null
TRAY_INV_REP_VW TRAYSET_EXCEPTION_COUNT number 22  √  null
TRAY_INV_REP_VW TRAYSET_LOCATION number 22  √  null
TRAY_INV_REP_VW TRAYSET_SUBLOCATION varchar2 7  √  null
TRAY_INV_SERVICE_REP_VW COMPANY_NO number 4
TRAY_INV_SERVICE_REP_VW FIRST_ASSM_TIME date 7  √  null
TRAY_INV_SERVICE_REP_VW INSTR_SRC_LOCATION number 22  √  null
TRAY_INV_SERVICE_REP_VW NEXT_ASSM_TIME date 7  √  null
TRAY_INV_SERVICE_REP_VW SERVICE_NAME varchar2 40
TRAY_INV_SERVICE_REP_VW SERVICE_NO number 4  √  null
TRAY_INV_SERVICE_REP_VW TOTAL_ITEMS number 22
TRAY_INV_SERVICE_REP_VW TRAY_ASID varchar2 10
TRAY_INV_SERVICE_REP_VW TRAY_LIST_NAME varchar2 100
TRAY_INV_SERVICE_REP_VW TRAY_LIST_NO varchar2 6
TRAY_INV_SERVICE_REP_VW TRAY_NO varchar2 9  √  null
TRAY_INV_SERVICE_REP_VW TRAYSET_ASSEMBLY_END_DT date 7  √  null
TRAY_INV_SERVICE_REP_VW TRAYSET_ASSEMBLY_START_DT date 7  √  null
TRAY_INV_SERVICE_REP_VW TRAYSET_EXCEPTION_COUNT number 22  √  null
TRAY_INV_SERVICE_REP_VW TRAYSET_LOCATION number 22  √  null
TRAY_INV_SERVICE_REP_VW TRAYSET_SUBLOCATION varchar2 7  √  null
TRAY_LIST BIO_TEST_REQD varchar2 1 'N'
TRAY_LIST CHARGE_CODE varchar2 50  √  null
TRAY_LIST COLOR_NO number 4  √  null
TRAY_LIST CREATED date 7
TRAY_LIST DECONTAM_ID number 4  √  null
TRAY_LIST DESCR varchar2 100
TRAY_LIST DISPLAYMFR number 1  √  null
TRAY_LIST FOOTER varchar2 200  √  null
TRAY_LIST HEADER varchar2 200  √  null
TRAY_LIST HOT_IND char 1
TRAY_LIST IMGLNK varchar2 255  √  null
TRAY_LIST SERV_NO number 4  √  null
TRAY_LIST SOURCE_LOCATION_NO number 22  √  null
TRAY_LIST STATUS number 1
TRAY_LIST STER_NO number 4  √  null
TRAY_LIST STORAGE_BIN varchar2 7  √  null
TRAY_LIST STORAGE_LOCATION_NO number 22  √  null
TRAY_LIST TL_EXT_NO varchar2 15  √  null
TRAY_LIST TL_ID number 22
TRAY_LIST TL_NO varchar2 6
TRAY_LIST TL_TYPE number 22
TRAY_LIST TOTAL number 22
TRAY_LIST USER_ID number 22
TRAY_LIST VERSION number 22
TRAY_LIST_ASSEMBLY_TIME_VW AVG_ASSEMBLY_SECONDS number 22  √  null
TRAY_LIST_ASSEMBLY_TIME_VW TL_NO varchar2 6
TRAY_LIST_CURRENT_VIEW CHARGE_CODE varchar2 50  √  null
TRAY_LIST_CURRENT_VIEW COLOR_NO number 4  √  null
TRAY_LIST_CURRENT_VIEW CREATED date 7
TRAY_LIST_CURRENT_VIEW DESCR varchar2 100
TRAY_LIST_CURRENT_VIEW DISPLAYMFR number 1  √  null
TRAY_LIST_CURRENT_VIEW FOOTER varchar2 200  √  null
TRAY_LIST_CURRENT_VIEW HEADER varchar2 200  √  null
TRAY_LIST_CURRENT_VIEW HOT_IND char 1
TRAY_LIST_CURRENT_VIEW IMGLNK varchar2 255  √  null
TRAY_LIST_CURRENT_VIEW SERV_NO number 4  √  null
TRAY_LIST_CURRENT_VIEW SOURCE_LOCATION_NO number 22  √  null
TRAY_LIST_CURRENT_VIEW STATUS number 1
TRAY_LIST_CURRENT_VIEW STER_NO number 4  √  null
TRAY_LIST_CURRENT_VIEW STORAGE_BIN varchar2 7  √  null
TRAY_LIST_CURRENT_VIEW STORAGE_LOCATION_NO number 22  √  null
TRAY_LIST_CURRENT_VIEW TL_EXT_NO varchar2 15  √  null
TRAY_LIST_CURRENT_VIEW TL_ID number 22
TRAY_LIST_CURRENT_VIEW TL_NO varchar2 6
TRAY_LIST_CURRENT_VIEW TL_TYPE number 22
TRAY_LIST_CURRENT_VIEW TOTAL number 22
TRAY_LIST_CURRENT_VIEW USER_ID number 22
TRAY_LIST_CURRENT_VIEW VERSION number 22
TRAY_LIST_CURRENT_VW LAST_REVISED date 7
TRAY_LIST_CURRENT_VW MAX_VERSION number 22
TRAY_LIST_CURRENT_VW SERV_NO number 4  √  null
TRAY_LIST_CURRENT_VW TOTAL_ITEMS number 22
TRAY_LIST_CURRENT_VW TRAY_LIST_CREATION_DT date 7  √  null
TRAY_LIST_CURRENT_VW TRAY_LIST_INSTR_LOC_ID number 22  √  null
TRAY_LIST_CURRENT_VW TRAY_LIST_MAX_ID number 22
TRAY_LIST_CURRENT_VW TRAY_LIST_NAME varchar2 100
TRAY_LIST_CURRENT_VW TRAY_LIST_NO varchar2 6
TRAY_LIST_ORMS_VW LAST_REVISED date 7
TRAY_LIST_ORMS_VW MAX_VERSION number 22
TRAY_LIST_ORMS_VW ROTATION_DAYS number 22  √  null
TRAY_LIST_ORMS_VW TOTAL_ITEMS number 22
TRAY_LIST_ORMS_VW TRAY_LIST_INSTR_LOC_ID number 22  √  null
TRAY_LIST_ORMS_VW TRAY_LIST_NAME varchar2 100
TRAY_LIST_ORMS_VW TRAY_LIST_NO varchar2 6
TRAY_LIST_SUMMARY_VIEW CREATED_DT date 7  √  null
TRAY_LIST_SUMMARY_VIEW CURRENT_TL_ID number 22
TRAY_LIST_SUMMARY_VIEW DESCR varchar2 100
TRAY_LIST_SUMMARY_VIEW FACILITY varchar2 30  √  null
TRAY_LIST_SUMMARY_VIEW ITEM_TRACKED number 22  √  null
TRAY_LIST_SUMMARY_VIEW LAST_MODIFIED_DATE date 7
TRAY_LIST_SUMMARY_VIEW LAST_USED_DT date 7  √  null
TRAY_LIST_SUMMARY_VIEW LOCATION_NAME varchar2 50
TRAY_LIST_SUMMARY_VIEW NUM_ITEMS number 22
TRAY_LIST_SUMMARY_VIEW NUM_TRAYS number 22  √  null
TRAY_LIST_SUMMARY_VIEW SERV_NO number 4  √  null
TRAY_LIST_SUMMARY_VIEW SERVICE_NAME varchar2 40  √  null
TRAY_LIST_SUMMARY_VIEW SOURCE_LOCATION_NO number 22  √  null
TRAY_LIST_SUMMARY_VIEW TL_NO varchar2 6
TRAY_LIST_SUMMARY_VIEW VERSION number 22
TRAY_ON_HOLD_VW COMMENTS varchar2 1000  √  null
TRAY_ON_HOLD_VW FIRST_NAME varchar2 55  √  null
TRAY_ON_HOLD_VW LAST_NAME varchar2 55  √  null
TRAY_ON_HOLD_VW ON_HOLD_DT date 7  √  null
TRAY_ON_HOLD_VW QTY_DAMAGED number 22  √  null
TRAY_ON_HOLD_VW QTY_MISSING number 22  √  null
TRAY_ON_HOLD_VW SOURCE_COMPANY_NAME varchar2 30  √  null
TRAY_ON_HOLD_VW SOURCE_COMPANY_NO number 4
TRAY_ON_HOLD_VW SOURCE_LOCATION_NAME varchar2 50
TRAY_ON_HOLD_VW SOURCE_LOCATION_NO number 22  √  null
TRAY_ON_HOLD_VW TL_DESCR varchar2 100
TRAY_ON_HOLD_VW TRAY_NO varchar2 5
TRAY_ON_HOLD_VW TS_ID number 22
TRAY_ROTATION_TIME_VW ASID varchar2 10
TRAY_ROTATION_TIME_VW FIRST_ASSM_TIME date 7  √  null
TRAY_ROTATION_TIME_VW NEXT_ASSM_TIME date 7  √  null
TRAY_ROTATION_TIME_VW TL_ID number 22  √  null
TRAY_ROTATION_TIME_VW TL_NO varchar2 6
TRAY_ROTATION_TIME_VW TRAY_NO varchar2 5
TRAY_USAGE ACTIVITY number 22
TRAY_USAGE ASM_TIME date 7
TRAY_USAGE TRAY_NO varchar2 5
TRAY_USAGE TS_NO varchar2 10
TRAYSET ASSM_DT date 7  √  null
TRAYSET ASSM_LOC_NO number 22  √  null
TRAYSET COMMENTS varchar2 1000  √  null
TRAYSET CREAT_DT date 7  √  null
TRAYSET HOLD_IND char 1  √  null
TRAYSET MOD_DT date 7  √  null
TRAYSET ON_HOLD_COMMENT varchar2 1000  √  null
TRAYSET STATUS number 22
TRAYSET STER_DONE varchar2 1 'N'
TRAYSET TL_ID number 22  √  null
TRAYSET TOTAL number 22
TRAYSET TRAY_NO varchar2 5
TRAYSET TRAYSET_BIN varchar2 7  √  null
TRAYSET TS_ID number 22
TRAYSET TS_NO varchar2 10
TRAYSET TS_TIME date 7
TRAYSET TS_TYPE number 22
TRAYSET USER_ID number 22
TRAYSET_CURRENT_VW ASSM_DT date 7  √  null
TRAYSET_CURRENT_VW ASSM_LOC_NO number 22  √  null
TRAYSET_CURRENT_VW COMMENTS varchar2 1000  √  null
TRAYSET_CURRENT_VW CREAT_DT date 7  √  null
TRAYSET_CURRENT_VW HOLD_IND char 1  √  null
TRAYSET_CURRENT_VW MOD_DT date 7  √  null
TRAYSET_CURRENT_VW ON_HOLD_COMMENT varchar2 1000  √  null
TRAYSET_CURRENT_VW STATUS number 22
TRAYSET_CURRENT_VW TL_ID number 22  √  null
TRAYSET_CURRENT_VW TOTAL number 22
TRAYSET_CURRENT_VW TRAY_NO varchar2 5
TRAYSET_CURRENT_VW TRAYSET_BIN varchar2 7  √  null
TRAYSET_CURRENT_VW TS_ID number 22
TRAYSET_CURRENT_VW TS_NO varchar2 10
TRAYSET_CURRENT_VW TS_TIME date 7
TRAYSET_CURRENT_VW TS_TYPE number 22
TRAYSET_CURRENT_VW USER_ID number 22
TRAYSET_TRAY ASSM_DT date 7  √  null
TRAYSET_TRAY ASSM_LOC_NO number 22  √  null
TRAYSET_TRAY CREAT_DT date 7  √  null
TRAYSET_TRAY HOLD_IND char 1  √  null
TRAYSET_TRAY HOT_TRAY_IND char 1
TRAYSET_TRAY MOD_DT date 7  √  null
TRAYSET_TRAY STATUS number 22
TRAYSET_TRAY TL_ID number 22  √  null
TRAYSET_TRAY TL_NO varchar2 6  √  null
TRAYSET_TRAY TOTAL number 22
TRAYSET_TRAY TRAY_ID number 22
TRAYSET_TRAY TRAY_NO varchar2 5
TRAYSET_TRAY TRAY_TYPE number 22  √  null
TRAYSET_TRAY TRAYSET_BIN varchar2 7  √  null
TRAYSET_TRAY TS_ID number 22
TRAYSET_TRAY TS_NO varchar2 10
TRAYSET_TRAY TS_TIME date 7
TRAYSET_TRAY TS_TYPE number 22
TRAYSET_TRAY USER_ID number 22
TS_INST_TK_DATA INSTRUMENT_ID varchar2 32  √  null
TS_INST_TK_DATA INSTRUMENT_TRACK_ID number 22  √  null
TS_INST_TK_DATA TL_ITEM_ID number 22
TS_INST_TK_DATA TS_ID number 22
TS_INST_TK_DATA TS_INST_TK_DATA_ID number 20
TS_INST_TK_EXCEPTION CHANGE_STATUS_TO_INACTIVE char 1
TS_INST_TK_EXCEPTION DESCR varchar2 200  √  null
TS_INST_TK_EXCEPTION EX_NO number 4
TS_INST_TK_EXCEPTION REP_INST_TRACK_ID number 22  √  null
TS_INST_TK_EXCEPTION REPL_LOCATION_ITEM_ID number 22  √  null
TS_INST_TK_EXCEPTION TS_INST_TK_DATA_ID number 22
TS_INST_TK_EXCEPTION TS_INST_TK_EX_ID number 20
TS_ITEM_EXCEPTION DESCR varchar2 200  √  null
TS_ITEM_EXCEPTION EX_NO number 4  √  null
TS_ITEM_EXCEPTION QTY number 22
TS_ITEM_EXCEPTION REPL_DESCR varchar2 200  √  null
TS_ITEM_EXCEPTION REPL_ITEM_NO number 22  √  null
TS_ITEM_EXCEPTION REPL_QTY number 22  √  null
TS_ITEM_EXCEPTION TL_ITEM_ID number 22
TS_ITEM_EXCEPTION TS_ID number 22
TS_ITEM_EXCEPTION TS_ITEM_ID number 22
TS_ITEM_EXCEPTION TS_ITEM_NO varchar2 10
TXN_TYPE TXN_NAME varchar2 30
TXN_TYPE TXN_TYPE char 1
UI_PAGE_MAPPING MAP_TO number 22
UI_PAGE_MAPPING SEQ number 9
UI_PAGE_MAPPING UI_PAGES_ID number 22
UI_PAGES IMG varchar2 255  √  null
UI_PAGES NAME varchar2 255
UI_PAGES PAGE varchar2 255  √  null
UI_PAGES TYPE varchar2 30  √  null
UI_PAGES UI_PAGES_ID number 22
UI_PAGES USR_ROLE_ID number 22  √  null
UI_PAGES WIDTH number 22  √  null
UOM DESCRIPTION varchar2 50  √  null
UOM NAME varchar2 4
USER_FACILITY_MAP FACILITY_ID number 22
USER_FACILITY_MAP USER_ID number 22
USER_GROUP NAME varchar2 60
USER_GROUP USR_GRP_ID number 22
USER_LOCATION_MAP COMPANY_NO number 4
USER_LOCATION_MAP COMPANY_ROLE_IND varchar2 1  √  null
USER_LOCATION_MAP LOCATION_ID number 22  √  null
USER_LOCATION_MAP USER_ID number 22
USER_ROLE NAME varchar2 60
USER_ROLE USR_ROLE_ID number 22
USERGROUP_USERROLE USR_GRP_ID number 22  √  null
USERGROUP_USERROLE USR_ROLE_ID number 22  √  null
USERPARFORM LOCATION_ID number 22
USERPARFORM USER_ID number 22
USERS ADDED_TO_MSC char 1
USERS CREATION_DT date 7
USERS EMAIL varchar2 100  √  null
USERS EMP_ID_VARCHAR varchar2 191  √  null
USERS EMPLOYEE_ID number 9  √  null
USERS EXT_DATA_IND char 1
USERS FIRST_NAME varchar2 55  √  null
USERS GLOBAL_ROLE_IND char 1  √  null
USERS ID_CONFLICT_DT date 7  √  null
USERS LAST_MODIFIED_DT date 7
USERS LAST_NAME varchar2 55  √  null
USERS NAME varchar2 80
USERS PASSWORD varchar2 1024  √  null
USERS REQUESTER varchar2 10  √  null
USERS SSOP varchar2 20  √  null
USERS STATUS char 1  √  null
USERS USER_ID number 22
USERS_USERGROUP USER_ID number 22  √  null
USERS_USERGROUP USR_GRP_ID number 22  √  null
VENDOR EXT_DATA_IND char 1
VENDOR EXTERNAL_STATUS char 1
VENDOR GROUP_ID varchar2 4
VENDOR INTERNAL_STATUS char 1
VENDOR IS_CARRIER char 1
VENDOR IS_MISC_RECEIVING char 1
VENDOR IS_PO_RECEIVING char 1
VENDOR POOL_OPTION char 1 '0'
VENDOR VENDOR_ID varchar2 9
VENDOR VENDOR_NAME varchar2 30
VENDOR VENDOR_SYSTEM_ID number 22
VENDOR_BUSINESS_RULES CARRIER_TRACKING_FORMAT_ID number 10
VENDOR_BUSINESS_RULES VENDOR_SYSTEM_ID number 22
VENDOR_CARRIER_MAP CARRIER_TRACKING_FORMAT_ID number 22
VENDOR_CARRIER_MAP MAX_MAP_VALUE varchar2 20
VENDOR_CARRIER_MAP MIN_MAP_VALUE varchar2 20
VENDOR_CARRIER_MAP VENDOR_SYSTEM_ID number 22
VENDOR_CLASS GROUP_ID varchar2 4
VENDOR_CLASS IS_MSCM_SYNC char 1
VENDOR_CLASS STATUS char 1
VENDOR_CLASS VENDOR_CLASS_ID varchar2 3
VENDOR_CLASS VENDOR_CLASS_NAME varchar2 30
VENDOR_GROUP EXTERNAL_STATUS char 1
VENDOR_GROUP GROUP_ID varchar2 4
VENDOR_GROUP GROUP_NAME varchar2 30
VENDOR_GROUP INTERNAL_STATUS char 1
VENDOR_GROUP_COMPANY COMPANY_NO number 4
VENDOR_GROUP_COMPANY GROUP_ID varchar2 4
WORKSTATION COMPANY_NO number 4
WORKSTATION CREATE_DATE date 7
WORKSTATION DEFAULT_REV_CTR_ID number 22  √  null
WORKSTATION DESCRIPTION varchar2 50  √  null
WORKSTATION HOSTNAME varchar2 256  √  null
WORKSTATION IDLE_GLOBAL char 1  √  'F'
WORKSTATION IDLE_TIME number 22  √  null
WORKSTATION IS_ACTIVE char 1
WORKSTATION LAST_UPDATE_DATE date 7  √  null
WORKSTATION WORKSTATION_ID number 22
WORKSTATION_LOCATION_GROUP CREATE_DATE date 7
WORKSTATION_LOCATION_GROUP LAST_UPDATE_DATE date 7  √  null
WORKSTATION_LOCATION_GROUP LOC_GROUP_ID number 22
WORKSTATION_LOCATION_GROUP WORKSTATION_ID number 22
WORKSTATION_LOCATION_GROUP WS_LOC_GROUP_ID number 22
WORKSTATION_PATIENT_LOCATION CREATE_DATE date 7
WORKSTATION_PATIENT_LOCATION LAST_UPDATE_DATE date 7  √  null
WORKSTATION_PATIENT_LOCATION PATIENT_LOCATION_ID number 22
WORKSTATION_PATIENT_LOCATION WORKSTATION_ID number 22
WORKSTATION_PATIENT_LOCATION WS_PATIENT_LOC_ID number 22
WORKSTATION_PRINTER_MAP PRINTER_ID number 8
WORKSTATION_PRINTER_MAP WORKSTATION_NAME varchar2 30
WORKSTATION_SUPPLY_LOCATION CREATE_DATE date 7
WORKSTATION_SUPPLY_LOCATION LAST_UPDATE_DATE date 7  √  null
WORKSTATION_SUPPLY_LOCATION LOCATION_ID number 22
WORKSTATION_SUPPLY_LOCATION WORKSTATION_ID number 22
WORKSTATION_SUPPLY_LOCATION WS_SUPPLY_LOC_ID number 22