Excel Add-In for QuickBooks

Build 21.0.7867

UnitOfMeasureRelatedUnits

Create and query QuickBooks unit-of-measure related units. QuickBooks requires QBXML version 7.0 or higher to use this table.

Columns

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

The unique identifier of the unit-of-measure related unit.

UnitOfMeasureSetId String False

UnitOfMeasure.ID

255

The item identifier of the unit of measure.

Name String False 31

The name of the unit of measure.

IsActive Boolean False

Boolean determining if the unit of measure is active.

UnitOfMeasureType String False 1000

The type of unit of measure, such as Count.

BaseUnit_Name String False 31

The name of the base unit of measure.

BaseUnit_Abbreviation String False 31

The abbreviation for the base unit of measure.

RelatedUnit_Name String False 31

The name of the related unit of measure.

RelatedUnit_Abbreviation String False 31

The abbreviation of the related unit of measure.

RelatedUnit_ConversionRatio String False 5000

The conversion ratio of the related unit of measure.

EditSequence String True 16

A string indicating the revision of the record.

TimeCreated Datetime True

The time the record was created.

TimeModified Datetime True

The last time the record was modified.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7867