Project
Return a list of: Project
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 | |
BudgetsAggregate | String | |
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 [KEY] | 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 |