Expense Distributions
The expense distributions view object contains distribution information for a specific expense line.
Data store key : FscmTopModelAM.FinExtractAM.ExmBiccExtractAM.ExpenseDistributionExtractPVO
Primary Keys : ExpenseDistributionId
Initial Extract Date : ExpenseDistributionCreationDate
Incremental Extract Date : ExpenseDistributionLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| ExpenseDistributionCodeCombinationId | The identifier of the accounting code combination to which the expense is charged. |
| ExpenseDistributionCostCenter | The cost center to which the expense needs to be charged. |
| ExpenseDistributionCreatedBy | The user who created the expense distribution row. |
| ExpenseDistributionCreationDate | The date and time when the expense distribution was created. |
| ExpenseDistributionExpenseId | The identifier of the expense for this distribution. |
| ExpenseDistributionExpenseReportId | The identifier of the expense report which includes the expense corresponding to this distribution. |
| ExpenseDistributionId | The unique identifier of the expense distribution of a specific expense item. |
| ExpenseDistributionLastUpdateDate | The date and time when the expense distribution row was last updated. |
| ExpenseDistributionLastUpdateLogin | The session login associated with the user who last updated the expense distribution row. |
| ExpenseDistributionLastUpdatedBy | The user who last updated the expense distribution row. |
| ExpenseDistributionObjectVersionNumber | The number used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
| ExpenseDistributionOrgId | The identifier of the business unit associated to the row. |
| ExpenseDistributionPjcBillableFlag | Indicates whether a project-related item is available to be billed to customers. |
| ExpenseDistributionPjcCapitalizableFlag | Indicates whether a project-related item is eligible for capitalization. |
| ExpenseDistributionPjcContextCategory | The segment used to identify the descriptive flexfield application context for project-related standardized cost collection. |
| ExpenseDistributionPjcContractId | The identifier of the contract. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed. |
| ExpenseDistributionPjcContractLineId | The identifier of contract line information. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed. |
| ExpenseDistributionPjcExpenditureItemDate | The date on which a project-related transaction is incurred. |
| ExpenseDistributionPjcExpenditureTypeId | The expenditure type used to build the transaction descriptive flexfield for project-related transaction distributions. |
| ExpenseDistributionPjcFundingAllocationId | The name of the project funding override. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed |
| ExpenseDistributionPjcOrganizationId | The identifier for expenditure organization used to build the transaction descriptive flexfield for project-related transaction distributions. |
| ExpenseDistributionPjcProjectId | The identifier of the project used to build the transaction descriptive flexfield for project-related transaction distributions. |
| ExpenseDistributionPjcReservedAttribute1 | An attribute reserved for project-related functionality. |
| ExpenseDistributionPjcReservedAttribute10 | An attribute reserved for project-related functionality. |
| ExpenseDistributionPjcReservedAttribute2 | An attribute reserved for project-related functionality. |
| ExpenseDistributionPjcReservedAttribute3 | An attribute reserved for project-related functionality. |
| ExpenseDistributionPjcReservedAttribute4 | An attribute reserved for project-related functionality. |
| ExpenseDistributionPjcReservedAttribute5 | An attribute reserved for project-related functionality. |
| ExpenseDistributionPjcReservedAttribute6 | An attribute reserved for project-related functionality. |
| ExpenseDistributionPjcReservedAttribute7 | An attribute reserved for project-related functionality. |
| ExpenseDistributionPjcReservedAttribute8 | An attribute reserved for project-related functionality. |
| ExpenseDistributionPjcReservedAttribute9 | An attribute reserved for project-related functionality. |
| ExpenseDistributionPjcTaskId | The identifier of the task used to build the transaction descriptive flexfield for project-related transaction distributions. |
| ExpenseDistributionPjcUserDefAttribute1 | An attribute reserved for user-definable project information. |
| ExpenseDistributionPjcUserDefAttribute10 | An attribute reserved for user-definable project information. |
| ExpenseDistributionPjcUserDefAttribute2 | An attribute reserved for user-definable project information. |
| ExpenseDistributionPjcUserDefAttribute3 | An attribute reserved for user-definable project information. |
| ExpenseDistributionPjcUserDefAttribute4 | An attribute reserved for user-definable project information. |
| ExpenseDistributionPjcUserDefAttribute5 | An attribute reserved for user-definable project information. |
| ExpenseDistributionPjcUserDefAttribute6 | An attribute reserved for user-definable project information. |
| ExpenseDistributionPjcUserDefAttribute7 | An attribute reserved for user-definable project information. |
| ExpenseDistributionPjcUserDefAttribute8 | An attribute reserved for user-definable project information. |
| ExpenseDistributionPjcUserDefAttribute9 | An attribute reserved for user-definable project information. |
| ExpenseDistributionPjcWorkTypeId | The identifier for project-related classification of the work performed. |
| ExpenseDistributionPreparerModifiedFlag | Indicates whether the expense preparer modified the account or project distribution. |
| ExpenseDistributionReimbursableAmount | The amount to be reimbursed to the individual against this expense distribution. |
| ExpenseDistributionSegment1 | A segment of the Expense Distributions descriptive flexfield. |
| ExpenseDistributionSegment10 | A segment of the Expense Distributions descriptive flexfield. |
| ExpenseDistributionSegment11 | A segment of the Expense Distributions descriptive flexfield. |
| ExpenseDistributionSegment12 | A segment of the Expense Distributions descriptive flexfield. |
| ExpenseDistributionSegment13 | A segment of the Expense Distributions descriptive flexfield. |
| ExpenseDistributionSegment14 | A segment of the Expense Distributions descriptive flexfield. |
| ExpenseDistributionSegment15 | A segment of the Expense Distributions descriptive flexfield. |
| ExpenseDistributionSegment16 | A segment of the Expense Distributions descriptive flexfield. |
| ExpenseDistributionSegment17 | A segment of the Expense Distributions descriptive flexfield. |
| ExpenseDistributionSegment18 | A segment of the Expense Distributions descriptive flexfield. |
| ExpenseDistributionSegment19 | A segment of the Expense Distributions descriptive flexfield. |
| ExpenseDistributionSegment2 | A segment of the Expense Distributions descriptive flexfield. |
| ExpenseDistributionSegment20 | A segment of the Expense Distributions descriptive flexfield. |
| ExpenseDistributionSegment21 | A segment of the Expense Distributions descriptive flexfield. |
| ExpenseDistributionSegment22 | A segment of the Expense Distributions descriptive flexfield. |
| ExpenseDistributionSegment23 | A segment of the Expense Distributions descriptive flexfield. |
| ExpenseDistributionSegment24 | A segment of the Expense Distributions descriptive flexfield. |
| ExpenseDistributionSegment25 | A segment of the Expense Distributions descriptive flexfield. |
| ExpenseDistributionSegment26 | A segment of the Expense Distributions descriptive flexfield. |
| ExpenseDistributionSegment27 | A segment of the Expense Distributions descriptive flexfield. |
| ExpenseDistributionSegment28 | A segment of the Expense Distributions descriptive flexfield. |
| ExpenseDistributionSegment29 | A segment of the Expense Distributions descriptive flexfield. |
| ExpenseDistributionSegment3 | A segment of the Expense Distributions descriptive flexfield. |
| ExpenseDistributionSegment30 | A segment of the Expense Distributions descriptive flexfield. |
| ExpenseDistributionSegment4 | A segment of the Expense Distributions descriptive flexfield. |
| ExpenseDistributionSegment5 | A segment of the Expense Distributions descriptive flexfield. |
| ExpenseDistributionSegment6 | A segment of the Expense Distributions descriptive flexfield. |
| ExpenseDistributionSegment7 | A segment of the Expense Distributions descriptive flexfield. |
| ExpenseDistributionSegment8 | A segment of the Expense Distributions descriptive flexfield. |
| ExpenseDistributionSegment9 | A segment of the Expense Distributions descriptive flexfield. |
| ExpenseDistributionSequenceNum | The sequence in which the distributions are created. |