incomconitem

### 1. Overview
 The `incomconitem` table serves as the **header record for Consumable Material Receipts** (Consumable Purchase Register). It captures primary transaction data for incoming consumable goods, including supplier invoice details, gate pass numbers (GP), linked Purchase Orders (PO), and tax/GST summaries. 
 
 In the procurement workflow, this table acts as the parent to `incondtl` (item-level details) and is critical for generating purchase registers, GST input reports, and monitoring consumable consumption across departments.
 
 ### 2. Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | NO | Primary Key (Identity) | Auto-increment | PK |
 | **compcode** | string | NO | Company Identifier | e.g., 'DAS', 'HFL' | Join Key |
 | **mrpno** | integer | NO | Material Receipt Process Number | Unique receipt ID | Join Key (Header-Detail) |
 | **mrpdate** | datetime | YES | Date of Material Receipt | | Filter / Ordering |
 | **pono** | integer | YES | Linked Purchase Order Number | 0 if no PO linked | Join Key to `cpohdr` |
 | **gpno** | integer | YES | Gate Pass Number | Internal security entry ID | Join Key |
 | **gpdate** | datetime | YES | Date of Gate Entry | | Audit/Tracking |
 | **invoiceno** | number | YES | Supplier's Invoice Number | | Filtering |
 | **invoicedate** | datetime | YES | Date on Supplier's Invoice | | Tax Reporting |
 | **invoiceamount** | number | YES | Total Gross Invoice Value | | Financial Summary |
 | **supcode** | string | YES | Supplier/Vendor Code | e.g., 'GIGASES' | Join Key to `suppmas` |
 | **poyn** | boolean | YES | Purchase Order Flag | True/False | Conditional Logic |
 | **podate** | datetime | YES | Purchase Order Date | | Audit/Tracking |
 | **chno** | integer | YES | Supplier's Challan Number | | Audit/Tracking |
 | **chdate** | datetime | YES | Supplier's Challan Date | | Audit/Tracking |
 | **bas_ex_cess_scess**| string | YES | Excise/Cess Detail String | | Legacy Tax Reporting |
 | **acpostingdate** | string | YES | Date posted to Accounts | | Accounting Status |
 | **moddate** | datetime | YES | Record Modification Date | | Audit |
 | **printflag** | string | YES | Printed Status Flag | 'Y' or NULL | Reporting |
 | **reason** | string | YES | Remarks/Reason for Shortage or Rejection | | Comments |
 | **st38** | string | YES | Statutory Form / State Form Detail | | Compliance |
 | **vattype** | string | YES | VAT Classification Type | 'F', 'G' | Likely Tax Logic |
 | **dpcode** | string | YES | Department Code | | Join Key to `dprt_mas` |
 | **useradd** | string | YES | User who added the record | | Audit |
 | **accessvalue** | number | YES | Taxable/Assessable Value | | Tax Calculation |
 | **vouno** | string | YES | Linked Accounting Voucher Number | | Join to Ledger |
 | **vou_type** | string | YES | Voucher Type | 'P' (Purchase) | Reporting |
 | **vou_auth_flag** | string | YES | Voucher Authorization Status | 'Y', 'N' | Financial Control |
 | **Auth_Flag** | string | YES | Transaction Authorization Status | | Workflow |
 | **AcGroupcode** | string | YES | Accounting Group Classification | | Financial Reporting |
 | **taxper** | string | YES | Tax Percentage | | Calculation |
 | **location** | string | YES | Business Location/Plant | | Join to `location` |
 | **Cgst_amt** | string | YES | Central GST Amount | | GST Reporting |
 | **Sgst_amt** | string | YES | State GST Amount | | GST Reporting |
 | **Igst_amt** | string | YES | Integrated GST Amount | | GST Reporting |
 | **Freight_amt** | string | YES | Freight/Transportation Charges | | Costing |
 | **Round_Off** | number | YES | Invoice Rounding Adjustment | | Accounting |
 | **BillDoc** | string | YES | Linked Bill Document Path/Reference | | Document Management |
 
 ### 3. Relationships & Join Map
 
 #### Parent-Child Joins
 * **incondtl**: Joined on `(mrpno, compcode)`. This is the primary relationship to retrieve itemized lines for a consumable receipt.
 
 #### Master Data Joins
 * **suppmas**: Joined on `(supcode, compcode)` to fetch supplier names and addresses.
 * **cpohdr**: Joined on `(pono, compcode)` to link receipts back to the originating Purchase Order.
 * **dprt_mas**: Joined on `(dpcode, compcode)` to associate the purchase with a specific cost center or department.
 * **location**: Joined on `(location, compcode)` for site-specific inventory tracking.
 
 #### Financial Joins
 * **csrnduty**: Joined on `(mrpno, compcode)` to retrieve specific tax/duty breakdowns (e.g., duty codes 51, 52, 53 for GST).
 * **citemmas**: (via `incondtl`) Joined on `(citmcode, compcode)` to identify the specific consumable items received.
 
 #### Usage Context
 * **Purchase Register**: Used in `dbo.PurchaseItemRegister` to consolidate "C" (Consumable) type purchases alongside RM and SF.
 * **GST Reporting**: Primary source for input tax credit records in `dbo.GstRegisterInput`.
 * **Consumption Analysis**: Used in `dbo.CostCenterWiseConsumption` to determine the unit rate of consumed items based on the most recent MRP date.