I've read elsewhere that all the GUIDs that used to be in the entity tables now reside in the SelectDb.pfm.Entity table. I believe I've got the correct join syntax to get the GUID for any entity in the database but want to be sure.
Would this be the correct way to get the GUID for a SelectDb.pfm.Order record:
Thanks--good to know. But I'm also looking for a more generic solution. So if I want the GUID for a property could I simply replace pfm.Property for pfm.Order in my query and achieve that?