Find what a text box on an IFS Form is linked to in the database

Try Solution Manager\System Information and Utilities\Logical Units\Logical Unit.

Thank you for the response @Technical Outlaws 

The logical unit page appears to give information on the views relation to the underlying table, but in this case looking for the connection to the application form. For another example to showcase this, how might I know that “Coordinator” on the purchase order form resolves to Authorize_Code  in the purchase_order_tab table if I didn’t already know that?

In your above supplied image the reference for authorize code is OrderCoordinator which would be a clue to that, but what about in a case where that reference was less obvious? 

There are also cases where elements on the form aren’t taken directly from an underlying view or table, but are instead using a database function and these wouldn’t show up on this logical unit page. ( e.g. Supplier_API.Get_Vendor_name() is used to get the supplier name on the Purchase Order form ). In cases where the form element isn’t searchable these can be tricky to track down.

Thanks,

Lavon

@Charith Epitawatta Thanks!

I just wanted to be certain there wasn’t a more optimal way to approach this, and now I know =)

-Lavon