Company Table

[snow_hard252]

Hi All

Can core_company table be extended? Its doesn't show up in the list.

I don't want to touch base table, and I need to add some new fields, so would want to create new company table and extend core_company.

Is this possible?

Thanks

Hardy

[Community Alums · Accepted solution]

By default, the Company table is marked as non-Extensible. You would need to update that field to true on the table record to extend it.

[snow_hard252]

HI Ben

I could get it , only just before I saw your reply, thanks very much anyway.

I have requirement, wherein I have excel dump of Location data of Company in a hierarchy of 4 levels.

COMPANY-> REGION->COUNTRY->STATE

I have to bring in this data in ServiceNow keeping intact this hierarchy.

I understand ServiceNow has Parent Reference in Location table, but I need some inputs as to how I can map the hierarchy as existing in Excel sheet.

Please give in your thoughts.

Thanks

Hardy

[Community Alums]

Without seeing the Excel spreadsheet, it is difficult to say for certain exactly the best way to handle this, but a couple thoughts come to mind here that could help you:

• Companies have a one to many relationship with Locations, meaning a single Company can have many locations.
• The Company field is not exposed by default on the Location form, but you can easily add it.
• I would also add the Locations related list to your Company form so you can see all the locations associated with a company.
• The Location table allows you to set a parent for each location, which is what provides the hierarchical structure. So you can import United States of America as a Location, then California with United States of America as its Parent, and then import San Francisco with California as its Parent. When you get down to the address level, you can have it identify the Company.

I hope this helps.

Ben

[snow_hard252]

HI Ben

Thanks, that was useful info.

May be I need to clarify more on this, say we are excluding COMPANY temporarily.

On Location Form the hierarchy needs to be defined as below:

1) REGION Field: Look up List Needs to populate( example set : America,Asia etc)

        Say America is chosen

2) COUNTRY: Field Look up List( example set: North America,South America, China, Phillippines etc)

          Since America is chosen, only North America and South America needs to be shown up the look up list.

                Say North America is chosen

3) STATE: Field Look up List(example set: Alabama, Texas, Michigan, Beijing , Buenos Aires etc)

        Since North America is chosen above, only Alabama, Texas needs to be shown up look up list.

                  Say Alabama is chosen

Then we have the Smaller Details of Street etc.

Given the cmn_location table the hierarchy defined and hierarachy expected are different, that's what I realized.

Please give your comments.

Regards

Hardy