BuildAssemblyLineItems
Create and query Reckon Build Assembly transactions.
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. |
Pseudo-Columns
Pseudo Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
StartTxnDate | String |
This pseudo column is deprecated and should no longer be used. Earliest transaction date to search for. |
EndTxnDate | String |
This pseudo column is deprecated and should no longer be used. Latest transaction date to search for. |
StartModifiedDate | String |
This pseudo column is deprecated and should no longer be used. Earliest modified date to search for. |
EndModifiedDate | String |
This pseudo column is deprecated and should no longer be used. Latest modified date to search for. |