vendtax

### 1) Overview
 The `vendtax` table is a configuration entity used to define specific tax rates (duties) applicable to individual vendors. It maps a vendor (`vendcode`) to one or more duty codes (`duty_code`) and their corresponding tax percentages. This data is critical for calculating procurement costs, tax liabilities on purchase orders, and verifying vendor invoices within the ERP system.
 
 ### 2) Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **compcode** | string | No | Unique identifier for the legal entity/company. | e.g., "DAS" | `WHERE compcode = 'DAS'` |
 | **vendcode** | string | No | Unique code identifying the vendor. | e.g., "SMHT", "SKE" | Join to `vendmas` |
 | **srno** | integer | No | Serial number/Sequence for multiple tax lines per vendor. | 1, 2, 3... | Order of application |
 | **duty_code** | integer | No | Reference to the specific type of tax or duty (GST, Freight, etc.). | e.g., 7, 18, 52 | Join to `dutymas` |
 | **taxpercentage** | number | No | The rate (percentage) to be applied for the associated duty code. | e.g., 18.0, 12.0 | Calculation |
 
 ---
 
 ### 3) Relationships & Join Map
 
 #### Logical Primary Key
 The combination of `compcode`, `vendcode`, and `srno` (or `duty_code`) forms the unique identifier for a tax configuration row.
 
 #### Joins (Strictly based on SCHEMA_MAP)
 
 **1. Vendor Master Data**
 Used to retrieve vendor names and addresses associated with these tax rates.
 * `vendtax.vendcode` -> `dbo.vendmas(vendcode)`
 * `vendtax.compcode` -> `dbo.vendmas(compcode)`
 
 **2. Tax/Duty Definitions**
 Used to find the descriptive name of the tax (e.g., "CGST", "IGST") associated with a `duty_code`.
 * `vendtax.duty_code` -> `dbo.dutymas(duty_code)`
 * `vendtax.duty_code` -> `dbo.cdutymas(duty_code)`
 * `vendtax.compcode` -> `dbo.dutymas(compcode)`
 
 **3. Procurement & Purchase Orders**
 Used to validate tax rates applied on Job Purchase Orders or Raw Material orders.
 * `vendtax.vendcode` -> `dbo.jobpohdr(vendcode)`
 * `vendtax.vendcode` -> `dbo.cjobpohdr(vendcode)`
 * `vendtax.compcode` -> `dbo.jobpohdr(compcode)`
 
 **4. Comparable Entities**
 Used for cross-referencing tax configurations between vendors, customers, and suppliers.
 * `vendtax.duty_code` -> `dbo.suptax(duty_code)` (Supplier-specific tax rates)
 * `vendtax.duty_code` -> `dbo.custtax(duty_code)` (Customer-specific tax rates)