ALER_EXPENSE_EXPORT_LINE (Expense reports export table)

Entity name	ALER_EXPENSE_EXPORT_LINE
Primary keys	EXPORT_ER_LINE_ID
Definition	This table contains the export version of an Expense Report line items and allocations. Data is created for each allocation in the expense report. Therefore, expense line item information may be duplicated if the expense is charged to multiple cost centers or project codes (multiple allocations). If an expense line does not have an allocation (itemized expense lines), the expense is not exported to this table.
Notes

Entity name

ALER_EXPENSE_EXPORT_LINE

Primary keys

EXPORT_ER_LINE_ID

Definition

This table contains the export version of an Expense Report line items and allocations. Data is created for each allocation in the expense report. Therefore, expense line item information may be duplicated if the expense is charged to multiple cost centers or project codes (multiple allocations). If an expense line does not have an allocation (itemized expense lines), the expense is not exported to this table.

Notes