Add supplier inbound data in an Excel file

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

始める前に

Role required: admin

手順

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.

タスクの結果

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.

次のタスク

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

関連タスク

• Load supplier data