...
Suppose a certain company has the following rules:
Types of Rotation Rules | |||
Code | Description | Table | Field |
04 | Activity- CNAE | Suspect | CNAE Code |
01 | Strategic - Invoicing | Suspect | Annual Invoicing |
05 | Region - ZIP CODE | Suspect | ZIP CODE |
Table 1
...
In the first stage, the system tracks sales representatives found within the Suspect data range and that have the rule associated to the sales representative.
Rotation Rule | |||||
Sales Representative | Position in Line | Type of Rule | Description | Range From | Range To |
000004 | 0001 | 05 | Region – São Paulo – South Side | 000001-000 | 039999-999 |
000003 | 0002 | 05 | Region – São Paulo – West Side | 040000-000 | 059999-999 |
000002 | 0003 | 05 | Region – São Paulo – North Side | 060000-000 | 079999-999 |
000005 | 0004 | 04 | Activity – Governmental | 0300-00/00 | 0399-99/99 |
000006 | 0005 | 04 | Activity – Governmental | 0300-00/00 | 0399-99/99 |
000001 | 0006 | 01 | Strategic – Invoicing | 5,000,000.00 | 10,000,000.00 |
Table 2
...