PJC_COST_DIST_OVERRIDES

PA_COST_DIST_OVERRIDES stores configurations defined at the project level that redirect specific costs and revenue to another organization. You can define a cost distribution override to redirect the costs and revenues generated by a specific employee or by all employees assigned to a specified organization. You can optionally redirect only certain costs and revenues by specifying an expenditure category. The cost distribution programs store the destination organization in the OVERRIDE_TO_ORGANIZATION_ID column of the PA_EXPENDITURE_ITEMS_ALL table. The destination organization overrides the organization that is normally derived from the expenditure or from the Expenditure Organization parameter that is passed to AutoAccounting. The destination organization is stored as the EXPENDITURE_ORGANIZATION_ID in the project accumulator tables. . .

Details

• Schema: FUSION

• Object owner: PJC

• Object type: TABLE

• Tablespace: APPS_TS_TX_DATA

Primary Key

Name	Columns
PJC_COST_DIST_OVERRIDES_PK	COST_DISTRIBUTION_OVERRIDE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
COST_DISTRIBUTION_OVERRIDE_ID	NUMBER		18	Yes	The system-generated number that uniquely identifies the cost distribution override
PROJECT_ID	NUMBER		18	Yes	The identifier of the project that is configured according to the cost distribution override
PERSON_ID	NUMBER		18		The identifier of the employee for which costs and revenue are overridden
OVERRIDE_FROM_ORGANIZATION_ID	NUMBER		18		The identifier of the organization for which costs and revenue are overridden
OVERRIDE_TO_ORGANIZATION_ID	NUMBER		18	Yes	The identifier of the organization to which costs and revenue are overridden
EXPENDITURE_CATEGORY_ID	NUMBER		18		identifier of the Expenditure Category *****
START_DATE_ACTIVE	DATE			Yes	First effective date of the override
END_DATE_ACTIVE	DATE				Last effective date of the override
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	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.

Foreign Keys

Table	Foreign Table	Foreign Key Column
PJC_COST_DIST_OVERRIDES	pjf_projects_all_b	PROJECT_ID
PJC_COST_DIST_OVERRIDES	pjf_exp_categories_b	EXPENDITURE_CATEGORY_ID

Indexes

Index	Uniqueness	Tablespace	Columns
PJC_COST_DIST_OVERRIDES_U1	Unique	Default	COST_DISTRIBUTION_OVERRIDE_ID
PJC_COST_DIST_OVERRIDES_U2	Unique	Default	PROJECT_ID, OVERRIDE_FROM_ORGANIZATION_ID, PERSON_ID, START_DATE_ACTIVE