Excel Add-In for Oracle Fusion Cloud SCM

Build 24.0.9175

InventoryOnhandBalanceslotslotSerialslotSerialAttributeDFFs

Customizes attributes of lot-serial items using descriptive flexfields for granular control.

Columns

Name Type Description
InventoryOnhandBalancesInventoryItemId [KEY] Long The unique identifier for the inventory item within the on-hand balances record. This identifier ensures accurate tracking of stock levels at an item level.
InventoryOnhandBalancesLocatorId [KEY] Long The unique identifier for the locator where the inventory item is stored. This identifier supports precise stock placement tracking within warehouses.
InventoryOnhandBalancesOrganizationId [KEY] Long The unique identifier for the organization managing the inventory. This identifier helps differentiate inventory ownership across multiple business units.
InventoryOnhandBalancesOwningPartySiteId [KEY] Long The unique identifier for the site associated with the owning party of the inventory item. This identifier supports consignment and third-party inventory tracking.
InventoryOnhandBalancesRevision [KEY] String The revision number of the inventory item, indicating version control for items that undergo design or specification changes.
InventoryOnhandBalancesSubinventoryCode [KEY] String An abbreviation representing the subinventory where the inventory item is stored. This abbreviation ensures accurate stock location tracking within the organization.
InventoryOnhandBalancesSubinventoryGroup [KEY] String The classification group for the subinventory storing the inventory item. This classification group enables better categorization of stock locations for operational purposes.
InventoryOnhandBalancesSummaryLevel [KEY] String Indicates whether the inventory on-hand balance is summarized at a specific level, such as 'Organization', 'Subinventory', or 'Project'.
LotsLotNumber [KEY] String The unique lot number assigned to a batch of inventory items. This lot number ensures traceability for quality control, expiration tracking, and compliance.
LotsOwningPartySiteId [KEY] Long The unique identifier for the site associated with the owning party of the lot-controlled inventory item. This identifier supports consignment and supplier-managed stock tracking.
LotserialsCountryOfOriginCode [KEY] String An abbreviation representing the country of origin for the serial-tracked inventory item. This abbreviation ensures compliance with trade regulations and import/export documentation.
LotserialsInventoryProjectId [KEY] Long The unique identifier for the project associated with the serialized inventory lot. This identifier supports traceability of stock allocated to project-based transactions.
LotserialsInventoryTaskId [KEY] Long The unique identifier for the task associated with the serialized inventory lot. This identifier supports tracking of inventory movement within specific project tasks.
LotserialsOwningPartySiteId [KEY] Long The unique identifier for the site associated with the owning party of the serialized inventory lot. This identifier supports vendor-managed inventory and consignment tracking.
LotserialsSerialNumber [KEY] String The unique serial number assigned to an inventory item for tracking purposes. This serial number ensures serialized inventory management, traceability, and compliance.
InventoryItemId [KEY] Long The unique identifier for the inventory item. This identifier ensures accurate tracking of stock availability and movement across locations.
SerialNumber [KEY] String The unique serial number assigned to an inventory item for identification and tracking throughout its lifecycle.
CurrentOrganizationId [KEY] Long The unique identifier for the organization currently managing the serialized inventory. This identifier supports tracking of stock transfers across organizations.
_FLEX_Context String A descriptive flexfield (DFF) context name for serial number attributes. This context name allows for additional custom attributes specific to business needs.
_FLEX_Context_DisplayValue String A display value for the DFF context of serial number attributes. This value provides a user-friendly label for serial-specific tracking.
Finder String The lookup reference used to retrieve and manage serialized inventory lot tracking records. This reference enables efficient searching, reporting, and system queries.
LocatorId Long The unique identifier for the specific storage locator within the warehouse. This identifier ensures precision in inventory placement tracking.
OrganizationId Long The unique identifier for the organization managing the inventory. This identifier helps differentiate inventory ownership across different entities.
OwningPartySiteId Long The unique identifier for the site associated with the owning party of the inventory lot. This identifier supports vendor-managed inventory and consignment tracking.
Revision String The revision number of the inventory item. This revision number provides visibility into changes in product design or specification over time.
SubinventoryCode String An abbreviation representing the subinventory where the inventory item is stored. This abbreviation ensures accurate tracking of stock location within warehouses.
SubinventoryGroup String The classification group for the subinventory. This classification group supports logical grouping of inventory locations for better organization management.
SummaryLevel String Indicates whether the inventory on-hand balance is maintained at a summarized level, such as organization-wide, project-specific, or detailed at the subinventory level.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175