| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPIncentive and Commission Management ICM |
1 | CACS00_DOCFI_P | Data Transfer: FI Documents (Items) | 4 | SETTL_POS | Item Number | nvarchar | 4 | 0 | | |
2 | CACS00_DOCSE | Commission Document, Settlement | 4 | SETTL_POS | Identification of a Settlement Item | nvarchar | 4 | 0 | | |
3 | CACS00_DOCSEDT | Line Item Detail Line | 4 | SETTL_POS | Identification of a Settlement Item | nvarchar | 4 | 0 | | |
4 | CACS_DOCFI_T | Data Transfer: FI Document (Tax Item) | 5 | SETTL_POS | Item Number | nvarchar | 4 | 0 | | |
5 | CACS_STL_REF_D | Settlement Document Reference - Detail | 5 | SETTL_POS | Identification of a Settlement Item | nvarchar | 4 | 0 | | |
6 | YCRM01_DOCFI_P | Data Transfer: FI Documents Item | 4 | SETTL_POS | Item Number | nvarchar | 4 | 0 | | |
7 | YCRM01_DOCSE | Commission Document: Due Dates | 4 | SETTL_POS | Identification of a Settlement Item | nvarchar | 4 | 0 | | |
8 | YCRM01_DOCSEDT | Due Date Details | 4 | SETTL_POS | Identification of a Settlement Item | nvarchar | 4 | 0 | | |
9 | YHITEC_DOCFI_P | Data Transfer: FI Documents Item | 4 | SETTL_POS | Item Number | nvarchar | 4 | 0 | | |
10 | YHITEC_DOCSE | Commission Document: Due Dates | 4 | SETTL_POS | Identification of a Settlement Item | nvarchar | 4 | 0 | | |
11 | YSVMA_DOCFI_P | Data Transfer: FI Documents (Items) | 4 | SETTL_POS | Item Number | nvarchar | 4 | 0 | | |
12 | YSVMA_DOCSE | Commission Document: Due Dates | 4 | SETTL_POS | Identification of a Settlement Item | nvarchar | 4 | 0 | | |
13 | YSVMA_DOCSEDT | Due Date Details | 4 | SETTL_POS | Identification of a Settlement Item | nvarchar | 4 | 0 | | |
14 | YTEL01_DOCFI_P | Data Transfer: FI Documents Item | 4 | SETTL_POS | Item Number | nvarchar | 4 | 0 | | |
15 | YTEL01_DOCSE | Commission Document: Due Dates | 4 | SETTL_POS | Identification of a Settlement Item | nvarchar | 4 | 0 | | |
16 | YTEL01_DOCSEDT | Due Date Details | 4 | SETTL_POS | Identification of a Settlement Item | nvarchar | 4 | 0 | | |
17 | YTEL05_DOCFI_P | Data Transfer: FI Documents (Items) | 4 | SETTL_POS | Item Number | nvarchar | 4 | 0 | | |
18 | YTEL05_DOCSE | Commission Document: Due Dates | 4 | SETTL_POS | Identification of a Settlement Item | nvarchar | 4 | 0 | | |
19 | YTEL05_DOCSEDT | Due Date Details | 4 | SETTL_POS | Identification of a Settlement Item | nvarchar | 4 | 0 | | |
20 | ZICMAG_DOCFI_P | Data Transfer: FI Documents (Items) | 4 | SETTL_POS | Item Number | nvarchar | 4 | 0 | | |
21 | ZICMAG_DOCSE | Commission Document: Due Dates | 4 | SETTL_POS | Identification of a Settlement Item | nvarchar | 4 | 0 | | |
22 | ZICMAG_DOCSEDT | Due Date Details | 4 | SETTL_POS | Identification of a Settlement Item | nvarchar | 4 | 0 | | |