podtlamnd

### 1) Overview
 The `podtlamnd` table serves as the historical or amendment-specific detail repository for Purchase Orders (POs) in the ERP system. While `podtl` contains the current state of a PO, `podtlamnd` captures the specific item-level changes (quantity, rate, discount) associated with a particular amendment number (`amndno`). This table is critical for audit trails and for generating invoices based on specific PO revisions.
 
 ### 2) Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | NO | Primary Key; internal unique identifier. | | PK |
 | **compcode** | string | NO | Unique code identifying the company. | e.g., "DAS" | Join; Filter |
 | **pono** | string | NO | Purchase Order number. | | Join; Filter |
 | **custcode** | string | NO | Unique identifier for the customer. | e.g., "HMCLV" | Join |
 | **itemcode** | string | NO | Internal code for the product/item. | e.g., "CP-174" | Join |
 | **itemqty** | number | YES | The revised quantity for the item in this amendment. | | Aggregate |
 | **itemrate** | number | YES | The unit price/rate for the item in this amendment. | | Calculation |
 | **uom** | string | YES | Unit of Measure. | e.g., "Nos" | Reporting |
 | **discount** | number | YES | Discount percentage or value applied to the item. | | Calculation |
 | **partno** | string | YES | The manufacturer's part number for the item. | | Search |
 | **amndno** | integer | NO | The specific amendment/revision version number. | 0, 1, 2... | Join; Versioning |
 | **amnddate** | datetime | YES | The date this specific amendment was effective. | | Filter |
 | **Gross_Rate** | number | YES | The total rate before specific net adjustments. | | Reporting |
 
 ### 3) Relationships & Join Map
 
 The `podtlamnd` table is a detail-level table that links primarily to PO headers and item masters.
 
 #### Primary Relationships (Strict SCHEMA_MAP Joins)
 * **dbo.pohdramnd**: Joins on `compcode`, `pono`, and `amndno`. This identifies the header information (validity dates, reason for change) for this specific detail revision.
 * **dbo.podtl**: Joins on `compcode`, `pono`, and `itemcode`. Used to compare amended rates vs. current active rates.
 * **dbo.cust**: Joins on `compcode` and `custcode`. Provides customer master data (Address, GST, etc.).
 * **dbo.itemmas**: Joins on `compcode` and `itemcode`. Provides item specifications (HSN, Type, Category).
 * **dbo.Performainvdtl**: Joins on `compcode`, `pono`, `itemcode`, and `amndno` (maps to `Suplamndno` or `amndno`). Used to link proforma invoice items back to a specific PO amendment.
 * **dbo.invdtl**: Joins on `compcode`, `pono`, `itemcode`, and `amndno`. Used for final billing against specific PO revisions.
 
 #### Likely Inference
 * **dbo.pohdr**: Joins on `compcode` and `pono`. Links back to the original Purchase Order record.
 * **dbo.UoMMaster**: Likely joins on `compcode` and `uom` (to `PUoM` or `CUoM`) for unit conversions.