FYE_CONTROLS
Fiscal Year End Controls
tableFINFYE
FYE_CONTROLS — Fiscal Year End Controls. FIN table in the standard Ross ERP 8.0 schema: 35 columns, used by 2 programs. Columns, data types, keys, foreign keys and relationships.
Open FYE_CONTROLS in the interactive Data Dictionary →Part of Other 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 | COMPANY_CODE | varchar(10) | PK | Company Code |
| 3 | CURRENT_YEAR | smallint | PK | Current Year |
| 4 | FROM_YEAR_1 | smallint | ||
| 5 | FROM_ACCOUNT_IDENT_1 | varchar(6) | FK→GL_RECORD_IDS | |
| 6 | TO_YEAR_1 | smallint | ||
| 7 | TO_ACCOUNT_IDENT_1 | varchar(6) | FK→GL_RECORD_IDS | |
| 8 | ACCOUNTS_1 | varchar(50) | Account Range for Year End | |
| 9 | FROM_YEAR_2 | smallint | ||
| 10 | FROM_ACCOUNT_IDENT_2 | varchar(6) | FK→GL_RECORD_IDS | |
| 11 | TO_YEAR_2 | smallint | ||
| 12 | TO_ACCOUNT_IDENT_2 | varchar(6) | FK→GL_RECORD_IDS | |
| 13 | ACCOUNTS_2 | varchar(50) | Account Range for Year End | |
| 14 | FROM_YEAR_3 | smallint | ||
| 15 | FROM_ACCOUNT_IDENT_3 | varchar(6) | FK→GL_RECORD_IDS | |
| 16 | TO_YEAR_3 | smallint | ||
| 17 | TO_ACCOUNT_IDENT_3 | varchar(6) | FK→GL_RECORD_IDS | |
| 18 | ACCOUNTS_3 | varchar(50) | Account Range for Year End | |
| 19 | FROM_YEAR_4 | smallint | ||
| 20 | FROM_ACCOUNT_IDENT_4 | varchar(6) | FK→GL_RECORD_IDS | |
| 21 | TO_YEAR_4 | smallint | ||
| 22 | TO_ACCOUNT_IDENT_4 | varchar(6) | FK→GL_RECORD_IDS | |
| 23 | ACCOUNTS_4 | varchar(50) | Account Range for Year End | |
| 24 | FROM_YEAR_5 | smallint | ||
| 25 | FROM_ACCOUNT_IDENT_5 | varchar(6) | FK→GL_RECORD_IDS | |
| 26 | TO_YEAR_5 | smallint | ||
| 27 | TO_ACCOUNT_IDENT_5 | varchar(6) | FK→GL_RECORD_IDS | |
| 28 | ACCOUNTS_5 | varchar(50) | Account Range for Year End | |
| 29 | ZERO_BALANCES | varchar(1) | Create Zero Balances | |
| 30 | GL_ACCOUNTS_RANGE_1 | text | GL Account Range | |
| 31 | GL_ACCOUNTS_RANGE_2 | text | GL Accounts Range 2 | |
| 32 | GL_ACCOUNTS_RANGE_3 | text | GL Accounts Range 3 | |
| 33 | GL_ACCOUNTS_RANGE_4 | text | GL Accounts Range 4 | |
| 34 | GL_ACCOUNTS_RANGE_5 | text | GL Accounts Range 5 | |
| 35 | GL_FYE_YEAR_CLOSED | varchar(1) |