GL_INQUIRY_CODE_LINES
GL Inquiry Codes Line Calculations
tableFINGL
GL_INQUIRY_CODE_LINES — GL Inquiry Codes Line Calculations. FIN table in the standard Ross ERP 8.0 schema: 11 columns, used by 12 programs. Columns, data types, keys, foreign keys and relationships.
Open GL_INQUIRY_CODE_LINES 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_INQUIRY_CODE | varchar(6) | PK | GL Inquiry Code |
| 3 | GL_COLUMN | smallint | PK FK→GL_INQUIRY_CODE_COLS | Column |
| 4 | SEQUENCE | smallint | PK | Sequence Number |
| 5 | ACCOUNT_IDENT | varchar(6) | Balance Type Identifier | |
| 6 | CURRENT_YEAR | smallint | Current Year | |
| 7 | GL_OPERATOR | varchar(1) | Operator | |
| 8 | FIELD_NAME | varchar(31) | Field Name | |
| 9 | SYS_CURRENCY_CODE | varchar(6) | Currency Code | |
| 10 | GL_INQUIRY_YEAR | smallint | Inquiry Year | |
| 11 | GL_INQUIRY_YEAR_OFFSET | smallint | Inquiry Year Offset |