Attribute Seed Data

Overview of Attribute Seed Data

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
  • LN: Line

  • BT: Both (Means at both the Line and Order levels)

  • OR: Order

ONT Order Management
OKC Oracle Contracts Core
Prec Precedence
Req Type Request Type
UE User Entered
No value/not applicable

Complex Maintenance Repair and Overhaul PTE Attributes

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.

Demand Planning PTE 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

Intercompany Transaction PTE Attributes

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

Logistics PTE Attributes

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

Order Fulfillment PTE Attributes

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
  1. For more information, see Oracle Advanced Pricing Implementation Guide.

  2. For more information, see Oracle Advanced Pricing Implementation Guide, Recurring Charges.

  3. 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
  1. For more information on GSA Pricing, see Oracle Advanced Pricing Implementation Guide and Oracle Advanced Pricing User's Guide.

  2. For more information, see Oracle Trade Management documentation.

  3. For more information, see Oracle Territory Manager documentation.

  4. For more information, see Oracle Advanced Pricing Implementation Guide, Profile Options.

  5. For more information, see Oracle Advanced Pricing Implementation Guide, Recurring Charges.

  6. For more information, see Oracle Advanced Pricing Implementation Guide and Oracle Advanced Pricing User's Guide, Cross Order Volume sections.

Procurement PTE Attributes

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:
  • Ship-To Organization on PO Shipment

  • Organization associated with the Ship-To Location on PO Header

  • Organization associated with the Ship-To Location in the Financial options

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:
  • Ship-To Organization on PO Shipment

  • Organization associated with the Ship-To Location on PO Header

  • Organization associated with the Ship-To Location in the Financial options

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