HORIZONTAL_FORMAT_DETAILS
GL Report Column Format Details
tableFINHORIZONTAL
HORIZONTAL_FORMAT_DETAILS — GL Report Column Format Details. FIN table in the standard Ross ERP 8.0 schema: 21 columns, used by 6 programs. Columns, data types, keys, foreign keys and relationships.
Open HORIZONTAL_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 | HF_IDENTIFIER | varchar(6) | PK | Column Format Identifier |
| 4 | HF_SEQUENCE | int | PK | Column Format Sequence Number |
| 5 | HF_COL_TYPE | varchar(1) | Column Type (D,V,P) | |
| 6 | HF_SOURCE | text | Column Source | |
| 7 | HF_COL_HEADING | varchar(60) | Heading for the report column | |
| 8 | HF_COL_MASK | varchar(61) | Column mask to use on printing | |
| 9 | HF_COL_START | smallint | Starting column to print | |
| 10 | HF_COL_WIDTH | smallint | Column Print Width | |
| 11 | HF_COL_ROW | smallint | Row position to print on | |
| 12 | HF_COL_TABLE | varchar(31) | The table on which the column source may be found | |
| 13 | HF_SOURCE_TYPE | varchar(1) | Source Field Type | |
| 14 | HF_LINE_LOGIC | text | Column Logic | |
| 15 | HF_VF_SEQ_LIST_FLAG | varchar(1) | Flag which indicates exclusion/inclusion of row list | |
| 16 | HF_ROUNDING | numeric(20,0) | Rounding for value fields. | |
| 17 | HF_SOURCE_1 | text | Column source | |
| 18 | HF_ROUND_SOURCE | varchar(1) | Round at Source | |
| 19 | TEMP_VF_LIST | varchar(60) | ||
| 20 | HF_VF_SEQ_LIST | text | Row sequence inclusion/exclusion list | |
| 21 | HF_COLUMN_SIGN | varchar(1) | Ignore Invert Balance |