Oracle Fusion · Data dictionary
PJB_REV_DISTRIBUTIONS
ProjectsUsed in 3 subject areas57 reporting columns
Projects Billing (PJB), accounting distribution lines, the GL coding behind each transaction line.
Likely primary key: REV_DISTRIBUTION_ID (inferred from Oracle naming conventions, verify against Tables & Views)
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| BILLING_TYPE_CODE | ● | Code identifying the billing type. | |
| BILL_RATE | ● | Bill rate. | |
| BILL_TRANSACTION_TYPE_CODE | ● | Code identifying the bill transaction type. | |
| CONT_CURR_REVENUE_AMT | ● | Cont currency revenue amount. | |
| CONT_CURR_REV_EXCHG_DATE | ● | Cont currency rev exchg date. | |
| CONT_CURR_REV_EXCHG_RATE | ● | Cont currency rev exchg rate. | |
| CONT_CURR_REV_RATE_TYPE | ● | Type of cont currency rev rate. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| EVENT_NUM | ● | Event number. | |
| EXPORT_PROCESS_ID | ● | Identifier for the export process. | |
| IC_TP_AMT_TYPE_CODE | ● | Code identifying the ic tp amount type. | |
| IC_TP_BASE_CODE | ● | Code identifying the ic tp base. | |
| INVOICE_DATE | ● | Invoice date. | |
| INV_LABOR_RATE_TYPE_CODE | ● | Code identifying the inventory labor rate type. | |
| INV_NL_RATE_TYPE_CODE | ● | Code identifying the inventory nl rate type. | |
| 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_REVENUE_AMT | ● | Ledger currency revenue amount. | |
| LEDGER_CURR_REV_EXCHG_DATE | ● | Ledger currency rev exchg date. | |
| LEDGER_CURR_REV_EXCHG_RATE | ● | Ledger currency rev exchg rate. | |
| LEDGER_CURR_REV_RATE_TYPE | ● | Type of ledger currency rev rate. | |
| LEDGER_RATE_DATE_TYPE | ● | Type of ledger rate date. | |
| LINE_NUM | ● | Line number. | |
| LINE_NUM_REVERSED | ● | Line number reversed. | |
| MAJOR_VERSION | ● | Major version. | |
| PA_DATE | ● | Pa date. | |
| PA_PERIOD_NAME | ● | Name of the pa period. | |
| PROJECT_CURRENCY_EXCHG_DATE | ● | Project currency exchg date. | |
| PROJECT_CURR_EXCHG_RATE | ● | Project currency exchg rate. | |
| PROJECT_CURR_RATE_TYPE | ● | Type of project currency rate. | |
| PROJECT_CURR_REVENUE_AMT | ● | Project currency revenue amount. | |
| PROJECT_RATE_DATE_TYPE | ● | Type of project rate date. | |
| QUANTITY | ● | Quantity. | |
| REVENUE_AMOUNT_CALC_CODE | ● | Code identifying the revenue amount calc. | |
| REVENUE_CATEGORY_CODE | ● | Code identifying the revenue category. | |
| REVENUE_CURR_AMT | ● | Revenue currency amount. | |
| REVENUE_CURR_DATE_TYPE | ● | Type of revenue currency date. | |
| REVENUE_CURR_EXCHG_DATE | ● | Revenue currency exchg date. | |
| REVENUE_CURR_EXCHG_RATE | ● | Revenue currency exchg rate. | |
| REVENUE_CURR_RATE_TYPE | ● | Type of revenue currency rate. | |
| REVENUE_DISCOUNT_PERCENTAGE | ● | Revenue discount percentage. | |
| REVENUE_LABOR_MULTIPLIER | ● | Revenue labor multiplier. | |
| REVENUE_MARKUP_PERCENTAGE | ● | Revenue markup percentage. | |
| REVERSED_FLAG | ● | Indicator (Y/N) for the reversed. | |
| REVERSED_REV_DISTRIBUTION_ID | ● | Identifier for the reversed rev distribution. | |
| REV_DISCOUNT_REASON_CODE | ● | Code identifying the rev discount reason. | |
| REV_DISTRIBUTION_ID | PK? | ● | Identifier for the rev distribution. |
| REV_INCREMENTAL_PERCENTAGE | ● | Rev incremental percentage. | |
| REV_LABOR_RATE_TYPE_CODE | ● | Code identifying the rev labor rate type. | |
| REV_NL_RATE_TYPE_CODE | ● | Code identifying the rev nl rate type. | |
| REV_RATE_SOURCE_TYPE_CODE | ● | Code identifying the rev rate source type. | |
| TP_REV_RULE_PERCENTAGE | ● | Tp rev rule percentage. | |
| TP_REV_SCH_LINE_PERCENTAGE | ● | Tp rev sch line percentage. | |
| TRANSACTION_DATE | ● | Transaction date. | |
| TRNS_CURR_REVENUE_AMT | ● | Trns currency revenue amount. |
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. In OTBI they combine only through shared dimensions or set operators such as union, inside one application; the owned conformed model joins this table across modules and systems on conformed keys.
- Project Billing - Funding Real Time
- Project Billing - Revenue Real Time
- Projects - Cross Subject Area Analysis - Real Time
Need the extract + dbt staging for PJB_REV_DISTRIBUTIONS?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table