Answer
Check whether the specific activated view being used for that entity's custom-field SQL actually exposes the column in question — custom-field validation checks against the columns the activated view exposes, not against the raw underlying table, so a standard column that's genuinely present on the table but happens to be missing from that particular activated view will trigger exactly this misleading "not an approved Custom Attribute" error, even though the column itself isn't custom at all.