Ross ERP Data Dictionary
dev.rossdata/data-dictionary
Tools
Exactly what the server advertised in the scan completed . Effects and capabilities are classified by Squatch from each tool's metadata. Squatch never runs tools.
- Effect: Read 16
- Effect: Execute 2
- Effect: Unknown effect 3
Showing 21 of 21 tools
| Details | ||
|---|---|---|
| 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 … | Effect: Execute | |
| 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 physic… | Effect: Execute | |
| facility_stats Overview of the Ross ERP 8.0 application layer — the client menu tree of UI facilities (screens, reports, inquiries, maintenance functions)… | Effect: Read | |
| 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 … | Effect: Read | |
| 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. | Effect: Read | |
| graph_neighbors List the knowledge-graph neighbours of an object — the programs, tables, views and procedures directly connected to it, with relationship t… | Effect: Read | |
| list_facilities Browse and filter Ross ERP 8.0 UI facilities (menu screens/functions). Filter by system, database, class, a name/code substring, or withTab… | Effect: Read | |
| list_objects Browse and filter Ross ERP 8.0 objects (tables / views / procedures / functions). Filter by type, database, module, or a name substring; pa… | Effect: Read | |
| 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=in… | Effect: Read | |
| 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, ty… | Effect: Read | |
| lookup_table Full schema for a Ross ERP 8.0 object (table / view / procedure / function): columns with type, nullability, keys, descriptions and valid v… | Effect: Read | |
| 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). | Effect: Read | |
| program_stats Overview of the Ross ERP 8.0 program catalog — every application-source program (metadata only, no source body): total programs, how many d… | Effect: Read | |
| 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 … | Effect: Read | |
| 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… | Effect: Read | |
| search_columns Search the Ross ERP 8.0 schema by name (and column descriptions). Returns matching objects and columns. | Effect: Read | |
| 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 regi… | Effect: Read | |
| 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 … | Effect: Read | |
| program_facilities Reverse of facility_programs: which UI facilities (menu screens / reports / inquiries) a program backs — 'what screens does this program ru… | Effect: Unknown effect | |
| table_facilities Reverse lookup: which UI facilities (screens/reports/programs) touch a given Ross ERP 8.0 table — split into core (facilities whose working… | Effect: Unknown effect | |
| table_programs Reverse lookup: which standard Ross ERP 8.0 programs reference a given table (validated against the Data Dictionary). Answers 'what code to… | Effect: Unknown effect |