All tables
tables · table

manuf_method

The manuf_method table serves as a reference master for manufacturing processes (e.g., Turning, Forging) used within the ERP system. It categorizes specific production techniques by unique codes and names, allowing other modules—such as Job Work, Material Consumption, and Item Master configurations—to specify which manufacturing approach is applied to specific parts or production runs.

Row count
4
Last entry
—
Source
tables

Columns

4
ColumnTypeNullableMeaning
compcodestringNoUnique identifier for the company/entity.
method_codestringNoUnique alphanumeric code for the manufacturing method.
method_namestringYesDescriptive name of the manufacturing process.
indexintegerNoInternal primary key for row-level identification.

Full documentation

### 1. Overview
 The `manuf_method` table serves as a reference master for manufacturing processes (e.g., Turning, Forging) used within the ERP system. It categorizes specific production techniques by unique codes and names, allowing other modules—such as Job Work, Material Consumption, and Item Master configurations—to specify which manufacturing approach is applied to specific parts or production runs.
 
 ### 2. Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **compcode** | string | No | Unique identifier for the company/entity. | e.g., "DAS", "PDS" | Join filter for multi-tenant data. |
 | **method_code** | string | No | Unique alphanumeric code for the manufacturing method. | e.g., "TURN0001", "FORG0001" | Primary key for process identification. |
 | **method_name** | string | Yes | Descriptive name of the manufacturing process. | e.g., "TURNING", "ZFORGING" | Display labels in UI/Reports. |
 | **index** | integer | No | Internal primary key for row-level identification. | | Internal indexing. |
 
 ### 3. Relationships & Join Map
 
 #### Logical Primary Key
 - `compcode`, `method_code` (Composite Key)
 
 #### Downstream Joins (Grounded in SCHEMA_MAP)
 
 | Target Table | Join Columns | Context |
 | :--- | :--- | :--- |
 | **dbo.itemrmchwt** | `compcode`, `method_code` | Linking specific manufacturing methods to raw material weight calculation parameters for items. |
 | **dbo.jobhdr** | `compcode`, `method_code` | Identifying the manufacturing method assigned to a specific production job card/header. |
 | **dbo.mchdr** | `compcode`, `method_code` | Associating a manufacturing method with material consumption headers. |
 | **dbo.tempvlistcon** | `compcode`, `method_code` | (Likely) Temporary table used for vendor-related consumption or production reporting by method. |