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 |