Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 FIELDNAME nvarchar(50)   Default = '' Stores the field name of the list layout field; if this is SYSTEM then it should exactly match the column name from the source query view.
 OBJECTNAME nvarchar(255)   Default = '' Stores the object name of field from the layout source.
 SOURCENAME nvarchar(128)   Default = '' Stores the name of field from the source file.
 FRIENDLYNAME nvarchar(50)   Default = '' Stores the friendly name of the list layout field that will be used to display the field name throughout the system.
 MAPPINGCODE tinyint   Default = 0 Contains the type of field mapping, SYSTEM is a field defined by the source query view, USER is user defined.
 DATATYPE tinyint   Default = 0 Contains the data type for the field from the file (XmlTypes.FormFieldDataType).
 SEQUENCE int   Default = 0 Determines relative position of the field in the overall list of fields.
 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.
 MAPPING nvarchar(13) (Computed) CASE [MAPPINGCODE] WHEN 0 THEN N'Not mapped' WHEN 1 THEN N'System' WHEN 2 THEN N'User' WHEN 3 THEN N'Do not import' END Provides a translation for the 'MAPPINGCODE' field.
 ISIDFIELD bit   Default = 0
 IDTYPECODE tinyint   Default = 0
 IDTYPE nvarchar(19) (Computed) CASE [IDTYPECODE] WHEN 0 THEN N'System record ID' WHEN 1 THEN N'Lookup ID' WHEN 2 THEN N'Alternate lookup ID' END

Foreign Key Field Type Null Notes Description
 LISTLAYOUTID uniqueidentifier   MKTLISTLAYOUT.ID The list layout that contains these fields.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 ALTERNATELOOKUPIDTYPECODEID uniqueidentifier ALTERNATELOOKUPIDTYPECODE.ID

Index Name Field(s) Unique Primary Clustered
 IX_MKTLISTLAYOUTFIELD_DATEADDED DATEADDED    
 IX_MKTLISTLAYOUTFIELD_DATECHANGED DATECHANGED      
 IX_MKTLISTLAYOUTFIELD_LISTLAYOUTID LISTLAYOUTID      
 PK_MKTLISTLAYOUTFIELD ID  

Trigger Name Description
 TR_MKTLISTLAYOUTFIELD_AUDIT_UPDATE
 TR_MKTLISTLAYOUTFIELD_AUDIT_DELETE

Entity-Relationship diagram of this table