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 |