You will need to create a new field in the DocuWare file cabinet with a type of either numeric or decimal. Then, you will need to transfer the contents of the text field to the new numeric or decimal field using a query in the database, since you cannot transfer text data to numeric with Autoindex.
Generally MSSQL will transfer data from a varchar field to an INT (numeric field) as an implicit conversion - meaning that you do not need to specify a conversion. You will however need to pay careful attention to decimal places if you use an INT (numeric field).
If your text value is '10.00' then you need to strip the decimal and write 1000 to the numeric field (if you have it set to 2 decimal places in DocuWare).
If you want to write it to a decimal field then I think that will work as a straight copy since that conversion is also an implicit conversion. My preference would be to create the new field as decimal as this will be a simpler conversion.
When transferring data, you must also be careful not to try and write anything else but numerical data otherwise your query will fail on the first record where the conversion cannot be completed.
Whatever you do you need to check the converted data carefully to ensure that you have written the values correctly depending on the target field type.
If all that seems a little difficult, Professional Services will be pleased to provide a quote to do the conversion for you.
Senior Director Client Services, Americas