| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /PICM/D_I_FILTER | Save Filter variant | 4 | FILTERID | Character String - 16 User-Defined Characters | nvarchar | 16 | 0 | | |
TOPIncentive and Commission Management ICM |
2 | CACS_CTRTBU | Commission Contract | 34 | FILTERID | Identification of an Activity Filter | nvarchar | 8 | 0 | | |
3 | TCACS_ASSGN2 | Assignment Table - Contract Type <-> Activity Filter | 4 | FILTERID | Filter Identification | nvarchar | 8 | 0 | | |
4 | TCACS_FILTER0 | Commission System Filter | 3 | FILTERID | Filter Identification | nvarchar | 8 | 0 | | |
5 | TCACS_FILTER0_T | Commission System Filter | 4 | FILTERID | Filter Identification | nvarchar | 8 | 0 | | |
6 | TCACS_FILTER1 | Commission System Filter | 3 | FILTERID | Filter Identification | nvarchar | 8 | 0 | | |
7 | TCACS_FILTER10 | Filter: Std Agreements of Performance-Related Remunerations | 3 | FILTERID | Filter Identification | nvarchar | 8 | 0 | | |
8 | TCACS_FILTER11 | Filter: Remuneration Types | 3 | FILTERID | Filter Identification | nvarchar | 8 | 0 | | |
9 | TCACS_FILTER20 | Filter: Activity Types | 3 | FILTERID | Filter Identification | nvarchar | 8 | 0 | | |
TOPLow Level Layer |
10 | TST21 | Memory for Used Trace Filter Settings | 3 | FILTERID | Filter setting ID (SysLog, Trace,...) | nvarchar | 20 | 0 | | |
TOPMedia Product Sales and Distribution |
11 | TJVSDSHPFILTER | Filters in Shipping Plan | 2 | FILTERID | Filter for Shipping Plan | nvarchar | 3 | 0 | | |
12 | TJVSDSHPFILTERT | Filters in Shipping Plan - Texts | 2 | FILTERID | Filter for Shipping Plan | nvarchar | 3 | 0 | | |
13 | TJVSDSHPZFILTER | Assignment of Filters to Filter Groups in Shipping Plan | 3 | FILTERID | Filter for Shipping Plan | nvarchar | 3 | 0 | | |
TOPSAP System Log |
14 | TSL5D | System Log Filter Settings Used | 3 | FILTERID | Filter setting ID (SysLog, Trace,...) | nvarchar | 20 | 0 | | |