rmindentitem

### 1. Overview
 The `rmindentitem` table serves as the line-item detail repository for Raw Material (RM) Indents within the ERP system. It records the specific raw materials, quantities, and rates requested under a parent indent header (`rmindent`). This table is critical for tracking procurement requirements before they are converted into Purchase Orders (POs) through the `rmpotabitem` table.
 
 ### 2. Column Dictionary
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | No | Primary key for the record. | e.g., 0, 1, 2... | Internal ID |
 | **compcode** | string | No | Unique identifier for the company/branch. | e.g., "DAS" | Joins, Filtering |
 | **indentno** | integer | No | Reference number to the parent RM indent. | e.g., 1 | Join to `rmindent` |
 | **rmcode** | string | No | Physical identifier for the raw material. | e.g., "B/BAR20", "ROD10" | Join to `rmmas` |
 | **uom** | string | Yes | Unit of Measure for the requested quantity. | e.g., "KGS" | Join to `UoMMaster` |
 | **indentqty** | number | Yes | Total quantity of material requested. | e.g., 1.0, 11.0 | Aggregation |
 | **rmrate** | number | Yes | Expected or current market rate of the material. | e.g., 53.0 | Calculation |
 | **Lock** | string | Yes | Status flag indicating if the item is locked/processed. | "N", "Y" | Logic Gate |
 
 ### 3. Relationships & Join Map
 
 #### Parent Relationships
 * **dbo.rmindent**: Joined via `indentno` and `compcode`. This represents the header record containing the indent date and department information.
 * **dbo.rmmas**: Joined via `rmcode` and `compcode`. Used to retrieve detailed material specifications (e.g., `rmname`, `rmsize`).
 
 #### Downstream Relationships
 * **dbo.rmpotabitem**: Joined via `rmcode` and `compcode`. This table tracks the actual Purchase Order lines generated against the indent requirements. 
  * *Note*: To calculate balance quantities, one must often link `rmindentitem` -> `rmpotab` (Header) on `indentno` then to `rmpotabitem` on `pono`.
 
 #### Likely Joins (Based on Schema Map)
 * **dbo.UoMMaster**: Likely join on `uom` (`CUoM`) and `compcode` for unit conversions.
 * **dbo.rmvendopr**: Likely join on `rmcode` and `compcode` to identify preferred vendors for the indented material.
 
 ---