PART_MASTER_M
Manufacturing Part Master
tableMANPART
PART_MASTER_M — Manufacturing Part Master. MAN table in the standard Ross ERP 8.0 schema: 59 columns, used by 100 programs. Columns, data types, keys, foreign keys and relationships.
Open PART_MASTER_M 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 | WAREHOUSE | varchar(2) | PK | Warehouse Code |
| 4 | PART_CODE | varchar(15) | PK | Product |
| 5 | TABLE_ID_M | varchar(1) | PK | Table Identifier |
| 6 | BOM_LOW_LEVEL_CODE | smallint | BOM Low Level Code | |
| 7 | DRAWING_NUMBER | varchar(15) | Blueprint/Drawing Number | |
| 8 | ENGINEERING_CHANGE_NUMBER | varchar(10) | Engineering Change Number | |
| 9 | PENDING_ENG_CHANGE_DATE | datetime | Pending Engineering Change Date | |
| 10 | PENDING_ENG_CHANGE_CODE | varchar(1) | Pending Engineering Change Code | |
| 11 | PENDING_ENG_CHANGE_NUMBER | varchar(10) | Pending Engineering Change Number | |
| 12 | MANU_ACT_RUNTIME_INC | numeric(20,3) | Actual Runtime (Incremental) | |
| 13 | MANU_ACT_RUNTIME_ACC | numeric(20,3) | Actual Runtime (Accumulative) | |
| 14 | MANU_ACT_SETUP_INC | numeric(20,3) | Actual Setup (Incremental) | |
| 15 | MANU_ACT_SETUP_ACC | numeric(20,3) | Actual Setup (Accumulative) | |
| 16 | MANU_STD_RUNTIME_INC | numeric(20,3) | Standard Runtime (Incremental) | |
| 17 | MANU_STD_RUNTIME_ACC | numeric(20,3) | Standard Runtime (Accumulative) | |
| 18 | MANU_STD_SETUP_INC | numeric(20,3) | Standard Setup (Incremental) | |
| 19 | MANU_STD_SETUP_ACC | numeric(20,3) | Standard Setup Time (Accumulative) | |
| 20 | MANU_STD_MOVETIME_ACC | numeric(20,3) | Standard Move Time (Accumulative) | |
| 21 | MANU_STD_MOVETIME_INC | numeric(20,3) | Standard Movetime (Incremental) | |
| 22 | MANU_ACT_MOVETIME_ACC | numeric(20,3) | Actual Movetime (Accumulative) | |
| 23 | MANU_ACT_MOVETIME_INC | numeric(20,3) | Actual Movetime (Incremental) | |
| 24 | MANU_BATCH_SIZE | numeric(20,6) | Manufacturing Batch Size | |
| 25 | COST_CATEGORY | varchar(2) | FK→COST_CATEGORIES | Cost Category |
| 26 | OH_ALLOCATION_REQD | varchar(1) | Overhead Allocation Required | |
| 27 | PART_OH_ALLOCATION_FLAG | varchar(1) | Overhead Allocation Flag | |
| 28 | OH_ALLOCATION_PERCENT | numeric(5,2) | Overhead Allocation Percentage | |
| 29 | OH_ALLOCATION_COST | numeric(20,4) | Overhead Allocation Cost | |
| 30 | CONV_TO_PLANNING_UNIT | numeric(20,4) | Conversion to Planning UOM | |
| 31 | STD_PRODUCT_SPEC | varchar(10) | Product Specification (std) | |
| 32 | OH_COST_CATEGORY | varchar(2) | FK→COST_CATEGORIES | Overhead Cost Category |
| 33 | GL_WIP_CODE | varchar(6) | GL Short Code - Work in Progress | |
| 34 | GL_WIP_ACCOUNT | varchar(50) | GL WIP Account | |
| 35 | UNIT_OH_ALLOCATION | varchar(4) | Unit of measure for overhead allocation | |
| 36 | COSTING_PROCESS_SPEC | varchar(15) | ||
| 37 | PLANNING_PROCESS_SPEC | varchar(15) | ||
| 38 | COSTING_FACTORY | varchar(2) | ||
| 39 | PLANNING_FACTORY | varchar(2) | ||
| 40 | MANU_LEAD_TIME | numeric(10,3) | Manufacture Lead Time | |
| 41 | RESOURCE_GROUP_CODE | varchar(6) | Resource Group | |
| 42 | PLANNING_PRODUCT | varchar(15) | ||
| 43 | GL_PART_OH_REC_ACCOUNT | varchar(50) | GL Overhead Recovery Account | |
| 44 | GL_PART_OH_REC_CODE | varchar(6) | GL Overhead Recovery Code | |
| 45 | STD_PRODUCT_SPEC_VERSION | int | ||
| 46 | PLANNING_PROCESS_SPEC_VERSION | int | FK→PROCESS_SPECIFICATIONS | |
| 47 | COSTING_PROCESS_SPEC_VERSION | int | FK→PROCESS_SPECIFICATIONS | |
| 48 | PM_FORMULA_CODE | varchar(6) | Formula code for UOM conversions and dependency. | |
| 49 | GL_PART_OH_REC_OFFSET_ACCT | varchar(50) | ||
| 50 | GL_PART_OH_REC_OFFSET_CODE | varchar(6) | ||
| 51 | RCS_CONVERSION_STATUS | varchar(1) | Ren/CS Data Conversion Status | |
| 52 | SCM_INCLUDE_IN_APS | varchar(1) | Include Product in SCM APS Integration | |
| 53 | GEM_TRANSACTION_ID | varchar(64) | System transaction identifier stamped by GEMBASE when the row was written. | |
| 54 | DEFAULT_YIELD | numeric(5,2) | ||
| 55 | PARENT_WAREHOUSE | varchar(2) | Parent Warehouse Code | |
| 56 | PARENT_PRODUCT | varchar(15) | Parent Product | |
| 57 | BACKFLUSH_LOCATION | varchar(15) | Bin location for backflush | |
| 58 | BACKFLUSH_LPN | varchar(30) | ||
| 59 | INCLUDE_IN_PT | varchar(1) | Include Process Spec in PlanetTogether |