VERTICAL_FORMAT_DETAILS
Row Format Details
tableFINVERTICAL
VERTICAL_FORMAT_DETAILS — Row Format Details. FIN table in the standard Ross ERP 8.0 schema: 57 columns, used by 6 programs. Columns, data types, keys, foreign keys and relationships.
Open VERTICAL_FORMAT_DETAILS 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_SEQUENCE | int | PK | Row format sequence number |
| 5 | VF_LINE_TYPE | varchar(1) | Row Format Row Type | |
| 6 | VF_INDENT | smallint | Column Indentation | |
| 7 | VF_LINES_BEFORE | smallint | Blank lines before detail line | |
| 8 | VF_LINES_AFTER | smallint | Blank lines after detail line | |
| 9 | VF_PRINT_FLAG | varchar(1) | Print this Line | |
| 10 | VF_NORMAL_BALANCE | varchar(1) | Row format normal balance | |
| 11 | VF_ZERO_SUPPRESS | varchar(1) | Suppress Lines with Zeros | |
| 12 | VF_TOP_UNDERLINE_CHAR | varchar(1) | Underlining Character Above | |
| 13 | VF_BOTTOM_UNDERLINE_CHAR | varchar(1) | Underlining Character Below | |
| 14 | VF_SELECTION_METHOD | varchar(1) | Selection Method (account, by entity, or analysis code) | |
| 15 | VF_SORT_FIELDS | varchar(60) | Sort Field(s) for the accounts | |
| 16 | VF_BREAK_DETAIL_1 | varchar(50) | Detail Break Field(s) 1 | |
| 17 | VF_BREAK_DETAIL_2 | varchar(50) | Detail Break Field(s) 2 | |
| 18 | VF_SUMMARY_FLAG | varchar(1) | Summarize the lowest level of detail | |
| 19 | VF_TOTAL_FLAG | varchar(1) | Totaling flag for a set of detail | |
| 20 | VF_LINE_LABEL | varchar(16) | The label to use for a row. | |
| 21 | VF_TOTAL_TO_LABEL | varchar(16) | Label to Accumulate to | |
| 22 | VF_CALC_SOURCE_1 | varchar(16) | Source 1 | |
| 23 | VF_CALC_FLAG_1 | varchar(1) | Flag | |
| 24 | VF_CALC_SOURCE_2 | varchar(16) | Source 2 | |
| 25 | VF_CALC_FLAG_2 | varchar(1) | Flag | |
| 26 | VF_CALC_OPERATOR | varchar(1) | Calculation Operator | |
| 27 | VF_COLUMN_MASK | varchar(16) | Column Mask | |
| 28 | VF_LINE_DESC | varchar(60) | Description | |
| 29 | VF_LINE_TEXT | text | Line Text | |
| 30 | VF_COLUMN_SHIFT | varchar(60) | Column shift specification for columns | |
| 31 | VF_MULTIPLE_ACCOUNTS | text | Multiple account specification for row formats | |
| 32 | VF_ROUND_FLAG | varchar(1) | Rounding Adjustment line (Only if report uses rounded cols) | |
| 33 | VF_START_ACCOUNT | varchar(50) | ||
| 34 | VF_END_ACCOUNT | varchar(50) | ||
| 35 | GL_DETAIL_ACCOUNT | varchar(1) | GL Detail Account | |
| 36 | VF_NEW_PAGE_1 | varchar(1) | New Page at Break 1 | |
| 37 | VF_NEW_PAGE_2 | varchar(1) | New Page at break 2 | |
| 38 | VF_GENERIC_CODE | varchar(50) | ||
| 39 | SYS_CURRENCY_CODE | varchar(6) | Currency Code | |
| 40 | GL_NORMAL_BALANCE_POSITIVE | varchar(1) | Normal Balance Positive (Y/N) | |
| 41 | GENERIC_STRUCTURE_CODE | varchar(25) | Generic Structure Code | |
| 42 | GL_ELEMENT_RANGE_01 | text | ||
| 43 | GL_ELEMENT_RANGE_02 | text | ||
| 44 | GL_ELEMENT_RANGE_03 | text | ||
| 45 | GL_ELEMENT_RANGE_04 | text | ||
| 46 | GL_ELEMENT_RANGE_05 | text | ||
| 47 | GL_ELEMENT_RANGE_06 | text | ||
| 48 | GL_ELEMENT_RANGE_07 | text | ||
| 49 | GL_ELEMENT_RANGE_08 | text | ||
| 50 | GL_ELEMENT_RANGE_09 | text | ||
| 51 | GL_ELEMENT_RANGE_10 | text | ||
| 52 | GL_ELEMENT_RANGE_11 | text | ||
| 53 | GL_ELEMENT_RANGE_12 | text | ||
| 54 | GL_ELEMENT_RANGE_13 | text | ||
| 55 | GL_ELEMENT_RANGE_14 | text | ||
| 56 | GL_ELEMENT_RANGE_15 | text | ||
| 57 | GL_INVERT_BALANCE | varchar(1) | Invert Balance Flag (Y/N) |