Tableau Connector for Microsoft Dynamics GP

Build 24.0.9060

ProjectTimesheet

Return a list of: ProjectTimesheet

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
DistributionsAggregate String
EmployeeId String
Id [KEY] String
LinesAggregate String
PeriodEndDate Datetime
PersonalDataKeeperProxyId String
PersonalDataKeeperTimesheetNumber String
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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060