Form_Active_Status

### 1) Overview
 The `Form_Active_Status` table serves as a configuration control layer within the ERP system, managing the availability and active state of specific application forms. It tracks whether a particular form (e.g., dispatch advice, master entry) is enabled or disabled for specific company codes and users. This is typically used to toggle features globally or for specific administrative roles.
 
 ### 2) Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | NO | Primary surrogate key for the record. | e.g., 0, 1, 2 | `WHERE index = 0` |
 | **compcode** | string | YES | The unique identifier for the company/branch. | e.g., "SF1" | `JOIN` key for multi-tenant filtering. |
 | **form_name** | string | YES | The technical internal name of the UI form. | e.g., "frmdailydespadvice" | `JOIN` to `Userrights.formname`. |
 | **form_active_flag** | string | YES | Toggle switch for form availability. | "Y" (Active), "N" (Inactive) | `WHERE form_active_flag = 'Y'` |
 | **UserName** | string | YES | The user account associated with the status or who last modified it. | e.g., "SYSTEM", "ADMIN" | `JOIN` key for user-specific settings. |
 
 ### 3) Relationships & Join Map
 
 The table functions as a metadata control table and links primarily to user management and system logging tables.
 
 #### Joins
 * **Company Context**: Joins to **dbo.Company** or **dbo.CompanyConfig** on `compcode`.
 * **User Rights**: Joins to **dbo.Userrights** or **dbo.UserrightsHdr** on `form_name` (Likely matches `formname`) and `UserName` (Likely matches `user_code`).
 * **System Audit**: Joins to **dbo.Deletion_Log** on `form_name` (Likely matches `FormName`) to track historical actions related to specific forms.
 * **User Profile**: Joins to **dbo.PhyLocation** or **dbo.Machine** on `UserName` (Likely matches `username`).