RF_FACTORY_CONTROLS
Ross Factory Factory Controls
tableMANRF
RF_FACTORY_CONTROLS — Ross Factory Factory Controls. MAN table in the standard Ross ERP 8.0 schema: 17 columns, used by 15 programs. Columns, data types, keys, foreign keys and relationships.
Open RF_FACTORY_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 | COMPANY_CODE | varchar(10) | PK | Company Code |
| 3 | FACTORY | varchar(2) | PK | Factory Code |
| 4 | RF_EXP_JOB_DIRECTORY | varchar(40) | Ross Facotry export job file directory | |
| 5 | RF_EXP_JOB_FILE_NAME | varchar(30) | Ross Factory export job file name | |
| 6 | RF_EXP_PROD_DIRECTORY | varchar(40) | Ross Factory Export products file directory | |
| 7 | RF_EXP_PROD_FILE_NAME | varchar(30) | Ross Factory export products file name | |
| 8 | USERNAME | varchar(20) | Username | |
| 9 | SYSTEM_DATE | datetime | System Date Transaction Made | |
| 10 | RF_EXP_MATERIAL_FILE_NAME | varchar(30) | Ross Factory export material requirements file name | |
| 11 | RF_IMP_JOB_MACHINE | varchar(1) | Enable importing job machine time from Ross Factory | |
| 12 | RF_IMP_JOB_OUTPUT | varchar(1) | Enable importing job output count quantity from Ross Factory | |
| 13 | RF_MATERIAL_HANDLING | varchar(1) | Job stage input materials must be exported | |
| 14 | RF_EXPORT_METHOD | varchar(3) | Method of exporting products and job stages | |
| 15 | RF_INTERFACE_URL | varchar(500) | ||
| 16 | RF_EXP_ALLOCS_FILE_NAME | varchar(30) | Ross Factory export allocated materials file name | |
| 17 | QUALITY_WORK_AREA | varchar(20) | Quality Work Area |