This is version 1 2 3 4 5 6 7 8 9 10 11 12 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

DEFINE CODE SEQUENCES#

The Define Code Sequences (IMCS) screen is used to setup code sequences that are used through out the system.

The definition data for the Define Code Sequences screen is stored in the P2K_AM_CODE_SEQUENCES and P2K_CM_ENTITIES tables.

Column Name

Which column (field) is to be "sequenced".

Table

This

Table Alias

This field provides an abbreviated form of the table name.

Length of Code

This field indicates the number of characters in the code sequence.

Zero Filled

Last # Assigned

This is the last number automatically assigned. The next sequence number will be one greater than the number shown here. This value must be between the lowest and the highest values above.

Lowest Range

This number specifies the starting point of the automatically sequenced range.

Highest Range

This number specifies the ending point of the automatically sequenced range. When you reach the end of this range, the system will not allow you to create the record being sequenced. At that point you must either enter a manual number, or modify the sequence range.

Manual Entry Option

A toggle to indicate if manual entry is permitted (instead of only allowing the system to generate the sequence value).

Manual Rule

This field identifies how the manual range is to function. Values that may be selected are as follows:

Manuals within the Range	This is required by entities that block off number ranges for sub-entities and need each sub-entity's manual range to be within their own allocated range.
Any Numeric Value Allowed	This is used by entities that set up sequencing to ensure that their codes are numeric, but the need to provide manual number is still present.
Any Value Allowed	This is used by entities that have a requirement to enter manual codes, but there is no requirement to ensure that they are numeric in nature.

Manual Lowest

This is the lowest value that may be manually entered.

Manual Highest

This is the highest value that may be manually entered.