Integrate Table Record For Free

Create or edit field mapping In the main pane, in the Type list, select Mappable. Select a mappable relationship. Then, on the Actions toolbar, select Actions, and then select Edit. Under Related, select Mappings.

Take action: Create a linked record Add a new field to one table, and choose ?linked record? as the field type. Then link to the second table, and you can easily look up a record in one and associate it with the other.

Assembly orders can be automatically created and linked when you create a sales order line. The link between the sales demand and assembly supply opens up for several opportunities when you process sales orders: Customize assembly items on the fly.

A record: Contains specific data, like information about a particular employee or a product. A field: Contains data about one aspect of the table subject, such as first name or e-mail address. A field value: Each record has a field value.

A field mapping describes how a persistent field maps to the database. If necessary, it also contains data on how to link the field to the data of its owning object, and how to link the field to the data of any related objects (if the field represents a relation to one or more other persistent objects).

Enable access to the APIs Open the Business Central Administration tool. Expand the OData Services tab, and select the Enable OData Services checkbox first, then select the Enable API Services checkbox. Check that the values for the OData Base URL and Port are entered correctly.

You set up filters on the Integration Table Mappings page. Choose the. icon, enter Integration Table Mappings, and then choose the related link. To filter the Business Central records, set the Table Filter field. To filter the Dataverse rows, set the Integration Table Filter field.