| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPConditions |
1 | A871 | Monthly Incentive Target | 6 | REM_BUSCASE_TYP | Remunerating Business Transaction in Operational System | nvarchar | 3 | 0 | | |
2 | A872 | Monthly Transaction Target | 6 | REM_BUSCASE_TYP | Remunerating Business Transaction in Operational System | nvarchar | 3 | 0 | | |
3 | A873 | YTD Accelerator | 6 | REM_BUSCASE_TYP | Remunerating Business Transaction in Operational System | nvarchar | 3 | 0 | | |
4 | A904 | Appl./AgreemntNo/Divis./Contr. no./RemBusTrCt/Version/Status | 8 | REM_BUSCASE_TYP | Remunerating Business Transaction in Operational System | nvarchar | 3 | 0 | | |
5 | A905 | Appl./AgreemntNo/Contr. no./RemBusTrCt/Version/Status | 7 | REM_BUSCASE_TYP | Remunerating Business Transaction in Operational System | nvarchar | 3 | 0 | | |
TOPIncentive and Commission Management ICM |
6 | A195 | A195 | 6 | REM_BUSCASE_TYP | Operación comercial a remunerar en sistema preexistente | nvarchar | 3 | 0 | | |
7 | CACS00_B_VAR_CAS | Variants for Commission Case | 31 | REM_BUSCASE_TYP | Remunerating Business Transaction in Operational System | nvarchar | 3 | 0 | | |
8 | CACS00_CAS | Commission Case | 27 | REM_BUSCASE_TYP | Remunerating Business Transaction in Operational System | nvarchar | 3 | 0 | | |
9 | CACS00_DOCHD | Commission Document Header | 25 | REM_BUSCASE_TYP | Remunerating Business Transaction in Operational System | nvarchar | 3 | 0 | | |
10 | CACS_DOCHD | Expected Commission (Remuneration) | 6 | REM_BUSCASE_TYP | Remunerating Business Transaction in Operational System | nvarchar | 3 | 0 | | |
11 | CACS_DOCRE | Expected Commission (Remuneration) | 6 | REM_BUSCASE_TYP | Remunerating Business Transaction in Operational System | nvarchar | 3 | 0 | | |
12 | TCACS_ELTDOCREV | Automatic Deactivation of ELT Document | 4 | REM_BUSCASE_TYP | Remunerating Business Transaction in Operational System | nvarchar | 3 | 0 | | |
13 | TCACS_ELTNEGENT | Transfer Negative Entitlements in ELT | 4 | REM_BUSCASE_TYP | Remunerating Business Transaction in Operational System | nvarchar | 3 | 0 | | |
14 | TCACS_ELTPOSTNEG | Transfer Reversal Posting in ELT | 4 | REM_BUSCASE_TYP | Remunerating Business Transaction in Operational System | nvarchar | 3 | 0 | | |
15 | TCACS_TRCAS | Trigger for Additional Commission Case | 9 | REM_BUSCASE_TYP | Remunerating Business Transaction in Operational System | nvarchar | 3 | 0 | | |
16 | YCRM01_B_VAR_CAS | Variants for Commission Case | 39 | REM_BUSCASE_TYP | Remunerating Business Transaction in Operational System | nvarchar | 3 | 0 | | |
17 | YCRM01_CAS | Commission Case | 27 | REM_BUSCASE_TYP | Remunerating Business Transaction in Operational System | nvarchar | 3 | 0 | | |
18 | YCRM01_DOCHD | Commission Document Header | 25 | REM_BUSCASE_TYP | Remunerating Business Transaction in Operational System | nvarchar | 3 | 0 | | |
19 | YHITEC_B_VAR_CAS | Variants for Commission Case | 24 | REM_BUSCASE_TYP | Remunerating Business Transaction in Operational System | nvarchar | 3 | 0 | | |
20 | YHITEC_CAS | Commission Case | 20 | REM_BUSCASE_TYP | Remunerating Business Transaction in Operational System | nvarchar | 3 | 0 | | |
21 | YHITEC_DOCHD | Commission Document Header | 26 | REM_BUSCASE_TYP | Remunerating Business Transaction in Operational System | nvarchar | 3 | 0 | | |
22 | YSVMA_B_VAR_CAS | Variants for Commission Case | 39 | REM_BUSCASE_TYP | Remunerating Business Transaction in Operational System | nvarchar | 3 | 0 | | |
23 | YSVMA_CAS | Commission Case | 35 | REM_BUSCASE_TYP | Remunerating Business Transaction in Operational System | nvarchar | 3 | 0 | | |
24 | YSVMA_DOCHD | Commission Document Header | 33 | REM_BUSCASE_TYP | Remunerating Business Transaction in Operational System | nvarchar | 3 | 0 | | |
25 | YTEL01_B_VAR_CAS | Variants for Commission Case | 24 | REM_BUSCASE_TYP | Remunerating Business Transaction in Operational System | nvarchar | 3 | 0 | | |
26 | YTEL01_CAS | Commission Case | 20 | REM_BUSCASE_TYP | Remunerating Business Transaction in Operational System | nvarchar | 3 | 0 | | |
27 | YTEL01_DOCHD | Commission Document Header | 26 | REM_BUSCASE_TYP | Remunerating Business Transaction in Operational System | nvarchar | 3 | 0 | | |
28 | YTEL05_B_VAR_CAS | Variants for Commission Case | 39 | REM_BUSCASE_TYP | Remunerating Business Transaction in Operational System | nvarchar | 3 | 0 | | |
29 | YTEL05_CAS | Commission Case | 35 | REM_BUSCASE_TYP | Remunerating Business Transaction in Operational System | nvarchar | 3 | 0 | | |
30 | YTEL05_DOCHD | Commission Document Header | 33 | REM_BUSCASE_TYP | Remunerating Business Transaction in Operational System | nvarchar | 3 | 0 | | |
31 | ZICMAG_B_VAR_CAS | Variants for Commission Case | 24 | REM_BUSCASE_TYP | Remunerating Business Transaction in Operational System | nvarchar | 3 | 0 | | |
32 | ZICMAG_CAS | Commission Case | 20 | REM_BUSCASE_TYP | Remunerating Business Transaction in Operational System | nvarchar | 3 | 0 | | |
33 | ZICMAG_DOCHD | Commission Document Header | 26 | REM_BUSCASE_TYP | Remunerating Business Transaction in Operational System | nvarchar | 3 | 0 | | |