I couldnt get access to that tool though.
In th efield table all info is there but the datatype is in int value. I want to display value in the normal names like (Character, Trim Text ) etc. IS there any table where this mapping is stored?
You won't have it in the database.
I don't have a VM right now since I'm at home and leaving for work but check the "/api/" folder for "ar.h" header file, you could have some "define"that might help you:
Check those threads:
As Laurent suggested,ar.h file contains below information.
#define AR_DATA_TYPE_NULL 0 /* code for a NULL value */
#define AR_DATA_TYPE_KEYWORD 1 /* code indicating a keyword setting */
#define AR_DATA_TYPE_INTEGER 2 /* codes for the data type of a value */
#define AR_DATA_TYPE_REAL 3
#define AR_DATA_TYPE_CHAR 4
#define AR_DATA_TYPE_DIARY 5
#define AR_DATA_TYPE_ENUM 6
#define AR_DATA_TYPE_TIME 7
#define AR_DATA_TYPE_BITMASK 8
#define AR_DATA_TYPE_BYTES 9
#define AR_DATA_TYPE_DECIMAL 10
#define AR_DATA_TYPE_ATTACH 11
#define AR_DATA_TYPE_CURRENCY 12
#define AR_DATA_TYPE_DATE 13
#define AR_DATA_TYPE_TIME_OF_DAY 14
You can make use of these numeric values & accordingly create some workflows to set the Name.