Tableau Connector for QuickBooks

Build 24.0.9060

BuildAssemblyLineItems

Create and query QuickBooks Build Assembly transactions.

Columns

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

The unique identifier.

BuildAssemblyId String False

BuildAssemblies.ID

255

The unique Id of the build assembly.

TxnNumber Integer True

An identifying number for this transaction.

ItemInventoryAssemblyRef_ListID String False

Items.ID

255

A reference to the Id of an inventory assembly. Either ItemInventoryAssemblyRef_ListID or ItemInventoryAssemblyRef_FullName is required when inserting a BuildAssembly.

ItemInventoryAssemblyRef_FullName String False 1000

A reference to the name of an inventory assembly. Either ItemInventoryAssemblyRef_ListID or ItemInventoryAssemblyRef_FullName is required when inserting a BuildAssembly.

InventorySiteRef_ListID String False

InventorySites.ID

255

A reference to the Id of an inventory site. Requires QBXML Version 10.0.

InventorySiteRef_FullName String False 31

A reference to the name of an inventory site. Requires QBXML Version 10.0.

SerialNumber String False 5000

The serial number of the asset. This cannot be used with LotNumber.

LotNumber String False 40

The lot number of the asset. This cannot be used with SerialNumber.

TxnDate Date False

The date of the transaction.

RefNumber String False 21

A reference number identifying the transaction. This does not have to be unique.

Memo String False 5000

A memo about the transaction.

IsPending Boolean True

If IsPending is set to true, the transaction in question has not been completed.

QuantityToBuild Double False

Specifies the number of assemblies to be built. The transaction will fail if the number specified here exceeds the number of on-hand items.

QuantityCanBuild Double True

Indicates the number of this assembly that can be built from the parts on hand.

QuantityOnHand Double True

The number of these items in the inventory. To change the QuantityOnHand, you would need to add an inventory adjustment.

QuantityOnSalesOrder Double True

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

MarkPendingIfRequired Boolean False

Allows the build assembly to be marked pending if there are insufficient quantities to complete the build assembly. This field requires QBXML Version 7.0 and is not returned in the response from QuickBooks.

ExternalGUID String True

A user-defined GUID value. Requires QBXML Version 9.0.

ComponentItemLineRet_ItemRef_ListID String True

Items.ID

255

Reference to the Id of an item.

ComponentItemLineRet_ItemRef_FullName String True 255

Reference to the full name of an item.

ComponentItemLineRet_InventorySiteRef_ListID String True

InventorySites.ID

255

Reference to the Id of an inventory site. Requires QBXML Version 10.0.

ComponentItemLineRet_InventorySiteRef_FullName String True 31

Reference to the full name of an inventory site. Requires QBXML Version 10.0.

ComponentItemLineRet_Desc String True 5000

Description for the line item.

ComponentItemLineRet_QuantityOnHand Double True

The number of these items in the inventory.

ComponentItemLineRet_QuantityNeeded Double True

The number of these items used in the assembly.

TimeCreated Datetime True

The datetime the transaction was made.

TimeModified Datetime True

The last datetime the transaction was modified.

EditSequence String True

An identifier used for versioning for this copy of the object.

ExpirationDateForSerialLotNumber String True 1099

The expiration date for serial lot number of this item. This requires QBXML version at least 16.0.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060