Skip to main content

Friday amusement for all of us developers.

  • December 13, 2024
  • 2 replies
  • 36 views
D
Captain II
Forum|alt.badge.img+7

​@Dmitrii Naumov - can you send this to whomever needs to see it?

I was looking at the SOAddress table and noticed the field length on the PostalCode field.  Might be excessive.

 

Edit: There’s probably a good reason for this. SOAddress’ fields are all 2500 nvarchars.

    Dmitrii Naumov
    Chris Hackett

    2 replies

    Dmitrii Naumov
    Acumatica Moderator
    Forum|alt.badge.img+7
    • Dmitrii Naumov
    • Acumatica Moderator
    • December 16, 2024

    ​@Django for some of the features of the product we need to encrypt “personal data”, including customer addresses. Since the encrypted string may be long, all the fields in these tables are made 2500 characters long

    D
    Chris Hackett
    D
    Captain II
    Forum|alt.badge.img+7
    • Django
    • Author
    • Captain II
    • December 16, 2024

    Thank you for the explanation!

    Chris Hackett
    Terms & ConditionsCookie settingsAccessibility statement
    About Acumatica ERP system
    Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
    © 2008 — 2024  Acumatica, Inc. All rights reserved