Oracle Fusion · Data dictionary
PJC_EXP_ITEMS_ALL
ProjectsUsed in 8 subject areas98 reporting columns
Projects Costing (PJC), transaction table (rows scoped across all operating units).
Primary key: EXPENDITURE_ITEM_ID
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACCT_BURDENED_COST | ● | Account burdened cost. | |
| ACCT_EXCHANGE_RATE | ● | Account exchange rate. | |
| ACCT_EXCHANGE_ROUNDING_LIMIT | ● | Account exchange rounding limit. | |
| ACCT_RATE_DATE | ● | Account rate date. | |
| ACCT_RATE_DATE_TYPE | ● | Type of account rate date. | |
| ACCT_RATE_TYPE | ● | Type of account rate. | |
| ACCT_RAW_COST | ● | Account raw cost. | |
| ACCT_TP_EXCHANGE_RATE | ● | Account tp exchange rate. | |
| ACCT_TP_RATE_DATE | ● | Account tp rate date. | |
| ACCT_TP_RATE_TYPE | ● | Type of account tp rate. | |
| ACCT_TRANSFER_PRICE | ● | Account transfer price. | |
| ADJUSTED_EXPENDITURE_ITEM_ID | ● | Identifier for the adjusted expenditure item. | |
| ADJUSTMENT_STATUS | ● | Status of the adjustment. | |
| ADJUSTMENT_TYPE | ● | Type of adjustment. | |
| BILLABLE_FLAG | ● | Indicator (Y/N) for the billable. | |
| BILL_HOLD_FLAG | ● | Indicator (Y/N) for the bill hold. | |
| BURDEN_COST_RATE | ● | Burden cost rate. | |
| CAPITALIZABLE_FLAG | ● | Indicator (Y/N) for the capitalizable. | |
| CAPITALIZATION_DIST_FLAG | ● | Indicator (Y/N) for the capitalization distribution. | |
| CC_BL_DISTRIBUTED_CODE | ● | Code identifying the cc bl distributed. | |
| CC_CROSS_CHARGE_CODE | ● | Code identifying the cc cross charge. | |
| CC_CROSS_CHARGE_TYPE | ● | Type of cc cross charge. | |
| CC_MARKUP_BASE_CODE | ● | Code identifying the cc markup base. | |
| CONVERTED_FLAG | ● | Indicator (Y/N) for the converted. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| DENOM_BURDENED_COST | ● | Denom burdened cost. | |
| DENOM_CURRENCY_CODE | ● | Currency code for the denom. | |
| DENOM_RAW_COST | ● | Denom raw cost. | |
| DENOM_TRANSFER_PRICE | ● | Denom transfer price. | |
| EXPENDITURE_ENDING_DATE | ● | Expenditure ending date. | |
| EXPENDITURE_ITEM_DATE | ● | Expenditure item date. | |
| EXPENDITURE_ITEM_ID | PK | ● | Identifier for the expenditure item. |
| IC_BILLABLE_FLAG | ● | Indicator (Y/N) for the ic billable. | |
| IC_BILL_BY_COST_CODE | ● | Code identifying the ic bill by cost. | |
| IC_BILL_HOLD_FLAG | ● | Indicator (Y/N) for the ic bill hold. | |
| IC_INVOICED_FLAG | ● | Indicator (Y/N) for the ic invoiced. | |
| IC_INVOICED_PERCENTAGE | ● | Ic invoiced percentage. | |
| IC_REVENUE_HOLD_FLAG | ● | Indicator (Y/N) for the ic revenue hold. | |
| IC_REVENUE_RECOGNIZED_FLAG | ● | Indicator (Y/N) for the ic revenue recognized. | |
| IC_REV_RECOG_PERCENTAGE | ● | Ic rev recog percentage. | |
| IC_TP_AMT_TYPE_CODE | ● | Code identifying the ic tp amount type. | |
| IC_TP_BASE_CODE | ● | Code identifying the ic tp base. | |
| INVOICED_FLAG | ● | Indicator (Y/N) for the invoiced. | |
| INVOICED_PERCENTAGE | ● | Invoiced percentage. | |
| INVOICE_EXCEPTION_FLAG | ● | Indicator (Y/N) for the invoice exception. | |
| INV_EXCLUDE_FLAG | ● | Indicator (Y/N) for the inventory exclude. | |
| LABOR_COST_MULTIPLIER_NAME | ● | Name of the labor cost multiplier. | |
| 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. | |
| LEDGER_CURR_INV_AMT | ● | Ledger currency inventory amount. | |
| LEDGER_CURR_REV_AMT | ● | Ledger currency rev amount. | |
| NET_ZERO_ADJUSTMENT_FLAG | ● | Indicator (Y/N) for the net zero adjustment. | |
| ORIGINAL_DIST_ID | ● | Identifier for the original distribution. | |
| ORIGINAL_HEADER_ID | ● | Identifier for the original header. | |
| ORIGINAL_LINE_NUMBER | ● | Original line number. | |
| ORIG_TRANSACTION_REFERENCE | ● | Orig transaction reference. | |
| PARENT_DIST_ID | ● | Identifier for the parent distribution. | |
| PARENT_HEADER_ID | ● | Identifier for the parent header. | |
| PARENT_LINE_NUMBER | ● | Parent line number. | |
| PERIOD_ACCRUAL_FLAG | ● | Indicator (Y/N) for the period accrual. | |
| PERSON_TYPE | ● | Type of person. | |
| PROJECT_BURDENED_COST | ● | Project burdened cost. | |
| PROJECT_CURR_INV_AMT | ● | Project currency inventory amount. | |
| PROJECT_CURR_REV_AMT | ● | Project currency rev amount. | |
| PROJECT_EXCHANGE_RATE | ● | Project exchange rate. | |
| PROJECT_RATE_DATE | ● | Project rate date. | |
| PROJECT_RATE_DATE_TYPE | ● | Type of project rate date. | |
| PROJECT_RATE_TYPE | ● | Type of project rate. | |
| PROJECT_RAW_COST | ● | Project raw cost. | |
| PROJECT_TP_EXCHANGE_RATE | ● | Project tp exchange rate. | |
| PROJECT_TP_RATE_DATE | ● | Project tp rate date. | |
| PROJECT_TP_RATE_TYPE | ● | Type of project tp rate. | |
| 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_RATE_DATE_TYPE | ● | Type of projfunc rate date. | |
| PROJFUNC_RAW_COST | ● | Projfunc raw cost. | |
| PROJFUNC_TRANSFER_PRICE | ● | Projfunc transfer price. | |
| PRVDR_ACCRUAL_DATE | ● | Prvdr accrual date. | |
| QUANTITY | ● | Quantity. | |
| RAW_COST_RATE | ● | Raw cost rate. | |
| RECVR_ACCRUAL_DATE | ● | Recvr accrual date. | |
| REVENUE_EXCEPTION_FLAG | ● | Indicator (Y/N) for the revenue exception. | |
| REVENUE_HOLD_FLAG | ● | Indicator (Y/N) for the revenue hold. | |
| REVENUE_RECOGNIZED_FLAG | ● | Indicator (Y/N) for the revenue recognized. | |
| REVENUE_RECOG_PERCENTAGE | ● | Revenue recog percentage. | |
| REV_EXCLUDE_FLAG | ● | Indicator (Y/N) for the rev exclude. | |
| SOURCE_EXPENDITURE_ITEM_ID | ● | Identifier for the source expenditure item. | |
| TP_AMT_TYPE_CODE | ● | Code identifying the tp amount type. | |
| TP_BILL_MARKUP_PERCENTAGE | ● | Tp bill markup percentage. | |
| TP_BILL_RATE | ● | Tp bill rate. | |
| TP_RULE_PERCENTAGE | ● | Tp rule percentage. | |
| TP_SCHEDULE_LINE_PERCENTAGE | ● | Tp schedule line percentage. | |
| TRANSFERRED_FROM_EXP_ITEM_ID | ● | Identifier for the transferred from exp item. | |
| UNIT_OF_MEASURE | ● | Unit of measure. |
5 reports 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_EXP_ITEMS_ALL.
- Projects Asset Management Report
- Projects Budgets vs Actuals Report
- Projects CIP TIP Asset Detail Report
- Projects Global vs Local CER Report
- Projects Transactions Dashboard Report
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_EXP_ITEMS_ALL?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table