Excel Add-In for Oracle Fusion Cloud SCM

Build 24.0.9175

InventoryCompletedTransactionslotslotSerialsserialStandardDFFs

Manages standard descriptive flexfields for serials to support customization and reporting needs for serial-controlled items.

Columns

Name Type Description
InventoryCompletedTransactionsTransactionId [KEY] Long The system-generated unique identifier linking this completed inventory transaction to a specific lot and serial-controlled item with standard descriptive flexfields (DFFs). This identifier ensures traceability of serialized 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.
LotserialsSerialNumber [KEY] String The serial number associated with the lot-controlled inventory item. This serial number enables traceability for serialized inventory, ensuring compliance with warranty tracking, recalls, and lifecycle monitoring.
TransactionId [KEY] Long The unique identifier for the completed inventory transaction. This identifier ensures traceability of serialized inventory movements and financial reconciliation with audit compliance.
SerialNumber [KEY] String The unique serial number assigned to an individual inventory item in this transaction. This serial number ensures complete traceability of serialized inventory, supporting asset tracking, regulatory compliance, and system integration.
_FLEX_Context String A standard DFF context name defining the category of additional attributes stored for serialized and lot-controlled inventory. This context name allows businesses to extend inventory tracking with standard attributes based on operational requirements.
_FLEX_Context_DisplayValue String A user-friendly display value for the standard DFF context, providing an intuitive representation of serialized and lot attributes for enhanced usability and reporting.
BindInventoryItemId Long The unique identifier for the inventory item associated with the serialized inventory transaction. This identifierensures accurate linkage between inventory master records and serial-tracked inventory movements.
BindItem String The item number associated with the serialized inventory transaction. This value establishes traceability between the inventory master record and standard attribute tracking via descriptive DFFs.
BindOrganization String The name of the organization responsible for managing the serialized inventory in this transaction. This field ensures accurate inventory ownership tracking and supports financial reconciliation across multiple business units.
BindOrganizationId Long The unique identifier for the organization linked to the serialized 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 serialized inventory transaction. This identifier enables project-based tracking of serialized items, supporting cost allocation and audit compliance in project-driven inventory management.
BindPJCProjectNumber String The project number associated with the serialized inventory transaction. This 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 serialized inventory transaction. This identifierensures that serialized 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 serialized inventory usage. This task number ensures that serialized items are properly assigned to project-specific activities and cost centers.
BindTransactionDate Datetime The date and time when the serialized inventory transaction occurred. This information supports chronological tracking of serial-tracked inventory movements and financial reconciliation with system records.
BindTransactionId Long The unique identifier for the inventory transaction linked to this serial 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 serial and lot-based inventory transactions with standard DFFs. This reference enables efficient searching, reporting, and system queries for serialized inventory tracking.

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