Skip to main content
OracleOps AI
← All tables
Oracle Fusion/Projects/Project Costing

PJC_COST_DIST_LINES_ALL

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

Key Columns

COST_DISTRIBUTION_LINE_IDEXPENDITURE_ITEM_IDPROJECT_IDLINE_TYPECODE_COMBINATION_IDAMOUNT

Parent Table

PJC_EXP_ITEMS_ALL

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

Common Joins

GL_CODE_COMBINATIONSvia CODE_COMBINATION_ID

The GL account the cost posts to.

Used In

Project CostingSubledger Accounting

Related

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.

Ask Oracle AI about PJC_COST_DIST_LINES_ALL