Add or remove fields in for an extraction table in ERP Canvas to define how your ERP (Enterprise Resource Planning) model. For example, you may want to remove fields with sensitive information, such as birthdays.

Before you begin

If you don't see the fields that you want to add to the extraction table, you must first add them to the model. For more information, see Choose output parameters for an ERP model.

Role required:
  • To modify extraction tables: sn_erp_integration.erp_admin
  • To read extraction tables: sn_erp_integration.erp_user

Procedure

  1. Navigate to All > ERP Canvas > ERP Canvas Home.
  2. Open the ERP extraction tables page by selecting the ERP extraction tables icon (ERP extraction tables navigation icon) in the side panel.
  3. Select an extraction table to work with by selecting the Name.
  4. Manage the columns to build the extraction table by selecting the Select fields button.
    1. On the modal, find and select the field that you want to add to the extraction table using the search box.
    2. Select the button to move the field from the Available columns list to the Selected columns list.
    3. Drag to rearrange how fields appear in the table.
    4. After you finish adding all the fields, select OK to save your changes.
      The ServiceNow AI Platform updates the fields on the extraction table with your changes.
  5. Confirm that the fields appear correctly as columns on the extraction table by selecting the Extraction table fields tab.