Line Item Variables

The list of variables that BigTime supports is updated regularly, but here is a list of the most common variables as well as the "numbers" they represent. We also refer (in many items) to their ability to support "sub-totalling." We'll talk about how sub-totalling effects line item formula in the next section.

TIME_CHG. Time charges on the invoice (e.g. - [BillableHours]*[BillingRate]. This item can be sub-totalled (based on the project settings).

TIME_CHG_IN. Total time charges INPUT on an invoice (includes no-charge time as well as input hours that may have been written down). This item can be sub-totalled (based on the project settings).

TOTAL_TIME_CHARGE_ITEMS. This item represents the total time charges (the same variables as the TIME_CHG value), but it doesn't support sub-totalling. So, you can use it in a sub-totalled line item to make sure that you are referring to the overall time charges on the project.

EXPENSE_CHG. Total expenses logged for this invoice. Includes both employee and vendor expenses, and it can be sub-totalled.

EXPENSE_CHG_NC. Total no-charge expenses logged to this invoice.

BUDG_AMT. Total of the pipeline budget, unless the project is sub-totalled by budget item. If the project is sub-totalled by budget item, then the value will represent the line item's current budget amount.

BUDG_COMPLETE. This item is only valid for line items that are sub-totalled by budget item. If you are sub-totalling by budget item, then this item will represent the budget line item's current status code (1 if the item is completed, and 0 if it is not). Otherwise, the value of the item is ZERO.

BUDG_PERCENT. This item is only valid for line items that are sub-totalled by budget item. If you are sub-totalling by budget item, then this item will represent the budget line item's "percent complete" value (a number from 0 to 1). Otherwise, the value of the item is ZERO.

BUDG_PAID. This item is only valid for line items that are sub-totalled by budget item. If you are sub-totalling by budget item, then this item will represent the dollars that have already been invoiced for this budget item. Otherwise, the value of the item is ZERO.

TOTAL_BUDG_AMT. The total amount of the estimate budget for this project. It includes only budget items that are not designated as "expenses only."

TOTAL_BUDG_AMT_EXP. The total amount of the estimate budget designated as "expenses only" for this project.

BUDG_TOTAL. The total of the pipeline budget for this project.

HOURS. Total billable hours that are included on the invoice.

HOURS_IN. Total number of hours "input" on the invoice (including hours marked as no charge or written down).