MKTSEGMENTLISTHISTORICAL

This table contains historical list and segment information about list segments.

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
LISTNAME	nvarchar(100)		Default = ''	The historical name of the list.
LISTDESCRIPTION	nvarchar(255)		Default = ''	The historical description of the list.
LISTCODE	nvarchar(10)		Default = ''	The historical code of the list.
LISTBASERENTALCOST	money		Default = 0	The historical base cost to rent the list.
LISTBASERENTALCOSTBASISCODE	tinyint		Default = 1	The historical basis on which the base cost to rent the list should be calculated.
LISTBASEEXCHANGECOST	money		Default = 0	The historical base cost associated with obtaining the list via an exchange.
LISTBASEEXCHANGECOSTBASISCODE	tinyint		Default = 1	The historical basis on which the base cost associated with obtaining the list via an exchange should be calculated.
SEGMENTNAME	nvarchar(100)		Default = ''	The historical name of the segment.
SEGMENTDESCRIPTION	nvarchar(255)		Default = ''	The historical description of the segment.
SEGMENTCODE	nvarchar(10)		Default = ''	The historical code of the segment.
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)	yes	CONVERT(bigint, TS)	Numeric representation of the timestamp.
LISTBASERENTALCOSTBASIS	nvarchar(12) (Computed)	yes	CASE [LISTBASERENTALCOSTBASISCODE] WHEN 1 THEN N'Per thousand' WHEN 2 THEN N'Flat' END	Provides a translation for the 'LISTBASERENTALCOSTBASISCODE' field.
LISTBASEEXCHANGECOSTBASIS	nvarchar(12) (Computed)	yes	CASE [LISTBASEEXCHANGECOSTBASISCODE] WHEN 1 THEN N'Per thousand' WHEN 2 THEN N'Flat' END	Provides a translation for the 'LISTBASEEXCHANGECOSTBASISCODE' field.
DATEPURGED	datetime	yes		The date the historical import data was purged from the system.
ORGANIZATIONLISTBASERENTALCOST	money		Default = 0	The cost of the rented records in the organization currency.
ORGANIZATIONLISTBASEEXCHANGECOST	money		Default = 0	The cost of the records received via exchange in the organization currency.

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
ID	uniqueidentifier		MKTSEGMENTLIST.ID	Primary Key.
LISTVENDORID	uniqueidentifier	yes	VENDOR.ID	Foreign key to VENDOR. The historical vendor of the list.
LISTCATEGORYCODEID	uniqueidentifier	yes	MKTLISTCATEGORYCODE.ID	The historical category of the list.
SEGMENTCATEGORYCODEID	uniqueidentifier	yes	MKTSEGMENTCATEGORYCODE.ID	Foreign key to MKTSEGMENTCATEGORYCODE. The historical category of the segment.
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
BASECURRENCYID	uniqueidentifier	yes	CURRENCY.ID	The base currency associated with this list.
CURRENCYEXCHANGERATEID	uniqueidentifier	yes	CURRENCYEXCHANGERATE.ID	The exchange rate used to convert from cost to organization cost.

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_MKTSEGMENTLISTHISTORICAL_BASECURRENCYID	BASECURRENCYID
IX_MKTSEGMENTLISTHISTORICAL_DATEADDED	DATEADDED			yes
IX_MKTSEGMENTLISTHISTORICAL_DATECHANGED	DATECHANGED
IX_MKTSEGMENTLISTHISTORICAL_LISTCATEGORYCODEID	LISTCATEGORYCODEID
IX_MKTSEGMENTLISTHISTORICAL_LISTVENDORID	LISTVENDORID
IX_MKTSEGMENTLISTHISTORICAL_SEGMENTCATEGORYCODEID	SEGMENTCATEGORYCODEID
PK_MKTSEGMENTLISTHISTORICAL	ID	yes	yes

Triggers

Trigger Name	Description
TR_MKTSEGMENTLISTHISTORICAL_AUDIT_UPDATE
TR_MKTSEGMENTLISTHISTORICAL_AUDIT_DELETE
TR_MKTSEGMENTLISTHISTORICAL_IU_ORGANIZATIONAMOUNTS