JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

ManufacturingOrderPickList

Return a list of: ManufacturingOrderPickList

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
PickListActualConsumedQty Decimal
PickListAllocatedBy String
PickListAllocatedQty Decimal
PickListAllowedQty Decimal
PickListAlternateItemForId String
PickListAlternateItemSequence Int
PickListBOMCategory String
PickListBOMName String
PickListBOMSequence Int
PickListBOMUserDef1 String
PickListBOMUserDef2 String
PickListBackFlushedQty Decimal
PickListBaseUOMQty Decimal
PickListCurrentConsumedQty Decimal
PickListCurrentReturnToStockQty Decimal
PickListCurrentScrappedQty Decimal
PickListDateAllocated Datetime
PickListDateRequired Datetime
PickListDateResourcePlanIssued Datetime
PickListExplodedQty Decimal
PickListFixedQty Decimal
PickListIsActualConsumedChecked Bool
PickListIsAllocated Bool
PickListIsAlternateItem Bool
PickListIsBOMApproved Bool
PickListIsBOMSingleLot Bool
PickListIsBackFlushed Bool
PickListIsBackOrdered Bool
PickListIsFloorStock Bool
PickListIsIssued Bool
PickListIsOptionedItem Bool
PickListIsPhantomItem Bool
PickListIsResourcePlanCalculated Bool
PickListIsSubAssemblyItem Bool
PickListIssuedBy String
PickListIssuedQty Decimal
PickListItemId String
PickListLastModifiedDate Datetime
PickListLeadTimeOffset Decimal
PickListLinkToSequence Int
PickListLocation String
PickListMRPAmountCurrency String
PickListMRPAmount Decimal
PickListMRPAmount2Currency String
PickListMRPAmount2 Decimal
PickListManufacturingNote String
PickListManufacturingOrderDocumentId String
PickListMarkdownAmtCurrency String
PickListMarkdownAmt Decimal
PickListNonInventoryCreditIndex Int
PickListNonInventoryItemDescription String
PickListOffsetFrom Decimal
PickListOrderStatus String
PickListPOLineLineSequenceNumber Int
PickListPOLinePurchaseTransactionId String
PickListParentPartNumberId String
PickListPositionNumber Int
PickListPositionNumber2 Int
PickListPromotion String
PickListRefillCostCurrency String
PickListRefillCost Decimal
PickListReturnToStockQty Decimal
PickListRoutingName String
PickListRoutingSequence String
PickListScrappedQty Decimal
PickListSequence [KEY] Int
PickListSubAssemblyItemForId String
PickListSubAssemblyItemSequence Int
PickListSuggestedQty Decimal
PickListUnitCostCurrency String
PickListUnitCost Decimal
PickListUofM String
PickListVendorId String
PickListVendorName String
PickListWorkCenter String
RouteAggregate 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