tmpmrpdtl

### 1) Overview
 The `tmpmrpdtl` table serves as a temporary detail repository for Material Requirement Planning (MRP) or Manufacturing Receipt processes. It captures specific operation-level details (such as machine operations like CNC) associated with a parent MRP transaction record. Each record link identifies the company, the specific MRP transaction number, and the operation performed.
 
 ### 2) Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | NO | Primary key (Internal/System generated) | | Primary Key |
 | **compcode** | string | YES | Unique identifier for the company | "DAS" | Join key to `dbo.company` |
 | **mrpno** | integer | YES | Material Requirement Planning / Manufacturing Receipt Number | 355205, 355207 | Join key to `tmpmrphdr`, `jobhdr` |
 | **oprcode** | string | YES | Operation Code (Process step) | "CNC1", "CNC2" | Join key to `oprmas`, `itemopr` |
 | **oprweight** | string | YES | Weight recorded during the operation | | Metric for production tracking |
 
 ### 3) Relationships & Join Map
 
 The table functions as a detail child to several header-level manufacturing and invoicing tables.
 
 #### Primary Joins (Authoritative):
 * **dbo.tmpmrphdr**: Joins on `mrpno` and `compcode` to retrieve header-level status and item info.
 * **dbo.oprmas**: Joins on `oprcode` and `compcode` to get the descriptive name and station of the operation.
 * **dbo.itemopr**: Joins on `oprcode` and `compcode` to validate operation parameters against specific items.
 * **dbo.jobhdr**: Joins on `mrpno` and `compcode` to link production operations to job cards.
 
 #### Downstream Joins (Likely):
 * **dbo.invdtl / dbo.Performainvdtl**: Joins on `mrpno` to link manufacturing process details to final billing or proforma invoices.
 * **dbo.MachineOperation**: Joins on `oprcode` and `compcode` to identify which machines (`mccode`) are capable of the specified operation.