BuildAssemblies

Create, update, delete, and query Reckon Build Assembly transactions.

Table Specific Information

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 BuildAssemblies is Id. All other filters are executed client-side. For example:

SELECT * FROM BuildAssemblies WHERE Id = 'ABCD-1234567890'

Insert

To add a BuildAssembly, specify the ItemInventoryAssemblyRef_FullName or ItemInventoryAssemblyRef_ListID and the QuantityToBuild. For example:

INSERT INTO BuildAssemblies (ItemInventoryAssemblyRef_FullName, QuantityToBuild, Memo, RefNumber) VALUES ('Interior Door kit', 36, 'Build Assembly One', '22572')

Update

To update a BuildAssembly, specify the Id and the fields to update. For example:

UPDATE BuildAssemblies SET Memo = 'Updated memo' WHERE ID = 'ABCD-1234567890'

Delete

BuildAssemblies may be deleted using the Id. For example:

DELETE FROM BuildAssemblies WHERE ID = 'ABCD-1234567890'

Columns


Name	Type	ReadOnly	References	Description
ID [KEY]	String	True		The unique identifier.
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.
BuildAssemblyLineAggregate	String	True		An aggregate of the line item data which can be used for adding a transfer inventory and its line item data.
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.