| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPIncentive and Commission Management ICM |
1 | CACS00_DOCSE | Commission Document, Settlement | 25 | SETTLE_POST_YEAR | Posting Year of Settlement Document | nvarchar | 4 | 0 | | |
2 | CACSCD_DOCCD_HD | Settlement to FS-CD: Reference Document Header | 2 | SETTLE_POST_YEAR | Posting Year of Settlement Document | nvarchar | 4 | 0 | | |
3 | CACSCD_DOCCD_PD | Settlement to FS-CD: Reference Document Line Items | 2 | SETTLE_POST_YEAR | Posting Year of Settlement Document | nvarchar | 4 | 0 | | |
4 | CACSCD_DOCCD_TI | Settlement to FS-CD: Reference Tax Information | 2 | SETTLE_POST_YEAR | Posting Year of Settlement Document | nvarchar | 4 | 0 | | |
5 | CACSCD_DOCCD_TX | Settlement to FS-CD: Reference Document Tax | 2 | SETTLE_POST_YEAR | Posting Year of Settlement Document | nvarchar | 4 | 0 | | |
6 | CACSFA_DOCFA_HD | Settlement to FI-CA: Reference Document Header | 2 | SETTLE_POST_YEAR | Posting Year of Settlement Document | nvarchar | 4 | 0 | | |
7 | CACSFA_DOCFA_PD | Settlement to FI-CA: Reference Document Line Items | 2 | SETTLE_POST_YEAR | Posting Year of Settlement Document | nvarchar | 4 | 0 | | |
8 | CACSFA_DOCFA_PKY | Settlement to FI-CA: Reference Pay Key Lines | 2 | SETTLE_POST_YEAR | Posting Year of Settlement Document | nvarchar | 4 | 0 | | |
9 | CACSFI_DOCFI_CO | Settlement to FI: Reference Document Costs | 2 | SETTLE_POST_YEAR | Posting Year of Settlement Document | nvarchar | 4 | 0 | | |
10 | CACSFI_DOCFI_HD | Settlement to FI: Reference Document Header | 2 | SETTLE_POST_YEAR | Posting Year of Settlement Document | nvarchar | 4 | 0 | | |
11 | CACSFI_DOCFI_PD | Settlement to FI: Reference Line Item | 2 | SETTLE_POST_YEAR | Posting Year of Settlement Document | nvarchar | 4 | 0 | | |
12 | CACSFI_DOCFI_TI | Settlement to FI: Reference Tax Information | 2 | SETTLE_POST_YEAR | Posting Year of Settlement Document | nvarchar | 4 | 0 | | |
13 | CACSFI_DOCFI_TX | Settlement to FI: Reference Document Tax | 2 | SETTLE_POST_YEAR | Posting Year of Settlement Document | nvarchar | 4 | 0 | | |
14 | CACSHR_DOCHR_HD | Settlement to PY: Reference Document Header | 2 | SETTLE_POST_YEAR | Posting Year of Settlement Document | nvarchar | 4 | 0 | | |
15 | CACSHR_DOCHR_PD | Settlement to PY: Reference Line Item | 2 | SETTLE_POST_YEAR | Posting Year of Settlement Document | nvarchar | 4 | 0 | | |
16 | CACSHR_DOCHR_TI | Settlement to PY: Reference Tax Information | 2 | SETTLE_POST_YEAR | Posting Year of Settlement Document | nvarchar | 4 | 0 | | |
17 | CACSHR_DOCHR_TX | Settlement to PY: Reference Document Tax | 2 | SETTLE_POST_YEAR | Posting Year of Settlement Document | nvarchar | 4 | 0 | | |
18 | CACS_STL_REF_H | Settlement Document Reference - Header | 3 | SETTLE_POST_YEAR | Posting Year of Settlement Document | nvarchar | 4 | 0 | | |
19 | CACS_STL_REF_P | Settlement Document Reference - Splitting | 3 | SETTLE_POST_YEAR | Posting Year of Settlement Document | nvarchar | 4 | 0 | | |
20 | YCRM01_DOCSE | Commission Document: Due Dates | 25 | SETTLE_POST_YEAR | Posting Year of Settlement Document | nvarchar | 4 | 0 | | |
21 | YHITEC_DOCSE | Commission Document: Due Dates | 25 | SETTLE_POST_YEAR | Posting Year of Settlement Document | nvarchar | 4 | 0 | | |
22 | YSVMA_DOCSE | Commission Document: Due Dates | 25 | SETTLE_POST_YEAR | Posting Year of Settlement Document | nvarchar | 4 | 0 | | |
23 | YTEL01_DOCSE | Commission Document: Due Dates | 42 | SETTLE_POST_YEAR | Posting Year of Settlement Document | nvarchar | 4 | 0 | | |
24 | YTEL05_DOCSE | Commission Document: Due Dates | 31 | SETTLE_POST_YEAR | Posting Year of Settlement Document | nvarchar | 4 | 0 | | |
25 | ZICMAG_DOCSE | Commission Document: Due Dates | 25 | SETTLE_POST_YEAR | Posting Year of Settlement Document | nvarchar | 4 | 0 | | |