ExpenseReportsExpenseExpenseDistributionPJCDFF
Offers project-centric descriptive flexfields for expense item distributions, integrating project cost details.
Columns
| Name | Type | Description |
| ExpenseReportsExpenseReportId [KEY] | Long | Unique identifier for the expense report in the system. It is used to track and reference specific reports within the expense management process. |
| ExpenseExpenseId [KEY] | Long | Unique identifier for an individual expense record within the expense report. It helps in linking individual expenses to their respective reports. |
| ExpensedistributionExpenseDistId [KEY] | Long | Unique identifier for the expense distribution record. It tracks how the total expense is distributed across different accounts or categories. |
| ExpenseDistId [KEY] | Long | Identifier used for linking the expense distribution records in the ExpenseReportsExpenseExpenseDistributionPJCDFF table, assisting in the organization of expense data. |
| _FLEX_Context | String | Context identifier related to the flexible data structure used for capturing additional information specific to the expense distribution in the ExpenseReportsExpenseExpenseDistributionPJCDFF. |
| _FLEX_Context_DisplayValue | String | Display value of the FLEX context field, providing a human-readable reference for the specific context of the expense distribution within the system. |
| BusinessUnit | String | The business unit associated with the expense report or distribution. It helps categorize expenses by the specific department or unit within the organization. |
| ExpenseReportId | Long | The unique identifier linking this record to a specific expense report, allowing for easy association between records and their corresponding report. |
| Finder | String | A search parameter used for filtering and locating specific expense records based on certain criteria. It assists in querying and retrieving relevant records. |
| SysEffectiveDate | String | System-defined effective date used for tracking when changes to a record become applicable. It ensures that the data is current and valid based on the specified date. |
| CUReferenceNumber | Int | Reference number used to map child aggregate records to parent tables, enabling relational data organization and ensuring consistency across hierarchical structures. |
| EffectiveDate | Date | The date used to fetch records that are effective as of the specified date, commonly used in queries to retrieve resources valid from that date onward. |