Expense Management Tables

Employee Profile Definition (F20103)

Stores employee information, such as the approving manager.

Expense Report Group Profiles (F20104)

Stores employee group information, such as the reimbursement method and currency.

Account Mapping Definition (F20106)

Stores account information by expense category.

Business Purpose History (F20107)

Stores the last 10 business purposes that each employee entered on his or her expense report.

Expense Report Header (F20111)

Stores information about the expense report, such as the employee ID, expense report type, expense report ending date, and expense report description.

Expense Report Detail (F20112)

Stores information about the expense report details, such as the expense report categories, expense date, and expense amount.

Tax Mapping (F09E105)

Stores tax information for each expense category by expense location.

Policy Edit Rules (F09E108)

Stores the policy rules for each expense category by expense report type.

Expense Category Setup (F09E109)

Stores the expense categories by expense report type.

Audit Selection Rules (F09E110)

Stores the audit rules for each policy that you establish.

Exchange Rate Identifiers (F09E114)

Stores the cross-reference information that the system needs to retrieve the appropriate exchange rate to reimburse expenses incurred in a foreign currency.

Credit Card Information (F0075)

Stores the credit card numbers, expirations dates, and credit card address book numbers.

Expense Reimbursement Routing Rules (F09E119)

Stores the routing rules for each expense report type.

Expense Category/Report Type to Pay Type Mapping (F09E118)

Stores the payroll PDBA (pay type, deduction, benefit, accrual) codes by expense report type and expense category.

Expense Report Routing History Log (F09E120)

Stores information about the expense report statuses that the system assigns during the reimbursement process.

Credit Card Transaction Interface Table (F09E150)

Stores information about credit card transactions received from the credit card company.