Campaign table/entity reference
Note
Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.
Container for campaign activities and responses, sales literature, products, and lists to create, plan, execute, and track the results of a specific marketing campaign through its life.
Added by: Marketing Solution
Messages
Message | Web API Operation | SDK class or method |
---|---|---|
AddItemCampaign | AddItemCampaignRequest | |
AddItemCampaignActivity | AddItemCampaignActivityRequest | |
Assign | PATCH /campaigns(campaignid) Update ownerid property. |
AssignRequest |
CopyCampaign | CopyCampaignRequest | |
Create | POST /campaigns See Create |
CreateRequest or Create |
CreateMultiple | CreateMultiple | CreateMultipleRequest |
Delete | DELETE /campaigns(campaignid) See Delete |
DeleteRequest or Delete |
GrantAccess | GrantAccess | GrantAccessRequest |
ModifyAccess | ModifyAccess | ModifyAccessRequest |
RemoveItemCampaign | RemoveItemCampaignRequest | |
RemoveItemCampaignActivity | RemoveItemCampaignActivityRequest | |
Retrieve | GET /campaigns(campaignid) See Retrieve |
RetrieveRequest or Retrieve |
RetrieveMultiple | GET /campaigns See Query Data |
RetrieveMultipleRequest or RetrieveMultiple |
RetrievePrincipalAccess | RetrievePrincipalAccess | RetrievePrincipalAccessRequest |
RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccessRequest |
RevokeAccess | RevokeAccess | RevokeAccessRequest |
SetState | PATCH /campaigns(campaignid) Update statecode and statuscode properties. |
SetStateRequest |
Update | PATCH /campaigns(campaignid) See Update |
UpdateRequest or Update |
UpdateMultiple | UpdateMultiple | UpdateMultipleRequest |
Properties
Property | Value |
---|---|
CollectionSchemaName | Campaigns |
DisplayCollectionName | Campaigns |
DisplayName | Campaign |
EntitySetName | campaigns |
IsBPFEntity | False |
LogicalCollectionName | campaigns |
LogicalName | campaign |
OwnershipType | UserOwned |
PrimaryIdAttribute | campaignid |
PrimaryNameAttribute | name |
SchemaName | Campaign |
Writable columns/attributes
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- ActualEnd
- ActualStart
- BudgetedCost
- CampaignId
- CodeName
- Description
- EmailAddress
- EntityImage
- ExpectedResponse
- ExpectedRevenue
- ImportSequenceNumber
- IsTemplate
- Message
- msdyn_gdproptout
- Name
- Objective
- OtherCost
- OverriddenCreatedOn
- OwnerId
- OwnerIdType
- PriceListId
- ProcessId
- PromotionCodeName
- ProposedEnd
- ProposedStart
- StageId
- StateCode
- StatusCode
- TimeZoneRuleVersionNumber
- TmpRegardingObjectId
- TransactionCurrencyId
- TraversedPath
- TypeCode
- UTCConversionTimeZoneCode
ActualEnd
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Enter the date when the campaign was closed or completed. |
DisplayName | Actual End Date |
Format | DateOnly |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | actualend |
RequiredLevel | None |
Type | DateTime |
ActualStart
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Enter the actual start date and time for the campaign. |
DisplayName | Actual Start Date |
Format | DateOnly |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | actualstart |
RequiredLevel | None |
Type | DateTime |
BudgetedCost
Property | Value |
---|---|
Description | Type the amount budgeted for the campaign to define a limit for how much you can spend. |
DisplayName | Budget Allocated |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | budgetedcost |
MaxValue | 1000000000000 |
MinValue | 0 |
Precision | 2 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
CampaignId
Property | Value |
---|---|
Description | Unique identifier of the campaign. |
DisplayName | Campaign |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | campaignid |
RequiredLevel | SystemRequired |
Type | Uniqueidentifier |
CodeName
Property | Value |
---|---|
Description | Type a number or other tracking code to identify the campaign. If no value is entered, a code will be generated automatically. |
DisplayName | Campaign Code |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | codename |
MaxLength | 32 |
RequiredLevel | None |
Type | String |
Description
Property | Value |
---|---|
Description | Type additional information to describe the campaign, such as the products or services offered or the targeted audience. |
DisplayName | Description |
Format | TextArea |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | description |
MaxLength | 2000 |
RequiredLevel | None |
Type | Memo |
EmailAddress
Property | Value |
---|---|
Description | The primary email address for the entity. |
DisplayName | Email Address |
FormatName | |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | emailaddress |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
EntityImage
Added by: Active Solution Solution
Property | Value |
---|---|
Description | The default image for the entity. |
DisplayName | Entity Image |
IsPrimaryImage | True |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | entityimage |
MaxHeight | 144 |
MaxWidth | 144 |
RequiredLevel | None |
Type | Image |
ExpectedResponse
Property | Value |
---|---|
Description | Type the expected response rate for the campaign as a full number between 0 and 100. |
DisplayName | Expected Response Percentage |
Format | None |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | expectedresponse |
MaxValue | 100 |
MinValue | 0 |
RequiredLevel | None |
Type | Integer |
ExpectedRevenue
Property | Value |
---|---|
Description | Type the expected revenue for the campaign for return on investment projections and post-campaign reporting. |
DisplayName | Estimated Revenue |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | expectedrevenue |
MaxValue | 1000000000000 |
MinValue | 0 |
Precision | 2 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
ImportSequenceNumber
Property | Value |
---|---|
Description | Sequence number of the import that created this record. |
DisplayName | Import Sequence Number |
Format | None |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | importsequencenumber |
MaxValue | 2147483647 |
MinValue | -2147483648 |
RequiredLevel | None |
Type | Integer |
IsTemplate
Property | Value |
---|---|
Description | Select whether the campaign is a template that can be copied when you create future campaigns. |
DisplayName | Template |
IsValidForForm | True |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | istemplate |
RequiredLevel | None |
Type | Boolean |
IsTemplate Choices/Options
Value | Label | Description |
---|---|---|
1 | Yes | |
0 | No |
DefaultValue: 0
Message
Property | Value |
---|---|
Description | Type the promotional message or marketing copy for the campaign. |
DisplayName | Message |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | message |
MaxLength | 256 |
RequiredLevel | None |
Type | String |
msdyn_gdproptout
Added by: Predictive Opportunity Scoring Solution
Property | Value |
---|---|
Description | Describes whether campaign is opted out or not |
DisplayName | GDPR Optout |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_gdproptout |
RequiredLevel | None |
Type | Boolean |
msdyn_gdproptout Choices/Options
Value | Label | Description |
---|---|---|
1 | Yes | |
0 | No |
DefaultValue: 0
Name
Property | Value |
---|---|
Description | Type a name for the campaign so that it is identified correctly in lists. |
DisplayName | Name |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | name |
MaxLength | 128 |
RequiredLevel | SystemRequired |
Type | String |
Objective
Property | Value |
---|---|
Description | Type the objective of the campaign, including products, services, discounts, and pricing. |
DisplayName | Offer |
Format | TextArea |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | objective |
MaxLength | 2000 |
RequiredLevel | None |
Type | Memo |
OtherCost
Property | Value |
---|---|
Description | Type the sum of any miscellaneous campaign costs not included in the campaign activities to make sure the actual cost of the campaign is calculated correctly. |
DisplayName | Miscellaneous Costs |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | othercost |
MaxValue | 1000000000000 |
MinValue | 0 |
Precision | 2 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
OverriddenCreatedOn
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Date and time that the record was migrated. |
DisplayName | Record Created On |
Format | DateOnly |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | overriddencreatedon |
RequiredLevel | None |
Type | DateTime |
OwnerId
Property | Value |
---|---|
Description | Owner Id |
DisplayName | Owner |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | ownerid |
RequiredLevel | SystemRequired |
Targets | systemuser,team |
Type | Owner |
OwnerIdType
Added by: Active Solution Solution
Property | Value |
---|---|
Description | Owner Id Type |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridtype |
RequiredLevel | SystemRequired |
Type | EntityName |
PriceListId
Property | Value |
---|---|
Description | Choose the price list associated with this item to make sure the products associated with the campaign are offered at the correct prices. |
DisplayName | Price List |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | pricelistid |
RequiredLevel | None |
Targets | pricelevel |
Type | Lookup |
ProcessId
Property | Value |
---|---|
Description | Contains the id of the process associated with the entity. |
DisplayName | Process Id |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | processid |
RequiredLevel | None |
Type | Uniqueidentifier |
PromotionCodeName
Property | Value |
---|---|
Description | Type a promotional code to track sales related to the campaign or allow customers to redeem a discount offer. |
DisplayName | Promotion Code |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | promotioncodename |
MaxLength | 128 |
RequiredLevel | None |
Type | String |
ProposedEnd
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Enter the date when the campaign is scheduled to end. |
DisplayName | Proposed End Date |
Format | DateOnly |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | proposedend |
RequiredLevel | None |
Type | DateTime |
ProposedStart
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Enter the date when the campaign is scheduled to start. |
DisplayName | Proposed Start Date |
Format | DateOnly |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | proposedstart |
RequiredLevel | None |
Type | DateTime |
StageId
Property | Value |
---|---|
Description | Contains the id of the stage where the entity is located. |
DisplayName | (Deprecated) Stage Id |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | stageid |
RequiredLevel | None |
Type | Uniqueidentifier |
StateCode
Property | Value |
---|---|
Description | Shows the status of the campaign. By default, campaigns are active and can't be deactivated. |
DisplayName | Status |
IsValidForCreate | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | statecode |
RequiredLevel | SystemRequired |
Type | State |
StateCode Choices/Options
Value | Label | DefaultStatus | InvariantName |
---|---|---|---|
0 | Active | 0 | Active |
1 | Inactive | 6 | Inactive |
StatusCode
Property | Value |
---|---|
Description | Select the campaign's status. |
DisplayName | Status Reason |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | statuscode |
RequiredLevel | None |
Type | Status |
StatusCode Choices/Options
Value | Label | State |
---|---|---|
0 | Proposed | 0 |
1 | Ready To Launch | 0 |
2 | Launched | 0 |
3 | Completed | 0 |
4 | Canceled | 0 |
5 | Suspended | 0 |
6 | Inactive | 1 |
TimeZoneRuleVersionNumber
Property | Value |
---|---|
Description | For internal use only. |
DisplayName | Time Zone Rule Version Number |
Format | None |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | timezoneruleversionnumber |
MaxValue | 2147483647 |
MinValue | -1 |
RequiredLevel | None |
Type | Integer |
TmpRegardingObjectId
Added by: Marketing Patch Solution
Property | Value |
---|---|
Description | |
DisplayName | TmpRegardingObjectId |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | tmpregardingobjectid |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
TransactionCurrencyId
Property | Value |
---|---|
Description | Choose the local currency for the record to make sure budgets are reported in the correct currency. |
DisplayName | Currency |
IsValidForForm | True |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | transactioncurrencyid |
RequiredLevel | ApplicationRequired |
Targets | transactioncurrency |
Type | Lookup |
TraversedPath
Property | Value |
---|---|
Description | A comma separated list of string values representing the unique identifiers of stages in a Business Process Flow Instance in the order that they occur. |
DisplayName | (Deprecated) Traversed Path |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | traversedpath |
MaxLength | 1250 |
RequiredLevel | None |
Type | String |
TypeCode
Property | Value |
---|---|
Description | Select the type of the campaign. |
DisplayName | Campaign Type |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | typecode |
RequiredLevel | None |
Type | Picklist |
TypeCode Choices/Options
Value | Label | Description |
---|---|---|
1 | Advertisement | |
2 | Direct Marketing | |
3 | Event | |
4 | Co-branding | |
5 | Other |
UTCConversionTimeZoneCode
Property | Value |
---|---|
Description | Time zone code that was in use when the record was created. |
DisplayName | UTC Conversion Time Zone Code |
Format | None |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | utcconversiontimezonecode |
MaxValue | 2147483647 |
MinValue | -1 |
RequiredLevel | None |
Type | Integer |
Read-only columns/attributes
These columns/attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.
- BudgetedCost_Base
- CreatedBy
- CreatedByName
- CreatedByYomiName
- CreatedOn
- CreatedOnBehalfBy
- CreatedOnBehalfByName
- CreatedOnBehalfByYomiName
- EntityImage_Timestamp
- EntityImage_URL
- EntityImageId
- ExchangeRate
- ExpectedRevenue_Base
- ModifiedBy
- ModifiedByName
- ModifiedByYomiName
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- OtherCost_Base
- OwnerIdName
- OwnerIdYomiName
- OwningBusinessUnit
- OwningBusinessUnitName
- OwningTeam
- OwningUser
- PriceListName
- TotalActualCost
- TotalActualCost_Base
- TotalCampaignActivityActualCost
- TotalCampaignActivityActualCost_Base
- TransactionCurrencyIdName
- VersionNumber
BudgetedCost_Base
Property | Value |
---|---|
Description | Value of the Budget Allocated in base currency. |
DisplayName | Budget Allocated (Base) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | budgetedcost_base |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
CreatedBy
Property | Value |
---|---|
Description | Shows who created the record. |
DisplayName | Created By |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | createdby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
CreatedByName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
CreatedByYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
CreatedOn
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Date and time when the record was created. |
DisplayName | Created On |
Format | DateAndTime |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | createdon |
RequiredLevel | None |
Type | DateTime |
CreatedOnBehalfBy
Property | Value |
---|---|
Description | Shows who created the record on behalf of another user. |
DisplayName | Created By (Delegate) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | createdonbehalfby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
CreatedOnBehalfByName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdonbehalfbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
CreatedOnBehalfByYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdonbehalfbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
EntityImage_Timestamp
Property | Value |
---|---|
Description | |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | entityimage_timestamp |
MaxValue | 9223372036854775807 |
MinValue | -9223372036854775808 |
RequiredLevel | None |
Type | BigInt |
EntityImage_URL
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Url |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | entityimage_url |
MaxLength | 200 |
RequiredLevel | None |
Type | String |
EntityImageId
Property | Value |
---|---|
Description | |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | entityimageid |
RequiredLevel | None |
Type | Uniqueidentifier |
ExchangeRate
Added by: Active Solution Solution
Property | Value |
---|---|
Description | Shows the conversion rate of the record's currency. The exchange rate is used to convert all money fields in the record from the local currency to the system's default currency. |
DisplayName | Exchange Rate |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | exchangerate |
MaxValue | 100000000000 |
MinValue | 0.000000000001 |
Precision | 12 |
RequiredLevel | None |
Type | Decimal |
ExpectedRevenue_Base
Property | Value |
---|---|
Description | Value of the Estimated Revenue in base currency. |
DisplayName | Estimated Revenue (Base) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | expectedrevenue_base |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
ModifiedBy
Property | Value |
---|---|
Description | Shows who last updated the record. |
DisplayName | Modified By |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | modifiedby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
ModifiedByName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
ModifiedByYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
ModifiedOn
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Date and time when the record was modified. |
DisplayName | Modified On |
Format | DateAndTime |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | modifiedon |
RequiredLevel | None |
Type | DateTime |
ModifiedOnBehalfBy
Property | Value |
---|---|
Description | Shows who created the record on behalf of another user. |
DisplayName | Modified By (Delegate) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | modifiedonbehalfby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
ModifiedOnBehalfByName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedonbehalfbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
ModifiedOnBehalfByYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedonbehalfbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
OtherCost_Base
Property | Value |
---|---|
Description | Value of the Miscellaneous Costs in base currency. |
DisplayName | Miscellaneous Costs (Base) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | othercost_base |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
OwnerIdName
Property | Value |
---|---|
Description | Name of the owner |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridname |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
OwnerIdYomiName
Property | Value |
---|---|
Description | Yomi name of the owner |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridyominame |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
OwningBusinessUnit
Property | Value |
---|---|
Description | Unique identifier for the business unit that owns the record |
DisplayName | Owning Business Unit |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | owningbusinessunit |
RequiredLevel | None |
Targets | businessunit |
Type | Lookup |
OwningBusinessUnitName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owningbusinessunitname |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
OwningTeam
Property | Value |
---|---|
Description | Unique identifier for the team that owns the record. |
DisplayName | Owning Team |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owningteam |
RequiredLevel | None |
Targets | team |
Type | Lookup |
OwningUser
Property | Value |
---|---|
Description | Unique identifier for the user that owns the record. |
DisplayName | Owning User |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owninguser |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
PriceListName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | pricelistname |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
TotalActualCost
Property | Value |
---|---|
Description | Shows the sum of the amounts entered in the Total Cost of Campaign Activities and Miscellaneous Costs fields. |
DisplayName | Total Cost of Campaign |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | totalactualcost |
MaxValue | 1000000000000 |
MinValue | 0 |
Precision | 2 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
TotalActualCost_Base
Property | Value |
---|---|
Description | Value of the Total Cost of Campaign in base currency. |
DisplayName | Total Cost of Campaign (Base) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | totalactualcost_base |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
TotalCampaignActivityActualCost
Property | Value |
---|---|
Description | Shows the sum of the values entered in the Actual Cost field on all campaign activities related to the campaign. |
DisplayName | Total Cost of Campaign Activities |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | totalcampaignactivityactualcost |
MaxValue | 1000000000000 |
MinValue | 0 |
Precision | 2 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
TotalCampaignActivityActualCost_Base
Property | Value |
---|---|
Description | Value of the Total Cost of Campaign Activities in base currency. |
DisplayName | Total Cost of Campaign Activities (Base) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | totalcampaignactivityactualcost_base |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
TransactionCurrencyIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | transactioncurrencyidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
VersionNumber
Property | Value |
---|---|
Description | Version Number |
DisplayName | Version Number |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | versionnumber |
MaxValue | 9223372036854775807 |
MinValue | -9223372036854775808 |
RequiredLevel | None |
Type | BigInt |
One-To-Many Relationships
Listed by SchemaName.
- Campaign_CampaignActivities
- Campaign_CampaignResponses
- campaign_leads
- campaign_OpportunityCloses
- campaign_OrderCloses
- campaign_QuoteCloses
- campaign_opportunities
- campaign_orders
- campaign_quotes
Campaign_CampaignActivities
Same as the Campaign_CampaignActivities many-to-one relationship for the campaignactivity table/entity.
Property | Value |
---|---|
ReferencingEntity | campaignactivity |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | Campaign_CampaignActivities |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: Cascade Share: Cascade Unshare: Cascade |
Campaign_CampaignResponses
Same as the Campaign_CampaignResponses many-to-one relationship for the campaignresponse table/entity.
Property | Value |
---|---|
ReferencingEntity | campaignresponse |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | Campaign_CampaignResponses |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: Cascade Share: Cascade Unshare: Cascade |
campaign_leads
Same as the campaign_leads many-to-one relationship for the lead table/entity.
Property | Value |
---|---|
ReferencingEntity | lead |
ReferencingAttribute | campaignid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | campaign_leads |
AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Marketing Label: Order: 130 |
CascadeConfiguration | Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
campaign_OpportunityCloses
Added by: Sales Solution
Same as the campaign_OpportunityCloses many-to-one relationship for the opportunityclose table/entity.
Property | Value |
---|---|
ReferencingEntity | opportunityclose |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | campaign_OpportunityCloses |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: Cascade Share: Cascade Unshare: Cascade |
campaign_OrderCloses
Added by: Sales Solution
Same as the campaign_OrderCloses many-to-one relationship for the orderclose table/entity.
Property | Value |
---|---|
ReferencingEntity | orderclose |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | campaign_OrderCloses |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: Cascade Share: Cascade Unshare: Cascade |
campaign_QuoteCloses
Added by: Sales Solution
Same as the campaign_QuoteCloses many-to-one relationship for the quoteclose table/entity.
Property | Value |
---|---|
ReferencingEntity | quoteclose |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | campaign_QuoteCloses |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: Cascade Share: Cascade Unshare: Cascade |
campaign_opportunities
Added by: Marketing Sales Solution
Same as the campaign_opportunities many-to-one relationship for the opportunity table/entity.
Property | Value |
---|---|
ReferencingEntity | opportunity |
ReferencingAttribute | campaignid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | campaign_opportunities |
AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Sales Label: Order: 130 |
CascadeConfiguration | Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
campaign_orders
Added by: Marketing Sales Solution
Same as the campaign_orders many-to-one relationship for the salesorder table/entity.
Property | Value |
---|---|
ReferencingEntity | salesorder |
ReferencingAttribute | campaignid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | campaign_orders |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
campaign_quotes
Added by: Marketing Sales Solution
Same as the campaign_quotes many-to-one relationship for the quote table/entity.
Property | Value |
---|---|
ReferencingEntity | quote |
ReferencingAttribute | campaignid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | campaign_quotes |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Many-To-One Relationships
Each Many-To-One relationship is defined by a corresponding One-To-Many relationship with the related table. Listed by SchemaName.
PriceList_Campaigns
Added by: Product Management Solution
See the PriceList_Campaigns one-to-many relationship for the pricelevel table/entity.
Many-To-Many Relationships
Relationship details provided where the Campaign table is the first table in the relationship. Listed by SchemaName.
- campaigncampaign_association
- campaignproduct_association
- campaignlist_association
- campaignsalesliterature_association
campaigncampaign_association
IntersectEntityName: campaignitem
Table 1
Property | Value |
---|---|
IntersectAttribute | campaignid |
IsCustomizable | False |
LogicalName | campaign |
NavigationPropertyName | campaigncampaign_association |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
Table 2
Property | Value |
---|---|
LogicalName | campaign |
IntersectAttribute | entityid |
NavigationPropertyName | campaigncampaign_association |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
campaignproduct_association
IntersectEntityName: campaignitem
Table 1
Property | Value |
---|---|
IntersectAttribute | campaignid |
IsCustomizable | False |
LogicalName | campaign |
NavigationPropertyName | campaignproduct_association |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
Table 2
Property | Value |
---|---|
LogicalName | product |
IntersectAttribute | entityid |
NavigationPropertyName | campaignproduct_association |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
campaignlist_association
IntersectEntityName: campaignitem
Table 1
Property | Value |
---|---|
IntersectAttribute | campaignid |
IsCustomizable | False |
LogicalName | campaign |
NavigationPropertyName | campaignlist_association |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
Table 2
Property | Value |
---|---|
LogicalName | list |
IntersectAttribute | entityid |
NavigationPropertyName | campaignlist_association |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
campaignsalesliterature_association
IntersectEntityName: campaignitem
Table 1
Property | Value |
---|---|
IntersectAttribute | campaignid |
IsCustomizable | False |
LogicalName | campaign |
NavigationPropertyName | campaignsalesliterature_association |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
Table 2
Property | Value |
---|---|
LogicalName | salesliterature |
IntersectAttribute | entityid |
NavigationPropertyName | campaignsalesliterature_association |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
See also
प्रतिक्रिया
https://aka.ms/ContentUserFeedback.
जल्द आ रहा है: 2024 के दौरान हम सामग्री के लिए फीडबैक तंत्र के रूप में GitHub मुद्दों को चरणबद्ध तरीके से समाप्त कर देंगे और इसे एक नई फीडबैक प्रणाली से बदल देंगे. अधिक जानकारी के लिए, देखें:के लिए प्रतिक्रिया सबमिट करें और देखें