| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPIncentive and Commission Management ICM |
| 1 | CACS00_DOCSE | Commission Document, Settlement | 12 | DUE_MONTH | Period in Year Due | nvarchar | 2 | 0 | | |
| 2 | CACS00_SUMSE | Totals Table for Settlement | 5 | DUE_MONTH | Period in Year Due | nvarchar | 2 | 0 | | |
| 3 | YCRM01_DOCSE | Commission Document: Due Dates | 12 | DUE_MONTH | Period in Year Due | nvarchar | 2 | 0 | | |
| 4 | YCRM01_SUMSE | Due Date Totals for Contract Account Display | 5 | DUE_MONTH | Period in Year Due | nvarchar | 2 | 0 | | |
| 5 | YHITEC_DOCSE | Commission Document: Due Dates | 12 | DUE_MONTH | Period in Year Due | nvarchar | 2 | 0 | | |
| 6 | YHITEC_SUMSE | Due Date Totals for Contract Account Display | 5 | DUE_MONTH | Period in Year Due | nvarchar | 2 | 0 | | |
| 7 | YSVMA_DOCSE | Commission Document: Due Dates | 12 | DUE_MONTH | Period in Year Due | nvarchar | 2 | 0 | | |
| 8 | YSVMA_SUMSE | Due Date Totals for Contract Account Display | 5 | DUE_MONTH | Period in Year Due | nvarchar | 2 | 0 | | |
| 9 | YTEL01_DOCSE | Commission Document: Due Dates | 29 | DUE_MONTH | Period in Year Due | nvarchar | 2 | 0 | | |
| 10 | YTEL01_SUMSE | Due Date Totals for Contract Account Display | 5 | DUE_MONTH | Period in Year Due | nvarchar | 2 | 0 | | |
| 11 | YTEL01_SUMSE02 | Reference Table for Settlement | 5 | DUE_MONTH | Period in Year Due | nvarchar | 2 | 0 | | |
| 12 | YTEL05_DOCSE | Commission Document: Due Dates | 18 | DUE_MONTH | Period in Year Due | nvarchar | 2 | 0 | | |
| 13 | YTEL05_SUMSE | Due Date Totals for Contract Account Display | 5 | DUE_MONTH | Period in Year Due | nvarchar | 2 | 0 | | |
| 14 | ZICMAG_DOCSE | Commission Document: Due Dates | 12 | DUE_MONTH | Period in Year Due | nvarchar | 2 | 0 | | |
| 15 | ZICMAG_SUMSE | Due Date Totals for Contract Account Display | 5 | DUE_MONTH | Period in Year Due | nvarchar | 2 | 0 | | |
