| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdministration |
| 1 | CPL1 | Quick Copy - Instance Log | 6 | MessageId | Message ID | nVarChar | 20 | 0 | | |
| TOPGeneral |
| 2 | EMSTT | EMSTT | 1 | MessageID | Message ID | nVarChar | 60 | 0 | | |
| 3 | UXILM | IVI Irrelevant Message IDs | 1 | MessageID | Message ID | Int | 11 | 0 | | |
| TOPInventory and Production |
| 4 | ILM1 | Srl & Batch Det of Inv Log Msg | 1 | MessageID | Message ID | Int | 11 | 0 | | |
| 5 | ILM2 | Inventory Account Substitute | 1 | MessageID | Message ID | Int | 11 | 0 | | |
| 6 | ILM3 | Non-Inventory and Resource Components Log Msg | 1 | MessageID | Message ID | Int | 11 | 0 | | |
| 7 | IVL2 | Inventory Components for Production | 2 | MessageID | Message ID | Int | 11 | 0 | | |
| 8 | OAIM | Archive Inventory Message | 1 | MessageID | Message ID | Int | 11 | 0 | | |
| 9 | OBTL | Bin Transaction Log | 2 | MessageID | ILM Message ID | Int | 11 | 0 | | |
| 10 | OILM | Inventory Log Message | 1 | MessageID | Message ID | Int | 11 | 0 | | |
| 11 | OIVL | Whse Journal | 58 | MessageID | Message ID | Int | 11 | 0 | | |
| 12 | SIVL | Whse Journal | 58 | MessageID | Message ID | Int | 11 | 0 | | |
| 13 | SIVL2 | Inventory Components for Production | 2 | MessageID | Message ID | Int | 11 | 0 | | |
| 14 | UILM | IVI Inventory Log Message | 1 | MessageID | Message ID | Int | 11 | 0 | | |
| 15 | UILM1 | Srl & Batch Det of Inv Log Msg | 1 | MessageID | Message ID | Int | 11 | 0 | | |
| 16 | UILM2 | Inventory Account Substitute | 1 | MessageID | Message ID | Int | 11 | 0 | | |
| 17 | UILM3 | Non-Inventory and Resource Components Log Msg | 1 | MessageID | Message ID | Int | 11 | 0 | | |
| 18 | UIVL | Whse Journal | 58 | MessageID | Message ID | Int | 11 | 0 | | |
| 19 | UIVL2 | Inventory Components for Production | 2 | MessageID | Message ID | Int | 11 | 0 | | |
