JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

ProjectChangeOrder

Return a list of: ProjectChangeOrder

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
FeesAggregate String
Id [KEY] String
KeyProjectContractId [KEY] 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) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462