BuildAssemblyLineItems
Create, update, and query Reckon Build Assembly transactions.
Table Specific Information
BuildAssemblyLineItems may be inserted, updated, or queried via the BuildAssemblyLineItems table. To delete a BuildAssembly, use the BuildAssemblies table.
Select
The following filters support server-side execution. Other filters are executed client-side.
Reckon Accounts Hosted allows only a small subset of columns to be used in the WHERE clause of a SELECT query. These columns can typically be used with only the equals or = comparison. The available column for BuildAssemblyLineItems is Id. All other filters are executed client-side. For example:
SELECT * FROM BuildAssemblyLineItems WHERE Id = 'ABCD-1234567890|ABCE-1234567890'
Insert
To add a BuildAssemblyLineItem, specify the BuildAssemblyId and the ItemInventoryAssemblyRef_FullName or ItemInventoryAssemblyRef_ListID. For example:
INSERT INTO BuildAssemblyLineItems (BuildAssemblyId, ItemInventoryAssemblyRef_FullName, QuantityToBuild) VALUES ('ABCD-1234567890', 'Interior Door kit', 10)
Update
To update a BuildAssemblyLineItem, specify the composite Id (BuildAssemblyId|LineItemId) and the fields to update. For example:
UPDATE BuildAssemblyLineItems SET Memo = 'Updated memo' WHERE ID = 'ABCD-1234567890|ABCE-1234567890'
Columns
| Name | Type | ReadOnly | References | Description |
| ID [KEY] | String | True |
The unique identifier. | |
| BuildAssemblyId | String | False |
The unique Id of the build assembly. | |
| TxnNumber | Integer | True |
An identifying number for this transaction. | |
| ItemInventoryAssemblyRef_ListID | String | False |
Items.ID |
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 |
Items.FullName |
A reference to the name of an inventory assembly. Either ItemInventoryAssemblyRef_ListID or ItemInventoryAssemblyRef_FullName is required when inserting a BuildAssembly. |
| SerialNumber | String | False |
The serial number of the asset. This cannot be used with LotNumber. | |
| LotNumber | String | False |
The lot number of the asset. This cannot be used with SerialNumber. | |
| TxnDate | Date | False |
The date of the transaction. | |
| RefNumber | String | False |
A reference number identifying the transaction. This does not have to be unique. | |
| Memo | String | False |
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. | |
| ComponentItemLineRet_ItemRef_ListID | String | True |
Items.ID |
Reference to the Id of an item. |
| ComponentItemLineRet_ItemRef_FullName | String | True |
Items.FullName |
Reference to the full name of an item. |
| ComponentItemLineRet_Desc | String | True |
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. |