GL_STRUCTURES
GL Hierarchy Structure
tableFINGL
GL_STRUCTURES — GL Hierarchy Structure. FIN table in the standard Ross ERP 8.0 schema: 29 columns, used by 23 programs. Columns, data types, keys, foreign keys and relationships.
Open GL_STRUCTURES in the interactive Data Dictionary →Part of GL 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 | GL_ACCOUNT_PARENT | varchar(50) | PK FK→GL_ACCOUNTS | GL Parent Account |
| 3 | GL_ACCOUNT_CHILD | varchar(50) | PK FK→GL_ACCOUNTS | GL Child Account |
| 4 | GL_OPERATOR | varchar(1) | Operator | |
| 5 | GL_SCALE | numeric(10,4) | Scale Value | |
| 6 | GL_ON_PERIOD | smallint | Effective On Period | |
| 7 | GL_ON_YEAR | smallint | GL Hierarchy On Year | |
| 8 | GL_OFF_PERIOD | smallint | Effective Off Period | |
| 9 | GL_OFF_YEAR | smallint | GL Heirarchy Off Year | |
| 10 | GL_DISPLAY_SEQ | smallint | Hierarchy Display Sequence | |
| 11 | GL_LEVEL_CODE | smallint | Hierarchy Level Code | |
| 12 | GL_ON_PERIOD_YEAR | varchar(6) | Period/Year for effectivity checking | |
| 13 | GL_OFF_PERIOD_YEAR | varchar(6) | Period/Year for effectivity checking | |
| 14 | STATUS_FLAG | varchar(1) | Status Flag | |
| 15 | GL_ELEMENT_RANGE_01 | text | ||
| 16 | GL_ELEMENT_RANGE_02 | text | ||
| 17 | GL_ELEMENT_RANGE_03 | text | ||
| 18 | GL_ELEMENT_RANGE_04 | text | ||
| 19 | GL_ELEMENT_RANGE_05 | text | ||
| 20 | GL_ELEMENT_RANGE_06 | text | ||
| 21 | GL_ELEMENT_RANGE_07 | text | ||
| 22 | GL_ELEMENT_RANGE_08 | text | ||
| 23 | GL_ELEMENT_RANGE_09 | text | ||
| 24 | GL_ELEMENT_RANGE_10 | text | ||
| 25 | GL_ELEMENT_RANGE_11 | text | ||
| 26 | GL_ELEMENT_RANGE_12 | text | ||
| 27 | GL_ELEMENT_RANGE_13 | text | ||
| 28 | GL_ELEMENT_RANGE_14 | text | ||
| 29 | GL_ELEMENT_RANGE_15 | text |