Suppliers Extract File Contents

The same extract file is used for both supplier and site data extracts. The CSV file name is SupplierExtract, with the batch job number appended.

The file contains a row for each of the supplier's sites, but for the supplier extract, the only site data included is the site name (both local and business languages), site code, and site status.

The first row will contain the unique system text for the field; the second row will contain the system text specifically for reporting (both shown in the selected language). The first column will contain an incrementing sequence number, starting from 1 (this is of use to reset the file to the original sequence after making changes in Excel). The second column will contain an automatically assigned unique compound key based on the record type and field.

All fields on the Supplier record will be output, including any custom fields, but excluding change history data. The contents of any embedded list views (such as the list of Contacts) are not output.

The individual rows of tables are output as separate rows (the parent data is not repeated). For example, a supplier with two sites, each with two entries in their References table would output as:

1	Supplier A details	Supplier A, Site 1 details	Site A-1	Reference 1
2				Reference 2
3		Supplier A, Site 2 details	Site A-2	Reference 1
4			Site A-2	Reference 2
5	Supplier B details	Supplier B, Site 1 details	Site B-1	Reference 1
6				Reference 2
7		Supplier B, Site 2 details	Site B-2	Reference 1
8			Site B-2	Reference 2

Columns that relate to a glossary (such as Business Category) contain the Description (not the Code) of the glossary record. Contact information is included, but not contact roles.