Power BI Connector for Exact Online

Build 24.0.9062

BillOfMaterialRoutings

Use this endpoint to create, read, update and delete routings in a bill of material version linked to a make item.

Columns

Name Type ReadOnly Description
ID [KEY] String True

Id for BillOfMaterialRoutings

Account String False

Reference to Account providing the Outsourced item

AttendedPercentage Double False

Attended Percentage

Backflush Int False

Indicates if this is a backflush step

CostPerItem Double False

Total cost / Batch quantity

CreatedBy String False

User ID of creator

CreatedDate Datetime False

Creation date

CreatorFullName String False

Name of creator

Currency String False

Name of creator

Division Int False

Division code

EfficiencyPercentage Double False

Efficiency Percentage

FactorType Int False

Conversion factor type between produced item and Subcontract purchase Unit

GeneralBurden Double False

General Burden

Item String False

Reference to Items

ItemVersion String False

Reference to Item versions

LineNumber Int False

Sequential order of the operation

MachineBurden Double False

Machine Burden

ModifiedBy String False

User ID of modifier

ModifiedDate Datetime False

Modification date

ModifierFullName String False

Modification date

Notes String False

Notes

Operation String False

Reference to Operations

OperationDescription String False

Description of the operation step

OperationResource String False

Reference to OperationResources

PurchaseUnit String False

Reference to Units

PurchaseUnitFactor Double False

Purchase Unit Factor

PurchaseUnitPriceFC Double False

Purchase Unit Price in the currency of the transaction

PurchaseUnitQuantity Double False

Purchase unit quantity of the plan

RateFC Double False

Rate FC

ResourceDescription String False

Resource Description

RoutingStepType Int False

Reference to RoutingStepTypes

Run Double False

Used in conjunction with RunMethod, and EfficiencyPercentage to determine PlannedRunHours

RunLabor Double False

Run Labor

RunLaborBurden Double False

Run Labor Burden

RunMethod Int False

Reference to OperationMethod

Setup Double False

Used in conjunction with SetupCount and Setup Unit to determine PlannedSetupHours

SetupLabor Double False

Setup Labor

SetupLaborBurden Double False

Setup Labor Burden

SetupUnit String False

Reference to TimeUnits

SubcontractedLeadDays Int False

Subcontracted lead days

TotalCostDC Double False

Total cost of the routing line

Workcenter String False

Reference to Workcenters

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