JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

SalespersonCommissions

Return a list of: SalespersonCommissions

Columns

Name Type Description
ExtensionsExtensionAggregate String
AmountCurrency String
Amount Decimal
AuditTrailCode String
CommissionAuditTrailCode String
CommissionPercent Decimal
CurrencyKeyISOCode String
CustomerId String
IsPaid Bool
IsPosted Bool
KeyDocumentNumber [KEY] String
KeyDocumentType [KEY] String
KeySequenceNumber [KEY] Int
NoncommissionedAmountCurrency String
NoncommissionedAmount Decimal
PercentOfSale Decimal
SalesAmountCurrency String
SalesAmount Decimal
SalesTerritoryId String
SalespersonId String
TransactionState String

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