JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

ItemWarehouse

Return a list of: ItemWarehouse

Columns

Name Type ReadOnly Description
ExtensionsExtensionAggregate String False

Bin String False

BuyerId String False

KeyItemId [KEY] String False

KeyWarehouseId [KEY] String False

LandedCostGroupId String False

PlannerId String False

PlanningFixedOrderQuantity Decimal False

PlanningManufacturingLeadTime Decimal False

PlanningMaximumOrderQuantity Decimal False

PlanningMinimumOrderQuantity Decimal False

PlanningOrderMultipleQuantity Decimal False

PlanningOrderPointQuantity Decimal False

PlanningOrderPolicy String False

PlanningOrderUpToLevelQuantity Decimal False

PlanningPurchasingLeadTime Decimal False

PlanningReorderVarianceQuantity Decimal False

PlanningReplenishmentMethod String False

PlanningSafetyStockQuantity Decimal False

PlanningShrinkageFactor Decimal False

PlanningTimeFence Short False

PrimaryVendorId String False

RequisitionedQuantity Decimal False

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