wipstock

### 1) Overview
 The `wipstock` table serves as a comprehensive ledger for tracking Work-In-Progress (WIP) inventory levels across various production and subcontracting stages. It records opening balances, production inputs, vendor-related transfers (issues and receipts), job work statuses, and final transfers to Finished Goods (`trfToFG`). This table is essential for calculating real-time inventory positions and monitoring the flow of materials through the manufacturing lifecycle.
 
 ### 2) Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | No | Primary Key | 0, 1, 2... | PK |
 | **compcode** | string | No | Unique identifier for the company | e.g., "DAS" | FK |
 | **itemcode** | string | No | Unique identifier for the manufactured or processed item | e.g., "GPDTVS", "CP-037" | FK |
 | **opbal** | integer | Yes | Opening balance of the item in WIP at the start of the period | | Numeric |
 | **vendorist** | integer | Yes | Quantity issued to vendor in Stage 1 | | Numeric |
 | **vendoriind** | integer | Yes | Quantity in-house from vendor in Stage 2 | | Numeric |
 | **clvendorist** | string | Yes | Closing balance at Vendor Stage 1 | | Meta |
 | **clvendoriind** | string | Yes | Closing balance at Vendor Stage 2 | | Meta |
 | **uiistqty** | string | Yes | Under Inspection Stage 1 Quantity | | Meta |
 | **uiiindqty** | string | Yes | Under Inspection Stage 2 Quantity | | Meta |
 | **saleofthemonth**| string | Yes | Sales total for the current month | | Meta |
 | **onlinesc** | integer | Yes | Online Scrap quantity generated during production | | Numeric |
 | **itemreturn** | string | Yes | Quantity of items returned | | Meta |
 | **semipurchase** | integer | Yes | Quantity of semi-finished items purchased | | Numeric |
 | **productionist** | integer | Yes | Production In-Stage quantity | | Numeric |
 | **jobist** | integer | Yes | Job Work Issued In-Stage | | Numeric |
 | **jobiind** | integer | Yes | Job Work In-house In-Indent | | Numeric |
 | **rejaccept** | string | Yes | Quantity of rejected items accepted back | | Meta |
 | **recofthemonth** | string | Yes | Receipts for the month | | Meta |
 | **ui** | string | Yes | Under Inspection (General) | | Meta |
 | **vendscrapqty** | string | Yes | Scrap quantity reported by vendors | | Meta |
 | **fgtowip** | integer | Yes | Finished Goods returned to WIP for rework | | Numeric |
 | **rgpqty** | number | Yes | Returnable Gate Pass quantity | | Numeric |
 | **jobiindout** | number | Yes | Job Work In-house Outbound quantity | | Numeric |
 | **SaleRej** | number | Yes | Sales Rejection quantity | | Numeric |
 | **wip** | number | Yes | Final calculated Work-In-Progress quantity | | Balance |
 | **trfToFG** | number | Yes | Quantity transferred to Finished Goods inventory | | Numeric |
 | **converqty** | number | Yes | Conversion adjustment quantity | | Adjustment |
 
 ### 3) Relationships & Join Map
 
 The `wipstock` table is a central node for inventory reporting and joins primarily on Item and Company identifiers.
 
 #### Primary Joins (SCHEMA_MAP Grounded):
 * **dbo.itemmas (itemcode):** To retrieve item descriptions, part numbers, and category details.
 * **dbo.wipjobstock (itemcode):** Highly likely to be a parallel table for detailed job-specific WIP tracking.
 * **dbo.itemledger (itemcode):** To reconcile WIP movements against the general item ledger.
 * **dbo.company (compcode):** To link stock data to specific company entities.
 * **dbo.desp1stjob (itemcode):** To track WIP movements related to subcontracted job work.
 
 #### Join Logic:
 ```sql
 SELECT a.itemcode, b.itemname, a.wip, a.trfToFG
 FROM wipstock a
 JOIN itemmas b ON a.itemcode = b.itemcode AND a.compcode = b.compcode
 LEFT JOIN wipjobstock c ON a.itemcode = c.itemcode AND a.compcode = c.compcode
 ```