REPORT_PRINT_CONTROLS
Report Print Controls
tableFINREPORT
REPORT_PRINT_CONTROLS — Report Print Controls. FIN table in the standard Ross ERP 8.0 schema: 28 columns, used by 163 programs. Columns, data types, keys, foreign keys and relationships.
Open REPORT_PRINT_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 | REPORT_NUMBER | varchar(15) | PK | Report Identifier |
| 3 | USERNAME | varchar(20) | PK | Username |
| 4 | REPORT_FILE_NAME | varchar(38) | Report File Name | |
| 5 | CODE_DESCRIPTION | varchar(30) | Code Description | |
| 6 | REPORT_AUTO_PRINT | varchar(1) | Report Auto Print Flag | |
| 7 | REPORT_QUEUE | varchar(40) | Report Queue Name | |
| 8 | REPORT_FORM_TYPE | varchar(40) | Report Form Type | |
| 9 | REPORT_COPIES | smallint | Report Copies | |
| 10 | SOURCE_MODULE | varchar(2) | Source Module Reference | |
| 11 | varchar(50) | Email Address | ||
| 12 | SYS_REPORT_PROCESS_TYPE | int | FK→SYS_REPORT_PROCESS_TYPES | Process by which a report is created. |
| 13 | SYS_STORED_PROCEDURE | varchar(30) | Name of stored procedure to run | |
| 14 | SYS_STORED_PROCEDURE_2 | varchar(30) | Name of stored procedure to run | |
| 15 | SYS_REPORT_OUTPUT_DIRECTORY | varchar(255) | Directory for saving report files | |
| 16 | SYS_REPORT_FILE_TYPE | int | FK→SYS_REPORT_FILE_TYPES | File type in which reports are created |
| 17 | SYS_SAVE_REPORT | varchar(1) | Determines whether to save report to disk | |
| 18 | SYS_DEBUG_MODE | varchar(1) | Places external application in debug mode | |
| 19 | SYS_RUN_AS_SERVICE | varchar(1) | Sets external application as a service | |
| 20 | SYS_EXT_REPORT_TEMPLATE | varchar(38) | External report template used by an external application. | |
| 21 | ALLOW_NAME_OVERRIDE | numeric(3,0) | Allow the user to override default report name | |
| 22 | SHOW_REPORT_FLAG | varchar(1) | Display Report | |
| 23 | SPLIT_REPORT_FLAG | varchar(1) | Separate Documents | |
| 24 | AUTO_UPLOAD_SHAREPOINT | smallint | Auto Upload Sharepoint | |
| 25 | SYS_EXT_RRS_TEMPLATE | varchar(60) | RRS Report Template | |
| 26 | SHOW_REPORT_AS_PDF | varchar(1) | Show report as pdf format | |
| 27 | SYS_POST_UPDATE_SCRIPT | varchar(100) | RRS Report Post Update Script | |
| 28 | SYS_GET_DOCUMENT_LIST | varchar(100) | RRS Report Get Document List |