JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

CustomerAddress

Return a list of: CustomerAddress

Columns

Name Type ReadOnly Description
ExtensionsExtensionAggregate String False

City String False

Line1 String False

Line2 String False

Line3 String False

PostalCode String False

State String False

CountryRegion String False

FaxCountryCode String False

FaxExtension String False

Fax String False

Phone1CountryCode String False

Phone1Extension String False

Phone1 String False

Phone2CountryCode String False

Phone2Extension String False

Phone2 String False

Phone3CountryCode String False

Phone3Extension String False

Phone3 String False

CountryRegionCodeId String False

ContactPerson String False

Name String False

CreatedDate Datetime 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

LastModifiedDate Datetime False

ModifiedDate Datetime False

ShippingMethodId String False

TaxScheduleId String False

UPSZone String False

UserDefined1 String False

UserDefined2 String False

DeleteOnUpdate Bool False

KeyCustomerId [KEY] String False

Id [KEY] String False

SalesTerritoryId String False

SalespersonId String False

WarehouseId 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