All tables
tables · table

nonretitmdtl

The nonretitmdtl table serves as the line-item detail repository for Non-Returnable Gate Passes (NRGP). It tracks specific items being moved out of the facility that are not expected to be returned (e.g., consumables, scrap, oils, or packaging materials). Each record identifies the item, the quantity issued, the associated gate pass number (nrgpno), and the financial rate of the item at the time of issue.

Row count
7,748
Last entry
2026-01-15
Source
tables

Columns

12
ColumnTypeNullableMeaning
indexintegerNoPrimary Key / Row Identifier
compcodestringNoCompany Code
nrgpnointegerNoNRGP Transaction Number
citmcodestringNoCatalog Item Code
makeintegerYesManufacturer/Brand Identifier
qtyrequirednumberYesQuantity Requested
qtyissuenumberYesQuantity Actually Issued
nrgpdatedatetimeYesGate Pass Date
ratenumberYesUnit Price of the Item
chnostringYesReference Challan Number
chdatestringYesReference Challan Date
nrgpdocstringYesDocument Path/Reference

Full documentation

### 1) Overview
 The `nonretitmdtl` table serves as the line-item detail repository for **Non-Returnable Gate Passes (NRGP)**. It tracks specific items being moved out of the facility that are not expected to be returned (e.g., consumables, scrap, oils, or packaging materials). Each record identifies the item, the quantity issued, the associated gate pass number (`nrgpno`), and the financial rate of the item at the time of issue.
 
 ### 2) Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | No | Primary Key / Row Identifier | | Unique identifier for the detail line. |
 | **compcode** | string | No | Company Code | e.g., "DAS" | Primary join key for multi-tenant isolation. |
 | **nrgpno** | integer | No | NRGP Transaction Number | | Foreign key linking to the NRGP header (`nonretitm`). |
 | **citmcode** | string | No | Catalog Item Code | e.g., "OIL002", "TAPE001" | Joins to `citemmas` for item master details. |
 | **make** | integer | Yes | Manufacturer/Brand Identifier | | Likely joins to `brandmas.Br_code`. |
 | **qtyrequired** | number | Yes | Quantity Requested | | Used to compare requisition vs. actual issue. |
 | **qtyissue** | number | Yes | Quantity Actually Issued | | Core metric for stock reduction/ledger. |
 | **nrgpdate** | datetime | Yes | Gate Pass Date | | Used for chronological reporting and ledger aging. |
 | **rate** | number | Yes | Unit Price of the Item | | Used to calculate the total value of the NRGP. |
 | **chno** | string | Yes | Reference Challan Number | | External document reference for tracking. |
 | **chdate** | string | Yes | Reference Challan Date | | Date of the linked reference document. |
 | **nrgpdoc** | string | Yes | Document Path/Reference | | Path to scanned copy or digital attachment. |
 
 ### 3) Relationships & Join Map
 
 #### Real Physical Joins (Authoritative)
 Based on `SCHEMA_MAP` and `REFERENCE_JSON`, the following joins are verified:
 
 * **Header Relationship**: Join to `nonretitm` to get vendor information and NRGP status.
  * `nonretitmdtl.nrgpno = nonretitm.nrgpno`
  * `nonretitmdtl.compcode = nonretitm.compcode`
 * **Item Master**: Join to `citemmas` to retrieve item names, UOM, and category.
  * `nonretitmdtl.citmcode = citemmas.citmcode`
  * `nonretitmdtl.compcode = citemmas.compcode`
 * **Manufacturer Details (Likely)**: Join to `brandmas` to resolve the `make` ID.
  * `nonretitmdtl.make = brandmas.Br_code`
  * `nonretitmdtl.compcode = brandmas.compcode`
 * **Challan Reference (Likely)**: Link to physical challan records.
  * `nonretitmdtl.chno = ChallanBinTrayHDR.chno`
  * `nonretitmdtl.compcode = ChallanBinTrayHDR.compcode`
 
 ---