Table Fields (ttadv4122s000)

Field Information

Table

The code of the package for which the table is defined.

Table

The code of the module for which the table is defined.

Table

The table's identification code.

A table is uniquely identified by the combination of package code, module code, and table identification code.

VRC

The version code of the package for which the table is defined.

VRC

The release code of the package for which the table is defined.

VRC

The customer extension of the package for which the table is defined.

Note: The customer extension is only relevant in case of customized software.

Field Name

The name of the field that can be used in forms, reports, and in scripts in the following way: <table name>.<field name>

The field name must be unique in the table.

Example table : pksls040 (package - module - table number) field name: orno

Sequence Number

The field number that determines the sequence of the fields in the table definition.

Note: An index can be optimized by some database drivers (ISAM) if the parts of the index are adjacent (as index parts and table fields) and have the string, byte, or enumerate data type. An optimized index speeds up searching.

Combined Field

If this check box is selected, the field is combined. A combined field consists of two or more normal (not combined) fields.

• A combined field can be used for references and indices.
• The child fields of a combined field can be maintained by the Child Fields by Combined Field (ttadv4523m000) session.

Mandatory Input

If this check box is selected, input in this field by the user is mandatory.

If the field has the byte, integer, long, float or double data type, mandatory input means that the value of the field must be unequal to 0. In fact, mandatory input is an addition to the domain definition of the field and has precedence over what is defined as the range of the domain. If the user tries to make a field empty while input is mandatory Tools gives range message of the domain.

Example
Field:	Employee number	(datatype long)
Range	Mandatory input	Allowed range on the field
$$ IN [0, 999999]	no	0 - 999999
$$ IN [0, 999999]	yes	1 - 999999
$$ IN [1, 999999]	no	0 - 999999 (0=empty)
$$ IN [1, 999999]	yes	1 - 999999

Repeating Field

If this check box is selected, the table field is repeating.

Note: A repeating field appears a number of times in the table with the same name and characteristics.

No. of elements

The depth of the field that is indicated as a repeating field.

Example

A table contains these fields:

• Help Topic Code (1)
• Topic Title (1)
• Topic Keywords (4)

The numbers indicate the number of elements for these fields.

Note:  Topic Keywords is a repeating field of 4 levels. You can define no more than four key words for each topic.

Domain

The domain of the table field's package code.

Domain

The domain of the table field that defines the data type and several characteristics of the field.

Note: If the table field is a combined field, no domain can be given.

Data Type/Length

The internal representation of data.

Data Type/Length

If the data type of the domain is string this is the length in characters. If the data type is multibyte string, it specifies the number of positions on which the characters can be placed.

Generate Unique Initial Value

This check box indicates whether a unique value must be generated for the selected table field during reconfiguration of the table.

If you select this check box:

• The Initial Value field becomes disabled, showing no content.
• In the database, the value "$__unique" is stored as the "Initial Value".
• The value "$__unique" is used to start a bdbreconfig. It generates a unique ID for the selected field.

If this check box is cleared (default value):

• The Initial Value field becomes enabled.
• The default value for Initial Value is empty. You can manually specify a default value.
• The value of Initial Value is stored in the database.

Initial Value

If a user adds a record to the table, this is the initial value for the field.

If the Generate Unique Initial Value check box is cleared, you must specify a default value.

If the Generate Unique Initial Value check box is selected, this field is read-only. The default value is determined by the specified domain.

Label Description

The description of the table field which is used for a label with the same name as the table field. If a label in a form, report or menu has the same name as the table field, this description will replace the label.

Note: A percentage symbol % in the label description forces a line break in the label in the form, report, or menu.

Label Length

The length of the label that is used in forms, reports and menus.

Related Label

The code of the label that is used as a description of the table field.

Note: This field can only be accessed if the field Label Description is empty.

Reference Table

The package of the reference table to which this field refers.

Reference Table

The module of the reference table to which this field refers.

Reference Table

The table number of the reference table to which this field refers.

Reference Table

This field displays a period.

Reference Table

The field name of the reference table to which is referred.

Reference Mode

You can choose the following options:

• Mandatory

  The foreign key value (the reference record) must exist in the reference table.

• Mandatory unless empty

  Same as Mandatory, but it allowed that the foreign key value is empty.

• Not mandatory

  The foreign key value will not be checked against the reference table.

Reference Message

The package code of the message which is given when a given value does not correspond to a record in the reference table.

Reference Message

The message code which Tools gives, if you enter a value in an input field in the form, where no related record in the reference table is present.

Note: The reference message is only relevant if the reference mode is mandatory, or mandatory unless empty.

Check by DBMS

If this check box is selected, the referential integrity of the reference field must be checked by the database server.

Delete Mode

Select the action to be taken by Tools , if an occurrence in the table referred to (= parent or reference table), is deleted.

Allowed values

Child will be deleted

All children that refer to the parent will be deleted.

Note: If the reference does not identify the relation this can result in the automatic deletion of many records. For example if the relation between the parent and child is not one-to-one but one-to-many.

Restricted (with counter)

Deletion of the parent is restricted if any child refers to the parent. A reference counter is checked, which indicates how many children refer to the parent. With each database action this counter is checked and updated, if necessary.

Nullifies

The field(s) of the child, which refer(s) to the parent that has been deleted, will be made empty (spaces or zero value).

No check

If the parent has been deleted, no check or action will be done on the child occurrences which refer to the parent. In that case the referential integrity of the database cannot be guaranteed.

Lookup (Restricted)

Deletion of the parent is restricted if any child refers to the parent.

Update Mode

Select the action to be taken by Tools , if the primary key of a record in the table to which is referred (= parent), is changed.

Allowed values

Child will be updated

All children that refer to the parent will be updated.

Note: If the reference does not identify the relation this may result in the automatic update of many records. For example if the relation between the parent and the child is not one-to-one but one-to-many.

Restricted (with counter)

Any change of the primary key fields of the parent is not allowed if any child refers to this record. A reference counter is checked, which indicates how many children refer to the parent. With each database action this counter will be checked and updated, if necessary.

Nullifies

The field(s) of the child, which refer(s) to the updated parent record, will be made empty (spaces or zero values).

No check

If the parent is changed, no check or action will be done on the child records which refer to the parent. In that case the referential integrity of the database cannot be guaranteed.

Lookup (Restricted)

Any change of the primary key fields of the parent is not allowed if any child refers to this record.

Is Inter-Company

Clear this check box if the reference table is located in the same company as the current table.

Select this check box if the reference table is located in a different company.

Reference Company Field

If the reference table is located in a different company, specify the table field that contains the company number where the reference table is located. You can only specify a table field if the Is Inter-Company check box is selected.

Example

The Shipping Warehouse (whinh220.cwar) field in the Outbound Order Lines (whinh220) table refers to the Warehouses (whwmd200) table.

The Warehouses (whwmd200) table is located in a different company.

The Ship-from Company (comp) field in the Outbound Order Lines (whinh220) table contains the company number where the Warehouses (whwmd200) table is located.

This reference information is specified for the Shipping Warehouse (whinh220.cwar) field in the Outbound Order Lines (whinh220) table:

• Reference table: whwmd200
• Is Inter-Company: Yes
• Reference Company Field: comp

Tech.Documentation

If this check box is selected, documentation for the table field is present.

Release Notes

If this check box is selected, release notes for the table field are available.