Open topic with navigation

REVENUELETTERMARKETING (4.0SP20)

Stores information pertaining to revenue details and their corresponding marketing letters.

Primary Key
Primary Key Field Type

ID

uniqueidentifier
Foreign Key Fields
Foreign Key Field Type Null Notes Description

MKTACKNOWLEDGEMENTMAILINGPROCESSSTATUSID

uniqueidentifier

true

A foreign key to the MKTACKNOWLEDGEMENTMAILINGPROCESSSTATUS table.

MKTSEGMENTID

uniqueidentifier

true

A foreign key to the MKTSEGMENT table.

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

MKTSEGMENTATIONID

uniqueidentifier

true

A foreign key to the MKTSEGMENTATION table.

MKTPACKAGEID

uniqueidentifier

true

Fields
Field Field Type Null Notes Description

DATEADDED

datetime

false

getdate()

Indicates the date this record was added.

DATECHANGED

datetime

false

getdate()

Indicates the date this record was last changed.

TS

timestamp

false

Timestamp.

TSLONG

bigint (Computed)

true

Numeric representation of the timestamp.

EXISTINGREVENUELETTER

bit

false

0

Determines whether or not the revenue letter was a pre-existing letter the user manually entered.
Indexes
Index Name Field(s) Unique Primary Clustered

IX_REVENUELETTERMARKETING_DATEADDED

DATEADDED

False

False

True

IX_REVENUELETTERMARKETING_DATECHANGED

DATECHANGED

False

False

False

IX_REVENUELETTERMARKETING_MKTACKNOWLEDGEMENTMAILINGPROCESSSTATUSID_EXISTINGREVENUELETTER

MKTACKNOWLEDGEMENTMAILINGPROCESSSTATUSID

EXISTINGREVENUELETTER

False

False

False

IX_REVENUELETTERMARKETING_MKTPACKAGEID

MKTPACKAGEID

False

False

False

IX_REVENUELETTERMARKETING_MKTSEGMENTATIONID_MKTSEGMENTID_MKTPACKAGEID

MKTSEGMENTATIONID

MKTSEGMENTID

MKTPACKAGEID

False

False

False

IX_REVENUELETTERMARKETING_MKTSEGMENTID

MKTSEGMENTID

False

False

False

PK_REVENUELETTERMARKETING

ID

True

True

False
Triggers
Trigger Name Description

TR_REVENUELETTERMARKETING_AUDIT_UPDATE

TR_REVENUELETTERMARKETING_AUDIT_DELETE