rmmrpdtl

### 1) Overview
 The `rmmrpdtl` table serves as the granular transaction log for raw material processing and receipt operations. It records the specific quantities (accepted, rejected, and scrapped), weights, and financial rates associated with an operation performed under a Material Receipt/Process (MRP) number. It is primarily used to track job work performed by vendors or internal departments, bridging the gap between raw material job cards (`rmjobhdr`) and the material receipt headers (`rmmrphdr`).
 
 ### 2) Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | NO | Unique internal identifier (Primary Key). | | Row identification. |
 | **compcode** | string | NO | Company code for multi-tenant isolation. | e.g., "DAS", "BAM" | Filter/Join (with most tables). |
 | **mrpno** | integer | NO | Material Receipt/Process Number. | | Join to `rmmrphdr(mrpno)`. |
 | **rmcodereq** | string | YES | The specific raw material grade/code requested. | e.g., "ROD39.50", "RB" | Join to `rmmas(rmcode)`. |
 | **oprcode** | string | YES | Operation code representing the type of work done. | e.g., "P", "TPD" | Join to `oprmas(oprcode)`. |
 | **qtyacpt** | integer | YES | Quantity of pieces accepted during the transaction. | | Calculation of throughput/yield. |
 | **qtyrej** | integer | YES | Quantity of pieces rejected during the transaction. | | Quality analysis. |
 | **acptwt** | integer | YES | Total weight of the accepted items. | | Weight-based inventory tracking. |
 | **wtrej** | number | YES | Total weight of the rejected items. | | Scrap/loss calculation. |
 | **oprrate** | number | YES | The monetary rate applied to this specific operation. | | Costing/Bill generation. |
 | **jobcardno** | integer | YES | Reference to the production job card. | | Join to `rmjobhdr(jobcardno)`. |
 | **mrpdate** | datetime | YES | Date of the material receipt or operation entry. | | Temporal reporting/Audit. |
 | **itemcode** | string | YES | Finished or semi-finished item code (if applicable). | | Join to `itemmas(itemcode)`. |
 | **lotno** | string | YES | Tracking number for the specific batch/lot. | | Batch traceability. |
 | **wooprqty** | integer | YES | Work Order Operation Quantity. | | Work order planning vs actual. |
 | **rej_flag** | string | YES | Indicator if a rejection exists for this line. | 'N', 'Y' | Quick filtering. |
 | **vendcode** | string | YES | Code of the vendor/department performing the work. | e.g., "BALAJI", "RS" | Join to `vendmas(vendcode)`. |
 
 ---
 
 ### 3) Relationships & Join Map
 
 The `rmmrpdtl` table acts as a transactional junction between procurement, production, and quality modules.
 
 #### Authoritative Joins (via SCHEMA_MAP):
 * **rmmrphdr**: `rmmrpdtl.mrpno = rmmrphdr.mrpno` AND `rmmrpdtl.compcode = rmmrphdr.compcode`
  * *Usage*: Linking detail lines to the material receipt header for vendor and document info.
 * **rmjobhdr**: `rmmrpdtl.jobcardno = rmjobhdr.jobcardno` AND `rmmrpdtl.compcode = rmjobhdr.compcode`
  * *Usage*: Tracking raw material usage against a specific production job.
 * **oprmas**: `rmmrpdtl.oprcode = oprmas.oprcode` AND `rmmrpdtl.compcode = oprmas.compcode`
  * *Usage*: Retrieving the full operation name and station details.
 * **vendmas**: `rmmrpdtl.vendcode = vendmas.vendcode` AND `rmmrpdtl.compcode = vendmas.compcode`
  * *Usage*: Validating vendor profiles and GST details for job work auditing.
 * **rmmas**: `rmmrpdtl.rmcodereq = rmmas.rmcode` AND `rmmrpdtl.compcode = rmmas.compcode`
  * *Usage*: Fetching raw material technical specifications (size, grade).
 
 #### Likely Joins (Inferred from Usage):
 * **rmincomingcoil**: `rmmrpdtl.mrpno = rmincomingcoil.mrpno` (Likely used to track specific coils received under an MRP).
 * **billagainstwo**: `rmmrpdtl.jobcardno = billagainstwo.jobno` (Likely for processing invoices for job work done).