tables · table
cmrpreqitem
The cmrpreqitem table serves as the line-item detail repository for Consumable Material Requisitions (Indents). It breaks down the specific items, quantities, and estimated rates associated with an indent header record (cmrpreq). It is primarily used for tracking internal stock requirements and serves as the basis for generating Purchase Orders for consumables.
Row count
1
Last entry
—
Source
tables
Columns
9| Column | Type | Nullable | Meaning |
|---|---|---|---|
index | integer | NO | Primary key (Identity) |
compcode | string | NO | Company identifier |
indentno | integer | NO | Unique Indent/Requisition number |
itemcode | string | NO | Code for the consumable item |
uom | string | YES | Unit of Measure |
indentqty | number | YES | Quantity requested in the indent |
itemrate | number | YES | Estimated or standard rate per unit |
remarks | string | YES | Item-specific instructions or justifications |
sqty | number | YES | Supplied/Short quantity tracking |
Full documentation
### 1) Overview The `cmrpreqitem` table serves as the **line-item detail repository** for Consumable Material Requisitions (Indents). It breaks down the specific items, quantities, and estimated rates associated with an indent header record (`cmrpreq`). It is primarily used for tracking internal stock requirements and serves as the basis for generating Purchase Orders for consumables. ### 2) Column Dictionary | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage | | :--- | :--- | :--- | :--- | :--- | :--- | | **index** | integer | NO | Primary key (Identity) | Auto-incrementing | `PK` | | **compcode** | string | NO | Company identifier | e.g., 'DAS' | `JOIN` | | **indentno** | integer | NO | Unique Indent/Requisition number | From `cmrpreq` | `JOIN` | | **itemcode** | string | NO | Code for the consumable item | e.g., 'SODIUMCIYLICADE' | `JOIN` (to `citemmas`) | | **uom** | string | YES | Unit of Measure | KGS, NOS, PCS | Display | | **indentqty** | number | YES | Quantity requested in the indent | e.g., 2.0 | Aggregation | | **itemrate** | number | YES | Estimated or standard rate per unit | e.g., 40.0 | Costing | | **remarks** | string | YES | Item-specific instructions or justifications | e.g., 'for coil repairing' | Audit | | **sqty** | number | YES | Supplied/Short quantity tracking | 0.0 (Default) | Fulfillment tracking | ### 3) Relationships & Join Map #### Parent Table * **dbo.cmrpreq**: This is the header table for requisitions. * **Join Logic**: `cmrpreqitem.indentno = cmrpreq.indentno` AND `cmrpreqitem.compcode = cmrpreq.compcode` #### Master Data Lookups * **dbo.citemmas**: Used to retrieve descriptive names and categories for consumables. * **Join Logic**: `cmrpreqitem.itemcode = citemmas.citmcode` AND `cmrpreqitem.compcode = citemmas.compcode` * **dbo.UoMMaster**: Used to validate or convert units. * **Join Logic**: `cmrpreqitem.uom = UoMMaster.PUoM` AND `cmrpreqitem.compcode = UoMMaster.compcode` #### Downstream Processes * **dbo.cpodtl** (Consumable Purchase Order Details): Used when an indent is converted into a purchase order. * **Join Logic**: `cmrpreqitem.indentno = cpodtl.indentno` (Likely, as indicated in `cpohdr` logic)