temprmstockvssale

### 1) Overview
 The `temprmstockvssale` table is a temporary reporting or calculation table used to analyze the lifecycle of Raw Materials (RM). It tracks the transition of material weights from opening stock through various job stages (Stage 1 and Stage 2 job work), captures purchase inputs, and compares them against final sales output. This table is likely used for reconciliation, material requirement planning, or inventory audit reports to identify discrepancies between material input and sales output.
 
 ### 2) Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | NO | Primary key; unique record identifier. | | `PRIMARY KEY` |
 | **compcode** | string | YES | Company identifier used for multi-tenant data separation. | e.g., "DAS" | `JOIN`, `WHERE` |
 | **rmcode** | string | YES | The unique code identifying the Raw Material. | e.g., "EN8D18.00M" | `JOIN`, `GROUP BY` |
 | **rmstockwtop** | number | YES | Raw Material Opening Stock weight at the beginning of the period. | | `SUM`, `CALCULATION` |
 | **sfstockwtop** | number | YES | Semi-Finished Opening Stock weight associated with this RM. | | `SUM` |
 | **jobistwtop** | number | YES | Opening weight of material currently at the 1st stage of Jobwork. | | `SUM` |
 | **jobiindwtop** | number | YES | Opening weight of material currently at the 2nd stage of Jobwork. | | `SUM` |
 | **rmpurwt** | number | YES | Total weight of Raw Material purchased during the reporting period. | | `SUM` |
 | **salewt** | number | YES | Total weight of finished goods sold derived from this RM. | | `SUM` |
 | **jobistwtcl** | number | YES | Closing weight of material at the 1st stage of Jobwork. | | `SUM` |
 | **jobiindwtcl** | number | YES | Closing weight of material at the 2nd stage of Jobwork. | | `SUM` |
 
 ---
 
 ### 3) Relationships & Join Map
 
 The table serves as a bridge between Raw Material masters, stock ledgers, and sales registers.
 
 #### Joins (Strictly based on SCHEMA_MAP)
 
 * **dbo.rmmas**: Join on `compcode` and `rmcode` to retrieve specific material attributes like RM Grade, RM Type, or HSN codes.
 * **dbo.itemmas**: Join on `compcode` and `rmcode` to identify which finished items utilize this specific raw material.
 * **dbo.rmstock**: Join on `compcode` and `rmcode` to compare these temporary calculations against the physical RM stock ledger.
 * **dbo.rmincoming**: Join on `compcode` and `rmcode` to audit `rmpurwt` against specific purchase invoices/gate entries.
 * **dbo.temprmreqgen**: (Likely) Join on `compcode` and `rmcode` as both tables appear to be part of the same Material Requirement Planning (MRP) or Stock Status reporting suite.
 
 ---