JDBC Driver for Exact Online

Build 22.0.8462

ShopOrderRoutingStepPlans

Usage information for the operation ShopOrderRoutingStepPlans.rsd.

Columns

Name Type ReadOnly Description
ID [KEY] String True

The ID column for the table ShopOrderRoutingStepPlans.

Account String False

The Account column for the table ShopOrderRoutingStepPlans.

AccountName String False

The AccountName column for the table ShopOrderRoutingStepPlans.

AccountNumber String False

The AccountNumber column for the table ShopOrderRoutingStepPlans.

AttendedPercentage Double False

The AttendedPercentage column for the table ShopOrderRoutingStepPlans.

Backflush Int False

The Backflush column for the table ShopOrderRoutingStepPlans.

CostPerItem Double False

The CostPerItem column for the table ShopOrderRoutingStepPlans.

Created Datetime False

The Created column for the table ShopOrderRoutingStepPlans.

Creator String False

The Creator column for the table ShopOrderRoutingStepPlans.

CreatorFullName String False

The CreatorFullName column for the table ShopOrderRoutingStepPlans.

Description String False

The Description column for the table ShopOrderRoutingStepPlans.

Division Int False

The Division column for the table ShopOrderRoutingStepPlans.

EfficiencyPercentage Double False

The EfficiencyPercentage column for the table ShopOrderRoutingStepPlans.

FactorType Int False

The FactorType column for the table ShopOrderRoutingStepPlans.

LineNumber Int False

The LineNumber column for the table ShopOrderRoutingStepPlans.

Modified Datetime False

The Modified column for the table ShopOrderRoutingStepPlans.

Modifier String False

The Modifier column for the table ShopOrderRoutingStepPlans.

ModifierFullName String False

The ModifierFullName column for the table ShopOrderRoutingStepPlans.

Notes String False

The Notes column for the table ShopOrderRoutingStepPlans.

Operation String False

The Operation column for the table ShopOrderRoutingStepPlans.

OperationCode String False

The OperationCode column for the table ShopOrderRoutingStepPlans.

OperationDescription String False

The OperationDescription column for the table ShopOrderRoutingStepPlans.

OperationResource String False

The OperationResource column for the table ShopOrderRoutingStepPlans.

PlannedEndDate Datetime False

The PlannedEndDate column for the table ShopOrderRoutingStepPlans.

PlannedRunHours Double False

The PlannedRunHours column for the table ShopOrderRoutingStepPlans.

PlannedSetupHours Double False

The PlannedSetupHours column for the table ShopOrderRoutingStepPlans.

PlannedStartDate Datetime False

The PlannedStartDate column for the table ShopOrderRoutingStepPlans.

PlannedTotalHours Double False

The PlannedTotalHours column for the table ShopOrderRoutingStepPlans.

PurchaseUnit String False

The PurchaseUnit column for the table ShopOrderRoutingStepPlans.

PurchaseUnitFactor Double False

The PurchaseUnitFactor column for the table ShopOrderRoutingStepPlans.

PurchaseUnitPriceFC Double False

The PurchaseUnitPriceFC column for the table ShopOrderRoutingStepPlans.

PurchaseUnitQuantity Double False

The PurchaseUnitQuantity column for the table ShopOrderRoutingStepPlans.

RoutingStepType Int False

The RoutingStepType column for the table ShopOrderRoutingStepPlans.

Run Double False

The Run column for the table ShopOrderRoutingStepPlans.

RunMethod Int False

The RunMethod column for the table ShopOrderRoutingStepPlans.

RunMethodDescription String False

The RunMethodDescription column for the table ShopOrderRoutingStepPlans.

Setup Double False

The Setup column for the table ShopOrderRoutingStepPlans.

SetupUnit String False

The SetupUnit column for the table ShopOrderRoutingStepPlans.

ShopOrder String False

The ShopOrder column for the table ShopOrderRoutingStepPlans.

Status Int False

The Status column for the table ShopOrderRoutingStepPlans.

StatusDescription String False

The StatusDescription column for the table ShopOrderRoutingStepPlans.

SubcontractedLeadDays Int False

The SubcontractedLeadDays column for the table ShopOrderRoutingStepPlans.

TotalCostDC Double False

The TotalCostDC column for the table ShopOrderRoutingStepPlans.

Workcenter String False

The Workcenter column for the table ShopOrderRoutingStepPlans.

WorkcenterCode String False

The WorkcenterCode column for the table ShopOrderRoutingStepPlans.

WorkcenterDescription String False

The WorkcenterDescription column for the table ShopOrderRoutingStepPlans.

LinkedTimeTransactions String False

The LinkedTimeTransactions column for the table ShopOrderRoutingStepPlans.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462