rgpdtl

### 1) Overview
 The `rgpdtl` (Returnable Gate Pass Detail) table serves as the line-item repository for Returnable Gate Passes. It tracks specific items (primarily consumable or capital items) sent out of the facility that are expected to be returned. Each record stores the quantity issued, the value (rate), and taxonomic identification (HSN). This table is a child of `rgphdr` and is critical for inventory reconciliation and tracking outstanding items with vendors.
 
 ### 2) Column dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | NO | Internal primary key/row identifier | | Primary Key |
 | **compcode** | string | NO | Company Identifier | e.g., 'pkc' | Join; Filter |
 | **rgpno** | integer | NO | Returnable Gate Pass unique number | | Join (Parent: `rgphdr`) |
 | **citmcode** | string | NO | Consumable/Capital Item Code | e.g., 'MOTOR01' | Join (Master: `citemmas`) |
 | **qtyissued** | number | NO | Total quantity sent out | | Calculation |
 | **make** | integer | YES | Manufacturer or Brand identifier | e.g., 1, 48 | Join (Likely: `brandmas.Br_code`) |
 | **rate** | number | YES | Unit rate/value of the item | | Valuation |
 | **partno** | string | YES | Manufacturer part number | | Descriptive |
 | **remdetail** | string | YES | Remarks or specific details for the line item | | Descriptive |
 | **HSN** | string | YES | Harmonized System of Nomenclature code | | Tax Reporting |
 
 ### 3) Relationships & join map
 
 #### Primary Relationships:
 * **rgphdr (Parent):** Joins on `compcode` and `rgpno`. This identifies the header details like date, vendor, and destination for the items listed here.
 * **citemmas (Master):** Joins on `compcode` and `citmcode`. Provides item descriptions, unit of measure (UoM), and category.
 * **cmrrdtl (Transaction):** Joins on `compcode`, `rgpno`, and `citmcode`. Used to reconcile how much of the issued quantity has been received back (Material Return Receipt).
 
 #### Secondary/Likely Joins:
 * **brandmas:** Joins on `compcode` and `make` (where `make` = `brandmas.Br_code`). Provides the brand name for the issued item.
 * **company:** Joins on `compcode` for multi-tenant reporting.