JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

ItemVendor

Return a list of: ItemVendor

Columns

Name Type ReadOnly Description
ExtensionsExtensionAggregate String False

AverageLeadTime Decimal False

EconomicOrderQuantity Decimal False

FreeOnBoard String False

KeyItemId [KEY] String False

KeyVendorId [KEY] String False

LastCurrencyKeyISOCode String False

LastOriginatingCostCurrency String False

LastOriginatingCost Decimal False

MaximumOrderQuantity Decimal False

MinimumOrderQuantity Decimal False

NumberOfReceipts Short False

OrderMultipleQuantity Decimal False

PlanningLeadTime Short False

PurchasingUofM String False

RequisitionedQuantity Decimal False

VendorItemDescription String False

VendorItemNumber String 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