1. To-Increase Dynamics 365 for Finance & Operations
  2. EDI studio
  3. Activities

Initialize document record fields - ODBC
Application task

For documents of type ODBC, you can initialize the fields for a record. To initialize record fields for an ODBC document, use a connector of type Database to connect to the applicable external database.

Make sure, the name in the Record table field is exactly the same name as the relevant table in the external database.
The fields are added to the record based on the fields of the external table.
When the initialization is finished, review and complete the properties of the initialized fields. Usually, during review, you do not add fields. However, you can remove the not needed fields.


Standard procedure

1. Click Connectivity studio Integration Design.
2. Click the Documents tab.
3. In the list, find and select the desired document of type ODBC.
4. Click Edit.
5. In the Records section, in the Record list, find and select the desired record.
6. On the Fields tab, click Initialize.
7. By default, the default Database connector that is defined for the project, is selected.
You can select another Database connector.
  In the Connector field, enter or select a value.
8. Click OK.
9. Close the page.

Provide feedback