SYS_CONTROL_FLAG_DESCRIPTIONS

Text descriptions for control flag codes

tableFINSYS

SYS_CONTROL_FLAG_DESCRIPTIONS — Text descriptions for control flag codes. FIN table in the standard Ross ERP 8.0 schema: 5 columns, used by 120 programs. Columns, data types, keys, foreign keys and relationships.

Open SYS_CONTROL_FLAG_DESCRIPTIONS in the interactive Data Dictionary →

Part of SYS 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.
2SYS_CONTROL_FLAG_FIELDvarchar(32)PKControl Flag Field Name
3SYS_CONTROL_FLAG_LANGvarchar(2)PKControl Flag Language
4SYS_CONTROL_FLAG_VALUEsmallintPKControl Flag Value
5SYS_CONTROL_FLAG_DESCvarchar(30)Control Flag Description Text