BATCHDIRECTMARKETINGEFFORTSEGMENT (4.0SP12)

ID

uniqueidentifier

MKTSEGMENTID

uniqueidentifier

true

The existing segment record.

CODEPARTDEFINITIONVALUESID

uniqueidentifier

true

The source code part definition format value.

MKTSEGMENTCATEGORYCODEID

uniqueidentifier

true

A category for grouping segments together.

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

SITEID

uniqueidentifier

true

The site to which this segment belongs.

NAME

nvarchar(100)

false

The name of the segment.

DESCRIPTION

nvarchar(255)

false

A description about the segment.

CODE

nvarchar(10)

false

A unique code that identifies the segment.

SEGMENTTYPECODE

tinyint

false

The type of the segment.

SEGMENTTYPE

nvarchar(11) (Computed)

true

Provides a translation for the 'SEGMENTTYPECODE' field.

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.

SEGMENTSITEISNULL

bit

false

True if the segment site selected is a null site. False if a segment site was not chosen or was not included in the template.

IX_BATCHDIRECTMARKETINGEFFORTSEGMENT_CODEPARTDEFINITIONVALUESID

False

False

False

IX_BATCHDIRECTMARKETINGEFFORTSEGMENT_DATEADDED

False

False

True

IX_BATCHDIRECTMARKETINGEFFORTSEGMENT_DATECHANGED

False

False

False

IX_BATCHDIRECTMARKETINGEFFORTSEGMENT_MKTSEGMENTCATEGORYCODEID

False

False

False

IX_BATCHDIRECTMARKETINGEFFORTSEGMENT_MKTSEGMENTID

False

False

False

PK_BATCHDIRECTMARKETINGEFFORTSEGMENT

True

True

False

TR_BATCHDIRECTMARKETINGEFFORTSEGMENT_AUDIT_UPDATE

TR_BATCHDIRECTMARKETINGEFFORTSEGMENT_AUDIT_DELETE

BATCHDIRECTMARKETINGEFFORT

BATCHDIRECTMARKETINGEFFORTSEGMENTID