Fusion Reference
Inventory
Supply chainInventory org parameters, subinventories and locators, on-hand balances at detail and summary grain, the material transaction ledger, lots, serials, reservations, movement requests, and transfer orders
13 tables
docs release 26C · Verified September 2026
Extraction map
The BICC extract data store (PVO) reaching each of this module’s tables — the bulk path out of the SaaS database. Full details, OTBI subject areas, and provenance links live on each table page.
| Table | BICC extract data store (PVO) |
|---|---|
| INV_ITEM_LOCATIONS | FscmTopModelAM.ScmExtractAM.InvBiccExtractAM.InventoryLocatorExtractPVO |
| INV_LOT_NUMBERS | FscmTopModelAM.ScmExtractAM.InvBiccExtractAM.InvLotNumbersExtractPVO |
| INV_MATERIAL_TXNS | FscmTopModelAM.ScmExtractAM.InvBiccExtractAM.InventoryTransactionDetailExtractPVO |
| INV_ONHAND_QUANTITIES_DETAIL | FscmTopModelAM.ScmExtractAM.InvBiccExtractAM.InventoryOnhandExtractPVO |
| INV_RESERVATIONS | FscmTopModelAM.ScmExtractAM.InvBiccExtractAM.InventoryReservationsExtractPVO |
| INV_SECONDARY_INVENTORIES | FscmTopModelAM.ScmExtractAM.InvBiccExtractAM.InventorySubinventoryExtractPVO |
| INV_SERIAL_NUMBERS | FscmTopModelAM.ScmExtractAM.InvBiccExtractAM.InvSerialNumbersExtractPVO |
| INV_TRANSACTION_TYPES_B | FscmTopModelAM.ScmExtractAM.InvBiccExtractAM.InvTxnTypeExtractPVO |
| INV_TRANSACTION_TYPES_B | FscmTopModelAM.ScmExtractAM.InvBiccExtractAM.InvTxnTypeTLExtractPVO |
| INV_TRANSFER_ORDER_HEADERS | FscmTopModelAM.ScmExtractAM.InvBiccExtractAM.TransferOrderHeaderExtractPVO |
| INV_TRANSFER_ORDER_LINES | FscmTopModelAM.ScmExtractAM.InvBiccExtractAM.TransferOrderLineExtractPVO |
| INV_TXN_REQUEST_HEADERS | FscmTopModelAM.ScmExtractAM.InvBiccExtractAM.MovementRequestHeaderExtractPVO |
| INV_TXN_REQUEST_LINES | FscmTopModelAM.ScmExtractAM.InvBiccExtractAM.MovementRequestLineExtractPVO |
Tables
Master · 4
- INV_ITEM_LOCATIONSThe stock locator master — the physical bin/row/rack positions inside a subinventory, with the human-readable locator name, capacity limits, and pick sequencingProduct: INVmaster
- INV_LOT_NUMBERSThe lot master — definition, genealogy (parent lot), grade, and the origination/expiration/retest dates for every lot, keyed by item + organization + lot numberProduct: INVmaster
- INV_SECONDARY_INVENTORIESThe subinventory master — each row a named section of stock within an organization (stores, staging, receiving, rejects) with its asset/expense nature, tracking and reservability controls, and replenishment sourceProduct: INVmaster
- INV_SERIAL_NUMBERSThe serial number master — definition and current position (status, org, subinventory, locator, lot) of every serialized unit, with manufacturing and shipping lifecycle datesProduct: INVmaster
Transaction · 8
- INV_MATERIAL_TXNSThe material transaction ledger — one row per inventory movement or cost update, classified by transaction type, action, and source type, with quantity, date, and the document reference that caused it; the reconciliation backbone for every stock questionProduct: INVtransaction
- INV_ONHAND_QUANTITIES_DETAILThe on-hand balance detail — receipt-level slices of stock per item, org, subinventory, locator, and lot, consumed in FIFO order as material issuesProduct: INVtransaction
- INV_ONHAND_QUANTITIES_SUMMARYPre-aggregated on-hand at the item + location grain, maintained automatically in step with the detail table — the ready-made balance EBS never hadProduct: INVtransaction
- INV_RESERVATIONSFirm reservations tying a demand source (a sales order line, most commonly) to a supply source (on-hand or expected supply) for an item in an org, optionally pinned down to subinventory, locator, and lotProduct: INVtransaction
- INV_TRANSFER_ORDER_HEADERSTransfer order headers — the orchestration document for internal material moves within or between organizations, carrying the order number, originating process, and requisitioning business unitProduct: INVtransaction
- INV_TRANSFER_ORDER_LINESTransfer order lines — the actionable grain carrying item, source and destination organizations, the requested/shipped/received/delivered quantity lifecycle, dates, and the transfer priceProduct: INVtransaction
- INV_TXN_REQUEST_HEADERSMovement request (move order) headers — the user-visible request number, type, status, and required date for requests to move material within an organizationProduct: INVtransaction
- INV_TXN_REQUEST_LINESMovement request lines — each row requests moving a quantity of an item from a source to a destination subinventory (or account), individually statused, allocated (quantity detailed), and deliveredProduct: INVtransaction