incondtl

### 1. Overview
 The `incondtl` table serves as the line-item detail repository for inward material receipts (MRPs) specifically for **consumable items**. It tracks the lifecycle of a received item from the quantity mentioned on the vendor's challan (`chqty`) to the physical quantity received (`recqty`), and the subsequent quality check results (Accepted: `acptqty` vs. Rejected: `rejqty`).
 
 This table is frequently utilized in inventory reports, financial monitoring, and GST input calculations. It acts as the detail-level counterpart to the `incomconitem` header table.
 
 ### 2. Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | No | Internal primary key (Pandas-generated). | | PK |
 | **compcode** | string | No | Unique identifier for the company/branch. | e.g., "DAS", "HFL" | Join to `dbo.company (compcode)` |
 | **mrpno** | integer | No | Material Receipt Posting number; unique document ID. | | FK to `dbo.incomconitem (mrpno)` |
 | **citmcode** | string | No | Unique code for the consumable item. | e.g., "GAS01", "OIL001" | FK to `dbo.citemmas (citmcode)` |
 | **chqty** | number | Yes | Quantity specified on the supplier's Challan. | | Measurement |
 | **recqty** | number | Yes | Physical quantity actually received at the gate/store. | | Measurement |
 | **acptqty** | number | Yes | Quantity accepted after quality inspection. | | Measurement |
 | **rejqty** | number | Yes | Quantity rejected after quality inspection. | | Measurement |
 | **rate** | number | Yes | Unit price of the item before discount. | | Price |
 | **mrpdate** | datetime | Yes | Date the material receipt was posted. | | Filtering/Reporting |
 | **discount** | number | Yes | Percentage discount applied to the unit rate. | | Calculation |
 | **make** | integer | Yes | Brand or Manufacturer identifier. | | Likely FK to `dbo.brandmas (br_code)` |
 | **poyn** | boolean | Yes | Flag indicating if this receipt is linked to a Purchase Order. | | Logic |
 | **sno** | integer | Yes | Serial/Line number within the specific `mrpno`. | | Sorting |
 | **hsn** | string | Yes | Harmonized System of Nomenclature code for GST categorization. | | Tax Reporting |
 
 ### 3. Relationships & Join Map
 
 #### Parent Tables
 * **dbo.incomconitem**: Joined on `compcode` and `mrpno` to retrieve receipt header information (Supplier code, Invoice number, GP number).
 * **dbo.citemmas**: Joined on `compcode` and `citmcode` to retrieve item details (Item name, UOM, Group code).
 * **dbo.brandmas**: (Likely) Joined on `compcode` and `br_code` (mapped from `incondtl.make`) to retrieve the manufacturer/brand name.
 
 #### Reference Joins (from Stored Procedures)
 * **dbo.cpohdr / dbo.cpodtl**: Joined via `incomconitem.pono` and `incondtl.citmcode` to track pending Purchase Order quantities.
 * **dbo.csrnduty**: Joined on `compcode` and `mrpno` to calculate GST tax components (CGST, SGST, IGST) for the consumables received.
 * **dbo.citemiss**: Joined via `citmcode` and `compcode` in consumption reports to analyze purchase vs. issuance trends.
 
 ### SQL Join Example
 ```sql
 SELECT 
  h.mrpno, 
  h.supcode, 
  d.citmcode, 
  m.citemname, 
  d.acptqty, 
  (d.rate * (1 - d.discount/100)) AS net_rate
 FROM dbo.incomconitem h
 INNER JOIN dbo.incondtl d ON h.mrpno = d.mrpno AND h.compcode = d.compcode
 INNER JOIN dbo.citemmas m ON d.citmcode = m.citmcode AND d.compcode = m.compcode
 WHERE h.mrpdate >= '2023-01-01';
 ```