ExpensesExpenseDistributionPJCDFF
Captures project-related flexfields for expense distributions, detailing project codes or tasks linked to the expenditure.
Columns
| Name | Type | Description |
| ExpensesExpenseId [KEY] | Long | Unique identifier for the expense record, used to track and manage individual expenses in the system. |
| ExpensedistributionExpenseDistId [KEY] | Long | Unique identifier for the expense distribution record, used to associate specific expenses with distribution accounts or categories. |
| ExpenseDistId [KEY] | Long | Unique identifier for the expense distribution in the ExpensesExpenseDistributionPJCDFF table, helping to track how an expense is allocated across different accounts. |
| _FLEX_Context | String | Contextual information related to the ExpensesExpenseDistributionPJCDFF table, used to specify the flexible data structure and rules for this particular record. |
| _FLEX_Context_DisplayValue | String | Display value associated with the FLEX context of the ExpensesExpenseDistributionPJCDFF record, used to provide a human-readable description of the context. |
| ExpenseId | Long | Unique identifier for the expense, used to link the expense distribution to the associated expense record in the system. |
| Finder | String | Search term or identifier used to locate and display specific records within the database, making data retrieval easier. |
| PersonId | String | Unique identifier for the person associated with the expense, used to link the expense to the individual who incurred or is responsible for it. |
| Request | String | Request identifier associated with the expense, used to track the approval or review process of the expense submission. |
| SysEffectiveDate | String | System-defined effective date that determines when the record becomes valid in the system, ensuring correct timing and applicability of the data. |
| CUReferenceNumber | Int | Reference number used to link child aggregates to their parent tables, ensuring relational integrity and the maintenance of data structure. |
| EffectiveDate | Date | Date parameter used to fetch resources that are effective as of a specified date, ensuring accurate and timely data retrieval based on the given start date. |