| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPIncentive and Commission Management ICM |
1 | CACS00_B_VAR_CAS | Variants for Commission Case | 45 | PERIOD_NO | Period Number | nvarchar | 6 | 0 | | |
2 | CACS00_CAS | Commission Case | 41 | PERIOD_NO | Period Number | nvarchar | 6 | 0 | | |
3 | CACS00_DOCHD | Commission Document Header | 38 | PERIOD_NO | Period Number | nvarchar | 6 | 0 | | |
4 | CACS_REMAJO | Flat-Rate Remuneration: Calculation Log | 11 | PERIOD_NO | Period Number | nvarchar | 6 | 0 | | |
5 | CACS_STMTJO | Settlement run log | 11 | PERIOD_NO | Period Number | nvarchar | 6 | 0 | | |
6 | CACS_TGACV | Target Agreements: Indiv. Actual/Correction/Target Values | 6 | PERIOD_NO | Period Number | nvarchar | 6 | 0 | | |
7 | CACS_TGLOG | Obsolete (Target Agreements: Log) | 7 | PERIOD_NO | Period Number | nvarchar | 6 | 0 | | |
8 | CACS_TGRIND | Target Agreements: Individual Target Rules | 6 | PERIOD_NO | Period Number | nvarchar | 6 | 0 | | |
9 | CACS_TGRIND_AES | Target Agreements: Individual Target Rules for AES | 6 | PERIOD_NO | Period Number | nvarchar | 6 | 0 | | |
10 | CACS_TRICAJO | Commission Case Trigger: Log | 11 | PERIOD_NO | Period Number | nvarchar | 6 | 0 | | |
11 | CACS_WARJO | Guarantee Calculation Log | 11 | PERIOD_NO | Period Number | nvarchar | 6 | 0 | | |
12 | TCACS_PERIOD | Period Definition (Obsolete) | 4 | PERIOD_NO | Period Number | nvarchar | 6 | 0 | | |
13 | TCACS_PERIOD_T | Period Definition (Obsolete) | 5 | PERIOD_NO | Period Number | nvarchar | 6 | 0 | | |
14 | TCACS_PRD | Period | 5 | PERIOD_NO | Period Number | nvarchar | 6 | 0 | | |
15 | TCACS_PRDT | Name of Period | 6 | PERIOD_NO | Period Number | nvarchar | 6 | 0 | | |
16 | YCRM01_B_VAR_CAS | Variants for Commission Case | 53 | PERIOD_NO | Period Number | nvarchar | 6 | 0 | | |
17 | YCRM01_CAS | Commission Case | 41 | PERIOD_NO | Period Number | nvarchar | 6 | 0 | | |
18 | YCRM01_DOCHD | Commission Document Header | 38 | PERIOD_NO | Period Number | nvarchar | 6 | 0 | | |
19 | YHITEC_B_VAR_CAS | Variants for Commission Case | 38 | PERIOD_NO | Period Number | nvarchar | 6 | 0 | | |
20 | YHITEC_CAS | Commission Case | 34 | PERIOD_NO | Period Number | nvarchar | 6 | 0 | | |
21 | YHITEC_DOCHD | Commission Document Header | 39 | PERIOD_NO | Period Number | nvarchar | 6 | 0 | | |
22 | YSVMA_B_VAR_CAS | Variants for Commission Case | 53 | PERIOD_NO | Period Number | nvarchar | 6 | 0 | | |
23 | YSVMA_CAS | Commission Case | 49 | PERIOD_NO | Period Number | nvarchar | 6 | 0 | | |
24 | YSVMA_DOCHD | Commission Document Header | 46 | PERIOD_NO | Period Number | nvarchar | 6 | 0 | | |
25 | YTEL01_B_VAR_CAS | Variants for Commission Case | 38 | PERIOD_NO | Period Number | nvarchar | 6 | 0 | | |
26 | YTEL01_CAS | Commission Case | 34 | PERIOD_NO | Period Number | nvarchar | 6 | 0 | | |
27 | YTEL01_DOCHD | Commission Document Header | 39 | PERIOD_NO | Period Number | nvarchar | 6 | 0 | | |
28 | YTEL05_B_VAR_CAS | Variants for Commission Case | 53 | PERIOD_NO | Period Number | nvarchar | 6 | 0 | | |
29 | YTEL05_CAS | Commission Case | 49 | PERIOD_NO | Period Number | nvarchar | 6 | 0 | | |
30 | YTEL05_DOCHD | Commission Document Header | 46 | PERIOD_NO | Period Number | nvarchar | 6 | 0 | | |
31 | ZICMAG_B_VAR_CAS | Variants for Commission Case | 38 | PERIOD_NO | Period Number | nvarchar | 6 | 0 | | |
32 | ZICMAG_CAS | Commission Case | 34 | PERIOD_NO | Period Number | nvarchar | 6 | 0 | | |
33 | ZICMAG_DOCHD | Commission Document Header | 39 | PERIOD_NO | Period Number | nvarchar | 6 | 0 | | |
TOPTraders and Schedulers Workbench |
34 | OIJ_PLBUCKPROF | Oil-TSW: Planning Buckets Profile | 4 | PERIOD_NO | Oil-TSW: Number of Periods | nvarchar | 2 | 0 | | |