SSIS Components for Microsoft Dynamics GP

Build 24.0.9062

ProjectChangeOrderFees

Return a list of: ProjectChangeOrderFees

Columns

Name Type Description
ExtensionsExtensionAggregate String
ApprovalDate Datetime
ApprovedBy String
ApproverPosition String
BudgetsAggregate String
ContractBeginDate Datetime
ContractEndDate Datetime
CustomerChangeOrderNumber String
CustomerId String
Date Datetime
Description String
DocumentStatus String
EstimatedBy String
FeesExtensionsExtensionAggregate String
FeesContractBeginDate Datetime
FeesContractEndDate Datetime
FeesKeyProjectChangeOrderId [KEY] String
FeesKeyProjectChangeOrderKeyProjectContractId [KEY] String
FeesKeyProjectId [KEY] String
FeesLinesAggregate String
FeesPostedProjectFeeAmountCurrency String
FeesPostedProjectFeeAmount Decimal
FeesPostedRetainerFeeAmountCurrency String
FeesPostedRetainerFeeAmount Decimal
FeesPostedRetentionFeeAmountCurrency String
FeesPostedRetentionFeeAmount Decimal
FeesPostedServiceFeeAmountCurrency String
FeesPostedServiceFeeAmount Decimal
FeesSequenceNumber Int
FeesTotalProjectFeeAmountCurrency String
FeesTotalProjectFeeAmount Decimal
FeesTotalRetainerFeeAmountCurrency String
FeesTotalRetainerFeeAmount Decimal
FeesTotalRetentionFeeAmountCurrency String
FeesTotalRetentionFeeAmount Decimal
FeesTotalServiceFeeAmountCurrency String
FeesTotalServiceFeeAmount Decimal
FeesVarianceFeeAmountCurrency String
FeesVarianceFeeAmount Decimal
FeesVarianceProjectFeeAmountCurrency String
FeesVarianceProjectFeeAmount Decimal
FeesVarianceRetainerFeeAmountCurrency String
FeesVarianceRetainerFeeAmount Decimal
FeesVarianceRetentionFeeAmountCurrency String
FeesVarianceRetentionFeeAmount Decimal
FeesVarianceServiceFeeAmountCurrency String
FeesVarianceServiceFeeAmount Decimal
Id String
KeyProjectContractId String
LastProcessedDate Datetime
ModifiedBy String
PreviousContractBeginDate Datetime
PreviousContractEndDate Datetime
PreviousProjectAmountCurrency String
PreviousProjectAmount Decimal
ProjectAmountCurrency String
ProjectAmount Decimal
ReasonForRevision String
RequestedBy String
RevisedBudgetTotalAmountCurrency String
RevisedBudgetTotalAmount Decimal
RevisedBy String
RevisedFeeTotalAmountCurrency String
RevisedFeeTotalAmount Decimal
RevisedProjectAmountCurrency String
RevisedProjectAmount Decimal
RevisersPosition String
SequenceNumber Int
Status String
TotalBillingCurrency String
TotalBilling Decimal
TotalChangeOrderAmountCurrency String
TotalChangeOrderAmount Decimal
TotalCostCurrency String
TotalCost Decimal
TotalQuantity Decimal
TrackChangesToType String
Type String
VarianceProjectAmountCurrency String
VarianceProjectAmount Decimal
VarianceTotalBillingCurrency String
VarianceTotalBilling Decimal
VarianceTotalCostCurrency String
VarianceTotalCost Decimal
VarianceTotalQuantity Decimal

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.9062