JDBC Driver for Microsoft Dynamics GP

Build 24.0.9062

ProjectBudget

Return a list of: ProjectBudget

Columns

Name Type Description
ExtensionsExtensionAggregate String
ActualBeginDate Datetime
ActualCostOfEarningsAmountCurrency String
ActualCostOfEarningsAmount Decimal
ActualEndDate Datetime
ActualLossAmountCurrency String
ActualLossAmount Decimal
ActualReceiptsAmountCurrency String
ActualReceiptsAmount Decimal
ActualWriteoffAmountCurrency String
ActualWriteoffAmount Decimal
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
BaselineNetProfitAmountCurrency String
BaselineNetProfitAmount Decimal
BaselineOverheadPercent Decimal
BaselineProfitPercent Decimal
BaselinePurchaseTaxBasis String
BaselinePurchaseTaxScheduleId String
BaselineSalesTaxBasis String
BaselineSalesTaxScheduleId String
BaselineUnitCostCurrency String
BaselineUnitCost Decimal
BilledAccruedRevenueCurrency String
BilledAccruedRevenue Decimal
BilledCostCurrency String
BilledCost Decimal
BilledQuantity Decimal
BillingType String
CostCompletedPercent Decimal
CostOfEarningsAmountCurrency String
CostOfEarningsAmount Decimal
DoesAcceptEquipmentRateTableReplacement Bool
DoesAcceptLaborRateTableReplacement Bool
EarningsAmountCurrency String
EarningsAmount Decimal
EquipmentRateTableId 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
ForecastNetProfitAmountCurrency String
ForecastNetProfitAmount Decimal
ForecastOverheadPercent Decimal
ForecastProfitPercent Decimal
ForecastPurchaseTaxBasis String
ForecastPurchaseTaxScheduleId String
ForecastSalesTaxBasis String
ForecastSalesTaxScheduleId String
ForecastUnitCostCurrency String
ForecastUnitCost Decimal
IsInventoryItem Bool
KeyCostCategoryId [KEY] String
KeyProjectId [KEY] String
KeyTransactionUsage [KEY] Int
LaborRateTableId String
LaborRateTableType String
LineSequenceNumber Int
OverheadRateMethod String
POCommittedCostsCurrency String
POCommittedCosts Decimal
POCommittedQuantity Decimal
PayCodeHourlyId String
PayCodeSalaryId String
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
PostedBillableAmountCurrency String
PostedBillableAmount Decimal
PostedCommittedCostCurrency String
PostedCommittedCost Decimal
PostedCommittedQuantity Decimal
PostedCommittedTaxAmountCurrency String
PostedCommittedTaxAmount Decimal
PostedTaxPaidAmountCurrency String
PostedTaxPaidAmount Decimal
ProfitType String
ProjectAmountCurrency String
ProjectAmount Decimal
QuantityCompletedPercent Decimal
ReceiptsAmountCurrency String
ReceiptsAmount Decimal
Status String
TaxPaidAmountCurrency String
TaxPaidAmount Decimal
TransactionalCurrencyCodeISOCode String
UncommittedPOCostsCurrency String
UncommittedPOCosts Decimal
UncommittedPOQuantity Decimal
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
UnpostedBeginDate Datetime
UnpostedBillableAmountCurrency String
UnpostedBillableAmount Decimal
UnpostedCommittedCostCurrency String
UnpostedCommittedCost Decimal
UnpostedCommittedQuantity Decimal
UnpostedCommittedTaxAmountCurrency String
UnpostedCommittedTaxAmount Decimal
UnpostedEndDate Datetime
UofM String
UofMScheduleId String
WriteUpDownAmountCurrency String
WriteUpDownAmount Decimal
WriteoffAmountCurrency String
WriteoffAmount Decimal
WriteoffTaxAmountCurrency String
WriteoffTaxAmount 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