GL_REPORTS
User-defined GL Reports
tableFINGL
GL_REPORTS — User-defined GL Reports. FIN table in the standard Ross ERP 8.0 schema: 18 columns, used by 6 programs. Columns, data types, keys, foreign keys and relationships.
Open GL_REPORTS 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 | COMPANY_CODE | varchar(10) | PK | Company Code |
| 3 | HF_IDENTIFIER | varchar(6) | FK→HORIZONTAL_FORMATS | Column Format Identifier |
| 4 | VF_IDENTIFIER | varchar(6) | FK→VERTICAL_FORMATS | Row rormat Identifier |
| 5 | GL_REPORT_IDENTIFIER | varchar(30) | PK | GL Report Identifier |
| 6 | GL_REPORT_DESC | varchar(30) | Report Description | |
| 7 | GL_REPORT_FILE_NAME | varchar(38) | Output File Name | |
| 8 | GL_REPORT_COL_HEADS_FLAG | varchar(1) | Suppress Col Headings | |
| 9 | GL_HEADING_1 | varchar(50) | 1st Heading Line | |
| 10 | GL_HEADING_2 | varchar(50) | 2nd Heading Line | |
| 11 | GL_HEADING_3 | varchar(50) | 3rd Heading Line | |
| 12 | GL_REPORT_DT_MASK | varchar(40) | Date_time Mask | |
| 13 | GL_REPORT_WIDTH | smallint | Report Width | |
| 14 | VF_FORM_SIZE | smallint | Row format form size | |
| 15 | GL_REPORT_LAST_LINE | smallint | Last Line for User Defined Reports | |
| 16 | PAGE_NUMBERING | varchar(1) | Include Page Numbers | |
| 17 | SYS_CURRENCY_CODE | varchar(6) | Currency Code | |
| 18 | REPORT_PRINT_TYPE | smallint | Output File Format |