ODBC Driver for QuickBooks

Build 24.0.9175

UnitOfMeasureDefaultUnits

Manages default units within QuickBooks Units of Measure, supporting creation and queries for streamlined measurement configurations. 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 default unit.

UnitOfMeasureSetId String False

UnitOfMeasure.ID

255

The unique identifier for the unit of measure set to which this default unit belongs.

Name String False 31

The descriptive name of the unit of measure, such as 'Kilogram' or 'Inch'.

IsActive Boolean False

Indicates whether this default 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 type or category of the unit of measure, such as 'Count', 'Length', or 'Weight'.

BaseUnit_Name String False 31

The name of the base unit of measure used for conversions or as a reference for related units, such as 'Meter' or 'Gram'.

BaseUnit_Abbreviation String False 31

The shorthand or abbreviation for the base unit of measure, such as 'm' for meters or 'kg' for kilograms.

DefaultUnit_UnitUsedFor String False 100

Specifies the purpose or context in which the default unit is used, such as sales, purchases, or inventory tracking.

DefaultUnit_Unit String False 31

Defines the default unit of measure used for the specified purpose, such as 'Box' or 'Dozen'.

EditSequence String True 16

A unique string used to track the revision history of this record, ensuring it reflects the most current version.

TimeCreated Datetime True

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

TimeModified Datetime True

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

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