job

This table, **`job`**, serves as a primary transaction ledger for **Secondary Operation Job Work**. It tracks materials sent outward to vendors for specific processing steps (e.g., CNC machining, milling). It captures quantities (pieces and weight), financial data including GST breakdown, conversion factors (`cw`), and statuses for returnable gate passes (`JobRGPFlag`). It is a critical component for tracking work-in-progress (WIP) that has been outsourced to external vendors.
 
 ### 1. Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | NO | Primary Key index | | PK |
 | **compcode** | string | NO | Company Identifier | e.g., "DAS" | Join; Filter |
 | **jobno** | integer | NO | Unique Job Card / Work Order Number | | Join; Filter |
 | **jobdate** | datetime | NO | Date the job was initiated | | Filter; Range |
 | **vendcode** | string | NO | Vendor identifier processing the job | e.g., "PDF01" | Join (vendmas) |
 | **itemcode** | string | NO | The primary item code being sent | | Join (itemmas) |
 | **itemcode1** | string | YES | Secondary or required item code | | Join (itemmas) |
 | **oprcode** | string | YES | Operation code to be performed | CNC1, MILLING, VMC | Join (oprmas) |
 | **pcs** | number | YES | Quantity in pieces | | Aggregation |
 | **weight** | number | YES | Net weight of the material | | Aggregation |
 | **cw** | number | YES | Conversion Weight (typically weight per 1000 pcs) | e.g., 1050.0 | Calculation |
 | **uom** | string | YES | Unit of Measure | PCS, KGS | Filter |
 | **lotno** | string | YES | Production Batch/Lot Number | | Filter; Tracking |
 | **sublotno** | string | YES | Specific sub-batch identifier | | Tracking |
 | **itemvalue** | number | YES | Taxable value of the items | | Calculation |
 | **CGST_Amt** | number | YES | Central GST Amount | | Financial |
 | **SGST_Amt** | number | YES | State GST Amount | | Financial |
 | **IGST_Amt** | number | YES | Integrated GST Amount | | Financial |
 | **TotalAMt** | number | YES | Grand total (Value + Taxes) | | Aggregation |
 | **JobRGPFlag** | string | YES | Returnable Gate Pass Flag | R, J | Filter |
 | **RM_Item_Flag** | string | YES | Item category flag | I (Item), R (Raw Material) | Filter |
 | **close_flag** | string | YES | Completion status | Y, N | Filter |
 | **cancel_flag** | string | YES | Cancellation status | Y, N | Filter |
 | **doc** | string | YES | Physical Document Reference | e.g., "MT/23-24/00001" | Reference |
 | **heatno** | string | YES | Material Heat Number | | Tracking |
 | **modepack** | string | YES | Packaging method | Tanki, Bin, Tray | Reference |
 | **consignee** | string | YES | Recipient of the material | | Join (vendmas) |
 
 ### 2. Relationships & Join Map
 
 The `job` table is the "Outward" anchor for outsourced production. It relates to material receipts, vendor masters, and operation definitions.
 
 #### Primary Joins (Authoritative):
 * **Secondary Operations (Detail):** Join `job.jobno` to `job2dtl.jobno` (and `compcode`) to retrieve specific operation rates and scrap permissions.
 * **Material Receipts (Inward):** Join `job.jobno` to `mrci_rep.jobno` (and `compcode`) to reconcile quantities received back from the vendor against the quantity sent.
 * **Vendor Info:** Join `job.vendcode` to `vendmas.vendcode` (and `compcode`) to get vendor names and GST details.
 * **Item Definitions:** Join `job.itemcode` to `itemmas.itemcode` (and `compcode`) for part names and standard weights.
 * **Operations Info:** Join `job.oprcode` to `oprmas.oprcode` (and `compcode`) to identify the specific process being performed.
 * **Billing Reconciliation:** Join `job.jobno` to `billagainstwo.jobno` (and `compcode`) to track payments and quantity adjustments.
 
 #### Indirect/Likely Joins:
 * **Gate Exit:** Join `job.jobno` to `rgphdr.rgpno` (Likely, when gate passes are generated for outsourced jobs).
 * **Logistics:** Join `job.tpcode` to `transptmas.tpcode` to identify the transporter used for dispatch.