SalesOrdersForOrderHublinescharges
Tracks pricing information, including charges and applied costs for sales orders.
Columns
| Name | Type | Description |
| SalesOrdersForOrderHubHeaderId [KEY] | Long | Unique identifier for the sales order header, linking the charge details to the parent order in Oracle Fusion Order Management. This helps track and reference charges applied to the entire order within the system. |
| LinesFulfillLineId [KEY] | Long | Identifier for the fulfillment line associated with the charge, linking the charge to specific order lines in Oracle Fusion Order Management and tracking fulfillment against customer orders. |
| OrderChargeId [KEY] | Long | Unique identifier for the charge applied to the order, used to track and reference charges within the Oracle Fusion Order Management system for billing and invoicing purposes. |
| SourceChargeId | String | Unique identifier for the charge assigned by the source system (for example, external pricing system or legacy ERP), allowing integration with Oracle Fusion Order Management and external systems. |
| PriceTypeCode | String | Abbreviation that identifies the price type, such as one-time or recurring. Used in Oracle Fusion Pricing to categorize the charge based on its nature, ensuring proper application of pricing strategies. |
| PriceType | String | Description of the price type applied, such as one-time charge or recurring fee. This helps determine how the charge is calculated in Oracle Fusion Pricing for pricing models and forecasting. |
| ChargeTypeCode | String | Abbreviation identifying the charge type, such as item sale, service fee, or shipping. This categorizes the charge in Oracle Fusion Order Management and Oracle Fusion Cost Management for correct handling in financial reporting. |
| ChargeType | String | Description of the charge type, categorizing it as an item sale, service, shipping, or another type of charge. Helps Oracle Fusion identify the nature of the charge for tax calculations and revenue recognition. |
| ChargeDefinitionCode | String | Abbreviation for the charge definition, which is defined in Oracle Fusion Pricing. It links the charge to a specific pricing rule or structure within the system, such as discounts, tax calculations, or surcharge rules. |
| ChargeDefinition | String | Description of the charge definition, detailing how the charge is calculated and applied. Used in Oracle Fusion Order Management to determine the charge’s impact on the total order value. |
| ChargeSubtypeCode | String | Abbreviation identifying the charge subtype, such as late fee, penalty, or promotional discount. Helps define the specific nature of the charge for reporting and customer agreements in Oracle Fusion. |
| ChargeSubType | String | Description of the charge subtype, providing further classification for charge types like restocking fees, penalty charges, or service fees, relevant for Oracle Fusion’s billing and reconciliation systems. |
| PricedQuantity | Decimal | Quantity associated with the charge, specifying how much of the item or service the charge applies to. For example, in Oracle Fusion, it helps calculate unit-based charges for inventory items. |
| ChargeCurrencyCode | String | Abbreviation identifying the currency used for the charge. In Oracle Fusion, this currency setting ensures that the charge is applied in the correct currency for international sales or multi-currency transactions. |
| ChargeCurrency | String | Currency used for the charge. This aligns with the currency in Oracle Fusion Financials, ensuring proper accounting entries are made when applying charges to orders in multiple currencies. |
| PricedQuantityUOMCode | String | Abbreviation identifying the unit of measure for the priced quantity, such as Ton. Oracle Fusion Product Lifecycle Management or Oracle Order Management Cloud provides this value to standardize how charges are measured. |
| PricedQuantityUOM | String | Unit of measure for the priced quantity, such as Ton, defined in Oracle Fusion Supply Chain Management or Order Management to track how units are billed and processed. |
| PricePeriodicityCode | String | Abbreviation identifying the periodicity of the charge (for example, monthly, annually). Used in Oracle Fusion Pricing to configure recurring charges and ensure proper scheduling of future charges. |
| PricePeriodicity | String | Description of the periodicity of the charge, specifying how often the charge recurs (for example, monthly, quarterly). This is crucial for managing subscription models or recurring billing in Oracle Fusion Subscriptions. |
| SequenceNumber | Int | Sequence number that orders the charges in the system, ensuring they are applied in the correct order. Useful in Oracle Fusion Order Management to apply charges in sequence, particularly when multiple charges are involved. |
| PrimaryFlag | Bool | Flag indicating whether the charge is the primary charge (true) or a secondary charge (false). Oracle Fusion Financials uses this to determine which charge is principal when calculating invoice amounts. |
| RollupFlag | Bool | Flag indicating whether the charge is a rollup charge (true), meaning it combines multiple charges into one. In Oracle Fusion, this affects how the charges are grouped for invoicing and reporting purposes. |
| AverageUnitSellingPrice | Decimal | The weighted average price per unit, calculated from total revenue divided by total units sold. In Oracle Fusion, this metric helps in analyzing the overall profitability of sales transactions. |
| CanAdjustFlag | Bool | Flag indicating whether the charge is eligible for adjustment (true) or not (false). In Oracle Fusion Order Management, this impacts whether changes can be made to charges post-sale based on discounts or disputes. |
| GSAUnitPrice | Decimal | Price per unit determined by the price list in Oracle Fusion Pricing, providing a reference for calculating the cost and revenue generated from each unit sold. |
| ApplyToCode | String | Abbreviation identifying where the charge is applied (for example, item, shipping, or return). In Oracle Fusion, this code ensures that the charge is appropriately allocated to the correct part of the order for correct invoicing. |
| ApplyTo | String | Description of where the charge applies, such as for the item, shipping, or return. Oracle Fusion uses this to determine how the charge impacts order totals and taxes. |
| TieredFlag | Bool | Flag indicating whether the charge uses a tiered pricing structure (true), commonly applied for volume-based discounts. Oracle Fusion Pricing uses this to apply graduated discount schemes or fees based on quantity. |
| TierAppliesToCode | String | Abbreviation identifying whether the tier applies to all tiers or just the highest tier. Oracle Fusion Pricing uses this to apply tiered pricing logic for large-volume purchases or high-value contracts. |
| TierAppliesTo | String | Description of whether the tiered pricing applies to all tiers or only the highest tier. This setting in Oracle Fusion ensures that discounts or charges are applied according to predefined tier rules. |
| UsagePriceLockFlag | Bool | Flag indicating whether the usage price is locked (true) or not (false), used to lock pricing for subscription-based models. This flag is managed within Oracle Fusion Subscriptions and Pricing. |
| BlockAllowance | Decimal | Block allowance for a non-tiered consumption charge, specifying the threshold of usage before additional charges apply. Oracle Fusion Subscriptions uses this to calculate usage-based billing for subscription models. |
| BlockSize | Decimal | Size of the block for charge calculation in tiered pricing, helping Oracle Fusion Pricing to calculate charges based on predefined usage blocks. |
| UsageUOMCode | String | Code identifying the unit of measure for usage, such as hours or units, used by Oracle Fusion Subscriptions or Oracle Cloud Inventory for tracking consumption. |
| ChargePeriodCode | String | Code identifying the charge period, such as monthly or annually. This setting ensures charges align with the periodicity of the subscription or usage model in Oracle Fusion Subscriptions. |
| UsageUOM | String | Unit of measure for usage-based charges, such as hours or units. Oracle Fusion Subscriptions uses this to track how usage is measured and billed to the customer. |
| ChargePeriod | String | Description of the period for which the charge applies, helping Oracle Fusion determine how frequently the charge is assessed (for example, monthly, yearly). |
| Finder | String | Method or tool used to locate specific charge records, enabling users to filter and retrieve relevant charge information from Oracle Fusion Order Management. |
| FromDate | Date | Start date when the charge is applicable, marking the beginning of the charge’s validity period in Oracle Fusion Order Management. |
| HeaderId | Long | Unique identifier for the order header related to the charges, associating the charge with the broader order context in Oracle Fusion. |
| OrderKey | String | Key used to uniquely identify the order line associated with the charge, ensuring the correct charge is applied to the appropriate order line in Oracle Fusion. |
| OrderNumber | String | Order number assigned to the sales order, used to track the order in Oracle Fusion Order Management and link it to the charges applied. |
| SourceTransactionNumber | String | Transaction number from the source system, linking the charge details to its originating transaction in external systems integrated with Oracle Fusion. |
| SourceTransactionSystem | String | Source system name from which the charge data originated, providing context for integration with external systems and ensuring consistency across platforms. |
| ToDate | Date | End date after which the charge is no longer valid, marking the expiration of the charge period in Oracle Fusion. |