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.
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.