| 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) | 18 | DUE_CONAMNT | Amount in document currency | decimal | 13 | 2 | | |
2 | CACS00_DOCRE | Commission Document, Remuneration and Liability | 42 | DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | decimal | 15 | 2 | | |
3 | CACS00_DOCSE | Commission Document, Settlement | 19 | DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | decimal | 15 | 2 | | |
4 | CACS00_DOCSEDT | Line Item Detail Line | 9 | DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | decimal | 15 | 2 | | |
5 | CACS00_SUMRE | Totals Table for Remuneration | 12 | DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | decimal | 15 | 2 | | |
6 | CACS00_SUMSE | Totals Table for Settlement | 9 | DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | decimal | 15 | 2 | | |
7 | CACS25_SESIT | Settlement Schedule Item | 15 | DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | decimal | 15 | 2 | | |
8 | CACSCD_DOCCD_PD | Settlement to FS-CD: Reference Document Line Items | 21 | DUE_CONAMNT | Amount in document currency | decimal | 13 | 2 | | |
9 | CACSCD_DOCCD_TX | Settlement to FS-CD: Reference Document Tax | 8 | DUE_CONAMNT | Tax amount in document currency | decimal | 13 | 2 | | |
10 | CACSFA_DOCFA_PD | Settlement to FI-CA: Reference Document Line Items | 17 | DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | decimal | 15 | 2 | | |
11 | CACSFI_DOCFI_CO | Settlement to FI: Reference Document Costs | 9 | DUE_CONAMNT | Amount in document currency | decimal | 13 | 2 | | |
12 | CACSFI_DOCFI_PD | Settlement to FI: Reference Line Item | 13 | DUE_CONAMNT | Amount in document currency | decimal | 13 | 2 | | |
13 | CACSFI_DOCFI_TX | Settlement to FI: Reference Document Tax | 9 | DUE_CONAMNT | Tax amount in document currency | decimal | 13 | 2 | | |
14 | CACSHR_DOCHR_PD | Settlement to PY: Reference Line Item | 21 | DUE_CONAMNT | Amount in document currency | decimal | 13 | 2 | | |
15 | CACSHR_DOCHR_TX | Settlement to PY: Reference Document Tax | 10 | DUE_CONAMNT | Tax amount in document currency | decimal | 13 | 2 | | |
16 | CACS_DOCRE | Expected Commission (Remuneration) | 15 | DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | decimal | 15 | 2 | | |
17 | YCRM01_DOCFI_P | Data Transfer: FI Documents Item | 18 | DUE_CONAMNT | Amount in document currency | decimal | 13 | 2 | | |
18 | YCRM01_DOCRE | Commission Document, Remuneration and Liability | 69 | DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | decimal | 15 | 2 | | |
19 | YCRM01_DOCSE | Commission Document: Due Dates | 19 | DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | decimal | 15 | 2 | | |
20 | YCRM01_DOCSEDT | Due Date Details | 9 | DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | decimal | 15 | 2 | | |
21 | YCRM01_SESIT | Settlement Schedule Item | 15 | DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | decimal | 15 | 2 | | |
22 | YCRM01_SUMRE | Remuneration Totals for Contract Account Display | 22 | DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | decimal | 15 | 2 | | |
23 | YCRM01_SUMRE02 | Commissions: Reference Totals Table for Compensation | 7 | DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | decimal | 15 | 2 | | |
24 | YCRM01_SUMSE | Due Date Totals for Contract Account Display | 9 | DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | decimal | 15 | 2 | | |
25 | YHITEC_DOCFI_P | Data Transfer: FI Documents Item | 16 | DUE_CONAMNT | Amount in document currency | decimal | 13 | 2 | | |
26 | YHITEC_DOCRE | Commission Document, Remuneration and Liability | 52 | DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | decimal | 15 | 2 | | |
27 | YHITEC_DOCSE | Commission Document: Due Dates | 19 | DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | decimal | 15 | 2 | | |
28 | YHITEC_SUMRE | Remuneration Totals for Contract Account Display | 12 | DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | decimal | 15 | 2 | | |
29 | YHITEC_SUMSE | Due Date Totals for Contract Account Display | 9 | DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | decimal | 15 | 2 | | |
30 | YSVMA_DOCFI_P | Data Transfer: FI Documents (Items) | 16 | DUE_CONAMNT | Amount in document currency | decimal | 13 | 2 | | |
31 | YSVMA_DOCRE | Commission Document, Remuneration and Liability | 46 | DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | decimal | 15 | 2 | | |
32 | YSVMA_DOCSE | Commission Document: Due Dates | 19 | DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | decimal | 15 | 2 | | |
33 | YSVMA_DOCSEDT | Due Date Details | 9 | DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | decimal | 15 | 2 | | |
34 | YSVMA_SESIT | Settlement Schedule Item | 15 | DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | decimal | 15 | 2 | | |
35 | YSVMA_SUMRE | Remuneration Totals for Contract Account Display | 13 | DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | decimal | 15 | 2 | | |
36 | YSVMA_SUMSE | Due Date Totals for Contract Account Display | 9 | DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | decimal | 15 | 2 | | |
37 | YTEL01_DOCFI_P | Data Transfer: FI Documents Item | 16 | DUE_CONAMNT | Amount in document currency | decimal | 13 | 2 | | |
38 | YTEL01_DOCRE | Commission Document, Remuneration and Liability | 66 | DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | decimal | 15 | 2 | | |
39 | YTEL01_DOCSE | Commission Document: Due Dates | 36 | DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | decimal | 15 | 2 | | |
40 | YTEL01_DOCSEDT | Due Date Details | 9 | DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | decimal | 15 | 2 | | |
41 | YTEL01_SUMRE | Remuneration Totals for Contract Account Display | 12 | DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | decimal | 15 | 2 | | |
42 | YTEL01_SUMSE | Due Date Totals for Contract Account Display | 9 | DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | decimal | 15 | 2 | | |
43 | YTEL01_SUMSE02 | Reference Table for Settlement | 6 | DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | decimal | 15 | 2 | | |
44 | YTEL05_DOCFI_P | Data Transfer: FI Documents (Items) | 16 | DUE_CONAMNT | Amount in document currency | decimal | 13 | 2 | | |
45 | YTEL05_DOCRE | Commission Document, Remuneration and Liability | 60 | DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | decimal | 15 | 2 | | |
46 | YTEL05_DOCSE | Commission Document: Due Dates | 25 | DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | decimal | 15 | 2 | | |
47 | YTEL05_DOCSEDT | Due Date Details | 9 | DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | decimal | 15 | 2 | | |
48 | YTEL05_SESIT | Settlement Schedule Item | 15 | DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | decimal | 15 | 2 | | |
49 | YTEL05_SUMRE | Remuneration Totals for Contract Account Display | 12 | DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | decimal | 15 | 2 | | |
50 | YTEL05_SUMSE | Due Date Totals for Contract Account Display | 9 | DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | decimal | 15 | 2 | | |
51 | ZICMAG_DOCFI_P | Data Transfer: FI Documents (Items) | 16 | DUE_CONAMNT | Amount in document currency | decimal | 13 | 2 | | |
52 | ZICMAG_DOCRE | Commission Document, Remuneration and Liability | 44 | DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | decimal | 15 | 2 | | |
53 | ZICMAG_DOCSE | Commission Document: Due Dates | 19 | DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | decimal | 15 | 2 | | |
54 | ZICMAG_DOCSEDT | Due Date Details | 9 | DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | decimal | 15 | 2 | | |
55 | ZICMAG_SUMRE | Remuneration Totals for Contract Account Display | 12 | DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | decimal | 15 | 2 | | |
56 | ZICMAG_SUMSE | Due Date Totals for Contract Account Display | 9 | DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | decimal | 15 | 2 | | |