| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPCollectionsDisbursements |
1 | TKKVIACT | Processing Contracts w. Acct Bal. Int. Calc. - Activities | 4 | ACKEY | Activity | nvarchar | 4 | 0 | | |
2 | TKKVIACTDEF | Processing IO w. Acct Bal. Int. Calc. - Activity Definition | 2 | ACKEY | Activity | nvarchar | 4 | 0 | | |
3 | TKKVIACTDEFT | Curr. Chge Acct Bal. Int. Calc. - Def. of Activities (Texts) | 3 | ACKEY | Activity | nvarchar | 4 | 0 | | |
4 | TVS010I | IS-IS Scheduling: Assignment of Activities to Posting Event | 5 | ACKEY | Activity With Payment Plan Posting | nvarchar | 4 | 0 | | |
5 | TVS010J | IS-IS Scheduling: Assignment of Activities to Change Event | 6 | ACKEY | Activity When Changing a Payment Plan Item | nvarchar | 4 | 0 | | |
6 | TVS020D | IS-IS Scheduling: Activities for Paymt Plan Change | 6 | ACKEY | Activity | nvarchar | 4 | 0 | | |
7 | TVS030A | IS-IS Scheduling: Activity Definition for Paymt Plan Change | 2 | ACKEY | Activity | nvarchar | 4 | 0 | | |
8 | TVS030AT | IS-IS Scheduling: Activity Definition for Paymt Plan Change | 3 | ACKEY | Activity | nvarchar | 4 | 0 | | |
9 | TVS030C | IS-IS Scheduling: Activity Def. Payment Plan Posting Events | 2 | ACKEY | Activity With Payment Plan Posting | nvarchar | 4 | 0 | | |
10 | TVS030CT | IS-IS Scheduling: Activity Def. Payment Plan Posting Events | 3 | ACKEY | Activity With Payment Plan Posting | nvarchar | 4 | 0 | | |
11 | TVS030E | IS-IS Scheduling: Activity Def. Payment Plan Change Events | 2 | ACKEY | Activity When Changing a Payment Plan Item | nvarchar | 4 | 0 | | |
12 | TVS030ET | IS-IS Scheduling: Activity Def. Payment Plan Change Events | 3 | ACKEY | Activity When Changing a Payment Plan Item | nvarchar | 4 | 0 | | |
TOPContract Accounts Receivable and Payable |
13 | DFKKCOMAKT | Correspondence Dunning Activities | 6 | ACKEY | Activity | nvarchar | 4 | 0 | | |
14 | DFKKWLI | Work Items | 22 | ACKEY | Activity | nvarchar | 4 | 0 | | |
15 | DFKKWLIA | Work Items (Work Item Type) | 22 | ACKEY | Activity | nvarchar | 4 | 0 | | |
16 | FKKMACTIVITIES | Dunning Activities | 8 | ACKEY | Activity | nvarchar | 4 | 0 | | |
17 | TFK047L | FI-CA Dunning: Definition of dunning activities | 2 | ACKEY | Activity | nvarchar | 4 | 0 | | |
18 | TFK047LT | FI-CA Dunning: Definition of dunning activities (texts) | 3 | ACKEY | Activity | nvarchar | 4 | 0 | | |
19 | TFK047M | FI-CA Dunning: Dunning Activities | 8 | ACKEY | Activity | nvarchar | 4 | 0 | | |
20 | TFK047V | FI-CA Dunning: Dunning Activities | 4 | ACKEY | Activity | nvarchar | 4 | 0 | | |
21 | TFK052A | Collection Work Item: Customizing | 2 | ACKEY | Activity | nvarchar | 4 | 0 | | |
22 | TFKCMCAP | Capacity Restriction for Dunning Activities (Customizing) | 2 | ACKEY | Activity | nvarchar | 4 | 0 | | |
TOPInternal Collection Procedure |
23 | UHC_CASE_ALIST | Actions in Collection Case | 4 | ACKEY | Technical Key for the Action | nvarchar | 4 | 0 | | |
24 | UHC_T001 | Actions - Definition of Actions | 2 | ACKEY | Technical Key for the Action | nvarchar | 4 | 0 | | |
25 | UHC_T001_A | Prerequisite Actions | 2 | ACKEY | Technical Key for the Action | nvarchar | 4 | 0 | | |
26 | UHC_T001_B | Do Not Execute Action - Prerequisite Case Status | 2 | ACKEY | Technical Key for the Action | nvarchar | 4 | 0 | | |
27 | UHC_T001_T | Actions - Definition of Actions (Texts) | 3 | ACKEY | Technical Key for the Action | nvarchar | 4 | 0 | | |
28 | UHC_T002_B | Actions in Action List | 4 | ACKEY | Technical Key for the Action | nvarchar | 4 | 0 | | |
TOPLease Accounting |
29 | /LSIERP/WLI | Work Items | 8 | ACKEY | Activity | nvarchar | 4 | 0 | | |
TOPSAP Utilities |
30 | TEAMI_DUNN_MTMPL | Assignment of AMI message templates to dunning activity | 2 | ACKEY | Activity | nvarchar | 4 | 0 | | |
TOPSweden |
31 | T5S0C | Absence conditions - SE | 5 | ACKEY | Absence condition key | nvarchar | 1 | 0 | | |