X-ERP Help

Extra tables

Extra Tables adds customer-specific data structures for information not provided for in the standard model.

Extra tables

Extra Tables adds customer-specific data structures for information not provided for in the standard model.

This is what you learn

  • what purpose Extra tables fulfilled in the overall process
  • which requirements and master data are important for this
  • how to check the result technically and avoid typical subsequent errors

Recommended process

  1. Clarify the target, affected record and required permissions.
  2. Open the area Toolbox > Extra Tables on the desktop Administration.
  3. Check existing information and record the change completely and comprehensibly.
  4. Save and check the result in the associated follow-up process or in the appropriate list.

Fields

  • Table name/ID Create a manual ID. XX is automatically prefixed.
  • Display name: Name of the table
  • Module name: Assign a module name.
  • Index type: Set the index type. It can no longer be changed after the extra table has been created.
  • Character limit: Became the index type NVarchar is selected, an additional limit on the number of characters is specified.
  • Enable attachments: If the checkbox is set, the new table receives one Attachments tab.

Then check

  • Master data, status and responsibility are complete and plausible.
  • The change is saved and can be found again via search or list.
  • The adjacent process accepts the data as expected.

Avoid typical mistakes

Leave Extra tables not immediately after an entry. Save consciously and then check whether the expected result is visible.

Related topics

  1. For customizers – customize screens and forms
  2. For Customizer – Customize screens and forms › User interface
  3. For customizers – customize screens and forms › Expand the document chain
  4. For Customizer – Customize screens and forms › Output control

Frequently asked questions

What is Extra Tables used for in X-ERP?

Adds custom data structures for information not provided for in the standard model.

What should I check for extra tables before closing?

Master data, status and responsibility are complete and plausible. The change is saved and can be found again via search or list.