SYS_MONITOR_CONTROLS
Monitor Controls
tableFINSYS
SYS_MONITOR_CONTROLS — Monitor Controls. FIN table in the standard Ross ERP 8.0 schema: 22 columns, used by 13 programs. Columns, data types, keys, foreign keys and relationships.
Open SYS_MONITOR_CONTROLS in the interactive Data Dictionary →Part of SYS 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 | DIVISION | varchar(2) | PK | Division |
| 4 | SYS_TRANSACTION_TYPE_CODE | varchar(6) | PK | Monitor Type Code |
| 5 | SYS_TRN_TYPE_ACTIVE_FLAG | varchar(1) | Transaction Type Active Flag | |
| 6 | SYS_DIRECTORY_PATH | varchar(40) | Directory Path for Flat File | |
| 7 | SYS_FLAT_FILE_NAME | varchar(40) | Name of Flat File | |
| 8 | SYS_PROCESSING_OPTION | varchar(1) | Monitor Processing Option | |
| 9 | SYS_BATCH_QUEUE | varchar(20) | Name of Batch Queue | |
| 10 | SYS_TIME_TRIGGER_OPTION | varchar(1) | Monitor Time Trigger Option | |
| 11 | SYS_DELTA_TIME | numeric(20,0) | Time (In Minutes) to Execute Time Trigger | |
| 12 | SYS_DAY_OF_MONTH | varchar(2) | Day of Month to Execute Time Trigger | |
| 13 | SYS_MONTH | varchar(3) | Month to Execute Time Trigger | |
| 14 | SYS_YEAR | varchar(4) | Year to Execute Time Trigger | |
| 15 | SYS_HOURS | varchar(2) | Hour to Execute Time Trigger | |
| 16 | SYS_MINUTES | varchar(2) | Minute to Execute Time Trigger | |
| 17 | SYS_DAY_OF_WEEK | varchar(3) | Day of Week to Execute Time Trigger | |
| 18 | SYS_MONITOR_TRIGGER_FLAG | varchar(1) | Event Trigger Flag | |
| 19 | SYS_RUN_CONTROL_NUMBER | varchar(8) | Run Control Number | |
| 20 | SYS_ARCHIVE_DIRECTORY_PATH | varchar(40) | Archive Directory Path for Flat File | |
| 21 | DEFAULT_ORDER_CYCLE | varchar(1) | ||
| 22 | PARTIAL_ORDERS | varchar(1) | Allow EDI monitor to process partial sales orders |