rmstockbeforedrawcon

### 1) Overview
 The `rmstockbeforedrawcon` table serves as a snapshot or calculation ledger for Raw Material (RM) stock levels specifically categorized "before drawing" or conversion processes. It aggregates opening balances, incoming receipts, job-related issues, machine consumption, returns, and sales to determine the current balance weight (`balwt`) and its associated financial value. This table is critical for inventory reconciliation and material requirement planning (MRP) within the manufacturing lifecycle.
 
 ### 2) Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | No | Primary key / Internal row identifier | | Primary Key |
 | **compcode** | string | No | Unique identifier for the company/branch | e.g., "DAS" | Join Key |
 | **rmcode** | string | No | Unique identifier for the Raw Material | e.g., "15B2511MM" | Join Key |
 | **opwt** | number | Yes | Opening weight at the start of the period | | Aggregate / Math |
 | **incwt** | number | Yes | Total incoming weight (receipts) | | Aggregate / Math |
 | **jobwt** | number | Yes | Weight issued to jobs/production | | Aggregate / Math |
 | **mcwt** | number | Yes | Weight consumed by machines | | Aggregate / Math |
 | **retwt** | number | Yes | Weight returned to the store | | Aggregate / Math |
 | **job_drawwt** | number | Yes | Weight processed via drawing for jobs | | Aggregate / Math |
 | **sale_wt** | number | Yes | Weight sold directly | | Aggregate / Math |
 | **balwt** | number | Yes | Current balance weight (Closing stock) | | Filter / Display |
 | **rmrate** | number | Yes | Unit rate of the raw material | | Financial Math |
 | **rmvalue** | number | Yes | Total valuation of the balance (`balwt * rmrate`) | | Reporting |
 | **recddrawwt** | number | Yes | Received drawing weight (post-processing) | | Aggregate / Math |
 | **rejwt** | number | Yes | Rejected material weight | | Quality Reporting |
 | **trfwt** | string | Yes | Weight transferred between locations/status | | Likely Audit |
 
 ### 3) Relationships & Join Map
 
 The table is a central point for RM stock auditing and relates to master data and transactional records via company and material codes.
 
 #### Mandatory Joins
 * **dbo.rmmas**: Joined on `compcode` and `rmcode` to retrieve master material details (RM name, grade, type).
 * **dbo.rmincoming**: Joined on `compcode` and `rmcode` to audit `incwt` against specific purchase/receipt transactions.
 
 #### Process Joins
 * **dbo.itemmas**: Joined on `compcode` and `rmcode` to link raw materials to finished or semi-finished items that consume them.
 * **dbo.rmreturn**: Joined on `compcode` and `rmcode` to reconcile the `retwt` column.
 * **dbo.rmjobhdr**: Joined on `compcode` and `rmcode` to track materials issued to specific job cards.
 * **dbo.temprmreqgen**: Joined on `compcode` and `rmcode` for real-time material requirement generation based on current balances.