itemoprprod

### 1) Overview
 The `itemoprprod` table serves as a **Production Routing Master**, defining the specific sequence of operations required to manufacture a finished or semi-finished item. It stores operational parameters such as cycle times, process sequence (PIS No), associated machinery, and operation rates. 
 
 This table is critical for calculating production capacity, scheduling floor activities, and determining the standard labor/overhead cost per operation for a specific part.
 
 ### 2) Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | NO | Primary Key. Unique identifier for the row. | 0, 1, 2... | Internal ID |
 | **compcode** | string | NO | Unique code for the company/branch. | e.g., "DAS" | `WHERE compcode = 'DAS'` |
 | **itemcode** | string | NO | Reference to the part or product being manufactured. | e.g., "BC", "CP-001" | Join to `itemmas` |
 | **oprcode** | string | NO | Code identifying the specific operation performed. | e.g., "BC", "HT", "CNC1" | Join to `oprmas` |
 | **oprrate** | number | YES | The financial rate assigned to this operation for costing. | 0.0, 12.5 | Cost Calculation |
 | **drawingno** | string | YES | The engineering drawing number associated with this part/process. | "0", "." | Reference |
 | **pisno** | integer | NO | **Process Instruction Sheet Number.** Defines the sequence of the operation. | 1, 2, 10, 11 | `ORDER BY pisno` |
 | **rivisionno** | number | YES | The revision level of the production process. | 0.0 | Versioning |
 | **cycle** | number | YES | Cycle time required to complete one unit of this operation. | e.g., 28.0 (Seconds/Minutes) | Capacity Planning |
 | **UOM** | string | YES | Unit of Measure for the operation. | "PCS", "KGS" | Quantity conversion |
 | **maccode** | string | YES | Suggested machine code for this operation. | e.g., "BAND", "CNC" | Join to `machine` |
 | **stationcode** | string | YES | Specific work station or cell code. | " " | Join to `oprstationmas` |
 | **oprdetail** | string | YES | Extended description or technical instructions for the operator. | Long text string | Documentation |
 
 ---
 
 ### 3) Relationships & Join Map
 
 The `itemoprprod` table acts as a bridge between the Item Master and the Operation/Machine definitions.
 
 #### Primary Joins (SCHEMA_MAP Grounded):
 * **Item Master**: Join `itemoprprod (itemcode)` to `dbo.itemmas (itemcode)` and `dbo.saleitemmas (itemcode)` to retrieve full part specifications.
 * **Operation Master**: Join `itemoprprod (oprcode)` to `dbo.oprmas (oprcode)` or `dbo.MachineOperation (oprcode)` to get operation names and descriptions.
 * **Machine Master**: Join `itemoprprod (maccode)` to `dbo.machine (mccode)` to identify machine capacity and specifications.
 * **Station Master**: Join `itemoprprod (stationcode)` to `dbo.oprstationmas (stationcode)` for physical location mapping.
 
 #### Likely Joins:
 * **Production Records**: Join `itemoprprod (itemcode, oprcode)` to `dbo.product2 (itemcode, oprcode)` to compare standard cycle times vs. actual production times.
 * **Job Card Details**: Join `itemoprprod (itemcode, oprcode)` to `dbo.jobdtl (itemcode, oprcode)` for subcontracting or work order tracking.
 
 ---