TEMPACTEXP – This table contains all unapproved Expense entries.
Ÿ ID – The Unique ID for the Unapproved Expense. (PK)
Ÿ SHEET – The Expense Sheet ID that Unapproved Expense belongs to. (FK)
Ÿ PROJECT – The Project for the expense. (FK)
Ÿ EMPLOYEE – The Employee for the expense. (FK)
Ÿ GROUP – The Expense Category. (FK)
Ÿ DATE – The Date for the expense. (FK)
Ÿ PURORD – The Purchase Order number for the expense.
Ÿ INVNUM – The Invoice number for the expense.
Ÿ AMOUNT – The Amount of the expense.
Ÿ MARKUP – The Markup percentage for the expense.
Ÿ FIXED – The Fixed amount for the expense.
Ÿ TAX1 – The Value added tax 1 for the expense.
Ÿ TAX2 - The Value added tax 2 for the expense.
Ÿ DESC – The Description for the expense.
Ÿ REQREI – The Request Reimbursement option for the expense. (T = "True", F = "False")
Ÿ BILLABLE – The Charge to Client option for the expense. (T="True", F = "False")