Supplier Excel files in detail

File Format

The Excel file (supplier import (total)) is divided into five different spreadsheets, which can also be used as independent files and imports:

• Supplier (supplier master record (central))

• Address (optional addresses, which are assigned to the suppliers via the unique, central supplier number)

• Bank (optional bank details, which are assigned to the suppliers via the unique, central supplier number)

• Contact (optional contacts, which are assigned to the suppliers via the unique, central supplier number)

• OrgUnitSpecific (vendor master record (organizational unit); organizational unit-specific specifications of master data and configurations)

The individual spreadsheets (or single imports) and the columns/attributes they contain are described below.