FACTORIES
Factories
tableMANFACTORIES
FACTORIES — Factories. MAN table in the standard Ross ERP 8.0 schema: 51 columns, used by 391 programs. Columns, data types, keys, foreign keys and relationships.
Open FACTORIES 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 | DESCRIPTION | varchar(60) | Description | |
| 5 | PERIOD | smallint | Period Number | |
| 6 | YEAR | smallint | Year Number | |
| 7 | LABOUR_RATE_SOURCE | varchar(1) | Labor Rate Source | |
| 8 | AUTO_NUMBER_BATCHES_FLAG | varchar(1) | Automatic Numbering of Lots Required | |
| 9 | GL_WIP_SUSPENSE_CODE | varchar(6) | WIP Suspense Code | |
| 10 | GL_WIP_SUSPENSE_ACCOUNT | varchar(50) | WIP Suspense Account | |
| 11 | INV_VALUATION_METHOD | varchar(4) | FK→INV_VALUATION_METHODS | Inventory Valuation Method |
| 12 | WAC_ADJUSTMENT_CODE | varchar(6) | WAC Rounding/adjustment Code | |
| 13 | WAC_ADJUSTMENT_ACCOUNT | varchar(50) | WAC Rounding/adjustment Account | |
| 14 | STD_VARIANCE_CODE | varchar(6) | Std Cost Variance Code | |
| 15 | STD_VARIANCE_ACCOUNT | varchar(50) | Std Cost Variance Account | |
| 16 | DIVISION | varchar(2) | Division | |
| 17 | ACTIVATE_MODULE | varchar(1) | Activate Module | |
| 18 | SEQUENCING_CONTROL | varchar(1) | Sequencing Control | |
| 19 | STATUS_FLAG | varchar(1) | Status Flag | |
| 20 | DAYS_FORWARD_COMMITMENT | smallint | Number of days forward to include in qty committed. | |
| 21 | DAYS_BACKWARD_COMMITMENT | smallint | Number of days backward to include in qty committed back. | |
| 22 | DAYS_FORWARD_ORDERED | smallint | Number of days forward to include in qty on forward order. | |
| 23 | DAYS_BACKWARD_ORDERED | smallint | Number of days backward to include in qty on back order. | |
| 24 | PM_SCHEDULING_REQD | varchar(1) | Finite Scheduling Required | |
| 25 | PM_NEW_DESCRIPTION_VERSION_REQ | varchar(1) | ||
| 26 | PM_CHANGEOVERS_REQD | varchar(1) | Changeover Jobs Required | |
| 27 | SYS_CURRENCY_METHOD | varchar(1) | Currency Method | |
| 28 | SYS_CURRENCY_CODE | varchar(6) | Currency Code | |
| 29 | PM_REVIEW_ALLOCATIONS | varchar(1) | Review Cost Allocations | |
| 30 | PM_JOB_SETUP | varchar(1) | Default job creation and release setting | |
| 31 | GL_WIP_VAR_ACCT | varchar(50) | ||
| 32 | GL_WIP_VAR_CODE | varchar(6) | ||
| 33 | APS_IN_USE | varchar(1) | Advanced Planning & Scheduling in use | |
| 34 | APS_JOB_EXPORTED | varchar(1) | Flag indicates whether Jobs are exported to the APS system | |
| 35 | JOB_TOLERANCE | numeric(5,2) | Job Tolerance | |
| 36 | SCM_APS_IN_USE | varchar(1) | SCM APS Integration In Use | |
| 37 | RECIPE_LINE_INCREMENT | smallint | Recipe Line Increment Value | |
| 38 | JOB_CREATE_OPTION | smallint | Job Create Option parameter | |
| 39 | CAMPAIGN_IN_USE | varchar(1) | Set to use Campaign or not on a factory | |
| 40 | DC_ISSUE_ENTER_JOB_FIRST | varchar(1) | Enter job first in DC Material Issue or not | |
| 41 | DC_CLOSE_ENTER_JOB_FIRST | varchar(1) | Enter job first in DC Partial Close or not | |
| 42 | ELEMENTAL_COSTING_YN | varchar(1) | Display Elemental Costs Yes or No | |
| 43 | RF_IN_USE | varchar(1) | Ross Factory in use flag | |
| 44 | PRE_ASSIGN_LOTS | varchar(1) | Pre-assign Lot Numbers | |
| 45 | CONTROL_MACHINE_RATES | varchar(1) | Whether the machine rates/costs are controlled | |
| 46 | CONTROL_LABOR_RATES | varchar(1) | Whether the labor rates/costs are controlled | |
| 47 | CONTROL_MISC_COSTS | varchar(1) | Whether the miscellaneous costs are controlled | |
| 48 | RF_QC_IN_USE | varchar(1) | Ross Factory Quality In Use | |
| 49 | RECIPE_AUDIT_FLAG | varchar(1) | Recipe Audit | |
| 50 | DEFAULT_ZERO_FOR_MTRL_ISSUE | varchar(1) | Flag to control Default Zero Qty for Material Issue | |
| 51 | GEM_MODIFY_DATE | datetime | System timestamp of the most recent modification to the row, maintained by GEMBASE. |
Referenced by · 33 foreign keys
BATCH_TIME_CARDSDESCRIPTION_CODESEMPLOYEESPM_RECIPE_TYPESPM_AUTHORIZATION_GROUPSPM_JOB_CONTROL_AREASPM_DEPARTMENTSPM_DEPARTMENT_AUTHORIZERSPM_AUTHORIZATION_SEQUENCECAMPAIGN_CODESJOBSJOB_DETAIL_COSTSJOB_STAGE_COSTSJOB_STAGE_COUNTSJOB_STAGE_LINESLABOUR_CLASSESLABOUR_TYPESMACHINESMACHINE_TIME_INPUTMISCELLANEOUS_CHARGESPLANNING_SPEC_PROCESSESPROCESS_LINESPROCESS_SPECIFICATIONSPROCESS_SPEC_FLOWSPROCESS_SPEC_STAGEPROCESS_SPEC_STAGE_COSTSPROCESS_SPEC_STAGE_RECIPESPROCESS_STAGESRECIPESRESOURCE_GROUPSSCHEDULE_RUN_MACHINESWAREHOUSE_FACTORY_ALLOCATIONSWORK_CENTERS