JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

ProjectMiscellaneousLogDistributions

Return a list of: ProjectMiscellaneousLogDistributions

Columns

Name Type Description
ExtensionsExtensionAggregate String
AuditTrailCode String
BatchKeyCreatedDateTime Datetime
BatchId String
BatchKeySource String
Comment String
CreatedBy String
CreatedDate Datetime
CurrencyKeyISOCode String
Date Datetime
ExchangeDate Datetime
ExchangeRate Decimal
GeneralLedgerPostingDate Datetime
OriginalDocumentId String
PostedBy String
PostedDate Datetime
ReferenceDocumentNumber String
ReportSuffix String
TotalAccruedRevenueCurrency String
TotalAccruedRevenue Decimal
TotalCostCurrency String
TotalCost Decimal
TotalQuantity Decimal
TransactionState String
TransactionType String
UserDefined1 String
UserDefined2 String
UserId String
DistributionsExtensionsExtensionAggregate String
DistributionsAuditTrailCode String
DistributionsCreditAmountCurrency String
DistributionsCreditAmount Decimal
DistributionsDebitAmountCurrency String
DistributionsDebitAmount Decimal
DistributionsDistributionTypeId Int
DistributionsGLAccountId String
DistributionsGLAccountKeyIsEncrypted Bool
DistributionsReference String
DistributionsKeyControlType [KEY] Int
DistributionsKeyProjectMiscellaneousLogId [KEY] String
DistributionsKeySequenceNumber [KEY] Int
DistributionsUserId String
Id String
LinesAggregate String
MiscellaneousId String
PeriodEndDate Datetime
ReportingDate Datetime
ReportingPeriod 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