DT439 Automatic number

Caution

• If system customizing changes are made to data tables or data items (e.g. new data items are created, data item parameters are changed), the Tools → Restart PLANTA service menu item must be executed in order to make the changes visible.
  • Note: If you click on the menu item, all open client connections (sessions) are closed. During restart, new client connections are not possible. This does not apply to changes made to I-texts, e.g. changes to the DI name or adjustment of value ranges (also of the VR type).
  • Before restarting the service, the target directory must be deleted so it can be created anew upon server restart in order to make sure that the POJO classes contained in it, which are responsible for the meta data of the data dictionary, are generated anew.

DI000388 License

License for which the automatic number takes effect

DI000361 DI

DI the number of which is incrementing

DI000094 Data item

Name 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 used to form the automatic number 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 digit counter 1
  • in places 9 and 10: "-B"

DI000006 Counter value 1

This shows the current counter value.

Note

• For all schemas except Q1B and Q2B, the counter value can be reset to the value of VR counter 1 from . You can then use automatic numbers which were generated but not saved and automatically created numbers of deleted records for automatic reallocation.

DI000007 Counter from

Start value for counter 1. The value may only contain numbers, no letters.

DI000008 Counter to

Final value for counter 1. The value may only contain numbers, no letters.

DI000009 C1 incrementing numerically

Used for automatic numbers of the alpha type: If appropriate, incremental counting will be strictly numeric.

DI000062 C1 leading zeros

For alpha numbers which are incremented purely numerically, there is an option to insert leading zeros.

DI000116 Auto. numbers only

Determines whether a number chosen by the user may be input instead of the automatically determined number.

Note

• Possibly does not allow the user to make an own input in the respective DI. If a data field is hidden, an automatic number will always be used, unless a default value is specified for 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

Database length

DI006108 DF length

Data field length

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.