JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

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

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