Back in time I have tested almost all field types in Wix and only those are accepted with external collections:
any will not throw an error but techincally not supported
use lowercase when you are typing not like in the image I posted. Like “number” or “datetime” or “date” etc.