Oracle® Retail Pricing Cloud Service Oracle Retail Pricing Cloud Service Implementation Guide Release 22.1.301.0 F59948-01 |
|
![]() Previous |
![]() Next |
The following Merchandising codes are used to manage some of the dropdowns and options in Pricing. The details on how each are used is described below. Some of these codes allow new values to be added, while others only allow you to configure certain options off or update descriptions and translations. To configure any of these options, you'll need to use the Merchandising Codes and Descriptions spreadsheet download and upload functionality. This includes updating the terminology used for these codes, marking those that you are not using, as well as updating or adding any translations. You can find details on how to access and use the spreadsheet upload for Codes and Descriptions in the Merchandising Implementation Guide.
Code Type | Code Type Description | Notes | Add New Allowed? |
---|---|---|---|
CLCT | Pricing Application - Clearance Change Types | Used to determine the valid discount types for clearance markdowns - Percent Off, Amount Off, Fixed Price or Reset. This code type provides the options available to a user in the dropdowns when creating markdowns in the Pricing UI or the spreadsheet upload. You could indicate one or more codes as not used to hide the values in your implementation. Note: one of the values for this code type is Exclude. That is used only systematically when an item/location needs to be excluded from a price event due to conflicts. This will not normally be visible as a change type to users, but it is visible when using the spreadsheet upload method. If a user chooses that value for upload, an error will be raised. | No |
CLIV | Pricing Application - Clearance Item Levels | Used to determine the valid item levels for creating clearance markdowns - Item, Parent/Diff, Upload List, Item List, or Item Parent. This code provides the options available to a user in the dropdowns when creating markdowns in the Pricing UI. You could indicate one or more codes as not used to hide the values in your implementation.
Note: code type 4 - Item Parent is used for backend processing only and is not displayed in the UI. |
No |
CLLI | Pricing Application - Clearance Location Levels - Induction | Used to provide a user-friendly description of the location type for users to select when downloading and uploading clearances using a spreadsheet, as well as through the web service or batched upload - Zone, Store, or Warehouse. You could indicate one or more codes as not used to hide a value in your implementation. | No |
CLLL | Pricing Application - Clearance Location Levels | Used to provide options for location type when creating clearance events in the Pricing screens. Valid values are Zone, Store, Warehouse, or Location List. You could indicate one or more codes as not used to hide the values in your implementation. | No |
CLSI | Pricing Application - Clearance Statuses - Induction | Used to provide a user-friendly description of the status for a clearance markdown for users to select when downloading and uploading clearances using a spreadsheet, as well as through the web service or batched upload. You could indicate one or more codes as not used to hide a value, but it is not recommended as it could result in errors when downloading existing clearance events. | No |
CLST | Pricing Application - Clearance Statuses | Indicates the valid values for status for clearance markdowns. Used for display in the clearance UIs. You could indicate one or more codes as not used to hide a value, but it is not recommended as it could lead to errors. | No |
CMRC | Pricing Application - Clearance Reasons | Indicates the valid reason codes for a clearance markdown. This code is expected to be updated for your implementation to add new reason codes that are applicable for your business. The default codes provided as part of the initial installation can also be renamed to better suit your business. All new codes added must be numeric. | Yes |
MKDN | Pricing Application - Clearance Markdowns | Indicates the valid markdown numbers for a clearance markdown (e.g. First, Second, Final, and so on). This code is expected to be updated for your implementation to add new codes that are applicable for your business. The default codes provided as part of the initial installation can also be renamed to better suit your business. All new codes added must be numeric. | Yes |
Code Type | Code Type Description | Notes | Add New Allowed? |
---|---|---|---|
PCCT | Pricing Application - Price Change Change Types | Used to determine the valid change types for regular price changes - Change by Percent, Change by Amount, Fixed Price, Reset POS, or Multi-Unit Fixed Price. This code provides the options available to a user in the dropdowns when creating price changes in the Pricing UI or the spreadsheet upload. You could indicate one or more codes as not used to hide the values in your implementation. Note: one of the values for this code type is Exclude. That is used only systematically when an item/location needs to be excluded from a price event due to conflicts. This will not normally be visible as a change type to users, but it is visible when using the spreadsheet upload method. If a user chooses that value for upload, an error will be raised. | No |
PCIL | Pricing Application - Price Change Item Levels | Used to determine the valid item levels for creating regular price changes - Item, Parent/Diff, Upload List, Item List, and Item Parent. This code provides the options available to a user in the dropdowns when creating price changes in the Pricing UI. You could indicate one or more codes as not used to hide the values in your implementation.
Note: code type 4 - Item Parent is used for backend processing only and is not displayed in the UI. |
No |
PCIM | Pricing Application - Price Change Impacts to Multi Unit Retail | Used to indicate the impact of a price change on the multi-unit retail of an item. The value selected on a price change help determine the workflow for the pricing analyst, as well as the intended behavior if no multi-unit pricing information is added for a price change. Valid values are Add or Update, Remove, or No Change. | No |
PCLI | Pricing Application - Price Change Location Levels - Induction | Used to provide a user-friendly description of the location type for users to select when downloading and uploading price changes using a spreadsheet, as well as through the web service or batched upload - Zone, Store, or Warehouse. You could indicate one or more codes as not used to hide the values in your implementation. | No |
PCLL | Pricing Application - Price Change Location Levels | Used to provide options for location type when creating price changes in the Pricing screens. Valid values are Zone, Store, or Warehouse. You could indicate one or more codes as not used to hide the values in your implementation. | No |
PCRC | Pricing Application - Price Change Reasons | Indicates the valid reason codes for a regular price change. This code is expected to be updated for your implementation to add new reason codes that are applicable for your business. The default codes provided as part of the initial installation can also be renamed to better suit your business. All new codes added must be numeric. | Yes |
PCSI | Pricing Application - Price Change Statuses - Induction | Used to provide a user-friendly description of the status for a regular price change for users to select when downloading and uploading price changes using a spreadsheet, as well as through the web service or batched upload. You could indicate one or more codes as not used to hide a value, but it is not recommended as it could result in errors when downloading existing price events. | No |
PCSS | Pricing Application - Price Change Statuses | Indicates the valid values for status for price changes. Used for display in the price change UIs. You could indicate one or more codes as not used to hide a value, but it is not recommended as it could lead to errors. | No |
Code Type | Code Type Description | Notes | Add New Allowed? |
---|---|---|---|
IBOT | Pricing Application - Promotion Item Buy/Get Offer Templates | Used to determine the valid offer templates for promotional item-level offers of type Buy/Get:
These codes provide the options available to a user in the dropdowns when creating promotional offers in the Pricing UI. You could indicate one or more codes as not used to hide the values in your implementation if not supported by your selling solutions or not a desirable offer type. |
No |
IGOT | Pricing Application - Promotion Item Gift with Purchase Offer Templates | Used to determine the valid offer templates for promotional item-level offers of type Gift with Purchase:
These codes provide the available options to a user in the dropdowns when creating promotional offers in the Pricing UI. You could indicate one or more codes as not used to hide the values in your implementation if not supported by your selling solutions or not a desirable offer type. |
No |
IOTP | Pricing Application - Promotion Item Offer Types | Used to determine the valid offer types for promotional item-level offers when creating offers in the Pricing UI:
You could indicate one or more codes as not used to hide the values in your implementation if not supported by your selling solutions or not a desirable offer type. |
No |
ISOT | Pricing Application - Promotion Item Simple Offer Templates | Used to determine the valid offer types of promotional item-level offers of type Simple Discount:
These codes provide the available options to a user in the dropdowns when creating promotional offers in the Pricing UI. There is one code for this type - Get Y for Discount. You could indicate this code as not used to hide the values in your implementation if not supported by your selling solutions or not a desirable offer type. |
No |
OFCT | Pricing Application - Promotion Offer Change Types | Indicates the valid discount types for promotional offers - Percent Off, Amount Off, or Fixed Price. You could indicate one or more codes as not used to hide the values in your implementation if not supported by your selling solutions. This code is only used in the system options screen to determine the default values. | No |
OFDR | Pricing Application - Promotion Offer Distribution Rules | Indicates how the selling solution should apply the discount on a customer's purchase for certain item-level offer types - Buy Items, Get Items, or Both Buy and Get Items. You could indicate one or more codes as not used to hide the values in your implementation if not supported by your selling solutions. Note: Xstore does not support using this indicator from Pricing. Therefore, when implementing with Xstore all but the "Get Items" option should be turned off. | nO |
OFII | Pricing Application - Promotion Offer Item Levels - Induction | Indicates the valid item levels for inclusion or exclusion that can be used when uploading promotional offers from an external source or from a spreadsheet. These item levels are used for both the conditions and rewards part of the offer, where applicable. If any of these levels cannot be used for your implementation because your POS or OMS cannot interpret the data, then you can choose to mark those levels as not used. For example, if your POS doesn't have information on the valid suppliers for an item, you may need to hide the Supplier Site/Brand option. Valid values are Department (1), Class (2), Subclass (3), Parent/Diff (5), Item (6), All Departments (8), and Supplier Site/Brand (11). | No |
OFIL | Pricing Application - Promotion Offer Item Levels | Indicates the valid item levels for inclusion and exclusion on promotional offers. This list is used for both the buy conditions and the get conditions as part of the offer creation. If any of these levels cannot be used for your implementation because your POS or OMS cannot interpret the data, then you can choose to mark those levels as not used. For example, if your POS doesn't have information on the valid suppliers for an item, you may need to hide the Supplier Site/Brand option. Valid values are Department (1), Class (2), Subclass (3), Item Parent (4), Parent/Diff (5), Item (6), Item List (7), All Departments (8), Upload List (10), and Supplier Site/Brand (11). Note that Item Parent is used only in backend processing. | No |
OFLI | Pricing Application - Promotion Offer Location Levels - Induction | Indicates the valid location types that can be used when uploading promotions from an external source or from a spreadsheet. Valid values are Store (0) or Zone (1). | No |
OFLV | Pricing Application - Promotion Offer Levels | Indicates the valid levels that offers can be created - Item or Transaction. Note: this code is used primarily for the labels on the screen, so setting the used flag to No doesn't impact how it is displayed. | No |
OFRC | Pricing Application - Promotion Offer Cancel Reasons | Indicates the valid reason codes for an offer cancellation. This code is expected to be updated for your implementation to add new reason codes that are applicable for your business. The default codes provided as part of the initial installation can also be renamed to better suit your business. All new codes added must be numeric. | Yes |
OFTI | Pricing Application - All Promotion Offer Templates - Induction | Lists all the valid offer templates supported by pricing for display in the spreadsheet download/upload function. | No |
OPRO | Pricing Application - Promotion Offer Price Restriction Operators | Indicates the valid operators that can be used when defining a price restriction as part of the item qualifier criteria on an offer. Valid values are Less than, Greater than, or Between. You could indicate one or more codes as not used to hide the values in your implementation if price restrictions are not fully supported by your selling solutions. | No |
PRAT | Pricing Application - Promotion Offer Applies To Values | Contains the options for which types of items an offer applies to: Regular, Clearance, or Regular and Clearance. | No |
PRST | Pricing Application - Promotion Offer Statuses | Indicates the valid values for status used for promotional offers. Used for display in the promotion UIs. You could indicate one or more codes as not used to hide a value, but it is not recommended as it could lead to errors. | No |
TBOT | Pricing Application - Promotion Transaction Buy/Get Offer Templates | Used to determine the valid offer templates for promotional transaction-level offers of type Buy/Get:
These codes provide the available options to a user in the dropdowns when creating promotional offers in the Pricing UI. You could indicate one or more codes as not used to hide the values in your implementation if not supported by your selling solutions or not a desirable offer type. |
No |
TOTP | Pricing Application - Promotion Transaction Offer Types | Used to determine the valid offer types for promotional transaction-level offers - Simple Discount or Buy/Get. These codes provide the available options to a user in the dropdowns when creating promotional offers in the Pricing UI. You could indicate one or more codes as not used to hide the values in your implementation if not supported by your selling solutions or not a desirable offer type. | No |
TSOT | Pricing Application - Promotion Transaction Simple Offer Templates | Used to determine the valid offer templates for promotional transaction-level offers of type Simple Discount
These codes provide the available options to a user in the dropdowns when creating promotional offers in the Pricing UI. You could indicate one or more codes as not used to hide the values in your implementation if not supported by your selling solutions or not a desirable offer type. |
No |
Code Type | Code Type Description | Notes | Add New Allowed? |
---|---|---|---|
CLCA | Pricing Application - Clearance Cadence | Indicates the options for adding markdowns to a clearance group - either as a single markdown (S) or using a template (T). | No |
MKUT | Pricing Application - Markup Types | Indicates the options for markup type used by Pricing. Valid values are Cost (0) and Retail (1). | No |
RPMT | Pricing Application - Template Types | Indicates the valid template types for configuring spreadsheets to use for download and upload of Price Changes and Clearances. It is not recommended that these be updated. | No |
RTCA | Pricing Application - Template Categories | Indicates the valid template categories for configuring spreadsheets to use for download and upload of Price Changes and Clearances. It is not recommended that these be updated. | No |
YIND | Pricing Application - Yes or No Indicator | Used to decode values of Yes or No for more user-friendly display in spreadsheets or UIs, as these are held as numeric values in the database. | No |