| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPIncentive and Commission Management ICM |
1 | CACS00_ACCAS | Account Assignment Type/Cost Information for Remuneration | 3 | ACCAS_TYID | Account Assignment Type Identification | nvarchar | 4 | 0 | | |
2 | CACS00_ACCST | Account Assignment Type/Cost Info for Settlement Types | 3 | ACCAS_TYID | Account Assignment Type Identification | nvarchar | 4 | 0 | | |
3 | CACSCD_ACRCD | Account Assignments of Remun.Types for FS-CD Stt.System | 2 | ACCAS_TYID | Account Assignment Type Identification | nvarchar | 4 | 0 | | |
4 | CACSCD_ACSCD | Account Assignment of Stt.Types for FS-CD Settlement System | 2 | ACCAS_TYID | Account Assignment Type Identification | nvarchar | 4 | 0 | | |
5 | CACSFA_ACRFA | Account Assignments of Remun.Types for FI-CA settlement | 2 | ACCAS_TYID | Account Assignment Type Identification | nvarchar | 4 | 0 | | |
6 | CACSFA_ACSFA | Account Assignment of Stt.Types for FI-CA Settlement System | 2 | ACCAS_TYID | Account Assignment Type Identification | nvarchar | 4 | 0 | | |
7 | CACSFI_ACRFI | Account Assignment of Remun.Types for FI Settlement System | 2 | ACCAS_TYID | Account Assignment Type Identification | nvarchar | 4 | 0 | | |
8 | CACSFI_ACSFI | Account Assignment of Stt.Types for FI Settlement System | 2 | ACCAS_TYID | Account Assignment Type Identification | nvarchar | 4 | 0 | | |
9 | CACSHR_ACRHR | Account Assignment of Remun.Types for HCM Settlement System | 2 | ACCAS_TYID | Account Assignment Type Identification | nvarchar | 4 | 0 | | |
10 | CACSHR_ACSHR | Account Assignment of Settlement Types for HCM Stt.System | 2 | ACCAS_TYID | Account Assignment Type Identification | nvarchar | 4 | 0 | | |
11 | CACSNO_NOACT01 | Account Assignment Table | 3 | ACCAS_TYID | Account Assignment Type Identification | nvarchar | 4 | 0 | | |
12 | CACSNO_NO_ACSFI | Account Assignments Notification Rules FI | 2 | ACCAS_TYID | Account Assignment Type Identification | nvarchar | 4 | 0 | | |
13 | CACSSE_ACR01 | Remun.Type Acct. Assignments for Customer Settlement System | 2 | ACCAS_TYID | Account Assignment Type Identification | nvarchar | 4 | 0 | | |
14 | CACSSE_ACS01 | Stt.Type Account Assignments for Customer Settlement System | 2 | ACCAS_TYID | Account Assignment Type Identification | nvarchar | 4 | 0 | | |
15 | CACS_COMB_NOTI | Combination of Noti rule with Remu type and Ret rule | 22 | ACCAS_TYID | Account Assignment Type Identification | nvarchar | 4 | 0 | | |
16 | CACS_S_NOT_CO | Combination of Noti rule with Remu type and Ret rule | 22 | ACCAS_TYID | Account Assignment Type Identification | nvarchar | 4 | 0 | | |
17 | TCACS_ACCAS | Commissions: Account Assignment Type | 3 | ACCAS_TYID | Account Assignment Type Identification | nvarchar | 4 | 0 | | |
18 | TCACS_ACCAST | Commissions: Account Assignment Type - Texts | 4 | ACCAS_TYID | Account Assignment Type Identification | nvarchar | 4 | 0 | | |
19 | TCACS_NOTTRIG | Notification: Target System | 6 | ACCAS_TYID | Account Assignment Type Identification | nvarchar | 4 | 0 | | |
20 | TCACS_REM | Commission Remuneration Types | 12 | ACCAS_TYID | Account Assignment Type Identification | nvarchar | 4 | 0 | | |
21 | TCACS_STMTY | Settlement Type | 6 | ACCAS_TYID | Account Assignment Type Identification | nvarchar | 4 | 0 | | |
22 | YCRM01_ACCAS | Account Assignment Type/Cost Information for Remuneration | 3 | ACCAS_TYID | Account Assignment Type Identification | nvarchar | 4 | 0 | | |
23 | YCRM01_ACCST | Account Assignment Type/Cost Info for Settlement Types | 3 | ACCAS_TYID | Account Assignment Type Identification | nvarchar | 4 | 0 | | |
24 | YHITEC_ACCAS | Account Assignment Type/Cost Information for Remuneration | 3 | ACCAS_TYID | Account Assignment Type Identification | nvarchar | 4 | 0 | | |
25 | YHITEC_ACCST | Account Assignment Type/Cost Info for Settlement Types | 3 | ACCAS_TYID | Account Assignment Type Identification | nvarchar | 4 | 0 | | |
26 | YSVMA_ACCAS | Account Assignment Type/Cost Information for Remuneration | 3 | ACCAS_TYID | Account Assignment Type Identification | nvarchar | 4 | 0 | | |
27 | YSVMA_ACCST | Account Assignment Type/Cost Info for Settlement Types | 3 | ACCAS_TYID | Account Assignment Type Identification | nvarchar | 4 | 0 | | |
28 | YTEL01_ACCAS | Account Assignment Type/Cost Information for Remuneration | 3 | ACCAS_TYID | Account Assignment Type Identification | nvarchar | 4 | 0 | | |
29 | YTEL01_ACCST | Account Assignment Type/Cost Info for Settlement Types | 3 | ACCAS_TYID | Account Assignment Type Identification | nvarchar | 4 | 0 | | |
30 | YTEL05_ACCAS | Account Assignment Type/Cost Information for Remuneration | 3 | ACCAS_TYID | Account Assignment Type Identification | nvarchar | 4 | 0 | | |
31 | YTEL05_ACCST | Account Assignment Type/Cost Info for Settlement Types | 3 | ACCAS_TYID | Account Assignment Type Identification | nvarchar | 4 | 0 | | |
32 | ZICMAG_ACCAS | Account Assignment Type/Cost Information for Remuneration | 3 | ACCAS_TYID | Account Assignment Type Identification | nvarchar | 4 | 0 | | |
33 | ZICMAG_ACCST | Account Assignment Type/Cost Info for Settlement Types | 3 | ACCAS_TYID | Account Assignment Type Identification | nvarchar | 4 | 0 | | |