ExpensesExpenseDistribution
Allocates the cost of an expense across multiple accounts, ensuring precise financial reporting.
Columns
| Name | Type | Description |
| ExpensesExpenseId [KEY] | Long | Unique identifier for the expense record, used to track and reference individual expenses within the system. |
| CodeCombinationId | Long | Unique identifier for the accounting code combination to which an expense is charged, used for financial reporting and categorization. |
| CostCenter | String | Business organization or department to which the expense is charged, used for budget allocation and financial tracking. |
| CreatedBy | String | Username of the individual who created the record, providing accountability for record creation and data entry. |
| CreationDate | Datetime | Timestamp indicating the exact date and time when the record was created, helping to track the creation process and chronological order. |
| ExpenseDistId [KEY] | Long | Unique identifier for the distribution of a specific expense item, used to associate expenses with specific accounts or categories. |
| ExpenseId | Long | Unique identifier for the expense, used to link the expense to its distribution and track it through the reimbursement process. |
| ExpenseReportId | Long | Unique identifier for the expense report that includes the expense item, helping to link individual expenses to larger reports. |
| LastUpdateDate | Datetime | Timestamp indicating the most recent update to the record, allowing for the tracking of changes and ensuring data accuracy. |
| LastUpdateLogin | String | Login session associated with the user who last updated the record, ensuring traceability and accountability for modifications. |
| LastUpdatedBy | String | Username of the individual who last modified the record, providing transparency regarding updates and changes to the data. |
| OrgId | Long | Unique identifier for the organization to which the expense is associated, helping to track expenses by organizational unit. |
| ReimbursableAmount | Decimal | Amount to be reimbursed to the individual for the expense, used to track how much of the expense is eligible for reimbursement. |
| Company | String | Name of the company to which the expense is charged, helping to classify expenses by the organization to which they belong. |
| BusinessUnit | String | Business unit associated with the expense, used to track and allocate expenses within specific areas or departments of the organization. |
| PJCDFF | String | Column used only for insert operations. For update or delete, refer to the child table's operations, maintaining data integrity. |
| Finder | String | Search term or identifier used to locate specific records or entries within the system, assisting in data retrieval and filtering. |
| PersonId | String | Unique identifier for the person associated with the expense, often used to link the expense to the employee or contractor submitting it. |
| Request | String | Request identifier associated with the expense, used to track the process or approval flow of the expense submission. |
| SysEffectiveDate | String | System-defined effective date that determines when the record becomes valid in the system, controlling the timing of its applicability. |
| CUReferenceNumber | Int | Reference number used to link child aggregates with their parent tables, ensuring relational integrity and maintaining data structure. |
| EffectiveDate | Date | Date parameter used to fetch resources that are effective as of a specified date, ensuring that accurate, time-sensitive data is retrieved. |