DataGrid = 100 THEN 'Custom: ' + Grp.[Name] ELSE '' END AS [Scheme] ,CASE WHEN PD.[Scheme] = 1 OR PD.[Scheme] = 6 THEN 'Both' -- UOM or Currency WHEN PD.[Scheme] <= 8 THEN 'Text' ELSE 'Member' -- collection member GUID END AS [DataType] ,PD.[Description] ,PD.[DefaultValue] AS [DefaultText] ,ISNULL(BO.[Name],'') AS [DefaultSelection] ,LTRIM(RTRIM(PD.[DefaultValue] + ' ' + ISNULL(BO.[Name],''))) AS [DefaultValue] ,PD.[SQLName] AS [SQLColumnName] FROM [PropertyDescriptor_View] PD INNER JOIN BusinessObject_View Typ ON Typ.Id = PD.ItemType LEFT JOIN [CustomGroup_View] Grp ON (100 + Grp.[Uid]) = PD.[Scheme] LEFT JOIN [BusinessObject_View] BO ON BO.[Id] = PD.[UomId] ORDER BY Name, Member ]]>