Routing Item

A series of Routing Items describe the steps through Resources to build a work order for a particular Part.

The indicates a required field.

Column Name
Type
Values

RoutingName

text(50)

The name of a collection of routing item operations, referenced by Work Order and optionally by Supply Order.

PartNumber

text(50)

Must match a valid Part Number, Revision and Location in the parts data.

Revision

text(10)

Location

text(32)

The name of a valid Location.

Family

text(50)

The the buffer family for the named routing set, providing buffer durations for operations in this routing.

RunRate

decimal

The run rate for the operation. It can represent one of three value: Units per hour, hours per unit, or minutes per unit depending on a program setting.

Resource

text(50)

The name of a valid Resource for the location.

Efficiency

integer

An optional value from 1 to 100 with smaller values increase the run duration at an operation; defaults to null. When null, the value from the Resource for the operation is used.

Buffer

integer

A buffer value applied before the start of an operation for buffered resources in either minutes or hours based on a program setting; defaults to 0. Value is not applied for any other resource type.

SetupTime

integer

A setup time included in the run duration at an operation, in either minutes or hours based on a program setting; defaults to 0.

FixedOffset

integer

A fixed offset is applied after the run duration at an operation, in either minutes or hours based on a program setting defaults to 0.

IsPrimaryConstraint

boolean

Valid for an operation for a constrained resource, and for a routing that has more than one constrained resource. This value indicates which of the multiple constraints should be primary, i.e. which one gets the buffer. Defaults to false.

CrewSize

integer

Optional value 1 or greater used for shortening the calculated duration at the operation. Defaults to 1.

OperationSequenceNumber

integer

A unique integer for a single routing for a part representing the order of the operation.

OperationDescription

text(255)

An optional description for the operation.

Last updated