cgcloud__CP_Pricing_Condition_Stage__c

Staging table for conditions that complex pricing uses. This object is available in API version 54.0 and later.

Supported Calls 

create(), delete(), describeLayout(), describeSObjects(), getDeleted(), getUpdated(), query(), retrieve(), search(), undelete(), update(), upsert()

Fields 

Name 
  • Type: string
  • Properties: Autonumber, Defaulted on create, Filter, idLookup, Sort
  • Description: Name of this record.

OwnerId 

  • Type: reference

  • Properties: Create, Defaulted on create, Filter, Group, Sort, Update

  • Description: ID of the record owner.

    This is a polymorphic relationship field.

  • Relationship Name: Owner

  • Relationship Type: Lookup

  • Refers To: Group, User

cgcloud__Account_Set__c 

  • Type: reference

  • Properties: Create, Filter, Group, Nillable, Sort, Update

  • Description: Reference to Customer Set.

    This is a relationship field.

  • Relationship Name: cgcloud__Account_Set__r

  • Relationship Type: Lookup

  • Refers To: cgcloud__Account_Set__c

cgcloud__Account__c 

  • Type: reference

  • Properties: Create, Filter, Group, Nillable, Sort, Update

  • Description: Reference to Account.

    This is a relationship field.

  • Relationship Name: cgcloud__Account__r

  • Relationship Type: Lookup

  • Refers To: Account

cgcloud__Currency__c 

  • Type: picklist

  • Properties: Create, Filter, Group, Nillable, Restricted picklist, Sort, Update

  • Description: Currency of agreement.

  • Possible values:

    • CAD—Canadian Dollar
    • CHF—Swiss Franc
    • EUR—Euro
    • GBP—Pound Sterling
    • JPY—Yen
    • NOK—Norwegian Krone
    • RUB—Russian Currency
    • USD—US Dollar

cgcloud__Denominator__c 
  • Type: double
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: Defines a denominator for the condition.

cgcloud__External_Id__c 
  • Type: string
  • Properties: Create, Filter, Group, idLookup, Nillable, Sort, Update
  • Description: SAP or ERP Condition record number.

cgcloud__Key_10__c 
  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Key of the used Key Type.

cgcloud__Key_1__c 
  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Key of the used Key Type.

cgcloud__Key_2__c 
  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Key of the used Key Type.

cgcloud__Key_3__c 
  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Key of the used Key Type.

cgcloud__Key_4__c 
  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Key of the used Key Type.

cgcloud__Key_5__c 
  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Key of the used Key Type.

cgcloud__Key_6__c 
  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Key of the used Key Type.

cgcloud__Key_7__c 
  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Key of the used Key Type.

cgcloud__Key_8__c 
  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Key of the used Key Type.

cgcloud__Key_9__c 
  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Key of the used Key Type.

cgcloud__Key_Type__c 

  • Type: reference

  • Properties: Create, Filter, Group, Nillable, Sort, Update

  • Description: Reference to Key Type.

    This is a relationship field.

  • Relationship Name: cgcloud__Key_Type__r

  • Relationship Type: Lookup

  • Refers To: cgcloud__CP_Key_Type__c

cgcloud__Keys_Hash_Code__c 
  • Type: string
  • Properties: Create, Filter, Group, idLookup, Nillable, Sort, Update
  • Description: Hash code of all columns that can be used to build the merge key in the target table.

cgcloud__Logistic_Unit__c 

  • Type: picklist

  • Properties: Create, Filter, Group, Nillable, Restricted picklist, Sort, Update

  • Description: Condition unit.

  • Possible values:

    • ConsumerUnit—Consumer Unit
    • Layer
    • Pallet
    • SalesUnit—Sales Unit

cgcloud__Pricing_Condition_Template__c 

  • Type: reference

  • Properties: Create, Filter, Group, Nillable, Sort, Update

  • Description: Reference to Pricing Condition Template.

    This is a relationship field.

  • Relationship Name: cgcloud__Pricing_Condition_Template__r

  • Relationship Type: Lookup

  • Refers To: cgcloud__CP_Pricing_Condition_Template__c

cgcloud__Product__c 

  • Type: reference

  • Properties: Create, Filter, Group, Nillable, Sort, Update

  • Description: Reference to Product.

    This is a relationship field.

  • Relationship Name: cgcloud__Product__r

  • Relationship Type: Lookup

  • Refers To: Product2

cgcloud__Promotion__c 

  • Type: reference

  • Properties: Create, Filter, Group, Nillable, Sort, Update

  • Description: Reference to Promotion.

    This is a relationship field.

  • Relationship Name: cgcloud__Promotion__r

  • Relationship Type: Lookup

  • Refers To: cgcloud__Promotion__c

cgcloud__Reward__c 

  • Type: reference

  • Properties: Create, Filter, Group, Nillable, Sort, Update

  • Description: Reference to Reward.

    This is a relationship field.

  • Relationship Name: cgcloud__Reward__r

  • Relationship Type: Lookup

  • Refers To: cgcloud__Promotion_Reward__c

cgcloud__Sales_Org__c 

  • Type: picklist

  • Properties: Create, Filter, Group, Nillable, Restricted picklist, Sort, Update

  • Description: Describes the sales organization to which the key condition belongs.

  • Possible values:

    • 0000
    • 0001
    • 0002
    • 0003

cgcloud__Sort__c 
  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Controls the sequence of complex pricing conditions.

cgcloud__Status__c 

  • Type: picklist

  • Properties: Create, Filter, Group, Nillable, Restricted picklist, Sort, Update

  • Description: State of the pricing condition stage.

  • Possible values:

    • d
    • n
    • u

cgcloud__Threshold_Unit__c 

  • Type: picklist

  • Properties: Create, Filter, Group, Nillable, Restricted picklist, Sort, Update

  • Description: Unit for which thresholds (scales) are defined.

  • Possible values:

    • ConsumerUnit—Consumer Unit
    • Layer
    • Pallet
    • SalesUnit—Sales Unit

cgcloud__Valid_From__c 
  • Type: date
  • Properties: Create, Defaulted on create, Filter, Group, Nillable, Sort, Update
  • Description: Date from which the entry is valid.

cgcloud__Valid_Thru__c 
  • Type: date
  • Properties: Create, Defaulted on create, Filter, Group, Nillable, Sort, Update
  • Description: Date until which the entry is valid.

cgcloud__Value__c 
  • Type: double
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: Condition value (amount or percentage).

Associated Objects 

Associated Objects 

This object has these following associated objects. If the API version isn’t specified, they are available in the same API versions as this object. Otherwise, they are available in the specified API version and later.

Get Started with Consumer Goods Cloud
Retail Execution
Standard Objects for Retail Execution
Associated Objects for Retail Execution
Custom Objects for Retail Execution
cgcloud__Account_Receivable__c
cgcloud__Account_Sales_Data__c
cgcloud__Account_Specific_Product_Condition__c
cgcloud__Account_Task__c
cgcloud__Account_Task_Template__c
cgcloud__Account_Visit_Setting__c
cgcloud__Asset_Audit__c
cgcloud__Asset_Template__c
cgcloud__Approval_Code__c
cgcloud__Batch_Last_Successful_Run__c
cgcloud__Batch_Process_Configuration__c
cgcloud__Color_Schema__c
cgcloud__BO_API__c
cgcloud__BO_API_Entity__c
cgcloud__BO_API_Output_Entity__c
cgcloud__BO_API_Step_Input_Structure__c
cgcloud__BO_API_Transaction_Log__c
cgcloud__BO_API_Workflow__c
cgcloud__BO_API_Workflow_Entity__c
cgcloud__BO_API_Workflow_Step__c
cgcloud__BO_API_Workflow_Workflow_Step__c
cgcloud__Consider_Default_SalesOrg__c
cgcloud__CP_Calculation_Schema__c
cgcloud__CP_Calculation_Schema_Determination__c
cgcloud__CP_Calculation_Schema_Step__c
cgcloud__CP_Key_Attribute__c
cgcloud__CP_Key_Type__c
cgcloud__CP_Pricing_Condition__c
cgcloud__CP_Pricing_Condition_Scale_Stage__c
cgcloud__CP_Pricing_Condition_Stage__c
cgcloud__CP_Pricing_Condition_Template__c
cgcloud__CP_Search_Strategy__c
cgcloud__CP_Search_Strategy_Step__c
cgcloud__Data_Type__c
cgcloud__Data_Type_Option__c
cgcloud__Field_Sales_Activity__c
cgcloud__Flatten_Org_Unit_Hierarchy__c
cgcloud__Historic_Product__c
cgcloud__Inventory__c
cgcloud__Inventory_Control_Template__c
cgcloud__Inventory_Transaction__c
cgcloud__Inventory_Transaction_Template__c
cgcloud__Job_Definition_List__c
cgcloud__Job_Definition_List_Account__c
cgcloud__Job_Definition_List_Account_Set__c
cgcloud__Job_Definition_List_Product__c
cgcloud__Job_Definition_List_Template__c
cgcloud__Job_Definition_Template__c
cgcloud__Job_DL_Job_Definition_Template__c
cgcloud__Job_DL_Template_Def_Template__c
cgcloud__Job_List__c
cgcloud__Job_Template__c
cgcloud__Listing_Classification__c
cgcloud__Listing_Module__c
cgcloud__Mobile_Link__c
cgcloud__Order__c
cgcloud__Order_Item__c
cgcloud__Order_Item_Inventory_Transaction__c
cgcloud__Order_Item_Order_Template_Association__c
cgcloud__Order_Item_Rule__c
cgcloud__Order_Item_Template__c
cgcloud__Order_Payment__c
cgcloud__Order_Payment_Inventory_Transaction__c
cgcloud__Order_Payment_Template__c
cgcloud__Order_Template__c
cgcloud__Order_Template_Order_Payment_Template__c
cgcloud__Order_Template_Product_Selector_Group__c
cgcloud__Org_Unit__c
cgcloud__Org_Unit_Hierarchy__c
cgcloud__Org_Unit_User__c
cgcloud__Organization_Setting__c
cgcloud__Package_Setting__c
cgcloud__Picklist_Toggle_Addon__c
cgcloud__POS__c
cgcloud__POS_Template__c
cgcloud__Product_Condition__c
cgcloud__Product_Listing_Module__c
cgcloud__Product_Assortment_Order_Template__c
cgcloud__Product_Assortment_Store__c
cgcloud__Promotion_Hurdle__c
cgcloud__Promotion_Hurdle_Expression__c
cgcloud__Promotion_Reward__c
cgcloud__Promotion_Reward_Group__c
cgcloud__Promotion_Reward_Product__c
cgcloud__Promotion_Sales_Folder__c
cgcloud__Promotion_Store__c
cgcloud__Sales_Folder__c
cgcloud__Sales_Folder_Sell_Sheet__c
cgcloud__Sales_Folder_Template__c
cgcloud__Sell_Sheet__c
cgcloud__Signature__c
cgcloud__Signature_Attribute__c
cgcloud__Signature_Flow_Step__c
cgcloud__Signature_Template__c
cgcloud__Substitution__c
cgcloud__System_Number__c
cgcloud__System_Number_Last__c
cgcloud__System_Number_Segment__c
cgcloud__Trip_List__c
cgcloud__Trip_List_Account__c
cgcloud__Unit_of_Measure__c
cgcloud__User_Accountable__c
cgcloud__User_Document__c
cgcloud__User_Document_Activity__c
cgcloud__User_Document_Template__c
cgcloud__User_Document_Template_Activity__c
cgcloud__Visit_Job__c
cgcloud__Visit_Template__c
cgcloud__Warehouse__c
cgcloud__Warehouse_Product__c
cgcloud__Warehouse_User__c
cgcloud__Workflow__c
cgcloud__Workflow_State_Transition__c
Standard DLO to DMO Mappings
Retail Execution Standard Metadata APIs
Retail Order Customization
Sync Management
Direct Store Delivery
Einstein Visit and Activity Recommendation
Trade Promotion Management
Custom Objects for Retail Execution and Trade Promotion Management
Standard and Custom Objects for Future Use
API End-of-Life Policy
Previous Versions