ODBC Driver for Reckon

Build 24.0.9062

BuildAssemblyLineItems

Create and query Reckon Build Assembly transactions.

Columns

Name Type ReadOnly References Description
ID [KEY] String True

The unique identifier.

BuildAssemblyId String False

BuildAssemblies.ID

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.

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