rmdia

### 1) Overview
 The `rmdia` table serves as a master reference for **Raw Material Diameters**. It defines specific numeric diameter values (`rmdia`) associated with company configurations. This table is primarily used as a lookup for the `itemmas` table to ensure standardized diameter specifications across the inventory and manufacturing modules.
 
 ### 2) Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | No | Internal primary key for the record. | 0, 1, 2... | `PRIMARY KEY` |
 | **compcode** | string | No | Unique identifier for the company/entity. | e.g., "DAS" | `JOIN`, `WHERE` |
 | **rmdia** | number | No | The specific numeric diameter value for the raw material. | e.g., 0.5, 5.2, 11.2 | `JOIN`, `FILTER` |
 | **shortcode** | string | Yes | An abbreviated alias or code for the diameter value. | Often NULL in data | `DISPLAY` |
 
 ### 3) Relationships & Join Map
 
 Based on the `SCHEMA_MAP`, the `rmdia` column is shared with the item master, indicating a validation or attribute relationship.
 
 #### Primary Joins:
 * **dbo.itemmas**: Joins on `rmdia` and `compcode`. This allows retrieving diameter-specific metadata for items.
  * `rmdia.rmdia = itemmas.rmdia`
  * `rmdia.compcode = itemmas.compcode`
 
 #### Likely Related Tables (Inferred):
 * **dbo.rmmas**: While `rmmas` uses `rmsize`, it is **Likely** that `rmdia` acts as a specific dimension lookup for raw materials where size is defined by diameter.
 * **dbo.company**: Joins on `compcode` to filter diameter standards by legal entity.