Question

Increasing Company ID length

  • 30 November 2023
  • 2 replies
  • 40 views

Userlevel 3
Badge +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

Userlevel 7
Badge +16

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.

Userlevel 6
Badge +15

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

Reply