ACTEXP – The table where Actual Expenses for Projects are stored. The client cost for an expense is calculated as follows: Client Cost = Amount * Markup + Fixed.
Ÿ ID – The unique ID for an expense. (PK)
Ÿ PROJECT – The project ID that this expense relates to. (FK)
Ÿ EMPLOYEE – The employee ID that this expense relates to. (FK)
Ÿ DATE – The date of the expense.
Ÿ PURORD – The purchase order number for the Expense.
Ÿ INVNUM – The invoice number for the Expense.
Ÿ AMOUNT – The base amount of the Expense.
Ÿ MARKUP – The markup on the expense. (This applies to client cost.)
Ÿ FIXED – The fixed amount on the expense. (This applies to client cost.)
Ÿ DESC – The description of the expense.
Ÿ BILLED – If the expense has been billed the field is “T” otherwise it is “F”.
Ÿ ARCHIVE – If this field is “T” the next time an archive is performed this item will be removed.
Ÿ OUTSIDE – Can contain information not internally used by the software. Is used by the Import/Export tool, and can also be used for other customizable purposes.