Common

System Types Table Fields H

System Types Table Fields V

To access this page:

  1. Select Common > System Types in the Navigation pane.
  2. Click the Tables icon for a System Type.
  3. Click the Fields icon for a Table Name.

NOTE: Excel Integration has been enabled on this page. Refer to Use Excel Integration for more information.

Field

Description

FIELD ORDER

Displays order of field within the system table.

FIELD

Displays name of field within the system table.

NOTE: The validation will fail if the field name is not unique.

DESCRIPTION

Displays brief description of the field.

If a description exists, it is included with the field name in the SOURCE FIELD field (on the Field Mappings page) in Map in order to facilitate the mapping process.

If a description does not exist, the Source ID displays with the field name.

KEY FIELD

If enabled, the field is the key on the table.

DATA TYPE

Displays data type for the field, for example, int or nvarchar.

LENGTH

Displays number of characters permitted by the field.

LOOKUP TABLE

Click the link on the name of the lookup table to open the System Types Table Lookup page to view or edit the fields in the lookup table.

Static Value List

Click to open the System Types Table Statics page to add a static value for the field.

SYSTEM SUPPLIED

If enabled, this content is installed with the Stewardship Tier and cannot be edited.

If disabled, the content was added by a user or process.

NOTE: This is a display-only check box. It cannot be updated.

System Types Table Fields V

System Types Table Fields H

Use this page to Add Fields to Tables.

This page has the following tabs:

General tab

Field

Description

Field Data

Field Order

Displays order of field within system table.

Field

Displays name of field within system table.

Description

Displays brief description of field.

If a description exists, it is included with the field name in the SOURCE FIELD field (on the Field Mappings page) in Map in order to facilitate the mapping process.

If a description does not exist, the source ID displays with the field name.

Key Field

If enabled, field is the key on the table.

Field Details

Data Type

Displays data type for field, for example, int or nvarchar.

Length

Displays number of characters permitted by field.

Decimals

Displays the number of decimal places allowed in numeric fields that allow for decimals.

Field Format

Displays the format of the field used to validate the data in this field during Data Services AutoGen and Construct Data entry. Values are Date, Time, Decimal and Checkbox.

For example, the Date Format for a target is set at YYYYDDMM.

This value will be loaded into Target Design's Target Fields page.

Active For Mapping Default

If enabled, the table field is marked Active when the table is used in the mapping process by Map. If disabled, the table field is made inactive until manually activated. The default value for this check box is enabled for manually entered fields and disabled for system-imported fields.

Rule Field

If enabled, the field is marked as Rule Only. A Rule Only field is part of the table creation process, but is excluded from being moved between the Source Table to the Source Table in the Object database, or between the Source Table in the Object database to the Target Table in the Object database.

Original Field Details

NOTE: During the System Type Model Import process, the values in this section are stored so that a complete set of metadata for the original System Type can be transferred to the Syniti cloud. If these fields were populated as part of the System Type Model Import process, they must not be updated.
If the System Type was added another way, these fields can be edited.

Original Data Type

Displays the original data type for the field, for example, RAW or NUMC.

Original Length

Displays the original number of characters permitted by the field.

Original Decimals

Displays the original number of decimal places allowed in numeric fields that allow for decimals.

Documentation tab

Field

Description

Application Screen

Displays the name of the screen in the ERP system that contains the field.

Help Text

Displays helpful information about the field. For System Types delivered with the Stewardship Tier, this field is imported directly from the System Type help documentation.

Comment

Displays a user-entered comment about the target field.

This field is for documentation purposes only.

Instructions

Displays instructions about how to use the field in mapping or other functions.

This field is for documentation purposes only.