rossdata.dev

Reference for the standard Ross ERP 8.0 database schema (FIN + MAN). It describes the shape of the database, not its contents: table and column definitions, DDL, the UI menu tree and the program catalog. No business data, no customer records, no program source — structure only. SCHEMA layer: start with schema_stats to orient, list_objects to browse/filter by type or module, find_column to locate a column across tables. Use lookup_table for a full object, search_columns to find objects/columns, get_ddl for CREATE TABLE, and graph_neighbors / path_between to explore how objects connect. Not sure which layer a term lives in? search_all spans schema, facilities and programs in one call. APPLICATION layer: the client menu tree of UI facilities (screens / reports / inquiries / maintenance functions). Use facility_stats to orient, list_facilities / search_facilities to find a screen, lookup_facility for a facility's program, help, the tables it touches, and the facilities it invokes / is invoked by, table_facilities for the reverse — which screens read or write a given table — and facility_programs for the code that implements a screen. PROGRAM CATALOG: the application source programs (metadata only, no source body). Use program_stats to orient, list_programs / search_programs to find a program, lookup_program for a program's type, procedures and the Data Dictionary tables it references, table_programs for the reverse — which programs reference a given table — and program_facilities for the screens a program backs. Object names and facility codes are upper-case, e.g. GL_ACCOUNTS, AP_A_002; program basenames are lower-case, e.g. ap_a_check_register.