GL_ACCOUNT_TEMPLATES
GL Hierarchy Account Ranges
tableFINGL
GL_ACCOUNT_TEMPLATES — GL Hierarchy Account Ranges. FIN table in the standard Ross ERP 8.0 schema: 44 columns, used by 8 programs. Columns, data types, keys, foreign keys and relationships.
Open GL_ACCOUNT_TEMPLATES 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 | ACCOUNT_TYPE | varchar(1) | Account Type (A-sset, L-iability, E-xpense etc.) | |
| 3 | NORMAL_BALANCE | varchar(1) | Normal Balance for Account (D-ebit or C-redit) | |
| 4 | AP_ACCESS_ACCOUNT | varchar(1) | Access from Accounts Payable permitted | |
| 5 | AR_ACCESS_ACCOUNT | varchar(1) | Access from Accounts Receivable Permitted | |
| 6 | GL_ACCESS_ACCOUNT | varchar(1) | Access from General Ledger Permitted | |
| 7 | INV_ACCESS_ACCOUNT | varchar(1) | Access from Inventory Permitted | |
| 8 | SUMMARIZATION_FLAG | varchar(1) | Summarization/Non-summarization flag | |
| 9 | SYS_ADB_REQUIRED | varchar(1) | Average Daily Balances Required | |
| 10 | DESCRIPTION_ELEMENT | smallint | ||
| 11 | GL_ACCOUNT_TEMPLATE_CODE | varchar(8) | PK | GL Account Template Code |
| 12 | SYS_CODE_DESCRIPTION | varchar(30) | Code Description | |
| 13 | COMPANY_CODE | varchar(10) | PK | Company Code |
| 14 | GL_RESPONSIBILITY | varchar(20) | FK→USER_COMPANY_ID | |
| 15 | GL_RETAIN_LIFE_TO_DATE | varchar(1) | Retain Life to Date | |
| 16 | SYS_CURRENCY_GAIN_LOSS | varchar(1) | Compute Unrealized Currency Gain/Loss | |
| 17 | GL_DEFAULT_RATE_TYPE | varchar(6) | FK→SYS_RATE_TYPES | Default Currency Rate Type |
| 18 | GL_DEFAULT_RATE_AUTHORITY | varchar(6) | FK→SYS_RATE_AUTHORITIES | Default Currency Rate Authority |
| 19 | GL_ELEMENT_RANGE_01 | text | ||
| 20 | GL_ELEMENT_RANGE_02 | text | ||
| 21 | GL_ELEMENT_RANGE_03 | text | ||
| 22 | GL_ELEMENT_RANGE_04 | text | ||
| 23 | GL_ELEMENT_RANGE_05 | text | ||
| 24 | GL_ELEMENT_RANGE_06 | text | ||
| 25 | GL_ELEMENT_RANGE_07 | text | ||
| 26 | GL_ELEMENT_RANGE_08 | text | ||
| 27 | GL_ELEMENT_RANGE_09 | text | ||
| 28 | GL_ELEMENT_RANGE_10 | text | ||
| 29 | GL_ELEMENT_RANGE_11 | text | ||
| 30 | GL_ELEMENT_RANGE_12 | text | ||
| 31 | GL_ELEMENT_RANGE_13 | text | ||
| 32 | GL_ELEMENT_RANGE_14 | text | ||
| 33 | GL_ELEMENT_RANGE_15 | text | ||
| 34 | FUND_IN_USE | varchar(1) | Fund/Commitment Accounting in Use | |
| 35 | GL_ALLOW_ANALYSIS_CODES | varchar(1) | Allow GL Postings Analysis Codes | |
| 36 | GL_ANALYSIS_CODE_1 | varchar(15) | GL Analysis Code | |
| 37 | GL_ANALYSIS_CODE_2 | varchar(15) | GL Analysis Code | |
| 38 | GL_ANALYSIS_CODE_3 | varchar(18) | GL Analysis Code | |
| 39 | GL_BUDGET_CHECK_PERIOD | varchar(1) | Budget Check Period | |
| 40 | GL_BUDGET_CHECK_LEVEL | varchar(1) | Budget Check Level | |
| 41 | BUDGET_SUMMARY_ACCOUNT | varchar(50) | Budget Summary Account | |
| 42 | RETAINED_EARNINGS_ACCOUNT | varchar(50) | Retained Earnings Account | |
| 43 | GL_TOLERANCE_AMOUNT | numeric(20,2) | Budget Tolerance Amount | |
| 44 | GL_TOLERANCE_PERCENT | numeric(10,2) | Budget Tolerance Percentage |