JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

VendorAddresses

Return a list of: VendorAddresses

Columns

Name Type Description
ExtensionsExtensionAggregate String
AccountsPayableGLAccountId String
AccountsPayableGLAccountKeyIsEncrypted Bool
AccruedPurchasesGLAccountId String
AccruedPurchasesGLAccountKeyIsEncrypted Bool
AddressesExtensionsExtensionAggregate String
AddressesCity String
AddressesLine1 String
AddressesLine2 String
AddressesLine3 String
AddressesPostalCode String
AddressesState String
AddressesCountryRegion String
AddressesFaxCountryCode String
AddressesFaxExtension String
AddressesFax String
AddressesPhone1CountryCode String
AddressesPhone1Extension String
AddressesPhone1 String
AddressesPhone2CountryCode String
AddressesPhone2Extension String
AddressesPhone2 String
AddressesPhone3CountryCode String
AddressesPhone3Extension String
AddressesPhone3 String
AddressesCountryRegionCodeId String
AddressesContactPerson String
AddressesName String
AddressesCreatedDate Datetime
AddressesInternetAddressesAdditionalInformation String
AddressesInternetAddressesEmailBccAddress String
AddressesInternetAddressesEmailCcAddress String
AddressesInternetAddressesEmailToAddress String
AddressesInternetAddressesInternetField1 String
AddressesInternetAddressesInternetField2 String
AddressesInternetAddressesInternetField3 String
AddressesInternetAddressesInternetField4 String
AddressesInternetAddressesInternetField5 String
AddressesInternetAddressesInternetField6 String
AddressesInternetAddressesInternetField7 String
AddressesInternetAddressesInternetField8 String
AddressesInternetAddressesMessengerAddress String
AddressesLastModifiedDate Datetime
AddressesModifiedDate Datetime
AddressesShippingMethodId String
AddressesTaxScheduleId String
AddressesUPSZone String
AddressesUserDefined1 String
AddressesUserDefined2 String
AddressesDeleteOnUpdate Bool
AddressesId [KEY] String
AddressesKeyVendorId [KEY] String
AllowRevaluation Bool
BankAccountId String
CashGLAccountId String
CashGLAccountKeyIsEncrypted Bool
CheckName String
ClassId String
Comment1 String
Comment2 String
CreatedDate Datetime
CreditLimitItem String
CurrencyKeyISOCode String
DefaultAddressId String
DefaultAddressKeyVendorId String
DefaultCashAccountType String
DiscountGracePeriod Int
DueDateGracePeriod Int
FinanceChargesGLAccountId String
FinanceChargesGLAccountKeyIsEncrypted Bool
FreeOnBoard String
FreightGLAccountId String
FreightGLAccountKeyIsEncrypted Bool
HistoryOptionsKeepCalendarHistory Bool
HistoryOptionsKeepDistributionHistory Bool
HistoryOptionsKeepFiscalHistory Bool
HistoryOptionsKeepTransactionHistory Bool
IsActive Bool
IsOnHold Bool
IsOneTime Bool
Id String
Language String
MaximumInvoiceItem String
MaximumWriteoffItem String
MinimumOrderAmountCurrency String
MinimumOrderAmount Decimal
MinimumPaymentItem String
MiscellaneousGLAccountId String
MiscellaneousGLAccountKeyIsEncrypted Bool
ModifiedDate Datetime
Name String
Notes String
PaymentPriority String
PaymentTermsId String
PostResultsTo String
ProjectAccountingOptionsDefaultPurchaseOrderFormat String
ProjectAccountingOptionsUnitCostCurrency String
ProjectAccountingOptionsUnitCost Decimal
ProjectAccountingOptionsUnitOfMeasure String
ProjectAccountingOptionsUserDefined1 String
ProjectAccountingOptionsUserDefined2 String
PurchaseAddressId String
PurchaseAddressKeyVendorId String
PurchasePriceVarianceGLAccountId String
PurchasePriceVarianceGLAccountKeyIsEncrypted Bool
PurchasesGLAccountId String
PurchasesGLAccountKeyIsEncrypted Bool
RateTypeId String
RemitToAddressId String
RemitToAddressKeyVendorId String
ShipFromAddressId String
ShipFromAddressKeyVendorId String
ShortName String
Tax1099BoxNumber Int
Tax1099Type String
TaxGLAccountId String
TaxGLAccountKeyIsEncrypted Bool
TaxIdentificationNumber String
TaxRegistrationNumber String
TaxSchedule String
TermsDiscountAvailableGLAccountId String
TermsDiscountAvailableGLAccountKeyIsEncrypted Bool
TermsDiscountTakenGLAccountId String
TermsDiscountTakenGLAccountKeyIsEncrypted Bool
TradeDiscountGLAccountId String
TradeDiscountGLAccountKeyIsEncrypted Bool
TradeDiscountPercent Decimal
UserDefined1 String
UserDefined2 String
UserLanguageId Int
VendorAccountNumber String
WorkflowPriority String
WorkflowsAggregate String
WriteoffGLAccountId String
WriteoffGLAccountKeyIsEncrypted Bool

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