jobhdr

### 1) Overview
 The `jobhdr` table serves as the primary header for tracking **1st Operation Job Work** transactions. It records the issuance of raw materials to external vendors or specific internal locations for processing into semi-finished or finished items. It acts as the "Outward" record in the job-work cycle, documenting the raw material weight provided, the expected piece count, specific manufacturing methods, and associated tax implications (GST).
 
 Key functional areas include:
 * **Material Issuance**: Tracking specific raw material batches (`mrpno`, `lotno`) and weights (`rmweight`) sent out.
 * **Production Planning**: Defining the target item (`itemcode`) and quantity (`pcs`).
 * **Compliance**: Managing excise/GST documentation (`exciseno`, `doc`) and E-way bill details.
 * **Audit & Reconciliation**: Providing the baseline for material reconciliation against receipts in `mrcirhdr` and adjustments in `billagainstwo`.
 
 ### 2) Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | No | Primary Key (Internal) | Unique ID | `PRIMARY KEY` |
 | **compcode** | string | No | Company Code | e.g., 'DAS', 'BAM' | Join key to most tables. |
 | **jobcardno** | integer | No | Unique Job Card Number | Sequential integer | Main identifier for job work receipts and returns. |
 | **jobdate** | datetime | No | Date of material issuance | ISO Datetime | Used for aging and period reporting. |
 | **vendcode** | string | No | Vendor Account Code | e.g., 'PDF01' | Joins to `vendmas(vendcode)`. |
 | **exciseno** | string | Yes | Excise/Challan Reference No | Document Number | Used for legal documentation and reporting. |
 | **excisedate** | datetime | Yes | Date of Excise Document | ISO Datetime | Reference date for tax compliance. |
 | **noofcoil** | integer | Yes | Number of material coils issued | e.g., 0, 1, 2 | Used for inventory tracking. |
 | **remarks** | string | Yes | General notes or reference numbers | e.g., '14071' | Descriptive metadata. |
 | **rmcode** | string | No | Raw Material Item Code | e.g., '50C-60' | Joins to `rmmas(rmcode)`. |
 | **rmweight** | number | No | Weight of raw material issued | KGS | Basis for material reconciliation. |
 | **mrpno** | integer | Yes | MRP Batch Reference Number | From `rmincoming` | Links issuance to specific material receipt batch. |
 | **lotno** | string | Yes | Production Lot Number | e.g., '14070J-1' | Tracking specific production runs. |
 | **pcs** | integer | No | Expected number of pieces | Piece count | Target quantity for the job worker. |
 | **itemcode** | string | No | Target Item to be produced | e.g., 'BUSH337' | Joins to `itemmas(itemcode)`. |
 | **method_code** | string | Yes | Manufacturing Method Identifier | e.g., 'TURN0001' | Joins to `manuf_method(method_code)`. |
 | **useradd** | string | Yes | User who created the record | Username | Audit trail. |
 | **addtime** | string | Yes | Timestamp of creation | Date/Time string | Audit trail. |
 | **usermod** | string | Yes | User who last modified the record | Username | Modification audit. |
 | **modtime** | string | Yes | Timestamp of last modification | Date/Time string | Modification audit. |
 | **printflag** | string | Yes | Printing Status | null, 'Y', 'N' | Controls document printing. |
 | **time** | string | Yes | Time of issuance | HH:MM | Removal time tracking. |
 | **username** | string | Yes | System user associated with record | Username | Security tracking. |
 | **dtofremoval** | string | Yes | Date/Time of material removal | e.g., '21.09.2024 / 11:40 Hrs' | Required for E-way bill/Annexure. |
 | **heatno** | string | Yes | Material Heat/Melt Number | Batch Property | Physical traceability. |
 | **excise_copy** | string | Yes | Flag for excise copy status | 'Y', 'N' | Compliance tracking. |
 | **excise_rdate** | string | Yes | Excise Return Date | Date string | Tracks return document timelines. |
 | **tacptqty** | number | Yes | Total Accepted Quantity (Aggregated) | Pieces | Summary of receipts. |
 | **tscrapqty** | number | Yes | Total Scrap Quantity (Aggregated) | Pieces | Summary of loss. |
 | **cw** | number | Yes | Calculated Weight per 1000 pcs | numeric | `(Qty * cw / 1000)` = Weight conversion. |
 | **tpcode** | string | Yes | Transporter Code | e.g., 'T001' | Joins to `transptmas(tpcode)`. |
 | **despthru** | string | Yes | Despatch Through / Vehicle No | Vehicle ID | Logistics tracking. |
 | **location** | string | Yes | Storage/Physical Location | e.g., 'BOP' | Joins to `location(loccode)`. |
 | **consignee** | string | Yes | Destination Party Code | e.g., 'PDF01' | Joins to `vendmas(vendcode)`. |
 | **through** | string | Yes | Intermediate agent/Transporter | Descriptive | Logistics metadata. |
 | **itemvalue** | number | Yes | Assessable Value of items | Currency | Basis for GST calculation. |
 | **SampleFlag** | string | Yes | Is this a sample issuance? | 'Y', 'N' | Filtering non-commercial shipments. |
 | **CGST_TaxPer** | number | Yes | CGST Percentage | e.g., 9.0 | Tax calculation. |
 | **CGST_Amt** | number | Yes | CGST Amount | Currency | Tax accounting. |
 | **SGST_TaxPer** | number | Yes | SGST Percentage | e.g., 9.0 | Tax calculation. |
 | **SGST_Amt** | number | Yes | SGST Amount | Currency | Tax accounting. |
 | **IGST_TaxPer** | number | Yes | IGST Percentage | e.g., 18.0 | Tax calculation. |
 | **IGST_Amt** | number | Yes | IGST Amount | Currency | Tax accounting. |
 | **TotalAMt** | number | Yes | Total Gross Invoice Value | Currency | Financial reporting. |
 | **JobRGPFlag** | string | Yes | Job vs Returnable Gate Pass | 'J', 'R' | Categorization. |
 | **doc** | string | Yes | System generated document ID | e.g., 'MT/24-25/01260' | Display reference for users. |
 | **close_flag** | string | Yes | Closure status of Job Card | 'Y', null | Indicates if job is complete. |
 | **Vehicle** | string | Yes | Specific Vehicle Number | e.g., 'DL01-1234' | Logistic reference. |
 | **IRNo** | string | Yes | Inspection Report Number | Reference | Link to QA records. |
 | **CurOprCode** | string | Yes | Current Operation Code | e.g., 'BC' | Joins to `oprmas(oprcode)`. |
 | **Calculated_Scrap** | number | Yes | Expected material loss weight | Weight | Reconciliation metric. |
 | **Tot_Allowed_ScrapPer** | number | Yes | Permissible scrap percentage | Percentage | Contractual limit for loss. |
 | **Valid_grace_date** | string | Yes | Extended return date | Date string | Vendor management. |
 | **Cancel_flag** | string | Yes | Record Cancellation status | 'Y', 'N' | Filtering valid transactions. |
 | **mannual_MRN** | string | Yes | Manual Material Receipt Note No | Reference | Offline record link. |
 | **nOprCode** | string | Yes | Next Operation Code | e.g., 'IBH' | Joins to `oprmas(oprcode)`. |
 | **e_waybill_no** | string | Yes | GST E-Way Bill Number | e.g., '1213...' | Logistics compliance. |
 | **e_waybill_date** | string | Yes | E-Way Bill Generation Date | Date string | Logistics compliance. |
 
 ### 3) Relationships & Join Map
 
 #### Authoritative Physical Joins (SCHEMA_MAP):
 * **Vendor Details**: Join `jobhdr.vendcode` to `vendmas.vendcode` (and `compcode`).
 * **Item Master**: Join `jobhdr.itemcode` to `itemmas.itemcode` (and `compcode`).
 * **Raw Material Details**: Join `jobhdr.rmcode` to `rmmas.rmcode` (and `compcode`).
 * **Inward Receipt Reconciliation**: Join `jobhdr.jobcardno` to `mrcirhdr.jobcardno` (and `compcode`). This is critical for tracking how many pieces were received back from the weight issued.
 * **Operation Mapping**: Join `jobhdr.CurOprCode` or `nOprCode` to `oprmas.oprcode`.
 * **Transporter**: Join `jobhdr.tpcode` to `transptmas.tpcode` (and `compcode`).
 * **Batch Origin**: Join `jobhdr.mrpno` to `rmincoming.mrpno` (and `compcode`).
 * **Bill Adjustments**: Join `jobhdr.jobcardno` to `billagainstwo.jobno` (Likely - based on SP logic `j.jobcardno=w.jobno`).
 
 #### Likely Logical Relationships:
 * **Lot Tracking**: `lotno` links to `product2` or `RMproduct1` for manufacturing genealogy.
 * **QA/Inspection**: `IRNo` links to `iteminspectionhdr.irno`.
 * **Material Returns**: Joins to `rmreturn.jobno` (using `jobcardno`).