Stores package information for Direct Marketing Effort batches.
Foreign Key Fields
| Foreign Key |
Field Type |
Null |
Notes |
Description |
|
MKTPACKAGEID
|
uniqueidentifier
|
true
|
|
The existing package record.
|
|
CODEPARTDEFINITIONVALUESID
|
uniqueidentifier
|
true
|
|
The source code part definition format value.
|
|
CHANNELCODEPARTDEFINITIONVALUESID
|
uniqueidentifier
|
true
|
|
The channel source code part definition format value.
|
|
MKTPACKAGECATEGORYCODEID
|
uniqueidentifier
|
true
|
|
A category for grouping packages together.
|
|
ADDEDBYID
|
uniqueidentifier
|
false
|
|
FK to CHANGEAGENT.
|
|
CHANGEDBYID
|
uniqueidentifier
|
false
|
|
FK to CHANGEAGENT.
|
|
BASECURRENCYID
|
uniqueidentifier
|
true
|
|
The base currency associated with the package.
|
|
SITEID
|
uniqueidentifier
|
true
|
|
The site to which this package belongs.
|
Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
NAME
|
nvarchar(100)
|
false
|
|
The name of the package.
|
|
DESCRIPTION
|
nvarchar(255)
|
false
|
|
A description about the package.
|
|
CODE
|
nvarchar(10)
|
false
|
|
A unique code that identifies the package.
|
|
CHANNELCODE
|
nvarchar(10)
|
false
|
|
A code that identifies the channel of the package.
|
|
PACKAGETYPECODE
|
tinyint
|
false
|
|
The type of the package.
|
|
PACKAGETYPE
|
nvarchar(5) (Computed)
|
true
|
|
Provides a translation for the 'PACKAGETYPECODE' field.
|
|
COST
|
money
|
false
|
|
The base cost of the package.
|
|
COSTDISTRIBUTIONMETHODCODE
|
tinyint
|
false
|
|
The method to be used to apply the package's base cost to a marketing effort.
|
|
DATEADDED
|
datetime
|
false
|
|
Indicates the date this record was added.
|
|
DATECHANGED
|
datetime
|
false
|
|
Indicates the date this record was last changed.
|
|
TS
|
timestamp
|
false
|
|
Timestamp.
|
|
TSLONG
|
bigint (Computed)
|
true
|
|
Numeric representation of the timestamp.
|
|
COSTDISTRIBUTIONMETHOD
|
nvarchar(20) (Computed)
|
true
|
|
Provides a translation for the 'COSTDISTRIBUTIONMETHODCODE' field.
|
|
PACKAGESITEISNULL
|
bit
|
false
|
|
True if the package site selected is a null site. False if a package site was not chosen or was not included in the template.
|
Indexes
| Index Name |
Field(s) |
Unique |
Primary |
Clustered |
|
IX_BATCHDIRECTMARKETINGEFFORTPACKAGE_BASECURRENCYID
|
|
False
|
False
|
False
|
|
IX_BATCHDIRECTMARKETINGEFFORTPACKAGE_CHANNELCODEPARTDEFINITIONVALUESID
|
CHANNELCODEPARTDEFINITIONVALUESID
|
False
|
False
|
False
|
|
IX_BATCHDIRECTMARKETINGEFFORTPACKAGE_CODEPARTDEFINITIONVALUESID
|
CODEPARTDEFINITIONVALUESID
|
False
|
False
|
False
|
|
IX_BATCHDIRECTMARKETINGEFFORTPACKAGE_DATEADDED
|
|
False
|
False
|
True
|
|
IX_BATCHDIRECTMARKETINGEFFORTPACKAGE_DATECHANGED
|
|
False
|
False
|
False
|
|
IX_BATCHDIRECTMARKETINGEFFORTPACKAGE_MKTPACKAGECATEGORYCODEID
|
|
False
|
False
|
False
|
|
IX_BATCHDIRECTMARKETINGEFFORTPACKAGE_MKTPACKAGEID
|
|
False
|
False
|
False
|
|
PK_BATCHDIRECTMARKETINGEFFORTPACKAGE
|
|
True
|
True
|
False
|
