PROCESS_SPECIFICATIONS
Process Specifications
tableMANPROCESS
PROCESS_SPECIFICATIONS — Process Specifications. MAN table in the standard Ross ERP 8.0 schema: 54 columns, used by 137 programs. Columns, data types, keys, foreign keys and relationships.
Open PROCESS_SPECIFICATIONS in the interactive Data Dictionary →Part of PROCESS 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 FK→FACTORIES | Factory Code |
| 4 | PROCESS_SPEC | varchar(15) | PK | Process Specification |
| 5 | DESCRIPTION | varchar(60) | Description | |
| 6 | DETAIL_DESCRIPTION | text | Detailed Description | |
| 7 | PROCESS_PLANNING_BATCH_QTY | numeric(20,6) | Planning Batch Quantity | |
| 8 | PROCESS_PLANNING_UOM | varchar(4) | Process Planning Unit of Measure | |
| 9 | PLANNING_TIME_UNIT | varchar(1) | FK→TIME_UNITS | Planning Time Unit |
| 10 | STATUS_FLAG | varchar(1) | Status Flag | |
| 11 | INPUT_OUTPUT_DRIVEN | varchar(1) | Recipe/Process Spec is Input or Output Driven | |
| 12 | MAX_BATCH_QTY | numeric(20,6) | Maximum Manufacturing Batch Qty | |
| 13 | MIN_BATCH_QTY | numeric(20,6) | Minimum Manufacturing Batch Qty | |
| 14 | PRINCIPAL_PRODUCT | varchar(15) | Prinicipal Final Output Product | |
| 15 | SOURCE_TYPE | varchar(1) | Source Type | |
| 16 | SEQUENCE_CODE_1 | varchar(4) | Process Sequencing Code | |
| 17 | SEQUENCE_CODE_2 | varchar(4) | Process Sequencing Code | |
| 18 | SEQUENCE_CODE_3 | varchar(4) | Process Sequencing Code | |
| 19 | CHANGEOVER_SPEC | varchar(1) | Changeover Specification | |
| 20 | JOB_COMPLETE_DATA_SOURCE | varchar(5) | FK→PLC_DATA_SOURCES | Job Complete Data Source Name |
| 21 | JOB_COMPLETE_POINT_NAME | varchar(15) | FK→PLC_TAGS | Job Complete Point Name |
| 22 | SPEC_DOWNLOAD_DATA_SOURCE | varchar(5) | FK→PLC_DATA_SOURCES | Specification Download Data Source |
| 23 | SPEC_DOWNLOAD_POINT_NAME | varchar(15) | FK→PLC_TAGS | Specification Download Point Name |
| 24 | JOB_DATA_SOURCE | varchar(5) | FK→PLC_DATA_SOURCES | Job data source |
| 25 | JOB_POINT_NAME | varchar(15) | FK→PLC_TAGS | Job point name |
| 26 | BATCH_INCREMENT_QTY | numeric(20,6) | Batch Increment Quantity | |
| 27 | SPEC_PRODUCTION_RATE | numeric(20,6) | Production Rate | |
| 28 | MOD_BY_TIME | varchar(1) | Modify MPS By Time | |
| 29 | PROCESS_SEQUENCE_NUMBER | int | ||
| 30 | SYS_VERSION_NUMBER | int | PK | Version Number |
| 31 | PM_RECIPE_TYPE | varchar(12) | FK→PM_RECIPE_TYPES | Recipe Type |
| 32 | PM_AUTHORIZATION_GROUP | varchar(6) | FK→PM_AUTHORIZATION_GROUPS | Manufacturing Authorization Group |
| 33 | SYS_CREATOR | varchar(6) | FK→EMPLOYEES | Creator |
| 34 | SYS_CREATION_DATE | datetime | Creation Date | |
| 35 | SYS_MODIFIED_DATE | datetime | Last Modification Date | |
| 36 | SYS_APPROVED_FLAG | varchar(1) | Approved Flag | |
| 37 | EFFECTIVE_ON_DATE | datetime | Effectivity On Date | |
| 38 | EFFECTIVE_OFF_DATE | datetime | Effectivity Off Date | |
| 39 | SEQUENCING_GROUP | varchar(8) | Specification Sequencing Group | |
| 40 | PM_EXEC_APPROVAL_STATUS | varchar(1) | Execution Approval Status | |
| 41 | PM_MFG_APPROVAL_STATUS | varchar(1) | Manufacturing Approval Status | |
| 42 | PM_SHIP_APPROVAL_STATUS | varchar(1) | Shipping Approval Status | |
| 43 | PM_SHIP_APPROVAL_INCL_UNLOT | varchar(1) | Include Unlotted in Shipping Approval Requirement | |
| 44 | PM_SHIP_APPROVAL_INCL_REPL | varchar(1) | Include Replenishable Lots in Shipping Approval Requirement | |
| 45 | GEM_TRANSACTION_ID | varchar(64) | System transaction identifier stamped by GEMBASE when the row was written. | |
| 46 | PRINT_FLAG | varchar(1) | Print Flag | |
| 47 | ES_INQUIRY_GEM_TRANSACTION_ID | varchar(64) | ||
| 48 | SYSTEM_DATE | datetime | System Date Transaction Made | |
| 49 | SYS_CREATE_USER | varchar(20) | User who new this record | |
| 50 | SYS_MODIFY_USER | varchar(20) | The last user who modified this record | |
| 51 | PA_PROJECT_CODE | varchar(10) | PA Project Code | |
| 52 | PA_WBS_NUMBER | varchar(25) | Project WBS Number | |
| 53 | YIELD_UOM | varchar(4) | Yield Unit | |
| 54 | GEM_MODIFY_DATE | datetime | System timestamp of the most recent modification to the row, maintained by GEMBASE. |