The seeded (predefined) pricing attributes, product attributes, qualifier attributes, attribute contexts and default pricing attribute mapping rules for Oracle Advanced Pricing are provided for each of the following pricing transaction entities (PTE) used with Oracle Advanced Pricing:
To find attributes, refer to the PTE section where the attribute is sourced. For example, to find the Product attribute of Item Category, go to the Order Fulfillment PTE Attributes section and look under the Product Attributes heading to find the listed attribute.
The following table lists the short names and definitions used in the attribute tables:
Short name | Definition |
---|---|
AM | Attribute Mapping |
AMM | Attribute Mapping Method |
Attrib | Attribute |
ASO | Oracle Order Capture |
CMRO | Complex Maintenance Repair and Overhaul |
Lmt | Limits |
Lvl | Level
|
ONT | Order Management |
OKC | Oracle Contracts Core |
Prec | Precedence |
Req Type | Request Type |
UE | User Entered |
— | No value/not applicable |
This section displays the attributes for the Complex Maintenance Repair and Overhaul (CMRO) PTE.
Pricing Attributes
The following table lists the seeded pricing attributes for the Complex Maintenance Repair and Overhaul PTE:.
Context | Attribute | Attrib Description | Mapped Value | Value Set Name | Lvl | AMM |
---|---|---|---|---|---|---|
AHL_PRICING | Resource Duration | Resource Duration | PRICING_ATTRIBUTE1 | QP: Number | LINE | UE |
Product Attributes
The following table lists the seeded product attributes for the Complex Maintenance Repair and Overhaul PTE:
Context | Attribute | Attrib Description | Mapped Value | Value Set Name | Lvl | AMM |
---|---|---|---|---|---|---|
ITEM | Item Number | Item Number | PRICING_ATTRIBUTE1 | -- | LINE | UE |
Qualifier Attributes
This PTE has no seeded qualifier attributes.
This section displays the attributes for the Demand Planning PTE.
Pricing Attributes
This PTE has no seeded pricing attributes.
Product Attributes
This PTE has no seeded product attributes.
Qualifier Attributes
The following table lists the seeded qualifier attributes for the Demand Planning PTE:
Context | Attribute | Attrib Description | Mapped Value | Value Set Name | Lvl | AMM |
---|---|---|---|---|---|---|
MODLIST | Coupon Number | Not Used | QUALIFIER_ATTRIBUTE3 | QP_SRS_COUPON_NO | BN | UE |
MODLIST | List Line Number | Not Used | QUALIFIER_ATTRIBUTE2 | QP_SRS_LIST_LINE_NUMBER | LN | UE |
MODLIST | Promotion No | Not Used | QUALIFIER_ATTRIBUTE1 | QP_SRS_PROMOTION_NO | BT | UE |
ORDER | Sales Agreement Number | Not Used | QUALIFIER_ATTRIBUTE3 | QP_BLANKET_NUMBER | LN | UE |
PARTY | Buyer | Customer Party, displayed as level value in Geography dimension in Demand Planning. | QUALIFIER_ATTRIBUTE2 | QP_PARTY | LN | UE |
PARTY | Sales Organization | Selling Operating Unit, displayed as level value in Ship From dimension in Demand Planning. | QUALIFIER_ATTRIBUTE3 | QP_SALES_ORGANIZATION | LN | UE |
PARTY | Supplier | Supplier Party, displayed as level value in Geography dimension in Demand Planning. | QUALIFIER_ATTRIBUTE1 | QP_PARTY | LN | UE |
The following section displays the attributes for the Intercompany Transaction PTE.
Pricing Attributes
This PTE has no seeded pricing attributes.
Product Attributes
The following table lists the seeded product attributes for the Intercompany Transaction PTE:
Context | Attribute | Attrib Description | Mapped Value | Value Set Name | Lvl | AMM |
---|---|---|---|---|---|---|
ITEM | Item Number | Item Number | PRICING_ATTRIBUTE1 | -- | LINE | AM |
Qualifier Attributes
The following table lists the seeded qualifier attributes for the Intercompany Transaction PTE:
Context | Attribute | Attrib Description | Mapped Value | Value Set Name | Lvl | AMM |
---|---|---|---|---|---|---|
GLOBAL_PROCUREMENT | Procuring Operating Unit | Procuring Operating Unit | QUALIFIER_ATTRIBUTE1 | HR_OPERATING_UNITS | LN | AM |
GLOBAL_PROCUREMENT | Receiving Operating Unit | Receiving Operating Unit | QUALIFIER_ATTRIBUTE2 | HR_OPERATING_UNITS | LN | AM |
GLOBAL_PROCUREMENT | Vendor Site | Vendor Site | QUALIFIER_ATTRIBUTE4 | INV_IC_VENDOR_SITE | LN | AM |
GLOBAL_PROCUREMENT | Vendor | Vendor | QUALIFIER_ATTRIBUTE3 | INV_IC_VENDOR | LN | AM |
INTERCOMPANY_INVOICING | Customer Site | Customer Site | QUALIFIER_ATTRIBUTE4 | INV_IC_CUSTOMER_SITE | LN | AM |
INTERCOMPANY_INVOICING | Customer | Customer | QUALIFIER_ATTRIBUTE3 | INV_IC_CUSTOMER | LN | AM |
INTERCOMPANY_INVOICING | Selling Operating Unit | Selling Operating Unit | QUALIFIER_ATTRIBUTE2 | HR_OPERATING_UNITS | LN | AM |
INTERCOMPANY_INVOICING | Shipping Operating Unit | Shipping Operating Unit | QUALIFIER_ATTRIBUTE1 | HR_OPERATING_UNITS | LN | AM |
INTERORG_TRANSFER | From Organization Code | From Organization Code | QUALIFIER_ATTRIBUTE1 | GMF_ORGANIZATIONS_ALL | LN | AM |
INTERORG_TRANSFER | To Organization Code | To Organization Code | QUALIFIER_ATTRIBUTE2 | GMF_ORGANIZATIONS_ALL | LN | AM |
ITEM | Item Number | Item Number | PRICING_ATTRIBUTE1 | LN | AM | |
MODLIST | Coupon Number | Coupon Number for applying Coupon Modifier | QUALIFIER_ATTRIBUTE3 | QP_SRS_COUPON_NO | BT | UE |
MODLIST | List LN Number | Used in conjunction with Promotion No attribute. Identifies Modifier LN Number for applying Ask For Promotion. | QUALIFIER_ATTRIBUTE2 | QP_SRS_LIST_LN_NUMBER | LN | UE |
MODLIST | Promotion No | Promotion Number for applying Ask for Promotion | QUALIFIER_ATTRIBUTE1 | QP_SRS_PROMOTION_NO | BT | UE |
ORDER | Order Date | Order Date | QUALIFIER_ATTRIBUTE1 | QP: Date | BT | AM |
ORDER | Sales Agreement Number | Sales Agreement Number | QUALIFIER_ATTRIBUTE3 | QP_BLANKET_NUMBER | LN | UE |
PARTY | Buyer | Buyer Party | QUALIFIER_ATTRIBUTE2 | QP_PARTY | LN | UE |
PARTY | SALES ORGANIZATION | Selling Operating Unit | QUALIFIER_ATTRIBUTE3 | QP_SALES_ORGANIZATION | LN | UE |
PARTY | Supplier | Supplier Party | QUALIFIER_ATTRIBUTE1 | QP_PARTY | LN | UE |
The following section displays the attributes for the Logistics PTE.
Pricing Attributes
The following table lists the seeded pricing attributes for the Logistics PTE:
Context | Attribute | Attrib Description | Mapped Value | Value Set Name | Lvl | AMM |
---|---|---|---|---|---|---|
LOGISTICS | Additional Service | Additional Service | PRICING_ATTRIBUTE4 | QP_ADDITIONAL_SERVICE | LN | UE |
LOGISTICS | Commodity | Commodity | PRICING_ATTRIBUTE1 | QP: Number | LN | UE |
LOGISTICS | Container Type | Container Type | PRICING_ATTRIBUTE2 | QP_CONTAINER_TYPE | LN | UE |
LOGISTICS | Destination Zone | Destination Zone | PRICING_ATTRIBUTE8 | QP: Number | LN | UE |
LOGISTICS | FREIGHT_CLASS | Freight Class | PRICING_ATTRIBUTE6 | QP_FREIGHT_CLASS | LN | UE |
LOGISTICS | HAZARD_CODE | Hazard Code | PRICING_ATTRIBUTE5 | - | LN | UE |
LOGISTICS | Loading Protocol | Loading Protocol | PRICING_ATTRIBUTE17 | QP: Text | BT | UE |
LOGISTICS | Origin Zone | Origin Zone | PRICING_ATTRIBUTE7 | QP: Number | LN | UE |
LOGISTICS | Service Type | Service Type | PRICING_ATTRIBUTE3 | QP_SERVICE_TYPE | LN | UE |
LOGISTICS | TL Continuous Move Discount Flag | TL Continuous Move Discount Flag | PRICING_ATTRIBUTE18 | QP: Yes/No | BT | UE |
LOGISTICS | TL Deadhead Rate Variant Flag | TL Deadhead Rate Variant Flag | PRICING_ATTRIBUTE19 | QP: Yes/No | BT | UE |
LOGISTICS | TL Distance Type | TL Distance Type | PRICING_ATTRIBUTE12 | QP: Text | BT | UE |
LOGISTICS | TL Handling Activity | TL Handling Activity | PRICING_ATTRIBUTE22 | QP: Yes/No | BT | UE |
LOGISTICS | TL Number of Weekend Layovers | TL Number of Weekend Layovers | PRICING_ATTRIBUTE16 | QP: Number | BT | UE |
LOGISTICS | TL Rate Basis | TL Rate Basis | PRICING_ATTRIBUTE11 | QP: Text | BT | UE |
LOGISTICS | TL Rate Type | TL Rate Type | PRICING_ATTRIBUTE13 | QP: Text | BT | UE |
LOGISTICS | TL Service Type | TL Service Type | PRICING_ATTRIBUTE14 | QP: Text | BT | UE |
LOGISTICS | TL Stop Loading Activity | TL Stop Loading Activity | PRICING_ATTRIBUTE20 | QP: Yes/No | BT | UE |
LOGISTICS | TL Stop Unloading Activity | TL Stop Unloading Activity | PRICING_ATTRIBUTE21 | QP: Yes/No | BT | UE |
LOGISTICS | Total Shipment Quantity | Total Shipment Quantity | PRICING_ATTRIBUTE9 | QP: Number | LN | UE |
LOGISTICS | Vehicle | Vehicle | PRICING_ATTRIBUTE15 | QP: Number | BT | UE |
LOGISTICS | Facility Dropoff Containers | Facility Dropoff Containers | PRICING_ATTRIBUTE41 | QP: Number | BT | UE |
LOGISTICS | Facility Dropoff Pallets | Facility Dropoff Pallets | PRICING_ATTRIBUTE42 | QP: Number | BT | UE |
LOGISTICS | Facility Dropoff Volume | Facility Dropoff Volume | PRICING_ATTRIBUTE40 | QP: Number | BT | UE |
LOGISTICS | Facility Dropoff Weight | Facility Dropoff Weight | PRICING_ATTRIBUTE39 | QP: Number | BT | UE |
LOGISTICS | Facility Handling Containers | Facility Handling Containers | PRICING_ATTRIBUTE45 | QP: Number | BT | UE |
LOGISTICS | Facility Handling Pallets | Facility Handling Pallets | PRICING_ATTRIBUTE46 | QP: Number | BT | UE |
LOGISTICS | Facility Handling Volume | Facility Handling Volume | PRICING_ATTRIBUTE44 | QP: Number | BT | UE |
LOGISTICS | Facility Handling Weight | Facility Handling Weight | PRICING_ATTRIBUTE43 | QP: Number | BT | UE |
LOGISTICS | Facility Pickup Container | Facility Pickup Container | PRICING_ATTRIBUTE37 | QP: Number | BT | UE |
LOGISTICS | Facility Pickup Pallets | Facility Pickup Pallets | PRICING_ATTRIBUTE38 | QP: Number | BT | UE |
LOGISTICS | Facility Pickup Volume | Facility Pickup Volume | PRICING_ATTRIBUTE36 | QP: Number | BT | UE |
LOGISTICS | Facility Pickup Weight | Facility Pickup Weight | PRICING_ATTRIBUTE35 | QP: Number | BT | UE |
LOGISTICS | Group Amount | Group Amount | PRICING_ATTRIBUTE5 | QP: Number | BT | UE |
LOGISTICS | Group Quantity | Group Quantity | PRICING_ATTRIBUTE4 | QP: Number | BT | UE |
LOGISTICS | Item Amount | Item Amount | PRICING_ATTRIBUTE12 | QP: Number | LN | UE |
LOGISTICS | Item Quantity | Item Quantity | PRICING_ATTRIBUTE10 | QP: Number | LN | UE |
LOGISTICS | TL Charged Out of Route Distance | TL Charged Out of Route Distance | PRICING_ATTRIBUTE22 | QP: Number | BT | UE |
LOGISTICS | TL Dropoff Containers | TL Dropoff Containers | PRICING_ATTRIBUTE31 | QP: Number | BT | UE |
LOGISTICS | TL Dropoff Pallets | TL Dropoff Pallets | PRICING_ATTRIBUTE32 | QP: Number | BT | UE |
LOGISTICS | TL Dropoff Volume | TL Dropoff Volume | PRICING_ATTRIBUTE30 | QP: Number | BT | UE |
LOGISTICS | TL Dropoff Weight | TL Dropoff Weight | PRICING_ATTRIBUTE29 | QP: Number | BT | UE |
LOGISTICS | TL Handling Volume | TL Handling Volume | PRICING_ATTRIBUTE34 | QP: Number | BT | UE |
LOGISTICS | TL Handling Weight | TL Handling Weight | PRICING_ATTRIBUTE33 | QP: Number | BT | UE |
LOGISTICS | TL Number Of Stops | TL Number Of Stops | PRICING_ATTRIBUTE21 | QP: Number | BT | UE |
LOGISTICS | TL Number of Weekday Layovers | TL Number of Weekday Layovers | PRICING_ATTRIBUTE23 | QP: Number | BT | UE |
LOGISTICS | TL Pickup Containers | TL Pickup Containers | PRICING_ATTRIBUTE27 | QP: Number | BT | UE |
LOGISTICS | TL Pickup Pallets | TL Pickup Pallets | PRICING_ATTRIBUTE28 | QP: Number | BT | UE |
LOGISTICS | TL Pickup Volume | TL Pickup Volume | PRICING_ATTRIBUTE26 | QP: Number | BT | UE |
LOGISTICS | TL Pickup Weight | TL Pickup Weight | PRICING_ATTRIBUTE25 | QP: Number | BT | UE |
LOGISTICS | TL Weekend Layover Mileage | TL Weekend Layover Mileage | PRICING_ATTRIBUTE24 | QP: Number | BT | UE |
LOGISTICS | Total Item Quantity | Total Item Quantity | PRICING_ATTRIBUTE20 | QP: Number | LN | UE |
Product Attributes
This table displays the seeded product attributes for the Logistics PTE:
Context | Attribute | Attrib Description | Mapped Value | Value Set Name | Lvl | AMM |
---|---|---|---|---|---|---|
ITEM | All Items | All Items | PRICING_ATTRIBUTE3 | QP:ITEM_ALL | LN | UE |
Qualifier Attributes
This table displays the seeded qualifier attributes for the Logistics PTE:
Context | Attribute | Attrib Description | Mapped Value | Value Set Name | Lvl | AMM |
---|---|---|---|---|---|---|
LOGISTICS | Additional Service | Additional Service | QUALIFIER_ATTRIBUTE8 | QP_ADDITIONAL_SERVICE | LN | UE |
LOGISTICS | Contract Reference | Contract Reference | QUALIFIER_ATTRIBUTE4 | QP_LANE_CONTRACT_REFERENCE | LN | UE |
LOGISTICS | Contracted Lane | Contracted Lane | QUALIFIER_ATTRIBUTE9 | QP: Yes/No | LN | UE |
LOGISTICS | Destination | Destination | QUALIFIER_ATTRIBUTE6 | QP: Number | LN | UE |
LOGISTICS | Mode of Transportation | Mode of Transportation | QUALIFIER_ATTRIBUTE7 | QP: Text | LN | UE |
LOGISTICS | Origin | Origin | QUALIFIER_ATTRIBUTE5 | QP: Number | LN | UE |
LOGISTICS | Service Type | Service Type | QUALIFIER_ATTRIBUTE10 | QP: Text | LN | UE |
MODLIST | List Line Number | Used in conjunction with Promotion No attribute, identifies Modifier Line Number for applying Ask For Promotion | QUALIFIER_ATTRIBUTE2 | QP_SRS_LIST_LN_NUMBER | LN | UE |
MODLIST | Price List | Price List | QUALIFIER_ATTRIBUTE4 | QP_SRS_PRICE_LIST_NAME | LN | UE |
MODLIST | Promotion No | Promotion Number for applying Ask for Promotions | QUALIFIER_ATTRIBUTE1 | QP_SRS_PROMOTION_NO | BT | UE |
ORDER | Sales Agreement Number | Sales Agreement Number | QUALIFIER_ATTRIBUTE3 | QP_BLANKET_NUMBER | LN | UE |
PARTY | Buyer | Buyer Party | QUALIFIER_ATTRIBUTE2 | QP_PARTY | LN | UE |
PARTY | SALES ORGANIZATION | Selling Operating Unit | QUALIFIER_ATTRIBUTE3 | QP_SALES_ORGANIZATION | LN | UE |
PARTY | Supplier | Supplier Party | QUALIFIER_ATTRIBUTE1 | QP_PARTY | LN | UE |
The following section displays the attributes for the Order Fulfillment PTE.
Pricing Attributes
The following table lists the seeded pricing attributes for the Order Fulfillment PTE:
Context | Attribute | Attrib Description | Mapped Value | Value Set Name | Lvl | AMM |
---|---|---|---|---|---|---|
BREAK_UOM | Usage UOM | Unit of Measure for usage-based pricing. This attribute is used to prorate price breaks. Currently, only supported for Oracle Service Contracts integration.1 | PRICING_ATTRIBUTE1 | -- | LN | AM |
OTA | Number of students | Number of students | PRICING_ATTRIBUTE1 | QP: Integer | LN | UE |
PERIODICITY | Charge Periodicity | Charge periodicity for a recurring charge line such as Yearly, Monthly, Weekly.2 | PRICING_ATTRIBUTE1 | QP_CHARGE_PERIODICITY | LN | AM |
PRICING ATTRIBUTE | Administration Cost | Used in cost to charge conversion formulas. | PRICING_ATTRIBUTE17 | QP: Number | LN | AM |
PRICING ATTRIBUTE | Customer Item | Customer Item | PRICING_ATTRIBUTE11 | -- | LN | AM |
PRICING ATTRIBUTE | Duty Cost | Used in cost to charge conversion formulas. | PRICING_ATTRIBUTE15 | QP: Number | LN | AM |
PRICING ATTRIBUTE | Estimated Transportation Charge | Used in cost to charge conversion formulas. | PRICING_ATTRIBUTE24 | QP: Number | LN | AM |
PRICING ATTRIBUTE | Estimated Transportation Price | Used in cost to charge conversion formulas. | PRICING_ATTRIBUTE23 | QP: Number | LN | AM |
PRICING ATTRIBUTE | Export Cost | Used in cost to charge conversion formulas. | PRICING_ATTRIBUTE14 | QP: Number | LN | AM |
PRICING ATTRIBUTE | Freight Cost | Can be used in cost to charge conversion formulas. | PRICING_ATTRIBUTE16 | QP: Number | LN | AM |
PRICING ATTRIBUTE | Grade | Grade for Process Items | PRICING_ATTRIBUTE19 | OPM_QC_GRADE | LN | AM |
PRICING ATTRIBUTE | Handling Cost | Can be used in cost to charge conversion formulas. | PRICING_ATTRIBUTE13 | QP: Number | LN | AM |
PRICING ATTRIBUTE | Insurance Cost | Can be used in cost to charge conversion formulas. | PRICING_ATTRIBUTE12 | QP: Number | LN | AM |
PRICING ATTRIBUTE | Model Id | For a line in a configuration, this attribute identifies the item on the top model line | PRICING_ATTRIBUTE1 | QP_MODEL_ITEM_ID | LN | AM |
PRICING ATTRIBUTE | Parent List Price | Attribute is applicable only to service items to determine the list price of product parent line that the service is for. | PRICING_ATTRIBUTE10 | QP: Number | LN | AM |
PRICING ATTRIBUTE | Transportation Charge | Transportation Charge | PRICING_ATTRIBUTE21 | QP: Number | LN | AM |
PRICING ATTRIBUTE | Transportation Price | Transportation Price | PRICING_ATTRIBUTE20 | QP: Number | LN | AM |
QP_INTERNAL | List Line Id | Used for price locking to ensure that the price specified on Sales Agreement or Service Contract is applied and only to transactions referencing that agreement/contract. | PRICING_ATTRIBUTE1 | QP: Integer | LN | AM |
VOLUME | Sales Agreement Amount | Released Amount from Sales Agreement Header | PRICING_ATTRIBUTE6 | QP: Number | LN | AM |
VOLUME | Sales Agreement Line Amount | Released Amount from Sales Agreement Line | PRICING_ATTRIBUTE7 | QP: Number | LN | AM |
VOLUME | Sales Agreement Line Quantity | Released Quantity from Sales Agreement Line | PRICING_ATTRIBUTE8 | QP: Number | LN | AM |
VOLUME | Item Amount | Item Amount is calculated as Quantity Unit multiplied by List Price. This value is sourced by pricing engine at run-time. | PRICING_ATTRIBUTE12 | QP: Number | LN | UE |
VOLUME | Item Quantity | This value is sourced by pricing engine at run-time. | PRICING_ATTRIBUTE10 | QP: Number | LN | UE |
VOLUME | Period1 Item Amount | Item amount ordered by the customer in Period 1.3 | PRICING_ATTRIBUTE13 | QP: Number | LN | AM |
VOLUME | Period1 Item Quantity | Item quantity ordered by the customer in Period 1.3 | PRICING_ATTRIBUTE3 | QP: Number | LN | AM |
VOLUME | Period2 Item Amount | Item amount ordered by the customer in Period 2.3 | PRICING_ATTRIBUTE14 | QP: Number | LN | AM |
VOLUME | Period2 Item Quantity | Item quantity ordered by the customer in Period 2. 3 | PRICING_ATTRIBUTE1 | QP: Number | LN | AM |
VOLUME | Period3 Item Amount | Item amount ordered by the customer in Period 3.3 | PRICING_ATTRIBUTE15 | QP: Number | LN | AM |
VOLUME | Period3 Item Quantity | Item quantity ordered by the customer in Period 3.3 | PRICING_ATTRIBUTE11 | QP: Number | LN | AM |
For more information, see Oracle Advanced Pricing Implementation Guide.
For more information, see Oracle Advanced Pricing Implementation Guide, Recurring Charges.
For more information, Oracle Advanced Pricing Implementation Guide and Oracle Advanced Pricing User's Guide, Cross Order Volume sections.
Product Attributes
The following section displays the product attributes for the Order Fulfillment PTE:
Context | Attribute | Attrib Description | Mapped Value | Value Set Name | Lvl | AMM |
---|---|---|---|---|---|---|
ITEM | All Items | Use this attribute if price list or price modifier should be available to All Items. | PRICING_ATTRIBUTE3 | QP:ITEM_ALL | LN | AM |
ITEM | Item Category | Item Category, derived from Item setup in Oracle Inventory. Use this attribute if price list or price modifier should be available to items within the Item Category. | PRICING_ATTRIBUTE2 | QP_ITEM_CATEGORIES | LN | AM |
ITEM | Item Number | Item Number | PRICING_ATTRIBUTE1 | -- | LN | AM |
ITEM | SEGMENT_1 - SEGMENT_20 | Segments 1-20 from the Inventory Item key flexfield. | PRICING_ATTRIBUTE4 | -- | LN | AM |
ITEM | iStore Section | Sections in Oracle Istore that contain the order item. | PRICING_ATTRIBUTE24 | AMS_ISTORE_SECTION | LN | AM |
Qualifier Attributes
The following section displays the seeded qualifier attributes for the Order Fulfillment PTE:
Context | Attribute | Attribute Description | Mapped Value | Value Set Name | Lvl | AMM |
---|---|---|---|---|---|---|
ASOPARTYINFO | Bill to Party Site | Bill To Party Site | QUALIFIER_ATTRIBUTE11 | QP_SHIP_TO_PARTY_SITE | BT | AM |
ASOPARTYINFO | Customer Party | Customer Party | QUALIFIER_ATTRIBUTE1 | QP_CUSTOMER_PARTY | BT | AM |
ASOPARTYINFO | Ship to Party Site | Ship To Party Site | QUALIFIER_ATTRIBUTE10 | QP_SHIP_TO_PARTY_SITE | BT | AM |
CUSTOMER | Account Type | Customer Profile Class - derived from Customer Account setup in Oracle TCA | QUALIFIER_ATTRIBUTE12 | QP_ACCOUNT_TYPE | BT | AM |
CUSTOMER | Agreement Name | Pricing Agreement Name | QUALIFIER_ATTRIBUTE7 | QP_AGREEMENT_NAME | BT | AM |
CUSTOMER | Agreement Type | Pricing Agreement Type - derived from Pricing Agreement setup | QUALIFIER_ATTRIBUTE8 | QP_AGREEMENT_TYPE | BT | AM |
CUSTOMER | Bill To | Bill To Location | QUALIFIER_ATTRIBUTE14 | QP_INVOICE_TO_ORGS | BT | AM |
CUSTOMER | Customer Class | Customer Class - derived from Customer Account set up in Oracle TCA. | QUALIFIER_ATTRIBUTE1 | QP_CUSTOMER_CLASS | BT | AM |
CUSTOMER | Customer Name | Customer Name | QUALIFIER_ATTRIBUTE2 | QP_CUSTOMERS | BT | AM |
CUSTOMER | End Customer Name | End Customer Name | QUALIFIER_ATTRIBUTE20 | QP_CUSTOMERS | LN | AM |
CUSTOMER | GSA | Identifies if this is a GSA customer - derived from Customer Account setup in Oracle TCA.1 | QUALIFIER_ATTRIBUTE15 | QP: Yes/No | BT | AM |
CUSTOMER | Invoice To Party Site | Same as Bill To Party Site attribute under Party qualifier context. This attribute (unlike Party qualifier context) is also mapped for Order Management (OM) request type. Use this attribute to have the qualifier apply to orders for OM request type. | QUALIFIER_ATTRIBUTE18 | QP_INVOICE_TO_PARTY_SITE_ID | BT | AM |
CUSTOMER | Party ID | Same as Customer Party attribute under Party qualifier context. This attribute (unlike Party qualifier context) is also mapped for OM request type. Use this attribute to have the qualifier apply to orders for OM request type. | QUALIFIER_ATTRIBUTE16 | QP_PARTY | BT | AM |
CUSTOMER | Sales Channel | Sales Channel | QUALIFIER_ATTRIBUTE13 | QP_SALES_CHANNEL_CODE | BT | AM |
CUSTOMER | Ship To Party Site | Same as Ship To Party Site attribute under Party qualifier context. This attribute (unlike Party qualifier context) is also mapped for OM request type. Use this attribute to have the qualifier apply to orders for OM request type. | QUALIFIER_ATTRIBUTE17 | QP_SHIP_TO_PARTY_SITE_ID | BT | AM |
CUSTOMER | Ship To | Ship To Location | QUALIFIER_ATTRIBUTE11 | QP_SHIP_TO_ORGS | BT | AM |
CUSTOMER | Customer Account Site | Sources both ship to location and bill to location. Use this attribute if a pricing qualifier should be applicable when the account site is either ship to location or bill to location on the order. Use this method rather than create two qualifiers, one each for the ship to location attribute and bill to location attribute. | QUALIFIER_ATTRIBUTE5 | QP_CUSTOMER_SITES | BT | AM |
CUSTOMER_GROUP | Buying Groups | Buying Groups that Customer or Customer Party belongs to. This is based on setups in Oracle Marketing. | QUALIFIER_ATTRIBUTE3 | AMS_BUYING_GROUP | BT | AM |
CUSTOMER_GROUP | Lists | Marketing Lists that Customer or Customer Party belongs to. This is based on setups in Oracle Marketing. | QUALIFIER_ATTRIBUTE1 | AMS_LISTS | BT | AM |
CUSTOMER_GROUP | Segments | Marketing Segments that Customer or Customer Party belongs to. This is based on setups in Oracle Marketing. | QUALIFIER_ATTRIBUTE2 | AMS_SEGMENTS | BT | AM |
MODLIST | Coupon Number | Coupon Number for applying Coupon Modifier | QUALIFIER_ATTRIBUTE3 | QP_SRS_COUPON_NO | BT | UE |
MODLIST | List Line Number | Used in conjunction with Promotion No (number) attribute, identifies Modifier Line Number for applying Ask For Promotion. | QUALIFIER_ATTRIBUTE2 | QP_SRS_LIST_LN_NUMBER | LN | UE |
MODLIST | Price List | This qualifier is used when a modifier should apply only if a specific price list is used. | QUALIFIER_ATTRIBUTE4 | QP_SRS_PRICE_LIST_NAME | BT | AM |
MODLIST | Promotion No | Promotion Number for applying Ask for Promotion | QUALIFIER_ATTRIBUTE1 | QP_SRS_PROMOTION_NO | BT | UE |
ORDER | Customer PO | Customer PO Number | QUALIFIER_ATTRIBUTE12 | QP_CUSTOMER_PO | BT | AM |
ORDER | Freight Cost Type Code | Identifies cost types with associated costs for the order line. Oracle Order Management gets cost/charge information at time of shipping and stores this in price adjustment tables with list line type code of COST. | QUALIFIER_ATTRIBUTE20 | QP_FREIGHT_COST_TYPE | LN | AM |
ORDER | Line Category | Line Category - Order or Return | QUALIFIER_ATTRIBUTE19 | QP_LN_CATEGORY | LN | AM |
ORDER | Line Type | Transaction type for the order line | QUALIFIER_ATTRIBUTE2 | QP_LN_TYPE | LN | AM |
ORDER | Order Category | Order Category - Order, Return or Mixed | QUALIFIER_ATTRIBUTE13 | QP_ORDER_CATEGORY | BT | AM |
ORDER | Order Date | Order Date | QUALIFIER_ATTRIBUTE1 | QP: Date | BT | AM |
ORDER | Order Type | Transaction type for the order header | QUALIFIER_ATTRIBUTE9 | QP_ORDER_TYPES_ALL | BT | AM |
ORDER | Pricing Date | Pricing Date | QUALIFIER_ATTRIBUTE14 | QP: Date | BT | AM |
ORDER | Quote Source Code | Quote Source Code | QUALIFIER_ATTRIBUTE4 | -- | OR | AM |
ORDER | Request Date | Request Date | QUALIFIER_ATTRIBUTE17 | QP: Date | BT | AM |
ORDER | Sales Agreement ID | Sales Agreement | QUALIFIER_ATTRIBUTE5 | QP_BLANKET_HEADER_ID | BT | AM |
ORDER | Sales Agreement Line Number | Sales Agreement Line Number | QUALIFIER_ATTRIBUTE6 | QP_BLANKET_LN_ID | LN | AM |
ORDER | Sales Order Number | Sales Order Number | QUALIFIER_ATTRIBUTE21 | QP_SALES_ORDER_NUMBER | BT | AM |
ORDER | Ship From | Ship From Location (also referred to as Warehouse) | QUALIFIER_ATTRIBUTE18 | QP_SHIP_FROM | BT | AM |
ORDER | Shipment Priority Code | Shipment Priority Code | QUALIFIER_ATTRIBUTE16 | QP_SHIPMENT_PRIORITY | BT | AM |
ORDER | Shippable Flag | Identifies if the item is shippable. | QUALIFIER_ATTRIBUTE10 | QP: Yes/No | BT | AM |
ORDER | Shipped Date | Shipped Date | QUALIFIER_ATTRIBUTE8 | QP: Date | BT | AM |
ORDER | Shipped Flag | Identifies if the item has been shipped | QUALIFIER_ATTRIBUTE11 | QP: Yes/No | LN | AM |
ORDER | Source Type | External (for drop ship order lines) or Internal | QUALIFIER_ATTRIBUTE15 | QP_SOURCE_TYPE | LN | AM |
PARTY | Buyer | Buyer Party | QUALIFIER_ATTRIBUTE2 | QP_PARTY | LN | UE |
PARTY | SALES ORGANIZATION | Selling Operating Unit | QUALIFIER_ATTRIBUTE3 | QP_SALES_ORGANIZATION | BT | AM |
PARTY | Supplier | Supplier Party | QUALIFIER_ATTRIBUTE1 | QP_PARTY | LN | UE |
SEGMENT | Target Segment | Target Segment | QUALIFIER_ATTRIBUTE2 | -- | BT | AM |
SOLD_BY | Distributor List | Oracle Trade Management tracks sales from distributors to retailers, also called indirect sales. Distributor List allows for offers to be targeted to indirect sales from certain distributors.2 | QUALIFIER_ATTRIBUTE3 | AMS_LISTS | BT | AM |
SOLD_BY | Distributor Name | Enables offers to be targeted to indirect sales from a specific distributor.2 | QUALIFIER_ATTRIBUTE2 | QP_CUSTOMERS | BT | AM |
SOLD_BY | Distributor Segment | Segments that the distributor belongs to.2 | QUALIFIER_ATTRIBUTE4 | AMS_SEGMENTS | BT | AM |
SOLD_BY | Distributor Territory | Territories that the distributor belongs to.2 | QUALIFIER_ATTRIBUTE5 | AMS_TM_OFFER_TERRITORIES | BT | AM |
SOLD_BY | Sales Method | Use this attribute if offer is to be extended only to direct or only to indirect sales.2 | QUALIFIER_ATTRIBUTE1 | OZF_SALES_METHOD | BT | AM |
STORE | MINISITE_ID | Minisite ID for orders placed from Oracle Istore | QUALIFIER_ATTRIBUTE1 | QP_IBE_MINISITES | BT | AM |
TERMS | Freight Terms | Freight Terms | QUALIFIER_ATTRIBUTE10 | QP_FREIGHT_TERMS | BT | AM |
TERMS | Payment Terms | Payment Terms | QUALIFIER_ATTRIBUTE1 | QP_PAYMENT_TERMS | BT | AM |
TERMS | Shipping Method | Shipping Method | QUALIFIER_ATTRIBUTE11 | QP_SHIP_METHODS | BT | AM |
TERRITORY | Sales Territories | Sales territories in Oracle Territory Manager that the customer belongs to.3 | QUALIFIER_ATTRIBUTE2 | AMS_SALES_ACCT_TERRITORIES | BT | AM |
TERRITORY | Trade Management Territories | Trade Management Territories | QUALIFIER_ATTRIBUTE1 | AMS_TM_OFFER_TERRITORIES | BT | AM |
VOLUME | Line Volume | The volume is derived by converting line item quantity from order line UOM to volume UOM specified in profile QP: Line Volume UOM Code.4 | QUALIFIER_ATTRIBUTE15 | QP: Number | LN | AM |
VOLUME | Line Weight | The line weight is derived by converting line item quantity from order line UOM to weight UOM specified in profile QP: Line Weight UOM Code.4 | QUALIFIER_ATTRIBUTE14 | QP: Number | BT | AM |
VOLUME | Order Amount | Sum of unit list price times quantity on all order lines for the current order being priced. This calculation excludes return lines and recurring charge lines.5 | QUALIFIER_ATTRIBUTE10 | QP: Number | BT | AM |
VOLUME | Order Volume | Total volume of all order lines on the order, derived by converting each line quantity from order line UOM to volume UOM specified in profile QP: Line Volume UOM Code and then adding up line quantities in this volume UOM.4 | QUALIFIER_ATTRIBUTE17 | QP: Number | OR | AM |
VOLUME | Order Weight | Total weight of all order lines on the order, derived by converting each line quantity from order line UOM to weight UOM specified in profile QP: Line Weight UOM Code and then adding up line quantities in this weight UOM.4 | QUALIFIER_ATTRIBUTE16 | QP: Number | OR | AM |
VOLUME | Period1 Order Amount | Amount ordered (across all items) by a customer in Period 1.4 | QUALIFIER_ATTRIBUTE12 | QP: Number | BT | AM |
VOLUME | Period2 Order Amount | Amount ordered (across all items) by a customer in Period 2.69 | QUALIFIER_ATTRIBUTE13 | QP: Number | BT | AM |
VOLUME | Period3 Order Amount | Amount ordered (across all items) by a customer in Period 3.6 | QUALIFIER_ATTRIBUTE11 | QP: Number | BT | AM |
For more information on GSA Pricing, see Oracle Advanced Pricing Implementation Guide and Oracle Advanced Pricing User's Guide.
For more information, see Oracle Trade Management documentation.
For more information, see Oracle Territory Manager documentation.
For more information, see Oracle Advanced Pricing Implementation Guide, Profile Options.
For more information, see Oracle Advanced Pricing Implementation Guide, Recurring Charges.
For more information, see Oracle Advanced Pricing Implementation Guide and Oracle Advanced Pricing User's Guide, Cross Order Volume sections.
The following section displays the attributes for the Procurement (PO) PTE.
Pricing Attributes
The following table lists the seeded pricing attributes for the Procurement PTE:
Context | Context Type | Attribute | Attrib Description | Mapped Value | Value Set Name | Lvl | AMM |
---|---|---|---|---|---|---|---|
PO_PRICING_ATTRIBUTES | PRICING_ATTRIBUTE | Destination Organization | Destination organization for the shipment line | PRICING_ATTRIBUTE13 | - | LN | AM |
PO_PRICING_ATTRIBUTES | PRICING_ATTRIBUTE | Hazardous Material Class | Hazardous Material Class | PRICING_ATTRIBUTE9 | - | LN | AM |
PO_PRICING_ATTRIBUTES | PRICING_ATTRIBUTE | Hazardous Material Code | Hazardous Material Code | PRICING_ATTRIBUTE10 | - | LN | AM |
PO_PRICING_ATTRIBUTES | PRICING_ATTRIBUTE | Item Revision | Item Revision | PRICING_ATTRIBUTE2 | QP: Text | LN | AM |
PO_PRICING_ATTRIBUTES | PRICING_ATTRIBUTE | PO Agreement Line Number | Source Document Line Reference on Requisition or PO Line. Value is dependent on PO Agreement Number. | PRICING_ATTRIBUTE6 | QP_PO_AGREEMENT_LN_NUM | LN | AM |
PO_PRICING_ATTRIBUTES | PRICING_ATTRIBUTE | PO Vendor Item Number | Supplier Item Number on Requisition or PO Line | PRICING_ATTRIBUTE1 | QP: Text | LN | AM |
PO_PRICING_ATTRIBUTES | PRICING_ATTRIBUTE | Primary Unit of Measure | Primary unit of measure for the shipment line | PRICING_ATTRIBUTE12 | -- | LN | AM |
PO_PRICING_ATTRIBUTES | PRICING_ATTRIBUTE | Purchasing Org | Operating Unit in which Requisition or Purchase Order was created. | PRICING_ATTRIBUTE3 | QP_PO_ORG | OR | AM |
PO_PRICING_ATTRIBUTES | PRICING_ATTRIBUTE | Ship To Location | Deliver-To Location on the Requisition OR Default Ship-To Location on PO Header OR Ship-To Location on PO Shipment. | PRICING_ATTRIBUTE5 | QP_PO_SHIP_TO_LOCATION | LN | AM |
PO_PRICING_ATTRIBUTES | PRICING_ATTRIBUTE | Ship To Org | Can be one of the following:
|
PRICING_ATTRIBUTE4 | QP_PO_SHIP_TO_ORG | LN | AM |
PO_PRICING_ATTRIBUTES | PRICING_ATTRIBUTE | Shipment Header Identifier | Shipment Header ID | PRICING_ATTRIBUTE7 | -- | LN | AM |
PO_PRICING_ATTRIBUTES | PRICING_ATTRIBUTE | Shipment Line Identifier | Shipment Line ID | PRICING_ATTRIBUTE8 | -- | LN | AM |
VOLUME | PRICING_ATTRIBUTE | Item Amount | Item Amount is calculated as Quantity times Unit List Price. This value is sourced by pricing engine at run-time. | PRICING_ATTRIBUTE12 | QP: Number | LN | UE |
VOLUME | PRICING_ATTRIBUTE | Item Quantity | Item Quantity. This value is sourced by pricing engine at run-time. | PRICING_ATTRIBUTE10 | QP: Number | LN | UE |
Product Attributes
The following table lists the seeded product attributes for the Procurement PTE:
Context | Attribute | Attrib Description | Mapped Value | Value Set Name | Lvl | AMM |
---|---|---|---|---|---|---|
ITEM | All Items | Use this attribute if price list or price modifier should be available to All Items. | PRICING_ATTRIBUTE3 | QP:ITEM_ALL | LN | AM |
ITEM | Item Category | Item Category, derived from Item setup in Oracle Inventory. Use this attribute if price list or price modifier should be available to items within the Item Category. | PRICING_ATTRIBUTE2 | QP_ITEM_CATEGORIES | LN | AM |
ITEM | Item Number | Item Number | PRICING_ATTRIBUTE1 | LN | AM |
Qualifier Attributes
The following table lists the seeded qualifier attributes for the Procurement PTE:
Context | Attribute | Attrib Description | Mapped Value | Value Set Name | Lvl | AMM |
---|---|---|---|---|---|---|
PO_BUYER | PO Agreement Number | Contract or Blanket Agreement Number | QUALIFIER_ATTRIBUTE2 | QP_PO_AGREEMENT_NUMBER | LN | AM |
PO_BUYER | PO Agreement Type | Contract or Blanket Agreement | QUALIFIER_ATTRIBUTE1 | QP_PO_AGREEMENT_TYPE | LN | AM |
PO_BUYER | PO Ship To Location | Deliver-To Location on the Requisition OR Default Ship-To Location on PO Header OR Ship-To Location on PO Shipment | QUALIFIER_ATTRIBUTE4 | QP_PO_SHIP_TO_LOCATION | BT | AM |
PO_BUYER | PO Ship To Org | Can be one of the following:
|
QUALIFIER_ATTRIBUTE3 | QP_PO_SHIP_TO_ORG | BT | AM |
PO_OR | PO Creation Date | Requisition or PO Creation Date | QUALIFIER_ATTRIBUTE2 | QP: Date | OR | AM |
PO_OR | PO Need By Date | Need-By Date on the Requisition Line OR Need-By Date on the PO Line OR Need-By Date on the PO Shipment | QUALIFIER_ATTRIBUTE4 | QP: Date | LN | AM |
PO_OR | PO Order Type | Requisition or Standard Purchase Order | QUALIFIER_ATTRIBUTE3 | QP_PO_OR_TYPE | OR | AM |
PO_OR | Shipment number | Shipment Number | QUALIFIER_ATTRIBUTE6 | -- | OR | AM |
PO_OR | Source Document Code | Source Document Code for the Shipment | QUALIFIER_ATTRIBUTE5 | -- | LN | AM |
PO_OR | Source Organization | Source organization associated with the shipment line | QUALIFIER_ATTRIBUTE1 | -- | OR | AM |
PO_SUPPLIER | Carrier Name | Carrier Name for the shipment line | QUALIFIER_ATTRIBUTE3 | -- | OR | AM |
PO_SUPPLIER | PO Vendor Site | Supplier Site | QUALIFIER_ATTRIBUTE2 | QP_PO_VENDOR_SITE | BT | AM |
PO_SUPPLIER | PO Vendor | Supplier | QUALIFIER_ATTRIBUTE1 | QP_PO_VENDOR | BT | AM |
RCV_RECEIPT | Carrier transportation method code | Transportation Method Code for the shipment line | QUALIFIER_ATTRIBUTE1 | -- | OR | AM |
RCV_RECEIPT | Expected arrival date | Expected arrival date | QUALIFIER_ATTRIBUTE2 | -- | OR | AM |
RCV_RECEIPT | Shipment Header Identifier | Shipment Header ID | QUALIFIER_ATTRIBUTE5 | -- | OR | AM |
RCV_RECEIPT | Shipment packaging code | Shipment packaging code | QUALIFIER_ATTRIBUTE3 | -- | OR | AM |
RCV_RECEIPT | Shipping Date | Shipping date | QUALIFIER_ATTRIBUTE4 | -- | OR | AM |
TERMS | Freight Terms | Freight terms for the shipment line | QUALIFIER_ATTRIBUTE10 | QP_FREIGHT_TERMS | OR | AM |