CData Python Connector for Oracle Fusion Cloud SCM

Build 24.0.9175

InventoryOnhandBalancesinventoryTrackingAttributes

Tracks primary on-hand quantities and other inventory details using tracking attributes for specific inventory projects and tasks.

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 classifcation 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'.
InventoryProjectId [KEY] Long The unique identifier for the project associated with the inventory on-hand balance. This identifier ensures traceability of stock allocated to project-based transactions.
InventoryTaskId [KEY] Long The unique identifier for the task associated with the inventory on-hand balance. This identifier supports tracking of inventory usage within specific project tasks.
CountryOfOriginCode [KEY] String An abbreviation representing the country of origin for the inventory item. This abbreviation ensures compliance with trade regulations and import/export documentation.
PrimaryQuantity Decimal The available quantity of the inventory item in the primary unit of measure (UOM). This quantity reflects stock availability for order fulfillment and replenishment.
ConsignedQuantity Decimal The quantity of inventory held under consignment. This quantity represents stock owned by a supplier but stored at the organization’s location, ensuring visibility into vendor-managed inventory.
InventoryProject String The project name associated with the inventory on-hand balance. This project name supports clear project-based inventory tracking.
InventoryTask String The task name associated with the inventory on-hand balance. This task name helps track inventory movement at a task-specific level within a project.
CountryOfOrigin String The full name of the country of origin for the inventory item. This name ensures proper identification for regulatory compliance and supplier tracking.
Finder String The lookup reference used to retrieve and manage inventory on-hand balance tracking attribute records. This reference enables efficient searching, reporting, and system queries.
InventoryItemId Long The unique identifier for the inventory item. This identifier ensures accurate tracking of stock availability and movement across locations.
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 item. 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