Domains (ttadv4100s000)

Use this session to maintain domains. A domain specifies the data type, the value range, (default) display format, length and so on. Domains can be linked to table fields, form fields, and program variables.

You can copy the domain to your current package VRC. However you can only maintain domains of your current package VRC.

You can also change the current package VRC of the user in the VRC of the current component.

Package

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

Package

The description of the package.

VRC

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

VRC

The release of the package for which the domain is defined.

VRC

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

Note: It is only relevant for customized software.
Domain

Select the domain's identification code.

A domain is uniquely identified by the combination of package code and domain code.

Expired

If this check box is selected, the domain for this package VRC and the package VRCs derived from it have expired.

Description

The description of the domain.

Data Type

The internal representation of data.

Allowed values

Byte

Used for fields that contain whole numbers.

Size 1 byte
Value ranges 0 through 127
Integer

Used for fields that contain whole numbers.

Size 2 bytes
Value ranges -32768 through 32767
Long

Used for fields that contain whole numbers.

Size 4 bytes
Value ranges -2147483648 through 2147483647
Float

Used for fields that contain fractions. For fractions with more than five significant digits you can use the double data type.

Size 4 bytes
Value ranges Floating point with max. 6 significant digits
Double

Used for fields that contain fractions. For fractions with more than five significant digits you can use the double data type.

Size 8 bytes
Value ranges Floating point with max. 15 significant digits
String

Each byte in a string can contain an ASCII character.

Size <= 999
Value ranges Any possible string
Enumerated

Used where the field or variable can contain a number of values (up to 255) presented to the user as text. An example of this data type is a field which can contain the values yes or no, or color values such as red, white, blue, and so on. The enumerate values with code and language-dependent descriptions are defined in the Enum/Set Constants (ttadv4501m000) session.

Size 1 byte
Value ranges 255 possible values for multiple choice fields
Set

Used where the field or variable can contain a set of values (up to 32) presented to the user as text. An example is the display feature set, which can contain the values bold, blinking, reverse, but also combinations of these, such as bold and blinking. You can maintain the set code and its language-dependent descriptions by using the Enum/Set Constants (ttadv4501m000) session.

Size 4 bytes
Value ranges 32 bits for 2^32 different patterns
Date

The internal data type for date is Long. You can specify the display format of this data type in the Software Languages (ttaad1510m000) session.

Size 4 bytes
Value ranges Date stored as a number of days, starting from 01-01-0001
Text

Used for fields that refer to a text number in the text database. For example, to make it possible to link a text to an item in an item file, you must add a field with a domain of the text data type in the item table definition.

Size 4 bytes
Value ranges Unique key for an unlimited number of text lines
Multibyte String

Each character in a string can consist of one or more bytes.

UTC Date/Time

A Universal Time Coordinated time/date format. LN stores both date and ti

me in a single Long integer referred to as the UTC long format.

Size 4 bytes
Value ranges Integer representing the number of seconds since 0:00 hour, January 1, 1970 (in UTC).
Raw

Can hold a string of unsigned bytes. The value of an unsigned byte lies between 0 and 255.

The raw data type contains a sequence of bytes that does not have a meaning on its own yet. The meaning is assigned afterwards to the raw data, for example based on corresponding meta data. Examples include a small pictogram or broken-off text lines. The application that writes the data to the database, and reads data from the database, interprets the data in the correct way.

Size <= 999 bytes
Value ranges Raw bytes
Binary Large Object

The Binary Large Object (BLOB) type can store data with a size that is unknown beforehand. Otherwise the BLOB type is comparable to the raw type. A database column of the BLOB type is a reference, a so-called BLOB locator, to another part in the database where the BLOB's data is stored. So, the data is not physically stored in the record.

BLOBs are typically images, audio, or other multimedia objects, though sometimes binary executable code is stored as a BLOB. In LN, BLOBs are sometimes used to store XML and PDF documents, because the final size of these documents is unknown beforehand.

String Length

The declared string size if the data type of the domain is string or multi-byte string.

For details, see "Strings and arrays" and "Multi-byte strings" in the Infor ES Programmers Guide (Infor Support Portal KB 22924522).

Alignment

Select the alignment method for strings.

Conversion

Select the conversion method for strings.

Internal Format

This field indicates how a number, entered in a form input field with the string data type must be internally formatted.

For example, if a number like 37 must be stored as 00000037, use the format 99999999.

Display Length of Enum/Set

The default display or print length of a field or variable with enumerate or set data type in a form or report. You can overwrite this length on the data of a field in a form or report.

Digits before Decimal

The maximum number of digits for the long, integer and byte data types. For the float and double data types, this is the maximum number of digits before the decimal point.

Digits after Decimal

The maximum number of digits after the decimal sign.

Note: Only relevant for double and float data types.
Divide Factor

The factor by which the entry in a field is divided.

Example Divide factor = 100 The user enters 25009 in the field. Tools divides 25009 by 100 and displays 250.09.

It can be useful for fields containing amounts.

Note: This entry can only be filled in a domain of the double or float data type.
Rounding Method

Select the way in which a field with the float or double data type can be rounded.

Rounding takes place at the last digit as specified by the number of digits after the decimal point.

In the following examples, the number of digits after the decimal sign is one.

Entered by user Round off Round off upwards Round off downwards
1.51 1.5 1.6 1.5
2.78 2.8 2.8 2.7
1.55 1.6 1.6 1.5
Format

The display format which is used in forms and reports to display specific data.

Note: The display format can be used for the byte, integer, long, double, float, string (with only digits) and date data types.
Date/Time Format

The date.

Date/Time Format

The time.

Legal Characters

The legal characters that can be entered in a form input field.

Example If only numbers can be entered in a field with string, data type, the legal characters are specified as:

The characters ' " ^ \ must be preceded by a backslash [\]: \\ and \".

Note: If you do not explicitly specify any legal characters, all characters are legal. If you define some characters as legal, all other characters are illegal, and vice-versa.
Illegal Characters

The illegal characters that cannot be entered in a form input field.

The characters ' " ^ \ must be preceded by a backslash [\]: \\ and \".

Note: 

This field cannot be accessed for domains of enumerate and set types.

If you do not explicitly specify any illegal characters, all characters are legal.

If you define some characters as illegal, all other characters are legal, and vice-versa.

Range

The range which is used to check the validity of the input. If you enter a value in a form input field outside the specified range, Tools produces a range message, and Tools will ask for input again.

For simple validation checks, you can use the data type, legal and illegal characters, the length of the field and the number of digits before and after the decimal point.

For more complicated validation checks, you need this range attribute. The range can be an expression with evaluated value true (valid value) or false (invalid value) (true <> 0, false = 0). Other variables can also be used in the expression. The current value can be tested in the expression by using 2 dollar signs: $$

Examples:

A number between 30 and 40 and not equal to a specified field:

$$ in [30,40] and $$ <> ppmmm001.reserved

A string starting with a capital:

$$ in ^[A-Z].*$ (regular expression)

The following operators can be used (listed in order of decreasing precedence):

( ) expr in brackets e.g. 2*(3+5)
IN range test e.g. $$ in [10,20]
- Unary minus e.g. -10
^ Raise to power e.g. 2^3 = 8
* / \ Multiply/ Divide/Remainder
& String concat e.g. "A"&"B"
+ - Addition / Subtracting
= <> <= >= < > Relational operators
not Logical negation
and Logical and
or Logical or
Range Message

Select the code of the messages (including package code) which is given if you enter a value outside the specified range.

Range Message

The message as shown when activated.

Tech.Documentation

If this check box is selected, technical documentation is present for this label.

Release Notes

If this check box is selected, release notes are present for this label.