How do the UDF properties work? Any link with a table or logic?

Legacy Contributor

I noticed many IDOs have several user-defined properties (UDFShortText1, UDFDataTime, etc.).

However they do not seem to be linked to a table column... are they?

Also, are they included by default in IDO methods ? Stored Procedures ?

 

I'm trying to figure out the purpose of these UDF properties, because if I add a UET Field I would still need to create its IDO Property and/or modify an IDO Method and/or SP to handle it properly.

Legacy Contributor

UDF's are a hold ovter from the pre-SyteLine 8.00 days. There is a table for them, which basically holds a record for each table record that uses the UDF fields. They should be considered deprecated and not used and only exist for backwards compatibility. UET's are the correct way to add custom attributes to IDOs. You do not need to add an IDO Property to use a UET. They are referenced on a form by the table alias (e.g. itm for item) and the UET field name (itmUf_SomeField). IDO Methods also can reference the UET in the same matter. Yes, you would have to add the UET to a SP. But that's another reason to start using IDO Custom Assemblies, so you don't have to.

0911060553270289.pdf