JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

ProjectContractBillingCycles

Return a list of: ProjectContractBillingCycles

Columns

Name Type Description
ExtensionsExtensionAggregate String
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
ActualBilledRetentionAmountCurrency String
ActualBilledRetentionAmount Decimal
ActualCommittedPOCostCurrency String
ActualCommittedPOCost Decimal
ActualCommittedPOQuantity Decimal
ActualCommittedPOTaxAmountCurrency String
ActualCommittedPOTaxAmount Decimal
ActualCostOfEarningsAmountCurrency String
ActualCostOfEarningsAmount Decimal
ActualEarningsAmountCurrency String
ActualEarningsAmount Decimal
ActualEndDate Datetime
ActualLossAmountCurrency String
ActualLossAmount Decimal
ActualPOCostsCurrency String
ActualPOCosts Decimal
ActualPOQuantity Decimal
ActualProjectFeeAmountCurrency String
ActualProjectFeeAmount Decimal
ActualReceiptsAmountCurrency String
ActualReceiptsAmount Decimal
ActualRetainerFeeAmountCurrency String
ActualRetainerFeeAmount Decimal
ActualRetentionAmountCurrency String
ActualRetentionAmount Decimal
ActualServiceFeeAmountCurrency String
ActualServiceFeeAmount Decimal
AddressId String
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
BillingCyclesExtensionsExtensionAggregate String
BillingCyclesBillingFormat String
BillingCyclesId [KEY] String
BillingCyclesKeyProjectContractId [KEY] String
BusinessManagerId String
ClassId String
CloseToBillings String
CloseToProjectCosts String
CommissionBasedOn String
CommissionPercent Decimal
ContactPerson String
ContractManagerId String
CostCompletedPercent Decimal
CurrencyKeyISOCode String
CustomerId String
CustomerPONumber String
DefaultBillingFormat String
DiscountPercent Decimal
DoesCombineForRevenueRecognition Bool
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
Name String
POCommittedCostsCurrency String
POCommittedCosts Decimal
POCommittedQuantity Decimal
ProjectAmountCurrency String
ProjectAmount Decimal
ProjectContractId String
ProjectFeeAmountCurrency String
ProjectFeeAmount Decimal
ProjectType String
QuantityCompletedPercent Decimal
RestrictToCustomerList Bool
RetainerAmountCurrency String
RetainerAmount Decimal
RetentionFeeAmountCurrency String
RetentionFeeAmount Decimal
SalesTerritoryId String
SalespersonId String
ServiceFeeAmountCurrency String
ServiceFeeAmount Decimal
Status String
TransactionalCurrencyKeyISOCode 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
UserDefined1 String
UserDefined2 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