tempjobcenvat

### 1) Overview
 The `tempjobcenvat` table is a temporary or staging table used to process or report on excise-related data (CENVAT) linked to specific job cards. It tracks the quantities received and scrapped for a particular job, likely during the calculation of tax credits or regulatory filings. Given the "temp" prefix, it is frequently used in stored procedures or batch reporting processes.
 
 ### 2) Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | NO | Primary key/Internal row identifier | 0, 1, 2... | `ORDER BY`, `WHERE` |
 | **compcode** | string | YES | Company Code | e.g., "DAS" | `JOIN`, `WHERE` |
 | **jobcardno** | integer | YES | The unique identifier for a production job card | e.g., 202515386 | `JOIN`, `GROUP BY` |
 | **jobdate** | datetime | YES | The date the job was processed or recorded | | `WHERE` (Date Range) |
 | **recqty** | number | YES | Received Quantity: The amount of material received back | 0.0, 3536.0 | `SUM` |
 | **scrapqty** | number | YES | Scrap Quantity: Material wasted during the job | | `SUM` |
 | **exciseno** | integer | YES | Excise Invoice or Document Number for CENVAT tracking | | `JOIN`, `WHERE` |
 
 ### 3) Relationships & Join Map
 
 The table serves as a bridge between production job cards and tax/excise records.
 
 #### Primary Joins (Physical Columns)
 * **dbo.jobhdr** (via `jobcardno`, `compcode`): To retrieve full header details of the job (Customer, Item, Status).
 * **dbo.jobdtl** (via `jobcardno`, `compcode`): To link back to specific operation-level details of the job card.
 * **dbo.rmjobhdr** (via `jobcardno`, `compcode`): To link with Raw Material specific job processing and excise numbers.
 * **dbo.vendmas** (via `exciseno`, `compcode`): Likely link to vendor records if the excise number is tied to a specific supplier or subcontractor.
 
 #### Secondary Joins (Logical/Likely)
 * **dbo.mrcirhdr** (via `jobcardno`): To correlate received quantities with Material Receipt Challenge Inspection Reports.
 * **dbo.vendbillcomproforma** (via `jobno` [likely matches `jobcardno`], `exciseno`): Used for proforma billing reconciliation.