Setting up Global Rolling Columns
From the main Navigation Menu, select Maintenance>>Global Rolling Columns.
To create a new Global Rolling Column, click the Create Global Rolling Column button.
- Enter a unique Name for the global rolling column.
- Enter a Description.
Enter a starting value for the Next Number field. When an integration process uses the global rolling column, this is the value that will be retrieved and incremented.
- IMPORTANT: The value used in the global rolling column will never expand beyond the number of characters that it is created with. For example, the value of SC01 will only work for 99 records, once the rolling column is incremented to SC99 – it has no room to increment to the next value as the total number of characters will not change during use. A much more appropriate starting value in this scenario would be SC0000001.
- Click Save to complete the creation of the new global rolling column.