Most data in a supplier record only exists once per record, e.g. Company Name, Country of Registration.
However, there are some fields that will exist multiple times. For example, a single supplier record may have multiple bank accounts, contracts, insurance documents, etc.
Where the report is displaying fields that exist multiple times on a supplier record, these fields will be presented in a secondary sheet.
- If the report is an Excel file, the secondary sheets will exist as separate tabs in the file
- If the report is a CSV file, the secondary sheets will be downloaded as separate CSV files
Each secondary sheet is grouped by the field domain it is reporting on. For example, Bank Details will exist in one sheet, Contracts will exist in a separate sheet, etc.
On each sheet - both the main one and each secondary sheet - the Company Name and UID of the supplier record will be included by default. This will enable you to map supplier data across the various sheets.