String or binary data would be truncated.
The statement has been terminated.
 Version No: 2020.1.0.0
INSERT INTO TRANS_MAIL_TMPL_FIELD_DTLS(FIELD_ID,FIELD_CAPTION,FIELD_NAME,COLUMN_LENGTH,OBJECT_TYPE)	
SELECT	ISNULL((SELECT MAX(FIELD_ID) from TRANS_MAIL_TMPL_FIELD_DTLS),0) + ROW_NUMBER()OVER(ORDER BY C.CHAR_ID)
	,C.CHAR_NAME,C.FIELD_NAME,CASE WHEN C.FIELD_SIZE<20 THEN 20 ELSE C.FIELD_SIZE END FIELD_SIZE,5
FROM	CUSTOM_CHAR_MSTR C
WHERE	CHAR_ID IN(
		SELECT	CHAR_ID FROM CUSTOM_CLASS_CHAR_MSTR 
			WHERE	CLASS_ID IN(
				SELECT	DISTINCT CLASS_ID FROM CUSTOM_OBJ_TYPE_CLASS_LINK 
						WHERE	OBJ_TYPE IN(5)
					)
			    )
AND NOT EXISTS(SELECT 1 FROM TRANS_MAIL_TMPL_FIELD_DTLS T WHERE T.FIELD_NAME = C.FIELD_NAME AND T.OBJECT_TYPE=5)