Table 5071 "Campaign"

Base Application · Microsoft.CRM.Campaign · BC23-30 · source at ea08af5e · facts from BC29

Properties

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

Keys

• Key1: No. (clustered)
• Key2: Salesperson Code

Events published

• OnAfterValidateShortcutDimCode(Campaign: Record Campaign; xCampaign: Record Campaign; FieldNumber: Integer; var ShortcutDimCode: Code[20]) (integration)
• OnBeforeValidateShortcutDimCode(Campaign: Record Campaign; xCampaign: Record Campaign; FieldNumber: Integer; var ShortcutDimCode: Code[20]) (integration)

Trigger event subscribers

• OnAfterDeleteEvent: Codeunit 7006 “Price Helper - V16” AfterDeleteCampaign, Codeunit 7019 “Price Helper - V15” AfterDeleteCampaign
• OnAfterModifyEvent: Codeunit 7019 “Price Helper - V15” AfterModifyCampaign
• OnAfterRenameEvent: Codeunit 7006 “Price Helper - V16” AfterRenameCampaign
• OnAfterValidateEvent(Ending Date): Codeunit 7006 “Price Helper - V16” AfterModifyEndingDateCampaign
• OnAfterValidateEvent(Starting Date): Codeunit 7006 “Price Helper - V16” AfterModifyStartingDateCampaign

Procedures

• AssistEdit(OldCampaign: Record Campaign): Boolean
• ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])
• ToPriceSource(var PriceSource: Record "Price Source")

Plus 1 local procedures.

Triggers

OnDelete, OnInsert, OnModify, OnRename

Relations

• lookup page Page 5087 “Campaign List”
• Salesperson Code: TableRelation Table 13 “Salesperson/Purchaser”
• Salesperson Filter: TableRelation Table 13 “Salesperson/Purchaser”
• No. Series: TableRelation Table 308 “No. Series”
• Global Dimension 1 Code: TableRelation Table 349 “Dimension Value”
• Global Dimension 2 Code: TableRelation Table 349 “Dimension Value”
• Contact Company Filter: TableRelation Table 5050 “Contact”
• Contact Filter: TableRelation Table 5050 “Contact”
• Comment: CalcFormula Table 5061 “Rlshp. Mgt. Comment Line”
• Contacts Responded: CalcFormula Table 5065 “Interaction Log Entry”
• Cost (LCY): CalcFormula Table 5065 “Interaction Log Entry”
• Duration (Min.): CalcFormula Table 5065 “Interaction Log Entry”
• Target Contacts Contacted: CalcFormula Table 5065 “Interaction Log Entry”
• Status Code: TableRelation Table 5073 “Campaign Status”
• Task Entry Exists: CalcFormula Table 5080 “To-do”
• Team Filter: TableRelation Table 5083 “Team”
• Sales Cycle Filter: TableRelation Table 5090 “Sales Cycle”
• Sales Cycle Stage Filter: TableRelation Table 5091 “Sales Cycle Stage”
• Calcd. Current Value (LCY): CalcFormula Table 5093 “Opportunity Entry”
• Estimated Value (LCY): CalcFormula Table 5093 “Opportunity Entry”
• No. of Opportunities: CalcFormula Table 5093 “Opportunity Entry”
• Opportunity Entry Exists: CalcFormula Table 5093 “Opportunity Entry”
• Close Opportunity Filter: TableRelation Table 5094 “Close Opportunity Code”
• Activated: CalcFormula Table 7030 “Campaign Target Group”

Referenced by

39 fields in 36 objects relate to this table (TableRelation or CalcFormula).

• Table 5076 “Segment Header”: Campaign Description, Campaign No.
• Table 5080 “To-do”: Campaign Description, Campaign No.
• Table 5092 “Opportunity”: Campaign Description, Campaign No.
• Table 110 “Sales Shipment Header”: Campaign No.
• Table 112 “Sales Invoice Header”: Campaign No.
• Table 114 “Sales Cr.Memo Header”: Campaign No.
• Table 120 “Purch. Rcpt. Header”: Campaign No.
• Table 122 “Purch. Inv. Header”: Campaign No.
• Table 124 “Purch. Cr. Memo Hdr.”: Campaign No.
• Table 13 “Salesperson/Purchaser”: Campaign Filter
• Table 181 “Posted Gen. Journal Line”: Campaign No.
• Table 36 “Sales Header”: Campaign No.
• Table 38 “Purchase Header”: Campaign No.
• Table 5050 “Contact”: Campaign Filter
• Table 5061 “Rlshp. Mgt. Comment Line”: No.
• Table 5064 “Interaction Template”: Campaign No.
• Table 5065 “Interaction Log Entry”: Campaign No.
• Table 5072 “Campaign Entry”: Campaign No.
• Table 5077 “Segment Line”: Campaign No.
• Table 5083 “Team”: Campaign Filter
• Table 5093 “Opportunity Entry”: Campaign No.
• Table 5102 “RM Matrix Management”: Campaign Filter
• Table 5107 “Sales Header Archive”: Campaign No.
• Table 5109 “Purchase Header Archive”: Campaign No.
• Table 6650 “Return Shipment Header”: Campaign No.
• Table 6660 “Return Receipt Header”: Campaign No.
• Table 7000 “Price List Header”: Assign-to No.
• Table 7001 “Price List Line”: Assign-to No.
• Table 7002 “Sales Price”: Sales Code
• Table 7004 “Sales Line Discount”: Sales Code
• Table 7022 “Price Worksheet Line”: Assign-to No.
• Table 7023 “Sales Price Worksheet”: Sales Code
• Table 7030 “Campaign Target Group”: Campaign No.
• Table 751 “Standard General Journal Line”: Campaign No.
• Table 81 “Gen. Journal Line”: Campaign No.
• Table 9063 “Relationship Mgmt. Cue”: Active Campaigns

Pages and codeunits on this table

• Page 5086 “Campaign Card” (source table)
• Page 5087 “Campaign List” (source table)
• Page 5088 “Campaign Statistics” (source table)

Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.

• Codeunit 408 “DimensionManagement” (5 calls: OnDelete → DeleteDefaultDim, OnInsert → UpdateDefaultDim, OnRename → RenameDefaultDim, …)
• Page 456 “No. Series” (2 calls: AssistEdit → (object), OnInsert → (object))
• Codeunit 7030 “Campaign Target Group Mgt” (1 call: OnDelete → DeactivateCampaign)

Ask your agent

Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Campaign"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.