Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 OVERRIDEQUANTITIESANDORSEGMENTCOSTS bit   Default = 0 If this is set, the quantities and/or variable costs obtained from this marketing effort segment's originating segment have been explicitly overridden.
 OVERRIDELISTCOSTS bit   Default = 0 If this is set, the fixed costs obtained from this marketing effort segment's originating list have been explicitly overridden.
 BASERENTALCOST money   Default = 0 The rental cost of the list segment's parent list.
 BASERENTALCOSTBASISCODE tinyint   Default = 1 The basis on which the rental cost of the list segment's parent list as a whole should be calculated.
 BASERENTALCOSTBASIS nvarchar(12) (Computed) CASE [BASERENTALCOSTBASISCODE] WHEN 1 THEN N'Per thousand' WHEN 2 THEN N'Flat' END Provides a translation for the 'BASERENTALCOSTBASISCODE' field.
 BASEEXCHANGECOST money   Default = 0 The exchange cost of the list segment's parent list.
 BASEEXCHANGECOSTBASISCODE tinyint   Default = 1 The basis on which the exchange cost of the list segment's parent list as a whole should be calculated.
 BASEEXCHANGECOSTBASIS nvarchar(12) (Computed) CASE [BASEEXCHANGECOSTBASISCODE] WHEN 1 THEN N'Per thousand' WHEN 2 THEN N'Flat' END Provides a translation for the 'BASEEXCHANGECOSTBASISCODE' field.
 RENTALQUANTITY int   Default = 0 The number of rental records in this list segment.
 RENTALCOSTADJUSTMENT money   Default = 0 The cost adjustment of the rental records in this list segment.
 RENTALCOSTADJUSTMENTBASISCODE tinyint   Default = 1 The basis on which the cost adjustment of the rental records in this list segment should be calculated.
 RENTALCOSTADJUSTMENTBASIS nvarchar(12) (Computed) CASE [RENTALCOSTADJUSTMENTBASISCODE] WHEN 1 THEN N'Per thousand' WHEN 2 THEN N'Flat' END Provides a translation for the 'RENTALCOSTADJUSTMENTBASISCODE' field.
 EXCHANGEQUANTITY int   Default = 0 The number of exchange records in this list segment.
 EXCHANGECOSTADJUSTMENT money   Default = 0 The cost adjustment of the exchange records in this list segment.
 EXCHANGECOSTADJUSTMENTBASISCODE tinyint   Default = 1 The basis on which the cost adjustment of the exchange records in this list segment should be calculated.
 EXCHANGECOSTADJUSTMENTBASIS nvarchar(12) (Computed) CASE [EXCHANGECOSTADJUSTMENTBASISCODE] WHEN 1 THEN N'Per thousand' WHEN 2 THEN N'Flat' END Provides a translation for the 'EXCHANGECOSTADJUSTMENTBASISCODE' field.
 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.
 ORGANIZATIONBASERENTALCOST money   Default = 0 The amount of the base rental cost in organization currency.
 ORGANIZATIONBASEEXCHANGECOST money   Default = 0 The amount of the base exchange cost in organization currency.
 ORGANIZATIONRENTALCOSTADJUSTMENT money   Default = 0 The amount of the rental cost adjustment in organization currency.
 ORGANIZATIONEXCHANGECOSTADJUSTMENT money   Default = 0 The amount of the exchange cost adjustment in organization currency.

Foreign Key Field Type Null Notes Description
 ID uniqueidentifier   MKTSEGMENTATIONSEGMENT.ID Primary Key.
 SEGMENTLISTID uniqueidentifier MKTSEGMENTLIST.ID Foreign key to MKTSEGMENTLIST. The list segment associated with this row. Only set when a marketing effort is activated.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 BASECURRENCYID uniqueidentifier CURRENCY.ID The base currency associated with this segmentation segment.
 ORGANIZATIONCURRENCYEXCHANGERATEID uniqueidentifier CURRENCYEXCHANGERATE.ID The exchange rate used to convert from the amounts to organization amounts.

Index Name Field(s) Unique Primary Clustered
 IX_MKTSEGMENTATIONSEGMENTLIST_BASECURRENCYID BASECURRENCYID      
 IX_MKTSEGMENTATIONSEGMENTLIST_DATEADDED DATEADDED    
 IX_MKTSEGMENTATIONSEGMENTLIST_DATECHANGED DATECHANGED      
 IX_MKTSEGMENTATIONSEGMENTLIST_ORGANIZATIONCURRENCYEXCHANGERATEID ORGANIZATIONCURRENCYEXCHANGERATEID      
 IX_MKTSEGMENTATIONSEGMENTLIST_SEGMENTLISTID SEGMENTLISTID      
 PK_MKTSEGMENTATIONSEGMENTLIST ID  

Trigger Name Description
 TR_MKTSEGMENTATIONSEGMENTLIST_IU_ORGANIZATIONAMOUNTS
 TR_MKTSEGMENTATIONSEGMENTLIST_AUDIT_UPDATE
 TR_MKTSEGMENTATIONSEGMENTLIST_AUDIT_DELETE

Entity-Relationship diagram of this table