Cmdlets for Oracle Fusion Cloud SCM

Build 23.0.8839

SalesOrdersForOrderHublinescharges

SalesOrdersForOrderHublinescharges

Columns

Name Type Description
SalesOrdersForOrderHubHeaderId [KEY] Long SalesOrdersForOrderHubHeaderId of SalesOrdersForOrderHublinescharges
LinesFulfillLineId [KEY] Long LinesFulfillLineId of SalesOrdersForOrderHublinescharges
OrderChargeId [KEY] Long OrderChargeId of SalesOrdersForOrderHublinescharges
SourceChargeId String Value that uniquely identifies the charge. The source application applies this value.
PriceTypeCode String Abbreviation that identifies the price type.
PriceType String Price type, such as one time, recurring, and so on.
ChargeTypeCode String Abbreviation that identifies the charge type.
ChargeType String Charge type, such as item sale, service sale, financing, lease, shipping, restocking penalties, and so on.
ChargeDefinitionCode String Abbreviation that identifies the charge definition.
ChargeDefinition String Charge definition that defines the price type, charge type, and subtype.
ChargeSubtypeCode String Abbreviation that identifies the charge subtype.
ChargeSubType String Charge subtype.
PricedQuantity Double Abbreviation that identifies the unit of measure for the priced quantity, such as Ton.
ChargeCurrencyCode String Abbreviation that identifies the charge currency.
ChargeCurrency String Charge currency.
PricedQuantityUOMCode String Abbreviation that identifies the unit of measure for the priced quantity.
PricedQuantityUOM String Unit of measure for priced quantity, such as Ton. Oracle Product Lifecycle Management Cloud or a service in Oracle Order Management Cloud provides this value.
PricePeriodicityCode String Abbreviation that identifies the price periodicity.
PricePeriodicity String Periodicity for recurring price types, such as month, quarter, or year.
SequenceNumber Int Sequence number for the charge.
PrimaryFlag Bool Contains one of the following values: true or false. If true, then the charge is the primary charge. If false, then the charge is not the primary charge. For Oracle Fusion application priced orders, the default value is set based on the pricing setup. For pre-priced orders, the value is entered by the user.
RollupFlag Bool Contains one of the following values: true or false. If true, then the charge is a rollup charge. If false, then the charge is not a rollup charge. For Oracle Fusion application priced orders, the default value is set based on the pricing setup. For pre-priced orders, the default value is false.
AverageUnitSellingPrice Double Weighted average of the selling price. This average is the total sales revenue divided by total units sold.
CanAdjustFlag Bool Contains one of the following values: true or false. If true, then the charge is eligible for adjustment. If false, then the charge is not eligible for adjustment. For Oracle Fusion application priced orders, the default value is set based on the pricing setup. For pre-priced orders, the default value is false.
GSAUnitPrice Double Price for each unit. Determined from the price list on the pricing strategy.
ApplyToCode String Abbreviation that identifies where pricing applies the charge: for the item, for shipping, or for the return.
ApplyTo String Specifies where pricing applies the charge: for the item, for shipping, or for the return.
TieredFlag Bool TieredFlag of SalesOrdersForOrderHublinescharges
TierAppliesToCode String Abbreviation that identifies the applicability of the tier whether all tiers or the highest tier. A list of accepted values is defined in the lookup type ORA_QP_TIER_GRADUATED_TYPES. This is available for use with the Integrate Order Management with Subscription Management to Process Subscriptions or Coverages features.
TierAppliesTo String Value that identifies whether the applicability of the tier is for all tiers or the highest tier. This is available for use with the Integrate Order Management with Subscription Management to Process Subscriptions or Coverages features.
UsagePriceLockFlag Bool Contains one of the following values: true or false. If true, then the usage pricing is used. If false, then the usage pricing isn't used. This attribute does not have a default value. This is available for use with the Integrate Order Management with Subscription Management to Process Subscriptions or Coverages features.
BlockAllowance Double Value that indicates the block allowance for a non-tiered consumption charge. This is available for use with the Integrate Order Management with Subscription Management to Process Subscriptions or Coverages features.
BlockSize Double Number that represents the size of the block for charge calculation for a tier. This is available for use with the Integrate Order Management with Subscription Management to Process Subscriptions or Coverages features.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
FromDate Date FromDate
HeaderId String HeaderId
OrderKey String OrderKey
OrderNumber String OrderNumber
SourceTransactionNumber String SourceTransactionNumber
SourceTransactionSystem String SourceTransactionSystem
ToDate Date ToDate
Finder String finder

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839