ODBC Driver for QuickBooks

Build 24.0.9175

UnitOfMeasure

Handles QuickBooks Units of Measure, supporting creation, updates, deletion, and queries. Requires QBXML Version 7.0 or higher.

Columns

Name Type ReadOnly References ColumnSize Description
ID [KEY] String True 255

The unique identifier assigned to the unit of measure.

Name String False 31

The descriptive name of the unit of measure, such as 'Pounds' or 'Liters'.

IsActive Boolean False

Indicates whether the unit of measure is currently active. A value of true means it is active, and false means it is inactive.

UnitOfMeasureType String False 1000

Specifies the category or type of the unit of measure, such as 'Count', 'Weight', or 'Volume'.

BaseUnit_Name String False 31

The name of the base unit of measure from which other related units are derived. For example, 'Gram' could be the base unit for weight measurements.

BaseUnit_Abbreviation String False 31

The shorthand or abbreviation for the base unit of measure, such as 'g' for grams or 'mL' for milliliters.

RelatedUnitAggregate String False 5000

An XML aggregate that defines the related units of measure, including conversions and relationships to the base unit.

DefaultUnitAggregate String False 5000

An XML aggregate that specifies the default unit of measure settings, including default quantities or relationships for transactions.

EditSequence String True 16

A unique string used for version control, ensuring the unit of measure entity is current and updated.

TimeCreated Datetime True

The date and time when this unit of measure entity was created, formatted as YYYY-MM-DD HH:MM:SS.

TimeModified Datetime True

The date and time when this unit of measure entity was last modified, formatted as YYYY-MM-DD HH:MM:SS.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175