Ross ERP Data Dictionary

1,865 tables · 37,003 columns · 358 views · 870 procs · 49 fns · 195 audit twins

All Tables1,865 Views358 Procs870 Fns49
Any ReferenceOrphanNo PK
Both DB FINMAN
⊘ Archive A_*
sort

Data Dictionary — Help

An interactive reference for the standard vanilla Ross ERP 8.0 schema (FIN + MAN) — every table, view, procedure and function, with column descriptions, valid-value lists and foreign keys drawn from the GEMBASE application dictionary.

The four tabs

ObjectsTables, views, procs & functions. Open one for its columns, keys, relationships and schema-neighborhood diagram.
ColumnsEvery distinct column name across the schema. Open one for its definition and every table that carries it.
ModulesTable families grouped by name prefix (GL_, AP_, IC_ …).
InsightsSchema-wide stats, most-depended-on tables, module coupling, and the full badge legend.

Search & filter

The search box filters the current list by object or column name — in the Columns tab it also matches text inside descriptions. In Objects, narrow with the chip rows: object type, class (reference / orphan / no-PK) and database (FIN / MAN). The ⊘ Archive A_* toggle brings in the archive / history twin tables, which are hidden by default; change ordering with sort (name · column count · most used).

Hover for details

Hover any table or column name — in a list, a foreign-key badge, the relationship sections or the schema diagram — to get a quick card: columns & key counts, foreign keys in/out, related tables and usage for a table; description, valid values and where it lives for a column. Click to open it fully.

Keyboard shortcuts

?Open / close this help
/Jump to the search box
EscClose help · leave the search box

Column badges

PKPrimary-key column (declared in DB metadata)
IDIdentity / surrogate auto-number key
fxComputed column — value from a formula
FKForeign key — references another table (click to follow)

Per-table actions

⬇ CSVDownload every column with types, descriptions, valid values & foreign keys.
⬇ JSONDownload the whole table as structured JSON — columns, keys, relationships & usage.
⧉ SELECTCopy a ready SELECT of all columns.
⧉ DDLCopy a CREATE TABLE with descriptions as comments and FK constraints.
↗ GraphOpen this object in the sibling knowledge-graph explorer.

Descriptions, valid-value lists and foreign keys come from the GEMBASE application data dictionary; additional relationships are inferred from shared key columns. Customer-specific objects are excluded and identifiers de-identified. Deep-link any object by its name in the URL, e.g. #GLLEDGER.