GL_YEAR_END_CONTROLS

Year End Control flag and Retained Earnings specifications

tableFINGL

GL_YEAR_END_CONTROLS — Year End Control flag and Retained Earnings specifications. FIN table in the standard Ross ERP 8.0 schema: 10 columns, used by 17 programs. Columns, data types, keys, foreign keys and relationships.

Open GL_YEAR_END_CONTROLS in the interactive Data Dictionary →

Part of GL 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.
2COMPANY_CODEvarchar(10)PKCompany Code
3ACCOUNT_IDENTvarchar(6)PKBalance Type Identifier
4GL_ASSET_YEAR_ENDvarchar(1)Asset Year End Flag
5GL_LIABILITY_YEAR_ENDvarchar(1)
6GL_EQUITY_YEAR_ENDvarchar(1)
7GL_INCOME_YEAR_ENDvarchar(1)
8GL_EXPENSE_YEAR_ENDvarchar(1)
9GL_MEMO_YEAR_ENDvarchar(1)
10RETAINED_EARNINGSvarchar(50)