GEM_TRIGGERS

tableFINGEM

GEM_TRIGGERS — FIN table in the standard Ross ERP 8.0 schema: 5 columns, used by 1 program. Columns, data types, keys, foreign keys and relationships.

Open GEM_TRIGGERS in the interactive Data Dictionary →

Part of GEM tables & objects · all tables, views & procedures

Columns

#ColumnTypeKeyDescription
1GEM_DBKEYintGEMBASE internal surrogate primary key: a system-generated unique row identifier (the database key). Not a business field; every table carries one.
2GEM_RELATION_NAMEvarchar(32)GEMBASE framework/system column (runtime- or dictionary-managed, not a business field).
3GEM_FIELD_NAMEvarchar(32)GEMBASE framework/system column (runtime- or dictionary-managed, not a business field).
4GEM_TRIGGERvarchar(255)GEMBASE framework/system column (runtime- or dictionary-managed, not a business field).
5GEM_TRIGGER_FLAGSintGEMBASE framework/system column (runtime- or dictionary-managed, not a business field).

Referenced by views / procedures · 9

GEM_ADD_TRIGGERGEM_DELETE_GEM_TRIGGERGEM_DEL_TABLE_TRIGGERGEM_DEL_TRIGGERGEM_GET_ALL_TRIGGERSGEM_GET_TRIGGERGEM_HLP_TRIGGERSGEM_LOAD_TABLE_TRIGGERSGEM_MOD_TRIGGER