ERP Canvas ERP model table field descriptions

  • Release version: Washingtondc
  • Updated February 1, 2024
  • 1 minute to read

    • The Entity fields tab for an ERP (Enterprise Resource Planning) model in ERP Canvas displays the table fields that are included in the ERP model.

    ERP Canvas automatically scans the linked ERP system to retrieve the latest entity data. However, you can select the refresh icon to update the data on demand.

    Table 1. Entity fields tab details
    Column Description
    Field name Name of the field on the system of record.
    Name Name of the table on the system of record that contains the field.
    Mapped field name Name of the mapped field.

    The ServiceNow AI Platform automatically creates this mapped field name in the ERP model after scanning the linked tables on the system of record.
    Field label Natural language field name for the automatically mapped field on the ServiceNow AI Platform.
    Is custom Option to indicate whether the field on the system of record is standard or customized.
    ERP data type Type of data the field contains. The options are:
    • char (character)
    • date
    • decimal
    • numc (number)
    • time
    Is queryable Option to indicate whether you can retrieve data from the field 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.