Expense Distribution

Stores the account and project distribution for an expense item. For example, the cost center or the projects to which the expense needs to be charged.

QName: {http://xmlns.oracle.com/apps/financials/expenses/shared/common/expenseExternalService/}ExpenseDistribution

Relationships

The following table describes how this service data object is related to other service data objects or business object services.

Relationship Type Object or Service

Contains

Expense Company Allocation

Contains

Project Expense Allocation

Contains

Expense Cost Center Allocation

Contained by

Expense Item

Handled by

Expense Item and Expense Report

Attributes

The following table describes attributes in the service data object.

Name Type Description

CodeCombinationId

long

The identifier of the account code combination to which the expense is charged.

CompanyKFF

Expense Company Allocation

The key flexfield that captures the company to which the expense is charged.

CostCenter

string

The cost center to which the expense is charged.

CostCenterKFF

Expense Cost Center Allocation

The key flexfield that captures the cost center to which the expense is charged.

ExpenseDistId

long

The identifier of the expense allocation for an expense.
  • Primary Key

ExpenseId

long

The identifier of the expense.

ExpenseReportId

long

The unique identifier of the expense report.

ObjectVersionNumber

int

The versioning ability implemented for record locking. This number is incremented every time the record is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the record since it was queried.

OrgId

long

The identifier of the business unit that is associated with the person named on the expense report.

PJC_CONTEXT_CATEGORY

string

Project context, such as Expenses, for which project-specific information is provided.

PJC_EXPENDITURE_ITEM_DATE

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The date of a project-related expense item.

PJC_EXPENDITURE_TYPE_Id

decimal

The identifier of the project expense type.

PJC_ORGANIZATION_Id

decimal

The identifier of the project business unit.

PJC_PROJECT_Id

decimal

The identifier of the project descriptive flexfield for a project-related expense.

PJC_TASK_Id

decimal

The identifier of the project task to which the expense is assigned.

ProjectDFF

Project Expense Allocation

The descriptive flexfield that captures the project number, task number, and related information.

ProjectNumber

string

The project number assigned to the expense.

ReimbursableAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The amount reimbursable to the person named on the expense report.

Segment1

string

A segment of the key flexfield.

Segment10

string

A segment of the key flexfield.

Segment11

string

A segment of the key flexfield.

Segment12

string

A segment of the key flexfield.

Segment13

string

A segment of the key flexfield.

Segment14

string

A segment of the key flexfield.

Segment15

string

A segment of the key flexfield.

Segment16

string

A segment of the key flexfield.

Segment17

string

A segment of the key flexfield.

Segment18

string

A segment of the key flexfield.

Segment19

string

A segment of the key flexfield.

Segment2

string

A segment of the key flexfield.

Segment20

string

A segment of the key flexfield.

Segment21

string

A segment of the key flexfield.

Segment22

string

A segment of the key flexfield.

Segment23

string

A segment of the key flexfield.

Segment24

string

A segment of the key flexfield.

Segment25

string

A segment of the key flexfield.

Segment26

string

A segment of the key flexfield.

Segment27

string

A segment of the key flexfield.

Segment28

string

A segment of the key flexfield.

Segment29

string

A segment of the key flexfield.

Segment3

string

A segment of the key flexfield.

Segment30

string

A segment of the key flexfield.

Segment4

string

A segment of the key flexfield.

Segment5

string

A segment of the key flexfield.

Segment6

string

A segment of the key flexfield.

Segment7

string

A segment of the key flexfield.

Segment8

string

A segment of the key flexfield.

Segment9

string

A segment of the key flexfield.

TaskNumber

string

The task number assigned to the expense.