Item detail template reference

Edit online

This reference provides field definitions, data types, defaults, and constraints for importing item details into the IBM® Maximo Inventory Optimization Essentials application.

General guidelines

  • This template is used to import new items in Maximo Inventory Optimization Essentials.
  • All mandatory fields must be populated. If a field is not used in ERP/EAM system, you can leave it blank.
  • Column headers in your import file must match exactly with the field names used in Maximo Inventory Optimization Essentials.
  • If a field is missing or has invalid data, the system assigns a default value if available.
  • Date format: YYYY-MM-DD
  • Usage data must be labeled as: YYYY-MM usage for example, 2025-04 usage) and must be for a completed month only.
  • Only new items can be created with this import. Updates must be done using the Bulk edit from file feature.
  • To achieve the best results, fill in all template fields, not just the required ones.
  • Any additional fields available through Maximo Inventory Optimization Essentials can also be included during the item detail import.
  • You can import up to 5 years of usage data. For meaningful insights, at least 24 months of data is recommended.

Item detail field definitions

Field name Type Size Default Mandatory
Organization Character 12 - Yes
Site Character 8 - Yes
Store Character 50 - Yes
Condition code Character 10 - Yes
Planning area Character 20 - Yes
Item number Character 18 - Yes
Stock on Hand Integer - - Yes
Date created Date - 1960-01-01 Yes
Average unit price Money - 0.01 Yes
Avg vendor lead time Numeric - 999 Yes
Average issue size Integer - 1 Yes
Host ROP Integer - - No
Host EOQ/Max Integer - - No
UOM Character 4 - No
Business impact Character - D No
Likelihood Character - R No
Review lead time Integer - 1 No
Delivery lead time Integer - 0 No
Set size Integer - 1 No
Short description Character 80 - No
Description line 2 Character 80 - No
Vendor number Character 6 - No
yyyy-mm usage Integer - 0 No

Field definitions

Host ROP
The customer's current reorder point.
Host EOQ/Max
The reorder quantity (EOQ or MAX), based on the client's stocking strategy.
UOM
Unit of Measure or Unit of Issue, for example, each.
Business impact
Risk of the item to business operations. Options: A, B, C, D, or E.
Likelihood (Workaround type)
  • W = Wear out
  • E = Emergency resupply
  • R = Temporary repair
  • S = Substitute equipment
  • N = None