PJC_COMMITMENT_TXNS

ProjectsUsed in 2 subject areas32 reporting columns

Projects Costing (PJC).

Primary key: not yet catalogued for PJC_COMMITMENT_TXNS — reference Oracle Tables & Views guide.

Columns

Column	In reports	Description (inferred)
AMOUNT_CANCELLED	●	Amount cancelled.
AMOUNT_DELIVERED	●	Amount delivered.
AMOUNT_INVOICED	●	Amount invoiced.
AMOUNT_ORDERED	●	Amount ordered.
AMOUNT_OUTSTANDING_DELIVERY	●	Amount outstanding delivery.
AMOUNT_OUTSTANDING_INVOICE	●	Amount outstanding invoice.
AMOUNT_OVERBILLED	●	Amount overbilled.
BILLABLE_FLAG	●	Indicator (Y/N) for the billable.
CAPITALIZABLE_FLAG	●	Indicator (Y/N) for the capitalizable.
CMT_CREATION_DATE	●	Cmt creation date.
CMT_DIST_NUM	●	Cmt distribution number.
CMT_LINE_NUMBER	●	Cmt line number.
CMT_NUMBER	●	Cmt number.
COMMITMENT_TYPE	●	Type of commitment.
CREATED_BY	●	User who created the row.
CREATION_DATE	●	Date and time the row was created.
DESCRIPTION	●	Description.
EXPENDITURE_ITEM_DATE	●	Expenditure item date.
LAST_UPDATED_BY	●	User who last updated the row.
LAST_UPDATE_DATE	●	Date and time the row was last updated (the incremental-extract key).
LINE_TYPE	●	Type of line.
ORIGINAL_AMOUNT_ORDERED	●	Original amount ordered.
ORIGINAL_QUANTITY_ORDERED	●	Original quantity ordered.
ORIGINAL_TXN_REFERENCE	●	Original transaction reference.
QUANTITY_CANCELLED	●	Quantity cancelled.
QUANTITY_DELIVERED	●	Quantity delivered.
QUANTITY_INVOICED	●	Quantity invoiced.
QUANTITY_ORDERED	●	Quantity ordered.
QUANTITY_OUTSTANDING_DELIVERY	●	Quantity outstanding delivery.
QUANTITY_OUTSTANDING_INVOICE	●	Quantity outstanding invoice.
QUANTITY_OVERBILLED	●	Quantity overbilled.
TOT_CMT_QUANTITY	●	Tot cmt quantity.

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

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