Tableau Connector for Microsoft Dynamics GP

Build 24.0.9060

ReceivablesDebitMemoCommissions

Return a list of: ReceivablesDebitMemoCommissions

Columns

Name Type Description
ExtensionsExtensionAggregate String
AddressKeyCustomerId String
AddressId String
AuditTrailCode String
BatchKeyCreatedDateTime Datetime
BatchId String
BatchKeySource String
CorporateAccountId String
CostAmountCurrency String
CostAmount Decimal
CurrencyKeyISOCode String
CurrentDocumentAmountCurrency String
CurrentDocumentAmount Decimal
CustomerId String
CustomerName String
CustomerPONumber String
Date Datetime
Description String
DistributionsAggregate String
DocumentAmountCurrency String
DocumentAmount Decimal
ExchangeDate Datetime
ExchangeRate Decimal
FreightAmountCurrency String
FreightAmount Decimal
FreightTaxScheduleId String
GeneralLedgerPostingDate Datetime
InvoicePaidOffDate Datetime
IsDeleted Bool
IsDirectDebitDocument Bool
IsElectronic Bool
IsIntrastatDocument Bool
IsVoided Bool
Id String
MiscellaneousAmountCurrency String
MiscellaneousAmount Decimal
MiscellaneousTaxScheduleId String
ModifiedBy String
ModifiedDate Datetime
PostedBy String
PostedDate Datetime
SalesAmountCurrency String
SalesAmount Decimal
SalesTaxScheduleId String
SalesTerritoryId String
SalespersonId String
ShippingMethodId String
TaxAmountCurrency String
TaxAmount Decimal
TaxScheduleId String
TaxesAggregate String
TradeDiscountAmountCurrency String
TradeDiscountAmount Decimal
TransactionState String
Type String
VoidDate Datetime
GSTDiscountAmountCurrency String
GSTDiscountAmount Decimal
PaymentCashAmountCurrency String
PaymentCashAmount Decimal
PaymentCashBankAccountId String
PaymentCashDate Datetime
PaymentCashNumber String
PaymentCheckAmountCurrency String
PaymentCheckAmount Decimal
PaymentCheckBankAccountId String
PaymentCheckCheckNumber String
PaymentCheckDate Datetime
PaymentCheckNumber String
PaymentPaymentCardAmountCurrency String
PaymentPaymentCardAmount Decimal
PaymentPaymentCardDate Datetime
PaymentPaymentCardNumber String
PaymentPaymentCardReceiptNumber String
PaymentPaymentCardTypeId String
PaymentPaymentCardBankAccountId String
PaymentTermsId String
TermsDiscountItem String
TermsDiscountAvailableAmountCurrency String
TermsDiscountAvailableAmount Decimal
TermsDiscountDate Datetime
TermsDueDate Datetime
TermsDiscountAvailableTakenAmountCurrency String
TermsDiscountAvailableTakenAmount Decimal
TermsDiscountTakenAmountCurrency String
TermsDiscountTakenAmount Decimal
WriteoffAmountCurrency String
WriteoffAmount Decimal
CommissionAmountCurrency String
CommissionAmount Decimal
CommissionBasedOn String
CommissionsExtensionsExtensionAggregate String
CommissionsCommissionAmountCurrency String
CommissionsCommissionAmount Decimal
CommissionsCommissionPercent Decimal
CommissionsKeyReceivablesDocumentId [KEY] String
CommissionsKeySequenceNumber [KEY] Int
CommissionsNoncommissionedAmountCurrency String
CommissionsNoncommissionedAmount Decimal
CommissionsPercentOfSale Decimal
CommissionsSalesAmountCurrency String
CommissionsSalesAmount Decimal
CommissionsSalesTerritoryId String
CommissionsSalespersonId 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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060