ODBC Driver for QuickBooks

Build 24.0.9175

BuildAssemblies

Manages Build Assembly transactions in QuickBooks, allowing users to insert, update, delete, and query assemblies for inventory management.

Columns

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

The unique identifier for the build assembly transaction in QuickBooks.

TxnNumber Integer True

A manually assigned transaction number for identifying this BuildAssembly separately from the Quickbooks generated ID.

ItemInventoryAssemblyRef_ListID String False

Items.ID

255

The unique identifier of the inventory assembly being built. Either this field or ItemInventoryAssemblyRef_FullName must be provided when inserting a BuildAssembly.

ItemInventoryAssemblyRef_FullName String False 1000

The name of the inventory assembly being built. Either this field or ItemInventoryAssemblyRef_ListID must be provided when inserting a BuildAssembly.

InventorySiteRef_ListID String False

InventorySites.ID

255

The unique identifier of the inventory site where the assembly is being built.

InventorySiteRef_FullName String False 31

The name of the inventory site where the assembly is being built.

SerialNumber String False 5000

The serial number of the asset being built. Cannot be used if LotNumber is specified.

LotNumber String False 40

The lot number of the asset being built. Cannot be used if SerialNumber is specified.

TxnDate Date False

The date of the transaction for the build assembly.

RefNumber String False 21

A reference number for the transaction, used for identification. This number does not have to be unique.

Memo String False 5000

A memo providing additional details about the build assembly transaction.

IsPending Boolean True

Indicates whether the transaction is pending. If true, the build assembly has not yet been completed.

QuantityToBuild Double False

The number of assemblies to be built. The transaction fails if this number exceeds the available on-hand inventory.

QuantityCanBuild Double True

The maximum number of assemblies that can be built with the current parts on hand.

QuantityOnHand Double True

The total quantity of these items currently in inventory. Adjustments must be made using inventory adjustments.

QuantityOnSalesOrder Double True

The number of these items that have been sold but not yet delivered to customers (as recorded in sales orders).

MarkPendingIfRequired Boolean False

Indicates whether the assembly should be marked as pending if there are insufficient parts to complete it. Requires QBXML Version 7.0 and is not returned in QuickBooks responses.

ExternalGUID String True

A user-defined globally unique identifier (GUID) for this transaction. Requires QBXML Version 9.0.

BuildAssemblyLineAggregate String True 5000

An aggregate of line item data for adding a build assembly and its associated line items in a single operation.

TimeCreated Datetime True

The timestamp of when this build assembly transaction was originally created.

TimeModified Datetime True

The timestamp of the last modification made to this build assembly transaction.

EditSequence String True

A unique identifier used for version control of this build assembly transaction, ensuring data integrity during updates.

ExpirationDateForSerialLotNumber String True 1099

The expiration date for the serial or lot number associated with this item. Requires QBXML Version 16.0 or higher.

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