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 |