JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

CompanyAddress

Return a list of: CompanyAddress

Columns

Name Type Description
ExtensionsExtensionAggregate String
City String
Line1 String
Line2 String
Line3 String
PostalCode String
State String
CountryRegion String
FaxCountryCode String
FaxExtension String
Fax String
Phone1CountryCode String
Phone1Extension String
Phone1 String
Phone2CountryCode String
Phone2Extension String
Phone2 String
Phone3CountryCode String
Phone3Extension String
Phone3 String
CountryRegionCodeId String
ContactPerson String
Name String
County String
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
Id [KEY] String
ModifiedBy String
ModifiedDate Datetime

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