VERTICAL_FORMATS
GL Report Writer Row Formats
tableFINVERTICAL
VERTICAL_FORMATS — GL Report Writer Row Formats. FIN table in the standard Ross ERP 8.0 schema: 25 columns, used by 7 programs. Columns, data types, keys, foreign keys and relationships.
Open VERTICAL_FORMATS in the interactive Data Dictionary →Part of Other 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 | VF_IDENTIFIER | varchar(6) | PK | Row rormat Identifier |
| 4 | VF_DESCRIPTION | varchar(30) | Row format description | |
| 5 | VF_SELECTION_METHOD | varchar(1) | Selection Method (account, by entity, or analysis code) | |
| 6 | GL_REPORT_LAST_LINE | smallint | Last Line for User Defined Reports | |
| 7 | VF_REPEAT_FLAG | varchar(1) | Repeat Report | |
| 8 | VF_REPEAT_SUBCLASS | smallint | ||
| 9 | GL_REPEAT_SUMMARY | varchar(1) | ||
| 10 | VF_REPEAT_VALUES | text | Element Values | |
| 11 | GL_ELEMENT_RANGE_01 | text | ||
| 12 | GL_ELEMENT_RANGE_02 | text | ||
| 13 | GL_ELEMENT_RANGE_03 | text | ||
| 14 | GL_ELEMENT_RANGE_04 | text | ||
| 15 | GL_ELEMENT_RANGE_05 | text | ||
| 16 | GL_ELEMENT_RANGE_06 | text | ||
| 17 | GL_ELEMENT_RANGE_07 | text | ||
| 18 | GL_ELEMENT_RANGE_08 | text | ||
| 19 | GL_ELEMENT_RANGE_09 | text | ||
| 20 | GL_ELEMENT_RANGE_10 | text | ||
| 21 | GL_ELEMENT_RANGE_11 | text | ||
| 22 | GL_ELEMENT_RANGE_12 | text | ||
| 23 | GL_ELEMENT_RANGE_13 | text | ||
| 24 | GL_ELEMENT_RANGE_14 | text | ||
| 25 | GL_ELEMENT_RANGE_15 | text |