Technical description
The Master Data tables have a single Primary Key of the Code length as 20. This code field is typically and automatically determined using the Number Series Pattern, although this is optional. To have a more humanly readable way to find records in the table, each Master Data has two text-fields of length 50, and a code-field of length 50.
Note
The Number Series Pattern will be discussed in Chapter 3, Design Patterns.
The following diagram explains how to implement the Master Data Pattern:
For the People Master Data, these text fields are called Name and Name 2. The code fields is named Search Name. The Product Master Data has text fields called Description and Description 2. Here, the code field is called Search Description.
The Search Description field is determined based on the first text field using the following algorithm:
IF ("Search Description" = UPPERCASE(xRec.Description)) OR
("Search Description" = '')
THEN
"...
