dbo.SXARCMTranslationDictionaryContentXREF 
Default Table Name  SXARCMTranslationDictionaryContentXREF 
Definition  Store Transaction Dictionary Code and Content Dictionary mapping information 

dbo.SXARCMTranslationDictionaryContentXREF Columns 
ColumnName  Domain  Datatype  NULL  Definition 
Build    int  NO  Identifies the build number and patch level of the software that inserted/updated this row. The format is the Build number followed by 3 digits for the patch level which is typically 000. The build number is tied to specific versions of the software, e.g. Sunrise 15.3 is Build 5021, Sunrise 16.3 is Build 5503. 
TouchedBy    varchar(50)  NO  Information about the user that last updated the row. This will typically be the UserID (IDCode from CV3User table) and may be prefixed with an environment identifier followed by an underscore, e.g. b96d2bf5_jongmore. 
TouchedWhenUTC    datetimeoffset(3)  NO  The date and time that the row was last updated including the time zone offset from UTC, for example 2015-01-30 04:55:04.372 -05:00. The date and time is based on the Enterprise Time Zone. 
CreatedBy    varchar(50)  NO  Information about the user that created the row. This will typically be the UserID (IDCode from CV3User table) and may be prefixed with an environment identifier followed by an underscore, e.g. b96d2bf5_jongmore. 
CreatedWhenUTC    datetimeoffset(3)  NO  The date and time that the row was created including the time zone offset from UTC, for example 2015-01-30 04:55:04.372 -05:00. The date and time is based on the Enterprise Time Zone. 
MSRowVersion    timestamp  NO  Optimistic lock identifier using rowversion datatype. 
Active    bit  NO  Denotes whether the row is active or not, 0 means the row has been soft deleted or deactivated. 
TranslationDictionaryContentXREFID(PK)    int  NO  Auto generated unique primary key value. 
ContentID(FK)    int  NO  A foreign key to the ContentID column in the SXARCMContent table. 
TranslationDictionaryID(FK)    int  NO  A foreign key to the TranslationDictionaryID column in the SXARCMTranslationDictionary table. 
StateTranslationDictionaryName    varchar(250)  YES  This coulmn contains display name of each translations defined for each state 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 
CodeDataTypeName    varchar(50)  YES  Data type name of Translated Master Code like varchar, bit or numeric 
CodeMaxLength    int  YES  Maximum length value of Translated Master Code 
CodeMinValue    numeric(18, 3)  YES  Minimum value of Translated Master Code 
CodeMaxValue    numeric(18, 3)  YES  Maximum value of Translated Master Code 
CodeRegExpression    nvarchar(500)  YES  Regular expression of Translated Master Code 
IsTranslationMasterCodeCreate    bit  NO  Flag to represent user can create Translation master record 
FilterString    varchar(100)  YES  Stores string for filteration 
IsTranslationMasterVisible    bit  NO  Value indicates if "Translation Master" screen is visible for this dictionary or not. 
VersionNumber    int  NO  Stores Version Number of the current Report Type 
SecondSourceFilterString    varchar(100)  YES  The string value determines the filter to be applied at the time of fetching values for second source code column in Translation Mapping 
IsTranslationMappingVisible    bit  NO  Value indicates if "Translation Mapping" screen is visible for this dictionary or not. 
SecondSourceParentFilterIDColumn    varchar(30)  YES  When it is required to filter second source code column based on chosen value of first source code columns, this holds the column name based on which filter hass to be applied 
ThirdSourceFilterString    varchar(100)  YES  This column stores filter string for third source 
ThirdSourceParentFilterIDColumn    varchar(30)  YES  This column stores parent filter id 

dbo.SXARCMTranslationDictionaryContentXREF Primary and Unique Keys 
Key Name  Key Type  Keys 
SXARCMTranslationDictionaryContentXREFPK  PrimaryKey  TranslationDictionaryContentXREFID