Release 10.1A: OpenEdge Development:
Progress Dynamics Administration

> ## Sequence Maintenance window

> The Sequence Maintenance folder window, shown in Figure 4–2, allows for editing of all the fields for a sequence.

> Figure 4–2: Sequence Maintenance window

> The Sequence TLA field refers to a unique three-letter-acronym which, in conjunction with the Entity Mnemonic field, forms the composite key. Thus, each mnemonic can have multiple sequences.

> The Sequence format field contains a user-defined format mask for the sequence. The format mask must include a numeric format that allows for the maximum value and that conforms to the database format rules (for example: `99999999` = eight-digit number with 0 prefix).

> The format can include hard-coded characters (for example PO for purchase order). The format can also include insertion codes to dynamically insert data at run time, as follows:

> - `%Y` = Insert the last digit of the current year.

> - `%YY` = Insert the current two-digit year.

> - `%YYYY` = Insert the current four-digit year.

> - `%MM` = Insert the current two-digit month.

> - `%MMM` = Insert the current three-character month.

> - `%DD` = Insert the current day of the month.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095