jobpodtl

### 1) Overview
 The `jobpodtl` table serves as the line-item detail repository for Job Purchase Orders (JPOs). It records specific manufacturing operations (e.g., Annealing, CNC Turning, Plating) required for individual items, assigning each operation a specific unit rate, operation code, and unit of measure. This table is primarily used to determine the financial rates applied during the job-work receiving process (`mrcirhdr`, `mrci_rep`) when billing vendors for services rendered.
 
 ### 2) Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | No | Primary Key | | PK |
 | **compcode** | string | No | Company Identifier | e.g., "DAS", "OMA" | Join, Filter |
 | **pono** | integer | No | Purchase Order Number | | Join, Reference |
 | **itemcode** | string | No | Physical Item Identifier | e.g., "CP-005", "9112" | Join, Reference |
 | **operation** | string | Yes | Verbose description of the process | e.g., "CNC TURNING 1ST" | Display |
 | **poqty** | string | Yes | Quantity allocated to this line item | Often "0" in rate contracts | Calculation |
 | **uom** | string | Yes | Unit of Measure | PCS, KGS | Display |
 | **rate** | number | Yes | Unit price/rate for the specific operation | | Financial Calc |
 | **oprcode** | string | Yes | Standardized Operation Code | e.g., "ANE", "CNC1" | Join, Filter |
 | **invyear** | integer | No | Inventory/Accounting Year | e.g., 2024, 2025 | Join, Filter |
 | **oprdetail** | string | Yes | Extended operation description | | Display |
 | **itemlock** | string | Yes | Logical lock flag for the item-operation | "N" (Active), "Y" (Locked) | Filter |
 | **sno** | number | Yes | Serial number/Line sequence | | Sorting |
 
 ### 3) Relationships & Join Map
 
 Based on `SCHEMA_MAP` and logic identified in `REFERENCE_JSON`, the table connects to the following:
 
 #### Primary Joins
 * **dbo.jobpohdr (pono, compcode, invyear)**: Links to the purchase order header for vendor information and validity dates.
 * **dbo.itemmas (itemcode, compcode)**: Links to the master item definition for item names, part numbers, and HSN codes.
 * **dbo.oprmas (oprcode, compcode)**: Resolves the standardized operation codes into verbose operation names.
 
 #### Likely Process Joins (Used for Rate Lookup)
 * **dbo.mrci2dtl (itemcode, oprcode, compcode)**: Used in billing procedures to match actual work received against the PO rates defined here.
 * **dbo.mrcirdtl (itemcode, oprcode, compcode)**: Joins during Jobwork Return processing to apply the correct operational rate for invoice generation.
 * **dbo.onlinerej_dtl (itemcode, oprcode, compcode)**: Joined during rejection processing (likely) to calculate the value of rejected parts based on their processed state.
 
 #### Join Example
 ```sql
 SELECT 
  h.vendcode, 
  d.itemcode, 
  d.operation, 
  d.rate 
 FROM dbo.jobpodtl d
 INNER JOIN dbo.jobpohdr h ON d.pono = h.pono AND d.compcode = h.compcode AND d.invyear = h.invyear
 WHERE d.itemlock = 'N';
 ```