JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

ProjectBudgets

Return a list of: ProjectBudgets

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
BudgetsExtensionsExtensionAggregate String
BudgetsActualBeginDate Datetime
BudgetsActualCostOfEarningsAmountCurrency String
BudgetsActualCostOfEarningsAmount Decimal
BudgetsActualEndDate Datetime
BudgetsActualLossAmountCurrency String
BudgetsActualLossAmount Decimal
BudgetsActualReceiptsAmountCurrency String
BudgetsActualReceiptsAmount Decimal
BudgetsActualWriteoffAmountCurrency String
BudgetsActualWriteoffAmount Decimal
BudgetsBaselineBeginDate Datetime
BudgetsBaselineBillableAmountCurrency String
BudgetsBaselineBillableAmount Decimal
BudgetsBaselineEndDate Datetime
BudgetsBaselineOverheadCostCurrency String
BudgetsBaselineOverheadCost Decimal
BudgetsBaselineProfitAmountCurrency String
BudgetsBaselineProfitAmount Decimal
BudgetsBaselineQuantity Decimal
BudgetsBaselineTaxAmountCurrency String
BudgetsBaselineTaxAmount Decimal
BudgetsBaselineTotalCostCurrency String
BudgetsBaselineTotalCost Decimal
BudgetsBaselineNetProfitAmountCurrency String
BudgetsBaselineNetProfitAmount Decimal
BudgetsBaselineOverheadPercent Decimal
BudgetsBaselineProfitPercent Decimal
BudgetsBaselinePurchaseTaxBasis String
BudgetsBaselinePurchaseTaxScheduleId String
BudgetsBaselineSalesTaxBasis String
BudgetsBaselineSalesTaxScheduleId String
BudgetsBaselineUnitCostCurrency String
BudgetsBaselineUnitCost Decimal
BudgetsBilledAccruedRevenueCurrency String
BudgetsBilledAccruedRevenue Decimal
BudgetsBilledCostCurrency String
BudgetsBilledCost Decimal
BudgetsBilledQuantity Decimal
BudgetsBillingType String
BudgetsCostCompletedPercent Decimal
BudgetsCostOfEarningsAmountCurrency String
BudgetsCostOfEarningsAmount Decimal
BudgetsDoesAcceptEquipmentRateTableReplacement Bool
BudgetsDoesAcceptLaborRateTableReplacement Bool
BudgetsEarningsAmountCurrency String
BudgetsEarningsAmount Decimal
BudgetsEquipmentRateTableId String
BudgetsForecastBeginDate Datetime
BudgetsForecastBillableAmountCurrency String
BudgetsForecastBillableAmount Decimal
BudgetsForecastEndDate Datetime
BudgetsForecastOverheadCostCurrency String
BudgetsForecastOverheadCost Decimal
BudgetsForecastProfitAmountCurrency String
BudgetsForecastProfitAmount Decimal
BudgetsForecastQuantity Decimal
BudgetsForecastTaxAmountCurrency String
BudgetsForecastTaxAmount Decimal
BudgetsForecastTotalCostCurrency String
BudgetsForecastTotalCost Decimal
BudgetsForecastNetProfitAmountCurrency String
BudgetsForecastNetProfitAmount Decimal
BudgetsForecastOverheadPercent Decimal
BudgetsForecastProfitPercent Decimal
BudgetsForecastPurchaseTaxBasis String
BudgetsForecastPurchaseTaxScheduleId String
BudgetsForecastSalesTaxBasis String
BudgetsForecastSalesTaxScheduleId String
BudgetsForecastUnitCostCurrency String
BudgetsForecastUnitCost Decimal
BudgetsIsInventoryItem Bool
BudgetsKeyCostCategoryId [KEY] String
BudgetsKeyProjectId [KEY] String
BudgetsKeyTransactionUsage [KEY] Int
BudgetsLaborRateTableId String
BudgetsLaborRateTableType String
BudgetsLineSequenceNumber Int
BudgetsOverheadRateMethod String
BudgetsPOCommittedCostsCurrency String
BudgetsPOCommittedCosts Decimal
BudgetsPOCommittedQuantity Decimal
BudgetsPayCodeHourlyId String
BudgetsPayCodeSalaryId String
BudgetsPostedAccruedRevenueAmountCurrency String
BudgetsPostedAccruedRevenueAmount Decimal
BudgetsPostedBillingAmountCurrency String
BudgetsPostedBillingAmount Decimal
BudgetsPostedBillingsInExcessOfEarningsAmountCurrency String
BudgetsPostedBillingsInExcessOfEarningsAmount Decimal
BudgetsPostedDiscountAmountCurrency String
BudgetsPostedDiscountAmount Decimal
BudgetsPostedEarningsInExcessOfBillingsAmountCurrency String
BudgetsPostedEarningsInExcessOfBillingsAmount Decimal
BudgetsPostedOverheadAmountCurrency String
BudgetsPostedOverheadAmount Decimal
BudgetsPostedProfitAmountCurrency String
BudgetsPostedProfitAmount Decimal
BudgetsPostedQuantity Decimal
BudgetsPostedRecognizedRevenueAmountCurrency String
BudgetsPostedRecognizedRevenueAmount Decimal
BudgetsPostedRetainageAmountCurrency String
BudgetsPostedRetainageAmount Decimal
BudgetsPostedSalesTaxAmountCurrency String
BudgetsPostedSalesTaxAmount Decimal
BudgetsPostedTaxAmountCurrency String
BudgetsPostedTaxAmount Decimal
BudgetsPostedTotalCostCurrency String
BudgetsPostedTotalCost Decimal
BudgetsPostedEarningsAmountCurrency String
BudgetsPostedEarningsAmount Decimal
BudgetsPostedPOCostsCurrency String
BudgetsPostedPOCosts Decimal
BudgetsPostedPOQuantity Decimal
BudgetsPostedBillableAmountCurrency String
BudgetsPostedBillableAmount Decimal
BudgetsPostedCommittedCostCurrency String
BudgetsPostedCommittedCost Decimal
BudgetsPostedCommittedQuantity Decimal
BudgetsPostedCommittedTaxAmountCurrency String
BudgetsPostedCommittedTaxAmount Decimal
BudgetsPostedTaxPaidAmountCurrency String
BudgetsPostedTaxPaidAmount Decimal
BudgetsProfitType String
BudgetsProjectAmountCurrency String
BudgetsProjectAmount Decimal
BudgetsQuantityCompletedPercent Decimal
BudgetsReceiptsAmountCurrency String
BudgetsReceiptsAmount Decimal
BudgetsStatus String
BudgetsTaxPaidAmountCurrency String
BudgetsTaxPaidAmount Decimal
BudgetsTransactionalCurrencyCodeISOCode String
BudgetsUncommittedPOCostsCurrency String
BudgetsUncommittedPOCosts Decimal
BudgetsUncommittedPOQuantity Decimal
BudgetsUnpostedAccruedRevenueAmountCurrency String
BudgetsUnpostedAccruedRevenueAmount Decimal
BudgetsUnpostedBillingAmountCurrency String
BudgetsUnpostedBillingAmount Decimal
BudgetsUnpostedBillingsInExcessOfEarningsAmountCurrency String
BudgetsUnpostedBillingsInExcessOfEarningsAmount Decimal
BudgetsUnpostedDiscountAmountCurrency String
BudgetsUnpostedDiscountAmount Decimal
BudgetsUnpostedEarningsInExcessOfBillingsAmountCurrency String
BudgetsUnpostedEarningsInExcessOfBillingsAmount Decimal
BudgetsUnpostedOverheadAmountCurrency String
BudgetsUnpostedOverheadAmount Decimal
BudgetsUnpostedProfitAmountCurrency String
BudgetsUnpostedProfitAmount Decimal
BudgetsUnpostedQuantity Decimal
BudgetsUnpostedRecognizedRevenueAmountCurrency String
BudgetsUnpostedRecognizedRevenueAmount Decimal
BudgetsUnpostedRetainageAmountCurrency String
BudgetsUnpostedRetainageAmount Decimal
BudgetsUnpostedSalesTaxAmountCurrency String
BudgetsUnpostedSalesTaxAmount Decimal
BudgetsUnpostedTaxAmountCurrency String
BudgetsUnpostedTaxAmount Decimal
BudgetsUnpostedTotalCostCurrency String
BudgetsUnpostedTotalCost Decimal
BudgetsUnpostedLossAmountCurrency String
BudgetsUnpostedLossAmount Decimal
BudgetsUnpostedBeginDate Datetime
BudgetsUnpostedBillableAmountCurrency String
BudgetsUnpostedBillableAmount Decimal
BudgetsUnpostedCommittedCostCurrency String
BudgetsUnpostedCommittedCost Decimal
BudgetsUnpostedCommittedQuantity Decimal
BudgetsUnpostedCommittedTaxAmountCurrency String
BudgetsUnpostedCommittedTaxAmount Decimal
BudgetsUnpostedEndDate Datetime
BudgetsUofM String
BudgetsUofMScheduleId String
BudgetsWriteUpDownAmountCurrency String
BudgetsWriteUpDownAmount Decimal
BudgetsWriteoffAmountCurrency String
BudgetsWriteoffAmount Decimal
BudgetsWriteoffTaxAmountCurrency String
BudgetsWriteoffTaxAmount Decimal
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 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