Project Actuals Converted Object Fields

This object and fields are for system use only.

The Project Actuals Converted stores Project Actuals which have been converted into different currencies.

Revenue Actuals

Field		Description
Billed		Sum of billed amounts. Expenses, timecard splits and miscellaneous adjustments that are billable contribute to billed revenue after they are billed/invoiced. Milestones contribute to billed and invoiced revenue after they are billed/invoiced.
Billings		Sum of ready-to-bill revenue from timecards, milestones, and miscellaneous adjustments.
Bookings		Booked revenue for this project. Budgets of type Customer PO and Customer PO Change Order contribute to bookings.
Expense Budget		Sum of expense budgets for the project. The Expense Amount field of a budget contributes to this field if the budget is of type: Customer PO, Customer PO Change Request, Internal Budget or Internal Budget Change Request. The Amount field of a budget contributes to this field if the budget is of type: Billable Expenses or Non-Billable Expenses. Miscellaneous adjustments of type Expense Budget also contribute to this field.
Internal Budget		Sum of internal budgets for the project. The Amount field of a budget contributes to this field if the budget is of type: Internal Budget or Internal Budget Change Request.
Invoiced		Sum of invoiced amounts. Expenses, timecard splits and miscellaneous adjustments that are billable contribute to invoiced revenue after they are billed/invoiced. Milestones contribute to invoiced revenue after they are billed/invoiced.
Margin		Billings minus Total Costs.
Pass-Through Billing		Sum of pass-through billings, including expenses.
Pre-Billed		Amount already billed for the project.
Revenue		Revenue is not calculated or rolled up. Enter a miscellaneous adjustment A catch-all business record that allows you to correct data entry errors or adjust transactions. to show revenue on the project actuals Totals for a given time period..

Individual Revenue Actuals

Individual, or Non-Rolled-up Value (NRV), actuals fields enable you to view the source of the rolled-up actuals fields.

Field		Description
Individual Billed		Individual value of the amounts marked as billed. Derived from this project alone, separate from child project roll ups.
Individual Billings		Individual value of ready-to-bill revenue from business records. Derived from this project alone, separate from child project roll ups.
Individual Bookings		Individual value of Customer POs and Customer PO Change Order budget amounts. Derived from this project alone, separate from child project roll ups.
Individual Expense Budget		Individual value of expense budget amounts. Derived from this project alone, separate from child project roll ups.
Individual Internal Budget		Individual value of Internal Budget and Internal Budget Change Request amounts. Derived from this project alone, separate from child project roll ups.
Individual Invoiced		Individual value of the invoiced amounts. Derived from this project alone, separate from child project roll ups.
Individual Margin		Individual value of Billings and Pass-Through Billings minus Total Costs. Derived from this project alone, separate from child project roll ups.
Individual Pass-Through Billing		Individual value of Billable expense and miscellaneous adjustment pass-through-ready-to-bill revenue amounts. Derived from this project alone, separate from child project roll ups.
Individual Pre-Billed		Individual value of pre-billed amounts from budgets or miscellaneous adjustments. Derived from this project alone, separate from child project roll ups.
Individual Revenue		Individual value of miscellaneous adjustment revenue amounts. Derived from this project alone, separate from child project roll ups.

Cost Actuals

Field		Description
Internal Costs		Sum of internal costs, whether billable or not. Internal costs are only for resources that are not marked as External. They are calculated using this formula: Approved timecard hours * Cost rate
External Costs		Sum of external costs, whether billable or not. Milestones may contribute to flat External Cost if the External Cost field is completed, and the Log Cost as External checkbox is selected. For example, when you count subcontractor fees as a flat cost amount that helped you reach the milestone and achieve the billings.
Expense Costs		Sum of approved expenses in expense reports, whether billable or not.
Other Costs		Any other project costs. Other costs might include things like material or capital costs incurred on the project. These are only generated through miscellaneous adjustments which can also generate any other category of revenue or cost. The Amount field of a budget also contributes to this field if the budget is of type Work Order or Work Order Change Request.
Total Costs		Total costs from all projects in the project hierarchy.

Individual Cost Actuals

Individual, or Non-Rolled-up Value (NRV), actuals fields enable you to view the source of the rolled-up actuals fields.

Field		Description
Individual Internal Costs		Individual value of costs from internal resources. Derived from this project alone, separate from child project roll ups.
Individual External Costs		Individual value of costs from external resources. Derived from this project alone, separate from child project roll ups.
Individual Expense Costs		Individual value of costs associated with expenses. Derived from this project alone, separate from child project roll ups.
Individual Other Costs		Individual value of miscellaneous adjustment other cost amounts. Derived from this project alone, separate from child project roll ups.
Individual Total Costs		Individual value of internal, external, expense and other costs. Derived from this project alone, separate from child project roll ups.

Time Actuals

Field		Description
Billable Hours (External)		Billable timecard hours from external resources.
Billable Hours (Internal)		Billable timecard hours from internal resources. These hours typically contribute to utilization.
Credited Hours		Timecard hours from internal resources, where the timecard has the Time Credited checkbox checked. These hours typically contribute to utilization.
Excluded Hours		Timecard hours from internal resources, where the timecard has the Time Excluded checkbox selected. These hours are also typically subtracted from calendar hours in utilization.
Non-Billable Hours (External)		All non-billable timecard hours from external resources, even if the Time Credited or Time Excluded checkboxes are selected.
Non-Billable Hours (Internal)		Non-billable timecard hours from internal resources, where the Time Credited and Time Excluded checkboxes are both deselected.

Individual Time Actuals

Individual, or Non-Rolled-up Value (NRV) actuals fields enable you to view the source of the rolled-up actuals fields.

Field		Description
Individual Billable Hours (External)		Individual value of billable timecard hours from external resources. Derived from this project alone, separate from child project roll ups.
Individual Billable Hours (Internal)		Individual value of billable timecard hours from internal resources. Derived from this project alone, separate from child project roll ups.
Individual Credited Hours		Individual value of credited Non-Billable timecard hours from internal resource. Derived from this project alone, separate from child project roll ups.
Individual Excluded Hours		Individual value of excluded Non-Billable timecard hours from internal resource. Derived from this project alone, separate from child project roll ups.
Individual Non-Billable Hours (External)		Individual value of Non-Billable timecard hours from external resources. Derived from this project alone, separate from child project roll ups.
Individual Non-Billable Hours (Internal)		Individual value of Non-Billable timecard hours from internal resources. Derived from this project alone, separate from child project roll ups.