Tableau Connector for Exact Online

Build 24.0.9111

AssemblyBillOfMaterialMaterials

To create, read, update and delete item bill of materials.

Columns

Name Type ReadOnly Description
ID [KEY] String True

Primary key.

AssembledItem String False

Main item.

AssembledItemCode String False

Main item code.

AssembledItemDescription String False

Main item description.

AssembledLeadDays Int False

Main item assembly lead days.

BatchQuantity Double False

Main item batch quantity.

Created Datetime False

Creation date.

Creator String False

User ID of the creator.

Division Int False

Division.

LineNumber Int False

Line number.

Modified Datetime False

Last modified date.

Modifier String False

User ID of the modifier.

PartItem String False

Key of part item.

PartItemCode String False

Part item code.

PartItemDescription String False

Part item description.

Quantity Double False

Quantity of the part item to produce main item.

QuantityBatch Double False

Quantity of the part item to produce the batch.

UpdateCostPrice Bool False

Indicates if cost price is updated.

UseExplosion Int False

Indicates if main item assemble at delivery is used.

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