On the data model all the indexes/ID are “Text” “Unicode string”, what is the main reason for this. I need to add another one of my existing files from another system called “PartyType” and its PK is 4-byte integer. Can I keep it that way because the data already exist? Or should I NOT use 4-byte integer ID’s ?
The reason we use unicode strings (GUIDs) as Primary keys (PK) is to make Replication support a lot easier.
If you don't intend to use Replication on a specific file, it is OK to use in that file an Integer (4/8 byte) as a PK - otherwise give it some thought ...