cjobpohdr

### 1) Overview
 The `cjobpohdr` (Contract Job Purchase Order Header) table serves as the primary registry for service-oriented or contract job purchase orders. It stores high-level transaction details, including vendor information, total order valuation, tax breakdowns (CGST, SGST, IGST), and detailed terms and conditions.
 
 This table is functionally the parent to `cjobpodtl` and tracks the lifecycle of a PO, including amendments (`amendno`) and authorization status (`authflag`).
 
 ### 2) Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | No | Primary Key | Auto-incrementing | `WHERE index = 10` |
 | **compcode** | string | No | Company Identifier | e.g., "DAS" | `JOIN ... ON compcode` |
 | **pono** | integer | No | Purchase Order Number | Unique per comp/year | `JOIN ... ON pono` |
 | **podate** | datetime | No | PO Creation Date | ISO Dates | `ORDER BY podate DESC` |
 | **quotno** | string | Yes | Vendor Quotation Reference | e.g., "BY MAIL" | `WHERE quotno LIKE '%123%'` |
 | **quotdate** | datetime | Yes | Date of vendor quotation | ISO Dates | Historical tracking |
 | **vendcode** | string | No | Physical Vendor Code | e.g., "BFW01" | `JOIN vendmas (vendcode)` |
 | **amendno** | integer | No | Amendment Version Number | 0 = Original, 1+ = Rev | `WHERE amendno = 0` |
 | **amenddate** | datetime | Yes | Date of PO Amendment | ISO Dates | Audit trail |
 | **term_1..7** | string | Yes | Terms & Conditions (1-7) | Payment, Delivery, etc. | `SELECT term_1` |
 | **authflag** | number | Yes | Authorization Status | 1.0 = Authorized, NULL | `WHERE authflag = 1` |
 | **wefdate** | datetime | Yes | With Effect From Date | ISO Dates | Pricing validity |
 | **reason** | string | Yes | Internal Notes or PO Justification | Free text | Searchable comments |
 | **povalue** | number | Yes | Base PO Value (Excl Tax) | Decimal values | `SUM(povalue)` |
 | **povalueword** | string | Yes | Total value in words | Text representation | Report printing |
 | **invyear** | integer | No | Financial/Accounting Year | e.g., 2018, 2023 | `JOIN ... ON invyear` |
 | **vendcodeC** | string | Yes | Consolidated/Contractor Vendor | Often same as vendcode | `JOIN vendmas (vendcode)` |
 | **PODoc** | string | Yes | Physical Document Serial | e.g., "CJOB/2019-20/0034"| Reference indexing |
 | **CGST_TaxPer** | number | Yes | Central GST Percentage | e.g., 6.0, 9.0 | Tax calculation |
 | **CGST_Amt** | number | Yes | Central GST Amount | Decimal values | Financial reporting |
 | **SGST_TaxPer** | number | Yes | State GST Percentage | e.g., 6.0, 9.0 | Tax calculation |
 | **SGST_Amt** | number | Yes | State GST Amount | Decimal values | Financial reporting |
 | **IGST_TaxPer** | number | Yes | Integrated GST Percentage | e.g., 12.0, 18.0 | Tax calculation |
 | **IGST_Amt** | number | Yes | Integrated GST Amount | Decimal values | Financial reporting |
 | **TotalAMt** | number | Yes | Total Invoice Value (Incl Tax) | Decimal values | Payment processing |
 | **Location** | string | Yes | Physical Dispatch/Job Location | e.g., "Plant A" | Filtering by site |
 | **ValidUpTo** | datetime | Yes | Order Expiry Date | ISO Dates | Compliance checks |
 
 ### 3) Relationships & Join Map
 
 #### Parent Table
 * **company**: Linked by `compcode` for entity details.
 
 #### Child Tables (Direct Joins)
 * **cjobpodtl**: Join on `pono`, `compcode`, and `invyear`. This provides item-level job operations.
 * **cjobpoduty**: Join on `pono` and `compcode`. This provides granular tax breakdowns if headers are summarized.
 * **cjobpohdramnd**: Join on `pono`, `compcode`, and `invyear`. This accesses the history of changes for a specific PO.
 
 #### Reference Tables
 * **vendmas**: Join on `vendcode` (and `compcode`) to retrieve vendor names and GST details.
 * **cItemmas**: Join indirectly through `cjobpodtl` (on `citmcode`) to get service/item descriptions.
 * **location**: Join on `Location` (and `compcode`) for site metadata.
 
 #### Likely Joins (Based on inferred workflow)
 * **cmrrhdr**: Join on `pono`, `compcode`, and `vendcode`. To track goods/service receipts against this PO.