Description
AE_ACCOUNTING
| Contains general expense authorization accounting data including, fiscal year/period, accounting distribution, and approved amount. Additional reporting can be by financial manager or the various hierarchy levels of the fund, organization code, account, program, and location.One row per accounting key. | | |
AE_APPROVAL_HISTORY
| History of requests for authorization or reimbursement approvals.One row per authorization or reimbursement request. | | |
AE_AUTHORIZATION
| Contains information about the request for an authorization, its current status, encumbrance number if generated, expense owner information, and amounts for the authorization as reimbursable and non-reimbursable. When the authorization is associated to requests for reimbursements, the reimbursement amounts are also totaled for reimbursable and non-reimbursable.One row per authorization. | | |
AE_CIRC_HEADER_STEP
| Approval circulation header records and steps.One row per circulation header per circulation step. | | |
AE_CIRC_RECIP_NOTIF
| Approval circulation recipients and notifications.One row per circulation recipient per circulation notification. | | |
AE_DELEGATE_ASSIGNMENT
| Contains personnel assigned to the delegate who is responsible for the creation of authorizations and expense reports.One row per delegate UID per person UID. | | |
AE_EXPENSE_ITEM
| Expenses for the plan to be authorized, reimbursed, or advanced to the traveler.One row per expense item. | | |
AE_EXPENSE_ITEM_TAX
| Contains a breakdown of the taxes used on the authorization or expense report item. The tax rate code, tax rate, receipt tax portion, tax amount in base currency, and tax amount in pay currency. | | |
AE_ITINERARY
| Itineraries which define the various segments of a trip with the travel plan.One row per travel itinerary. | | |
AE_PORTFOLIO
| Portfolios used to group all expenses, authorizations, reimbursements and advances for a person.One row per portfolio. | | |
AE_PROFILE
| Contains data pertaining to a user's profile.One row per profile. | | |
AE_REIMBURSEMENT
| Contains information about the request for a reimbursement, its current status, expense owner and payee information, and reimbursement summary amounts for reimbursable and non-reimbursable expenses. If the reimbursement is associated to an authorization, this also contains summary amounts for the authorization as reimbursable and non-reimbursable.One row per reimbursement. | | |
AE_STATUS_HISTORY
| Contains status and status date history as the authorization / reimbursement request migrates through various stages of completion.One row per authorization or reimbursement per change in status. | | |