Primary Key Field Type
 ID uniqueidentifier

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) CONVERT(bigint, TS) Numeric representation of the timestamp.
 DATEPURGED datetime The date the historical import data was purged from the system.
 LISTBASERENTALCOSTBASIS nvarchar(12) (Computed) 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) CASE [LISTBASEEXCHANGECOSTBASISCODE] WHEN 1 THEN N'Per thousand' WHEN 2 THEN N'Flat' END Provides a translation for the 'LISTBASEEXCHANGECOSTBASISCODE' field.
 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 Key Field Type Null Notes Description
 ID uniqueidentifier   MKTSEGMENTLIST.ID Primary Key.
 LISTVENDORID uniqueidentifier VENDOR.ID Foreign key to VENDOR. The historical vendor of the list.
 LISTCATEGORYCODEID uniqueidentifier MKTLISTCATEGORYCODE.ID The historical category of the list.
 SEGMENTCATEGORYCODEID uniqueidentifier 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 CURRENCY.ID The base currency associated with this list.
 CURRENCYEXCHANGERATEID uniqueidentifier CURRENCYEXCHANGERATE.ID The exchange rate used to convert from cost to organization cost.

Index Name Field(s) Unique Primary Clustered
 IX_MKTSEGMENTLISTHISTORICAL_BASECURRENCYID BASECURRENCYID      
 IX_MKTSEGMENTLISTHISTORICAL_DATEADDED DATEADDED    
 IX_MKTSEGMENTLISTHISTORICAL_DATECHANGED DATECHANGED      
 IX_MKTSEGMENTLISTHISTORICAL_LISTCATEGORYCODEID LISTCATEGORYCODEID      
 IX_MKTSEGMENTLISTHISTORICAL_LISTVENDORID LISTVENDORID      
 IX_MKTSEGMENTLISTHISTORICAL_SEGMENTCATEGORYCODEID SEGMENTCATEGORYCODEID      
 PK_MKTSEGMENTLISTHISTORICAL ID  

Trigger Name Description
 TR_MKTSEGMENTLISTHISTORICAL_AUDIT_UPDATE
 TR_MKTSEGMENTLISTHISTORICAL_AUDIT_DELETE
 TR_MKTSEGMENTLISTHISTORICAL_IU_ORGANIZATIONAMOUNTS

Entity-Relationship diagram of this table