Supplier & Core Company Records

[JeyaNivas]

Anybody knows if you create a new supplier record in the Supplier table, will a new vendor record be automatically created in the core Company table. If yes, can someone share how it is getting created ?

[Ankur Bawiskar]

@JeyaNivas 

did you check business rule or flow which is doing this?

[JeyaNivas]

Have been trying to find out it it actually happens OOTB

[Ankur Bawiskar]

@JeyaNivas 

yes I also think it's Out of the box and part of source to pay architecture

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Vikram Reddy · Accepted solution]

Hey @JeyaNivas,

Company [core_company]
        \
         extended by
          \
           Supplier [sn_fin_supplier]

Yes, and it's not a business rule quietly inserting a second record, it's plain table inheritance, the same mechanism you see with cmdb_ci_computer extending cmdb_ci. sn_fin_supplier is a vertical extension of core_company, so the supplier record and its company record share the exact same sys_id and the same base row. Name, address, and phone live on core_company; supplier-specific fields like risk rating, category, and onboarding status live on sn_fin_supplier. So creating a supplier IS creating the core_company record, you're just looking at it through the extended table's form, not a separate object being synced.

References

• Supplier [sn_fin_supplier] table
• Companies table fields clarification
• core_company table - vendor vs non vendor best practices

Thank you,
Vikram Karety
Octigo Solutions INC