Merge User Defined Objects into Data Dictionary

This program is accessed from the Program List of the SYSPRO menu:

• Program List > Utilities > Merge User Objects into Data Dictionary

• User-defined columns in a standard SYSPRO table can be imported into the Data Dictionary if you want to add or remove columns or indexes against user-defined tables that have been changed in SSMS.

• The above method can also be used to add indexes to custom form tables. However, columns must be added, updated or deleted through the Custom Forms Entry program once they exist in the Data Dictionary.

• The limitations as to what can be imported into the Data Dictionary are as follows:

  • Table and column names cannot be longer than 30 characters.

  • Each table cannot have more than 300 columns.

  • Columns must contain SYSPRO-supported data types.

  • Character-based columns are limited to 3 000 characters and decimal or number-based columns are limited to 6 decimals or 20 integers.

  • Objects must exist in all company databases and have matching names, types and sizes.

• The Data Dictionary limitations are as follows:

  • Name size limitations

    Object	Maximum size
    Table name	18 characters
    Column name	18 characters
    Index name	30 characters
    Foreign key name	128 characters

  • Column size limitations

    Data type	Maximum size
    Decimal/Numeric	20 integers, 6 decimals
    Char/Varchar	3 000 bytes
    Binary	3 000 bytes

  • Unsupported SQL data types:

    Type	Data type number returned
    Date	386
    DateTimeOffset	398
    Geography	0
    Geometry	0
    HierarchyId	0
    Image	405
    Text and nTex	1100
    Sql_variant	0
    Time	390
    XML	1100