Excel Add-In for Oracle Fusion Cloud SCM

Build 24.0.9175

InventoryCompletedTransactionslotslotStandardDFFs

Maintains descriptive flexfields for lot attributes, enhancing data customization for items under lot control.

Columns

Name Type Description
InventoryCompletedTransactionsTransactionId [KEY] Long The system-generated unique identifier linking this completed inventory transaction to a specific lot-controlled item with standard descriptive flexfields (DFFs). This identifier ensures traceability of lot-tracked inventory movements with extended standard attributes.
LotsLotNumber [KEY] String The unique lot number associated with the inventory item in this transaction. This value ensures precise tracking of lot-controlled inventory, supporting compliance with quality control, expiration management, and regulatory traceability.
TransactionId [KEY] Long The unique identifier for the completed inventory transaction. This identifier ensures traceability of lot-tracked inventory movements and financial reconciliation with audit compliance.
LotNumber [KEY] String The lot number assigned to an inventory item in this transaction. This value enables lot-specific tracking of stock movements, supporting expiration monitoring, regulatory compliance, and product recalls.
_FLEX_Context String The standard DFF context name defining the category of additional attributes stored for lot-controlled inventory. This field enables businesses to extend inventory tracking with predefined system attributes.
_FLEX_Context_DisplayValue String A user-friendly display value for the standard DFF context, providing an intuitive representation of lot attributes for enhanced usability and reporting.
BindInventoryItemId Long The unique identifier for the inventory item associated with the lot transaction. This identifierensures accurate linkage between inventory master records and lot-tracked inventory movements.
BindItem String The item number associated with the lot-controlled inventory transaction. This number establishes traceability between the inventory master record and extended attribute tracking via standard DFFs.
BindOrganization String The name of the organization responsible for managing the lot-controlled inventory in this transaction. This name ensures accurate inventory ownership tracking and supports financial reconciliation across multiple business units.
BindOrganizationId Long The unique identifier for the organization linked to the lot-controlled inventory transaction. This identifier ensures financial integrity, ownership assignment, and regulatory compliance in multi-entity inventory management.
BindPJCProjectId String The unique identifier for the project associated with the lot-controlled inventory transaction. This identifier enables project-based tracking of lot-tracked items and supports cost allocation in project-driven inventory management.
BindPJCProjectNumber String The project number associated with the lot-controlled inventory transaction. This project number provides a user-friendly reference for tracking project-related inventory allocations and cost distribution.
BindPJCTaskId String The unique identifier for the project task linked to the lot-controlled inventory transaction. This identifier ensures that lot-tracked items are properly allocated to project-specific tasks for accurate cost tracking and financial reporting.
BindPJCTaskNumber String The task number assigned within the project to track lot-controlled inventory usage. This task number ensures that lot-tracked items are properly assigned to project-specific activities and cost centers.
BindTransactionDate Datetime The date and time when the lot-controlled inventory transaction occurred. This information supports chronological tracking of lot-tracked inventory movements and financial reconciliation with system records.
BindTransactionId Long The unique identifier for the inventory transaction linked to this lot record. This identifier ensures proper reference and traceability in reporting, auditing, and compliance tracking.
Finder String The lookup reference used to retrieve and manage completed lot-based inventory transactions with standard DFFs. This reference enables efficient searching, reporting, and system queries for lot-controlled inventory tracking.

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