<<

Contents

Search

>>

 

Create Master Data Management

 

A Master Data Management is established for an Index File. For this, the mask must be empty.

 

With the Master Data Management the programmer can implement the basic functions of a database management without having to do any coding work him/herself.

 

 

Master Data Management for file: Specifies the name of the Index File for which the Master Data Management shall be established. An Index File can be selected with F2 or F7.

 

Create Index File Fields from field number: If you enter 0 or 1, all fields of the Index File will be entered on the mask (provided that there is enough space available). If you enter a number > 1, only the fields from the specified number on and the fields of the primary key of the Index File will be considered. The created mask field is labelled with the field name of the Index File field. You can move, delete or change the mask fields and labels as you like.

 

Two Stage File Management: Often a two stage Master Data Management is established (e.g. invoice head + invoice positions).

 

Create select button: In addition to the buttons ’save’ and ’delete’ another button for selecting data records is created. On a further mask it can be specified which fields shall be shown in the selection.

 

Select starts at beginning of Index File: With pushing the Select button the function SELECT for displaying the data records is executed. If this checkbox is set, the instruction INITIALIZE <INDEX FILE> will be executed before SELECT is called. In this way the display always begins with the first data record of the Index File. If this checkbox is not set, the first displayed data record will be the current data record of the Index File.

 

Clear fields when a new data record is created: When a data record is newly recorded, all mask fields are deleted automatically.

 

Clear fields when a data record has been deleted: After a data record has been deleted successfully all mask fields are deleted.

 

Confirmation before data record is deleted: The data record will only be deleted after the user has confirmed that he/she really wants to delete the record.

 

Message when data record has been deleted: After the data record has been deleted a message will confirm that the record has been deleted.

 

If the checkbox Two Stage File Management is set, a new mask will appear, on which the subordinate file must be specified.

 

 

Secondary Index File: Here the name of the subordinate Index File must be specified. With F2 or F7 an Index File can be selected. The condition for a two-stage data management is that the primary key of the subordinate Index File has the same structure as the primary key of the master data file. In addition to that, the primary key of the subordinate file must have an serial number (=numeric field without post decimal positions) as last field.

Example: Invoice head and invoice positions: The primary key of the Index File invoice head is the invoice number. The primary key of the subordinate Index File invoice position consists of invoice head + serial number. Every position of the invoice is saved as data record in the Index File invoice positions.

 

Show items permanently: If this checkbox  is set, the fields for displaying the data records from the subordinate file will permanently be displayed on the mask, otherwise a window for editing the data records of the subordinate file will appear after the last field of the master data file.

 

Window with Title Bar: The subordinate file can be edited over the function SELECTA. A window is opened, in which the data record of the subordinate file can be edited. If the checkbox Window with Title Bar  is set, a window with title bar will be created; in the opposite case a window without title bar will appear.

 

Window Title: Specifies the heading displayed in the Window with Title Bar.

 

Alignment: Specifies whether the fields of the subordinate file are displayed in the center of the mask or left-justified.

 

Number of Items: Specifies the maximum of data records of the subordinate file that shall be edited.

 

On another mask you can select the fields of the subordinate file that shall be displayed or edited. All fields except of the fields of the primary key can be selected, even the serial number of the subordinate file. The serial number is displayed in the program, but it cannot be changed.

 

 

 

In the column Show and Change  the fields to be edited are displayed. By double-clicking, the RETURN key or the right mouse button a field from the column Fields of secondary Index File can be moved into the column Show and Change. Analogously a field from the column Show and Change can be removed again. A field heading can be changed by double-clicking on it or pushing the RETURN key.

 

Button 'All Fields': All fields from Fields of secondary Index File are entered in Show and Change.

 

Button 'OK': The settings are adopted and the mask is closed.

 

Button 'Cancel': The mask is closed and program execution continues at the mask Create Master Data Management

 

If the checkbox Create Select Button is set, another mask will appear, where you can specify which fields shall be displayed in the selection.

 

 

In the column Show in Selection the fields displayed in the selection are shown. By double clicking, the RETURN key or the right mouse button a field from the column Fields of Index File can be moved into the column Show in Selection. Analogously a field from the column Show in Selection can be removed again. A field heading can be changed by double-clicking on it or pushing the RETURN key.

 

Button 'All Fields': All fields from Fields of Index File are entered in Show in Selection.

 

Button 'OK': The settings are adopted and the mask is closed.

 

Button 'Cancel': The mask is closed and program execution continues at the mask Create Master Data Management.