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. |