Brendan Vogt wrote:
When it is ideal to use a number Id or a text Id?
I've also stumbled over that as well. From my perspective, if you have
an account that is used a lot like a supplier or repeat customer, it
makes sence to create a partyId with a nemonic that is memorable, since
someone may have to look them up several times a month. For the random
web customer, the next available number is fine.
Remember that field (partyId) is really a text field for sorting
purposes, so even if you see only numbers, if you sort by it by partyId,
it sorts alphabetically (198765 comes before 20000 since the first
character is a "1").
--
Walter
