Ross ERP Data Dictionary

Tools

• facility_programs

  Cross-link a UI facility to the program(s) that implement it — 'what code runs this screen?'. Each program carries a match label: declared (named by the facility's menu entry, authoritative) or titleId (TITLE id equals the facility code). Complements lookup_facility (which gives the facility's tables and call graph). Metadata only — no source body.

  Measured 19 hr ago

• facility_stats

  Overview of the Ross ERP 8.0 application layer — the client menu tree of UI facilities (screens, reports, inquiries, maintenance functions): total facilities, and their breakdown by system (e.g. ACCOUNTS_PAYABLE), database (FIN/MAN) and class (REPORT, MAINTENANCE, INQUIRY, ...). Use this first to orient before browsing facilities.

  Measured 19 hr ago

• find_column

  Look up a single column by exact name across the whole Ross ERP 8.0 schema: its description, valid values, notes, every table that carries it, and any foreign-key roles it plays.

  Measured 19 hr ago

• get_ddl

  Return the CREATE TABLE (DDL) for a Ross ERP 8.0 table, with column descriptions as comments plus primary-key and foreign-key constraints.

  Measured 19 hr ago

• graph_neighbors

  List the knowledge-graph neighbours of an object — the programs, tables, views and procedures directly connected to it, with relationship type and direction.

  Measured 19 hr ago

• list_facilities

  Browse and filter Ross ERP 8.0 UI facilities (menu screens/functions). Filter by system, database, class, a name/code substring, or withTables (only facilities whose table cluster is known); paginate with limit/offset. Returns summaries — use lookup_facility for full detail.

  Measured 19 hr ago

• list_objects

  Browse and filter Ross ERP 8.0 objects (tables / views / procedures / functions). Filter by type, database, module, or a name substring; paginate with limit/offset. Returns object summaries — use lookup_table for full detail.

  Measured 19 hr ago

• list_programs

  Browse and filter Ross ERP 8.0 programs (application source, metadata only). Filter by module (ap, gl, ic, sop, ...), type (a=archive, i=inquiry, m=maintenance, r=report, s=server, l=load, u=utility, ...), layer (base | vendor-core), titled (only programs that declare a TITLE id), or a substring of basename/title; paginate with limit/offset. Returns summaries — use lookup_program for full detail.

  Measured 19 hr ago

• lookup_facility

  Full detail for one Ross ERP 8.0 UI facility by code: its name, system, database, class, GEMBASE program, help text, menu paths, the physical table cluster it touches — core (the working set the screen is built on) and reference (control/lookup tables) — and its call graph: the facilities this one invokes (calls) and the facilities that invoke it (calledBy), parsed from the program source.

  Measured 19 hr ago

• lookup_program

  Full detail for one Ross ERP 8.0 program, by TITLE program-id (e.g. AP_A_002) or source basename (e.g. ap_a_check_register): its module, type, layer, declared title, internal PROCEDURE_FORM procedures, the Data Dictionary tables it references — each classified read vs read-write (a write is a FIND IN.../LOCK=WRITE update, an ADD, or a DELETE) with a writeCount — its call graph (the programs it invokes and the programs that invoke it, from PERFORM "GEM<mod>:<prog>"), the menu facilities it backs, and — for programs with no TITLE label — a display name carried from the menu facility's registry description. Metadata only — no source body.

  Measured 19 hr ago

• lookup_table

  Full schema for a Ross ERP 8.0 object (table / view / procedure / function): columns with type, nullability, keys, descriptions and valid values, foreign keys in and out, related tables, and usage.

  Measured 19 hr ago

• path_between

  Find the shortest path between two objects in the Ross ERP 8.0 knowledge graph (how A reaches B through calls / references / accesses).

  Measured 19 hr ago

• program_facilities

  Reverse of facility_programs: which UI facilities (menu screens / reports / inquiries) a program backs — 'what screens does this program run?'. One program often serves several facilities. Lookup by TITLE id (e.g. AP_I_001) or basename (e.g. ap_i_vendors); each facility carries the same declared / titleId match label.

  Measured 19 hr ago

• program_stats

  Overview of the Ross ERP 8.0 program catalog — every application-source program (metadata only, no source body): total programs, how many declare a TITLE id, how many carry Data Dictionary table links, total program→table edges, read/write counts (withWrites programs, writeEdges program→table write edges), base vs vendor-core split, program→program call-graph counts (programs with outbound calls, total call edges) and how many back a menu facility, plus the module and type breakdowns. Use this first to orient before browsing programs.

  Measured 19 hr ago

• schema_stats

  Overview of the Ross ERP 8.0 schema in one call: object counts by type, module list, total/distinct columns, audit-twin pairs, and the top tables/columns/modules. Use this first to orient before drilling in.

  Measured 19 hr ago

• search_all

  Cross-domain search in one call — spans schema objects, columns, UI facilities and programs at once. Use this when you don't yet know which layer a term lives in (e.g. 'check register' is a screen, a program and a table). Scope to one layer with type = object | column | facility | program (default all); limit is per domain.

  Measured 19 hr ago

• search_columns

  Search the Ross ERP 8.0 schema by name (and column descriptions). Returns matching objects and columns.

  Measured 19 hr ago

• search_facilities

  Search Ross ERP 8.0 UI facilities by code, name, help text, program or tag. Use this to find the screen/report for a task, e.g. 'check register' or 'purchase order receipts'.

  Measured 19 hr ago

• search_programs

  Search Ross ERP 8.0 programs by basename, TITLE program-id, title, module or type. Use this to find the program behind a task, e.g. 'check register' or 'ap_a'.

  Measured 19 hr ago

• table_facilities

  Reverse lookup: which UI facilities (screens/reports/programs) touch a given Ross ERP 8.0 table — split into core (facilities whose working set includes it) and reference (facilities that use it as a control/lookup), each with how many times the program source accesses it. Answers 'what screens read or write this table?'.

  Measured 19 hr ago

• table_programs

  Reverse lookup: which standard Ross ERP 8.0 programs reference a given table (validated against the Data Dictionary). Answers 'what code touches this table?' — complements table_facilities (which answers 'what screens touch it?'). Metadata only — no source body.

  Measured 19 hr ago

Probe history

• 19 hr agook441 ms21 tools

Status and uptime

Add badge to your README

The image links back to this page. It shows checks passed, or uptime, and the colour follows the latest status. Responses are cached for 5 to 15 minutes.

[![MCP Heartbeat](https://mcpheartbeat.com/badge/dev.rossdata/data-dictionary.svg)](https://mcpheartbeat.com/s/dev.rossdata/data-dictionary)

<a href="https://mcpheartbeat.com/s/dev.rossdata/data-dictionary"><img alt="MCP Heartbeat" src="https://mcpheartbeat.com/badge/dev.rossdata/data-dictionary.svg"></a>

[![MCP Heartbeat uptime](https://mcpheartbeat.com/badge/dev.rossdata/data-dictionary.svg?kind=uptime)](https://mcpheartbeat.com/s/dev.rossdata/data-dictionary)

Served from https://mcpheartbeat.com.

Same function and industry, ranked by checks passed then median latency.

• Responded16 / 22 checks passed

  Catalyst evidence graph

  catalystproject.aiVerified

  Findings on what compounds and supplements do in the body, with evidence strength, quote and paper.

  OtherOther

  • Handshake
  • Tools listed
  • Updated recently

  Median latency 699 ms · Last checked 16 hr ago

• Responded15 / 22 checks passed

  wcway

  wcway.comVerified

  Find the nearest public toilet worldwide. Read-only tools, no account, no API key.

  OtherOther

  • Handshake
  • Tools listed
  • Updated recently

  Median latency 49 ms · Last checked 15 hr ago

• Responded15 / 22 checks passed

  NEXO CAUSAL: perícia e ciência forense

  nexocausal.eng.brVerified

  Perícia e ciência forense pelo mundo, em português: busca, artigos completos e glossário técnico.

  OtherOther

  • Handshake
  • Tools listed
  • Updated recently

  Median latency 56 ms · Last checked 15 hr ago

• Responded15 / 22 checks passed

  Pick My Costume

  pickmycostume.comVerified

  Recommends Halloween costumes you can actually build, with step-by-step DIY build guides.

  OtherOther

  • Handshake
  • Tools listed
  • Updated recently

  Median latency 57 ms · Last checked 15 hr ago

• Responded15 / 22 checks passed

  Routine Run: write a routine

  routinerun.comVerified

  Write a step-by-step routine and get a link that opens it in Routine Run on iPhone. No sign-in.

  OtherOther

  • Handshake
  • Tools listed
  • Updated recently

  Median latency 62 ms · Last checked 15 hr ago

• Responded15 / 22 checks passed

  Pick My Secret Santa

  pickmysecretsanta.comVerified

  Runs a Secret Santa name draw in chat and gives each person a private reveal link.

  OtherOther

  • Communication & social

  • Handshake
  • Tools listed
  • Updated recently

  Median latency 62 ms · Last checked 15 hr ago