CData Python Connector for Oracle Fusion Cloud SCM

Build 25.0.9454

ActiveSubinventories

Handles subinventories within the warehouse to facilitate item fulfillment and align with transaction type needs.

Columns

Name Type Description
SubinventoryId Long The unique identifier for the subinventory, representing a specific storage location within a warehouse used for managing inventory segmentation and tracking.
SecondaryInventoryName [KEY] String The unique name assigned to the subinventory, distinguishing it from other subinventories within the same organization for inventory management and reporting purposes.
OrganizationId [KEY] Long The unique identifier for the organization that owns or manages the subinventory, ensuring accurate assignment of inventory to the correct business entity.
OrganizationCode String A shortened alphanumeric code used to identify the organization associated with the subinventory in reports, transactions, and system workflows.
OrganizationName String The full name of the organization that manages the subinventory, providing clear ownership details for operational and audit purposes.
Description String A text description providing additional details about the subinventory, such as its function, storage restrictions, or specific inventory handling requirements.
DisableDate Date The date on which the subinventory is set to become inactive, preventing further transactions from being processed against it.
InventoryATPCode Int The unique code representing the Available-to-Promise (ATP) status of the subinventory, indicating whether inventory in this location can be allocated to customer orders.
IncludeInATP String A flag that indicates whether the subinventory is included in Available-to-Promise (ATP) calculations, determining if inventory from this location can be promised to sales or production orders.
NettableCode Int The unique code indicating whether the inventory in this subinventory is considered nettable, meaning it can be included in planning calculations such as Material Requirements Planning (MRP).
Nettable String A status indicator specifying whether the inventory in this subinventory is available for netting in supply and demand planning processes.
ReservableType Int The unique code defining the reservable type of the subinventory, specifying whether inventory in this location can be reserved for specific orders or transactions.
AllowReservations String A flag indicating whether reservations are allowed for inventory in this subinventory, which impacts allocation control and order fulfillment processes.
LocatorTypeCode String A unique code representing the type of locator system used within the subinventory, defining storage organization methods such as bin or bulk storage.
LocatorType String The classification of the locator system used in the subinventory, specifying how inventory is structured within the warehouse for efficient retrieval and storage.
PickingOrder Int The numerical sequence that determines the priority in which inventory is picked from this subinventory during order fulfillment, impacting warehouse efficiency.
QuantityTrackedCode Int The unique code indicating whether inventory quantities in this subinventory are tracked at a detailed level, affecting stock visibility and audit accuracy.
QuantityTracked String A status indicator specifying whether quantity tracking is enabled for inventory in this subinventory, ensuring accurate stock monitoring.
AssetInventoryCode Int The unique code indicating whether the inventory in this subinventory is considered an asset, meaning it is capitalized and accounted for in financial statements.
AssetInventory String A flag that determines whether inventory in this subinventory is classified as an asset, affecting accounting treatment and financial reporting.
SourceTypeCode String A unique code representing the source type of the subinventory, indicating whether inventory is internally manufactured, externally procured, or transferred from another location.
SourceType String The classification of the inventory source type for this subinventory, defining its origin in supply chain processes such as internal production or external procurement.
SourceSubinventory String The name of the subinventory from which inventory is sourced, used when managing inter-subinventory transfers or warehouse replenishment strategies.
SourceOrganizationId Long The unique identifier for the source organization responsible for supplying inventory to this subinventory, ensuring traceability in supply chain transactions.
SourceOrganizationCode String The unique code identifying the source organization from which inventory is received, aiding in supply chain tracking and reporting.
SourceOrganizationName String The full name of the source organization supplying inventory to this subinventory, providing clarity in inter-organization inventory movements.
PreprocessingLeadTime Int The number of days required for preprocessing activities before inventory is available in this subinventory, such as quality checks or inspections.
ProcessingLeadTime Int The number of days required to process inventory within this subinventory, including handling, staging, and preparation for further distribution.
PostprocessingLeadTime Int The number of days required for postprocessing activities after inventory is moved into this subinventory, such as final checks or system updates.
LocationId Long The unique identifier for the physical location associated with this subinventory, linking it to a specific warehouse or distribution center.
LocationName String The name of the physical location where this subinventory is housed, used for operational reference and logistics planning.
DepreciableCode Int The unique code indicating whether inventory in this subinventory is subject to depreciation, typically relevant for capital assets.
Depreciable String A status indicator specifying whether inventory stored in this subinventory is considered depreciable, affecting financial accounting and asset management.
StatusId Long The unique identifier representing the current status of the subinventory, linking to predefined values such as 'Active' or 'Inactive' for operational control.
StatusCode String The unique code representing the current status of the subinventory, such as 'Active', 'Inactive', or 'Restricted', used to control inventory transactions and warehouse operations.
SubinventoryTypeCode String The unique code identifying the type of subinventory, used for classification in system workflows and reporting.
SubinventoryType String The unique classification of the subinventory type, specifying its purpose within the warehouse, such as raw materials, finished goods, or quarantined inventory.
BindItem String The unique name or identifier of the inventory item that is bound to this subinventory, used for tracking and ensuring proper storage allocation.
BindItemId Long The unique identifier for the inventory item assigned to this subinventory, ensuring accurate tracking of bound inventory items.
BindOrgId Long The unique identifier for the organization that is associated with the bound inventory subinventory, ensuring accurate linkage between inventory and its owning entity.
BindSubinventory String The unique name of the subinventory linked to this subinventory, used to manage stock relationships and inventory movement constraints.
BindTransactionActionId String The unique identifier representing the specific transaction action bound to this subinventory, such as issue, receipt, or transfer.
BindTransactionSourceTypeId Long The unique identifier for the transaction source type associated with this subinventory, defining the origin of inventory movements.
BindTransactionTypeId Long The unique identifier for the transaction type that applies to inventory movements in this subinventory, used to control inventory processing rules and workflows.
Finder String The unique searchable reference used to quickly locate specific subinventories within the inventory management system, improving navigation and operational efficiency.

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