The OMI interface uses the following database tables:
-
M_OMI_IMPORT_JOBS - This table stores the job definitions and job options.
-
M_IMPORT_INTERFACES - This table stores the data loaded either with SQL*Loader or the CIP package. This table is intermediate storage that is then processed by the OMI main program; the main program analyzes and validates the import data and creates BOM data items in the central Smart Materials BOM tables for valid input records.
-
M_IMPORT_INTERFACE_LOGS - This table stores the import protocols for OMI jobs. The import protocol block on the B.40.01 screen as well as the protocol report B.40.R.01 are based on this table.
-
M_IMPORT_INTERFACE_ERRS - If the main import program encounters and logs an error to the log table, the offending import records are also copied to this table in order to allow for easier analyzing of data errors. These records are displayed in the detail section in the B.40.01 Import protocol window.
-
M_PDS_BOM_CONFIGS - This table stores the header of a PDS-to-OMI transfer configuration.
-
M_PDS_BOM_CONFIG_ITEMS - This table stores the details of PDS-to-OMI transfer configuration in the context of a header record in table m_pds_bom_configs.
-
M_PDS_RAW_DATA - The PDS to OMI data source option initially loads a PDS standard G-Type BOM report into this intermediate table via SQL*Loader.