Available tables - ION Manual

Data Connector Overview

The Data Connector exposes your organization’s data as a set of read-only views. These views come in three tiers, listed in full below:

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

Computed tables

The computed tier is a set of curated, pre-joined, and aggregated datasets maintained by the ION Analytics team. For the full list with descriptions and grain, see Data Products.