nonmovingitemCstore

### 1) Overview
 The `nonmovingitemCstore` table is a specialized analytical or reporting table used to track inventory items within the "C-Store" (typically consumables, maintenance, or indirect materials) that have been classified as non-moving. It stores the company context, item identifiers, and the volume and value of the last relevant purchase activity for these stagnant items.
 
 ### 2) Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | NO | Primary key / Row identifier | | Primary Key |
 | **compcode** | string | YES | Unique identifier for the company/branch | e.g., "DAS" | Filter/Join (Partitioning) |
 | **citmcode** | string | YES | Consumable Item Code (often space-padded) | e.g., "0005", "2009500000" | Join (Item ID) |
 | **uom** | string | YES | Unit of Measure | PCS, KGS, NOS, MTR, SET | Reference |
 | **purqty** | number | YES | Purchase Quantity recorded for the item | | Aggregation |
 | **puramt** | number | YES | Total Purchase Amount/Value for the item | | Aggregation/Reporting |
 
 ### 3) Relationships & Join Map
 
 The table is primarily linked to the Consumable Item Master and various procurement/receipt tables via the `citmcode`.
 
 #### Authoritative Joins (via SCHEMA_MAP):
 * **dbo.citemmas (citmcode, compcode):** Join to retrieve item names, categories, and current stock levels for non-moving items.
 * **dbo.cpodtl (citmcode, compcode):** Join to find the specific Purchase Orders associated with these non-moving quantities.
 * **dbo.cmrrdtl (citmcode, compcode):** Join to find the last receipt date (MRR) to determine exactly how long the item has been sitting in the store.
 * **dbo.cjobpodtl (citmcode, compcode):** Join to check if the item was purchased for a specific job or operation.
 * **dbo.rgpdtl (citmcode, compcode):** Join to check if any of these non-moving items are currently out on a Returnable Gate Pass (RGP).
 
 #### Likely Joins (Inferred):
 * **dbo.UoMMaster (uom):** Likely used to convert units if the purchase unit differs from the stock unit.
 
 ---