ExpenseReportsExpenseExpenseDistribution
Shows how costs from a single expense line are allocated across multiple accounts, departments, or cost centers.
Columns
| Name | Type | 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 | 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 | 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 | 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. |