can't create constraint for ad_entitytype_id column on pack out detail
Description
on window table & column choose record of "AD_Package_Exp_Detail" go to column AD_EntityType_ID and do a sync column get below issue
i guess almost table when refer to ad_entitytype use column entitytype, so logic to create constrain just care this column.
it's better to move AD_Package_Exp_Detail/AD_EntityType_ID to AD_Package_Exp_Detail/entitytype? will have to modify code at package out to lookup by entitytype, not by AD_EntityType_ID
This incompatible type error seems to happen in 8.2 also, with another columns. I’ve created a custom column DEV_CreatedBy, type Search, Reference to another table DEV_User, and when using Cascade as constraint, I got “...incompatible types: numeric and character varying”.
Minor
on window table & column choose record of "AD_Package_Exp_Detail"
go to column AD_EntityType_ID and do a sync column
get below issue
i guess almost table when refer to ad_entitytype use column entitytype, so logic to create constrain just care this column.
it's better to move AD_Package_Exp_Detail/AD_EntityType_ID to AD_Package_Exp_Detail/entitytype?
will have to modify code at package out to lookup by entitytype, not by AD_EntityType_ID