| 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 | 26 | SETTLE_DOC_ID | Settlement Document Number | nvarchar | 10 | 0 | | |
2 | CACSCD_DOCCD_HD | Settlement to FS-CD: Reference Document Header | 3 | SETTLE_DOC_ID | Settlement Document Number | nvarchar | 10 | 0 | | |
3 | CACSCD_DOCCD_PD | Settlement to FS-CD: Reference Document Line Items | 3 | SETTLE_DOC_ID | Settlement Document Number | nvarchar | 10 | 0 | | |
4 | CACSCD_DOCCD_TI | Settlement to FS-CD: Reference Tax Information | 3 | SETTLE_DOC_ID | Settlement Document Number | nvarchar | 10 | 0 | | |
5 | CACSCD_DOCCD_TX | Settlement to FS-CD: Reference Document Tax | 3 | SETTLE_DOC_ID | Settlement Document Number | nvarchar | 10 | 0 | | |
6 | CACSFA_DOCFA_HD | Settlement to FI-CA: Reference Document Header | 3 | SETTLE_DOC_ID | Settlement Document Number | nvarchar | 10 | 0 | | |
7 | CACSFA_DOCFA_PD | Settlement to FI-CA: Reference Document Line Items | 3 | SETTLE_DOC_ID | Settlement Document Number | nvarchar | 10 | 0 | | |
8 | CACSFA_DOCFA_PKY | Settlement to FI-CA: Reference Pay Key Lines | 3 | SETTLE_DOC_ID | Settlement Document Number | nvarchar | 10 | 0 | | |
9 | CACSFI_DOCFI_CO | Settlement to FI: Reference Document Costs | 3 | SETTLE_DOC_ID | Settlement Document Number | nvarchar | 10 | 0 | | |
10 | CACSFI_DOCFI_HD | Settlement to FI: Reference Document Header | 3 | SETTLE_DOC_ID | Settlement Document Number | nvarchar | 10 | 0 | | |
11 | CACSFI_DOCFI_PD | Settlement to FI: Reference Line Item | 3 | SETTLE_DOC_ID | Settlement Document Number | nvarchar | 10 | 0 | | |
12 | CACSFI_DOCFI_TI | Settlement to FI: Reference Tax Information | 3 | SETTLE_DOC_ID | Settlement Document Number | nvarchar | 10 | 0 | | |
13 | CACSFI_DOCFI_TX | Settlement to FI: Reference Document Tax | 3 | SETTLE_DOC_ID | Settlement Document Number | nvarchar | 10 | 0 | | |
14 | CACSHR_DOCHR_HD | Settlement to PY: Reference Document Header | 3 | SETTLE_DOC_ID | Settlement Document Number | nvarchar | 10 | 0 | | |
15 | CACSHR_DOCHR_PD | Settlement to PY: Reference Line Item | 3 | SETTLE_DOC_ID | Settlement Document Number | nvarchar | 10 | 0 | | |
16 | CACSHR_DOCHR_TI | Settlement to PY: Reference Tax Information | 3 | SETTLE_DOC_ID | Settlement Document Number | nvarchar | 10 | 0 | | |
17 | CACSHR_DOCHR_TX | Settlement to PY: Reference Document Tax | 3 | SETTLE_DOC_ID | Settlement Document Number | nvarchar | 10 | 0 | | |
18 | CACS_STL_REF_H | Settlement Document Reference - Header | 4 | SETTLE_DOC_ID | Settlement Document Number | nvarchar | 10 | 0 | | |
19 | CACS_STL_REF_P | Settlement Document Reference - Splitting | 4 | SETTLE_DOC_ID | Settlement Document Number | nvarchar | 10 | 0 | | |
20 | YCRM01_DOCSE | Commission Document: Due Dates | 26 | SETTLE_DOC_ID | Settlement Document Number | nvarchar | 10 | 0 | | |
21 | YHITEC_DOCSE | Commission Document: Due Dates | 26 | SETTLE_DOC_ID | Settlement Document Number | nvarchar | 10 | 0 | | |
22 | YSVMA_DOCSE | Commission Document: Due Dates | 26 | SETTLE_DOC_ID | Settlement Document Number | nvarchar | 10 | 0 | | |
23 | YTEL01_DOCSE | Commission Document: Due Dates | 43 | SETTLE_DOC_ID | Settlement Document Number | nvarchar | 10 | 0 | | |
24 | YTEL05_DOCSE | Commission Document: Due Dates | 32 | SETTLE_DOC_ID | Settlement Document Number | nvarchar | 10 | 0 | | |
25 | ZICMAG_DOCSE | Commission Document: Due Dates | 26 | SETTLE_DOC_ID | Settlement Document Number | nvarchar | 10 | 0 | | |