PON_BID_HEADERS

ProcurementUsed in 2 subject areas26 reporting columns

Sourcing / Negotiations (PON) — header table — one row per transaction or event (with detail in the paired _LINES table).

Likely primary key: BID_HEADER_ID (inferred from Oracle naming conventions — verify against Tables & Views)

Columns

Column	Key	In reports	Description (inferred)
AWARD_STATUS		●	Status of the award.
BID_CURRENCY_CODE		●	Currency code for the bid.
BID_HEADER_ID	PK?	○	Identifier for the bid header.
BID_NUMBER		●	Bid number.
BID_STATUS		●	Status of the bid.
CANCELLED_DATE		●	Cancelled date.
CANCEL_REASON		●	Cancel reason.
CREATED_BY		●	User who created the row.
DRAFT_LOCKED		●	Draft locked.
DRAFT_LOCKED_DATE		●	Draft locked date.
DRAFT_UNLOCKED_DATE		●	Draft unlocked date.
INTERNAL_NOTE		●	Internal note.
NOTE_TO_AUCTION_OWNER		●	Note to auction owner.
NOTE_TO_SUPPLIER		●	Note to supplier.
NUMBER_PRICE_DECIMALS		●	Number price decimals.
ORIGINAL_BID_NUMBER		●	Original bid number.
PARTIAL_RESPONSE_FLAG		●	Indicator (Y/N) for the partial response.
PUBLISH_DATE		●	Publish date.
RATE		●	Rate.
SHORTLIST_FLAG		●	Indicator (Y/N) for the shortlist.
SURROG_BID_FLAG		●	Indicator (Y/N) for the surrog bid.
SURROG_BID_ONLINE_ENTRY_DATE		●	Surrog bid online entry date.
SURROG_BID_RECEIPT_DATE		●	Surrog bid receipt date.
SURROG_METHOD_OF_RESPONSE		●	Surrog method of response.
TECHNICAL_SHORTLIST_FLAG		●	Indicator (Y/N) for the technical shortlist.
TRADING_PARTNER_ID		●	Identifier for the trading partner.
TYPE_OF_RESPONSE		●	Type of response.

No cataloged report reads from this table yet — it's part of the broader Fusion dictionary.

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 PON_BID_HEADERS?

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