Oracle Fusion/Projects/Project Costing

PJC_EXP_ITEMS_ALL

Costed expenditure items — one row per project transaction with quantity, raw cost and burdened cost.

Key Columns

EXPENDITURE_ITEM_IDEXPENDITURE_IDPROJECT_IDTASK_IDEXPENDITURE_TYPEQUANTITYRAW_COSTBURDENED_COST

Parent Table

PJC_EXPENDITURES_ALL

Expenditure batch header — groups expenditure items entered together (timecards, expense reports, misc).

Child Tables

PJC_COST_DIST_LINES_ALL

Accounting distribution lines for an expenditure item — the debits and credits sent to Subledger Accounting.

Common Joins

PJC_COST_DIST_LINES_ALLvia EXPENDITURE_ITEM_ID

The accounting distribution lines generated from this item.

PJF_PROJ_ELEMENTS_Bvia TASK_ID = PROJ_ELEMENT_ID

The task the cost is charged to.

Used In

Project CostingProject Billing

Project costing data model

Costs arrive as expenditure items (PJC_EXP_ITEMS_ALL) grouped into batches (PJC_EXPENDITURES_ALL) — external costs come through PJC_TXN_XFACE_ALL_B. Costing generates distribution lines (PJC_COST_DIST_LINES_ALL) that Subledger Accounting turns into GL journals.