I need to add the assembly BOM field from the Item card in a view. This is a flow field. I have a view that is pulling the fields from the BOM component table in NAV . And I have a separate view that is pulling the fields from the item table (27). The Assembly BOM field as a flow field on the item card is a Boolean type. What will be the SQL statement that I need to add the Assembly BOM field to my Item view so that the Assembly BOM field will show up as "yes" or "no"?