BuildAssemblyLineItems
Supports creation and querying of individual line items within QuickBooks Build Assembly transactions.
Columns
| Name | Type | ReadOnly | References | ColumnSize | Description |
| ID [KEY] | String | True | 255 |
The unique identifier for this build assembly line item. | |
| BuildAssemblyId | String | False | 255 |
The unique identifier of the build assembly transaction associated with this line item. | |
| TxnNumber | Integer | True |
A manually assigned transaction number for identifying this build assembly transaction 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 | 255 |
The unique identifier of the inventory site associated with this line item. Requires QBXML Version 10.0. | |
| InventorySiteRef_FullName | String | False | 31 |
The name of the inventory site associated with this line item. Requires QBXML Version 10.0. | |
| SerialNumber | String | False | 5000 |
The serial number of the asset associated with this line item. Cannot be used if LotNumber is specified. | |
| LotNumber | String | False | 40 |
The lot number of the asset associated with this line item. 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 this build assembly transaction. | |
| IsPending | Boolean | True |
Indicates whether this 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 quantity exceeds the number of on-hand items. | ||
| 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 recorded in sales orders but not yet delivered to customers. | ||
| MarkPendingIfRequired | Boolean | False |
Specifies whether the build 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. | ||
| ComponentItemLineRet_ItemRef_ListID | String | True |
Items.ID | 255 |
The unique identifier of the item used in this assembly line. |
| ComponentItemLineRet_ItemRef_FullName | String | True | 255 |
The full name of the item used in this assembly line. | |
| ComponentItemLineRet_InventorySiteRef_ListID | String | True | 255 |
The unique identifier of the inventory site where the component item is stored. Requires QBXML Version 10.0. | |
| ComponentItemLineRet_InventorySiteRef_FullName | String | True | 31 |
The full name of the inventory site where the component item is stored. Requires QBXML Version 10.0. | |
| ComponentItemLineRet_Desc | String | True | 5000 |
A description of the line item used in this assembly. | |
| ComponentItemLineRet_QuantityOnHand | Double | True |
The total quantity of the component item currently in inventory. | ||
| ComponentItemLineRet_QuantityNeeded | Double | True |
The quantity of the component item required to build the specified number of assemblies. | ||
| 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 line item. Requires QBXML Version 16.0 or higher. |