iExpenses Table
| 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 |
Subscribe to: Post Comments (Atom)
With this option, employer pays the credit card provider for expenses that are categorizes as business expenses. Employees need to pay the credit card provider for all personal expenses. An invoice cannot be created for the credit card provider until the expense report is imported into Oracle Payables as an Invoice.Below are the process flow diagrams for your reference:
Employer pays for all credit card transactions incurred by their employees. Employees are reimbursed for cash and other business expenses. Credit card transactions reported as business expenses will not impact the amount reimbursed to the employee. However,if the employee reports any transactions as personal expenses, these transactions are offset against any cash and other expenses reported on the expense report. In short, the amount reimbursable to the employee will be reduced by the amount of credit card personal expenses.Below are the process flow diagrams for your reference.