JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

Project

Return a list of: Project

Columns

Name Type Description
ExtensionsExtensionAggregate String
AccountAmountCurrency String
AccountAmount Decimal
AccountingMethod String
AccountsAggregate String
ActualAccruedRevenueAmountCurrency String
ActualAccruedRevenueAmount Decimal
ActualBillingAmountCurrency String
ActualBillingAmount Decimal
ActualBillingsInExcessOfEarningsAmountCurrency String
ActualBillingsInExcessOfEarningsAmount Decimal
ActualDiscountAmountCurrency String
ActualDiscountAmount Decimal
ActualEarningsInExcessOfBillingsAmountCurrency String
ActualEarningsInExcessOfBillingsAmount Decimal
ActualOverheadAmountCurrency String
ActualOverheadAmount Decimal
ActualProfitAmountCurrency String
ActualProfitAmount Decimal
ActualQuantity Decimal
ActualRecognizedRevenueAmountCurrency String
ActualRecognizedRevenueAmount Decimal
ActualRetainageAmountCurrency String
ActualRetainageAmount Decimal
ActualSalesTaxAmountCurrency String
ActualSalesTaxAmount Decimal
ActualTaxAmountCurrency String
ActualTaxAmount Decimal
ActualTotalCostCurrency String
ActualTotalCost Decimal
ActualBeginDate Datetime
ActualEndDate Datetime
BaselineBeginDate Datetime
BaselineBillableAmountCurrency String
BaselineBillableAmount Decimal
BaselineEndDate Datetime
BaselineOverheadCostCurrency String
BaselineOverheadCost Decimal
BaselineProfitAmountCurrency String
BaselineProfitAmount Decimal
BaselineQuantity Decimal
BaselineTaxAmountCurrency String
BaselineTaxAmount Decimal
BaselineTotalCostCurrency String
BaselineTotalCost Decimal
BillToAddressId String
BilledAccruedRevenueCurrency String
BilledAccruedRevenue Decimal
BilledCostCurrency String
BilledCost Decimal
BilledQuantity Decimal
BillingCyclesAggregate String
BillingNotReceivableCurrency String
BillingNotReceivable Decimal
BillingType String
BudgetsAggregate String
BusinessManagerId String
CloseToBillings Bool
CloseToProjectCosts Bool
CommissionBasedOn String
CommissionPercent Decimal
ContactPerson String
CostCompletedPercent Decimal
CurrencyKeyISOCode String
CustomerId String
CustomerPONumber String
DefaultBillingFormat String
DepartmentId String
DiscountPercent Decimal
DoesAcceptEquipmentRateTableReplacement Bool
DoesAcceptLaborRateTableReplacement Bool
DoesCombineForRevenueRecognition Bool
EquipmentListAggregate String
EquipmentRateTableId String
EstimatorId String
FeesAggregate String
ForecastBeginDate Datetime
ForecastBillableAmountCurrency String
ForecastBillableAmount Decimal
ForecastEndDate Datetime
ForecastOverheadCostCurrency String
ForecastOverheadCost Decimal
ForecastProfitAmountCurrency String
ForecastProfitAmount Decimal
ForecastQuantity Decimal
ForecastTaxAmountCurrency String
ForecastTaxAmount Decimal
ForecastTotalCostCurrency String
ForecastTotalCost Decimal
Id [KEY] String
LaborRateTableId String
LaborRateTableType String
Name String
POCommittedCostsCurrency String
POCommittedCosts Decimal
POCommittedQuantity Decimal
PostedAccruedRevenueAmountCurrency String
PostedAccruedRevenueAmount Decimal
PostedBillingAmountCurrency String
PostedBillingAmount Decimal
PostedBillingsInExcessOfEarningsAmountCurrency String
PostedBillingsInExcessOfEarningsAmount Decimal
PostedDiscountAmountCurrency String
PostedDiscountAmount Decimal
PostedEarningsInExcessOfBillingsAmountCurrency String
PostedEarningsInExcessOfBillingsAmount Decimal
PostedOverheadAmountCurrency String
PostedOverheadAmount Decimal
PostedProfitAmountCurrency String
PostedProfitAmount Decimal
PostedQuantity Decimal
PostedRecognizedRevenueAmountCurrency String
PostedRecognizedRevenueAmount Decimal
PostedRetainageAmountCurrency String
PostedRetainageAmount Decimal
PostedSalesTaxAmountCurrency String
PostedSalesTaxAmount Decimal
PostedTaxAmountCurrency String
PostedTaxAmount Decimal
PostedTotalCostCurrency String
PostedTotalCost Decimal
PostedEarningsAmountCurrency String
PostedEarningsAmount Decimal
PostedPOCostsCurrency String
PostedPOCosts Decimal
PostedPOQuantity Decimal
PostedBilledRetentionAmountCurrency String
PostedBilledRetentionAmount Decimal
PostedCostOfEarningsAmountCurrency String
PostedCostOfEarningsAmount Decimal
PostedLossAmountCurrency String
PostedLossAmount Decimal
PostedProjectFeeAmountCurrency String
PostedProjectFeeAmount Decimal
PostedReceiptsAmountCurrency String
PostedReceiptsAmount Decimal
PostedRetainerFeeAmountCurrency String
PostedRetainerFeeAmount Decimal
PostedRetentionAmountCurrency String
PostedRetentionAmount Decimal
PostedServiceFeeAmountCurrency String
PostedServiceFeeAmount Decimal
PostedWriteoffAmountCurrency String
PostedWriteoffAmount Decimal
ProjectAmountCurrency String
ProjectAmount Decimal
ProjectClassId String
ProjectContractId String
ProjectContractId String
ProjectFeeAmountCurrency String
ProjectFeeAmount Decimal
ProjectId String
ProjectManagerId String
QuantityCompletedPercent Decimal
RestrictToCustomerList Bool
RetainerAmountCurrency String
RetainerAmount Decimal
RetentionFeeAmountCurrency String
RetentionFeeAmount Decimal
RetentionPercent Decimal
SUTAState String
SalesTerritoryId String
SalespersonId String
ServiceFeeAmountCurrency String
ServiceFeeAmount Decimal
Status String
TransactionalCurrencyCodeKeyISOCode String
Type String
UnpostedAccruedRevenueAmountCurrency String
UnpostedAccruedRevenueAmount Decimal
UnpostedBillingAmountCurrency String
UnpostedBillingAmount Decimal
UnpostedBillingsInExcessOfEarningsAmountCurrency String
UnpostedBillingsInExcessOfEarningsAmount Decimal
UnpostedDiscountAmountCurrency String
UnpostedDiscountAmount Decimal
UnpostedEarningsInExcessOfBillingsAmountCurrency String
UnpostedEarningsInExcessOfBillingsAmount Decimal
UnpostedOverheadAmountCurrency String
UnpostedOverheadAmount Decimal
UnpostedProfitAmountCurrency String
UnpostedProfitAmount Decimal
UnpostedQuantity Decimal
UnpostedRecognizedRevenueAmountCurrency String
UnpostedRecognizedRevenueAmount Decimal
UnpostedRetainageAmountCurrency String
UnpostedRetainageAmount Decimal
UnpostedSalesTaxAmountCurrency String
UnpostedSalesTaxAmount Decimal
UnpostedTaxAmountCurrency String
UnpostedTaxAmount Decimal
UnpostedTotalCostCurrency String
UnpostedTotalCost Decimal
UnpostedLossAmountCurrency String
UnpostedLossAmount Decimal
UnpostedBilledRetentionAmountCurrency String
UnpostedBilledRetentionAmount Decimal
UnpostedCostOfEarningsAmountCurrency String
UnpostedCostOfEarningsAmount Decimal
UnpostedEarningsAmountCurrency String
UnpostedEarningsAmount Decimal
UnpostedPOCostsCurrency String
UnpostedPOCosts Decimal
UnpostedPOQuantity Decimal
UnpostedProjectFeeAmountCurrency String
UnpostedProjectFeeAmount Decimal
UnpostedReceiptsAmountCurrency String
UnpostedReceiptsAmount Decimal
UnpostedRetainerFeeAmountCurrency String
UnpostedRetainerFeeAmount Decimal
UnpostedRetentionAmountCurrency String
UnpostedRetentionAmount Decimal
UnpostedServiceFeeAmountCurrency String
UnpostedServiceFeeAmount Decimal
UserDefinedText1 String
UserDefinedText2 String
WorkersCompensationId String
WriteUpDownAmountCurrency String
WriteUpDownAmount 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