Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(100)   Default = '' The name of the package.
 DESCRIPTION nvarchar(255)   Default = '' A description about the package.
 CODE nvarchar(10)   Default = '' A unique code that identifies the package.
 CHANNELCODE nvarchar(10)   Default = '' A code that identifies the channel of the package.
 PACKAGETYPECODE tinyint   Default = 0 The type of the package.
 PACKAGETYPE nvarchar(5) (Computed) CASE [PACKAGETYPECODE] WHEN 0 THEN N'Mail' WHEN 1 THEN N'Email' WHEN 2 THEN N'Phone' END Provides a translation for the 'PACKAGETYPECODE' field.
 COST money   Default = 0 The base cost of the package.
 COSTDISTRIBUTIONMETHODCODE tinyint   Default = 0 The method to be used to apply the package's base cost to a marketing effort.
 DATEADDED datetime   Default = getdate() Indicates the date this record was added.
 DATECHANGED datetime   Default = getdate() Indicates the date this record was last changed.
 TS timestamp   Timestamp.
 TSLONG bigint (Computed) CONVERT(bigint, TS) Numeric representation of the timestamp.
 COSTDISTRIBUTIONMETHOD nvarchar(20) (Computed) CASE [COSTDISTRIBUTIONMETHODCODE] WHEN 0 THEN N'Per piece' WHEN 1 THEN N'Per response' WHEN 2 THEN N'Per marketing effort' WHEN 3 THEN N'Do not include' WHEN 4 THEN N'Per thousand' END
 PACKAGESITEISNULL bit   Default = 0

Foreign Key Field Type Null Notes Description
 MKTPACKAGEID uniqueidentifier MKTPACKAGE.ID The existing package record.
 CODEPARTDEFINITIONVALUESID uniqueidentifier MKTSOURCECODEPARTDEFINITIONVALUES.ID The source code part definition format value.
 CHANNELCODEPARTDEFINITIONVALUESID uniqueidentifier MKTSOURCECODEPARTDEFINITIONVALUES.ID The channel source code part definition format value.
 MKTPACKAGECATEGORYCODEID uniqueidentifier MKTPACKAGECATEGORYCODE.ID A category for grouping packages together.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 BASECURRENCYID uniqueidentifier CURRENCY.ID The base currency associated with the package.
 SITEID uniqueidentifier SITE.ID

Index Name Field(s) Unique Primary Clustered
 IX_BATCHDIRECTMARKETINGEFFORTPACKAGE_BASECURRENCYID BASECURRENCYID      
 IX_BATCHDIRECTMARKETINGEFFORTPACKAGE_CHANNELCODEPARTDEFINITIONVALUESID CHANNELCODEPARTDEFINITIONVALUESID      
 IX_BATCHDIRECTMARKETINGEFFORTPACKAGE_CODEPARTDEFINITIONVALUESID CODEPARTDEFINITIONVALUESID      
 IX_BATCHDIRECTMARKETINGEFFORTPACKAGE_DATEADDED DATEADDED    
 IX_BATCHDIRECTMARKETINGEFFORTPACKAGE_DATECHANGED DATECHANGED      
 IX_BATCHDIRECTMARKETINGEFFORTPACKAGE_MKTPACKAGECATEGORYCODEID MKTPACKAGECATEGORYCODEID      
 IX_BATCHDIRECTMARKETINGEFFORTPACKAGE_MKTPACKAGEID MKTPACKAGEID      
 PK_BATCHDIRECTMARKETINGEFFORTPACKAGE ID  

Trigger Name Description
 TR_BATCHDIRECTMARKETINGEFFORTPACKAGE_INSERTUPDATE_CURRENCY
 TR_BATCHDIRECTMARKETINGEFFORTPACKAGE_AUDIT_UPDATE
 TR_BATCHDIRECTMARKETINGEFFORTPACKAGE_AUDIT_DELETE

Referenced by Field
 BATCHDIRECTMARKETINGEFFORT BATCHDIRECTMARKETINGEFFORTPACKAGEID

Entity-Relationship diagram of this table