We realized our company table needs to be sanitized and I would like your help in doing so. We want to know how other customers handles companies and vendors.
Issue: We have instances where a company can be both a company and a vendor and where a company is not the vendor.
Example for us:
Carahsoft is the company and ServiceNow is the vendor however in our company table we have ServiceNow listed as the company and the vendor attribute checked which identifies ServiceNow as both a company and a vendor. Not Carahsoft. We are now finding this is incorrect.
For Applications Portfolio Manager we want to pull vendors however we have other forms which will need to pull companies.
On the core company table, we are thinking of the following:
In addition to the Vendor flag add a relationship field.
Add a new reference field:
- Field Name: u_provides_vendor
- Table: core_company
- Reference: core_company
Example:
Company | Vendor | Provides Vendor |
Carahsoft | ✔ | ServiceNow |
ServiceNow | ✔ | — |
CDW | ✔ | Microsoft |
This means both Carahsoft and ServiceNow will be listed in the core company table but flagged differently.
Any feedback or insight will be helpful
Thanks
Garfield
