- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-17-2026 04:48 AM
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 ?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-17-2026 06:18 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago - last edited 3 weeks ago
This is incorrect. Supplier [sn_fin_supplier] extends Organization [sn_fin_organization]. There is a field Global Company on the Supplier table, that refences Company table [core_company]. Further on if you create a Supplier, if no match is found in the Company table by name, new company record is created and reference to it is saved to Related company field on the Supplier record.
