ProjectTimesheetDistributions
Return a list of: ProjectTimesheetDistributions
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 | |
| DistributionsKeyProjectTimesheetId [KEY] | String | |
| DistributionsKeySequenceNumber [KEY] | Int | |
| EmployeeId | String | |
| Id | 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 |