cjobpoduty

### 1) Overview
 The `cjobpoduty` table stores the breakdown of taxes, levies, and duties (such as GST, cess, or other charges) associated with Job Purchase Orders (Job POs). It functions as a child table to Job PO headers, detailing the specific tax percentages (`duty_per`) and calculated monetary values (`amount`) applied to each order.
 
 ### 2) Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | No | Primary Key | 0, 1, 2... | Internal unique identifier. |
 | **compcode** | string | No | Company Identifier | e.g., "DAS" | Primary join key for multi-tenant data isolation. |
 | **pono** | integer | No | Purchase Order Number | e.g., 3, 53, 175 | Links duty records to a specific Job PO. |
 | **duty_code** | integer | No | Tax/Duty Category Code | e.g., 51 (CGST), 52 (SGST) | Foreign key to `cdutymas` or `dutymas`. |
 | **amount** | number | No | Calculated Tax Amount | e.g., 7280.01 | The actual monetary value of the tax. |
 | **sno** | integer | No | Serial/Line Number | 2, 3, 4... | Sequence of the tax line within the PO. |
 | **duty_per** | number | No | Duty Percentage Rate | 0.0, 9.0, 18.0 | The tax rate applied to calculate the amount. |
 
 ### 3) Relationships & Join Map
 
 #### Logical Parent Tables
 * **dbo.cjobpohdr**: The primary header for Job Purchase Orders.
  * `JOIN dbo.cjobpohdr ON cjobpoduty.pono = cjobpohdr.pono AND cjobpoduty.compcode = cjobpohdr.compcode`
 * **dbo.cdutymas**: Master table containing definitions (names, types) for tax codes.
  * `JOIN dbo.cdutymas ON cjobpoduty.duty_code = cdutymas.duty_code AND cjobpoduty.compcode = cdutymas.compcode`
 
 #### Logical Sibling Tables
 * **dbo.cjobpodtl**: Line items (parts/services) for the same Job PO.
  * `JOIN dbo.cjobpodtl ON cjobpoduty.pono = cjobpodtl.pono AND cjobpoduty.compcode = cjobpodtl.compcode`
 
 #### Specific Join Rules
 * Always join using both `compcode` and `pono` to ensure accuracy across different financial years or company branches if applicable.
 * The `sno` in this table typically refers to the sequence of duties, not necessarily a 1-to-1 match with the `sno` in the detail table (`cjobpodtl`).