tables · table
UoMMaster
The UoMMaster table serves as the central repository for defining Units of Measure (UoM) and their corresponding conversion factors within the ERP system. It manages standard units such as "BOX", "KGS", "PCS", and "Feet". This table is critical for normalizing quantity measurements across sales, purchasing, inventory, and production modules, ensuring that conversions between parent and child units are mathematically consistent.
Row count
17
Last entry
—
Source
tables
Columns
5| Column | Type | Nullable | Meaning |
|---|---|---|---|
compcode | string | No | Unique identifier for the company/entity. |
PUoM | string | No | **Parent Unit of Measure**: The base or primary unit identifier. |
CUoM | string | No | **Child Unit of Measure**: The target unit for conversion or a secondary identifier. |
ConValue | number | Yes | **Conversion Value**: The multiplier used to convert from PUoM to CUoM. |
index | integer | No | Physical row identifier (Primary Key in internal storage). |
Full documentation
### 1) Overview The `UoMMaster` table serves as the central repository for defining Units of Measure (UoM) and their corresponding conversion factors within the ERP system. It manages standard units such as "BOX", "KGS", "PCS", and "Feet". This table is critical for normalizing quantity measurements across sales, purchasing, inventory, and production modules, ensuring that conversions between parent and child units are mathematically consistent. ### 2) Column Dictionary | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage | | :--- | :--- | :--- | :--- | :--- | :--- | | **compcode** | string | No | Unique identifier for the company/entity. | e.g., "DAS" | `WHERE compcode = 'DAS'` | | **PUoM** | string | No | **Parent Unit of Measure**: The base or primary unit identifier. | "BOX", "KGS", "PCS", "MTR", "SET" | `JOIN ... ON T.uom = U.PUoM` | | **CUoM** | string | No | **Child Unit of Measure**: The target unit for conversion or a secondary identifier. | "BOX", "KGS", "PCS", "Roll" | `JOIN ... ON T.uom = U.CUoM` | | **ConValue** | number | Yes | **Conversion Value**: The multiplier used to convert from PUoM to CUoM. | e.g., 0.0, 1.0, 12.0 | `qty * ConValue` | | **index** | integer | No | Physical row identifier (Primary Key in internal storage). | | Internal use only. | ### 3) Relationships & Join Map The `UoMMaster` table is a reference (lookup) table. Most transaction and master tables containing a `uom` or `UoM` column link back to this table to validate the unit or retrieve conversion factors. #### Primary Joins * **dbo.itemmas (uom)**: Links items to their defined units of measure. * **dbo.invdtl (uom)**: Links invoice line items to their billing units. * **dbo.job (uom)**: Links production job cards to the units used for material tracking. * **dbo.rmmas (uom)**: Links raw materials to their base stock-keeping units. * **dbo.citemmas (uom)**: Links consumable items to their units. #### Join Logic Requirements * **Multi-tenant Joins**: Always include `compcode` in the join condition to ensure the correct company's unit definitions are used. * **Unit Matching**: Joins are typically performed on `PUoM` or `CUoM` depending on whether the source table refers to the primary or converted unit. ---