PJB_INV_LINE_DISTS

ProjectsUsed in 3 subject areas50 reporting columns

Projects Billing (PJB).

Primary key: not yet catalogued for PJB_INV_LINE_DISTS — reference Oracle Tables & Views guide.

Columns

Column	In reports	Description (inferred)
ACCRUED_FLAG	●	Indicator (Y/N) for the accrued.
BILLING_TYPE_CODE	●	Code identifying the billing type.
BILL_EMPLOYEE_BILLING_TITLE	●	Bill employee billing title.
BILL_JOB_BILLING_TITLE	●	Bill job billing title.
BILL_RATE	●	Bill rate.
BILL_TRANSACTION_TYPE_CODE	●	Code identifying the bill transaction type.
CONT_CURR_BILLED_AMT	●	Cont currency billed amount.
CONT_CURR_CONCESSION_AMT	●	Cont currency concession amount.
CONT_CURR_CREDIT_AMT	●	Cont currency credit amount.
CONT_CURR_INV_DATE_TYPE	●	Type of cont currency inventory date.
CONT_CURR_INV_EXCHG_DATE	●	Cont currency inventory exchg date.
CONT_CURR_INV_EXCHG_RATE	●	Cont currency inventory exchg rate.
CONT_CURR_INV_RATE_TYPE	●	Type of cont currency inventory rate.
CREDITED_DIST_ID	●	Identifier for the credited distribution.
IC_TP_AMT_TYPE_CODE	●	Code identifying the ic tp amount type.
IC_TP_BASE_CODE	●	Code identifying the ic tp base.
INVOICED_FLAG	●	Indicator (Y/N) for the invoiced.
INVOICE_AMOUNT_CALC_CODE	●	Code identifying the invoice amount calc.
INVOICE_CURR_BILLED_AMT	●	Invoice currency billed amount.
INVOICE_CURR_CREDIT_AMT	●	Invoice currency credit amount.
INVOICE_CURR_DATE_TYPE	●	Type of invoice currency date.
INVOICE_CURR_EXCHG_DATE	●	Invoice currency exchg date.
INVOICE_CURR_EXCHG_RATE	●	Invoice currency exchg rate.
INVOICE_CURR_RATE_TYPE	●	Type of invoice currency rate.
INVOICE_DISCOUNT_PERCENTAGE	●	Invoice discount percentage.
INVOICE_MARKUP_PERCENTAGE	●	Invoice markup percentage.
INV_CURR_CONCESSION_AMT	●	Inventory currency concession amount.
INV_DISCOUNT_REASON_CODE	●	Code identifying the inventory discount reason.
INV_DISTRIBUTION_TYPE_CODE	●	Code identifying the inventory distribution type.
INV_INCREMENTAL_PERCENTAGE	●	Inventory incremental percentage.
INV_LINE_DIST_NUM	●	Inventory line distribution number.
LEDGER_CURR_BILLED_AMT	●	Ledger currency billed amount.
LEDGER_CURR_INV_DATE_TYPE	●	Type of ledger currency inventory date.
LEDGER_CURR_INV_EXCHG_DATE	●	Ledger currency inventory exchg date.
LEDGER_CURR_INV_EXCHG_RATE	●	Ledger currency inventory exchg rate.
LEDGER_CURR_INV_RATE_TYPE	●	Type of ledger currency inventory rate.
PROJECT_CURR_BILLED_AMT	●	Project currency billed amount.
PROJECT_CURR_INV_EXCHG_DATE	●	Project currency inventory exchg date.
PROJECT_CURR_INV_EXCHG_RATE	●	Project currency inventory exchg rate.
PROJECT_CURR_INV_RATE_TYPE	●	Type of project currency inventory rate.
PROJ_CURR_INV_DATE_TYPE	●	Type of proj currency inventory date.
RATE_SOURCE_CODE	●	Code identifying the rate source.
READY_TO_ACCRUAL_FLAG	●	Indicator (Y/N) for the ready to accrual.
REVENUE_DATE	●	Revenue date.
TP_INV_RULE_PERCENTAGE	●	Tp inventory rule percentage.
TP_INV_SCH_LINE_PERCENTAGE	●	Tp inventory sch line percentage.
TRANSACTION_DATE	●	Transaction date.
TRNS_CURR_BILLED_AMT	●	Trns currency billed amount.
TRNS_CURR_CONCESSION_AMT	●	Trns currency concession amount.
TRNS_CURR_CREDIT_AMT	●	Trns currency credit 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_INV_LINE_DISTS?

We ship parameterized SQL, BICC config, and dbt models you own.

Talk to us