Oracle Fusion · Data dictionary
PJC_COST_DIST_LINES_ALL
ProjectsUsed in 8 subject areas38 reporting columns
Projects Costing (PJC), project cost distributions to GL.
Primary key: COST_DISTRIBUTION_ID
Joins (inferred from key columns): EXPENDITURE_ITEM_ID → PJC_EXP_ITEMS_ALL
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACCT_BURDENED_COST | ● | Account burdened cost. | |
| ACCT_EXCHANGE_RATE | ● | Account exchange rate. | |
| ACCT_RATE_DATE | ● | Account rate date. | |
| ACCT_RATE_TYPE | ● | Type of account rate. | |
| ACCT_RAW_COST | ● | Account raw cost. | |
| BILLABLE_FLAG | ● | Indicator (Y/N) for the billable. | |
| BUDGETARY_CONTROL_VAL_STATUS | ● | Status of the budgetary control val. | |
| CAPITALIZABLE_FLAG | ● | Indicator (Y/N) for the capitalizable. | |
| COST_DISTRIBUTION_ID | PK | ○ | Identifier for the cost distribution. |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| DENOM_BURDENED_COST | ● | Denom burdened cost. | |
| DENOM_RAW_COST | ● | Denom raw cost. | |
| EXPENDITURE_ITEM_ID | ● | Identifier for the expenditure item. | |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| LAST_UPDATE_LOGIN | ● | Session login of the user who last updated the row. | |
| LINE_NUM | ● | Line number. | |
| LINE_NUM_REVERSED | ● | Line number reversed. | |
| LINE_TYPE | ● | Type of line. | |
| PARENT_LINE_NUM | ● | Parent line number. | |
| PROJECT_BURDENED_COST | ● | Project burdened cost. | |
| PROJECT_EXCHANGE_RATE | ● | Project exchange rate. | |
| PROJECT_RATE_DATE | ● | Project rate date. | |
| PROJECT_RATE_TYPE | ● | Type of project rate. | |
| PROJECT_RAW_COST | ● | Project raw cost. | |
| PROJFUNC_BURDENED_COST | ● | Projfunc burdened cost. | |
| PROJFUNC_COST_EXCHANGE_RATE | ● | Projfunc cost exchange rate. | |
| PROJFUNC_COST_RATE_DATE | ● | Projfunc cost rate date. | |
| PROJFUNC_COST_RATE_TYPE | ● | Type of projfunc cost rate. | |
| PROJFUNC_RAW_COST | ● | Projfunc raw cost. | |
| PRVDR_GL_DATE | ● | Prvdr general ledger date. | |
| PRVDR_PA_DATE | ● | Prvdr pa date. | |
| QUANTITY | ● | Quantity. | |
| RAW_LINE_NUM_REVERSED | ● | Raw line number reversed. | |
| REVERSED_FLAG | ● | Indicator (Y/N) for the reversed. | |
| SI_ASSETS_ADDITION_FLAG | ● | Indicator (Y/N) for the si assets addition. | |
| TRANSFER_REJECTION_REASON | ● | Transfer rejection reason. | |
| TRANSFER_STATUS_CODE | ● | Code identifying the transfer status. |
1 report read from this table
Change a column here and these are the reports that move with it, the blast radius for any change to PJC_COST_DIST_LINES_ALL.
Where this surfaces in OTBI
The OTBI subject areas that expose this table. You can't join across them in OTBI, the owned conformed model joins them on shared keys.
- Budgetary Control - Transactions Real Time
- Project Billing - Invoices Real Time
- Project Billing - Revenue Real Time
- Project Costing - Actual Costs Real Time
- Project Costing - Assets Real Time
- Project Costing - Expenditure Item Performance - Real Time
- Projects - Cross Subject Area Analysis - Real Time
- Subledger Accounting - Journals Real Time
Need the extract + dbt staging for PJC_COST_DIST_LINES_ALL?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table