ADO.NET Provider for Oracle Fusion Cloud SCM

Build 24.0.9175

SalesOrdersForOrderHublinestransactionItemAttributes

Tracks transaction-specific attributes for items on each order line, supporting custom requirements.

Columns

Name Type Description
SalesOrdersForOrderHubHeaderId [KEY] Long Unique identifier for the sales order header, linking the transaction item attributes to the overall order. This ensures proper tracking and association of item attributes at the order level.
LinesFulfillLineId [KEY] Long Identifier for the fulfillment line associated with the transaction item attribute, enabling tracking of attributes at the line level within the order.
CharacterAttributeValue String Character-based value for the transaction item attribute (TIA), used to store non-numeric data such as descriptions or identifiers specific to the item on the order line.
DateAttributeValue Date Date-based value for the TIA, used for attributes that store specific date-related information, such as expiry dates or delivery schedules.
NumberAttributeValue Decimal Numeric value for the TIA, used to store quantitative information such as quantity or price relevant to the item on the order line.
SourceTransactionLineAttributeId String Unique identifier for the transaction item attribute on the fulfillment line, assigned by the source application, linking the attribute to its original data source.
TimestampAttributeValue Datetime Timestamp-based value for the TIA, used to capture precise date and time values for time-sensitive data associated with the item on the order line.
TransactionAttributeId [KEY] Long Unique identifier for the transaction item attribute, linking it to the overall sales order and helping manage item-level attributes during processing.
TransactionAttributeName String Name of the transaction item attribute, providing a descriptive label to identify the attribute and its purpose within the order processing system.
TransactionAttributeMetadataid Long Unique identifier for the TIA metadata, which stores the structure and properties of the attribute for reference within the system.
TransactionItemAttributeId Long Unique identifier for the TIA, enabling linkage of specific attributes to individual items on the sales order.
Finder String Method or tool used to locate transaction item attribute records in the system, allowing efficient retrieval of attributes associated with the sales order and fulfillment line.
FromDate Date Start date when the transaction item attribute becomes valid, ensuring the attribute is applied correctly during the specified time period.
HeaderId Long Unique identifier for the header of the transaction item attribute record, linking the attribute to the overall order in the system.
OrderKey String Unique key for referencing the sales order associated with the transaction item attribute, ensuring that all related item attributes are tracked under the correct order.
OrderNumber String Unique order number assigned to the sales order, used to reference the order in reports, invoicing, and fulfillment.
SourceTransactionNumber String Transaction number from the source system, linking the transaction item attribute to its originating transaction, ensuring consistency when integrating with external systems.
SourceTransactionSystem String Source system name from which the transaction item attribute data originated, providing context for integration with external systems and ensuring consistency across platforms.
ToDate Date End date when the transaction item attribute is no longer valid, marking the expiration of the attribute in the system. This ensures that attributes are applied correctly within a defined timeframe.

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