> > > >

Use this form to create definition groups. Definition groups define the tables and formats that are used for export and import data. Definition groups are required when you export data, but not when you import data.

The follow rules apply to importing data:

  • If you select a definition file, only the defined table is imported.

  • If you do not select a definition file, everything from a given file is imported.

  • If you create a definition group for import some of the dependant tables may not be imported.

If you do not want to use a definition group, use the dialog from the menu.

If you have used the Microsoft Excel Template Wizard, the definition group was created by the wizard. For information about how to use the Microsoft Excel Template Wizard, see Microsoft Office Excel Template Wizard (form).

Tasks that use this form

Navigating the form

The following tables provide descriptions for the controls in this form.




Identify and select a type for the definition group.

Select additional attributes to the definition groups.

Select table groups.




Resets values on the and the tabs to original settings.

Clears all values on the and the tabs.




Identify the definition group using letters or numbers up to 10 characters.

Identify the definition group using letters or numbers up to 30 characters.

Select the type of definition group:

– Export or import Microsoft Dynamics AX tables as binary or comma delimited files. Select binary if the files will be re-imported into Microsoft Dynamics AX. Select comma delimited if the information is viewed in a spreadsheet or similar file.

– Import a file from an excel spreadsheet. We recommend that you use the Excel template wizard to create the definition group.

– Import a custom defined table group.

Select to include notes that were added in the Application Object Tree (AOT) using the Add notescommand. Information is saved in DocuRef table.

Select to include system tables such as Users, User groups, and Document parameters. If selected, carefully review the list of tables to be exported by clicking the button after the definition group is created. Clear tables with a Utilprefix.

Select to include tables with a prefix of XRef. Cross reference tables are generated by the system and can be regenerated at any time.

Select to include tables that track updates, insertions, and deletions made by users.

Select to include generic tables that are shared by all companies. Setup in the Administration module is used by all companies.

Select to include tables such as methods of payment, Web portal tables, asset setup, states, and transactions.

Select to include all the module parameters and batch, document, and other miscellaneous parameters.

Select to include tables such as bank groups, pricing groups, commission groups, item groups, and address tables.

Select to include master tables such as customers, vendors, items, work centers, ledger accounts, employees, bank accounts, tax tables, item dimensions, and routes.

Select to include transaction tables for all modules.

Select to include tables related to journal headers and lines.

Select to include tables related to journal headers and lines.

See Also