Prices Array Set
Overview
The transaction line Prices array (oRCL_charges) holds the prices and charges information of an item. This array set is used in OIC mappings to generate the payload for Oracle Order Management integration. Commerce library “oRCL_fOM_populateCharges” included in the Commerce Standard Process is used to populate this array set with all the applicable charges defined for an item in the pricing portal.
| Name | Variable Name | Type | Description |
|---|---|---|---|
|
Apply To |
oRCL_applyTo |
Text |
Indicates which type of price it is applied. |
|
Charge Definition Integration ID |
_s_oRCL_chargeDefIntegrationId |
Text |
The charge definition code in the integrated order management system. |
|
Charge Name |
oRCL_chargeName |
Text |
Name of the charges. Example Values: Sale Price, Recurring Sale Price. |
|
Charge Type |
_s_oRCL_chargeType |
Text |
Charge Type of the item. Introduced in CPQ 23C. Replaced |
|
oRCL_chargeType |
Text |
Removed in CPQ 23C. Replaced with |
|
|
Contract Discount Amount |
oRCL_contractDiscountAmount |
Float |
The total discount of this line including all one-time and recurring charges. |
|
Contract List Value |
oRCL_contractListValue |
Float |
The total of all contract list value of this line, including all one-time and recurring charges. |
|
Contract Net Value |
oRCL_contractNetValue |
Float |
The total contract value of this line including all one-time and recurring charges. |
|
Contract Tax Amount |
_s_oRCL_contractTaxAmount |
Float |
Total Tax amount applicable on the charge for the contract duration. Introduced in CPQ 25A |
|
Contract Total Amount |
_s_oRCL_contractTotalAmount |
Float |
Total amount including taxes applicable on the charge for the contract duration. Introduced in CPQ 25A |
|
Contract Total Amount Excluding Tax |
_s_oRCL_contractTotalAmountExcludingTax |
Float |
Total amount without taxes applicable on the charge for the contract duration. Introduced in CPQ 25A |
|
Custom Discount Amount |
oRCL_customDiscountAmount |
Float |
The type of custom discount applied to this charge. Typically this may be an override price, a discount value or a discount percentage. |
|
Custom Discount Type |
_s_oRCL_customDiscountType |
Text |
The type of custom discount applied to this charge. Typically this may be an override price, a discount value or a discount percentage. Introduced in CPQ 23C. |
|
Discount Amount |
oRCL_discountAmount |
Float |
The discount amount for this line. |
|
List Amount |
oRCL_listAmount |
Float |
The extended list amount for this line. |
|
List Price |
oRCL_listPrice |
Float |
List Price of the item. |
|
Net Amount |
oRCL_netAmount |
Float |
The extended list amount minus any discounts for this line. |
|
Net Price |
oRCL_netPrice |
Float |
The price paid by the customer for this item. |
|
Price Period |
_s_oRCL_pricePeriod |
Text |
The time period, frequency or recurrence with which the price or charge is levied. Introduced in CPQ 23C. |
|
Price Type |
_s_oRCL_priceType |
Text |
Indicates whether the amount on this line is charged once or periodically. Introduced in CPQ 23C. |
|
Price Unit of Measure |
_s_oRCL_priceUOM |
Text |
Indicates whether the amount on this line is charged once or periodically. Introduced in CPQ 23C. |
|
Primary Charge |
oRCL_primaryCharge |
Boolean |
Primary charge is used to determine whether the charge is primary or not. |
|
Sequence Number |
oRCL_chargeSequenceNumber |
Integer |
Sequence number of the charges. |
|
Tax Amount |
_s_oRCL_taxAmount |
Float |
Total Tax amount applicable on the charge. Introduced in CPQ 25A |
|
Tax Price |
_s_oRCL_taxPrice |
Float |
Tax applicable per unit on the charge. Introduced in CPQ 25A |
|
Total Amount Excluding Tax |
_s_oRCL_totalAmountExcludingTax |
Float |
Total amount without taxes for this charge. Introduced in CPQ 25A |
|
Total Amount Including Tax |
_s_oRCL_totalAmount |
Float |
Total amount including taxes applicable for this charge. Introduced in CPQ 25A |
|
Total Price Excluding Tax |
_s_oRCL_totalPriceExcludingTax |
Float |
Total price without taxes for this charge. Introduced in CPQ 25A |
|
Total Price Including Tax |
_s_oRCL_TotalPrice |
Float |
Total price including taxes applicable for this charge. Introduced in CPQ 25A |
|
Total Prorated Order Discount |
_s_oRCL_totalProratedOrderDiscount |
Float |
Total Prorated Order Discount accounted from line. Not applicable for charges. Introduced in CPQ 25A |
|
Unit Prorated Order Discount |
_s_oRCL_unitProratedOrderDiscount |
Float |
Prorated Order Level Discount Per Unit from line. Not applicable for charges. Introduced in CPQ 25A |
Administration
Edit a Prices Array Set Attribute





