Data Dictionary
Every table, column, key and relationship — searchable.
An interactive reference for the whole standard Ross ERP 8.0 schema (FIN + MAN). Column descriptions, valid-value lists and foreign keys come from the GEMBASE application dictionary; additional relationships are inferred from shared key columns.
- Every table, view and procedure — searchable, filterable by type, class, module, DB
- Per-column: type, nullability, PK / identity / computed badges, description, valid values, FKs
- Foreign keys in and out, plus inferred related tables (shared-key)
- ER "neighborhood" diagram for each table
- Field-level lineage — where a column is read and written across the schema — plus seed-data decodes (code → meaning) right in the column drawer
- One-click exports: CSV and JSON per table; copy SELECT and CREATE TABLE (DDL)
- Insights: module coupling, most-depended-on tables, schema-wide stats
- Keyboard-driven (
/search,?help), deep-linkable —dd.rossdata.dev/#GL_ACCOUNTS
Search or filter to an object → open it → read its columns, keys and relationships → export or copy what you need → jump to the same object in the Knowledge Graph.
Open the Data DictionaryKnowledge Graph
See the schema as a living map you can explore.
The same schema rendered as an interactive graph — objects as nodes, relationships and code references as edges — so you can see the structure the dictionary lists in tables.
- Force-directed map of the schema + code layer, grouped into modules and communities
- Path-finding between any two objects — "how does A reach B?"
- Hub / most-connected detection; filter by object type
- Deep-linkable focus on any node; one-click jump to the Data Dictionary entry
Start from a module or search a node → follow edges to see what connects → find the path between two objects → click through to the Dictionary for the detail.
Explore the Knowledge GraphFacility Explorer
Browse the application from the user's side: every facility — screen, report or program — in the standard Ross ERP 8.0 client menu, searchable by facility code, name and module, each with the full menu path that reaches it. 2,327 facilities across FIN + MAN. Deep-linkable — toc.rossdata.dev/#AP_M_011.
Program Explorer
Browse the standard Ross ERP 8.0 program catalog — every program by module, type and declared title, each cross-linked to the exact Data Dictionary tables it references. 3,327 programs across 22 modules, 24,363 program→table links. Metadata only — no source. Deep-linkable — pg.rossdata.dev/#ap_a_check_register.
Web Services
Browse the standard Ross ERP 8.0 SOAP / Connect web services — every RS_* service with its typed parameters and full request / response field lists, each built from real Data Dictionary columns. 233 web services across 10 systems. Deep-linkable — rs.rossdata.dev/#rs_add_customer.
Programmatic access
The same dataset — straight into your tools and scripts.REST API
LiveA REST / JSON API for the Data Dictionary — the same structured data the site exports, programmatically. Fetch a table's full schema as JSON, look up any column, search objects, get DDL. Public, read-only, CORS-open — no key required.
MCP server
LiveOne MCP server that connects agents and tools directly to this dataset — the Dictionary (look up tables, columns, DDL), the Knowledge Graph (traverse relationships, find paths), the application layer (find a screen, or ask which facilities touch a table) and the program catalog (browse programs, or ask which programs reference a table). Point any MCP client at the endpoint:
schema_stats
list_objects
find_column
lookup_table
search_columns
search_all
get_ddl
graph_neighbors
path_between
facility_stats
list_facilities
search_facilities
lookup_facility
table_facilities
facility_programs
program_stats
list_programs
search_programs
lookup_program
table_programs
program_facilities
Ask Ross
Coming soonPlain-English answers about the Ross ERP 8.0 data model. Ask a question and get the exact tables, columns, keys and relationships that answer it — with links straight into the Dictionary and the Graph. The whole schema, made conversational.