Other table in Microsoft Dynamics 365 Business Central. 43 fields, 3 records in Cronus demo.
The Campaign table (ID 5071) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 43 fields, with a primary key of No., and includes 11 calculated FlowFields. Use the reference below to explore every field, data type, and table relation.
The primary key uniquely identifies each record in this table. It consists of: No..
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 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 |
Tables referenced by fields on the Campaign table through TableRelation properties.