mrci_rep

### 1) Overview
 The `mrci_rep` table is a core transaction table used for tracking **Material Receipt and Inspection** for subcontracted (jobwork) items. It specifically handles the return of processed items from vendors after subsequent manufacturing operations (often referred to in the system as "JIind" or "MRP2nd" stages).
 
 This table records the quantities received from vendors, the results of quality inspections (accepted, rejected, and scrap quantities), and traceability data such as Lot Numbers and Heat Numbers. It serves as a bridge between jobwork issuance and either further internal processing or movement to Finished Goods (FG).
 
 ### 2) Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | NO | Primary Key | | PK |
 | **compcode** | string | NO | Company identifier | e.g., "DAS", "BAM" | Join to `vendmas`, `itemmas` |
 | **mrpno** | integer | NO | Material Receipt Plan/Note Number | | Unique ID for receipt |
 | **mrpdate** | datetime | YES | Date of material receipt | | Filter/Reporting |
 | **rgpno** | integer | YES | Returnable Gate Pass Number | | Links back to issuance |
 | **billno** | integer | YES | Vendor's Bill or Invoice Number | | Reconciliation |
 | **billdate** | datetime | YES | Date on the vendor's bill | | Reconciliation |
 | **gpno** | integer | YES | Gate Pass Number (Inward) | | Logistics tracking |
 | **jobno** | integer | YES | Reference to the Job issuance record | | Join to `dbo.job` |
 | **irno** | integer | YES | Inspection Report Number | | Link to Quality records |
 | **chqty** | number | YES | Quantity mentioned on Vendor Challan | | Variance analysis |
 | **qtyreceive** | number | YES | Actual quantity received physically | | Inventory input |
 | **acptqty** | number | YES | Quantity accepted after inspection | | **Critical:** Net stock gain |
 | **rejqty** | number | YES | Quantity rejected during inspection | | Quality analysis |
 | **scrapqty** | number | YES | Quantity declared as scrap by vendor/QC | | Loss accounting |
 | **vendcode** | string | YES | Vendor identifier | e.g., "AGI", "BPPL" | Join to `dbo.vendmas` |
 | **lotno** | string | YES | Internal traceability lot number | | Traceability |
 | **sublotno** | string | YES | Detailed lot subdivision | | Traceability |
 | **heatno** | string | YES | Raw material heat number | | Traceability |
 | **itemcode** | string | YES | Item identifier | | Join to `dbo.itemmas` |
 | **final_status**| integer | YES | Workflow status (WIP vs Final) | 0: WIP, 1: Final | Logic filtering |
 | **nextoprcode** | string | YES | The next required operation | e.g., "FINAL", "CLOSE" | Join to `dbo.oprmas` |
 | **packqty** | integer | YES | Quantity per packaging unit | | Logistics |
 | **useradd** | string | YES | User who created the record | | Audit |
 | **addtime** | string | YES | Creation timestamp | | Audit |
 
 ### 3) Relationships & Join Map
 
 The `mrci_rep` table is a junction for jobwork reconciliation and stock updates.
 
 | Target Table | Join Columns | Relationship |
 | :--- | :--- | :--- |
 | **dbo.job** | `jobno` (`mrci_rep`), `jobno` (`job`) | **Authoritative:** Links received processed items back to the original job issuance. |
 | **dbo.mrci2dtl** | `mrpno` (`mrci_rep`), `mrpno` (`mrci2dtl`) | **One-to-Many:** Links receipt header to specific operation/value details. |
 | **dbo.itemmas** | `itemcode` (`mrci_rep`), `itemcode` (`itemmas`) | **Authoritative:** Retrieves item descriptions and unit weights. |
 | **dbo.vendmas** | `vendcode` (`mrci_rep`), `vendcode` (`vendmas`) | **Authoritative:** Retrieves vendor details (name, GST, address). |
 | **dbo.oprmas** | `nextoprcode` (`mrci_rep`), `oprcode` (`oprmas`) | Retrieves the description of the next manufacturing step. |
 | **dbo.billagainstwo** | `jobno` (`mrci_rep`), `jobno` (`billagainstwo`) | Links receipt to financial adjustments/work orders. |
 | **dbo.mrprejhdr** | `mrpno` (`mrci_rep`), `mrpno` (`mrprejhdr`) | Links rejected quantities to formal rejection documentation. |
 
 ### Summary