rmvendopr

### 1) Overview
 The `rmvendopr` table acts as a commercial master for Raw Material (RM) processing. It maps specific vendors to the operations they are authorized to perform on specific raw materials, along with the negotiated rates (`oprrate` and `billrate`) and scrap allowances. This table is critical for calculating job work costs and validating vendor invoices during RM processing cycles.
 
 ### 2) Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **compcode** | string | NO | Unique identifier for the company/branch. | e.g., "DAS" | `WHERE compcode = 'DAS'` |
 | **rmcode** | string | NO | Unique identifier for the Raw Material. | e.g., "EN8D17.40H", "SAE-1018" | `JOIN rmmas ON rmcode` |
 | **vendcode** | string | NO | Unique identifier for the Vendor performing the operation. | e.g., "JFPL", "SHYAMI" | `JOIN vendmas ON vendcode` |
 | **oprcode** | string | NO | Code representing the specific process/operation. | e.g., "P" (Process), "BC" (Bar Cutting), "TPD" | `JOIN oprmas ON oprcode` |
 | **oprrate** | number | NO | The internal operation rate per UoM. | e.g., 0.6, 2.8 | `SUM(qty * oprrate)` |
 | **billrate** | number | NO | The actual billing rate charged by the vendor. | Usually same as oprrate | Used for invoice validation. |
 | **UoM** | string | NO | Unit of Measure for the material/operation. | "KGS", "PCS" | `JOIN UoMMaster ON UoM` |
 | **scrapper** | number | YES | Percentage or fixed value of scrap allowed for this operation. | e.g., 1.0, 2.5 | `(weight * scrapper / 100)` |
 
 ### 3) Relationships & Join Map
 
 #### Primary Master Relationships
 * **rmmas**: Joins on `compcode` and `rmcode` to retrieve raw material specifications (Grade, Size).
 * **vendmas**: Joins on `compcode` and `vendcode` to retrieve vendor details (Name, GST).
 * **oprmas**: Joins on `compcode` and `oprcode` to identify the nature of the operation.
 
 #### Transactional & Procedural Joins (Grounded in SCHEMA_MAP & REFERENCE_JSON)
 * **rmjobhdr**: Joins on `compcode`, `rmcode`, and `vendcode`. Used to link job cards to the correct vendor rates.
 * **rmmrpdtl**: Joins on `compcode` and `oprcode`. Used in financial monitoring to calculate `JobworkAmt`.
 * **rmmrphdr**: Joins on `compcode` and `vendcode`. Used in `FinancialMonitoringStatus` to aggregate total work value.
 * **UoMMaster**: Joins on `compcode` and `UoM` (mapping to `PUoM` or `CUoM`) for unit conversions.
 
 ---