| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdministration |
1 | CUFD | User Fields - Description | 14 | Action | Action | VarChar | 1 | 0 | | |
2 | DAR2 | Data Archive - Transaction Log | 12 | Action | Action | VarChar | 1 | 0 | T | L=Locked, R=Remove, T=Temporary |
3 | MDC1 | Master Data Cleanup - Log | 7 | Action | Action | VarChar | 1 | 0 | | D=Deactivate, R=Remove |
4 | OUKD | User Key Description | 5 | Action | Action | VarChar | 1 | 0 | N | A=Add, D=Delete, N=None, U=Update |
5 | OUPT | User Autorization Tree | 8 | Action | Action | Int | 6 | 0 | | |
6 | USR5 | User Access Log | 2 | Action | Performed Action | VarChar | 1 | 0 | | C=Created, D=Superuser Deselected, F=Logon Failed, I=Logon Succeeded, L=Locked, N=Screen Unlock Failed, O=Logoff, P=Password Changed, R=Removed, S=Superuser Selected, T=Temporary User Change, U=Unlocked |
TOPBusiness Partners |
7 | ACLG | Activities - History | 23 | Action | Activity | VarChar | 1 | 0 | C | C=Phone Call, E=Note, M=Meeting, N=Other, P=Campaign, T=Task |
8 | OCLG | Activities | 23 | Action | Activity | VarChar | 1 | 0 | C | C=Phone Call, E=Note, M=Meeting, N=Other, P=Campaign, T=Task |
TOPGeneral |
9 | OREA | Return Action | 2 | Action | Return Action | nVarChar | 228 | 0 | | |
10 | OWWT | Workbench | 4 | Action | Workbench Actions | Text | 16 | 0 | | |
TOPInventory and Production |
11 | OIMT | Templates for Inventory JE | 6 | Action | Action Type | Int | 6 | 0 | 0 | |
TOPReports |
12 | OGDP | General Data Protection Wizard | 11 | Action | Personal Data Management Wizard Action | VarChar | 1 | 0 | R | B=Personal Data Blocking, E=Personal Data Cleanup, I=Determine Natural Persons, N=Reverse Natural Person Determination, R=Personal Data Report, U=Personal Data Unblocking |