Add supplier inbound data in an Excel file

You can import supplier inbound table data in an Excel file.

Before you begin

Role required: admin

Procedure

1. Select All.
2. In the navigation filter, do one of the following:
   • To see the list of columns in the supplier location inbound table, enter sn_fcms_intg_supplier_location_inbound_list.do.
   • To see the list of columns in the supplier contact inbound table, enter sn_fcms_intg_supplier_contact_inbound_list.do.
   • To see the list of columns in the supplier payment inbound table, enter sn_fcms_intg_supplier_payment_inbound_stage_list.do.
   • To see the list of columns in the supplier payment inbound table, enter sn_fcms_intg_supplier_legal_entity_list.do.
3. Right-click any column heading and select Export > .xlsx.
4. Select Download to save the spreadsheet on your local system.

Result

Depending on the supplier inbound table you selected, an Excel template is created with the mandatory columns for supplier location, supplier contacts, or supplier payment information. Use this Excel spreadsheet to enter the supplier data that you want to import and store into the SLO inbound staging tables.

What to do next

Load the supplier data from the excel template into the supplier inbound​ staging tables. For more information, see Load supplier data.