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