JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

Item

Return a list of: Item

Columns

Name Type Description
ExtensionsExtensionAggregate String
ABCCode String
AllowBackOrder Bool
AssemblyVarianceGLAccountId String
AssemblyVarianceGLAccountKeyIsEncrypted Bool
ClassId String
CostofGoodsSoldGLAccountId String
CostofGoodsSoldGLAccountKeyIsEncrypted Bool
CreatedDate Datetime
CurrencyDecimalPlaces String
CurrentCostCurrency String
CurrentCost Decimal
DamagedGLAccountId String
DamagedGLAccountKeyIsEncrypted Bool
DefaultPriceLevelId String
DefaultSellingUofM String
DefaultWarehouseId String
Description String
DropShipGLAccountId String
DropShipGLAccountKeyIsEncrypted Bool
FunctionalCurrencyDecimalPlaces String
GenericDescription String
InServiceGLAccountId String
InServiceGLAccountKeyIsEncrypted Bool
InUseGLAccountId String
InUseGLAccountKeyIsEncrypted Bool
IncludeInDemandPlanning Bool
InternetAddressesAdditionalInformation String
InternetAddressesEmailBccAddress String
InternetAddressesEmailCcAddress String
InternetAddressesEmailToAddress String
InternetAddressesInternetField1 String
InternetAddressesInternetField2 String
InternetAddressesInternetField3 String
InternetAddressesInternetField4 String
InternetAddressesInternetField5 String
InternetAddressesInternetField6 String
InternetAddressesInternetField7 String
InternetAddressesInternetField8 String
InternetAddressesMessengerAddress String
InventoryGLAccountId String
InventoryGLAccountKeyIsEncrypted Bool
InventoryOffsetGLAccountId String
InventoryOffsetGLAccountKeyIsEncrypted Bool
InventoryReturnGLAccountId String
InventoryReturnGLAccountKeyIsEncrypted Bool
IsDiscontinued Bool
KeepCalendarYearHistory Bool
KeepDistributionHistory Bool
KeepFiscalYearHistory Bool
KeepTransactionHistory Bool
Id [KEY] String
LastModifiedDate Datetime
MarkdownGLAccountId String
MarkdownGLAccountKeyIsEncrypted Bool
ModifiedDate Datetime
PriceMethod String
PurchasePriceVarianceGLAccountId String
PurchasePriceVarianceGLAccountKeyIsEncrypted Bool
PurchaseTaxBasis String
PurchaseTaxScheduleId String
PurchaseUofM String
QuantityDecimalPlaces String
SalesGLAccountId String
SalesGLAccountKeyIsEncrypted Bool
SalesReturnGLAccountId String
SalesReturnGLAccountKeyIsEncrypted Bool
SalesTaxBasis String
SalesTaxScheduleId String
ShippingWeight Decimal
ShortDescription String
StandardCostCurrency String
StandardCost Decimal
SubstituteItem1Id String
SubstituteItem2Id String
Type String
UnrealizedPurchasePriceVarianceGLAccountId String
UnrealizedPurchasePriceVarianceGLAccountKeyIsEncrypted Bool
UofMScheduleId String
UserCategoryList1 String
UserCategoryList2 String
UserCategoryList3 String
UserCategoryList4 String
UserCategoryList5 String
UserCategoryList6 String
VarianceGLAccountId String
VarianceGLAccountKeyIsEncrypted Bool
WarrantyDays Short

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