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)
Ÿ GROUP – The expense category ID that this expense relates to. (FK)
Ÿ DATE – The date of the expense. (FK)
Ÿ 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.)
Ÿ TAX1 – The first Value Added Tax for the expense.
Ÿ TAX2 – The second Value Added Tax for the expense.
Ÿ DESC – The description of the expense.
Ÿ REQREI – If a request for reimbursement has been made this field is "T" otherwise it is "F".
Ÿ BILLABLE – If this expense can be charged to the client the field is "T" otherwise it is "F".
Ÿ BILLED – If the expense has been billed the field is "T" otherwise it is "F".
Ÿ APPROVED – If the expense has been approved 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.