SSIS Components for Microsoft Dynamics GP

Build 24.0.9060

ProjectMiscellaneousLogLines

Return a list of: ProjectMiscellaneousLogLines

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
Id String
LinesExtensionsExtensionAggregate String
LinesAccruedRevenueCurrency String
LinesAccruedRevenue Decimal
LinesContraGLAccountId String
LinesContraGLAccountKeyIsEncrypted Bool
LinesCostCategoryId String
LinesCostOfGoodsSoldGLAccountId String
LinesCostOfGoodsSoldGLAccountKeyIsEncrypted Bool
LinesDate Datetime
LinesExtendedCostCurrency String
LinesExtendedCost Decimal
LinesMarkupPercent Decimal
LinesOriginalDocumentSequenceNumber Int
LinesOverheadAmountCurrency String
LinesOverheadAmount Decimal
LinesOverheadGLAccountId String
LinesOverheadGLAccountKeyIsEncrypted Bool
LinesOverheadPercent Decimal
LinesProfitAmountCurrency String
LinesProfitAmount Decimal
LinesProfitType String
LinesProjectContractId String
LinesProjectId String
LinesQuantity Decimal
LinesReferenceDocumentSequenceNumber Int
LinesRoundAmountCurrency String
LinesRoundAmount Decimal
LinesRoundingGLAccountId String
LinesRoundingGLAccountKeyIsEncrypted Bool
LinesTotalCostCurrency String
LinesTotalCost Decimal
LinesTotalOverheadAmountCurrency String
LinesTotalOverheadAmount Decimal
LinesTotalProfitAmountCurrency String
LinesTotalProfitAmount Decimal
LinesUnbilledAccountReceivableGLAccountId String
LinesUnbilledAccountReceivableGLAccountKeyIsEncrypted Bool
LinesUnbilledProjectRevenueGLAccountId String
LinesUnbilledProjectRevenueGLAccountKeyIsEncrypted Bool
LinesUnitCostCurrency String
LinesUnitCost Decimal
LinesUofM String
LinesWorkInProgressGLAccountId String
LinesWorkInProgressGLAccountKeyIsEncrypted Bool
LinesBillingAmountCurrency String
LinesBillingAmount Decimal
LinesBillingProfitAmountCurrency String
LinesBillingProfitAmount Decimal
LinesBillingProfitPercent Decimal
LinesBillingQuantity Decimal
LinesBillingRateCurrency String
LinesBillingRate Decimal
LinesBillingStatus String
LinesBillingTaxAmountCurrency String
LinesBillingTaxAmount Decimal
LinesBillingType String
LinesBillingDiscountAmountCurrency String
LinesBillingDiscountAmount Decimal
LinesKeyProjectMiscellaneousLogId [KEY] String
LinesKeySequenceNumber [KEY] Int
LinesProjectChangeOrderId String
LinesProjectChangeOrderKeyProjectContractId 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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060