ProjectAccounts
Return a list of: ProjectAccounts
Columns
| Name | Type | Description |
| ExtensionsExtensionAggregate | String | |
| AccountAmountCurrency | String | |
| AccountAmount | Decimal | |
| AccountingMethod | String | |
| AccountsExtensionsExtensionAggregate | String | |
| AccountsGLAccountId | String | |
| AccountsGLAccountKeyIsEncrypted | Bool | |
| AccountsKeyCostTransaction [KEY] | String | |
| AccountsKeyDistributionTypeId [KEY] | Int | |
| AccountsKeyProjectId [KEY] | String | |
| AccountsKeySourceFile [KEY] | 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 | 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 |