| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdministration |
| 1 | AWEX | Workflow Engine Execution Entity | 7 | ParentId | Parent ID | Int | 11 | 0 | | |
| 2 | OWEX | Workflow Engine Execution Entity | 6 | ParentId | Parent ID | Int | 11 | 0 | | |
| TOPBusiness Partners |
| 3 | OCLG | Activities | 52 | parentId | Parent Object ID | Int | 11 | 0 | | |
| TOPFinance |
| 4 | OSCM | Special Ledger - Analytical Accounting Configuration Rules: Material | 3 | ParentID | Parent Rule ID | Int | 6 | 0 | | |
| 5 | OSCR | Special Ledger - Analytical Accounting Configuration Rules: Revenues & Expenses | 3 | ParentID | Parent Rule ID | Int | 6 | 0 | | |
| TOPInventory and Production |
| 6 | OIVE | FIFO Based Sales Return | 2 | ParentID | Parent ID | Int | 11 | 0 | -1 | |
| 7 | OIVL | Whse Journal | 68 | ParentID | Parent ID | Int | 11 | 0 | -1 | |
| 8 | OIVQ | FIFO Queue Working Table | 2 | ParentID | Parent ID | Int | 11 | 0 | -1 | |
| 9 | SIVE | FIFO Based Sales Return | 2 | ParentID | Parent ID | Int | 11 | 0 | -1 | |
| 10 | SIVL | Whse Journal | 68 | ParentID | Parent ID | Int | 11 | 0 | -1 | |
| 11 | SIVQ | FIFO Queue Working Table | 2 | ParentID | Parent ID | Int | 11 | 0 | -1 | |
| 12 | UIVE | FIFO Based Sales Return | 2 | ParentID | Parent ID | Int | 11 | 0 | -1 | |
| 13 | UIVL | Whse Journal | 68 | ParentID | Parent ID | Int | 11 | 0 | -1 | |
| 14 | UIVQ | FIFO Queue Working Table | 2 | ParentID | Parent ID | Int | 11 | 0 | -1 | |
| TOPMarketing Documents |
| 15 | DWZ4 | Dunning Wizard Array 4-Paging Grid | 46 | ParentId | Parent Id | Int | 11 | 0 | | |
| TOPReports |
| 16 | XRREL | XLR Company Report Objects | 1 | ParentId | ParentId | nVarChar | 38 | 0 | | |
