ExpensesExpenseDff

Holds descriptive flexfield references for an individual expense, enabling custom data collection and categorization.

Columns


Name	Type	Description
ExpensesExpenseId [KEY]	Long	Unique identifier for the expense record, used to track and manage individual expense records within the system.
ExpenseId [KEY]	Long	Identifier for the expense in the ExpensesExpenseDff table, used to link additional data related to the expense in the flexible data fields.
_FLEX_Context	String	Contextual information associated with the ExpensesExpenseDff table, used to specify the flexible data structure for this particular record.
Finder	String	Search term or identifier used to locate and display specific records or entries within the system, enhancing data retrieval.
PersonId	String	Unique identifier for the person associated with the expense, often used to link the expense record to the individual submitting or owning the expense.
Request	String	Request identifier associated with the expense, used for tracking the approval or review process of the expense submission.
SysEffectiveDate	String	System-defined effective date used to determine when the record becomes valid in the system, controlling the timing of its applicability.
CUReferenceNumber	Int	Reference number used to map child aggregates to their parent tables, ensuring relational integrity and data linkage.
EffectiveDate	Date	Date parameter used to fetch resources that are effective as of a specified start date, ensuring that historical data is retrieved correctly.