GMI Tables (82)
GMI - Process Manufacturing Inventory — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
GMI_AUTO_ALLOCATION_BATCH |
50 | auto allocation batch parameter table |
GMI_CATEGORY_SETS |
10 | Stores the association between the OPM Classifications and the Category Sets. Any defined Category Set can be assigned to an OPM Classificat |
GMI_CLOS_WAREHOUSES |
9 | Warehouses to be closed for a year/period |
GMI_DISCRETE_TRANSFERS |
45 | Process to/from Discrete inventory transfer table. Holds transfer header information |
GMI_DISCRETE_TRANSFER_LINES |
68 | Process to/from Discrete inventory transfer lines table. Holds transfer lines information |
GMI_DISCRETE_TRANSFER_LOTS |
20 | Process to/from Discrete inventory transfer lots table. Holds transfer lots information belonging to transfer lines |
GMI_ITEMS_XML_INTERFACE |
99 | This table holds the xml gateway api request to add an Item to OPM |
GMI_ITEM_CATEGORIES |
8 | Stores the category assigned to OPM Items. Note that for existing OPM Classifications, the categories assigned are maintained both in this t |
GMI_ITEM_CONV_AUDIT |
14 | Contains history of all lot conversions holding old and new values and date of change |
GMI_ITEM_CONV_AUDIT_DETAILS |
16 | Contains inventory transaction details for a conversion record in gmi_item_conversion_audit table |
GMI_ITEM_ORGANIZATIONS |
6 | Relates OPM to Apps Organization Definitions |
GMI_LOTS_CONV_XML_INTERFACE |
16 | This table contains the Item/lot conversion xml api request. |
GMI_LOTS_XML_INTERFACE |
58 | This is the XML Lot API Interface table. This table stores data about individual xml lot api requests. |
GMI_LOT_TRACE |
6 | GMI Lot Trace |
GMI_MASSTRANS_CTL |
27 | Contains record of mass move transaction created. |
GMI_MIGRATION_PARAMETERS |
10 | This is a single row table that contains the values for the migration populated via the pre-migration form. |
GMI_OBSOLETE_ITEM_COLUMNS |
8 | This is table to store the reference to all OPM item master obsolete columns mapped to the discrete item master flexfield |
GMI_QUANTITY_XML_INTERFACE |
63 | This table entries for the XML Gateway Inventory Quantity API requests. |
GMI_SUBLOT_GENERATE |
8 | Holds values for next sublot to be generated for a Lot |
GMI_TRAN_TMP |
23 | Stores data temporarily for Pick Lots Screen |
IC_ADJS_JNL |
37 | Inventory adjustment detail |
IC_ALOT_PRM |
16 | Automatic lot allocation parameters |
IC_CLDR_DTL |
15 | Inventory calendar detail |
IC_CLDR_HDR_B |
14 | This table contains header information for the inventory calendar. The fiscal year is defined, calendar periods will be setup in the IC_CLDR |
IC_CLDR_HDR_TL |
10 | Translations table table holding OPM inventory calendar descriptions in multiple languages |
IC_COMD_CDS |
10 | Commodity Codes Table. This table contains information about the commodity codes which are used by the Intrastat Module. |
IC_CRUL_CLS |
12 | Count class table |
IC_CYCL_ADT |
39 | Cycle audit |
IC_CYCL_DTL |
14 | Cycle detail |
IC_CYCL_ERR |
13 | Cycle Count Error Table. |
IC_CYCL_HDR |
26 | This table contains the cycle header information. It will define the warehouse for which the count is taking place. |
IC_CYCL_MSC |
13 | This table contains the additional items added to a cycle count. |
IC_DECM_MST |
12 | Store information about records in IC_LOCT_INV whose decimal quantities have been reset to tolerance levels. |
IC_INVN_TYP |
42 | This table contains the definition of the Inventory Types that can be used throughout OPM. |
IC_ITEM_CDT |
14 | Scheduled count date |
IC_ITEM_CNV |
15 | This table contains the Item/lot conversion factors. |
IC_ITEM_CPG |
8 | This table contains item information that is specific to a CPG installation. |
IC_ITEM_HIERARCHY |
7 | This table contains hierarchical information defined for the Item Activation Workflow. Use this table to setup users to approve the creation |
IC_ITEM_MST_B |
119 | This is the Item definition table. It contains all information relating to an item, such as lot/sublot control, unit of measure information, |
IC_ITEM_MST_B_MIG |
10 | This is table to store the reference to all successfully migrated OPM items. A separate table is need because the OPM item can be migrated t |
IC_ITEM_MST_TL |
10 | Translations table table holding OPM item descriptions in multiple languages |
IC_ITEM_WHS |
8 | *NOT USED* |
IC_JRNL_MST |
50 | Journal master header table |
IC_LOCT_INV |
21 | Location inventory table. |
IC_LOCT_MST |
46 | This table contains location information for location controlled warehouses. |
IC_LOTS_CPG |
9 | This table contains lot information that is specific to a CPG installation. |
IC_LOTS_MST |
60 | This is the lot master table. This table stores data about individual lots for an item. |
IC_LOTS_MST_MIG |
18 | This is table to store the reference to all successfully migrated OPM items. A separate table is need because the OPM lots can be migrated t |
IC_LOTS_STS |
18 | Lot status table. |
IC_PERD_BAL |
26 | Inventory period balances |
IC_PHYS_CNT |
22 | Physical inventory and cycle counts |
IC_PHYS_ERR |
13 | Physical Inventory Posting Error Table. |
IC_PKGS_MST |
16 | *NOT USED* |
IC_PLNT_INV |
52 | Production rules, by item and plant. These rules are used by MRP and supply defaults for Production Batch creation. |
IC_PURG_PRM |
44 | Inventory purge parameters |
IC_RANK_MST |
18 | Inventory rank master. This table defines rank information for use in determining the cycle count schedule. |
IC_STAT_RPT |
13 | Intrastat reporting table. |
IC_TAXN_ASC |
11 | Item tax class association. This table associates items to item tax classes. |
IC_TEXT_HDR |
6 | Master table for creation and storage of text codes associated with GMI tables. |
IC_TEXT_TBL_TL |
13 | IC Module Text Lines. Descriptive text for all tables in this module. |
IC_TRAN_ARC |
37 | Inventory transaction archive |
IC_TRAN_CMP |
41 | Completed inventory transactions |
IC_TRAN_PND |
45 | Pending inventory transactions |
IC_TXN_REQUEST_HEADERS |
45 | Move Order Headers |
IC_TXN_REQUEST_LINES |
68 | Move order lines |
IC_WHSE_INV |
68 | Warehouse rules |
IC_WHSE_MST |
61 | Warehouse master.This table contains warehouse definition information. |
IC_WHSE_REL |
22 | Warehouse transfer rules table. This table contains information on transfers between warehouses, it is used by MRP. |
IC_WHSE_STS |
11 | Warehouse close status |
IC_XFER_MST |
68 | Inventory transfer master |
IN_ADDR_MST |
16 | EC Address Supplemental Details. Intrastat details relevant to ship-to address. |
IN_CTRY_MST |
11 | Country Codes. Intrastat specific country codes. |
IN_ITEM_MST |
12 | EC Item Supplemental Details. Item related Intrastat details. |
IN_REGN_MST |
10 | EC Regions Code. Intrastat region codes. |
IN_STAT_CTL |
17 | EC Statistics Control Table. Intrastat build run status by company code. |
IN_STAT_DTL |
39 | EC Statistics Detail. Intrastat statistics detail file. |
IN_STAT_HDR |
17 | EC Statistics Header. Intrastat statistics header file. |
IN_STAT_MSG |
9 | EC Statistics message table. Intrastat build error messages by company code. |
IN_TEXT_HDR |
6 | Intrastat Text Header Table. |
IN_TEXT_TBL_TL |
13 | IN Module Text Lines. Descriptive text for all tables in this module. |
IN_TOFD_MST |
10 | EC Terms of Delivery Table. Intrastat specific terms of delivery codes. |
SY_WF_ITEM_ROLES |
15 | Table used to relate Item ID with Roles. If the Item ID is NULL, then Roles will be associated with the warehouse Item ID. This table will |