Item
An item can be both product and material, although not in the same product structure. As a product, the item is made up of other items (material). As a material, the item is included in other items (products).
The Item dimension contains all items defined in MITMAS, MITMAH and SITCOM. Names and descriptions of codes are retrieved from CSYTAB.
Additional style information is also available in the Item dimension. This is retrieved from the Style Info table, MMODMA.
This dimension supports the use of Extensibility Dimension in the M3 Analytics model extension space. See Model Extension details in Infor M3 Analytics for M3 CloudSuites Administration Guide for more information.
The attributes listed in the table are part of the custom subject area. M3 Analytics contains more attributes in the default subject area. For a complete list, see the mapping document in KB 2015457.
| Hierarchy | Custom subject area | Attributes |
|---|---|---|
| Item |
M3A Finance M3A Procurement M3A Production M3A Sales M3A Warehouse |
Active Season ID Attribute X, Attribute Y, Attribute Z Basic Unit of Measure Business Area, Business Area Description, Business Area ID, Business Area Name Collection ID Color Division ID Environment Group, Environment Group Description, Environment Group ID, Environment Group Name Gender Code Group Technology Class, Group Technology Class Description, Group Technology Class ID, Group Technology Class Name Item, Item Category, Item Category ID Item Description Item Group, Item Group Description, Item Group ID, Item Group Name Item Hierarchy 1, Item Hierarchy 1 ID, Item Hierarchy 2, Item Hierarchy 2 ID, Item Hierarchy 3, Item Hierarchy 3 ID, Item Hierarchy 4, Item Hierarchy 4 ID, Item Hierarchy 5, Item Hierarchy 5 ID Item Name Item Number Item Type, Item Type Description, Item Type ID, Item Type Name, Item w/ Basic UM Make/Buy Product Group, Product Group Description, Product Group ID, Product Group Name Procurement Group, Procurement Group Description, Procurement Group ID, Procurement Group Name Quality Group Responsible, Responsible ID, Responsible Name |
Drill map
This table shows the drill map for Item:
| Name | Drill From Column | Drill To Column |
|---|---|---|
| M3A Item – Attribute X | Attribute X | Item |
| M3A Item – Attribute Y | Attribute Y | Item |
| M3A Item – Attribute Z | Attribute Z | Item |
| M3A Item – Color | Color | Item |
| M3A Item – Item Hierarchy | Item Hierarchy 1 | Item Hierarchy 2 |
| Item Hierarchy 2 | Item Hierarchy 3 | |
| Item Hierarchy 3 | Item Hierarchy 4 | |
| Item Hierarchy 4 | Item Hierarchy 5 | |
| Item Hierarchy 5 | Item | |
| M3A Item – Standard | Item Type | Business Area |
| Business Area | Product Group | |
| Product Group | Item Group | |
| Item Group | Item | |
| M3A Item – Style | Style | Item |