CData Python Connector for QuickBooks

Build 24.0.9175

UnitOfMeasureRelatedUnits

Handles related units in QuickBooks Units of Measure, supporting creation and queries for complex measurement systems. 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 related unit of measure.

UnitOfMeasureSetId String False

UnitOfMeasure.ID

255

The unique identifier for the unit of measure set that this related unit belongs to.

Name String False 31

The descriptive name of the unit of measure, such as 'Liter' or 'Pound'.

IsActive Boolean False

Indicates whether this related 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', 'Length', or 'Volume'.

BaseUnit_Name String False 31

The name of the base unit of measure used for conversions or as a standard reference, such as 'Meter' or 'Kilogram'.

BaseUnit_Abbreviation String False 31

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

RelatedUnit_Name String False 31

The name of the related unit of measure, such as 'Centimeter' or 'Ounce'.

RelatedUnit_Abbreviation String False 31

The abbreviation or shorthand for the related unit of measure, such as 'cm' for centimeters or 'oz' for ounces.

RelatedUnit_ConversionRatio String False 5000

Defines the conversion ratio from the base unit to the related unit. For example, '100' if 1 meter equals 100 centimeters.

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 related unit of measure record was created, formatted as YYYY-MM-DD HH:MM:SS.

TimeModified Datetime True

The date and time when this related 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