ODBC Driver for Microsoft Dynamics GP

Build 24.0.9060

Service

Return a list of: Service

Columns

Name Type ReadOnly Description
ExtensionsExtensionAggregate String False

ABCCode String False

AllowBackOrder Bool False

AssemblyVarianceGLAccountId String False

AssemblyVarianceGLAccountKeyIsEncrypted Bool False

ClassId String False

CostofGoodsSoldGLAccountId String False

CostofGoodsSoldGLAccountKeyIsEncrypted Bool False

CreatedDate Datetime False

CurrencyDecimalPlaces String False

CurrentCostCurrency String False

CurrentCost Decimal False

DamagedGLAccountId String False

DamagedGLAccountKeyIsEncrypted Bool False

DefaultPriceLevelId String False

DefaultSellingUofM String False

DefaultWarehouseId String False

Description String False

DropShipGLAccountId String False

DropShipGLAccountKeyIsEncrypted Bool False

FunctionalCurrencyDecimalPlaces String False

GenericDescription String False

InServiceGLAccountId String False

InServiceGLAccountKeyIsEncrypted Bool False

InUseGLAccountId String False

InUseGLAccountKeyIsEncrypted Bool False

IncludeInDemandPlanning Bool False

InternetAddressesAdditionalInformation String False

InternetAddressesEmailBccAddress String False

InternetAddressesEmailCcAddress String False

InternetAddressesEmailToAddress String False

InternetAddressesInternetField1 String False

InternetAddressesInternetField2 String False

InternetAddressesInternetField3 String False

InternetAddressesInternetField4 String False

InternetAddressesInternetField5 String False

InternetAddressesInternetField6 String False

InternetAddressesInternetField7 String False

InternetAddressesInternetField8 String False

InternetAddressesMessengerAddress String False

InventoryGLAccountId String False

InventoryGLAccountKeyIsEncrypted Bool False

InventoryOffsetGLAccountId String False

InventoryOffsetGLAccountKeyIsEncrypted Bool False

InventoryReturnGLAccountId String False

InventoryReturnGLAccountKeyIsEncrypted Bool False

IsDiscontinued Bool False

KeepCalendarYearHistory Bool False

KeepDistributionHistory Bool False

KeepFiscalYearHistory Bool False

KeepTransactionHistory Bool False

Id [KEY] String False

LastModifiedDate Datetime False

MarkdownGLAccountId String False

MarkdownGLAccountKeyIsEncrypted Bool False

ModifiedDate Datetime False

PriceMethod String False

PurchasePriceVarianceGLAccountId String False

PurchasePriceVarianceGLAccountKeyIsEncrypted Bool False

PurchaseTaxBasis String False

PurchaseTaxScheduleId String False

PurchaseUofM String False

QuantityDecimalPlaces String False

SalesGLAccountId String False

SalesGLAccountKeyIsEncrypted Bool False

SalesReturnGLAccountId String False

SalesReturnGLAccountKeyIsEncrypted Bool False

SalesTaxBasis String False

SalesTaxScheduleId String False

ShippingWeight Decimal False

ShortDescription String False

StandardCostCurrency String False

StandardCost Decimal False

SubstituteItem1Id String False

SubstituteItem2Id String False

Type String False

UnrealizedPurchasePriceVarianceGLAccountId String False

UnrealizedPurchasePriceVarianceGLAccountKeyIsEncrypted Bool False

UofMScheduleId String False

UserCategoryList1 String False

UserCategoryList2 String False

UserCategoryList3 String False

UserCategoryList4 String False

UserCategoryList5 String False

UserCategoryList6 String False

VarianceGLAccountId String False

VarianceGLAccountKeyIsEncrypted Bool False

WarrantyDays Short 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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060