| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdministration |
1 | ODAR | Data Archiving | 5 | CreateTime | Archive Time | Int | 6 | 0 | | |
2 | OWPK | Dashboard Packages | 9 | CreateTime | Create Time | Int | 6 | 0 | | |
TOPBanking |
3 | OITR | Internal Reconciliation | 13 | CreateTime | Creation Time | Int | 6 | 0 | | |
TOPFinance |
4 | AJDT | Journal Entry - History | 47 | CreateTime | Generation Time | Int | 6 | 0 | | |
5 | CASE | Internal Recon. Upgrade 2007A | 3 | CreateTime | Creation Time | Int | 6 | 0 | | |
6 | OBTF | Journal Voucher Entry | 47 | CreateTime | Generation Time | Int | 6 | 0 | | |
7 | OJDT | Journal Entry | 47 | CreateTime | Generation Time | Int | 6 | 0 | | |
8 | OJST | TDS Adjustment | 9 | CreateTime | Generation Time | Int | 11 | 0 | | |
TOPInventory and Production |
9 | OAIM | Archive Inventory Message | 23 | CreateTime | Generation Time | Int | 6 | 0 | | |
10 | OILM | Inventory Log Message | 32 | CreateTime | Generation Time | Int | 6 | 0 | | |
11 | OIVL | Whse Journal | 6 | CreateTime | Generation Time | Int | 6 | 0 | | |
12 | SIVL | Whse Journal | 6 | CreateTime | Generation Time | Int | 6 | 0 | | |
13 | UILM | IVI Inventory Log Message | 32 | CreateTime | Generation Time | Int | 6 | 0 | | |
14 | UIVL | Whse Journal | 6 | CreateTime | Generation Time | Int | 6 | 0 | | |
TOPMarketing Documents |
15 | ORCP | Recurring Transaction Template | 14 | CreateTime | Creation Time | Int | 6 | 0 | | |
16 | OWDD | Docs. for Confirmation | 12 | CreateTime | Production Time | Int | 6 | 0 | | |
17 | WDD1 | Documents for Approval - Authorizers | 8 | CreateTime | Request Time | Int | 6 | 0 | | |
TOPReports |
18 | OLLR | Electronic Report Generation Result | 4 | CreateTime | Creation Time | Int | 6 | 0 | | |
19 | RDC1 | Multilingual Report | 7 | CreateTime | Create Time | Int | 11 | 0 | | |
TOPService |
20 | ASCL | History | 28 | createTime | Creation Time | Int | 6 | 0 | | |
21 | OREQ | External System Call Request | 5 | CreateTime | Request Creation Time | Int | 11 | 0 | | |
22 | OSCL | Service Calls | 28 | createTime | Creation Time | Int | 6 | 0 | | |
23 | QUE2 | Queue Elements | 7 | createTime | Creation Time | Int | 6 | 0 | | |