SalesOrdersForOrderHublinesassetTransactionDetails
Captures asset transaction data to support license migrations; currently not actively used in operations.
Columns
| Name | Type | Description |
| SalesOrdersForOrderHubHeaderId [KEY] | Long | Unique identifier for the order header, linking the asset transaction details to the parent sales order and enabling cross-referencing of order-related information. |
| LinesFulfillLineId [KEY] | Long | Identifier for the fulfillment line associated with the asset transaction details, helping to track the specific order line involved in the transaction. |
| AssetTransactionDetailId [KEY] | Long | Unique value identifying the asset transaction detail for a specific order line, enabling precise tracking of each asset's transaction. |
| FulfillLineId | Long | Identifier for the specific fulfillment line that contains the asset transaction details, used to tie the asset data to the correct line in the order. |
| SourceAssetTransactionDetailId | String | Unique identifier for the asset transaction detail assigned by the source application, used to trace the transaction back to its origin. |
| AssetId | Long | Unique identifier for the asset being transacted, used to link the asset to the order line and track its history. |
| AssetNumber | String | Number assigned to the asset, helping to identify and track the specific asset involved in the transaction. |
| Quantity | Decimal | Quantity of the asset transacted, tracking the number of units affected by the asset transaction within the installed base. |
| AssetUOMCode | String | Code representing the unit of measure for the asset quantity, used to define how the asset quantity is measured (for example, pieces, meters). |
| AssetUOM | String | Unit of measure for the asset quantity, ensuring that the quantity is properly recorded in the correct measurement system. |
| StatusId | Long | Unique identifier for the status of the asset after the transaction is performed, tracking the asset's current state within the system. |
| StatusCode | String | Abbreviation representing the status of the asset after the transaction, used to categorize the asset’s condition post-transaction. |
| Status | String | Description of the asset’s status after the transaction, providing additional context for the asset’s condition or processing state. |
| AssetTransactionActionCode | String | Code identifying the type of transaction performed on the asset, categorizing actions such as installation, transfer, or return. |
| AssetTransactionAction | String | Name of the transaction performed on the asset, describing the action taken, such as 'installation' or 'deactivation'. |
| CustomerAssetEndDate | Datetime | Date and time when the asset's lifecycle ends within the installed base, marking the point when the asset is no longer active or available for use. |
| CreatedBy | String | Identifier for the user who created the asset transaction details, providing traceability and accountability for the creation process. |
| CreationDate | Datetime | Date and time when the asset transaction details were created, ensuring proper record-keeping for asset management and order processing. |
| LastUpdatedBy | String | Identifier for the user who last updated the asset transaction details, ensuring traceability of modifications made to the record. |
| LastUpdateDate | Datetime | Date and time when the asset transaction details were last updated, providing an audit trail for changes made to the asset's transaction information. |
| LastUpdateLogin | String | Login identifier for the user who last updated the asset transaction details, helping to trace changes to the asset record. |
| Finder | String | Tool or method used to search and locate specific asset transaction details, helping to filter and retrieve relevant asset records efficiently. |
| FromDate | Date | Start date for the asset transaction details, marking the beginning of the period during which the transaction details are valid. |
| HeaderId | Long | Unique identifier for the asset transaction header, linking the transaction details to the broader asset management process. |
| OrderKey | String | Unique key identifying the order line associated with the asset transaction details, ensuring accurate tracking of the transaction within the sales order. |
| OrderNumber | String | Order number assigned to the sales order, used to reference and track the order line within the broader order processing system. |
| SourceTransactionNumber | String | Transaction number assigned by the source system, linking the asset transaction details to the originating system for tracking purposes. |
| SourceTransactionSystem | String | Name of the source transaction system, providing context for where the asset transaction originated and how it is integrated with other systems. |
| ToDate | Date | End date for the asset transaction details, marking the point at which the transaction details are no longer valid or applicable. |