SalesOrdersForOrderHublinesmanualPriceAdjustments
Tracks manual price adjustments made to sales order lines by Order Entry Specialists.
Columns
| Name | Type | Description |
| SalesOrdersForOrderHubHeaderId [KEY] | Long | Unique identifier for the sales order header, linking the manual price adjustment to the parent order, ensuring proper tracking of adjustments within the order lifecycle. |
| LinesFulfillLineId [KEY] | Long | Identifier for the fulfillment line associated with the manual price adjustment, allowing tracking of adjustments at the line level for accurate pricing and order fulfillment. |
| ManualPriceAdjustmentId [KEY] | Long | Unique identifier for the manual price adjustment applied to the order, used for tracking and managing price adjustments throughout the order lifecycle. |
| AdjustmentAmount | Decimal | The amount of the manual price adjustment, either as a fixed amount or a percentage, applied to a charge or the total amount in the order. |
| AdjustmentElementBasis | String | Basis used for calculating the manual price adjustment, such as total price, list price, or net price, providing context for how the adjustment is applied. |
| AdjustmentElementBasisName | String | Name describing the basis used for the price adjustment, helping clarify the method of calculation for transparency in pricing. |
| AdjustmentTypeCode | String | Abbreviation identifying the type of manual price adjustment, such as discount, surcharge, or promotional offer, providing a quick reference for the adjustment type. |
| AdjustmentType | String | The method used to calculate the manual price adjustment, such as a percentage discount, a fixed amount reduction, or other pricing models. |
| ChargeDefinitionCode | String | Abbreviation identifying the charge definition for the manual price adjustment, helping to categorize and track charge types for price adjustments. |
| ChargeDefinition | String | Description of the charge definition applied for the price adjustment, clarifying the specific charges affected by the adjustment. |
| ChargeRollupFlag | Bool | Indicates whether pricing should roll up the charge for the adjustment (true) or not (false). For Oracle Fusion priced orders, this default value is based on pricing setup. For pre-priced orders, no default is set. |
| Comments | String | Additional comments or notes describing the rationale or details of the manual price adjustment, providing context for review or auditing. |
| ParentEntityId | Long | Identifier for the parent entity (such as a promotion or contract) associated with the manual price adjustment, linking it to larger pricing strategies. |
| PricePeriodicityCode | String | Abbreviation identifying the price periodicity for the charge affected by the price adjustment, such as monthly, yearly, or quarterly. |
| PricePeriodicity | String | Description of the price periodicity for the charge adjustment, helping to define the frequency at which the adjustment is applied. |
| ReasonCode | String | Abbreviation identifying the reason for the price adjustment, such as promotional discount or contractual obligation. |
| Reason | String | Description of the reason for the price adjustment, providing context for why the adjustment was applied. |
| SequenceNumber | Int | Order of the manual price adjustment in relation to other adjustments, used for prioritization when multiple adjustments are applied to the same order line. |
| SourceManualPriceAdjustmentId | String | Unique identifier assigned by the source application for the manual price adjustment, ensuring consistency and integration with external systems. |
| ValidationStatusCode | String | Validation status code indicating whether the manual price adjustment has been validated or requires further review, ensuring proper application of adjustments. |
| EffectivityTypeCode | String | Abbreviation that identifies the type of effectivity to use for the price adjustment. Defines when the adjustment is applicable, such as immediate, scheduled, or based on certain conditions. Accepted values are defined in ORA_OSS_PRICE_ADJ_EFFECTIVITY. Use this with the Integrate Order Management with Subscription Management to process subscriptions or coverages features. |
| EffectivityType | String | Description of the effectivity type for the price adjustment, helping to clarify when the adjustment will be applied (for example, on order submission or based on specific criteria). Use this with the Integrate Order Management with Subscription Management to process subscriptions or coverages features. |
| EffectivePeriodFrom | Decimal | The period number from which the price adjustment starts, used for determining the validity of the adjustment over a series of time periods. Use this with the Integrate Order Management with Subscription Management to process subscriptions or coverages features. |
| EffectivePeriodUntil | Decimal | The period number until which the price adjustment is valid, ensuring that the adjustment is only applied within a specific time frame. Use this with the Integrate Order Management with Subscription Management to process subscriptions or coverages features. |
| EffectiveNumberOfPeriods | Decimal | The number of periods for which the price adjustment will be applied, defining the duration of the adjustment's effect. Use this with the Integrate Order Management with Subscription Management to process subscriptions or coverages features. |
| Finder | String | Method or tool used to locate specific manual price adjustment records, facilitating efficient retrieval and management of pricing data. |
| FromDate | Date | Start date of the manual price adjustment, marking when the adjustment becomes valid or effective. |
| HeaderId | Long | Unique identifier for the header of the price adjustment record, linking the adjustment to the overall sales order or pricing entity. |
| OrderKey | String | Key used to reference the sales order associated with the manual price adjustment, ensuring that the adjustment is tracked under the correct order. |
| OrderNumber | String | Unique order number for the sales order, used for tracking the adjustment and ensuring consistency in reporting and fulfillment. |
| SourceTransactionNumber | String | Transaction number from the source system that links the manual price adjustment to its originating transaction. |
| SourceTransactionSystem | String | Source system name that provided the data for the manual price adjustment, helping ensure consistency and accurate integration between systems. |
| ToDate | Date | End date for the manual price adjustment, marking when the adjustment is no longer valid or applicable to the order. |