i have to create field ESTIMATE_STATUS in Ztable values allowed only UPPERCASE .
the allowed values are for the field are PENDING, ACTIVE, CLOSED . how to do it.
2 nd requirement: is i have to create filed ESTMATE_NBR the values for the field must be generated sequentiall by the system.
thanks in advance.