Table 5072 "Campaign Entry"

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

Properties

Property	Value
Caption	Campaign Entry
DataClassification	CustomerContent

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.

No.	Name	Type	Explanation	Notes
1	Entry No. Δ BC28	Integer	Specifies the number of the entry, as assigned from the specified number series when the entry was created.
2	Campaign No.	Code[20]	—	TableRelation Table 5071 “Campaign”
3	Description Δ BC28	Text[100]	Specifies the description of the campaign entry.
4	Date Δ BC28	Date	Specifies the date the campaign entry was recorded. The field is not editable.
5	User ID	Code[50]	—	TableRelation User.“User Name”; not editable; DataClassification EndUserIdentifiableInformation
6	Segment No.	Code[20]	—	TableRelation Table 5076 “Segment Header” (Segment Header)
7	Canceled Δ BC28	Boolean	Specifies that the entry has been canceled.
8	No. of Interactions Δ BC28	Integer	Specifies the number of interactions created as part of the campaign entry. The field is not editable.	FlowField: count(“Interaction Log Entry” where(“Campaign No.” = field(“Campaign No.”), “Campaign Entry No.” = field(“Entry No.”), Canceled = field(Canceled))); not editable
10	Cost (LCY) Δ BC27	Decimal	Specifies the cost of the campaign entry. The field is not editable. via Page 5089 “Campaign Entries”	FlowField: sum(“Interaction Log Entry”.“Cost (LCY)” where(“Campaign No.” = field(“Campaign No.”), “Campaign Entry No.” = field(“Entry No.”), Canceled = field(Canceled))); not editable
11	Duration (Min.) Δ BC27	Decimal	Specifies the duration of the action linked to the campaign entry. The field is not editable. via Page 5089 “Campaign Entries”	FlowField: sum(“Interaction Log Entry”.“Duration (Min.)” where(“Campaign No.” = field(“Campaign No.”), “Campaign Entry No.” = field(“Entry No.”), Canceled = field(Canceled))); not editable
12	Salesperson Code	Code[20]	—	TableRelation Table 13 “Salesperson/Purchaser” (Salesperson/Purchaser)
13	Register No.	Integer	—	TableRelation Table 5075 “Logged Segment” (Logged Segment)
14	Document Type	Enum “Interaction Log Entry Document Type”	—	enum Enum 5099 “Interaction Log Entry Document Type”

Keys

Key1: Entry No. (clustered)
Key2: Campaign No., Date, Document Type
Key3: Register No.

Procedures

CopyFromSegment(SegLine: Record "Segment Line")
ToggleCanceledCheckmark()
SetCanceledCheckmark(CanceledCheckmark: Boolean)

Plus 1 local procedures.

Triggers

OnDelete

Relations

drill-down page Page 5089 “Campaign Entries”
lookup page Page 5089 “Campaign Entries”
Salesperson Code: TableRelation Table 13 “Salesperson/Purchaser”
Cost (LCY): CalcFormula Table 5065 “Interaction Log Entry”
Duration (Min.): CalcFormula Table 5065 “Interaction Log Entry”
No. of Interactions: CalcFormula Table 5065 “Interaction Log Entry”
Campaign No.: TableRelation Table 5071 “Campaign”
Register No.: TableRelation Table 5075 “Logged Segment”
Segment No.: TableRelation Table 5076 “Segment Header”

Referenced by

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

Table 5065 “Interaction Log Entry”: Campaign Entry No.
Table 5075 “Logged Segment”: No. of Campaign Entries
Table 5077 “Segment Line”: Campaign Entry No.

Pages and codeunits on this table

Page 5089 “Campaign Entries” (source table)

Ask your agent

Procedure bodies are not stored here (D10). 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 Entry"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.