semidtl

### 1) Overview
 The `semidtl` table stores transaction-level line items for semi-finished (SEMI) material processes or receipts. It contains detailed data regarding quantities (Challan, Received, Accepted, Rejected), pricing, and tax components. Based on the data samples, this table is used to store both physical item lines and calculated summary lines (such as Basic Value, IGST, and Net Amount) identified by specific line number ranges (e.g., 100, 999).
 
 ### 2) Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | NO | Primary key for the record. | | PK |
 | **compcode** | string | NO | Company identifier code. | e.g., "DAS" | FK / Join |
 | **mrpno** | number | NO | Material Receipt/Process Number referencing the header. | e.g., 10109.0 | FK / Join |
 | **line** | integer | NO | Sequence line number. High values (100+) often denote tax/total lines. | 1, 100, 999 | Filter |
 | **itemcode** | string | YES | Unique identifier for the item. | | FK / Join |
 | **itemname** | string | YES | Description of the item or the name of the tax component. | "SHAFT...", "IGST" | Display |
 | **amount** | number | YES | The line value or specific tax value. | | Summation |
 | **uom** | string | YES | Unit of Measure. | e.g., "PCS" | Join |
 | **chqty** | number | YES | Challan Quantity (quantity mentioned on the delivery document). | | Calculation |
 | **recqty** | number | YES | Received Quantity (physical count at receipt). | | Calculation |
 | **acptqty** | number | YES | Accepted Quantity after inspection. | | Calculation |
 | **rejqty** | number | YES | Rejected Quantity after inspection. | | Calculation |
 | **rate** | number | YES | Unit price of the item. | | Calculation |
 | **amount1** | number | YES | Extended value (Rate * Qty or tax component value). | | Summation |
 | **HeatNo** | string | YES | Manufacturing heat number or batch number for traceability. | | Filtering |
 | **Irno** | number | YES | Inspection Report number referencing quality checks. | | Join |
 | **DebitQty** | string | YES | Quantity associated with a debit note (if applicable). | | Likely |
 | **DebitValue**| string | YES | Financial value of the debit associated with this line. | | Likely |
 | **oldrate** | string | YES | Previous rate if a price revision occurred. | | Historical |
 | **hsn** | string | YES | Harmonized System of Nomenclature code for GST classification. | | Reporting |
 
 ---
 
 ### 3) Relationships & Join Map
 
 The `semidtl` table acts as the child detail for semi-finished inventory transactions. It primarily links to the header table and the item master.
 
 #### Primary Joins (SCHEMA_MAP Verified)
 * **dbo.semihdr**: Joins on `compcode` and `mrpno`. This retrieves the document date, supplier, and general status.
 * **dbo.itemmas**: Joins on `compcode` and `itemcode`. This provides item technical specs, categories, and HSN masters.
 * **dbo.UoMMaster**: Joins on `compcode` and `uom`. Used for unit conversions.
 
 #### Downstream & Contextual Joins
 * **dbo.Debitdtl**: Joins on `compcode` and `mrpno` (aliased as `MRPNo` in `Debitdtl`). Used to find debit notes issued against these specific receipts.
 * **dbo.fghdr**: Joins on `compcode` and `mrpno`. Links semi-finished receipts to finished goods production batches.
 * **dbo.Performainvdtl**: Joins on `compcode` and `mrpno`. Used if proforma invoices are generated based on these receipt details.
 
 ---