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