cjobpodtl

### 1. Overview
 The `cjobpodtl` table stores line-item details for **Capital Job Purchase Orders**. It captures specific services, repairs, or maintenance tasks (operations) performed on capital items. Unlike standard material POs, this table focuses on service-based procurement such as "Regrinding," "Repairing," "Rewinding," and "Calibration." Each record links a specific capital item (`citmcode`) to a purchase order header, defining the quantity, rate, and financial breakdown for that specific task.
 
 ### 2. Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | NO | Primary Key | | Row identifier |
 | **compcode** | string | NO | Company Identifier | e.g., "DAS" | Join Key |
 | **pono** | integer | NO | Purchase Order Number | | Join Key |
 | **citmcode** | string | NO | Capital Item Code | e.g., "SCDRILL064", "MOTOR06" | Join Key (Item Ref) |
 | **operation** | string | YES | Description of service/work | e.g., "Regrinding", "Repairing" | Descriptive |
 | **poqty** | string | YES | Quantity ordered | e.g., "1", "0" | Calculation |
 | **uom** | string | YES | Unit of Measure | NOS, PCS, MTR², Day | Formatting |
 | **rate** | number | YES | Unit rate of the service | | Calculation |
 | **oprcode** | string | YES | Specific operation category code | | Filtering/Join |
 | **discount** | number | YES | Discount applied to line | | Calculation |
 | **invyear** | integer | NO | Financial/Accounting Year | e.g., 2018, 2019, 2024 | Join Key |
 | **sno** | integer | YES | Serial number within the PO | | Ordering |
 | **NetRate** | number | YES | Rate after discounts | | Calculation |
 | **NetAmount** | number | YES | Total line amount (Rate * Qty) | | Calculation |
 
 ### 3. Relationships & Join Map
 
 #### Real Physical Joins (Authoritative)
 Based on `SCHEMA_MAP` and `REFERENCE_JSON`, the following joins are valid:
 
 * **Purchase Order Header**: Joins to `dbo.cjobpohdr` to retrieve vendor information and order dates.
  * `cjobpodtl.pono = cjobpohdr.pono`
  * `cjobpodtl.compcode = cjobpohdr.compcode`
  * `cjobpodtl.invyear = cjobpohdr.invyear`
 * **Capital Item Master**: Joins to `dbo.citemmas` to get specific item descriptions and properties.
  * `cjobpodtl.citmcode = citemmas.citmcode`
  * `cjobpodtl.compcode = citemmas.compcode`
 * **Tax/Duty Details**: Joins to `dbo.cjobpoduty` for line-level tax breakdowns.
  * `cjobpodtl.pono = cjobpoduty.pono`
  * `cjobpodtl.compcode = cjobpoduty.compcode`
  * `cjobpodtl.sno = cjobpoduty.sno`
 * **Operation Master (Likely)**: Joins to `dbo.oprmas` for standardized operation names.
  * `cjobpodtl.oprcode = oprmas.oprcode`
  * `cjobpodtl.compcode = oprmas.compcode`
 
 #### Derived Relationships
 * **Amendments**: Line item history can be tracked by joining to `dbo.cjobpodtlamnd` using `pono`, `citmcode`, and `compcode`.