tbl_Campaign [Campaign]

Property	Value
Name	tbl_Campaign
Caption	Campaign
Module	X15
USI	X15\Workspaces\Campaigns\General\Main Grid\tbl_Campaign
Table Group	tg_Campaings
Is administrated by field	Yes
Is administrated by record	Yes
Record change is logged	No

Fields

#	Name	Type	Name
1.	ID	Identifier	Campaign
2.	Name	Unicode string [250]	Campaign
3.	CampaignFamilyID	Unique identifier GUID	Campaign Family
4.	CampaignTypeID	Unique identifier GUID	Campaign type
5.	SourceID	Unique identifier GUID	Campaign Source
6.	TerritoryID	Unique identifier GUID	Territory
7.	Objectives	Unicode string [250]	Objective
8.	ActualLaunch	Date/Time	Actual Launch Date
9.	DueDate	Date/Time	End Date
10.	StartPrepare	Date/Time	Preparation Start Date
11.	StatusID	Unique identifier GUID	Status
12.	CurrencyID	Unique identifier GUID	Currency
13.	Rate	Float [15]	Currency Rate
14.	EstimatedBudget	Float [15]	Expected Budget
15.	ActualCost	Float [15]	Actual Cost
16.	EstimatedBasicBudget	Float [15]	Expected Budget (b.c.)
17.	ActualBasicCost	Float [15]	Actual Cost (b.c.)
18.	ExpectedResult	Float [15]	Expected Result
19.	PotentialResponses	Integer	Expected Response
20.	ActualResult	Float [15]	Actual Result
21.	ActualSales	Float [15]	Actual Sales Amount
22.	OwnerID	Unique identifier GUID	Owner
23.	ExpectedROI	Float [15]	Expected ROI
24.	ActualROI	Float [15]	Actual ROI
25.	PullingDate	Date/Time	Impact Start Date
26.	DuePullingDate	Date/Time	Impact End Date
27.	CreatedOn	Date/Time	Created On
28.	CreatedByID	Unique identifier GUID	Created By
29.	ModifiedOn	Date/Time	Modification Date
30.	ModifiedByID	Unique identifier GUID	Modified By
31.	Description	Large binary object	Description
32.	AudienceNumber	Integer	Audience Number
33.	ActualResponses	Integer	Actual Response
34.	CalculateAudience	Boolean	Calculate Audience
35.	CalculateActualResponses	Boolean	Calculate Actual Response
36.	Audience	Unicode string [250]	Audience
37.	ExpectedSales	Float [15]	Expected Sales
38.	CalculateSalesID	Unique identifier GUID	Calculate Sum

Relations

#	Relation name	Field	Table	Cascade relation
1.	FCampaign_TerritoryID	TerritoryID	tbl_Territory	No
2.	FCampaign_SourceID	SourceID	tbl_CampaignSource	No

Indexes

#	Name	Unique	Structure
1.	ICampaign	No	SourceID
2.	ICampaign1	No	TerritoryID
3.	ICampaignCreatedByID	No	CreatedByID
4.	ICampaignModifiedByID	No	ModifiedByID
5.	ICampaignCampaignFamilyID	No	CampaignFamilyID
6.	ICampaignCampaignTypeID	No	CampaignTypeID
7.	ICampaignCurrencyID	No	CurrencyID
8.	ICampaignOwnerID	No	OwnerID
9.	ICampaignStatusID	No	StatusID