Skip to main content
OracleOps AI
← All tables
Oracle Fusion/Projects/Project Billing

PJB_INVOICE_HEADERS_ALL

Project contract invoice headers — draft and released invoices generated from billing events and rate-based work.

Key Columns

INVOICE_HEADER_IDPROJECT_IDCONTRACT_IDINVOICE_NUMINVOICE_DATEINVOICE_AMOUNTINVOICE_STATUS_CODE

Child Tables

PJB_INVOICE_LINES_ALL

Project invoice lines — amount by contract line / task, transferred to Receivables as AR invoice lines.

Common Joins

PJB_INVOICE_LINES_ALLvia INVOICE_HEADER_ID

The billing lines that sum to the invoice amount.

Used In

Project BillingReceivables

Related

Project billing and contract invoicing

Billable expenditure items and events become billing transactions (PJB_BILL_TRANSACTIONS), which roll into project invoice headers and lines (PJB_INVOICE_HEADERS_ALL / PJB_INVOICE_LINES_ALL) and transfer to Receivables.

Ask Oracle AI about PJB_INVOICE_HEADERS_ALL