ERP Data Hub remote table form field descriptions

  • Release version: Xanadu
  • Updated August 1, 2024
  • 2 minutes to read

    • The Remote table form in ERP Data Hub enables you to create and edit remote tables in the ERP (Enterprise Resource Planning) model.

    Table 1. Remote table details
    Field Description
    Name Name of the remote table on the ServiceNow AI Platform.
    ERP model ERP model connected to the remote table. The ERP model controls the available fields on the remote table.
    Note:
    Changing the ERP model removes any previously configured table fields that aren't available on the new model.

    To change the model for an ERP remote table, you must select the Unlock ERP model field button and then select the Unlock model change button on the confirmation dialog.
    ERP module Functional area or component within an ERP system. The module represents a distinct set of features and functionalities tailored to address a set of business processes or activities.
    ERP system ERP system that the remote table is linked to.

    The connected system represents the ERP instance that is linked to the model, enabling data flow and interaction between the model and the connected ERP system. For more information, see Create an ERP system in ERP Data Hub.
    Remote table link Name of and link to the remote table on the ServiceNow AI Platform.

    Selecting the remote table link opens a new browser tab, where you can explore, query, and manage the remote table.
    Attachment setting How the remote table uses attachments, which contain the remote data from the ERP system.
    The options are:
    • None: No attachment is used for the remote table.
    • Save attachment: Generate a new attachment when specified in the scheduled query or by selecting the Refresh attachment data button.
    • Use attachment: The current attachment, if available, is used locally.
    Short description Brief description of the ERP remote table.
    Long text Additional details on the contents of the remote table.
    Requires queryable field Indicates whether you can retrieve data from the remote table without querying the source table.

    Smaller tables, such as a currency table, can have data stored locally and thus don't require a query to retrieve fields.
    Enable schedule Option to create a scheduled query (ETL extraction) to fetch a new version of the attachment data.
    Note:
    The Attachment setting field must be set to Save attachment or Use attachment for this option to be available.
    Daily schedule time Time, in 24-hour format, for when the schedule runs every day.
    Scheduled encoded query Details on any scheduled extraction queries for the remote table.

    Create an encoded query string using a filter on the remote table list and paste the string into the Encoded query field. For more information on creating encoded queries, see Encoded query strings.