Campaign #5071

Other table in Microsoft Dynamics 365 Business Central. 43 fields, 3 records in Cronus demo.

43
Fields
3
Records
1
Primary key
11
FlowFields
14
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: No..

All fields (43)

Campaign — FIELDS
NO.FIELDTYPECLASSRELATION
1 No. PK Code Normal
2 Description Text Normal
3 Starting Date Date Normal
4 Ending Date Date Normal
5 Salesperson Code Code Normal → Salesperson/Purchaser #13
6 Comment ⚡ FLOW Boolean FlowField
7 Last Date Modified Date Normal
8 No. Series Code Normal → No. Series #308
9 Global Dimension 1 Code Code Normal → Dimension Value #349
10 Global Dimension 2 Code Code Normal → Dimension Value #349
11 Status Code Code Normal → Campaign Status #5073
12 Target Contacts Contacted ⚡ FLOW Integer FlowField
13 Contacts Responded ⚡ FLOW Integer FlowField
14 Duration (Min.) ⚡ FLOW Decimal FlowField
16 Cost (LCY) ⚡ FLOW Decimal FlowField
17 No. of Opportunities ⚡ FLOW Integer FlowField
18 Estimated Value (LCY) ⚡ FLOW Decimal FlowField
19 Calcd. Current Value (LCY) ⚡ FLOW Decimal FlowField
20 Date Filter Date FlowFilter
23 Action Taken Filter Option FlowFilter
24 Sales Cycle Filter Code FlowFilter → Sales Cycle #5090
25 Sales Cycle Stage Filter Integer FlowFilter → Sales Cycle Stage #5091
26 Probability % Filter Decimal FlowFilter
27 Completed % Filter Decimal FlowFilter
28 Contact Filter Code FlowFilter → Contact #5050
29 Contact Company Filter Code FlowFilter → Contact #5050
30 Estimated Value Filter Decimal FlowFilter
31 Calcd. Current Value Filter Decimal FlowFilter
32 Chances of Success % Filter Decimal FlowFilter
33 Task Status Filter Option FlowFilter
34 Task Closed Filter Boolean FlowFilter
35 Priority Filter Option FlowFilter
36 Team Filter Code FlowFilter → Team #5083
37 Salesperson Filter Code FlowFilter → Salesperson/Purchaser #13
38 Opportunity Entry Exists ⚡ FLOW Boolean FlowField
39 Task Entry Exists ⚡ FLOW Boolean FlowField
40 Close Opportunity Filter Code FlowFilter → Close Opportunity Code #5094
41 Activated ⚡ FLOW Boolean FlowField
2000000000 System ID GUID Normal
2000000001 Created At DateTime Normal
2000000002 Created By GUID Normal
2000000003 Modified At DateTime Normal
2000000004 Modified By GUID Normal

Related tables (10)

Tables referenced by fields on the Campaign table through TableRelation properties.

Salesperson/Purchaser
#13 · General Ledger · via Salesperson Code, Salesperson Filter
No. Series
#308 · Other · via No. Series
Dimension Value
#349 · Dimensions · via Global Dimension 1 Code, Global Dimension 2 Code
Campaign Status
#5073 · Other · via Status Code
Sales Cycle
#5090 · Other · via Sales Cycle Filter
Sales Cycle Stage
#5091 · Other · via Sales Cycle Stage Filter
Contact
#5050 · Other · via Contact Filter, Contact Company Filter
Team
#5083 · Other · via Team Filter
Close Opportunity Code
#5094 · Other · via Close Opportunity Filter