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 are:
|
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.
- Possible values are:
- The default value is global.
|
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.
- The default value is 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.
- Possible values are:
-
1—Promotion
Template
-
2—Phase
-
3—Custom 3
-
4—Custom 4
-
5—Custom 5
- The default value is 1.
|
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 are:
- 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 are:
|
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 are:
|
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.
- Possible values are:
- 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
- The default value is 0176D3.
|
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 are:
-
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 are:
- 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
-
CASE($User.cgcloud__Language_Postfix__c,
"Language1", cgcloud__Description_Language_1__c,
"Language2", BLANKVALUE(cgcloud__Description_Language_2__c,cgcloud__Description_Language_1__c),
"Language3", BLANKVALUE(cgcloud__Description_Language_3__c,cgcloud__Description_Language_1__c),
"Language4", BLANKVALUE(cgcloud__Description_Language_4__c,cgcloud__Description_Language_1__c),
cgcloud__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.
- Possible values are:
- The default value is km.
|
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.
- The default value is 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.
- The default value is 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.
- The default value is 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.
- The default value is 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.
- The default value is 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.
- The default value is 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.
- The default value is 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.
- The default value is 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 are:
-
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 are:
-
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.
- The default value is 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.
- The default value is 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 are:
-
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 are:
-
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 are:
-
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 are:
-
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__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 are:
|
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 are:
|
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.
- Possible values are:
-
Combined_Anchors—Combined Anchors
-
Independent_Anchors—Independent Anchors
- The default value is 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.
- Possible values are:
- Brand
- Category
- Flavor
- Package
- Product
- SubCategory
- The default value is Brand.
|
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 are:
|
cgcloud__Sales_Organization_Cluster__c |
- Type
- picklist
- Properties
- Create, Filter, Group, Nillable, Restricted picklist, Sort,
Update
- Description
- Values of the organization cluster.
- Possible values are:
|
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.
- Possible values are:
-
dynamic—Dynamic
-
startdate—Start
Date
- The default value is startdate.
|
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.
- Possible values are:
-
cm3—cubic
meters
- gallon
-
l—liter
- The default value is l.
|
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 are:
|
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 are:
|
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.
- Possible values are:
- The default value is kg.
|
cgcloud__Zip_Code__c |
- Type
- string
- Properties
- Create, Filter, Group, Nillable, Sort, Update
- Description
- Postal code.
|