rmincoming

This table, `rmincoming`, serves as the primary transaction ledger for **Incoming Raw Material Receipts** (often referred to as Material Receipt Notes or GRNs). It tracks the lifecycle of raw material from the point of entry (Gate Pass) through invoice verification, weight reconciliation (Billed vs. Received vs. Accepted), and quality inspection. It is a central hub for raw material inventory accounting and supplier performance auditing.
 
 ### 1. Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | No | Primary Key | Auto-increment | Internal reference |
 | **compcode** | string | No | Company Identifier | e.g., "DAS", "HFL" | Filtering by business unit |
 | **mrpno** | integer | No | Material Receipt Plan/Note No | e.g., 1, 2, 3 | Unique Receipt ID for joins |
 | **mrpdate** | datetime | No | Receipt/GRN Date | | Temporal reporting, aging |
 | **gpno** | integer | Yes | Gate Pass Number | | Inward gate entry tracking |
 | **gpdate** | datetime | Yes | Gate Pass Date | | Logistics lead time analysis |
 | **pono** | number | Yes | Purchase Order Number | | Join to `rmpotab` |
 | **billno** | number | Yes | Supplier Invoice Number | | Financial reconciliation |
 | **billdate** | datetime | Yes | Supplier Invoice Date | | Payment cycle calculation |
 | **rmcoil** | integer | Yes | Number of Coils Received | | Quantity for coil-based RM |
 | **rmwt** | number | Yes | Gross Received Weight | | Input for stock calculation |
 | **rmrate** | number | Yes | Purchase Price per Unit | | Costing and valuation |
 | **billwt** | number | Yes | Invoiced Weight | | Reconciliation with `rmwt` |
 | **acptwt** | number | Yes | Quality Accepted Weight | | Actual stock increment |
 | **rejtdwt** | number | Yes | Quality Rejected Weight | | Debit note trigger |
 | **irno** | integer | Yes | Inspection Report Number | | Join to `rminspectionreport` |
 | **irdate** | datetime | Yes | Inspection Date | | QC cycle tracking |
 | **supcode** | string | No | Supplier Code | e.g., "ST" | Join to `suppmas` |
 | **rmcode** | string | No | Raw Material Code | e.g., "ROD27.50" | Join to `rmmas` |
 | **billamount** | number | Yes | Total Invoice Value | | Account Payables input |
 | **username** | string | Yes | Creating User | | Audit trail |
 | **actual** | string | Yes | Actual Flag | 'Y', 'N' | Filtering valid transactions |
 | **tcno** | string | Yes | Test Certificate Number | | Often stores Heat Number |
 | **stock_flag** | string | Yes | Inventory Impact Flag | 'Y' (Stock), 'N' (Direct) | Inventory vs Expense logic |
 | **hsn** | string | Yes | Harmonized System Nomenclature | | GST Compliance |
 | **Vou_Auth_flag** | string | Yes | Voucher Authorized Flag | 'Y', 'N' | Financial finalization |
 | **PhyLocation** | string | Yes | Physical Storage Bin | | Warehouse management |
 
 ### 2. Relationships & Join Map
 
 The table `rmincoming` acts as a transactional bridge between Procurement, Quality, and Inventory.
 
 #### Primary Joins (Confirmed via SCHEMA_MAP)
 * **Raw Material Master:** Join with `dbo.rmmas` (`rmcode`, `compcode`) to retrieve material descriptions, UoM, and sizes.
 * **Supplier Master:** Join with `dbo.suppmas` (`supcode`, `compcode`) to fetch supplier names, GST details, and addresses.
 * **Purchase Orders:** Join with `dbo.rmpotab` (`pono`, `compcode`) to compare receipt quantities against ordered quantities.
 * **Coil-Level Details:** Join with `dbo.rmincomingcoil` (`mrpno`, `compcode`) for specific weight and hardness details per individual coil.
 * **Quality Inspections:** Join with `dbo.rminspectionreport` (`irno` or `mrpno`, `compcode`) to view detailed test parameters.
 * **GST Reporting:** Joins with `dbo.srnduty` (`mrpno`, `compcode`) to retrieve broken-down tax components (CGST, SGST, IGST) for the receipt.
 
 #### Likely Joins (Inferred from SP Logic)
 * **Debit/Credit Notes:** Joins with `dbo.debithdr` (`mrpno`, `compcode`) when `rejtdwt` triggers a "Rejection of Qty" reason for financial recovery.
 * **Production Issues:** Joins with `dbo.rmjobrec1st` (`mrpno`, `compcode`) when raw material is issued for Job Work or 1st-stage operations.
 * **Locations:** Joins with `dbo.location` (`location`, `compcode`) for departmental tracking of stock.
 
 ### 3. Summary Block