GL_ADB_BALANCES
Average Daily Balances
tableFINGL
GL_ADB_BALANCES — Average Daily Balances. FIN table in the standard Ross ERP 8.0 schema: 12 columns, used by 10 programs. Columns, data types, keys, foreign keys and relationships.
Open GL_ADB_BALANCES 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_NUMBER | varchar(50) | PK | GL Account Number |
| 3 | ACCOUNT_IDENT | varchar(6) | PK | Balance Type Identifier |
| 4 | SYS_CURRENCY_CODE | varchar(6) | PK | Currency Code |
| 5 | GL_EFFECTIVE_DATE | datetime | PK | ADB Effective Date |
| 6 | GL_DAILY_ACTIVITY | numeric(20,2) | Account Activity | |
| 7 | GL_DAILY_BALANCE | numeric(20,2) | Daily Balance | |
| 8 | GL_ANNUAL_ADB | numeric(20,2) | Annual Average Daily Balance | |
| 9 | GL_ADB_BUCKET_01 | numeric(20,2) | ||
| 10 | GL_ADB_BUCKET_02 | numeric(20,2) | ||
| 11 | GL_ADB_BUCKET_03 | numeric(20,2) | ||
| 12 | GL_ADB_BUCKET_04 | numeric(20,2) |