cjobpodtlamnd

### 1) Overview
 The `cjobpodtlamnd` table serves as the historical detail repository for amendments made to **Consumable Job Purchase Orders**. It captures changes to specific line items, including revisions to operations, quantities, rates, and item codes. Every record represents a specific version of a purchase order line, linked back to a header amendment record via the `amendno` and `pono` columns.
 
 ### 2) Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | NO | Internal primary key for the row. | Unique Integer | `WHERE index = 10` |
 | **compcode** | string | NO | Unique identifier for the company/branch. | e.g., "DAS" | `JOIN` key |
 | **pono** | integer | NO | Purchase Order number assigned to the job. | e.g., 8, 17, 20 | `JOIN` key |
 | **amendno** | integer | NO | Incrementing version number of the PO amendment. | 0 = Original, 1+ = Revisions | `JOIN` key / Filter |
 | **citmcode** | string | NO | Consumable item code identifying the tool or service. | e.g., "TOOLCOST01", "CSHUB01" | `JOIN` to `citemmas` |
 | **operation** | string | YES | Detailed description of the work, scope, or specific tool requirements. | Free text / Scope details | `LIKE '%Welding%'` |
 | **poqty** | string | YES | The revised quantity for the amended line item. | e.g., "1 " | Aggregate/Display |
 | **uom** | string | YES | Unit of Measure for the consumable or service. | NOS, PCS, SET | `GROUP BY uom` |
 | **rate** | number | YES | The revised unit price or service charge. | e.g., 335000.0 | Financial calculation |
 | **discount** | number | YES | Percentage or value of discount applied to the line. | e.g., 0.0, 3.0 | Net price calc |
 | **oprcode** | string | YES | Specific operation code if linked to a standard process. | Likely linked to `oprmas` | `WHERE oprcode IS NOT NULL` |
 | **invyear** | integer | NO | The financial/accounting year associated with the PO. | e.g., 2019, 2024 | Partitioning/Filter |
 
 ### 3) Relationships & Join Map
 
 #### Parent Table (Header Amendment)
 * **dbo.cjobpohdramnd**: Joins to retrieve the amendment date, vendor information, and authorization status.
  * **Join Condition**: `cjobpodtlamnd.compcode = cjobpohdramnd.compcode AND cjobpodtlamnd.pono = cjobpohdramnd.pono AND cjobpodtlamnd.amendno = cjobpohdramnd.amendno AND cjobpodtlamnd.invyear = cjobpohdramnd.invyear`
 
 #### Master Tables
 * **dbo.citemmas**: Joins to retrieve consumable item descriptions, HSN codes, and tax rates.
  * **Join Condition**: `cjobpodtlamnd.compcode = citemmas.compcode AND cjobpodtlamnd.citmcode = citemmas.citmcode`
 * **dbo.oprmas (Likely)**: Joins to decode standard operations if `oprcode` is populated.
  * **Join Condition**: `cjobpodtlamnd.compcode = oprmas.compcode AND cjobpodtlamnd.oprcode = oprmas.oprcode`
 
 #### Transactional History
 * **dbo.cjobpodtl**: This table represents the current (live) detail. `cjobpodtlamnd` is the versioned history of changes to `cjobpodtl`.
  * **Join Condition**: `cjobpodtlamnd.compcode = cjobpodtl.compcode AND cjobpodtlamnd.pono = cjobpodtl.pono`