| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPCustomer Contact |
1 | BPCT_CRM_CLASS | Display Contact Type/Class on CRM Activities | 7 | ACTIVITY_GUID | CRM GUID of Object | varbinary | 16 | 0 | | |
TOPE-Recruiting |
2 | T77RCF_TRANS_ACT | Data Transfer Activities Using XI Interface | 2 | ACTIVITY_GUID | Global Key for Activities | nvarchar | 32 | 0 | | |
TOPEmployee Interaction Center |
3 | THREIC_ACT_CONT | EIC: Linkage of Activity and Contact | 2 | ACTIVITY_GUID | EIC: GUID | nvarchar | 32 | 0 | | |
4 | THREIC_ACT_LOCK | EIC: Lock (Activities) | 2 | ACTIVITY_GUID | EIC: GUID | nvarchar | 32 | 0 | | |
5 | THREIC_ACT_LOG | EIC: Activity Log | 2 | ACTIVITY_GUID | EIC: GUID | nvarchar | 32 | 0 | | |
6 | THREIC_ACT_PROC | EIC: Related Processes of Activity | 4 | ACTIVITY_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
7 | THREIC_ACT_PR_VP | EIC: Processes Related to Activity (VP) | 4 | ACTIVITY_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
8 | THREIC_ASR_PROC | EIC: Related Processes of Activity | 2 | ACTIVITY_GUID | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |