rmincomingcoil

### 1. Overview
 The `rmincomingcoil` table is a granular inventory tracking entity used in the Raw Material (RM) management system. It manages the specific details of individual sub-coils derived from larger material receipts (identified by `mrpno`). This table tracks physical properties (weight, heat number), quality metrics (UTS, hardness), and processing status (rejection, closing flags). It serves as a bridge between high-level material intake (`rmincoming`) and machine-level consumption (`mchdrcoil`).
 
 ### 2. Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | NO | Internal primary key. | Auto-increment | Primary Key |
 | **compcode** | string | NO | Company identifier code. | e.g., "DAS", "SF1" | Join Key (Global) |
 | **mrpno** | integer | NO | Material Receipt Plan number. | | Join Key to `rmincoming` |
 | **coilno** | string | YES | The parent coil identifier. | | Reference for traceability |
 | **subcoilno** | string | YES | Unique identifier for a subdivided coil. | e.g., "-1", "-2" | Join Key for consumption |
 | **subcoilwt** | number | YES | The specific weight of the sub-coil. | | Mass balance calculations |
 | **close_flag** | string | YES | Status indicating if the coil is fully consumed. | 'Y' (Closed), ' ' | Filter for stock |
 | **type** | string | YES | Classification of the coil material. | e.g., 'P' | Filter |
 | **rmcode** | string | YES | Raw Material Item Code. | | Join Key to `rmmas` |
 | **heatno** | string | YES | Metallurgical heat number for quality tracking. | | Quality/Traceability |
 | **rejflag** | string | YES | Rejection status flag. | 'Y' (Rejected), ' ' | QC Filtering |
 | **actualwt** | string | YES | Recorded actual weight (Likely used if different from subcoilwt). | | Auditing |
 | **fgsflag** | string | YES | Finished Goods status flag (Likely). | | QC status |
 | **UTS** | string | YES | Ultimate Tensile Strength measurement. | | Material Quality |
 | **Quenchhardness** | string | YES | Hardness value after quenching process. | | Material Quality |
 
 ### 3. Relationships & Join Map
 
 #### Logical Relationships
 * **Parent Material Receipt:** Each record belongs to a parent receipt tracked in `dbo.rmincoming` or `dbo.rmmrphdr` via `mrpno`.
 * **Item Definition:** The `rmcode` links to `dbo.rmmas` for master material descriptions and specifications.
 * **Machine Consumption:** Sub-coils are issued to machines and tracked via `dbo.mcdtlcoilselected`.
 
 #### Mandatory Joins (SCHEMA_MAP Verified)
 
 **1. Raw Material Incoming Details**
 * **Table:** `dbo.rmincoming`
 * **Join Column:** `mrpno`, `compcode`
 * **Context:** Retrieving supplier information and parent receipt dates.
 
 **2. Sub-Coil Selection/Consumption**
 * **Table:** `dbo.mcdtlcoilselected` (Inferred via Reference SPs)
 * **Join Column:** `subcoilno`, `compcode`
 * **Context:** Used in `RMMRPBalance` and `viewtotalcoilwtissued` to track which specific coils have been issued to production.
 
 **3. Raw Material Master**
 * **Table:** `dbo.rmmas`
 * **Join Column:** `rmcode`, `compcode`
 * **Context:** Fetching RM Grade, Size, and Name for reporting.
 
 **4. Material Returns**
 * **Table:** `dbo.rmreturncoil` (Inferred via Reference SPs)
 * **Join Column:** `subcoilno` (maps to `subcoilnor`), `compcode`
 * **Context:** Calculating stock balance by subtracting returned sub-coil weights.