JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

Customer

Return a list of: Customer

Columns

Name Type ReadOnly Description
ExtensionsExtensionAggregate String False

AccountsReceivableGLAccountId String False

AccountsReceivableGLAccountKeyIsEncrypted Bool False

AddressesAggregate String False

AllowRevaluation Bool False

BalanceType String False

BankAccountId String False

BankBranch String False

BankName String False

BillToAddressKeyCustomerId String False

BillToAddressId String False

CashGLAccountId String False

CashGLAccountKeyIsEncrypted Bool False

ClassId String False

Comment1 String False

Comment2 String False

CorporateAccountId String False

CostOfGoodsSoldGLAccountId String False

CostOfGoodsSoldGLAccountKeyIsEncrypted Bool False

CreatedDate Datetime False

CreditLimitItem String False

CreditLimitPeriod Int False

CreditLimitPeriodAmountCurrency String False

CreditLimitPeriodAmount Decimal False

CurrencyKeyISOCode String False

DefaultAddressKeyCustomerId String False

DefaultAddressId String False

DefaultCashAccountType String False

DiscountGracePeriod Int False

DueDateGracePeriod Int False

FinanceChargeItem String False

FinanceChargesGLAccountId String False

FinanceChargesGLAccountKeyIsEncrypted Bool False

HistoryOptionsKeepCalendarHistory Bool False

HistoryOptionsKeepDistributionHistory Bool False

HistoryOptionsKeepFiscalHistory Bool False

HistoryOptionsKeepTransactionHistory Bool False

IncludeInDemandPlanning Bool False

InventoryGLAccountId String False

InventoryGLAccountKeyIsEncrypted Bool False

IsActive Bool False

IsOnHold Bool False

Id [KEY] String False

LastModifiedDate Datetime False

MaximumWriteoffItem String False

MinimumPaymentItem String False

ModifiedDate Datetime False

Name String False

Notes String False

OrderFullfillmentShortageDefault String False

OverpaymentWriteoffGLAccountId String False

OverpaymentWriteoffGLAccountKeyIsEncrypted Bool False

PaymentCardAccountExpirationDate Datetime False

PaymentCardAccountKeyNumber String False

PaymentCardAccountKeyPaymentCardTypeId String False

PaymentTermsDiscountAvailableGLAccountId String False

PaymentTermsDiscountAvailableGLAccountKeyIsEncrypted Bool False

PaymentTermsDiscountTakenGLAccountId String False

PaymentTermsDiscountTakenGLAccountKeyIsEncrypted Bool False

PaymentTermsId String False

PostResultsTo String False

PriceLevelId String False

Priority Int False

RateTypeId String False

SalesGLAccountId String False

SalesGLAccountKeyIsEncrypted Bool False

SalesOrderReturnsGLAccountId String False

SalesOrderReturnsGLAccountKeyIsEncrypted Bool False

SendEmailStatements Bool False

ShipCompleteOnly Bool False

ShipToAddressKeyCustomerId String False

ShipToAddressId String False

Shortname String False

StatementCycle String False

StatementName String False

StatementRecipientsBCCAggregate String False

StatementRecipientsCCAggregate String False

StatementRecipientsToAggregate String False

StatementToAddressKeyCustomerId String False

StatementToAddressId String False

TaxExemptNumbersAggregate String False

TaxRegistrationNumber String False

TradeDiscountPercent Decimal False

UserDefined1 String False

UserDefined2 String False

UserLanguageId Int False

WriteoffGLAccountId String False

WriteoffGLAccountKeyIsEncrypted Bool 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