itemmas

### 1. Overview
 The `itemmas` table serves as the central Item Master for the ERP system. It stores technical specifications, costing rates, weight parameters, and classification data for all items, including finished goods, semi-finished components, and assembly parts. It is heavily utilized across production (WIP), inventory management, and sales modules to provide descriptive details and weight-based calculations for material consumption and realization reports.
 
 ### 2. Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | No | Primary key index | | Primary key |
 | **compcode** | string | No | Company Code | e.g., 'DAS', 'RF2' | Join key for multi-tenancy |
 | **itemcode** | string | No | Unique Item Identifier | e.g., '0032', '0148' | Primary business key for joins |
 | **itemname** | string | Yes | Name/Description of the Item | | Used for reporting and labels |
 | **uom** | string | Yes | Unit of Measure | PCS, NOS, KGS | Transactional unit |
 | **itemrate** | number | Yes | Unit Rate/Cost | | Used in valuation/costing |
 | **debitrate** | string | Yes | Rate used for debit notes | | Likely costing-related |
 | **cheesewt** | number | Yes | Gross weight/Input weight | | Used in material utilization |
 | **finishwt** | number | Yes | Finished weight per piece | | Used to calculate total weight |
 | **conversionwt**| number | Yes | Process conversion weight | | Realization calculations |
 | **partno** | string | Yes | Manufacturer/Customer Part Number | | Secondary identifier for customers |
 | **rmcode** | string | Yes | Linked Raw Material Code | | Join to `rmmas` |
 | **scraprate** | number | Yes | Scrap value rate | | Costing of wastage |
 | **ercode** | string | Yes | Engineering Revision Code | | Version control |
 | **erdrawno** | string | Yes | Engineering Drawing Number | | Quality/Design reference |
 | **username** | string | Yes | Record creator/modifier | | Audit trail |
 | **dis_flag** | string | Yes | Discontinued/Disabled Flag | Y, N | Filter for active items |
 | **itemtype** | string | Yes | Classification of item type | | Filtering |
 | **itemgroup** | string | Yes | Group category | I (Finished), J, S | High-level categorization |
 | **taxrate** | number | Yes | GST/Tax percentage | 18.0, 0.0 | Tax calculations |
 | **hsn** | string | Yes | Harmonized System Code | e.g., '87089900' | Statutory reporting |
 | **ItemCatcode** | integer | Yes | Item Category ID | | Join to `ItemCategory` |
 | **custGroupcode**| number | Yes | Customer Group Link | | Join to `CustGroupMas` |
 | **Prod_IHBOP** | string | Yes | Production Source | INHouse, BuyOut | Sourcing strategy |
 | **SaleTaxRate** | number | Yes | Sales Tax percentage | | Sales pricing |
 | **Max_level** | number | Yes | Maximum Inventory Level | | Inventory control |
 | **Min_level** | number | Yes | Minimum Inventory Level | | Reorder alerts |
 | **Lead_Time** | integer | Yes | Procurement/Production lead time | | Planning |
 | **dom_export** | string | Yes | Domestic or Export flag | D, E | Market classification |
 
 ### 3. Relationships & Join Map
 
 #### Logical Primary Key
 The logical unique identifier is a composite of `compcode` and `itemcode`.
 
 #### Forward Joins (itemmas as Parent)
 * **Production & WIP:** Joins to `RMproduct1`, `product2`, and `prodfhdr` on `itemcode` to provide item descriptions for daily production entries.
 * **Sales & Invoicing:** Joins to `invdtl`, `Debitdtl`, and `Performainvdtl` on `itemcode` to provide HSN codes, unit weights (`finishwt`), and part numbers for billing.
 * **Process Mapping:** Joins to `itemopr` on `itemcode` to define the sequence of operations (routes) an item must follow.
 * **Sub-Assemblies:** Joins to `assemblyproddtl` on `itemcode` to identify components within a parent assembly.
 
 #### Backward Joins (itemmas as Child)
 * **Categories:** Joins to `ItemCategory` on `ItemCatcode` to fetch human-readable categories.
 * **Customer Groups:** Joins to `CustGroupMas` on `custGroupcode` to associate items with specific market segments.
 * **Locations:** Joins to `PhyLocation` or `location` on `location` string.
 
 #### Join Map Table (SCHEMA_MAP Authoritative)
 
 | Source Table | Source Column | Target Table | Target Column |
 | :--- | :--- | :--- | :--- |
 | `dbo.itemmas` | `compcode` | *Most Tables* | `compcode` |
 | `dbo.itemmas` | `itemcode` | `dbo.Debitdtl` | `itemcode` |
 | `dbo.itemmas` | `itemcode` | `dbo.PackingSlipdtl` | `itemcode` |
 | `dbo.itemmas` | `itemcode` | `dbo.Performainvdtl` | `itemcode` |
 | `dbo.itemmas` | `itemcode` | `dbo.invdespdtl` | `itemcode` |
 | `dbo.itemmas` | `itemcode` | `dbo.jobhdr` | `itemcode` |
 | `dbo.itemmas` | `itemcode` | `dbo.jobdtl` | `itemcode` |
 | `dbo.itemmas` | `itemcode` | `dbo.itemopr` | `itemcode` |
 | `dbo.itemmas` | `itemcode` | `dbo.assemblyproddtl` | `itemcode` |
 | `dbo.itemmas` | `ItemCatcode` | `dbo.ItemCategory` | `ItemCatcode` |
 | `dbo.itemmas` | `custGroupcode` | `dbo.CustGroupMas` | `CustGroupCode` |
 | `dbo.itemmas` | `rmcode` | `dbo.rmmas` | `rmcode` (Likely) |