this has taken me a lttle while to work out today so this might save time for you guys....
The most likely use of precision sql data types is in the use of "Money".... This is not a valid .Net/C# datatype but maps to a "Decimal(19,4)". Use the Decimal as the property datatype for moeny fields because it iis more precise, this can then be mapped using the following in NHibernate:
<property name="[Property Name]" type="Decimal(19,4)">
<column name="[Column Name]" sql-type="Money" />
</property>