Mar 6, 2018

Unicode string FK

1 comment


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 ?


Steven Sitas
Mar 6, 2018

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 ...



New Posts
  • legalpride
    Sep 29

    To do bank reconciliation I am using more than one bank and do receipting and payments to these bank accounts from customers and supplier. I receive an electronic bank statement and then need to provide a bank account reconciliation function to balance back to the bank statement. How would the cashbook transactions such as payments and receipts fit in to support a reconciliation function within the a360 data module paradigm of bBusinessDocument_CashLine - SalesAR Payment – bBusinessDocument - gCashBook or am I missing something? Thanks, Andre
  • reimic5
    Oct 18

    Is it possible to convert database to HFSQL C/S ?
  • Steven Sitas
    Aug 16, 2017

    Here you can post questions about our alpha360 Data Models


Leoforos Dodonis 43,  45221


Registered VAT ID: EL084190121