CPANEL_CONTROLS
Cpanel Configuration Table
tableFINCPANEL
CPANEL_CONTROLS — Cpanel Configuration Table. FIN table in the standard Ross ERP 8.0 schema: 24 columns, used by 48 programs. Columns, data types, keys, foreign keys and relationships.
Open CPANEL_CONTROLS 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 | CP_NAME | varchar(30) | PK | Cpanel Name |
| 3 | CP_TYPE | varchar(1) | Cpanel Type | |
| 4 | CP_NUMBER_OF_ELEMENTS | smallint | Cpanel Element Number | |
| 5 | CP_ELEMENTS_1 | varchar(10) | ||
| 6 | CP_ELEMENTS_2 | varchar(10) | ||
| 7 | CP_ELEMENTS_3 | varchar(10) | ||
| 8 | CP_ELEMENTS_4 | varchar(10) | ||
| 9 | CP_ELEMENTS_5 | varchar(10) | ||
| 10 | CP_ELEMENTS_6 | varchar(10) | ||
| 11 | CP_ELEMENTS_7 | varchar(10) | ||
| 12 | CP_ELEMENTS_8 | varchar(10) | ||
| 13 | CP_ELEMENTS_9 | varchar(10) | ||
| 14 | CP_ELEMENTS_10 | varchar(10) | ||
| 15 | CP_ELEMENTS_11 | varchar(10) | ||
| 16 | CP_ELEMENTS_12 | varchar(10) | ||
| 17 | CP_ELEMENTS_13 | varchar(10) | ||
| 18 | CP_ELEMENTS_14 | varchar(10) | ||
| 19 | CP_ELEMENTS_15 | varchar(10) | ||
| 20 | CP_ELEMENTS_16 | varchar(10) | ||
| 21 | CP_ELEMENTS_17 | varchar(10) | ||
| 22 | CP_ELEMENTS_18 | varchar(10) | ||
| 23 | CP_ELEMENTS_19 | varchar(10) | ||
| 24 | CP_ELEMENTS_20 | varchar(10) |