Oracle Fusion · Data dictionary
PJB_INVOICE_LINES
ProjectsUsed in 1 subject areas10 reporting columns
Projects Billing (PJB), line table, one row per line item under the header.
Primary key: not declared here, see Oracle's Tables and Views page for PJB_INVOICE_LINES
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ASSESSABLE_VALUE | ● | Assessable value. | |
| CREDIT_PROCESSED_FLAG | ● | Indicator (Y/N) for the credit processed. | |
| EXCEPTION_FLAG | ● | Indicator (Y/N) for the exception. | |
| INVOICE_CURR_CREDIT_PCT | ● | Invoice currency credit percent. | |
| INVOICE_LINE_DESC | ● | Description of the invoice line. | |
| INVOICE_LINE_NUM | ● | Invoice line number. | |
| INVOICE_LINE_TYPE | ● | Type of invoice line. | |
| PRODUCT_TYPE | ● | Type of product. | |
| TRANSLATED_TEXT | ● | Translated text. | |
| WRITE_OFF_FLAG | ● | Indicator (Y/N) for the write off. |
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.
Need the extract + dbt staging for PJB_INVOICE_LINES?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table