CData Python Connector for Oracle Fusion Cloud SCM

Build 24.0.9175

InventoryCompletedTransactionsserialsserialAttributeDFFs

Customizes serial details using descriptive flexfields for serial-controlled items.

Columns

Name Type Description
InventoryCompletedTransactionsTransactionId [KEY] Long A system-generated unique identifier linking this completed inventory transaction to a specific serialized item with extended attributes via descriptive flexfields (DFFs). This identifier ensures traceability and enhanced attribute tracking for serialized inventory.
SerialsSerialNumber [KEY] String The serial number assigned to the serialized inventory item in this transaction. This serial number enables precise tracking of individual units for warranty validation, recall management, and compliance with serial tracking policies.
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 of the inventory item in this transaction. This serial number ensures traceability for serialized inventory, supporting asset tracking, regulatory compliance, and system integration.
_FLEX_Context String The DFF context name defining the category of additional attributes stored for serialized inventory. This context name allows businesses to extend inventory tracking based on operational requirements.
_FLEX_Context_DisplayValue String Auser-friendly display value for the DFF context, providing an intuitive representation of serial attributes for enhanced usability and reporting.
BindInventoryItemId Long The unique identifier for the inventory item associated with the serialized inventory transaction. This identifier ensures accurate linkage between inventory master records and serialized inventory tracking.
BindItem String The item number associated with the serialized inventory transaction. This value establishes traceability between the inventory master record and serial-tracked inventory movements.
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 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 serialized inventory transaction. This identifier ensures 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-based inventory transactions with extended attribute tracking. This reference enables efficient searching, reporting, and system queries for serialized inventory management.

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