Oracle Fusion · Data dictionary
PJB_INVOICE_HEADERS
ProjectsUsed in 1 subject areas35 reporting columns
Projects Billing (PJB) — header table — one row per transaction or event (with detail in the paired _LINES table).
Likely primary key: INVOICE_HEADER_ID (inferred from Oracle naming conventions — verify against Tables & Views)
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACCTD_EXCHG_RATE | ● | Acctd exchg rate. | |
| ACCTD_RATE_DATE | ● | Acctd rate date. | |
| ACCTD_RATE_TYPE | ● | Type of acctd rate. | |
| APPROVED_DATE | ● | Approved date. | |
| BILLING_TYPE_CODE | ● | Code identifying the billing type. | |
| BILL_FROM_DATE | ● | Bill from date. | |
| BILL_SET_NUM | ● | Bill set number. | |
| BILL_TO_DATE | ● | Bill to date. | |
| CANCELLED_FLAG | ● | Indicator (Y/N) for the cancelled. | |
| CONVERTED_FLAG | ● | Indicator (Y/N) for the converted. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| EXCEPTION_FLAG | ● | Indicator (Y/N) for the exception. | |
| EXPORT_PROCESS_ID | ● | Identifier for the export process. | |
| GENERATION_ERROR_FLAG | ● | Indicator (Y/N) for the generation error. | |
| INVOICE_COMMENT | ● | Invoice comment. | |
| INVOICE_DATE | ● | Invoice date. | |
| INVOICE_HEADER_ID | PK? | ○ | Identifier for the invoice header. |
| INVOICE_INSTRUCTIONS | ● | Invoice instructions. | |
| INVOICE_NUM | ● | Invoice number. | |
| INVOICE_STATUS_CODE | ● | Code identifying the invoice status. | |
| INVOICE_TYPE_CODE | ● | Code identifying the invoice type. | |
| IN_AP_TRANSFER_STATUS_CODE | ● | Code identifying the in payables transfer status. | |
| LANG | ● | Lang. | |
| 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. | |
| MAJOR_VERSION | ● | Major version. | |
| PA_DATE | ● | Pa date. | |
| PA_PERIOD_NAME | ● | Name of the pa period. | |
| PURGE_FLAG | ● | Indicator (Y/N) for the purge. | |
| RA_INVOICE_NUMBER | ● | Ra invoice number. | |
| RELEASED_DATE | ● | Released date. | |
| SYSTEM_REFERENCE | ● | System reference. | |
| TAXATION_COUNTRY | ● | Taxation country. | |
| TRANSFERRED_DATE | ● | Transferred date. |
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_INVOICE_HEADERS?
We ship parameterized SQL, BICC config, and dbt models you own.