Works from CSV or workbook exports produced from SAP, IBM Maximo, Oracle ERP, Hexagon EAM, Infor, and other ERP, EAM, or CMMS systems. No direct integration or write-back is required — Review data requirements →
Industrial IQ documentation

Column Mapping Guide

Column Mapping Guide documentation for AI2COE Industrial IQ buyers, operators, data owners, executives, and governance teams.

Run Free Industrial IQ SnapshotRequired Data by EngineDocs Home
8Engines
18Industry guides
0ERP write-back
AI adoption maturity roadmap showing discovery, diagnostics, governance, pilot prioritization, and enterprise scaling stages.
Documentation explains how exported data becomes evidence, reports, actions, and recurring score history.
Task overview

Column Mapping Guide

Understand how AI-assisted field matching uses aliases, required fields, optional fields, completeness, confidence, and user confirmation.

This guide explains the operating task, source data needed, validation steps, output interpretation, trust boundary, and where to go next.

UploadCSV export or sample dataset
Source FitRequired fields and data quality
AI MatchColumn aliases and confidence
NormalizeCanonical field preparation
DiagnoseEngine logic and evidence
ReportScore, actions, assumptions
RepeatScore history and renewal value
Task directory

Start with the operating task.

Prepare exported data, map required fields, understand diagnostic outputs, review trust controls, and troubleshoot an Industrial IQ run.

Documentation task Prepare exported data

Check engine-specific required fields, sample datasets, mapping templates, and source-fit rules before upload.

 Documentation task Map required fields

Resolve aliases, required-field coverage, source context, and limitations before a diagnostic run.

 Documentation task Understand diagnostic outputs

Read evidence rows, confidence tiers, score interpretation, assumptions, limitations, and owner actions.

 Documentation task Review trust controls

Validate no ERP write-back, source-file purge, human review, data handling, and report ownership.

 Documentation task Troubleshoot a run

Use the user manual, field guidance, and support path when mapping, source fit, or output review needs attention.

Engine-specific required fields

Each Industrial IQ engine needs a different source-file shape.

The minimum fields let the diagnostic run. The best-upload context improves source-fit, confidence, report completeness, and owner review quality.

Catalog Intelligence

PartsCleanse AI

Primary fileMaterial or item master CSV
Minimum uploadDescription
Engine-specific context addsMaterial Id, Manufacturer, Mpn, Supplier, Uom
Download mapping template
Inventory Risk Intelligence

InventoryMind AI

Primary fileInventory balance CSV
Minimum uploadMaterial Id, Quantity
Engine-specific context addsDescription, Unit Cost, Stock Value, Last Movement Date, Movement Qty
Download mapping template
Procurement Leakage Intelligence

ProcureMind AI

Primary filePurchase order CSV
Minimum uploadPo Number, Description
Engine-specific context addsMaterial Id, Supplier, Unit Price, Quantity, Order Date
Download mapping template
Working Capital Intelligence

FinanceMind AI

Primary fileInventory value file
Minimum uploadMaterial Id, Stock Value
Engine-specific context addsDescription, Quantity, Unit Cost, Duplicate Family, Carrying Cost Rate
Download mapping template
Required data by engine

Use this table before upload.

EngineRequired Data FileRequired FieldsOptional FieldsOutput GeneratedMinimum Viable UploadEngine-Specific Context
PartsCleanse AI Material or item master CSV Description Material Id, Manufacturer, Mpn, Supplier, Uom, Quantity, Unit Cost, Site Catalog health score, evidence, report, actions, score history Description Material Id, Manufacturer, Mpn, Supplier, Uom, Quantity, Unit Cost, Site
InventoryMind AI Inventory balance CSV Material Id, Quantity Description, Unit Cost, Stock Value, Last Movement Date, Movement Qty, Demand, Criticality, Min Stock Inventory health score, evidence, report, actions, score history Material Id, Quantity Description, Unit Cost, Stock Value, Last Movement Date, Movement Qty, Demand, Criticality, Min Stock
ProcureMind AI Purchase order CSV Po Number, Description Material Id, Supplier, Unit Price, Quantity, Order Date, Order Type, Emergency Flag, Stock On Hand Procurement leakage score, evidence, report, actions, score history Po Number, Description Material Id, Supplier, Unit Price, Quantity, Order Date, Order Type, Emergency Flag, Stock On Hand
FinanceMind AI Inventory value file Material Id, Stock Value Description, Quantity, Unit Cost, Duplicate Family, Carrying Cost Rate, Emergency Premium, Site, Currency Working capital score, evidence, report, actions, score history Material Id, Stock Value Description, Quantity, Unit Cost, Duplicate Family, Carrying Cost Rate, Emergency Premium, Site, Currency
Accepted CSV format

Prepare clean exports before upload.

Use UTF-8 CSV with one header row, one operational record per row, stable identifiers, ISO-style dates where available, numeric values without currency symbols, and separate columns for site, supplier, asset, quantity, value, and owner context.

Common errors: merged header rows, hidden subtotal rows, mixed currencies in one value column, duplicate column names, free-text dates, missing material or asset identifiers, and supplier names embedded inside descriptions.

If fields are missing: Industrial IQ still profiles source fit, but unmapped required fields reduce the AI Match Score, Mapping Readiness Score, diagnostic confidence, and report completeness until the user normalizes the data.

Sample row examples

Minimum viable row patterns.

  • Catalog Intelligence: Description: 6205-2RS bearing sealed SKF
  • Inventory Risk Intelligence: Material Id: MAT-100245 | Quantity: 42
  • Procurement Leakage Intelligence: Po Number: PO_NUMBER | Description: 6205-2RS bearing sealed SKF
  • Working Capital Intelligence: Material Id: MAT-100245 | Stock Value: 1850.00
Related engines

Which diagnostic should the buyer run next?

Related engine

PartsCleanse AI

MRO catalog deduplication, field quality, UOM consistency, and duplicate capital exposure.

Open documentation
Related engine

InventoryMind AI

Dead stock, slow-moving stock, excess, stockout risk, and duplicated stock exposure.

Open documentation
Related engine

ProcureMind AI

Emergency procurement, stocked-but-purchased events, repeated buys, supplier alias risk, and price variance.

Open documentation
Related engine

FinanceMind AI

Duplicate capital exposure, carrying cost, emergency premium, and recoverable value scenarios.

Open documentation
Report anatomy

What the buyer can share internally.

Industrial IQ reports include scope, source-fit score, AI match score, mapping readiness, diagnostic confidence, score components, evidence records, assumptions, limitations, review requirements, action items, and recurring score history.

Column Mapping GuideValue lever
Uploaded dataCustomer-specific diagnostic required
FinanceMind AIRelated diagnostic engine
EstimateAssumption-labeled until reviewed
Benchmark assumptionUploaded evidenceConfidence tierHuman reviewReportable value
Documentation context

Use the docs to move from source export to reviewed diagnostic evidence.

Each guide keeps Industrial IQ documentation tied to source preparation, validation, evidence review, and Trust controls.

Docs home
Prepare export Use approved CSV/workbook exports or governed sample data. Map fields Confirm required fields, aliases, source fit, and limitations. Review evidence Inspect findings, confidence tiers, assumptions, and owner actions. Trust controls No ERP write-back, source-file purge after report generation, and human review before action.
AI2COE Copilot