job2dtl

### 1) Overview
 The `job2dtl` table serves as a secondary detail layer for Job Work processing, specifically tracking operations, rates, and item-level specifications for jobs sent to vendors or processed internally. It is heavily utilized in reporting for "Second Operation" job work, calculating ready-to-FG (Finished Goods) stock, and generating Annexure reports for material tracking.
 
 ### 2) Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | NO | Primary Key - internal row identifier | Unique Integer | PK for row identification. |
 | **compcode** | string | NO | Company identifier code | e.g., "DAS", "BPL" | Joins to all system tables. |
 | **jobno** | integer | NO | Reference number to the Job header | | Join to `job.jobno` or `mrci_rep.jobno`. |
 | **oprcode** | string | NO | Operation Code (Process step) | e.g., "TPO", "PY", "FAC", "CLOSE" | Join to `oprmas.oprcode` or `itemopr.oprcode`. |
 | **oprrate** | number | YES | Rate/Cost per unit for this operation | | Used in vendor billing calculations. |
 | **itemcode** | string | NO | Unique code for the item/component | | Join to `itemmas.itemcode`. |
 | **uom** | string | YES | Unit of Measure | "KGS", "PCS" | Used in weight-to-quantity conversions. |
 | **grade** | string | YES | Material grade specification | | Display/Quality check. |
 | **hrc** | string | YES | Hardness Rockwell C scale spec | | Technical specification. |
 | **rework** | string | YES | Flag indicating if this is a rework operation | "Y", "N" | Filter for quality/cost reports. |
 | **pono** | string | YES | Associated Purchase Order number | | Likely joins to `jobpohdr`. |
 | **podate** | string | YES | Associated Purchase Order date | | Reference info. |
 | **amndno** | string | YES | Amendment number | | Tracking document changes. |
 | **amnddate** | string | YES | Amendment date | | Tracking document changes. |
 | **JobRGPFlag** | string | YES | Returnable Gate Pass Flag | "J" (Job), "S" (Scrap) | Material movement type. |
 | **Allowed_ScrapPer** | number | YES | Permissible scrap percentage | | Calculation of `Allowed_Scrap`. |
 
 ### 3) Relationships & Join Map
 
 #### Authoritative Joins (via SCHEMA_MAP)
 * **job** (`compcode`, `jobno`): Connects detail operations to the primary job work header.
 * **itemmas** (`compcode`, `itemcode`): Retrieves item descriptions, part numbers, and drawing references.
 * **oprmas** (`compcode`, `oprcode`): Provides the full name and station details of the process.
 * **itemopr** (`compcode`, `itemcode`, `oprcode`): Links to technical operation parameters like `oprweight` used for KGS/PCS conversions.
 * **mrci_rep** (`compcode`, `jobno`): Used to track receipts against specific job operations (MRCI = Material Receipt Challan Inward).
 * **mrci2dtl** (`compcode`, `jobno`, `oprcode`): Used to match specific inward material details to the expected job operation.
 
 #### Derived Joins (via REFERENCE_JSON)
 * **billagainstwo** (`compcode`, `jobno`): Used in stored procedures to calculate adjusted pieces and final balances for vendor payments.
 * **mrprejhdr** (`compcode`, `jobno`): Used to identify rejected pieces that have been issued back (`qtyrejissued`).
 
 ### Summary