| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPIncentive and Commission Management ICM |
1 | CACS00_DOCDT | Comn: Detail Items for Remuneration Rows | 4 | REMUN_POS | ID of Remuneration Row for Referenced Document | nvarchar | 4 | 0 | | |
2 | CACS00_DOCRE | Commission Document, Remuneration and Liability | 4 | REMUN_POS | ID of Remuneration Row for Referenced Document | nvarchar | 4 | 0 | | |
3 | CACS00_DOCRE01 | Do Not Use! Enhancement Data Remuneration Lines | 4 | REMUN_POS | ID of Remuneration Row for Referenced Document | nvarchar | 4 | 0 | | |
4 | CACS00_DOCSE01 | Do Not Use! Enhancement Data Settlement Rows | 4 | REMUN_POS | ID of Remuneration Row for Referenced Document | nvarchar | 4 | 0 | | |
5 | CACS25_SESHD | Settlement Schedule Header | 8 | REMUN_POS | ID of Remuneration Row for Referenced Document | nvarchar | 4 | 0 | | |
6 | CACSCP_RCP_BUFF | RCP: Buffer Table for RCP Processing | 10 | REMUN_POS | ID of Remuneration Row for Referenced Document | nvarchar | 4 | 0 | | |
7 | CACS_DOCRE | Expected Commission (Remuneration) | 8 | REMUN_POS | ID of Remuneration Row for Referenced Document | nvarchar | 4 | 0 | | |
8 | YCRM01_DOCDT | Comn: Detail Items for Remuneration Rows | 4 | REMUN_POS | ID of Remuneration Row for Referenced Document | nvarchar | 4 | 0 | | |
9 | YCRM01_DOCRE | Commission Document, Remuneration and Liability | 4 | REMUN_POS | ID of Remuneration Row for Referenced Document | nvarchar | 4 | 0 | | |
10 | YCRM01_DOCRE91 | Do Not Use! Enhancement Data Remuneration Lines | 4 | REMUN_POS | ID of Remuneration Row for Referenced Document | nvarchar | 4 | 0 | | |
11 | YCRM01_DOCSE91 | Do Not Use! Enhancement Data Settlement Rows | 4 | REMUN_POS | ID of Remuneration Row for Referenced Document | nvarchar | 4 | 0 | | |
12 | YCRM01_SESHD | Settlement Schedule Header | 8 | REMUN_POS | ID of Remuneration Row for Referenced Document | nvarchar | 4 | 0 | | |
13 | YHITEC_DOCDT | Comn: Detail Items for Remuneration Rows | 4 | REMUN_POS | ID of Remuneration Row for Referenced Document | nvarchar | 4 | 0 | | |
14 | YHITEC_DOCRE | Commission Document, Remuneration and Liability | 4 | REMUN_POS | ID of Remuneration Row for Referenced Document | nvarchar | 4 | 0 | | |
15 | YHITEC_DOCRE91 | Do Not Use! Enhancement Data Remuneration Lines | 4 | REMUN_POS | ID of Remuneration Row for Referenced Document | nvarchar | 4 | 0 | | |
16 | YHITEC_DOCSE91 | Do Not Use! Enhancement Data Settlement Rows | 4 | REMUN_POS | ID of Remuneration Row for Referenced Document | nvarchar | 4 | 0 | | |
17 | YSVMA_DOCDT | Comn: Detail Items for Remuneration Rows | 4 | REMUN_POS | ID of Remuneration Row for Referenced Document | nvarchar | 4 | 0 | | |
18 | YSVMA_DOCRE | Commission Document, Remuneration and Liability | 4 | REMUN_POS | ID of Remuneration Row for Referenced Document | nvarchar | 4 | 0 | | |
19 | YSVMA_RCP_BUFF | RCP: Buffer Table for RCP Processing | 10 | REMUN_POS | ID of Remuneration Row for Referenced Document | nvarchar | 4 | 0 | | |
20 | YSVMA_SESHD | Settlement Schedule Header | 8 | REMUN_POS | ID of Remuneration Row for Referenced Document | nvarchar | 4 | 0 | | |
21 | YTEL01_DOCDT | Comn: Detail Items for Remuneration Rows | 4 | REMUN_POS | ID of Remuneration Row for Referenced Document | nvarchar | 4 | 0 | | |
22 | YTEL01_DOCRE | Commission Document, Remuneration and Liability | 4 | REMUN_POS | ID of Remuneration Row for Referenced Document | nvarchar | 4 | 0 | | |
23 | YTEL01_DOCRE01 | Do Not Use! Enhancement Data Remuneration Lines | 4 | REMUN_POS | ID of Remuneration Row for Referenced Document | nvarchar | 4 | 0 | | |
24 | YTEL01_DOCSE01 | Do Not Use! Enhancement Data Settlement Rows | 4 | REMUN_POS | ID of Remuneration Row for Referenced Document | nvarchar | 4 | 0 | | |
25 | YTEL05_DOCDT | Comn: Detail Items for Remuneration Rows | 4 | REMUN_POS | ID of Remuneration Row for Referenced Document | nvarchar | 4 | 0 | | |
26 | YTEL05_DOCRE | Commission Document, Remuneration and Liability | 4 | REMUN_POS | ID of Remuneration Row for Referenced Document | nvarchar | 4 | 0 | | |
27 | YTEL05_RCP_BUFF | RCP: Buffer Table for RCP Processing | 10 | REMUN_POS | ID of Remuneration Row for Referenced Document | nvarchar | 4 | 0 | | |
28 | YTEL05_SESHD | Settlement Schedule Header | 8 | REMUN_POS | ID of Remuneration Row for Referenced Document | nvarchar | 4 | 0 | | |
29 | ZICMAG_DOCDT | Comn: Detail Items for Remuneration Rows | 4 | REMUN_POS | ID of Remuneration Row for Referenced Document | nvarchar | 4 | 0 | | |
30 | ZICMAG_DOCRE | Commission Document, Remuneration and Liability | 4 | REMUN_POS | ID of Remuneration Row for Referenced Document | nvarchar | 4 | 0 | | |