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 7 removed 4 lines
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.
At line 13 changed 3 lines
;[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.
‘Define Code Sequences’ Usage and Examples
;[Column Name|COLUMN_NAME]:Which column (field) is to be "sequenced".
;[Table|TABLE_NAME]:This
At line 17 changed one line
!Attributes
;[Table Alias |TABLE_ALIAS]:This field provides an abbreviated form of the table name.
At line 19 changed one line
;[Zero Filled |ZERO_FILLED]: This toggle enables the code sequence to be filled with zeros to lengthen the code sequence to the length defined.
;[Zero Filled |ZERO_FILLED]:
At line 23 removed 2 lines
!Manual Entry Options
At line 26 changed 9 lines
;[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'}]
;[Manual Rule|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|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.