List of iExpenses Tables

List of iExpenses Tables 

Table Name	Description
AP_EXPENSE_REPORT_HEADERS_ALL	Expense report header information
AP_EXPENSE_REPORT_LINES_ALL	Expense report lines information
AP_EXP_REPORT_DISTS_ALL	Expense report distribution information. It contains the accounts against each expense report line.
AP_CREDIT_CARD_TRXNS_ALL	Table to store the corporate credit card transactions that are sent by the banks. These lines are saved as expense lines when the user creates the expense lines for credit cards
AP_NOTES	Table to store the comments entered by approvers and auditors
Setup tables
AP_EXPENSE_REPORTS_ALL	This table contains the header level information about the expense templates
AP_EXPENSE_REPORT_PARAMS_ALL	This table contains the detail level information about the expense templates
AP_POL_CAT_OPTIONS_ALL	Table to store the policy options
AP_POL_CONTEXT	Table to store the policy context
AP_POL_LOCATIONS_TL	Table to store the locations for which policies have been defined.
AP_POL_VIOLATIONS_ALL	Table to store the lines for which the defined policies have been violated
AP_POL_ITEMIZATIONS
AP_POL_SCHEDULE_PERIODS
AP_POL_EXRATE_OPTIONS_ALL	Table to store the exchange rate tolerance
AP_POL_HEADERS	Table to store all the policy headers
AP_POL_LINES	Table to store all the policy details
AP_CARDS_ALL	Table to store the corporate credit card details for the employees
AP_EXPENSE_REPORTS_ALL	Table to store the expense report templates that can be used by employees from different operating units
AP_WEB_DISC_HEADERS_GT
AP_POL_SCHEDULE_OPTIONS	Table to store the basis of the policy created, E.g. location, currency, etc.
AP_EXPENSE_REPORT_PARAMS_ALL	Table to store the expense template detailed information
Audit tables
AP_AUD_AUDITORS	Table to store auditor id and security_profile_id
AP_AUD_AUDIT_REASONS	Table containing the expense report header id and audit reason id and code
AP_AUD_AUTO_AUDITS	Table to store the employees who are auditors. This table is updated through the seeded package,AP_WEB_AUDIT_PROCESS.add_to_audit_list
AP_AUD_QUEUES
AP_AUD_RULE_ASSIGNMENTS_ALL	Table containing audit rule assignments
AP_AUD_RULE_SETS	Table containing audit rules