I have a requirement where the client needs field permissions on certain financial fields on an entity which will allow reading/updating of the field for users within the BU of the record, but not to users in other BUs, similar to how security works on the entity level (with permissions being given at access levels of either: User, BU, Parent/Child BU, or Organisation). I know the basic field level security just allows the binary option of "users are never allowed to read/update the field" or "users can read/update the field as long as they have the appropriate entity permissions to the entity", with no discerning between records owned by you/your team, but is there a way to fulfil my requirement without something incredibly cumbersome like a copy of the field for each BU plus an additional field to aggregate them together for business logic?
To clarify the requirement, an example of the need would be for their UK sales people to be able to see a count of Orders owned by the US BU for a given Account (to see whether the Account is being actively engaged by other countries, for example) but not to see how much the Orders cost, but the UK sales people would still need to see and update the Order cost field for Orders owned by users in their UK BU. Is this possible?
