CData Python Connector for Oracle Fusion Cloud SCM

Build 24.0.9175

InventoryItemLotslotAttributeDFF

Customizes lot attributes using descriptive flexfields to enhance traceability and reporting.

Columns

Name Type Description
InventoryItemLotsInventoryItemId [KEY] Long The unique identifier for the inventory item associated with the lot in the InventoryItemLots record. This identifer ensures traceability of lot-controlled inventory items.
InventoryItemLotsLotNumber [KEY] String The unique lot number assigned to the inventory item within the InventoryItemLots record. This number ensures tracking of lot-controlled inventory for compliance and quality control.
InventoryItemLotsOrganizationId [KEY] Long The unique identifier for the organization managing the inventory lot within the InventoryItemLots record. This identifer supports accurate stock tracking across multiple organizations.
InventoryItemId [KEY] Long The unique identifier for the inventory item associated with the lot attribute. This identifer ensures accurate linkage between item-level inventory and lot-specific attributes.
OrganizationId [KEY] Long The unique identifier for the organization managing the inventory lot. This identifer ensures accurate tracking of stock ownership and operational reporting.
LotNumber [KEY] String The unique identifier for the inventory lot. This identifer supports traceability, inventory rotation, and quality assurance of lot-controlled items.
_FLEX_Context String A descriptive flexfield (DFF) context name that defines the attribute structure for lot attributes. This context name ensures flexibility in tracking additional inventory details.
_FLEX_Context_DisplayValue String A display value representing the context-specific attributes for the lot. This value ensures user-friendly identification of additional lot details.
BindInventoryItemId Long The identifier linking the inventory item to system bindings for integration purposes. This identifer ensures accurate data mapping for lot attributes in transactions.
BindItemNumber String The item number used in system bindings to ensure consistency in tracking inventory attributes across integrated platforms.
BindLotNumber String The lot number used in system bindings to ensure accurate tracking of lot attributes in integrated systems.
BindOrganizationCode String The organization code used in system bindings to ensure accurate tracking of lot attributes across organizations.
Finder String The lookup reference used to retrieve and manage inventory lot attribute records. This reference enables efficient searching, reporting, and system queries.
Param_CycleCountHeaderId Long The unique identifier for the cycle count header associated with the lot. This identifer ensures accurate reconciliation of inventory during cycle counting.
Param_InventoryItemId Long The unique identifier linking the inventory item to cycle count and transaction processes. This identifer ensures accurate tracking of lot attributes during inventory adjustments.
Param_LocatorId Long The unique identifier for the locator where the lot is stored. This identifer ensures accurate tracking of inventory placement within a warehouse.
Param_OrganizationId Long The unique identifier for the organization conducting the cycle count or inventory transaction involving the lot attributes.
Param_Subinventory String The subinventory where the lot is stored. This subinventory ensures accurate tracking of inventory location within an organization for reporting and transaction processing.
Param_TransactionTypeId Long The unique identifier for the transaction type associated with the lot attribute. This identifer ensures proper classification of inventory transactions.

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