cpodtlamnd

### 1) Overview
 The `cpodtlamnd` table serves as the historical detail repository for **Consumable Purchase Order (PO) Amendments**. It tracks modifications made to specific line items within a PO after its initial release. This table is primarily used to audit changes in quantities, rates, and specifications, and to generate amendment-specific purchase order documentation.
 
 In the ERP ecosystem, it acts as the "Amended" counterpart to `dbo.cpodtl`, allowing the system to maintain a versioned history of purchasing commitments for consumable items (e.g., tools, crates, lubricants).
 
 ### 2) Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | NO | Primary Key - unique record identifier. | | PK |
 | **compcode** | string | NO | Company identifier code. | e.g., "DAS" | FK/Join |
 | **pono** | integer | NO | Purchase Order number. | | FK/Join |
 | **amendno** | integer | NO | Amendment sequence number (incremented per revision). | 0, 1, 2... | Join |
 | **citmcode** | string | NO | Consumable Item Code. | e.g., "PUNCH06" | FK (citemmas) |
 | **make** | integer | YES | Brand or Manufacturer code. | | Join (brandmas) |
 | **itemqty** | number | YES | Revised quantity for the specific line item. | | Calculation |
 | **rate** | number | YES | Unit price of the consumable item. | | Calculation |
 | **discount** | number | YES | Percentage discount applied to the item. | | Calculation |
 | **description** | string | YES | Detailed item specifications or notes. | | Descriptive |
 | **invyear** | integer | NO | Financial/Inventory year associated with the PO. | e.g., 2014 | Join |
 | **partno** | string | YES | Manufacturer part number. | | Filter |
 | **hsn** | string | YES | Harmonized System of Nomenclature code for tax. | | Compliance |
 | **sno** | string | YES | Serial/Line number within the PO. | | Order |
 | **UoM** | string | YES | Unit of Measure. | e.g., "NOS" | Unit |
 | **Lock** | string | YES | Status flag indicating if the record is frozen. | "Y", "N", null | Logical |
 
 ### 3) Relationships & Join Map
 
 The table is designed to be joined with header amendment tables and master item/brand tables to provide a complete view of a specific PO version.
 
 #### Authority Joins (SCHEMA_MAP Verified)
 * **dbo.cpohdramnd**: Joins on `compcode`, `pono`, `invyear`, and `amendno`. This is the primary relationship used to link amended details to the amended header info (reasons for change, dates).
 * **dbo.citemmas**: Joins on `compcode` and `citmcode` to retrieve master consumable names (`citemname`) and category info.
 * **dbo.brandmas**: Joins on `compcode` and `make` (maps to `Br_code` in `brandmas`) to identify the manufacturer of the consumable.
 * **dbo.cpodtl**: Joins on `compcode`, `pono`, `invyear`, and `sno` to compare the current amendment against the original PO line item.
 
 #### Likely Joins (Inferred)
 * **dbo.UoMMaster**: Likely joins on `compcode` and `UoM` (mapping to `CUoM`) for unit conversions.
 * **dbo.chapter**: Joins on `hsn` (maps to `chapter`) to determine applicable tax rates for the amended item.