PhyLocation

This table, **PhyLocation**, serves as a master registry for physical storage identifiers (such as bins, racks, or shelf addresses) within a facility. It maps specific physical codes to general locations and tracks the administrative user responsible for the entry.
 
 ### 1) Overview
 The `PhyLocation` table is primarily used in warehouse management and inventory modules to provide granular tracking of where items or raw materials are stored. While the `Location` column typically represents a broad area (e.g., "Warehouse A"), the `PhyLocation` column represents the specific coordinate (e.g., "A-1").
 
 ### 2) Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | No | Internal primary key for the record. | | Primary Key |
 | **CompCode** | string | Yes | Unique identifier for the company. | e.g., "DAS" | Join / Filter |
 | **PhyLocation** | string | Yes | Specific physical storage address (Bin/Rack/Shelf). | e.g., "A-1", "B-12" | Join / Search |
 | **Location** | string | Yes | General site or department location identifier. | e.g., "Main Store" | Join / Filter |
 | **username** | string | Yes | The system user who created or last updated the record. | e.g., "system" | Auditing |
 
 ### 3) Relationships & Join Map
 
 The `PhyLocation` table acts as a reference for inventory-heavy tables to specify exact stock placement.
 
 #### Primary Joins (Authoritative)
 * **dbo.itemmas**: Join on `PhyLocation` and `CompCode`. Used to identify the default storage bin assigned to a specific finished good or item.
 * **dbo.citemmas**: Join on `PhyLocation` and `CompCode`. Used to identify where components (child items) are stored in the sub-store.
 * **dbo.rmincoming**: Join on `PhyLocation` and `CompCode`. Used to track the specific rack or bin where raw materials were placed upon receipt.
 
 #### Likely/Inferred Joins
 * **dbo.location**: Join on `Location` and `CompCode`. Links the granular physical bin to the broader site/departmental metadata.
 * **dbo.company**: Join on `CompCode` to retrieve company-wide settings or address details.