Create a New Data Mapping Item

To create a new Data Mapping item:

1. Click New, in the left-hand frame of the browser window.

The browser displays the Edit Mapping form on the right-hand side of the Integration Administration application page.

This form includes, for the selected item, a list of configuration information prompts followed by text boxes with the current value displayed.

2. To add a Name value, click in the text box, and type text or numbers to create a unique name for the Data Mapping item.
3. To add a Select EBD Table value, click in the drop-down menu, and select a table name from the Procurement application, to be mapped to the ERP system.
4. Click [Get Fields] to populate the Select Key Field and Select the description field drop-down menus from your selected EBD Table.
5. To add a Select Key Field value, click in the drop-down menu, and select a field name that needs to be mapped to the ERP system.

This should generally be the Primary Key of the table. For example, you would select UOMID for UOM, or SupplierID if the Procurement application table is Supplier.

6. To add a Select the description field value, click to the right of the drop-down menu, and select a field name description.

This helps in setting up the mappings because many values in the Key Field are numeric (being primary key) and do not give much information about the contained data. For example, for UOM you may select BuyerDesc, or for Supplier you may select Name.

7. To add an optional Alias for the key field value, click in the text box, and type an alias for the value in the Select Key Field.
8. To add a Mapped Field Name value, click in the text box, and type the name of the ERP Field to be mapped to the Procurement application.
9. The Associate ERP with this item field is required.

To add this value, click in the drop-down menu, and select from a list of available ERP systems to be associated with this Data Mapping item.

10. Click [Save] to apply the configuration parameters to the new Data Mapping item.
11. When you have completed creating new Data Mapping Items:
• Click Search or New, in the left-hand frame of the browser window, to take other actions using the Data Mapping Configuration Form.
• Click the name of a parameter in the left-hand side menu, to take other Integration Administration actions.
• Click Home, in the left-hand frame of the browser window, to return to the Procurement Home Page.