This page (revision-12) was last changed on 26-Nov-2021 10:22 by JEscott

This page was created on 26-Nov-2021 10:22 by KateN

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
12 26-Nov-2021 10:22 2 KB JEscott to previous
11 26-Nov-2021 10:22 1 KB JEscott to previous | to last
10 26-Nov-2021 10:22 1 KB JMyers to previous | to last
9 26-Nov-2021 10:22 1 KB JMyers to previous | to last
8 26-Nov-2021 10:22 1 KB JMyers to previous | to last
7 26-Nov-2021 10:22 2 KB JMyers to previous | to last
6 26-Nov-2021 10:22 2 KB JMyers to previous | to last
5 26-Nov-2021 10:22 2 KB JMyers to previous | to last
4 26-Nov-2021 10:22 1 KB JMyers to previous | to last
3 26-Nov-2021 10:22 1 KB JMyers to previous | to last
2 26-Nov-2021 10:22 1 KB JMyers to previous | to last
1 26-Nov-2021 10:22 280 bytes KateN to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 1 changed 34 lines
[{TableOfContents }]
!!!DEFINE CODE SEQUENCES
The Define Code Sequences (IMCS) screen is used to setup code sequences that are used through out the system.
Code Sequencing is a method of having the application automatically assign a numerical code (in sequential order) for a specific column/field in the application. Code Sequencing is often used for fields like [person code|PERSON_CODE], [batch number|BATCH_NUMBER] and [pay run number|PAY_RUN_NUMBER].
Only certain columns (fields) are allowed to have code sequencing defined. The [Code Sequence Allowed|CODE_SEQUENCE_ALLOWED] toggle in [IMCD] identifies which columns(fields) may have code sequencing.
The definition data for the Define Code Sequences screen is stored in the [P2K_AM_CODE_SEQUENCES] and [P2K_CM_ENTITIES] tables.
;[Column Name|COLUMN_NAME]:This field identifies which column (field) may have a code sequenced defined for.
;[Table|TABLE_NAME]:This field identifies which table the column is associated to.
;[Table Alias |TABLE_ALIAS]:This field provides an abbreviated form of the table name.
!Attributes
;[Length of Code |CODE_LENGTH]:This field indicates the number of characters in the code sequence.
;[Zero Filled |ZERO_FILLED]: This toggle enables the code sequence to be filled with zeros to lengthen the code sequence to the length defined.
;[Last # Assigned|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|RANGE_LOWEST]:This number specifies the starting point of the automatically sequenced range.
;[Highest Range|RANGE_HIGHEST]: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 Options
;[Manual Entry Option|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|MANUAL_RULE]:This field identifies how the manual range is to function.
;[Manual Lowest|MANUAL_LOWEST]:This is the lowest value that may be manually entered.
;[Manual Highest |MANUAL_HIGHEST]:This is the highest value that may be manually entered.
----
![Notes|Edit:Internal.IMCS]
[{InsertPage page='Internal.IMCS' default='Click to create a new notes page'}]
!!!CODE SEQUENCES
The [{$applicationname}] program may automatically create review numbers. This is necessary if you wish to generate reviews and is recommended to ensure a logical numbering order of reviews. Sequences are maintained in the Define Code Sequences ([IMCS]) form.