citemmas

### 1. Overview
 The `citemmas` table serves as the **Consumable Item Master** repository. It is the authoritative source for non-production items, such as maintenance spares, tools, sensors, and office supplies (consumables). Unlike `itemmas` (Finished/Semi-Finished Goods) or `rmmas` (Raw Materials), this table focuses on items required for operations and maintenance. It stores critical inventory parameters including reorder levels, standard rates, HSN codes for GST compliance, and physical storage locations.
 
 ### 2. Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | No | Primary Key (Internal) | Auto-incremented | Unique identifier for the row. |
 | **compcode** | string | No | Company Code | e.g., "DAS", "BPL" | Used in multi-tenant filtering. |
 | **citmcode** | string | No | Consumable Item Code | e.g., "#8PS-E3TST14", "00001" | Unique identifier for the item; used in joins. |
 | **citemname** | string | No | Item Description | e.g., "Photo Sensor", "DIE SPRING" | Full text name of the consumable. |
 | **uom** | string | Yes | Unit of Measure | NOS, PCS, SET, KGS, KIT | Used for quantity calculations. |
 | **citemrate** | number | Yes | Standard/Purchase Rate | | Used for valuation and PO pricing. |
 | **maxlevel** | number | Yes | Maximum Stock Level | | Inventory control threshold. |
 | **rorderleve** | number | Yes | Reorder Level | | Triggers procurement requests. |
 | **minlevel** | number | Yes | Minimum Safety Stock | | Alert level for stockouts. |
 | **groupcode** | integer | Yes | Primary Item Group | Links to `cgroupmas` | High-level categorization. |
 | **opbal** | number | Yes | Opening Balance | | Starting stock at `asondate`. |
 | **asondate** | datetime | Yes | Opening Balance Date | | Date of last manual balance entry. |
 | **active** | string | Yes | Item Status | 'Y', 'N' | Filters out obsolete items. |
 | **category** | string | Yes | ABC Category | 'A', 'B', 'C' | Used for inventory prioritization. |
 | **acgroupcode** | number | Yes | Accounting Group Code | | Link for financial ledger posting. |
 | **authflag** | string | Yes | Authorization Status | 'Y', 'N' | Ensures only approved items are usable. |
 | **useradd** | string | Yes | User who created item | | Audit trail. |
 | **addtime** | string | Yes | Creation Timestamp | | Audit trail. |
 | **usermod** | string | Yes | Last Modifier User | | Audit trail. |
 | **modtime** | string | Yes | Last Modification Time | | Audit trail. |
 | **capital_flag** | string | Yes | Capital Asset Flag | 'Y', 'N' | Determines if item is depreciable asset. |
 | **taxrate** | number | Yes | GST/Tax Percentage | 0, 18, 28 | Default tax rate for procurement. |
 | **hsn** | string | Yes | HSN Code | | Statutory code for GST reports. |
 | **subgroupcode**| string | Yes | Secondary Item Group | Links to `csubgroupmas` | Fine-grained categorization. |
 | **leadtime** | number | Yes | Procurement Lead Time | | Days taken to receive item after order. |
 | **PhyLocation** | string | Yes | Physical Storage Location| | Warehouse bin/rack identifier. |
 
 ### 3. Relationships & Join Map
 
 The table interacts heavily with procurement and internal inventory movement modules:
 
 * **Item Grouping**:
  * Joins to `dbo.cgroupmas` on `groupcode` to retrieve human-readable group names.
  * Joins to `dbo.csubgroupmas` on `groupcode` AND `subgroupcode` for detailed classification.
 * **Procurement (Purchasing)**:
  * **Purchase Orders**: Joins to `dbo.cpodtl` on `citmcode` to track item-specific orders.
  * **Inward Receipts (SRN)**: Joins to `dbo.incondtl` on `citmcode` to link physical receipts (consumable purchase) to the master.
  * **Returns to Vendor**: Joins to `dbo.cmrrdtl` on `citmcode` for returnable gate passes (RGP).
 * **Inventory & Consumption**:
  * **Internal Issues**: Joins to `dbo.citisdtl` on `citmcode` to track issues to departments (linked via `dbo.citemiss`).
  * **Usage in Production**: Joins to `dbo.citemusedinpitem` on `citmcode` to see which consumables are required for specific production items (`PItemcode`).
  * **Returns from Production**: Joins to `dbo.itemreturn` on `itemcode` (`citmcode`) for unused/reclaimed items.
 * **Gate Passes**:
  * Joins to `dbo.rgpdtl` on `citmcode` for items sent outside for repair.
  * Joins to `dbo.nonretitmdtl` on `citmcode` for non-returnable outflows.