Storing French SIREN (Taxpayer ID) for Suppliers and Customers in Oracle Fusion

Summary:

We are looking for a suitable field to store the SIREN number for French companies. Our understanding is that SIREN serves as a Taxpayer ID equivalent for France. In the supplier setup, there is a Taxpayer ID field stored in the column INCOME_TAX_ID of the table POZ_SUPPLIERS_PII. This field enforces uniqueness checks per country across all suppliers. However, customers also have a SIREN or Taxpayer ID.

Our questions are:

1. Why is the supplier Taxpayer ID not stored in the ZX_REGISTRATIONS table? Storing it only in the supplier table (POZ_SUPPLIERS_PII) prevents enforcing the uniqueness of this value across both suppliers and customers.