JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

PlannedOrderItems

Return a list of: PlannedOrderItems

Columns

Name Type Description
ExtensionsExtensionAggregate String
DueDate Datetime
IsCRPScheduled Bool
ItemId String
ItemsAllocatedByOpenMO Decimal
ItemsAllocatedByReleasedMO Decimal
ItemsCanceled Bool
ItemsConsumedByOpenMO Decimal
ItemsConsumedByReleasedMO Decimal
ItemsDueDate Datetime
ItemsExceptionsHasException1 Bool
ItemsExceptionsHasException10 Bool
ItemsExceptionsHasException11 Bool
ItemsExceptionsHasException12 Bool
ItemsExceptionsHasException13 Bool
ItemsExceptionsHasException14 Bool
ItemsExceptionsHasException15 Bool
ItemsExceptionsHasException16 Bool
ItemsExceptionsHasException17 Bool
ItemsExceptionsHasException18 Bool
ItemsExceptionsHasException19 Bool
ItemsExceptionsHasException2 Bool
ItemsExceptionsHasException20 Bool
ItemsExceptionsHasException3 Bool
ItemsExceptionsHasException4 Bool
ItemsExceptionsHasException5 Bool
ItemsExceptionsHasException6 Bool
ItemsExceptionsHasException7 Bool
ItemsExceptionsHasException8 Bool
ItemsExceptionsHasException9 Bool
ItemsItemId String
ItemsLocationId String
ItemsMRPParentType String
ItemsMRPType String
ItemsMoveIn Bool
ItemsMoveOut Bool
ItemsOriginalDueDate Datetime
ItemsPhantomParent String
ItemsPlannedOrderId String
ItemsRequiredByOpenMO Decimal
ItemsRequiredByReleasedMO Decimal
ItemsSequenceNumber [KEY] Int
ItemsStatus String
ItemsStatusDescription String
LLC Int
LocationId String
PlannedOrderId String
QuantityToOrder Decimal
ReleaseDate Datetime
Replenishment String
RunNumber Int
Transferred Bool
UnitOfMeasure String
VendorId 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