VendorManufacturingOrderRoute
Return a list of: VendorManufacturingOrderRoute
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 | |
| 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 |