rmmrphdr

### 1. Overview
 The `rmmrphdr` table serves as the **Raw Material Material Receipt Header**. It primarily tracks the receipt of raw materials following specific processes, most notably "Drawing" operations performed either in-house or by external vendors. It captures quantitative data (received, accepted, rejected, and scrap quantities), quality-related metadata (Heat Numbers, Trace Numbers), and links material transactions to job cards and vendor bills.
 
 In the workflow, this table acts as the entry point for drawn material back into the inventory system, facilitating the reconciliation between material issued for job work (`rmjobhdr`) and material received back.
 
 ### 2. Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | No | Primary key / unique row identifier | | PK |
 | **compcode** | string | No | Company identifier | e.g., "DAS" | FK (Common Join) |
 | **mrpno** | integer | No | Material Receipt Number | 85, 1158 | FK (Unique ID for Receipt) |
 | **mrpdate** | datetime | No | Date of the material receipt | | Filter, Audit |
 | **rgpno** | integer | Yes | Returnable Gate Pass number | | Join to `rgphdr` |
 | **billno** | integer | Yes | Vendor bill or invoice number | 215, 977 | Documentation |
 | **billdate** | datetime | Yes | Date of the vendor bill | | Audit |
 | **gpno** | integer | Yes | Gate Pass Number | 21, 1 | Audit |
 | **gpdate** | datetime | Yes | Gate Pass Date | | Audit |
 | **jobcardno** | integer | Yes | Associated Job Card Number | 20131284 | Join to `rmjobhdr`, `jobhdr` |
 | **irno** | integer | Yes | Inspection Report Number | 296, 0 | Join to `rminspectionreport` |
 | **irdate** | datetime | Yes | Date of inspection | | Audit |
 | **totalwtrec** | number | Yes | Total weight received | | Quantitative analysis |
 | **vendcode** | string | Yes | Vendor code | e.g., "RS", "BALAJI" | Join to `vendmas` |
 | **qtyrecd** | number | Yes | Quantity received from vendor/process | | Quantitative analysis |
 | **qtyacpt** | number | Yes | Quantity accepted after inspection | | Calculation of net stock |
 | **qtyrej** | number | Yes | Quantity rejected | | Rejection analysis |
 | **qtyscrap** | number | Yes | Quantity identified as scrap | | Scrap analysis |
 | **wtacpt** | number | Yes | Weight accepted | | Quantitative analysis |
 | **wtrej** | number | Yes | Weight rejected | | Quantitative analysis |
 | **scrapwt** | number | Yes | Weight of scrap material | | Quantitative analysis |
 | **lotno** | string | Yes | Batch or Lot identifier | | Join to `rmproduct1` |
 | **qtych** | number | Yes | Quantity as per Challan | | Reconciliation |
 | **wtch** | number | Yes | Weight as per Challan | | Reconciliation |
 | **wtadj** | number | Yes | Weight adjustment value | | Correction |
 | **rmcodereq** | string | Yes | Raw Material code requested/processed | e.g., "ROD25.2" | Join to `rmmas` |
 | **username** | string | Yes | Internal system user | | Audit |
 | **useradd** | string | Yes | User who added the record | | Audit |
 | **addtime** | string | Yes | Timestamp of record creation | | Audit |
 | **usermod** | string | Yes | User who last modified the record | | Audit |
 | **modtime** | string | Yes | Timestamp of last modification | | Audit |
 | **printflag** | string | Yes | Indicates if document was printed | | Internal tracking |
 | **noofcoil** | string | Yes | Number of coils received | | Physical tracking |
 | **rmstatus** | string | Yes | Material status code | e.g., "H" (Likely Hold/History) | Logic filter |
 | **heatno** | string | Yes | Metallurgical heat number for traceability | | FK to `rmincomingcoil` |
 | **location** | string | Yes | Storage location | | Join to `location` |
 | **Modreason** | string | Yes | Reason for record modification | | Audit |
 | **TraceNo** | string | Yes | System traceability number | | Audit |
 | **nOprCode** | string | Yes | Next operation code or current op code | | Join to `oprmas` |
 
 ### 3. Relationships & Join Map
 
 #### Joins (Authoritative)
 * **vendmas**: Join `vendcode` to `vendmas.vendcode` to retrieve vendor names and GST details.
 * **rmmas**: Join `rmcodereq` to `rmmas.rmcode` to get material descriptions, grades, and sizes.
 * **rmjobhdr**: Join `jobcardno` to `rmjobhdr.jobcardno`. This is the primary parent relationship for "Draw" operations where material is issued.
 * **rmmrpdtl**: Join `mrpno` and `compcode` to `rmmrpdtl.mrpno` and `rmmrpdtl.compcode` for item-level operation details.
 * **rmincomingcoil**: Join `mrpno` and `heatno` to `rmincomingcoil.mrpno` and `rmincomingcoil.heatno` for coil-level weight tracking.
 * **billagainstwo**: Join `jobcardno` to `billagainstwo.jobno` to reconcile material losses and adjustments.
 * **oprmas**: Join `nOprCode` to `oprmas.oprcode` to identify the specific process or machine operation.
 * **pdiinspectionhdr**: Join `mrpno` to `pdiinspectionhdr.RMMRPNo` for quality control linkage.
 
 #### Likely Joins (Inferred)
 * **location**: Join `location` to `location.loccode` to determine the physical warehouse or department.
 * **mrprejhdr**: Join `mrpno` and `jobcardno` to `mrprejhdr.mrpno` and `mrprejhdr.jobno` to track rejected material returns.