ExpenseReportsExpenseExpenseDistribution
Shows how costs from a single expense line are allocated across multiple accounts, departments, or cost centers.
Columns
| Name | Type | SupportedFinders | Description |
| ExpenseReportsExpenseReportId [KEY] | Long | Unique identifier for the expense report in the system, used to track and reference individual expense reports. | |
| ExpenseExpenseId [KEY] | Long | Unique identifier for each expense item, enabling the identification and tracking of individual expenses. | |
| CodeCombinationId | Long | Unique identifier for the accounting code combination used to categorize and allocate the expense. | |
| CostCenter | String | The business unit or department to which an expense is charged, helping to track expenditures by organizational segment. | |
| CreatedBy | String | Username of the individual who created the record, used for auditing and tracking the origin of the entry. | |
| CreationDate | Datetime | Timestamp indicating when the expense record was created, important for tracking the timeline of financial data entry. | |
| ExpenseDistId [KEY] | Long | Unique identifier for the expense distribution, linking a specific expense item to its distribution. | |
| ExpenseId | Long | Unique identifier for the expense item within an expense distribution, used to associate distributions with the corresponding expense. | |
| ExpenseReportId | Long | PrimaryKey | Unique identifier linking an expense distribution to a specific expense report for consolidation and review. |
| LastUpdateDate | Datetime | Timestamp indicating when the record was last modified, useful for tracking changes and maintaining version history. | |
| LastUpdateLogin | String | Session login ID of the user who last updated the record, used for security and auditing purposes. | |
| LastUpdatedBy | String | Username of the user who last updated the record, providing accountability for data changes. | |
| OrgId | Long | Unique identifier for the organization associated with the expense, enabling segmentation of expenses by organizational unit. | |
| ReimbursableAmount | Decimal | The amount to be reimbursed to the individual for an expense distribution, used for processing reimbursements. | |
| Company | String | The company to which an expense is allocated, essential for tracking expenses at the organizational level. | |
| BusinessUnit | String | FindByBusinessUnit | The specific business unit associated with the expense record, helping to categorize expenses within different units. |
| Finder | String | A search key or filter used to locate specific records or transactions within the system. | |
| SysEffectiveDate | String | FindByBusinessUnit | System-defined effective date used to determine when an expense record or distribution is considered valid. |
| CUReferenceNumber | Int | Identifier used to map child aggregates with parent tables, facilitating the relationship between child and parent data. | |
| EffectiveDate | Date | Date used to fetch resources based on their effective start date, ensuring that data retrieved is valid for the given date. |