SalesOrdersForOrderHublinespriceAdjustments
Manages price changes such as discounts applied to sales orders.
Columns
| Name | Type | Description |
| SalesOrdersForOrderHubHeaderId [KEY] | Long | Unique identifier for the sales order header, linking the price adjustments to the parent order. This helps track and associate price adjustments at the order level within Oracle Fusion Order Management. |
| LinesFulfillLineId [KEY] | Long | Identifier for the fulfillment line associated with the price adjustment, enabling tracking of price adjustments at the line level within Oracle Fusion Order Management. |
| PriceAdjustmentId [KEY] | Long | Unique identifier for the price adjustment applied to the order line. This helps track and reconcile price adjustments made during the order lifecycle, ensuring proper application and reporting. |
| AdjustmentName | String | Name or description of the price adjustment, providing additional context to the specific adjustment applied, such as a discount, surcharge, or price override. |
| Amount | Decimal | The amount of the price adjustment applied to the order line, either as a positive or negative value depending on whether the price is being increased or decreased. |
| AdjustmentTypeCode | String | Abbreviation or code that identifies the type of price adjustment applied to the order line, such as a discount, markup, or surcharge. |
| AdjustmentType | String | The type of adjustment applied, which could be a discount, surcharge, or other price modification. This helps classify the nature of the adjustment. |
| InvoicedFlag | Bool | Flag indicating whether the price adjustment has been invoiced. A value of true means the adjustment has been included in the invoice, while false means it has not yet been invoiced. |
| OrigSystemAdjustmentReference | String | Original reference from the source system that identifies the price adjustment, used to maintain consistency across systems and ensure accurate integration. |
| Finder | String | Method or tool used to locate specific price adjustment records in Oracle Fusion Order Management, allowing for efficient retrieval and analysis of price adjustments. |
| FromDate | Date | The start date when the price adjustment becomes effective. This date marks the period during which the adjustment applies to the order. |
| HeaderId | Long | Unique identifier for the header of the price adjustment record, linking it to the overall sales order header in Oracle Fusion Order Management. |
| OrderKey | String | Unique key used to reference the sales order associated with the price adjustment. This ensures that all related transactions and adjustments are tracked under the correct order. |
| OrderNumber | String | Unique order number assigned to the sales order, providing a reference for reporting, invoicing, and tracking within Oracle Fusion Order Management. |
| SourceTransactionNumber | String | Transaction number from the source system that identifies the original transaction linked to the price adjustment, ensuring consistency in cross-system integration. |
| SourceTransactionSystem | String | Name of the source system that provided the original transaction data. This helps maintain data integrity during system integrations and transactions. |
| ToDate | Date | The end date when the price adjustment is no longer valid. This date marks the expiration of the adjustment period, ensuring that the adjustment only applies within the specified timeframe. |