ADO.NET Provider for Oracle Fusion Cloud SCM

Build 24.0.9175

ActiveLocators

Manages warehouse inventory locators used to store and fulfill items based on transaction type requirements.

Columns

Name Type Description
InventoryLocationId [KEY] Long The unique identifier for the inventory location, used to distinguish specific storage areas within a warehouse or facility. This identifier is crucial for tracking stock movement, warehouse organization, and transaction accuracy.
Locator String A detailed alphanumeric code representing the exact storage location of inventory items within a warehouse, including aisle, rack, and bin numbers. This code ensures precise stock placement and efficient retrieval during picking operations.
OrganizationId Long The unique identifier for the organization that owns or manages the inventory location. This identifier allows inventory records to be correctly assigned to the corresponding business unit, ensuring accountability and accurate reporting.
OrganizationName String The full name of the organization associated with the inventory location, providing clarity on ownership and operational control. This name helps distinguish different entities managing warehouse operations within a multi-organization setup.
OrganizationCode String A shortened alphanumeric code used to identify the organization in reports, transactions, and internal systems. This code is useful for quick reference and avoids the need to use long organization names in system workflows.
SubinventoryId Long The unique identifier for the subinventory, a logical or physical subdivision within a warehouse that helps segregate stock for better organization, faster processing, and inventory visibility.
SubinventoryCode String An alphanumeric code assigned to a subinventory, enabling easy identification and tracking of inventory across multiple storage areas. This code is used in transactions and reporting to streamline warehouse operations.
Description String A text description providing additional details about the inventory location, such as its intended use, temperature control requirements, access restrictions, or hazardous material handling guidelines.
DisableDate Date The date on which the inventory location is set to become inactive or unavailable for use. After this date, transactions involving this location are restricted to prevent errors in inventory tracking.
InventoryLocationType String A classification defining the function of the inventory location, such as a storage area, picking zone, staging area, or returns section. This categorization helps warehouse staff manage inventory placement and retrieval efficiently.
LocatorType String A specification indicating the type of locator used in the warehouse, which can correspond to different storage methodologies, such as bulk storage, bin storage, or temperature-controlled storage.
PickingOrder Double A numerical value that determines the priority sequence in which inventory is picked for order fulfillment. A lower value indicates higher priority, optimizing picking efficiency in high-volume operations.
StatusId Long The unique identifier representing the current operational status of the inventory location. This identifier links to predefined status values that define whether the location is 'Active', 'Inactive', or 'Restricted'.
StatusCode String A code that indicates the current operational status of the inventory location, such as 'Active,' 'Inactive,' or 'Restricted.' This code helps ensure accurate warehouse transactions and prevent inventory misallocations.
BindItem String The name or identifier of an inventory item that is permanently associated with this locator. This identifier is used when a specific storage location is dedicated to a particular item due to storage constraints or regulatory compliance.
BindItemId Long The unique identifier for the inventory item that is bound to this locator. This identifier ensures accurate tracking of designated stock that must remain in a fixed location.
BindLocatorId Long The unique identifier for another inventory locator that is linked to this one. This identifier is often used to establish relationships between primary and secondary storage locations.
BindOrgId Long The unique identifier for the organization associated with the bound inventory location. This identifier ensures that inventory locations are correctly mapped to their respective business entities, preventing cross-organization discrepancies.
BindSubinventory String A code representing the subinventory linked to this inventory locator. This code is used to maintain inventory separation and prevent unauthorized stock movements.
BindTransactionTypeId Long The unique identifier for the transaction type that applies to inventory movements for this locator. This identifier helps define specific warehouse processing rules, such as allowed transfer types or replenishment policies.
Finder String A searchable reference used to quickly locate specific inventory locations within the warehouse management system. This reference enables faster navigation and improved efficiency in locating stock.
Param_CycleCountHeaderId Long The unique identifier for the cycle count session associated with this inventory location. This identifier is used in periodic inventory audits to ensure stock accuracy and compliance with inventory control policies.
Param_Subinventory String A code representing the subinventory used in parameterized searches or inventory transactions. This code ensures that operations are executed within the correct warehouse sublocation, preventing misplacement of stock.

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