ManufacturingOrderRoute
Return a list of: ManufacturingOrderRoute
Columns
Name | Type | Description |
ExtensionsExtensionAggregate | String | |
ActualDemand | Decimal | |
BOMCategory | String | |
BOMRevisionLevel | String | |
ComponentCalculation | String | |
DateCompleted | Datetime | |
Description | String | |
DrawFromSite | String | |
EndDate | Datetime | |
EndingQty | Decimal | |
IsArchivedMO | Bool | |
IsQuickMO | Bool | |
ItemId | String | |
LastModifiedDate | Datetime | |
LotNumber | String | |
ManufacturingOrderDocumentId | String | |
Notes | String | |
OrderStatus | String | |
OutSourced | String | |
PickNumber | String | |
PlanName | String | |
PostToSite | String | |
Priority | String | |
RoutingName | String | |
RoutingRevisionLevel | String | |
ScheduleMethod | String | |
SchedulingPreference | String | |
StartDate | Datetime | |
StartingQty | Decimal | |
PickListAggregate | String | |
RouteActualFinishDate | Datetime | |
RouteActualStartDate | Datetime | |
RouteClosedBy | String | |
RouteCycleTime | Decimal | |
RouteDateClosed | Datetime | |
RouteDateCreated | Datetime | |
RouteDrawingNumber | String | |
RouteIsAutoBackFlushLabor | Bool | |
RouteIsAutoBackFlushMachine | Bool | |
RouteIsCapacityRequirementsPlanned | Bool | |
RouteIsDone | Bool | |
RouteIsLastSequenceofTheDay | Bool | |
RouteIsMultiEmployeeOperation | Bool | |
RouteIsPhantomItem | Bool | |
RouteIsQualityAssuranceNeeded | Bool | |
RouteLaborCode1 | String | |
RouteLaborCode2 | String | |
RouteLaborTime | Decimal | |
RouteLastModifiedDate | Datetime | |
RouteMRPAmountCurrency | String | |
RouteMRPAmount | Decimal | |
RouteMachineId | String | |
RouteMachineTime | Decimal | |
RouteManufacturingNote | String | |
RouteManufacturingOrderDocumentId | String | |
RouteMoveTime | Decimal | |
RouteNextRouteNumber | String | |
RouteNotes | String | |
RouteNumberOfCrews | Int | |
RouteNumberOfEmployees | Int | |
RouteNumberOfMachines | Int | |
RouteOperationCode | String | |
RoutePOOffsetDays | Int | |
RoutePercentageComplete | Int | |
RoutePieces | Decimal | |
RouteQuantity | Decimal | |
RouteQueueTime | Decimal | |
RouteRejects | Decimal | |
RouteRouteMachineID | String | |
RouteRoutePartNumber | String | |
RouteRouteSeqDescription | String | |
RouteRouteSequenceNum [KEY] | Int | |
RouteRouteSequenceType | String | |
RouteRouteWorkCenter | String | |
RouteRunTime | Decimal | |
RouteScheduledFinishDate | Datetime | |
RouteScheduledStartDate | Datetime | |
RouteServiceItemDateReleased | Datetime | |
RouteServiceItemManufacturingOrderDocumentId | String | |
RouteServiceItemQtyToOrder | Decimal | |
RouteServiceItemRequiredDate | Datetime | |
RouteServiceItemRouteSequenceNum | Int | |
RouteServiceItemServiceItemId | String | |
RouteServiceItemSuggestedQty | Decimal | |
RouteSetupTime | Decimal | |
RouteUserDef1 | String | |
RouteUserDef2 | String | |
RouteVendorId | String | |
RouteVendorName | String | |
RouteWIPOutputPerMOStartQty | Decimal | |
RouteWaitHours | Int | |
RouteWorkCenter | String |
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 |
PagingColumn | String |