Oracle Fusion · Data dictionary
PJC_TXN_XFACE_ALL
ProjectsUsed in 1 subject areas77 reporting columns
Projects Costing (PJC), transaction table (rows scoped across all operating units).
Primary key: not yet catalogued for PJC_TXN_XFACE_ALL, reference Oracle Tables & Views guide.
Joins (inferred from key columns): EXPENDITURE_ITEM_ID → PJC_EXP_ITEMS_ALL
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACCRUAL_FLAG | ● | Indicator (Y/N) for the accrual. | |
| ACCRUE_ON_RECEIPT_FLAG | ● | Indicator (Y/N) for the accrue on receipt. | |
| 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. | |
| ADJUSTED_EXPENDITURE_ITEM_ID | ● | Identifier for the adjusted expenditure item. | |
| ADJUSTED_TXN_INTERFACE_ID | ● | Identifier for the adjusted transaction interface. | |
| ALLOW_CC_FLAG | ● | Indicator (Y/N) for the allow cc. | |
| BATCH_DESCRIPTION | ● | Description of the batch. | |
| BATCH_ENDING_DATE | ● | Batch ending date. | |
| BATCH_NAME | ● | Name of the batch. | |
| BILLABLE_FLAG | ● | Indicator (Y/N) for the billable. | |
| BURDENED_COST_RATE | ● | Burdened cost rate. | |
| CAPITALIZABLE_FLAG | ● | Indicator (Y/N) for the capitalizable. | |
| CDL_LINE_NUM | ● | Cdl line number. | |
| CDL_LINE_NUM_REVERSED | ● | Cdl line number reversed. | |
| CDL_LINE_TYPE | ● | Type of cdl line. | |
| CDL_PARENT_LINE_NUM | ● | Cdl parent line number. | |
| 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_RAW_COST | ● | Denom raw cost. | |
| DOCUMENT_DISTRIBUTION_TYPE | ● | Type of document distribution. | |
| EI_CREATION_FLAG | ● | Indicator (Y/N) for the ei creation. | |
| ERROR_GROUP | ● | Error group. | |
| EXPENDITURE_COMMENT | ● | Expenditure comment. | |
| EXPENDITURE_ENDING_DATE | ● | Expenditure ending date. | |
| EXPENDITURE_ITEM_ID | ● | Identifier for the expenditure item. | |
| 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. | |
| 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_EXP_TXN_REFERENCE1 | ● | Orig exp transaction reference1. | |
| ORIG_EXP_TXN_REFERENCE2 | ● | Orig exp transaction reference2. | |
| ORIG_EXP_TXN_REFERENCE3 | ● | Orig exp transaction reference3. | |
| ORIG_TRANSACTION_REFERENCE | ● | Orig transaction reference. | |
| ORIG_USER_EXP_TXN_REFERENCE | ● | Orig user exp transaction reference. | |
| PARENT_DIST_ID | ● | Identifier for the parent distribution. | |
| PARENT_HEADER_ID | ● | Identifier for the parent header. | |
| PARENT_LINE_NUMBER | ● | Parent line number. | |
| PARENT_REVERSAL_ID | ● | Identifier for the parent reversal. | |
| PERSON_TYPE | ● | Type of person. | |
| PROJECT_BURDENED_COST | ● | Project burdened cost. | |
| 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. | |
| 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. | |
| QUANTITY | ● | Quantity. | |
| RAW_COST_RATE | ● | Raw cost rate. | |
| RAW_LINE_NUM_REVERSED | ● | Raw line number reversed. | |
| RECEIPT_CURRENCY_AMOUNT | ● | Receipt currency amount. | |
| RECEIPT_EXCHANGE_RATE | ● | Receipt exchange rate. | |
| REQUEST_ID | ● | Identifier of the process that created or last updated the row. | |
| REVERSAL_FLAG | ● | Indicator (Y/N) for the reversal. | |
| REVERSED_ORIG_TXN_REFERENCE | ● | Reversed orig transaction reference. | |
| SOURCE_EXP_ITEM_ID | ● | Identifier for the source exp item. | |
| SRC_SYSTEM_LINKAGE_FUNCTION | ● | Src system linkage function. | |
| TRANSACTION_STATUS_CODE | ● | Code identifying the transaction status. | |
| TXN_INTERFACE_ID | ● | Identifier for the transaction interface. | |
| TXN_REVIEW_COMMENT | ● | Transaction review comment. | |
| UNMATCHED_NEGATIVE_TXN_FLAG | ● | Indicator (Y/N) for the unmatched negative transaction. |
Used by reports
No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.
- ,
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.
Need the extract + dbt staging for PJC_TXN_XFACE_ALL?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table