JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

Company

Return a list of: Company

Columns

Name Type Description
Id [KEY] Int
ExtensionsExtensionAggregate String
AccountSegmentSeparator String
BusinessType String
CreatedDate Datetime
DUNSNumber String
DefaultAddressExtensionsExtensionAggregate String
DefaultAddressCity String
DefaultAddressLine1 String
DefaultAddressLine2 String
DefaultAddressLine3 String
DefaultAddressPostalCode String
DefaultAddressState String
DefaultAddressCountryRegion String
DefaultAddressFaxCountryCode String
DefaultAddressFaxExtension String
DefaultAddressFax String
DefaultAddressPhone1CountryCode String
DefaultAddressPhone1Extension String
DefaultAddressPhone1 String
DefaultAddressPhone2CountryCode String
DefaultAddressPhone2Extension String
DefaultAddressPhone2 String
DefaultAddressPhone3CountryCode String
DefaultAddressPhone3Extension String
DefaultAddressPhone3 String
DefaultAddressCountryRegionCodeId String
DefaultAddressContactPerson String
DefaultAddressName String
DefaultAddressCounty String
DefaultAddressId String
IsValueAddedTaxReturnEnabled Bool
IsWorkflowEnabled Bool
ModifiedBy String
ModifiedDate Datetime
Name String
Options String
PayablesProcessesTaxDetailId String
PurchasesTaxScheduleId String
ReceivablesProcessesTaxDetailId String
SICNumber String
SalesTaxScheduleId String
TaxExempt1 String
TaxExempt2 String
TaxRegistration String
UserDefined1 String
UserDefined2 String
Vets100Number String
WithholdingVendorId String
WitholdingFileOrReconciliationNumber String
WitholdingTaxRate Int

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