grademas

### 1. Overview
 The `grademas` table serves as the central master repository for **Raw Material Grade** definitions. It stores specific metallurgical or material classifications (e.g., Steel, Aluminum grades), their descriptions, shorthand codes, and standard financial rates per kilogram for both raw and Work-In-Progress (WIP) states. This table is critical for material procurement, inventory valuation, and production planning.
 
 ### 2. Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | NO | Primary key; unique record identifier. | 0, 1, 2... | Internal PK |
 | **compcode** | string | NO | Company identifier code. | "DAS" | Join key to `dbo.company` |
 | **rmgrade** | string | NO | The primary Raw Material Grade name. | "10B21", "16MnCr5" | **Join key** to Material Masters |
 | **gradedesc** | string | YES | Detailed description of the grade. | "10B21", "AA-6063-T6" | Display Labels |
 | **username** | string | YES | User ID of the person who created/updated the record. | "system", "admin" | Audit Trail |
 | **rmgradeshort** | string | YES | Short identifier/alphanumeric code for reports. | "21", "16", "AL" | Reporting shorthand |
 | **Rate_RMGradePerKG** | number | YES | Standard cost rate per KG for the raw material grade. | e.g., 0.0, NULL | Financial Valuation |
 | **WIPRate_RMGradePerKG**| number | YES | Work-In-Progress (WIP) valuation rate per KG. | e.g., 0.0, NULL | Cost Accounting |
 
 ### 3. Relationships & Join Map
 
 The `grademas` table is a foundational master table used to validate material grades across procurement and production modules.
 
 #### Primary Joins (Physical Tables)
 * **dbo.itemmas**: Joins on `(compcode, rmgrade)`. Used to link finished or semi-finished items to their base raw material grade.
 * **dbo.rmmas**: Joins on `(compcode, rmgrade)`. Links specific raw material codes to their generic grade definitions.
 * **dbo.job**: Joins on `(compcode, rmgrade)`. Defines the material grade requirements for specific job orders.
 * **dbo.pdiinspectionhdr**: Joins on `(compcode, rmgrade)`. Used in Pre-Delivery Inspection to record the material grade of the inspected lot.
 * **dbo.iteminspectionhdr**: Joins on `(compcode, rmgrade)`. Used during incoming material inspection.
 * **dbo.ProductTag**: Joins on `(compcode, rmgrade)`. Identifies the material grade on physical product tracking tags.
 
 #### Likely Joins (Contextual)
 * **dbo.company**: Joins on `(compcode)` to filter grades by organizational unit.
 * **dbo.pass1**: Joins on `(username)` to identify the personnel responsible for grade setup.