| 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 | ACLG | Activities - History | 52 | parentId | Parent Object ID | Int | 11 | 0 | | |
4 | OCLG | Activities | 52 | parentId | Parent Object ID | Int | 11 | 0 | | |
TOPFinance |
5 | OSCM | Special Ledger - Analytical Accounting Configuration Rules: Material | 3 | ParentID | Parent Rule ID | Int | 6 | 0 | | |
6 | OSCR | Special Ledger - Analytical Accounting Configuration Rules: Revenues & Expenses | 3 | ParentID | Parent Rule ID | Int | 6 | 0 | | |
TOPGeneral |
7 | APHA | Project Management Subproject - History | 6 | ParentID | Parent Subproject | Int | 11 | 0 | | |
8 | OPHA | Project Management Subproject | 6 | ParentID | Parent Subproject | Int | 11 | 0 | | |
TOPInventory and Production |
9 | OIVE | FIFO Based Sales Return | 2 | ParentID | Parent ID | Int | 11 | 0 | -1 | |
10 | OIVL | Whse Journal | 68 | ParentID | Parent ID | Int | 11 | 0 | -1 | |
11 | OIVQ | FIFO Queue Working Table | 2 | ParentID | Parent ID | Int | 11 | 0 | -1 | |
12 | SIVE | FIFO Based Sales Return | 2 | ParentID | Parent ID | Int | 11 | 0 | -1 | |
13 | SIVL | Whse Journal | 68 | ParentID | Parent ID | Int | 11 | 0 | -1 | |
14 | SIVQ | FIFO Queue Working Table | 2 | ParentID | Parent ID | Int | 11 | 0 | -1 | |
15 | UIVE | FIFO Based Sales Return | 2 | ParentID | Parent ID | Int | 11 | 0 | -1 | |
16 | UIVL | Whse Journal | 68 | ParentID | Parent ID | Int | 11 | 0 | -1 | |
17 | UIVQ | FIFO Queue Working Table | 2 | ParentID | Parent ID | Int | 11 | 0 | -1 | |
TOPMarketing Documents |
18 | DWZ4 | Dunning Wizard Array 4-Paging Grid | 46 | ParentId | Parent Id | Int | 11 | 0 | | |
TOPReports |
19 | AEC2 | Electronic Transactions | 3 | ParentID | Parent ID | Int | 11 | 0 | | |
20 | ECM2 | Electronic Transactions | 3 | ParentID | Parent ID | Int | 11 | 0 | | |
21 | OIRC | Interactive Report Category | 2 | ParentId | Parent Category Id | Int | 11 | 0 | -1 | |
22 | XRREL | XLR Company Report Objects | 1 | ParentId | ParentId | nVarChar | 38 | 0 | | |