brandmas

### 1) Overview
 The `brandmas` table serves as a central master repository for brand definitions within the ERP system. It categorizes items (consumables, raw materials, or components) by their manufacturer or brand name (e.g., SKF, NBC, CASTROL). This table is frequently used in procurement modules (Purchase Orders, Good Receipts) and inventory reporting to identify the "make" of a specific part or material.
 
 ### 2) Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | NO | Primary Key; Internal row identifier. | Auto-incrementing | `PRIMARY KEY` |
 | **compcode** | string | NO | Company Code; links the brand to a specific business unit. | e.g., "DAS" | `JOIN`, `WHERE` |
 | **Br_code** | integer | NO | Unique Brand Identifier; used as a foreign key in transactional tables. | 1 (GENERAL), 8 (SKF), etc. | `JOIN` |
 | **Br_name** | string | NO | Descriptive name of the brand. | e.g., "WIDIA", "ISCAR", "MITUTOYO" | `SELECT` (Labels) |
 
 ### 3) Relationships & Join Map
 
 #### Primary Keys
 * **index**: Unique record identifier.
 * **compcode, Br_code**: Composite logical key used across the system.
 
 #### Joins (Authoritative)
 Based on `SCHEMA_MAP` and `REFERENCE_JSON`, this table joins with procurement and inventory tables, often using `Br_code` or a column named `make` (which stores the Brand Code):
 
 **Standard Joins (using Br_code):**
 * **dbo.itemsup** (`Br_code`): Links brands to item-supplier relationship records.
 * **dbo.rmincoming** (`br_code`): Identifies the brand of incoming raw materials.
 * **dbo.rmpotabitem** / **dbo.rmpotabitemamnd** (`br_code`): Used in Raw Material Purchase Orders to specify brand requirements.
 
 **Logical Joins (using `make` as Brand Code):**
 The ERP system frequently uses the column `make` in transaction tables to store the `Br_code` value. These are verified via the provided SQL View/Sproc definitions:
 * **dbo.cpodtl** (`make`): Consumable Purchase Order lines.
 * **dbo.rgpdtl** (`make`): Returnable Gate Pass details.
 * **dbo.incondtl** (`make`): Incoming consumable material details.
 * **dbo.citisdtl** (`make`): Consumable issue details.
 * **dbo.scheduledtl** (`make`): Scheduling and planning details.
 * **dbo.srntemp** (`make`): Store Return Note temporary data.
 * **dbo.cmrrdtl** (`make`): Consumable Material Receipt Report details.
 
 **Common Filters:**
 * Joins always include `compcode` to ensure data isolation between different business units.