InventoryCompletedTransactionsserialsserialStandardDFFs
Stores standard descriptive flexfields for serials, offering a consistent structure for tracking and reporting.
Columns
Name | Type | Description |
InventoryCompletedTransactionsTransactionId [KEY] | Long | A system-generated unique identifier linking this completed inventory transaction to a specific serialized item with standard attributes tracked 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 standard DFF context name defining the category of additional attributes stored for serialized inventory. This context name allows businesses to extend inventory tracking based on standardized system attributes. |
_FLEX_Context_DisplayValue | String | A user-friendly display value for the standard 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 standard attribute tracking via DFFs. This reference enables efficient searching, reporting, and system queries for serialized inventory management. |