2 Replies Latest reply: Jan 7, 2017 8:24 AM by PAUL YEO RSS

    How to handle COMPANY field name ?

    PAUL YEO

      Hi All

       

       

      My IT have generated many table , for example :-

      Sales order

      AR

      AP

      GL

       

       

      Each of the above table , it have company field name , some of the company field length 25 , some 40. Meaning some company name not full.

       

       

      My question is how should I handle this situation on diff length ?

       

       

      In the pass I try to create different field name :-

       

       

      COMPANY

      company

      Company_sales

       

       

      As I worry if I use same name , all table will join the company and it become very complicated.

       

       

      Now it is very messy.

       

       

      Hope some one advise me.

       

       

      Paul