Oracle Fusion · Data dictionary
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 | Key | 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.
- Project Billing - Funding Real Time
- Project Billing - Invoices Real Time
- Projects - Cross Subject Area Analysis - Real Time
Need the extract + dbt staging for PJB_INV_LINE_DISTS?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table