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
See also: DB 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
See also: DB type |
DI006106 PPMS Type
See also: PPMS type |
DI006107 DB length
Database length
See also: DB length |
DI006108 DF length
Data field length
See also: DF 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.