| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdministration |
| 1 | AWLS | Workflow - Task Details | 7 | Operation | Operation | VarChar | 1 | 0 | | A=Add, D=Delete, U=Update |
| 2 | OWLS | Workflow - Task Details | 7 | Operation | Operation | VarChar | 1 | 0 | | A=Add, D=Delete, U=Update |
| TOPGeneral |
| 3 | APH4 | Project Management - Stages - Documents - History | 14 | Operation | Operation which we will apply to the amount from the total | VarChar | 1 | 0 | | A=Add, S=Subtract |
| 4 | APM4 | Project Management - Stages - Documents - History | 14 | Operation | Operation which we will apply to the amount from the total | VarChar | 1 | 0 | | A=Add, S=Subtract |
| 5 | EMMSG | EMMSG | 3 | Operation | Operation | nVarChar | 60 | 0 | | |
| 6 | ITMR | ITMR | 63 | Operation | Operation | Int | 6 | 0 | 0 | 10=Less, 11=LessEq, 12=Equally, 13=Not eq, 14=GrEq, 15=Greater, 16=$Len, 17=Left, 18=Right, 19=Round, 1=+, 20=$Currency, 21=$Number, 2=-, 3=x, 4=/, 5=%, 6=$Concat, 7=$Right, 8=$Left, 9=$Sentence |
| 7 | MLOG | MLOG | 6 | operation | | VarChar | 1 | 0 | | C=Create, D=Remove, U=Update |
| 8 | PHA4 | Project Management - Stages - Documents | 14 | Operation | Operation which we will apply to the amount from the total | VarChar | 1 | 0 | | A=Add, S=Subtract |
| 9 | PMG4 | Project Management - Stages - Documents | 14 | Operation | Operation which we will apply to the amount from the total | VarChar | 1 | 0 | | A=Add, S=Subtract |
| TOPReports |
| 10 | QWZ3 | Query Condition Fields | 6 | Operation | Operation | Int | 11 | 0 | | |
| 11 | RITM | Reporting Element | 63 | Operation | Operation | Int | 6 | 0 | 0 | 10=Less than, 11=Less or Equal, 12=Equal, 13=Not equal, 14=Greater or Equal, 15=Greater than, 16=$Length, 17=Left Part (Characters), 18=Right Part (Mantissa), 19=Round, 1=+, 20=$Currency, 21=$Number, 2=-, 3=x, 4=/, 5=%, 6=$Concat, 7=$Right, 8=$Left, 9=$Sentence |
