Analytics Catalog/Data dictionary/PJB_REV_DISTRIBUTIONS
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
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

ColumnKeyIn reportsDescription (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_IDPK?●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. You can't join across them in OTBI, the owned conformed model joins them on shared keys.

Need the extract + dbt staging for PJB_REV_DISTRIBUTIONS?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us
Problems that run through this table
What the extract does not carry · The export ceiling · The extraction pattern