Power BI Connector for Microsoft Dynamics GP

Build 24.0.9060

CashReceiptDistributions

Return a list of: CashReceiptDistributions

Columns

Name Type Description
ExtensionsExtensionAggregate String
AmountCurrency String
Amount Decimal
AuditTrailCode String
BankAccountId String
BatchKeyCreatedDateTime Datetime
BatchId String
BatchKeySource String
CheckCardNumber String
CorporateAccountId String
CurrencyKeyISOCode String
CustomerId String
Date Datetime
Description String
DistributionsExtensionsExtensionAggregate String
DistributionsDistributionTypeId Int
DistributionsGLAccountId String
DistributionsGLAccountKeyIsEncrypted Bool
DistributionsReference String
DistributionsKeyReceivablesDocumentId [KEY] String
DistributionsKeySequenceNumber [KEY] Int
ExchangeDate Datetime
ExchangeRate Decimal
GeneralLedgerPostingDate Datetime
IsVoided Bool
Id String
ModifiedBy String
ModifiedDate Datetime
PaymentCardTypeId String
PostedBy String
PostedDate Datetime
Type String
VoidDate 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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060