INV_MATERIAL_TXNS

InventoryUsed in 2 subject areas25 reporting columns

Inventory (INV).

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

Columns

Column	In reports	Description (inferred)
ACTUAL_COST	●	Actual cost.
CREATED_BY	●	User who created the row.
CREATION_DATE	●	Date and time the row was created.
LAST_UPDATED_BY	●	User who last updated the row.
LAST_UPDATE_DATE	●	Date and time the row was last updated (the incremental-extract key).
LOT_TXN_GROUP_NAME	●	Name of the lot transaction group.
NUMBER_OF_CONTAINERS	●	Number of containers.
ORIG_TRANSACTION_QUANTITY	●	Orig transaction quantity.
PJC_BILLABLE_FLAG	●	Indicator (Y/N) for the pjc billable.
PJC_CAPITALIZABLE_FLAG	●	Indicator (Y/N) for the pjc capitalizable.
PRIMARY_QUANTITY	●	Primary quantity.
REVISION	●	Revision.
SECONDARY_TRANSACTION_QUANTITY	●	Secondary transaction quantity.
SECONDARY_UOM_CODE	●	Code identifying the secondary unit of measure.
SOURCE_CODE	●	Code identifying the source.
SOURCE_LOT_FLAG	●	Indicator (Y/N) for the source lot.
TRANSACTION_ACTION_ID	●	Identifier for the transaction action.
TRANSACTION_DATE	●	Transaction date.
TRANSACTION_ID	●	Identifier for the transaction.
TRANSACTION_MODE	●	Transaction mode.
TRANSACTION_QUANTITY	●	Transaction quantity.
TRANSACTION_REFERENCE	●	Transaction reference.
TRANSACTION_SOURCE_NAME	●	Name of the transaction source.
TRANSACTION_SOURCE_TYPE_ID	●	Identifier for the transaction source type.
TRANSACTION_UOM	●	Transaction unit of measure.

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

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