Skip to main content
Question

Increasing Company ID length

  • Nov 30, 2023 3:24 PM UTC
  • 2 replies
  • 104 views

Vernon Anderson
Sidekick (Employee)
Forum|alt.badge.img+8

We’ve had a customer asking whether or not the length of the company ID field can be increased so they can accommodate their legacy intelligent company number.  

Has anyone been asked this question and if so,what was your answer?

 

Thanks!

2 replies

Forum|alt.badge.img+16
  • Hero (Customer)
  • Dec 11, 2023 10:01 AM UTC

Hi, Vernon,

I could say that increasing company id field length is very complex exercise, as this field is present in multiple database tables and variables in the system code. Each one should be then changed and tested.


Marcel.Ausan
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • Dec 11, 2023 10:33 AM UTC

@Vernon Anderson 

As @Adam Bereda  mentioned, increasing the length of the company_id is not advisable since this column is present in almost 8000 tables in IFS:

 

Below you can see the only attributes for which the length can be changed as a simple setup, but company_id is not one of them.

 

I would recommend to create a Custom Attribute to store Old Company ID.