Site Extract File Contents

The same extract file is used for both supplier and site data extracts (see Extracting Suppliers). The CSV file name is SiteExtract, with the batch job number appended.

The file contains a row for each site, with the parent supplier name (both local and business languages) and supplier code on the first site row.

All fields on the Site 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 Growers List table is excluded.

Note:

If a full combination of supplier and site data is required, two separate Supplier and Site extract files must be created and manually merged using the common Supplier Code as the key.