[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | EDW_ITEMS_M |
|---|---|
| Object Type: | TABLE |
| Owner: | ENI |
| Subobject Name: | |
| Status: | VALID |
This is the denormalized star table for the Item Dimension. It contains records for the lowest level of the Item dimension and their parentage up to the top level, across all hierarchies.
| Tablespace: |  APPS_TS_SUMMARY |
|---|---|
| PCT Free: | 30 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| EDW_ITEMS_M_U1 | NORMAL | UNIQUE |
APPS_TS_SUMMARY
|
 IREV_ITEM_REVISION_PK
IREV_ITEM_REVISION_PK_KEY
|
| EDW_ITEMS_M_U2 | NORMAL | UNIQUE |
APPS_TS_SUMMARY
|
IREV_ITEM_REVISION_PK_KEY
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CO15_CATEGORY_PK_KEY | NUMBER | System Generated unique identifier of the fifth level in the Item Organization Hierarchy | ||
| CO14_CATEGORY_PK_KEY | NUMBER | System Generated unique identifier of the fourth level in the Item Organization Hierarchy | ||
| CO13_CATEGORY_PK_KEY | NUMBER | System Generated unique identifier of the third level in the Item Organization Hierarchy | ||
| CO11_CATEGORY_PK_KEY | NUMBER | System Generated unique identifier of the first level in the Item Organization Hierarchy | ||
| CI310_CATEGORY_PK_KEY | NUMBER | System Generated unique identifier of the tenth level in the third Item category Hierarchy | ||
| CI39_CATEGORY_PK_KEY | NUMBER | System Generated unique identifier of the ninth level in the third Item category Hierarchy | ||
| CI38_CATEGORY_PK_KEY | NUMBER | System Generated unique identifier of the eigth level in the third Item category Hierarchy | ||
| CI37_CATEGORY_PK_KEY | NUMBER | System Generated unique identifier of the ctenth level in the seventh Item category Hierarchy | ||
| CI36_CATEGORY_PK_KEY | NUMBER | System Generated unique identifier of the sixth level in the third Item category Hierarchy | ||
| CI35_CATEGORY_PK_KEY | NUMBER | System Generated unique identifier of the fifth level in the third Item category Hierarchy | ||
| CI34_CATEGORY_PK_KEY | NUMBER | System Generated unique identifier of the forth level in the third Item category Hierarchy | ||
| CI33_CATEGORY_PK_KEY | NUMBER | System Generated unique identifier of the hird level in the third Item category Hierarchy | ||
| CI32_CATEGORY_PK_KEY | NUMBER | System Generated unique identifier of the second level in the third Item category Hierarchy | ||
| CI31_CATEGORY_PK_KEY | NUMBER | System Generated unique identifier of the first level in the third Item category Hierarchy | ||
| CI26_CATEGORY_PK_KEY | NUMBER | System Generated unique identifier of the sixth level in the second Item category Hierarchy | ||
| CI25_CATEGORY_PK_KEY | NUMBER | System Generated unique identifier of the fifth level in the second Item category Hierarchy | ||
| CI24_CATEGORY_PK_KEY | NUMBER | System Generated unique identifier of the fourth level in the second Item category Hierarchy | ||
| CI23_CATEGORY_PK_KEY | NUMBER | System Generated unique identifier of the third level in the second Item category Hierarchy | ||
| CI22_CATEGORY_PK_KEY | NUMBER | System Generated unique identifier of the second level in the second Item category Hierarchy | ||
| CI21_CATEGORY_PK_KEY | NUMBER | System Generated unique identifier of the first level in the second Item category Hierarchy | ||
| CI16_CATEGORY_PK_KEY | NUMBER | System Generated unique identifier of the sixth level in the first Item category Hierarchy | ||
| CI15_CATEGORY_PK_KEY | NUMBER | System Generated unique identifier of the fifth level in the first Item category Hierarchy | ||
| CI14_CATEGORY_PK_KEY | NUMBER | System Generated unique identifier of the fourth level in the first Item category Hierarchy | ||
| CI13_CATEGORY_PK_KEY | NUMBER | System Generated unique identifier of the third level in the first Item category Hierarchy | ||
| CI12_CATEGORY_PK_KEY | NUMBER | System Generated unique identifier of the second level in the first Item category Hierarchy | ||
| CI11_CATEGORY_PK_KEY | NUMBER | System Generated unique identifier of the first level in the first Item category Hierarchy | ||
| CO12_CATEGORY_PK_KEY | NUMBER | System Generated unique identifier of the second level in the Item Organization Hierarchy | ||
| PLIN_INTEREST_TYPE_ID | NUMBER | Unique identifier of the Product Line Interest type identifier | ||
| PLIN_PRODUCT_LINE_PK_KEY | NUMBER | System Generated unique identifier of the Product Line | ||
| PCTG_PRIMARY_CODE_ID | NUMBER | Unique Identifier for Primary Product Category Code | ||
| PCTG_PRODUCT_CATEG_PK_KEY | NUMBER | System Generated unique identifier for product category | ||
| PGRP_SECONDARY_CODE_ID | NUMBER | Unique identifier for seconday product category code | ||
| PGRP_PRODUCT_GROUP_PK_KEY | NUMBER | System Generated unique identifier for product group | ||
| ALL_ALL_PK_KEY | NUMBER | System Generated unique identifier for the top of the hierarchy | ||
| PRDF_PROD_FAMILY_PK_KEY | NUMBER | System Generated unique identifier for Product Family | ||
| ITEM_ITEM_NUMBER_PK_KEY | NUMBER | System generated unique identifier | ||
| IORG_UN_NUMBER_ID | NUMBER | Purchasing UN (United Nations) number | ||
| IORG_SHELF_LIFE_DAYS | NUMBER | Length of shelf life days | ||
| IORG_PRC_TOLERANCE_PCT | NUMBER | Purchase price tolerance percentage | ||
| IORG_MARKET_PRICE | NUMBER | Purchasing market price | ||
| IORG_LIST_UNIT_PRICE | NUMBER | Unit list price - purchasing | ||
| IORG_HAZARD_CLASS_ID | NUMBER | Purchasing hazard identifier | ||
| IORG_ITEM_ORG_PK_KEY | NUMBER | System generated unique identifier | ||
| IREV_ITEM_REVISION_PK_KEY | NUMBER | Yes | System generated unique identifier | |
| CI39_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User Defined Attribute for Ninth Level in Third Item Category Hierarchy | |
| CI39_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User Defined Attribute for Ninth Level in Third Item Category Hierarchy | |
| CI39_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User Defined Attribute for Ninth Level in Third Item Category Hierarchy | |
| CI39_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User Defined Attribute for Ninth Level in Third Item Category Hierarchy | |
| CI39_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User Defined Attribute for Ninth Level in Third Item Category Hierarchy | |
| CI39_NAME | VARCHAR2 | (320) | Name of the Category at Level 9 in the Third Item Category hierarchy | |
| CI39_INSTANCE_CODE | VARCHAR2 | (40) | The Instance that the category at Level 9 in the Third Item Category hierarchy was collected from | |
| CI39_DESCRIPTION | VARCHAR2 | (240) | Description of the Category at Level 9 in the Third Item Category hierarchy | |
| CI39_CATEGORY_SET_NAME | VARCHAR2 | (40) | Category Set of the category at level 9 in the ThirdItem Hierarchy | |
| CI39_CATEGORY_PK | VARCHAR2 | (240) | Unique Identifier of the ninth level in the third item category hierarchy | |
| CI39_CATEGORY_NAME | VARCHAR2 | (240) | Name of the Category at Level 9 in the Third Item Category hierarchy | |
| CI39_CATEGORY_DP | VARCHAR2 | (240) | Not currently used | |
| CI38_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User Defined Attribute for Eigth Level in Third Item Category Hierarchy | |
| CI38_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User Defined Attribute for Eigth Level in Third Item Category Hierarchy | |
| CI38_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User Defined Attribute for Eigth Level in Third Item Category Hierarchy | |
| CI38_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User Defined Attribute for Eigth Level in Third Item Category Hierarchy | |
| CI38_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User Defined Attribute for Eigth Level in Third Item Category Hierarchy | |
| CI38_NAME | VARCHAR2 | (320) | Name of the Category at Level 8 in the Third Item Category Hierarchy | |
| CI38_INSTANCE_CODE | VARCHAR2 | (40) | The Instance that the category at Level 8 in the Third Item Category Hierarchy was collected from | |
| CI38_DESCRIPTION | VARCHAR2 | (240) | Description of the Category at Level 8 in the Third Item Category Hierarchy | |
| CI38_CATEGORY_SET_NAME | VARCHAR2 | (40) | Category Set of the Category at Level 8 in the Third Item Hierarchy | |
| CI38_CATEGORY_PK | VARCHAR2 | (240) | Unique Identifier of the eigth level in the third item category hierarchy | |
| CI38_CATEGORY_NAME | VARCHAR2 | (240) | Name of the Category at Level 8 in the Third Item Category Hierarchy | |
| CI38_CATEGORY_DP | VARCHAR2 | (240) | Not currently used | |
| CI37_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User Defined Attribute for Seventh Level in Third Item Category Hierarchy | |
| CI37_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User Defined Attribute for Seventh Level in Third Item Category Hierarchy | |
| CI37_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User Defined Attribute for Seventh Level in Third Item Category Hierarchy | |
| CI37_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User Defined Attribute for Seventh Level in Third Item Category Hierarchy | |
| CI37_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User Defined Attribute for Seventh Level in Third Item Category Hierarchy | |
| CI37_NAME | VARCHAR2 | (320) | Name of the Category at Level 7 in the Third Item Category Hierarchy | |
| CI37_INSTANCE_CODE | VARCHAR2 | (40) | The Instance that the category at Level 7 in the Third Item Category Hierarchy was collected from | |
| CI37_DESCRIPTION | VARCHAR2 | (240) | Description of the Category at Level 7 in the Third Item Category Hierarchy | |
| CI37_CATEGORY_SET_NAME | VARCHAR2 | (40) | Category Set of the category at level 7 in the Third Item Hierarchy | |
| CI37_CATEGORY_PK | VARCHAR2 | (240) | Unique Identifier of the seventh level in the third item category hierarchy | |
| CI37_CATEGORY_NAME | VARCHAR2 | (240) | Name of the Category at Level 7 in the Third Item Category Hierarchy | |
| CI37_CATEGORY_DP | VARCHAR2 | (240) | Not currently used | |
| CI36_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User Defined Attribute for Sixth Level in Third Item Category Hierarchy | |
| CI36_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User Defined Attribute for Sixth Level in Third Item Category Hierarchy | |
| CI36_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User Defined Attribute for Sixth Level in Third Item Category Hierarchy | |
| CI36_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User Defined Attribute for Sixth Level in Third Item Category Hierarchy | |
| CI36_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User Defined Attribute for Sixth Level in Third Item Category Hierarchy | |
| CI36_NAME | VARCHAR2 | (320) | Name of the Category at Level 6 in the Third Item Category Hierarchy | |
| CI36_INSTANCE_CODE | VARCHAR2 | (40) | The Instance that the category at Level 6 in the Third Item Category Hierarchy was collected from | |
| CI36_DESCRIPTION | VARCHAR2 | (240) | Description of the Category at Level 6 in the Third Item Category Hierarchy | |
| CI36_CATEGORY_SET_NAME | VARCHAR2 | (40) | Category Set of the Category at Level 6 in the Third Item Hierarchy | |
| CI36_CATEGORY_PK | VARCHAR2 | (240) | Unique Identifier of the sixth level in the third item category hierarchy | |
| CI36_CATEGORY_NAME | VARCHAR2 | (240) | Name of the Category at Level 6 in the Third Item Category Hierarchy | |
| CI36_CATEGORY_DP | VARCHAR2 | (240) | Not currently used | |
| CI35_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User Defined Attribute for Fifth Level in Third Item Category Hierarchy | |
| CI35_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User Defined Attribute for Fifth Level in Third Item Category Hierarchy | |
| CI35_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User Defined Attribute for Fifth Level in Third Item Category Hierarchy | |
| CI35_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User Defined Attribute for Fifth Level in Third Item Category Hierarchy | |
| CI35_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User Defined Attribute for Fifth Level in Third Item Category Hierarchy | |
| CI35_NAME | VARCHAR2 | (320) | Name of the Category at Level 5 in the Third Item Category Hierarchy | |
| CI35_INSTANCE_CODE | VARCHAR2 | (40) | The Instance that the category at Level 5 in the Third Item Category Hierarchy was collected from | |
| CI35_DESCRIPTION | VARCHAR2 | (240) | Description of the Category at Level 5 in the Third Item Category Hierarchy | |
| CI35_CATEGORY_SET_NAME | VARCHAR2 | (40) | Category Set of the Category at Level 5 in the Third Item Hierarchy | |
| CI35_CATEGORY_PK | VARCHAR2 | (240) | Unique Identifier of the fifth level in the third item category hierarchy | |
| CI35_CATEGORY_NAME | VARCHAR2 | (240) | Name of the Category at Level 5 in the Third Item Category Hierarchy | |
| CI35_CATEGORY_DP | VARCHAR2 | (240) | Not currently used | |
| CI34_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User Defined Attribute for Fourth Level in Third Item Category Hierarchy | |
| CI34_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User Defined Attribute for Fourth Level in Third Item Category Hierarchy | |
| CI34_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User Defined Attribute for Fourth Level in Third Item Category Hierarchy | |
| CI34_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User Defined Attribute for Fourth Level in Third Item Category Hierarchy | |
| CI34_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User Defined Attribute for Fourth Level in Third Item Category Hierarchy | |
| CI34_NAME | VARCHAR2 | (320) | Name of the Category at Level 4 in the Third Item Category Hierarchy | |
| CI34_INSTANCE_CODE | VARCHAR2 | (40) | The Instance that the category at Level 4 in the Third Item Category Hierarchy was collected from | |
| CI34_DESCRIPTION | VARCHAR2 | (240) | Description of the Category at Level 4in the Third Item Category Hierarchy | |
| CI34_CATEGORY_SET_NAME | VARCHAR2 | (40) | Category Set of the Category at Level 4 in the Third Item Hierarchy | |
| CI34_CATEGORY_PK | VARCHAR2 | (240) | Unique Identifier of the fourth level in the third item category hierarchy | |
| CI34_CATEGORY_NAME | VARCHAR2 | (240) | Name of the Category at Level 4 in the Third Item Category Hierarchy | |
| CI34_CATEGORY_DP | VARCHAR2 | (240) | Not currently used | |
| CI33_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User Defined Attribute for Third Level in Third Item Category Hierarchy | |
| CI33_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User Defined Attribute for Third Level in Third Item Category Hierarchy | |
| CI33_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User Defined Attribute for Third Level in Third Item Category Hierarchy | |
| CI33_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User Defined Attribute for Third Level in Third Item Category Hierarchy | |
| CI33_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User Defined Attribute for Third Level in Third Item Category Hierarchy | |
| CI33_NAME | VARCHAR2 | (320) | Name of the Category at Level 3 in the Third Item Category Hierarchy | |
| CI33_INSTANCE_CODE | VARCHAR2 | (40) | The Instance that the category at Level 3 in the Third Item Category Hierarchy was collected from | |
| CI33_DESCRIPTION | VARCHAR2 | (240) | Description of the Category at Level 3 in the Third Item Category Hierarchy | |
| CI33_CATEGORY_SET_NAME | VARCHAR2 | (40) | Category Set of the Category at Level 3 in the Third Item Hierarchy | |
| CI33_CATEGORY_PK | VARCHAR2 | (240) | Unique Identifier of the third level in the third item category hierarchy | |
| CI33_CATEGORY_NAME | VARCHAR2 | (240) | Name of the Category at Level 3 in the Third Item Category Hierarchy | |
| CI33_CATEGORY_DP | VARCHAR2 | (240) | Not currently used | |
| CI32_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User Defined Attribute for Second Level in Third Item Category Hierarchy | |
| CI32_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User Defined Attribute for Second Level in Third Item Category Hierarchy | |
| CI32_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User Defined Attribute for Second Level in Third Item Category Hierarchy | |
| CI32_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User Defined Attribute for Second Level in Third Item Category Hierarchy | |
| CI32_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User Defined Attribute for Second Level in Third Item Category Hierarchy | |
| CI32_NAME | VARCHAR2 | (320) | Name of the Category at Level 2 in the Third Item Category Hierarchy | |
| CI32_INSTANCE_CODE | VARCHAR2 | (40) | The Instance that the category at Level 2 in the Third Item Category Hierarchy was collected from | |
| CI32_DESCRIPTION | VARCHAR2 | (240) | Description of the Category at Level 2 in the Third Item Category Hierarchy | |
| CI32_CATEGORY_SET_NAME | VARCHAR2 | (40) | Category Set of the Category at Level 2 in the Third Item Hierarchy | |
| CI32_CATEGORY_PK | VARCHAR2 | (240) | Unique Identifier of the second level in the third item category hierarchy | |
| CI32_CATEGORY_NAME | VARCHAR2 | (240) | Name of the Category at Level 2 in the Third Item Category Hierarchy | |
| CI32_CATEGORY_DP | VARCHAR2 | (240) | Not currently used | |
| CI310_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User Defined Attribute for Tenth Level in Third Item Category Hierarchy | |
| CI310_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User Defined Attribute for Tenth Level in Third Item Category Hierarchy | |
| CI310_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User Defined Attribute for Tenth Level in Third Item Category Hierarchy | |
| CI310_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User Defined Attribute for Tenth Level in Third Item Category Hierarchy | |
| CI310_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User Defined Attribute for Tenth Level in Third Item Category Hierarchy | |
| CI310_NAME | VARCHAR2 | (320) | Name of the Category at Level 10 in the Third Item Category Hierarchy | |
| CI310_INSTANCE_CODE | VARCHAR2 | (40) | The Instance that the category at Level 10 in the Third Item Category Hierarchy was collected from | |
| CI310_DESCRIPTION | VARCHAR2 | (240) | Description of the Category at Level 10 in the Third Item Category Hierarchy | |
| CI310_CATEGORY_SET_NAME | VARCHAR2 | (40) | Category Set of the Category at Level 10 in the Third Item Hierarchy | |
| CI310_CATEGORY_PK | VARCHAR2 | (240) | Unique Identifier of the tenth level in the third item category hierarchy | |
| CI310_CATEGORY_NAME | VARCHAR2 | (240) | Name of the Category at Level 10 in the Third Item Category Hierarchy | |
| CI310_CATEGORY_DP | VARCHAR2 | (240) | Not currently used | |
| CI31_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User Defined Attribute for First Level in Third Item Category Hierarchy | |
| CI31_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User Defined Attribute for First Level in Third Item Category Hierarchy | |
| CI31_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User Defined Attribute for First Level in Third Item Category Hierarchy | |
| CI31_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User Defined Attribute for First Level in Third Item Category Hierarchy | |
| CI31_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User Defined Attribute for First Level in Third Item Category Hierarchy | |
| CI31_NAME | VARCHAR2 | (320) | Name of the Category at Level 1 in the Third Item Category Hierarchy | |
| CI31_INSTANCE_CODE | VARCHAR2 | (40) | The Instance that the category at Level 1 in the Third Item Category Hierarchy was collected from | |
| CI31_DESCRIPTION | VARCHAR2 | (240) | Description of the Category at Level 1 in the Third Item Category Hierarchy | |
| CI31_CATEGORY_SET_NAME | VARCHAR2 | (40) | Category Set of the Category at Level 1 in the Third Item Hierarchy | |
| CI31_CATEGORY_PK | VARCHAR2 | (240) | Unique Identifier of the first level in the third item category hierarchy | |
| CI31_CATEGORY_NAME | VARCHAR2 | (240) | Name of the Category at Level 1 in the Third Item Category Hierarchy | |
| CI31_CATEGORY_DP | VARCHAR2 | (240) | Not currently used | |
| CI26_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User Defined Attribute for Sixth Level in Second Item Category Hierarchy | |
| CI26_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User Defined Attribute for Sixth Level in Second Item Category Hierarchy | |
| CI26_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User Defined Attribute for Sixth Level in Second Item Category Hierarchy | |
| CI26_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User Defined Attribute for Sixth Level in Second Item Category Hierarchy | |
| CI26_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User Defined Attribute for Sixth Level in Second Item Category Hierarchy | |
| CI26_NAME | VARCHAR2 | (320) | Name of the Category at Level 6 in the Second Item Category Hierarchy | |
| CI26_INSTANCE_CODE | VARCHAR2 | (40) | The Instance that the category at Level 6 in the Second Item Category Hierarchy was collected from | |
| CI26_DESCRIPTION | VARCHAR2 | (240) | Description of the Category at Level 6 in the Second Item Category Hierarchy | |
| CI26_CATEGORY_SET_NAME | VARCHAR2 | (40) | Category Set of the Category at Level 6 in the second Item Hierarchy | |
| CI26_CATEGORY_PK | VARCHAR2 | (240) | Unique Identifier of the sixth level in the second item category hierarchy | |
| CI26_CATEGORY_NAME | VARCHAR2 | (240) | Name of the Category at Level 6 in the Second Item Category Hierarchy | |
| CI26_CATEGORY_DP | VARCHAR2 | (240) | Not currently used | |
| CI25_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User Defined Attribute for Fifth Level in Second Item Category Hierarchy | |
| CI25_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User Defined Attribute for Fifth Level in Second Item Category Hierarchy | |
| CI25_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User Defined Attribute for Fifth Level in Second Item Category Hierarchy | |
| CI25_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User Defined Attribute for Fifth Level in Second Item Category Hierarchy | |
| CI25_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User Defined Attribute for Fifth Level in Second Item Category Hierarchy | |
| CI25_NAME | VARCHAR2 | (320) | Name of the Category at Level 5 in the Second Item Category Hierarchy | |
| CI25_INSTANCE_CODE | VARCHAR2 | (40) | The Instance that the category at Level 5 in the Second Item Category Hierarchy was collected from | |
| CI25_DESCRIPTION | VARCHAR2 | (240) | Description of the Category at Level 5 in the Second Item Category Hierarchy | |
| CI25_CATEGORY_SET_NAME | VARCHAR2 | (40) | Category Set of the Category at Level 5 in the Second Item Hierarchy | |
| CI25_CATEGORY_PK | VARCHAR2 | (240) | Unique Identifier of the fifth level in the second item category hierarchy | |
| CI25_CATEGORY_NAME | VARCHAR2 | (240) | Name of the Category at Level 5 in the Second Item Category Hierarchy | |
| CI25_CATEGORY_DP | VARCHAR2 | (240) | Not currently used | |
| CI24_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User Defined Attribute for Fourth Level in Second Item Category Hierarchy | |
| CI24_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User Defined Attribute for Fourth Level in Second Item Category Hierarchy | |
| CI24_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User Defined Attribute for Fourth Level in Second Item Category Hierarchy | |
| CI24_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User Defined Attribute for Fourth Level in Second Item Category Hierarchy | |
| CI24_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User Defined Attribute for Fourth Level in Second Item Category Hierarchy | |
| CI24_NAME | VARCHAR2 | (320) | Name of the Category at Level 4 in the Second Item Category Hierarchy | |
| CI24_INSTANCE_CODE | VARCHAR2 | (40) | The Instance that the category at Level 4 in the Second Item Category Hierarchy was collected from | |
| CI24_DESCRIPTION | VARCHAR2 | (240) | Description of the Category at Level 4 in the Second Item Category Hierarchy | |
| CI24_CATEGORY_SET_NAME | VARCHAR2 | (40) | Category Set of the Category at Level 4 in the second Item Hierarchy | |
| CI24_CATEGORY_PK | VARCHAR2 | (240) | Unique Identifier of the fourth level in the second item category hierarchy | |
| CI24_CATEGORY_NAME | VARCHAR2 | (240) | Name of the Category at Level 4 in the Second Item Category Hierarchy | |
| CI24_CATEGORY_DP | VARCHAR2 | (240) | Not currently used | |
| CI23_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User Defined Attribute for Third Level in Second Item Category Hierarchy | |
| CI23_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User Defined Attribute for Third Level in Second Item Category Hierarchy | |
| CI23_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User Defined Attribute for Third Level in Second Item Category Hierarchy | |
| CI23_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User Defined Attribute for Third Level in Second Item Category Hierarchy | |
| CI23_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User Defined Attribute for Third Level in Second Item Category Hierarchy | |
| CI23_NAME | VARCHAR2 | (320) | Name of the Category at Level 3 in the Second Item Category Hierarchy | |
| CI23_INSTANCE_CODE | VARCHAR2 | (40) | The Instance that the category at Level 3 in the Second Item Category Hierarchy was collected from | |
| CI23_DESCRIPTION | VARCHAR2 | (240) | Description of the Category at Level 3 in the Second Item Category Hierarchy | |
| CI23_CATEGORY_SET_NAME | VARCHAR2 | (40) | Category Set of the Category at Level 3 in the second Item Hierarchy | |
| CI23_CATEGORY_PK | VARCHAR2 | (240) | Unique Identifier of the third level in the second item category hierarchy | |
| CI23_CATEGORY_NAME | VARCHAR2 | (240) | Name of the Category at Level 3 in the Second Item Category Hierarchy | |
| CI23_CATEGORY_DP | VARCHAR2 | (240) | Not currently used | |
| CI22_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User Defined Attribute for Second Level in Second Item Category Hierarchy | |
| CI22_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User Defined Attribute for Second Level in Second Item Category Hierarchy | |
| CI22_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User Defined Attribute for Second Level in Second Item Category Hierarchy | |
| CI22_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User Defined Attribute for Second Level in Second Item Category Hierarchy | |
| CI22_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User Defined Attribute for Second Level in Second Item Category Hierarchy | |
| CI22_NAME | VARCHAR2 | (320) | Name of the Category at Level 2 in the Second Item Category Hierarchy | |
| CI22_INSTANCE_CODE | VARCHAR2 | (40) | The Instance that the category at Level 2 in the Second Item CategoryHierarchy was collected from | |
| CI22_DESCRIPTION | VARCHAR2 | (240) | Description of the Category at Level 2 in the Second Item Category Hierarchy | |
| CI22_CATEGORY_SET_NAME | VARCHAR2 | (40) | Category Set of the Category at Level 2 in the second Item Hierarchy | |
| CI22_CATEGORY_PK | VARCHAR2 | (240) | Unique Identifier of the second level in the second item category hierarchy | |
| CI22_CATEGORY_NAME | VARCHAR2 | (240) | Name of the Category at Level 2 in the Second Item Category Hierarchy | |
| CI22_CATEGORY_DP | VARCHAR2 | (240) | Not currently used | |
| CI21_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User Defined Attribute for First Level in Second Item Category Hierarchy | |
| CI21_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User Defined Attribute for First Level in Second Item Category Hierarchy | |
| CI21_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User Defined Attribute for First Level in Second Item Category Hierarchy | |
| CI21_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User Defined Attribute for First Level in Second Item Category Hierarchy | |
| CI21_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User Defined Attribute for First Level in Second Item Category Hierarchy | |
| CI21_NAME | VARCHAR2 | (320) | Name of the Category at Level 1 in the Second Item Category Hierarchy | |
| CI21_INSTANCE_CODE | VARCHAR2 | (40) | The Instance that the category at Level 1 in the Second Item Category Hierarchy was collected from | |
| CI21_DESCRIPTION | VARCHAR2 | (240) | Description of the Category at Level 1 in the Second Item Category Hierarchy | |
| CI21_CATEGORY_SET_NAME | VARCHAR2 | (40) | Category Set of the Category at Level 1 in the second Item Hierarchy | |
| CI21_CATEGORY_PK | VARCHAR2 | (240) | Unique Identifier of the first level in the second item category hierarchy | |
| CI21_CATEGORY_NAME | VARCHAR2 | (240) | Name of the Category at Level 1 in the Second Item Category Hierarchy | |
| CI21_CATEGORY_DP | VARCHAR2 | (240) | Not currently used | |
| CI16_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User Defined Attribute for Sixth Level in First Item Category Hierarchy | |
| CI16_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User Defined Attribute for Sixth Level in First Item Category Hierarchy | |
| CI16_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User Defined Attribute for Sixth Level in First Item Category Hierarchy | |
| CI16_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User Defined Attribute for Sixth Level in First Item Category Hierarchy | |
| CI16_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User Defined Attribute for Sixth Level in First Item Category Hierarchy | |
| CI16_NAME | VARCHAR2 | (320) | Name of the Category at Level 6 in the First Item Category Hierarchy | |
| CI16_INSTANCE_CODE | VARCHAR2 | (40) | The Instance that the category at Level 6 in the First Item Category Hierarchy was collected from | |
| CI16_DESCRIPTION | VARCHAR2 | (240) | Description of the Category at Level 6 in the First Item Category Hierarchy | |
| CI16_CATEGORY_SET_NAME | VARCHAR2 | (40) | Category Set of the Category at Level 6 in the First Item Hierarchy | |
| CI16_CATEGORY_PK | VARCHAR2 | (240) | Unique Identifier of the sixth level in the first item category hierarchy | |
| CI16_CATEGORY_NAME | VARCHAR2 | (240) | Name of the Category at Level 6 in the First Item Category Hierarchy | |
| CI16_CATEGORY_DP | VARCHAR2 | (240) | Not currently used | |
| CI15_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User Defined Attribute for Fifth Level in First Item Category Hierarchy | |
| CI15_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User Defined Attribute for Fifth Level in First Item Category Hierarchy | |
| CI15_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User Defined Attribute for Fifth Level in First Item Category Hierarchy | |
| CI15_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User Defined Attribute for Fifth Level in First Item Category Hierarchy | |
| CI15_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User Defined Attribute for Fifth Level in First Item Category Hierarchy | |
| CI15_NAME | VARCHAR2 | (320) | Name of the Category at Level 5 in the First Item Category Hierarchy | |
| CI15_INSTANCE_CODE | VARCHAR2 | (40) | The Instance that the category at Level 5 in the First Item Category Hierarchy was collected from | |
| CI15_DESCRIPTION | VARCHAR2 | (240) | Description of the Category at Level 5 in the First Item Category Hierarchy | |
| CI15_CATEGORY_SET_NAME | VARCHAR2 | (40) | Category Set of the Category at Level 5 in the First Item Hierarchy | |
| CI15_CATEGORY_PK | VARCHAR2 | (240) | Unique Identifier of the fifth level in the first item category hierarchy | |
| CI15_CATEGORY_NAME | VARCHAR2 | (240) | Name of the Category at Level 5 in the First Item Category Hierarchy | |
| CI15_CATEGORY_DP | VARCHAR2 | (240) | Not currently used | |
| CI14_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User Defined Attribute for Fourth Level in First Item Category Hierarchy | |
| CI14_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User Defined Attribute for Fourth Level in First Item Category Hierarchy | |
| CI14_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User Defined Attribute for Fourth Level in First Item Category Hierarchy | |
| CI14_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User Defined Attribute for Fourth Level in First Item Category Hierarchy | |
| CI14_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User Defined Attribute for Fourth Level in First Item Category Hierarchy | |
| CI14_NAME | VARCHAR2 | (320) | Name of the Category at Level 4 in the First Item Category Hierarchy | |
| CI14_INSTANCE_CODE | VARCHAR2 | (40) | The Instance that the category at Level 4 in the First Item Category Hierarchy was collected from | |
| CI14_DESCRIPTION | VARCHAR2 | (240) | Description of the Category at Level 4 in the First Item Category Hierarchy | |
| CI14_CATEGORY_SET_NAME | VARCHAR2 | (40) | Category Set of the Category at Level 4 in the First Item Hierarchy | |
| CI14_CATEGORY_PK | VARCHAR2 | (240) | Unique Identifier of the fourth level in the first item category hierarchy | |
| CI14_CATEGORY_NAME | VARCHAR2 | (240) | Name of the Category at Level 4 in the First Item Category Hierarchy | |
| CI14_CATEGORY_DP | VARCHAR2 | (240) | Not currently used | |
| CI13_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User Defined Attribute for Third Level in First Item Category Hierarchy | |
| CI13_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User Defined Attribute for Third Level in First Item Category Hierarchy | |
| CI13_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User Defined Attribute for Third Level in First Item Category Hierarchy | |
| CI13_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User Defined Attribute for Third Level in First Item Category Hierarchy | |
| CI13_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User Defined Attribute for Third Level in First Item Category Hierarchy | |
| CI13_NAME | VARCHAR2 | (320) | Name of the Category at Level 3 in the First Item Category Hierarchy | |
| CI13_INSTANCE_CODE | VARCHAR2 | (40) | The Instance that the category at Level 3 in the First Item Category Hierarchy was collected from | |
| CI13_DESCRIPTION | VARCHAR2 | (240) | Description of the Category at Level 3 in the First Item Category Hierarchy | |
| CI13_CATEGORY_SET_NAME | VARCHAR2 | (40) | Category Set of the Category at Level 3 in the First Item Hierarchy | |
| CI13_CATEGORY_PK | VARCHAR2 | (240) | Unique Identifier of the third level in the first item category hierarchy | |
| CI13_CATEGORY_NAME | VARCHAR2 | (240) | Name of the Category at Level 3 in the First Item Category Hierarchy | |
| CI13_CATEGORY_DP | VARCHAR2 | (240) | Not currently used | |
| CI12_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User Defined Attribute for Second Level in First Item Category Hierarchy | |
| CO11_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User Defined Attribute for the First Level in First Item Organization Hierarchy | |
| CO11_CATEGORY_PK | VARCHAR2 | (240) | Unique Identifier of the First Level in the First Item Organization Hierarchy | |
| CO11_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User Defined Attribute for the First Level in First Item Organization Hierarchy | |
| CO11_INSTANCE_CODE | VARCHAR2 | (40) | The Instance that the organization at Level 1 in the First Item Organization hierarchy was collected from | |
| CO11_NAME | VARCHAR2 | (320) | Name of the Organization at Level 1 in the First Item Organization hierarchy | |
| CO11_DESCRIPTION | VARCHAR2 | (240) | Description of the Organization at Level 1 in the First Item Organization Hierarchy | |
| CO11_CATEGORY_SET_NAME | VARCHAR2 | (40) | Category Set name of the category at Level 1 in the First Item Organization Hierarchy. | |
| CO11_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User Defined Attribute for the First Level in First Item Organization Hierarchy | |
| CO11_CATEGORY_DP | VARCHAR2 | (240) | Not currently used | |
| CO11_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User Defined Attribute for the First Level in First Item Organization Hierarchy | |
| CO11_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User Defined Attribute for the First Level in First Item Organization Hierarchy | |
| CO11_CATEGORY_NAME | VARCHAR2 | (240) | Name of the Category at Level 1 in the First Item Organization Hierarchy | |
| CO16_CATEGORY_PK_KEY | VARCHAR2 | (240) | System generatedUnique Identifier of the sixth Level in the First Item Organization Hierarchy | |
| CO12_CATEGORY_PK | VARCHAR2 | (240) | Unique Identifier of the second level in the item organization hierarchy. | |
| IORG_SEGMENT1 | VARCHAR2 | (40) | The first segment of teh Item Number key flex segments | |
| CO15_NAME | VARCHAR2 | (320) | Name of the Organization at Level 5 in the First Item Organization hierarchy | |
| CO15_CATEGORY_SET_NAME | VARCHAR2 | (40) | Category Set name of the category at Level 5 in the First Item Organization Hierarchy. | |
| CO14_CATEGORY_DP | VARCHAR2 | (240) | Not currently used | |
| CO14_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User Defined Attribute for the Fourth Level in First Item Organization Hierarchy | |
| CO14_CATEGORY_NAME | VARCHAR2 | (240) | Name of the Category at Level 4 in the First Item Organization Hierarchy | |
| CO14_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User Defined Attribute for the Fourth Level in First Item Organization Hierarchy | |
| CO13_CATEGORY_PK | VARCHAR2 | (240) | Unique Identifier of the third level in the item organization hierarchy. | |
| CO13_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User Defined Attribute for the Third Level in First Item Organization Hierarchy | |
| CO13_INSTANCE_CODE | VARCHAR2 | (40) | The Instance that the organization at Level 3 in the First Item Organization hierarchy was collected from | |
| CO16_CATEGORY_DP | VARCHAR2 | (240) | Not currently used | |
| CO16_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User Defined Attribute for the Sixth Level in First Item Organization Hierarchy | |
| CO16_CATEGORY_NAME | VARCHAR2 | (240) | Name of the Category at Level 6 in the First Item Organization Hierarchy | |
| CO16_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User Defined Attribute for the Sixth Level in First Item Organization Hierarchy | |
| CO16_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User Defined Attribute for the Sixth Level in First Item Organization Hierarchy | |
| CO16_DESCRIPTION | VARCHAR2 | (240) | Description of the Organization at Level 6 in the First Item Organization Hierarchy | |
| CO16_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User Defined Attribute for the Sixth Level in First Item Organization Hierarchy | |
| CO16_CATEGORY_PK | VARCHAR2 | (240) | Unique Identifier of the sixth level in the item organization hierarchy. | |
| CO16_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User Defined Attribute for the Sixth Level in First Item Organization Hierarchy | |
| CO16_INSTANCE_CODE | VARCHAR2 | (40) | The Instance that the organization at Level 6 in the First Item Organization hierarchy was collected from | |
| CO16_NAME | VARCHAR2 | (320) | Name of the Organization at Level 6 in the First Item Organization hierarchy | |
| CO15_CATEGORY_DP | VARCHAR2 | (240) | Not currently used | |
| CO15_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User Defined Attribute for the Fifth Level in First Item Organization Hierarchy | |
| CO15_CATEGORY_NAME | VARCHAR2 | (240) | Name of the Category at Level 5 in the First Item Organization Hierarchy | |
| CO15_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User Defined Attribute for the Fifth Level in First Item Organization Hierarchy | |
| CO15_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User Defined Attribute for the Fifth Level in First Item Organization Hierarchy | |
| CO15_DESCRIPTION | VARCHAR2 | (240) | Description of the Organization at Level 5 in the First Item Organization Hierarchy | |
| CO15_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User Defined Attribute for the Fifth Level in First Item Organization Hierarchy | |
| CO15_CATEGORY_PK | VARCHAR2 | (240) | Unique Identifier of the fifth level in the item organization hierarchy. | |
| CO15_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User Defined Attribute for the Fifth Level in First Item Organization Hierarchy | |
| CO15_INSTANCE_CODE | VARCHAR2 | (40) | The Instance that the organization at Level 5 in the First Item Organization hierarchy was collected from | |
| CO14_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User Defined Attribute for the Fourth Level in First Item Organization Hierarchy | |
| CO14_CATEGORY_SET_NAME | VARCHAR2 | (40) | Category Set name of the category at Level 4 in the First Item Organization Hierarchy. | |
| CO14_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User Defined Attribute for the Fourth Level in First Item Organization Hierarchy | |
| CO12_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User Defined Attribute for the Second Level in First Item Organization Hierarchy | |
| CO12_CATEGORY_DP | VARCHAR2 | (240) | Not currently used | |
| CO12_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User Defined Attribute for the Second Level in First Item Organization Hierarchy | |
| CO12_CATEGORY_NAME | VARCHAR2 | (240) | Name of the Category at Level 2 in the First Item Organization Hierarchy | |
| CO12_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User Defined Attribute for the Second Level in First Item Organization Hierarchy | |
| CO12_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User Defined Attribute for the Second Level in First Item Organization Hierarchy | |
| CO12_INSTANCE_CODE | VARCHAR2 | (40) | The Instance that the organization at Level 2 in the First Item Organization hierarchy was collected from | |
| CO12_NAME | VARCHAR2 | (320) | Name of the Organization at Level 2 in the First Item Organization hierarchy | |
| CO12_DESCRIPTION | VARCHAR2 | (240) | Description of the Organization at Level 2 in the First Item Organization Hierarchy | |
| CO12_CATEGORY_SET_NAME | VARCHAR2 | (40) | Category Set name of the category at Level 2 in the First Item Organization Hierarchy. | |
| CO13_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User Defined Attribute for the Third Level in First Item Organization Hierarchy | |
| CO13_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User Defined Attribute for the Third Level in First Item Organization Hierarchy | |
| CO13_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User Defined Attribute for the Third Level in First Item Organization Hierarchy | |
| CO12_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User Defined Attribute for the Second Level in First Item Organization Hierarchy | |
| CO13_NAME | VARCHAR2 | (320) | Name of the Organization at Level 3 in the First Item Organization hierarchy | |
| CO13_DESCRIPTION | VARCHAR2 | (240) | Description of the Organization at Level 3 in the First Item Organization Hierarchy | |
| CO13_CATEGORY_NAME | VARCHAR2 | (240) | Name of the Category at Level 3 in the First Item Organization Hierarchy | |
| CO13_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User Defined Attribute for the Third Level in First Item Organization Hierarchy | |
| CO13_CATEGORY_DP | VARCHAR2 | (240) | Not currently used | |
| CO13_CATEGORY_SET_NAME | VARCHAR2 | (40) | Category Set name of the category at Level 3 in the First Item Organization Hierarchy. | |
| CO14_CATEGORY_PK | VARCHAR2 | (240) | Unique Identifier of the fourth level in the item organization hierarchy. | |
| CO14_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User Defined Attribute for the Fourth Level in First Item Organization Hierarchy | |
| CO14_INSTANCE_CODE | VARCHAR2 | (40) | The Instance that the organization at Level 4 in the First Item Organization hierarchy was collected from | |
| CO14_NAME | VARCHAR2 | (320) | Name of the Organization at Level 54in the First Item Organization hierarchy | |
| CO14_DESCRIPTION | VARCHAR2 | (240) | Description of the Organization at Level 4 in the First Item Organization Hierarchy | |
| CI11_INSTANCE_CODE | VARCHAR2 | (40) | The Instance that the category at Level 1 in the First Item Category Hierarchy was collected from | |
| CI11_DESCRIPTION | VARCHAR2 | (240) | Description of the Category at Level 1 in the First Item Category Hierarchy | |
| CI11_CATEGORY_SET_NAME | VARCHAR2 | (40) | Category Set that the Category Name of the Category at Level 1 in the First Item Category Hierarchy is part of | |
| CI11_CATEGORY_PK | VARCHAR2 | (240) | Unique Identifier of the first level in the first item category hierarchy. | |
| CI11_CATEGORY_NAME | VARCHAR2 | (240) | Name of the Category at Level 1 in the First Item Category Hierarchy | |
| CI11_CATEGORY_DP | VARCHAR2 | (240) | Not currently used | |
| CI12_INSTANCE_CODE | VARCHAR2 | (40) | The Instance that the category at Level 2 in the First Item Category Hierarchy was collected from | |
| CI12_DESCRIPTION | VARCHAR2 | (240) | Description of the Category at Level 2 in the First Item Category Hierarchy | |
| CI12_CATEGORY_SET_NAME | VARCHAR2 | (40) | Category Set that the Category Name of the Category at Level 2 in the First Item Category Hierarchy is part of | |
| CI12_CATEGORY_PK | VARCHAR2 | (240) | Unique Identifier of the second level in the first item category hierarchy | |
| CI12_CATEGORY_NAME | VARCHAR2 | (240) | Name of the Category at Level 2 in the First Item Category Hierarchy | |
| CI12_CATEGORY_DP | VARCHAR2 | (240) | Not currently used | |
| CI11_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User Defined Attribute for First Level in First Item Category Hierarchy | |
| CO16_CATEGORY_SET_NAME | VARCHAR2 | (40) | Category Set name of the category at Level 6 in the First Item Organization Hierarchy. | |
| CI11_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User Defined Attribute for First Level in First Item Category Hierarchy | |
| CI11_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User Defined Attribute for First Level in First Item Category Hierarchy | |
| CI11_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User Defined Attribute for First Level in First Item Category Hierarchy | |
| CI11_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User Defined Attribute for First Level in First Item Category Hierarchy | |
| CI11_NAME | VARCHAR2 | (320) | Name of the Category at Level 1 in the First Item Category Hierarchy | |
| CI12_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User Defined Attribute for Second Level in First Item Category Hierarchy | |
| CI12_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User Defined Attribute for Second Level in First Item Category Hierarchy | |
| CI12_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User Defined Attribute for Second Level in First Item Category Hierarchy | |
| CI12_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User Defined Attribute for Second Level in First Item Category Hierarchy | |
| CI12_NAME | VARCHAR2 | (320) | Name of the Category at Level 2 in the First Item Category Hierarchy | |
| PLIN_USER_ATTRIBUTE5 | VARCHAR2 | (240) | Product Line User defined attribute | |
| PLIN_USER_ATTRIBUTE4 | VARCHAR2 | (240) | Product Line User defined attribute | |
| PLIN_USER_ATTRIBUTE3 | VARCHAR2 | (240) | Product Line User defined attribute | |
| PLIN_USER_ATTRIBUTE2 | VARCHAR2 | (240) | Product Line User defined attribute | |
| PLIN_USER_ATTRIBUTE1 | VARCHAR2 | (240) | Product Line User defined attribute | |
| PLIN_PRODUCT_LINE_DP | VARCHAR2 | (240) | Not currently used | |
| PLIN_PRODUCT_LINE_PK | VARCHAR2 | (240) | Unique identifier | |
| PLIN_NAME | VARCHAR2 | (320) | Product Line name | |
| PLIN_INSTANCE_CODE | VARCHAR2 | (40) | Instance from which the product line level record was collected | |
| PLIN_ENABLED_FLAG | VARCHAR2 | (20) | Enabled Flag | |
| PLIN_DESCRIPTION | VARCHAR2 | (240) | Description of the Product Line (Interest Type) | |
| PCTG_USER_ATTRIBUTE5 | VARCHAR2 | (240) | Product Category User defined attribute | |
| PCTG_USER_ATTRIBUTE4 | VARCHAR2 | (240) | Product Category User defined attribute | |
| PCTG_USER_ATTRIBUTE3 | VARCHAR2 | (240) | Product Category User defined attribute | |
| PCTG_USER_ATTRIBUTE2 | VARCHAR2 | (240) | Product Category User defined attribute | |
| PCTG_USER_ATTRIBUTE1 | VARCHAR2 | (240) | Product Category User defined attribute | |
| PCTG_PRODUCT_CATEG_DP | VARCHAR2 | (240) | Not currently used | |
| PCTG_PRODUCT_CATEG_PK | VARCHAR2 | (240) | Unique identifier | |
| PCTG_NAME | VARCHAR2 | (320) | Product Category name | |
| PCTG_INSTANCE_CODE | VARCHAR2 | (40) | Instance from which the Product Category level record was collected | |
| PCTG_ENABLED_FLAG | VARCHAR2 | (20) | Enabled flag | |
| PCTG_DESCRIPTION | VARCHAR2 | (240) | Description of the Product Category (Primary Interest Code) | |
| PGRP_USER_ATTRIBUTE5 | VARCHAR2 | (240) | Product Group User defined attribute | |
| PGRP_USER_ATTRIBUTE4 | VARCHAR2 | (240) | Product Group User defined attribute | |
| PGRP_USER_ATTRIBUTE3 | VARCHAR2 | (240) | Product Group User defined attribute | |
| PGRP_USER_ATTRIBUTE2 | VARCHAR2 | (240) | Product Group User defined attribute | |
| PGRP_USER_ATTRIBUTE1 | VARCHAR2 | (240) | Product Group User defined attribute | |
| PGRP_PRODUCT_GROUP_DP | VARCHAR2 | (240) | Not currently used | |
| PGRP_PRODUCT_GROUP_PK | VARCHAR2 | (240) | Unique identifier | |
| PGRP_NAME | VARCHAR2 | (320) | Product Group name | |
| PGRP_INSTANCE_CODE | VARCHAR2 | (40) | Instance from which the Product Group level record was collected | |
| PGRP_ENABLED_FLAG | VARCHAR2 | (20) | Enabled flag | |
| PGRP_DESCRIPTION | VARCHAR2 | (240) | Description of the Product Group (Secondary Interest Code) | |
| ALL_NAME | VARCHAR2 | (320) | All items item category name | |
| ALL_ALL_PK | VARCHAR2 | (40) | Unique identifier | |
| PRDF_USER_ATTRIBUTE5 | VARCHAR2 | (240) | Product Family User defined attribute | |
| PRDF_USER_ATTRIBUTE4 | VARCHAR2 | (240) | Product Family User defined attribute | |
| PRDF_USER_ATTRIBUTE3 | VARCHAR2 | (240) | Product Family User defined attribute | |
| PRDF_USER_ATTRIBUTE2 | VARCHAR2 | (240) | Product Family User defined attribute | |
| PRDF_USER_ATTRIBUTE1 | VARCHAR2 | (240) | Product Family User defined attribute | |
| PRDF_PROD_FAMILY_DP | VARCHAR2 | (240) | Not currently used | |
| PRDF_PROD_FAMILY_PK | VARCHAR2 | (320) | Unique identifier | |
| PRDF_PRODUCT_FAMILY | VARCHAR2 | (240) | Product family name | |
| PRDF_NAME | VARCHAR2 | (320) | Product family name | |
| PRDF_INSTANCE_CODE | VARCHAR2 | (40) | Instance code | |
| PRDF_DESCRIPTION | VARCHAR2 | (240) | Description | |
| ITEM_USER_ATTRIBUTE5 | VARCHAR2 | (240) | Item User defined attribute | |
| ITEM_USER_ATTRIBUTE4 | VARCHAR2 | (240) | Item User defined attribute | |
| ITEM_USER_ATTRIBUTE3 | VARCHAR2 | (240) | Item User defined attribute | |
| ITEM_USER_ATTRIBUTE2 | VARCHAR2 | (240) | Item User defined attribute | |
| ITEM_USER_ATTRIBUTE1 | VARCHAR2 | (240) | Item User defined attribute | |
| ITEM_ITEM_NUMBER_DP | VARCHAR2 | (240) | Not currently used | |
| ITEM_ONE_TIME_FLAG | VARCHAR2 | (10) | One time flag | |
| ITEM_NAME | VARCHAR2 | (320) | Item name | |
| ITEM_ITEM_NUMBER_PK | VARCHAR2 | (240) | Unique Identifier | |
| ITEM_ITEM_NAME | VARCHAR2 | (240) | Alternate Item Name | |
| ITEM_INSTANCE_CODE | VARCHAR2 | (40) | Instance code | |
| ITEM_DESCRIPTION | VARCHAR2 | (240) | Description | |
| IORG_ONE_TIME_FLAG | VARCHAR2 | (10) | Flag to signify if this item is recorded in the item master | |
| IORG_USER_ATTRIBUTE5 | VARCHAR2 | (240) | Item Organization User defined attribute | |
| IORG_USER_ATTRIBUTE4 | VARCHAR2 | (240) | Item Organization User defined attribute | |
| IORG_USER_ATTRIBUTE3 | VARCHAR2 | (240) | Item Organization User defined attribute | |
| IORG_USER_ATTRIBUTE2 | VARCHAR2 | (240) | Item Organization User defined attribute | |
| IORG_USER_ATTRIBUTE1 | VARCHAR2 | (240) | Item Organization User defined attribute | |
| IORG_UNORDERED_RCPT | VARCHAR2 | (20) | Flag indicating unordered receipts allowed | |
| IORG_TAXABLE_FLAG | VARCHAR2 | (20) | Flag indicating item is taxable | |
| IORG_TAX_CODE | VARCHAR2 | (80) | Tax code | |
| IORG_SUBSTITUTE_RCPT | VARCHAR2 | (20) | Substitute receipt | |
| IORG_STOCKABLE_FLAG | VARCHAR2 | (20) | Flag indicating item is stockable | |
| IORG_SHELF_LIFE_CODE | VARCHAR2 | (80) | Shelf life code | |
| IORG_SERIAL_CONTROL | VARCHAR2 | (80) | Serial number control code | |
| IORG_RFQ_REQUIRED_FLAG | VARCHAR2 | (20) | Flag indicating whether an RFQ (Request For Quotation) is required | |
| IORG_REVISION_CONTROL | VARCHAR2 | (80) | Revision control code | |
| IORG_ITEM_ORG_DP | VARCHAR2 | (240) | Not currently used | |
| IORG_RECEIPT_REQUIRED | VARCHAR2 | (20) | Flag indicating supplier receipt is required before payment | |
| IORG_PURCHASEABLE_FLAG | VARCHAR2 | (20) | Flag indicating item is purchasable | |
| IORG_PLANNER_FK | VARCHAR2 | (1000) | Foreign key to the planner level | |
| IORG_OUTSIDE_OP_FLAG | VARCHAR2 | (20) | Flag indicating item may appear on outside operation purchase order | |
| IORG_NAME | VARCHAR2 | (320) | Alternate organization item name | |
| IORG_MAKE_OR_BUY_FLAG | VARCHAR2 | (40) | Flag indicating whether item is manufactured or purchased | |
| IORG_MRP_PLN_METHOD | VARCHAR2 | (80) | MRP planning method | |
| IORG_LOT_CONTROL | VARCHAR2 | (80) | Lot control code | |
| IORG_LOCATOR_CONTROL | VARCHAR2 | (80) | Stock locator control code | |
| IORG_ITEM_ORG_PK | VARCHAR2 | (320) | Unique identifier | |
| IORG_ITEM_NUMBER | VARCHAR2 | (240) | Item number | |
| IORG_INV_PLANNING_CODE | VARCHAR2 | (40) | Inventory planning code | |
| IORG_INTERNAL_ORD_FLAG | VARCHAR2 | (20) | Flag indicating internally orderable item | |
| IORG_INSTANCE_CODE | VARCHAR2 | (40) | Instance code | |
| IORG_INSP_REQUIRED | VARCHAR2 | (40) | Flag indicating whether inspection is required upon receipt | |
| IORG_EXPRS_DELIVERY | VARCHAR2 | (20) | Flag indicating whether express delivery is required | |
| IORG_EFFECTIVITY_CONTROL | VARCHAR2 | (80) | Indicates whether item is unit or date controlled | |
| IORG_DESCRIPTION | VARCHAR2 | (240) | Description | |
| IORG_BUYER_FK | VARCHAR2 | (1000) | Foreign key to the buyer level | |
| IORG_APPROVED_SUPPLIER | VARCHAR2 | (20) | Approved Supplier | |
| IREV_USER_ATTRIBUTE5 | VARCHAR2 | (240) | Item Revision User defined attribute | |
| IREV_USER_ATTRIBUTE4 | VARCHAR2 | (240) | Item Revision User defined attribute | |
| IREV_USER_ATTRIBUTE3 | VARCHAR2 | (240) | Item Revision User defined attribute | |
| IREV_USER_ATTRIBUTE2 | VARCHAR2 | (240) | Item Revision User defined attribute | |
| IREV_USER_ATTRIBUTE1 | VARCHAR2 | (240) | Item Revision User defined attribute | |
| IREV_ITEM_REVISION_DP | VARCHAR2 | (240) | Not currently used | |
| IREV_NAME | VARCHAR2 | (320) | Item revision name | |
| IREV_LEVEL_NAME | VARCHAR2 | (25) | Level name | |
| IREV_ITEM_REVISION_PK | VARCHAR2 | (320) | Unique identifier | |
| IREV_ITEM_REVISION | VARCHAR2 | (240) | Item Revision | |
| IREV_INSTANCE_CODE | VARCHAR2 | (40) | Instance code | |
| IREV_EFFECTIVE_DATE | DATE | Date on which the item revision becomes effective | ||
| CREATION_DATE | DATE | Standard Who Column | ||
| LAST_UPDATE_DATE | DATE | Standard Who Column | ||
| IREV_CATEGORY_ID | NUMBER | (22) | Surrogate Key for Category | |
| IREV_CATEGORY_SET_ID | NUMBER | (22) | Surrogate Key for Category Set | |
| IREV_INVENTORY_ITEM_ID | NUMBER | (22) | Surrogate Key for Inventory Item | |
| IREV_ORGANIZATION_ID | NUMBER | (22) | Surrogate Key for Organization | |
| ITEM_TYPE | VARCHAR2 | (30) | Item Type |
Cut, paste (and edit) the following text to query this object:
SELECT CO15_CATEGORY_PK_KEY
, CO14_CATEGORY_PK_KEY
, CO13_CATEGORY_PK_KEY
, CO11_CATEGORY_PK_KEY
, CI310_CATEGORY_PK_KEY
, CI39_CATEGORY_PK_KEY
, CI38_CATEGORY_PK_KEY
, CI37_CATEGORY_PK_KEY
, CI36_CATEGORY_PK_KEY
, CI35_CATEGORY_PK_KEY
, CI34_CATEGORY_PK_KEY
, CI33_CATEGORY_PK_KEY
, CI32_CATEGORY_PK_KEY
, CI31_CATEGORY_PK_KEY
, CI26_CATEGORY_PK_KEY
, CI25_CATEGORY_PK_KEY
, CI24_CATEGORY_PK_KEY
, CI23_CATEGORY_PK_KEY
, CI22_CATEGORY_PK_KEY
, CI21_CATEGORY_PK_KEY
, CI16_CATEGORY_PK_KEY
, CI15_CATEGORY_PK_KEY
, CI14_CATEGORY_PK_KEY
, CI13_CATEGORY_PK_KEY
, CI12_CATEGORY_PK_KEY
, CI11_CATEGORY_PK_KEY
, CO12_CATEGORY_PK_KEY
, PLIN_INTEREST_TYPE_ID
, PLIN_PRODUCT_LINE_PK_KEY
, PCTG_PRIMARY_CODE_ID
, PCTG_PRODUCT_CATEG_PK_KEY
, PGRP_SECONDARY_CODE_ID
, PGRP_PRODUCT_GROUP_PK_KEY
, ALL_ALL_PK_KEY
, PRDF_PROD_FAMILY_PK_KEY
, ITEM_ITEM_NUMBER_PK_KEY
, IORG_UN_NUMBER_ID
, IORG_SHELF_LIFE_DAYS
, IORG_PRC_TOLERANCE_PCT
, IORG_MARKET_PRICE
, IORG_LIST_UNIT_PRICE
, IORG_HAZARD_CLASS_ID
, IORG_ITEM_ORG_PK_KEY
, IREV_ITEM_REVISION_PK_KEY
, CI39_USER_ATTRIBUTE5
, CI39_USER_ATTRIBUTE4
, CI39_USER_ATTRIBUTE3
, CI39_USER_ATTRIBUTE2
, CI39_USER_ATTRIBUTE1
, CI39_NAME
, CI39_INSTANCE_CODE
, CI39_DESCRIPTION
, CI39_CATEGORY_SET_NAME
, CI39_CATEGORY_PK
, CI39_CATEGORY_NAME
, CI39_CATEGORY_DP
, CI38_USER_ATTRIBUTE5
, CI38_USER_ATTRIBUTE4
, CI38_USER_ATTRIBUTE3
, CI38_USER_ATTRIBUTE2
, CI38_USER_ATTRIBUTE1
, CI38_NAME
, CI38_INSTANCE_CODE
, CI38_DESCRIPTION
, CI38_CATEGORY_SET_NAME
, CI38_CATEGORY_PK
, CI38_CATEGORY_NAME
, CI38_CATEGORY_DP
, CI37_USER_ATTRIBUTE5
, CI37_USER_ATTRIBUTE4
, CI37_USER_ATTRIBUTE3
, CI37_USER_ATTRIBUTE2
, CI37_USER_ATTRIBUTE1
, CI37_NAME
, CI37_INSTANCE_CODE
, CI37_DESCRIPTION
, CI37_CATEGORY_SET_NAME
, CI37_CATEGORY_PK
, CI37_CATEGORY_NAME
, CI37_CATEGORY_DP
, CI36_USER_ATTRIBUTE5
, CI36_USER_ATTRIBUTE4
, CI36_USER_ATTRIBUTE3
, CI36_USER_ATTRIBUTE2
, CI36_USER_ATTRIBUTE1
, CI36_NAME
, CI36_INSTANCE_CODE
, CI36_DESCRIPTION
, CI36_CATEGORY_SET_NAME
, CI36_CATEGORY_PK
, CI36_CATEGORY_NAME
, CI36_CATEGORY_DP
, CI35_USER_ATTRIBUTE5
, CI35_USER_ATTRIBUTE4
, CI35_USER_ATTRIBUTE3
, CI35_USER_ATTRIBUTE2
, CI35_USER_ATTRIBUTE1
, CI35_NAME
, CI35_INSTANCE_CODE
, CI35_DESCRIPTION
, CI35_CATEGORY_SET_NAME
, CI35_CATEGORY_PK
, CI35_CATEGORY_NAME
, CI35_CATEGORY_DP
, CI34_USER_ATTRIBUTE5
, CI34_USER_ATTRIBUTE4
, CI34_USER_ATTRIBUTE3
, CI34_USER_ATTRIBUTE2
, CI34_USER_ATTRIBUTE1
, CI34_NAME
, CI34_INSTANCE_CODE
, CI34_DESCRIPTION
, CI34_CATEGORY_SET_NAME
, CI34_CATEGORY_PK
, CI34_CATEGORY_NAME
, CI34_CATEGORY_DP
, CI33_USER_ATTRIBUTE5
, CI33_USER_ATTRIBUTE4
, CI33_USER_ATTRIBUTE3
, CI33_USER_ATTRIBUTE2
, CI33_USER_ATTRIBUTE1
, CI33_NAME
, CI33_INSTANCE_CODE
, CI33_DESCRIPTION
, CI33_CATEGORY_SET_NAME
, CI33_CATEGORY_PK
, CI33_CATEGORY_NAME
, CI33_CATEGORY_DP
, CI32_USER_ATTRIBUTE5
, CI32_USER_ATTRIBUTE4
, CI32_USER_ATTRIBUTE3
, CI32_USER_ATTRIBUTE2
, CI32_USER_ATTRIBUTE1
, CI32_NAME
, CI32_INSTANCE_CODE
, CI32_DESCRIPTION
, CI32_CATEGORY_SET_NAME
, CI32_CATEGORY_PK
, CI32_CATEGORY_NAME
, CI32_CATEGORY_DP
, CI310_USER_ATTRIBUTE5
, CI310_USER_ATTRIBUTE4
, CI310_USER_ATTRIBUTE3
, CI310_USER_ATTRIBUTE2
, CI310_USER_ATTRIBUTE1
, CI310_NAME
, CI310_INSTANCE_CODE
, CI310_DESCRIPTION
, CI310_CATEGORY_SET_NAME
, CI310_CATEGORY_PK
, CI310_CATEGORY_NAME
, CI310_CATEGORY_DP
, CI31_USER_ATTRIBUTE5
, CI31_USER_ATTRIBUTE4
, CI31_USER_ATTRIBUTE3
, CI31_USER_ATTRIBUTE2
, CI31_USER_ATTRIBUTE1
, CI31_NAME
, CI31_INSTANCE_CODE
, CI31_DESCRIPTION
, CI31_CATEGORY_SET_NAME
, CI31_CATEGORY_PK
, CI31_CATEGORY_NAME
, CI31_CATEGORY_DP
, CI26_USER_ATTRIBUTE5
, CI26_USER_ATTRIBUTE4
, CI26_USER_ATTRIBUTE3
, CI26_USER_ATTRIBUTE2
, CI26_USER_ATTRIBUTE1
, CI26_NAME
, CI26_INSTANCE_CODE
, CI26_DESCRIPTION
, CI26_CATEGORY_SET_NAME
, CI26_CATEGORY_PK
, CI26_CATEGORY_NAME
, CI26_CATEGORY_DP
, CI25_USER_ATTRIBUTE5
, CI25_USER_ATTRIBUTE4
, CI25_USER_ATTRIBUTE3
, CI25_USER_ATTRIBUTE2
, CI25_USER_ATTRIBUTE1
, CI25_NAME
, CI25_INSTANCE_CODE
, CI25_DESCRIPTION
, CI25_CATEGORY_SET_NAME
, CI25_CATEGORY_PK
, CI25_CATEGORY_NAME
, CI25_CATEGORY_DP
, CI24_USER_ATTRIBUTE5
, CI24_USER_ATTRIBUTE4
, CI24_USER_ATTRIBUTE3
, CI24_USER_ATTRIBUTE2
, CI24_USER_ATTRIBUTE1
, CI24_NAME
, CI24_INSTANCE_CODE
, CI24_DESCRIPTION
, CI24_CATEGORY_SET_NAME
, CI24_CATEGORY_PK
, CI24_CATEGORY_NAME
, CI24_CATEGORY_DP
, CI23_USER_ATTRIBUTE5
, CI23_USER_ATTRIBUTE4
, CI23_USER_ATTRIBUTE3
, CI23_USER_ATTRIBUTE2
, CI23_USER_ATTRIBUTE1
, CI23_NAME
, CI23_INSTANCE_CODE
, CI23_DESCRIPTION
, CI23_CATEGORY_SET_NAME
, CI23_CATEGORY_PK
, CI23_CATEGORY_NAME
, CI23_CATEGORY_DP
, CI22_USER_ATTRIBUTE5
, CI22_USER_ATTRIBUTE4
, CI22_USER_ATTRIBUTE3
, CI22_USER_ATTRIBUTE2
, CI22_USER_ATTRIBUTE1
, CI22_NAME
, CI22_INSTANCE_CODE
, CI22_DESCRIPTION
, CI22_CATEGORY_SET_NAME
, CI22_CATEGORY_PK
, CI22_CATEGORY_NAME
, CI22_CATEGORY_DP
, CI21_USER_ATTRIBUTE5
, CI21_USER_ATTRIBUTE4
, CI21_USER_ATTRIBUTE3
, CI21_USER_ATTRIBUTE2
, CI21_USER_ATTRIBUTE1
, CI21_NAME
, CI21_INSTANCE_CODE
, CI21_DESCRIPTION
, CI21_CATEGORY_SET_NAME
, CI21_CATEGORY_PK
, CI21_CATEGORY_NAME
, CI21_CATEGORY_DP
, CI16_USER_ATTRIBUTE5
, CI16_USER_ATTRIBUTE4
, CI16_USER_ATTRIBUTE3
, CI16_USER_ATTRIBUTE2
, CI16_USER_ATTRIBUTE1
, CI16_NAME
, CI16_INSTANCE_CODE
, CI16_DESCRIPTION
, CI16_CATEGORY_SET_NAME
, CI16_CATEGORY_PK
, CI16_CATEGORY_NAME
, CI16_CATEGORY_DP
, CI15_USER_ATTRIBUTE5
, CI15_USER_ATTRIBUTE4
, CI15_USER_ATTRIBUTE3
, CI15_USER_ATTRIBUTE2
, CI15_USER_ATTRIBUTE1
, CI15_NAME
, CI15_INSTANCE_CODE
, CI15_DESCRIPTION
, CI15_CATEGORY_SET_NAME
, CI15_CATEGORY_PK
, CI15_CATEGORY_NAME
, CI15_CATEGORY_DP
, CI14_USER_ATTRIBUTE5
, CI14_USER_ATTRIBUTE4
, CI14_USER_ATTRIBUTE3
, CI14_USER_ATTRIBUTE2
, CI14_USER_ATTRIBUTE1
, CI14_NAME
, CI14_INSTANCE_CODE
, CI14_DESCRIPTION
, CI14_CATEGORY_SET_NAME
, CI14_CATEGORY_PK
, CI14_CATEGORY_NAME
, CI14_CATEGORY_DP
, CI13_USER_ATTRIBUTE5
, CI13_USER_ATTRIBUTE4
, CI13_USER_ATTRIBUTE3
, CI13_USER_ATTRIBUTE2
, CI13_USER_ATTRIBUTE1
, CI13_NAME
, CI13_INSTANCE_CODE
, CI13_DESCRIPTION
, CI13_CATEGORY_SET_NAME
, CI13_CATEGORY_PK
, CI13_CATEGORY_NAME
, CI13_CATEGORY_DP
, CI12_USER_ATTRIBUTE5
, CO11_USER_ATTRIBUTE5
, CO11_CATEGORY_PK
, CO11_USER_ATTRIBUTE4
, CO11_INSTANCE_CODE
, CO11_NAME
, CO11_DESCRIPTION
, CO11_CATEGORY_SET_NAME
, CO11_USER_ATTRIBUTE2
, CO11_CATEGORY_DP
, CO11_USER_ATTRIBUTE3
, CO11_USER_ATTRIBUTE1
, CO11_CATEGORY_NAME
, CO16_CATEGORY_PK_KEY
, CO12_CATEGORY_PK
, IORG_SEGMENT1
, CO15_NAME
, CO15_CATEGORY_SET_NAME
, CO14_CATEGORY_DP
, CO14_USER_ATTRIBUTE1
, CO14_CATEGORY_NAME
, CO14_USER_ATTRIBUTE2
, CO13_CATEGORY_PK
, CO13_USER_ATTRIBUTE4
, CO13_INSTANCE_CODE
, CO16_CATEGORY_DP
, CO16_USER_ATTRIBUTE1
, CO16_CATEGORY_NAME
, CO16_USER_ATTRIBUTE2
, CO16_USER_ATTRIBUTE3
, CO16_DESCRIPTION
, CO16_USER_ATTRIBUTE5
, CO16_CATEGORY_PK
, CO16_USER_ATTRIBUTE4
, CO16_INSTANCE_CODE
, CO16_NAME
, CO15_CATEGORY_DP
, CO15_USER_ATTRIBUTE1
, CO15_CATEGORY_NAME
, CO15_USER_ATTRIBUTE2
, CO15_USER_ATTRIBUTE3
, CO15_DESCRIPTION
, CO15_USER_ATTRIBUTE5
, CO15_CATEGORY_PK
, CO15_USER_ATTRIBUTE4
, CO15_INSTANCE_CODE
, CO14_USER_ATTRIBUTE3
, CO14_CATEGORY_SET_NAME
, CO14_USER_ATTRIBUTE5
, CO12_USER_ATTRIBUTE2
, CO12_CATEGORY_DP
, CO12_USER_ATTRIBUTE1
, CO12_CATEGORY_NAME
, CO12_USER_ATTRIBUTE3
, CO12_USER_ATTRIBUTE4
, CO12_INSTANCE_CODE
, CO12_NAME
, CO12_DESCRIPTION
, CO12_CATEGORY_SET_NAME
, CO13_USER_ATTRIBUTE1
, CO13_USER_ATTRIBUTE3
, CO13_USER_ATTRIBUTE5
, CO12_USER_ATTRIBUTE5
, CO13_NAME
, CO13_DESCRIPTION
, CO13_CATEGORY_NAME
, CO13_USER_ATTRIBUTE2
, CO13_CATEGORY_DP
, CO13_CATEGORY_SET_NAME
, CO14_CATEGORY_PK
, CO14_USER_ATTRIBUTE4
, CO14_INSTANCE_CODE
, CO14_NAME
, CO14_DESCRIPTION
, CI11_INSTANCE_CODE
, CI11_DESCRIPTION
, CI11_CATEGORY_SET_NAME
, CI11_CATEGORY_PK
, CI11_CATEGORY_NAME
, CI11_CATEGORY_DP
, CI12_INSTANCE_CODE
, CI12_DESCRIPTION
, CI12_CATEGORY_SET_NAME
, CI12_CATEGORY_PK
, CI12_CATEGORY_NAME
, CI12_CATEGORY_DP
, CI11_USER_ATTRIBUTE5
, CO16_CATEGORY_SET_NAME
, CI11_USER_ATTRIBUTE4
, CI11_USER_ATTRIBUTE3
, CI11_USER_ATTRIBUTE2
, CI11_USER_ATTRIBUTE1
, CI11_NAME
, CI12_USER_ATTRIBUTE4
, CI12_USER_ATTRIBUTE3
, CI12_USER_ATTRIBUTE2
, CI12_USER_ATTRIBUTE1
, CI12_NAME
, PLIN_USER_ATTRIBUTE5
, PLIN_USER_ATTRIBUTE4
, PLIN_USER_ATTRIBUTE3
, PLIN_USER_ATTRIBUTE2
, PLIN_USER_ATTRIBUTE1
, PLIN_PRODUCT_LINE_DP
, PLIN_PRODUCT_LINE_PK
, PLIN_NAME
, PLIN_INSTANCE_CODE
, PLIN_ENABLED_FLAG
, PLIN_DESCRIPTION
, PCTG_USER_ATTRIBUTE5
, PCTG_USER_ATTRIBUTE4
, PCTG_USER_ATTRIBUTE3
, PCTG_USER_ATTRIBUTE2
, PCTG_USER_ATTRIBUTE1
, PCTG_PRODUCT_CATEG_DP
, PCTG_PRODUCT_CATEG_PK
, PCTG_NAME
, PCTG_INSTANCE_CODE
, PCTG_ENABLED_FLAG
, PCTG_DESCRIPTION
, PGRP_USER_ATTRIBUTE5
, PGRP_USER_ATTRIBUTE4
, PGRP_USER_ATTRIBUTE3
, PGRP_USER_ATTRIBUTE2
, PGRP_USER_ATTRIBUTE1
, PGRP_PRODUCT_GROUP_DP
, PGRP_PRODUCT_GROUP_PK
, PGRP_NAME
, PGRP_INSTANCE_CODE
, PGRP_ENABLED_FLAG
, PGRP_DESCRIPTION
, ALL_NAME
, ALL_ALL_PK
, PRDF_USER_ATTRIBUTE5
, PRDF_USER_ATTRIBUTE4
, PRDF_USER_ATTRIBUTE3
, PRDF_USER_ATTRIBUTE2
, PRDF_USER_ATTRIBUTE1
, PRDF_PROD_FAMILY_DP
, PRDF_PROD_FAMILY_PK
, PRDF_PRODUCT_FAMILY
, PRDF_NAME
, PRDF_INSTANCE_CODE
, PRDF_DESCRIPTION
, ITEM_USER_ATTRIBUTE5
, ITEM_USER_ATTRIBUTE4
, ITEM_USER_ATTRIBUTE3
, ITEM_USER_ATTRIBUTE2
, ITEM_USER_ATTRIBUTE1
, ITEM_ITEM_NUMBER_DP
, ITEM_ONE_TIME_FLAG
, ITEM_NAME
, ITEM_ITEM_NUMBER_PK
, ITEM_ITEM_NAME
, ITEM_INSTANCE_CODE
, ITEM_DESCRIPTION
, IORG_ONE_TIME_FLAG
, IORG_USER_ATTRIBUTE5
, IORG_USER_ATTRIBUTE4
, IORG_USER_ATTRIBUTE3
, IORG_USER_ATTRIBUTE2
, IORG_USER_ATTRIBUTE1
, IORG_UNORDERED_RCPT
, IORG_TAXABLE_FLAG
, IORG_TAX_CODE
, IORG_SUBSTITUTE_RCPT
, IORG_STOCKABLE_FLAG
, IORG_SHELF_LIFE_CODE
, IORG_SERIAL_CONTROL
, IORG_RFQ_REQUIRED_FLAG
, IORG_REVISION_CONTROL
, IORG_ITEM_ORG_DP
, IORG_RECEIPT_REQUIRED
, IORG_PURCHASEABLE_FLAG
, IORG_PLANNER_FK
, IORG_OUTSIDE_OP_FLAG
, IORG_NAME
, IORG_MAKE_OR_BUY_FLAG
, IORG_MRP_PLN_METHOD
, IORG_LOT_CONTROL
, IORG_LOCATOR_CONTROL
, IORG_ITEM_ORG_PK
, IORG_ITEM_NUMBER
, IORG_INV_PLANNING_CODE
, IORG_INTERNAL_ORD_FLAG
, IORG_INSTANCE_CODE
, IORG_INSP_REQUIRED
, IORG_EXPRS_DELIVERY
, IORG_EFFECTIVITY_CONTROL
, IORG_DESCRIPTION
, IORG_BUYER_FK
, IORG_APPROVED_SUPPLIER
, IREV_USER_ATTRIBUTE5
, IREV_USER_ATTRIBUTE4
, IREV_USER_ATTRIBUTE3
, IREV_USER_ATTRIBUTE2
, IREV_USER_ATTRIBUTE1
, IREV_ITEM_REVISION_DP
, IREV_NAME
, IREV_LEVEL_NAME
, IREV_ITEM_REVISION_PK
, IREV_ITEM_REVISION
, IREV_INSTANCE_CODE
, IREV_EFFECTIVE_DATE
, CREATION_DATE
, LAST_UPDATE_DATE
, IREV_CATEGORY_ID
, IREV_CATEGORY_SET_ID
, IREV_INVENTORY_ITEM_ID
, IREV_ORGANIZATION_ID
, ITEM_TYPE
FROM ENI.EDW_ITEMS_M;
ENI.EDW_ITEMS_M does not reference any database object
ENI.EDW_ITEMS_M is referenced by following:
APPS
EDW_ITEMS_M
|
|
|
|