cgcloud__Sales_Organization__c

This object stores the details of the Sales Organization. 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 

LastReferencedDate 
  • Type: dateTime
  • Properties: Filter, Nillable, Sort
  • Description: Most recent date on which a user referenced this record.

LastViewedDate 
  • Type: dateTime
  • Properties: Filter, Nillable, Sort
  • Description: Most recent date on which a user viewed this record.

Name 
  • Type: string
  • Properties: Create, Defaulted on create, Filter, Group, idLookup, Nillable, Sort, Update
  • Description: Unique identification of the 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__APM_Product_List_Relevant_Measures__c 

  • Type: multipicklist

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

  • Description: Stores the measure codes that are defined for the accountproductmeasure table.

  • Possible values:

    • BASP

cgcloud__Account_Number__c 
  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Account number at the bank.

cgcloud__Account_Product_List_Type__c 

  • Type: picklist

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

  • Description: Defines the Product List that’s to be used.

  • Default value: global

  • Possible values:

    • global
    • timedependent

cgcloud__Automatic_Promotion_Push__c 
  • Type: boolean
  • Properties: Create, Defaulted on create, Filter, Group, Sort, Update
  • Description: Activates the automatic push on leave of the promotion.
  • Default value: true

cgcloud__Available_Trade_Calendar_Color_Schemas__c 

  • Type: multipicklist

  • Properties: Create, Defaulted on create, Filter, Nillable, Restricted picklist, Update

  • Description: Property Based Coloring of Promotion Bars within the Trade Calendar.

  • Default value: 1

  • Possible values:

    • 1—Promotion Template
    • 2—Phase
    • 3—Custom 3
    • 4—Custom 4
    • 5—Custom 5

cgcloud__BIN__c 
  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Bank Identification Number.

cgcloud__Bank_Code__c 
  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Code of the bank.

cgcloud__Bank__c 
  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Bank that’s used for payments.

cgcloud__Business_Unit__c 
  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Reference to the book keeping segment.

cgcloud__City__c 
  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Name of the city.

cgcloud__Country__c 
  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Indicates the country.

cgcloud__Currency__c 

  • Type: picklist

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

  • Description: Currency of the sales organization.

  • Possible values:

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

cgcloud__Custom_Calendar__c 

  • Type: reference

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

  • Description: Reference to the custom calendar that’s used for the sales org.

    This is a relationship field.

  • Relationship Name: cgcloud__Custom_Calendar__r

  • Relationship Type: Lookup

  • Refers To: cgcloud__Custom_Calendar__c

cgcloud__DMI_Product_List_Relevant_Measures__c 

  • Type: multipicklist

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

  • Description: Stores measure codes that are defined for the daily measurement table.

  • Possible values:

    • DMI

cgcloud__DMR_Product_List_Relevant_Measures__c 

  • Type: multipicklist

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

  • Description: Stores measure codes that are defined for the dailymeasurereal table.

  • Possible values:

    • SHIP

cgcloud__Default_Mobility_Visit_Color__c 

  • Type: picklist

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

  • Description: Field to define the default color of visits on the calendar of a mobility device.

  • Default value: 0176D3

  • Possible values:

    • 003344
    • 008899
    • 0176D3
    • 20B2AA
    • 467596
    • 551155
    • 6495ED
    • 6688BB
    • 77AA99
    • 87CEEB
    • 87CEFA
    • 8FBC8F
    • AA1133
    • ADD8E6
    • B0C4DE
    • BBBB00
    • BC8F8F
    • D1DDEC
    • DAA520
    • DD4411
    • DDECD1
    • E9967A
    • EE9B38
    • EED2E0
    • F08080
    • F4A460
    • F7EBD9
    • FA8072
    • FF7F50
    • FFA07A
    • FFD700

cgcloud__Default_Price_List_Type__c 

  • Type: picklist

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

  • Description: Default price list type of the sales organization.

  • Possible values:

    • NotRelevant—Not Relevant
    • WS1999—Wholesaler
    • WS2000—Direct Customers

cgcloud__Default_Price_Type__c 

  • Type: picklist

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

  • Description: Default price type of the sales organization.

  • Possible values:

    • NotRelevant
    • consumer
    • factory

cgcloud__Default_Tactic_Fund_Template__c 

  • Type: reference

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

  • Description: Default template that’s used as a fallback if no fund template is selected in the tactic.

    This is a relationship field.

  • Relationship Name: cgcloud__Default_Tactic_Fund_Template__r

  • Relationship Type: Lookup

  • Refers To: cgcloud__Fund_Template__c

cgcloud__Description_Language_1__c 
  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Stores the description of language 1.

cgcloud__Description_Language_2__c 
  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Stores the description of language 2.

cgcloud__Description_Language_3__c 
  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Stores the description of language 3.

cgcloud__Description_Language_4__c 
  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Stores the description of language 4.

cgcloud__Description__c 

  • Type: string

  • Properties: Filter, Nillable, Sort

  • Description: Description based on the user-specified language.

    This is a calculated field.

  • Formula:

    1CASE($User.cgcloud__Language_Postfix__c,
2"Language1", cgcloud__Description_Language_1__c,
3"Language2", BLANKVALUE(cgcloud__Description_Language_2__c,cgcloud__Description_Language_1__c),
4"Language3", BLANKVALUE(cgcloud__Description_Language_3__c,cgcloud__Description_Language_1__c),
5"Language4", BLANKVALUE(cgcloud__Description_Language_4__c,cgcloud__Description_Language_1__c),
6cgcloud__Description_Language_1__c)

cgcloud__Distance_Unit__c 

  • Type: picklist

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

  • Description: Distance unit for mobility.

  • Default value: km

  • Possible values:

    • km—Kilometer
    • miles—Miles

cgcloud__Email__c 
  • Type: email
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Email address.

cgcloud__Enable_Acc_Cat_WDS_Profile__c 
  • Type: boolean
  • Properties: Create, Defaulted on create, Filter, Group, Sort, Update
  • Description: Determines whether the account, category, account, and sales org-specific profiles use the Profile bucket share calculation, which is found first.
  • Default value: false

cgcloud__Enable_Account_Set_Search_in_TPC__c 
  • Type: boolean
  • Properties: Create, Defaulted on create, Filter, Group, Sort, Update
  • Description: Determines whether the customer set search filter is available in the trade calendar filter.
  • Default value: true

cgcloud__Enable_Auto_Tactic_Fund_Assignment__c 
  • Type: boolean
  • Properties: Create, Defaulted on create, Filter, Group, Sort, Update
  • Description: Determines whether the tactic fund assignment is automatic.
  • Default value: true

cgcloud__Enable_Payment_Overwrite__c 
  • Type: boolean
  • Properties: Create, Defaulted on create, Filter, Group, Sort, Update
  • Description: Determines whether the payment can be overwritten for the sales organization.
  • Default value: true

cgcloud__Enable_Sub_Account_Search_In_TPC__c 
  • Type: boolean
  • Properties: Create, Defaulted on create, Filter, Group, Sort, Update
  • Description: Determines whether the customer set search filter is available in the trade calendar filter.
  • Default value: false

cgcloud__Enable_Subperiod_Writeback__c 
  • Type: boolean
  • Properties: Create, Defaulted on create, Filter, Group, Sort, Update
  • Description: Determines whether the system stores subperiod values with writebacks.
  • Default value: false

cgcloud__Enable_Subset_Load_Optimization__c 
  • Type: boolean
  • Properties: Create, Defaulted on create, Filter, Group, Sort, Update
  • Description: Determines whether the system uses KPI subset configurations for optimized loading of KPIs in promotion and account plan.
  • Default value: true

cgcloud__Enable_Tactic_Condition_Creation__c 
  • Type: boolean
  • Properties: Create, Defaulted on create, Filter, Group, Sort, Update
  • Description: Determines whether the condition can be created at the tactic level.
  • Default value: false

cgcloud__Fax__c 
  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Fax number.

cgcloud__First_Day_Of_Week__c 

  • Type: picklist

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

  • Description: Indicates the day of the week.

  • Possible values:

    • 1—Sunday
    • 2—Monday
    • 3—Tuesday
    • 4—Wednesday
    • 5—Thursday
    • 6—Friday
    • 7—Saturday

cgcloud__First_Week_Of_Year__c 

  • Type: picklist

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

  • Description: Shows the week for call scheduling.

  • Possible values:

    • 1—First January
    • 2—First Four Days
    • 3—First Full Week

cgcloud__Geofence_Distance__c 
  • Type: double
  • Properties: Create, Defaulted on create, Filter, Nillable, Sort, Update
  • Description: Maximum distance(in kilometers) allowed for geofencing validation (start-of-day, end-of-day, visit).

cgcloud__Global_Sales_Org__c 
  • Type: boolean
  • Properties: Create, Defaulted on create, Filter, Group, Sort, Update
  • Description: Defines whether the current sales org is the global sales org.
  • Default value: false

cgcloud__Has_Activated_Business_Years__c 
  • Type: boolean
  • Properties: Create, Defaulted on create, Filter, Group, Sort, Update
  • Description: Indicates whether the business years are activated for the sales org.
  • Default value: false

cgcloud__IBAN__c 
  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: International Bank Account Number.

cgcloud__Language_1__c 

  • Type: picklist

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

  • Description: Language 1 of the sales org.

  • Possible values:

    • de—German
    • en—English
    • es—Spanish
    • fr—French
    • it—Italian

cgcloud__Language_2__c 

  • Type: picklist

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

  • Description: Language 2 of the sales org.

  • Possible values:

    • de—German
    • en—English
    • es—Spanish
    • fr—French
    • it—Italian

cgcloud__Language_3__c 

  • Type: picklist

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

  • Description: Language 3 of the sales org.

  • Possible values:

    • de—German
    • en—English
    • es—Spanish
    • fr—French
    • it—Italian

cgcloud__Language_4__c 

  • Type: picklist

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

  • Description: Language 4 of the sales org.

  • Possible values:

    • de—German
    • en—English
    • es—Spanish
    • fr—French
    • it—Italian

cgcloud__Legal_Information__c 
  • Type: textarea
  • Properties: Create, Nillable, Update
  • Description: Legal information to be shown on the printouts.

cgcloud__Lookback_Period_In_Years__c 

  • Type: picklist

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

  • Description: The products with an end date within the lookback period are selected for the calculation of account plan profit and loss and customer business plan.

  • Possible values:

    • 1
    • 2

cgcloud__No__c 
  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: House Number.

cgcloud__PMR_Product_List_Relevant_Measures__c 

  • Type: multipicklist

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

  • Description: Stores measure codes that are defined for the WeeklyPromotionMeasureResult and MonthlyPromotionMeasureResult tables.

  • Possible values:

    • PIV
    • PTV

cgcloud__PM_Product_List_Relevant_Measures__c 

  • Type: multipicklist

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

  • Description: Stores measure codes that are defined for the product measure table.

  • Possible values:

    • COGS

cgcloud__Phone__c 
  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Phone number.

cgcloud__Postbox__c 
  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Number of a post box.

cgcloud__Promotion_Access_Definition_Policy__c 

  • Type: picklist

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

  • Description: Defines whether the edit and access rights are dependent on either the product categories that the user has assigned or the account and product category relationship.

  • Default value: Independent_Anchors

  • Possible values:

    • Combined_Anchors—Combined Anchors
    • Independent_Anchors—Independent Anchors

cgcloud__Promotion_Aggregation_Level__c 

  • Type: picklist

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

  • Description: Defines at which level the product is located.

  • Default value: Brand

  • Possible values:

    • Brand
    • Category
    • Flavor
    • Package
    • Product
    • SubCategory

cgcloud__SWIFT__c 
  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: International bank account identifier.

cgcloud__Sales_Org_Admin_User__c 

  • Type: reference

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

  • Description: Identifies the admin user of the sales org.

    This field is a relationship field.

  • Relationship Name: cgcloud__Sales_Org_Admin_User__r

  • Relationship Type: Lookup

  • Refers To: User

cgcloud__Sales_Org_Value__c 

  • Type: picklist

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

  • Description: Value of the sales org that are defined in the global value picklist.

  • Possible values:

    • 0000
    • 0001
    • 0002
    • 0003

cgcloud__Sales_Organization_Cluster__c 

  • Type: picklist

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

  • Description: Values of the organization cluster.

  • Possible values:

    • EU
    • NA
    • SA

cgcloud__Should_Include_Discontinued_Products__c 
  • Type: boolean
  • Properties: Create, Defaulted on create, Filter, Group, Sort, Update
  • Description: Indicates whether the discontinued products are included in the calculation of the account plan profit and loss and customer business plan. A single lookback period spans 380 days. The lookback period goes back from the start of the customer business plan or account plan. It goes back by 380 days for a 1-year period and 760 days for a 2-year period.
  • Default value: false

cgcloud__State__c 
  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Name of the state.

cgcloud__Street__c 
  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Name of a street.

cgcloud__Tax_Jurisdiction_Code__c 
  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Tax Account Number.

cgcloud__Used_Reference_Date__c 

  • Type: picklist

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

  • Description: Determines the value that’s selected in the view for the product hierarchy resolution reference date.

  • Default value: startdate

  • Possible values:

    • dynamic—Dynamic
    • startdate—Start Date

cgcloud__Visit_Start_Time__c 
  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Stores the Visit Start Time value.

cgcloud__Volume_Unit__c 

  • Type: picklist

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

  • Description: Item volume unit used for complex pricing. Assumption: All pricing relevant volume values (product master data, condition data) are interpreted in this overall specified unit.

  • Default value: l

  • Possible values:

    • cm3—cubic meters
    • gallon
    • l—liter

cgcloud__WMI_Product_List_Relevant_Measures__c 

  • Type: multipicklist

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

  • Description: Stores the measure codes that are defined for the weeklymeasureint table.

  • Possible values:

    • BSL
    • CONS

cgcloud__WMR_Product_List_Relevant_Measures__c 

  • Type: multipicklist

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

  • Description: Stores the measure codes that are defined for the weeklymeasurereal table.

  • Possible values:

    • WMR

cgcloud__Week_Day_Share_Profile__c 

  • Type: reference

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

  • Description: Reference to the weekday share profile that’s used as the default for the sales organization.

    This is a relationship field.

  • Relationship Name: cgcloud__Week_Day_Share_Profile__r

  • Relationship Type: Lookup

  • Refers To: cgcloud__Week_Day_Share_Profile__c

cgcloud__Weight_Unit__c 

  • Type: picklist

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

  • Description: Item weight unit that’s used for complex pricing. Assumption: All pricing relevant weight values (product master data, condition data) are interpreted in this overall specified unit.

  • Default value: kg

  • Possible values:

    • kg
    • oz
    • pound
    • ton

cgcloud__Zip_Code__c 
  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Postal code.

Associated Objects 

Associated Objects 

This object has these 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
Trade Promotion Management
Custom Objects for Retail Execution and Trade Promotion Management
cgcloud__Account_Condition__c
cgcloud__Account_Extension__c
cgcloud__Account_Manager__c
cgcloud__Account_Relationship__c
cgcloud__Account_Set__c
cgcloud__Account_Set_Account__c
cgcloud__Account_Set_Manager__c
cgcloud__Account_Template__c
cgcloud__Account_Trade_Org_Hierarchy__c
cgcloud__Account_Org_Unit__c
cgcloud__Batch_Run_Status__c
cgcloud__Batch_Run_Status_Detail__c
cgcloud__CGCPS_Service_Settings__c
cgcloud__Condition_Template__c
cgcloud__Custom_Permission_User_Role_Mapping__c
cgcloud__Flatten_Account_Hierarchy__c
cgcloud__Product_Assortment_Template__c
cgcloud__Product_Category_Share__c
cgcloud__Product_Hierarchy__c
cgcloud__Product_Template__c
cgcloud__Promotion__c
cgcloud__Promotion_Attachment__c
cgcloud__Promotion_Attachment_Link__c
cgcloud__Promotion_Template__c
cgcloud__Promotion_Template_Hierarchy__c
cgcloud__Promotion_Template_Tactic_Template__c
cgcloud__Sales_Organization__c
cgcloud__Sales_Organization_User__c
cgcloud__Segmentation_Rule__c
cgcloud__Segmentation_Rule_Def__c
cgcloud__Segmentation_Rule_Def_Column__c
cgcloud__Segmentation_Rule_Template__c
cgcloud__System_Setting__c
cgcloud__Trigger_Setting__c
cgcloud__Tactic__c
cgcloud__Tactic_Product__c
cgcloud__Tactic_Template__c
cgcloud__Transaction_Log__c
cgcloud__Update_Activation__c
cgcloud__User_Setting__c
cgcloud__Validation_Rules_Setting__c
Standard and Custom Objects for Future Use
API End-of-Life Policy
Previous Versions