DT439 Automatic number

Caution

• If system customizing changes are made to data tables or data items (e.g. new data items created, data item parameters changed), the menu item Tools → Restart PLANTA service must be executed to make the changes visible.
  • Note: If you click on the menu item, all open client connections (sessions) are closed. New client connections are not possible during restart. Changes to I-texts, e.g. changes to the DI designation or adjustments to value ranges (including the VR type), present an exception.
  • Before restarting the service, the target directory must be deleted so that it can be created again when the service is restarted to ensure that the POJO classes it contains, which are responsible for the metadata of the data dictionary, are generated anew.

DI000388 License

The license for which the automatic number takes effect

DI000361 DI

D%ata item the number of which is incrementing

DI000094 Data item

Name of the data itemName of the data item

DI008278 DB Schema

ID of the database schema

DI026846 DB schema name

Name of the database schema

DI001592 DT

Data table

DI008291 Data table

Name of the data table

DI000002 Number construction rule

The schema according to which the automatic number is formed is specified here.

Values

• Any required characters for the fixed portion, apart from:
  • $ = sign for counter 1
  • = last 2 digits of the current year
  • ; = character for logged-on license number (left-justified, padded with blanks if necessary up to the number of the specified ";").
  • Currently not available:
    • % = variable input by the user (remainder as per form)

Example

• X-$$$$$$-B always brings 10 digits, namely
  • in the first two places: "X-"
  • in the 2nd to 8th place counter 1
  • in places 9 and 10: "-B"

DI000006 Counter value 1

Here, the current counter value is displayed.

Note

• For all schemas except Q1B and Q2B, the counter value can be reset to the value of VR counter 1 from . This allows automatic numbers that have been generated but not saved and automatic numbers from deleted data records to be used for automatic reallocation.

DI000007 Counter from

Start value of counter 1. The value must only contain numbers, no characters.

DI000008 Counter to

End value of counter 1 The value must only contain numbers, no characters

DI000009 C1 incrementing numerically

Use for automatic numbers of the alpha type: It may only be incremented numerically.

DI000062 C1 leading zeros

Zeros can optionally be added to numerically incremented alpha numbers.

DI000116 Auto. numbers only

Determines whether a user-defined number can be entered instead of the automatic number.

Notes

• Possibly does not allow the user to make an own input in the respective DI. If the datafield is not visible, the automatic number is generally used in case no default value is specified in the data field.
• If the number has a variable part which can be entered by the user, he/she can only input the latter; on output, the entire number formed will be visible.

DI006105 DB type

Database type

DI006106 PPMS type

DI006107 DB length

Length of the database

DI006108 DF length

Length of the data field

DI001931 Changed by

When a record is modified, the ID (code) of the logged-on user is automatically entered in this field.

DI000402 Changed on

When a record is modified, the modification date is automatically entered here.