- Raw: a near 1:1 replica of each ION entity, with internal system columns removed. This is the “straight data” closest to what you see in the ION app.
- Cleaned: the same entities with First Resonance data cleanup and business logic applied (still one row per entity), suffixed
_enriched. - Computed: curated, performance-optimized Data Products with calculations and aggregations maintained by the ION Analytics team.
Table and column names are case-insensitive unless quoted. Names are shown here in lowercase for readability.The exact set of raw tables available to your organization depends on which ION features you use, so you’ll only see views for entities that exist in your schema. The list below is the full ION entity catalog. Customers on GovCloud also have column masking policies applied to certain fields.
Raw tables
A raw view is published for essentially every ION entity in your schema. Internal system tables and change-tracking columns are excluded.Attribute tables (suffixed
_attributes_base) store one row per record and attribute key. When you join one to its parent record, join on both the record ID and the key, otherwise you get a row per attribute and your results fan out.Parts & inventory
parts · part_attributes_base · parts_inventory · parts_inventories_attributes_base · part_inventory_history · part_inventory_build_requirements · parts_inventory_rolled_up_costs · part_procedures · supplier_parts
Kits
parts_kits · part_kit_attributes_base · part_kit_items · part_kit_item_attributes_base · part_kit_inventories
BOM & builds
mboms · mboms_attributes_base · mbom_item · mbom_substitute · abom_installations · build_requirements
Runs, procedures & steps
runs · runs_attributes_base · run_batches · run_steps · run_steps_attributes_base · run_steps_fields · run_steps_dags · run_step_part_inventories · run_step_sessions · procedures · procedures_attributes_base · steps · steps_attributes_base · steps_fields
Planning & MRP
plans · plans_attributes_base · plan_items · plan_inputs · plan_item_allocations · plan_item_results · plan_plan_items · mrp_jobs
Purchasing & receiving
purchase_orders · purchase_orders_attributes_base · purchase_order_lines · purchase_order_lines_attributes_base · purchase_order_line_inventories · purchase_order_approval_requests · receipts · receipts_attributes_base · receipt_items · suppliers · suppliers_attributes_base
Quality: issues, further actions, redlines & approvals
issues · issues_attributes_base · issue_approval_requests · issue_approvals · issue_disposition_types · issue_part_inventories · issue_relations · further_actions · further_actions_attributes_base · further_action_approval_requests · further_action_approval_roles · further_action_approvals · further_action_issues · further_action_parts · further_action_runs · redlines · redline_approval_requests · review_requests · step_approval_requests
Locations
locations · locations_attributes_base
Organization, users & access
organizations · users · user_roles · roles · teams · team_roles · team_users
Datagrids
datagrid_columns · datagrid_rows · datagrid_values
Files, labels, comments & entities
file_attachments · entities_file_attachments · labels · entities_labels · comments · entities · model_tables
Barcodes
barcode_labels · barcode_templates
Webhooks
webhook_receivers · webhook_subscriptions
Cleaned tables
The same entities as above with data cleanup and business logic applied. Each is suffixed_enriched and retains entity-level grain (one row per entity).
barcode_labels_enriched · barcode_templates_enriched · datagrid_columns_enriched · datagrid_rows_enriched · datagrid_values_enriched · file_attachments_enriched · further_actions_attributes_base_enriched · issue_approval_requests_enriched · issues_attributes_base_enriched · issues_enriched · locations_attributes_base_enriched · locations_enriched · mbom_item_enriched · mbom_substitute_enriched · mboms_attributes_base_enriched · mboms_enriched · mrp_jobs_enriched · organizations_enriched · part_attributes_base_enriched · part_kit_attributes_base_enriched · part_kit_item_attributes_base_enriched · part_kit_items_enriched · parts_enriched · parts_inventories_attributes_base_enriched · parts_inventory_enriched · parts_kits_enriched · plan_items_enriched · plans_attributes_base_enriched · plans_enriched · procedures_attributes_base_enriched · procedures_enriched · purchase_order_approval_requests_enriched · purchase_order_line_inventories_enriched · purchase_order_lines_attributes_base_enriched · purchase_order_lines_enriched · purchase_orders_attributes_base_enriched · purchase_orders_enriched · receipts_attributes_base_enriched · receipts_enriched · redline_approval_requests_enriched · redlines_enriched · review_requests_enriched · roles_enriched · run_batches_enriched · run_steps_attributes_base_enriched · run_steps_fields_enriched · run_steps_enriched · runs_attributes_base_enriched · runs_enriched · step_approval_requests_enriched · steps_attributes_base_enriched · steps_fields_enriched · steps_enriched · suppliers_attributes_base_enriched · suppliers_enriched · teams_enriched · users_enriched · webhook_receivers_enriched · webhook_subscriptions_enriched