wipjobstock

### 1) Overview
 The `wipjobstock` table serves as a snapshot or ledger for Work-In-Progress (WIP) inventory, specifically focusing on items moving through various job work stages (1st stage "ist" and 2nd stage "iind"). It tracks opening and closing balances, production throughput, vendor scrap, and inspection quantities. This table is critical for reconciling stock levels between the internal production floor and external job work vendors.
 
 ### 2) Column dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | No | Primary key / Unique identifier for the record | | Primary Key |
 | **compcode** | string | No | Company code for multi-tenant scoping | e.g., "DAS" | Join; Filter |
 | **itemcode** | string | No | Unique identifier for the manufactured item or part | e.g., "CP-002" | Join; Filter |
 | **opbal** | integer | Yes | Opening balance at the start of the period | | Aggregate |
 | **uiistqty** | integer | Yes | Under Inspection 1st stage quantity | | Aggregate |
 | **uiiindqty** | integer | Yes | Under Inspection 2nd stage (indirect) quantity | | Aggregate |
 | **saleofthemonth** | integer | Yes | Total sales quantity for the current month | | Aggregate |
 | **onlinesc** | integer | Yes | Online Scrap (generated during production) | | Aggregate |
 | **itemreturn** | integer | Yes | Quantity of items returned to WIP | | Aggregate |
 | **semipurchase** | integer | Yes | Quantity of semi-finished items purchased | | Aggregate |
 | **productionist** | integer | Yes | Total quantity produced in the 1st stage | | Aggregate |
 | **jobist** | integer | Yes | Quantity currently out at job work (1st stage) | | Aggregate |
 | **jobiind** | integer | Yes | Quantity currently out at job work (2nd stage) | | Aggregate |
 | **jobgopcs** | integer | Yes | Good pieces received back from job work | | Aggregate |
 | **rejaccept** | integer | Yes | Rejected items that were subsequently accepted | | Aggregate |
 | **recofthemonth** | string | Yes | Record or Recovery identification for the month | | Informational |
 | **ui** | string | Yes | Under Inspection status or identifier | | Filter |
 | **vendscrapqty** | integer | Yes | Quantity of scrap reported by external vendors | | Aggregate |
 | **fgtowip** | integer | Yes | Finished Goods returned to WIP for rework/re-processing | | Aggregate |
 | **clbal** | integer | Yes | Closing balance at the end of the period | | Aggregate |
 
 ---
 
 ### 3) Relationships & join map
 
 The `wipjobstock` table is primarily linked to item and vendor management tables via the `compcode` and `itemcode` composite.
 
 #### Logical Joins:
 * **dbo.itemmas** (via `compcode`, `itemcode`): To retrieve item names, units of measure, and part numbers.
 * **dbo.wipstock** (via `compcode`, `itemcode`): A closely related table likely used for general WIP tracking vs. job-specific tracking.
 * **dbo.temprmreqgen** (via `compcode`, `itemcode`): Shares identical columns (`jobiind`, `jobist`, `onlinesc`, `productionist`); likely used in raw material requirement calculations.
 * **dbo.desp1stjob** (via `compcode`, `itemcode`): To track details of the physical dispatch to 1st stage job workers.
 * **dbo.temprmstockvssale** (via `compcode`, `itemcode`): For stock-to-sales analysis.
 
 #### Likely Constraints:
 * **Foreign Key (Likely)**: `compcode` references `dbo.company (compcode)`.
 * **Foreign Key (Likely)**: `itemcode` references `dbo.itemmas (itemcode)`.