GEM_RELATION_FIELDS
tableFINGEM
GEM_RELATION_FIELDS — FIN table in the standard Ross ERP 8.0 schema: 20 columns, used by 7 programs. Columns, data types, keys, foreign keys and relationships.
Open GEM_RELATION_FIELDS in the interactive Data Dictionary →Part of GEM tables & objects · all tables, views & procedures
Columns
| # | Column | Type | Key | Description |
|---|---|---|---|---|
| 1 | GEM_DBKEY | int | GEMBASE internal surrogate primary key: a system-generated unique row identifier (the database key). Not a business field; every table carries one. | |
| 2 | GEM_RELATION_NAME | varchar(32) | GEMBASE framework/system column (runtime- or dictionary-managed, not a business field). | |
| 3 | GEM_FIELD_NAME | varchar(32) | GEMBASE framework/system column (runtime- or dictionary-managed, not a business field). | |
| 4 | GEM_LANG_CODE | varchar(2) | GEMBASE framework/system column (runtime- or dictionary-managed, not a business field). | |
| 5 | GEM_FIELD_SOURCE | varchar(32) | GEMBASE framework/system column (runtime- or dictionary-managed, not a business field). | |
| 6 | GEM_FIELD_GLOBAL | varchar(32) | GEMBASE framework/system column (runtime- or dictionary-managed, not a business field). | |
| 7 | GEM_FIELD_SRCE_CTXT | smallint | GEMBASE framework/system column (runtime- or dictionary-managed, not a business field). | |
| 8 | GEM_FIELD_PROMPT | varchar(60) | GEMBASE framework/system column (runtime- or dictionary-managed, not a business field). | |
| 9 | GEM_SHORT_PROMPT | varchar(16) | GEMBASE framework/system column (runtime- or dictionary-managed, not a business field). | |
| 10 | GEM_FIELD_HEADING | varchar(60) | GEMBASE framework/system column (runtime- or dictionary-managed, not a business field). | |
| 11 | GEM_INPUT_MASK | varchar(60) | GEMBASE framework/system column (runtime- or dictionary-managed, not a business field). | |
| 12 | GEM_OUTPUT_MASK | varchar(60) | GEMBASE framework/system column (runtime- or dictionary-managed, not a business field). | |
| 13 | GEM_DESCRIPTION | varchar(96) | GEMBASE framework/system column (runtime- or dictionary-managed, not a business field). | |
| 14 | GEM_SEQUENCE | smallint | GEMBASE framework/system column (runtime- or dictionary-managed, not a business field). | |
| 15 | GEM_SUB_TYPE | varchar(1) | GEMBASE framework/system column (runtime- or dictionary-managed, not a business field). | |
| 16 | GEM_COMPUTED_DTYPE | smallint | GEMBASE framework/system column (runtime- or dictionary-managed, not a business field). | |
| 17 | GEM_COMPUTED_LENGTH | smallint | GEMBASE framework/system column (runtime- or dictionary-managed, not a business field). | |
| 18 | GEM_COMPUTED_SOURCE | text | GEMBASE framework/system column (runtime- or dictionary-managed, not a business field). | |
| 19 | GEM_HELP | text | GEMBASE framework/system column (runtime- or dictionary-managed, not a business field). | |
| 20 | GEM_DISPLAY_LENGTH | int | GEMBASE framework/system column (runtime- or dictionary-managed, not a business field). |
Referenced by views / procedures · 40
GEM_ADD_LANG_CODE_2GEM_CHECK_COMP_DOC_FNAMESGEM_CHECK_GEM_REL_FIELDGEM_COMPUTED_1GEM_COMPUTED_2GEM_COMPUTED_SOURCEGEM_DDF_GEM_TABLE_FIELDGEM_DELETE_LANG_CODEGEM_DEL_REL_FLDGEM_DEL_TAB_REL_FLDSGEM_FIND_BASE_NAMEGEM_GEM_PVT_TABLE_FIELDSGEM_GEM_TABLE_FIELDSGEM_GET_SOURCE_FIELDGEM_GET_TF_FIELD_HELPGEM_GET_VIEW_COMPGEM_HLP_BASED_ONGEM_HLP_EQ_FIELDSGEM_HLP_M_FIELDSGEM_IS_COMPUTED_FIELDGEM_LOAD_ALL_TABFLD1GEM_LOAD_ALL_TABFLD2GEM_LOAD_ALL_TABFLD3GEM_LOAD_CTXT1GEM_LOAD_CTXT3GEM_LOAD_RFLDS_GBLGEM_LOAD_SPEC_TABFLD2GEM_LOAD_TABFLD2GEM_LOAD_TABFLD3GEM_LOAD_TABFLD_COMP_FNAMESGEM_LRF1GEM_MDC_LOAD_2GEM_MDC_LOAD_EIGGEM_MODIFY_GEM_RELFLDGEM_MODIFY_GEM_RELFLD_1GEM_MODIFY_GEM_RELFLD_1_HELPGEM_MOD_GEM_TABFLDGEM_MOD_TABLE_1GEM_SETUP_LIST_OF_MOD_TABFLDSGEM_UPDATE_GEM_RELFLD