Charge Tiers

The Charge Tiers view object manages details about tier definitions for charges.

Data Store Key : FscmTopModelAM.ScmExtractAM.DooBiccExtractAM.OrderChargeTierExtractPVO

Primary Keys : OrderChargeTierId

Initial Extract Date : OrderChargeTierCreationDate

Incremental Extract Date : OrderChargeTierLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
OrderChargeTierAdjustmentAmount	Value that identifies the amount to be adjusted or the price for each unit or block for the item. In Oracle Subscription Management Cloud, this attribute is mapped to the list price.
OrderChargeTierAdjustmentBasisId	Value that uniquely identifies the basis to use when the adjustment type is a percent.
OrderChargeTierAdjustmentTypeCode	Value that identifies the type of adjustment to apply. The ORA_QP_LINE_ADJ_TYPES lookup type contains the values that you can use for this attribute.
OrderChargeTierApplicationMethodCode	Value that identifies the application method to use for tiered pricing. The ORA_OSS_PRICE_FORMAT lookup type contains the values that you can use for this attribute.
OrderChargeTierBlockSize	Number that represents the size of the block for charge calculation for a tier.
OrderChargeTierCreatedBy	User who created the charge tier row.
OrderChargeTierCreationDate	Date when the charge tier row was created.
OrderChargeTierDeltaType	Internal column used by change processing framework for tracking type of change like update, cancel, and so on.
OrderChargeTierId	Value that uniquely identifies the charge tier.
OrderChargeTierLastUpdateDate	Date when the charge tier row was last updated.
OrderChargeTierLastUpdateLogin	Session login associated to the user who most recently updated the charge tier row.
OrderChargeTierLastUpdatedBy	User who most recently updated the charge tier row.
OrderChargeTierModifiedFlag	Value that indicates that the row has been modified in the version currently submitted.
OrderChargeTierObjectVersionNumber	Number of times the charge tier row has been updated.
OrderChargeTierOrderChargeId	Value that uniquely identifies the charge.
OrderChargeTierPartialBlockAction	Value that identifies which block to consider if the block size is entered. A list of accepted values is defined in the lookup type ORA_QP_PARTIAL_BLOCK_ACTIONS.
OrderChargeTierReferenceOrderChargeTierId	Used by change management to associate the change order's charge tier ID with the original order's charge tier ID.
OrderChargeTierSourceOrderChargeTierId	Value that uniquely identifies the charge tier in the source application.
OrderChargeTierTierFrom	Value that identifies the starting value of the tier.
OrderChargeTierTierSequenceNumber	Value that identifies the sequence number for the charge tier.
OrderChargeTierTierTo	Value that identifies the ending value of the tier.