Skip to main content
Question

Customer and Supplier Master Data Setup

Do Gooder

Are there any character limitations for a customer or supplier name?

    4 replies

    Yathartha Karunananda
    Superhero (Employee)
    Forum|alt.badge.img+12

    Hi ​@ekgaba,

    Yes it is limited to 100.

    ~If this response resolves your issue, mark it as the best answer~
      Michael Kaiser
      Hero (Customer)
      Forum|alt.badge.img+10

      Hi Yathartha,
      I did a field research: 
      The CUSTOMER_INFO_TAB.NAME field is 400 characters long.
      Hmmm, this is from Apps10. Do you think cloud made the field “smaller”?

      Ok, I did a test in Apps10: 100 char → ok. 
      More: The value “my 101 test char” has invalid format.

      So I’m happy to learned something new.
      What do you think: Why 400 varchar for 100 char in the mask?

      Questions over questions!  :-)

      BR
      Michael
       

      High transparency and better decision quality with IFS-based controlling (reports/BI).
        Yathartha Karunananda
        Superhero (Employee)
        Forum|alt.badge.img+12

        Hi ​@Michael Kaiser,

        Not really sure why it has been reduced. But there is an enhancement request which seems to be asking to increase it😉: Length of the "Customer/ Supplier" Name | IFS Community

        ~If this response resolves your issue, mark it as the best answer~
          Hero (Employee)
          Forum|alt.badge.img+10

          This 100 characters > VARCHAR2(400)  situation is likely because the Unicode character set used by App 10 and newer editions of IFS supported databases generally equates to 4 bytes per character.  With all the language sets needed globally and supported by Oracle databases (and therefore by the IFS editions as well) it’s necessary for the Unicode character set known as AL32UTF8 to be used to accommodate them all.

          When I worked with one of the IFS upgrade groups we typically found that VARCHAR2(nnnn) fields would actually hold characters which were equal ¼ of the count of bytes allocated to such fields.

          I hope this helps.

          Terms & ConditionsAccessibility statement