Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
---|---|---|---|---|---|---|---|---|---|---|
Administration | ||||||||||
1 | ODAR | Data Archiving | 5 | CreateTime | Archive Time | Int | 6 | 0 | ||
Banking | ||||||||||
2 | OITR | Internal Reconciliation | 13 | CreateTime | Creation Time | Int | 6 | 0 | ||
Finance | ||||||||||
3 | AJDT | Journal Entry - History | 47 | CreateTime | Generation Time | Int | 6 | 0 | ||
4 | CASE | Internal Recon. Upgrade 2007A | 3 | CreateTime | Creation Time | Int | 6 | 0 | ||
5 | OBTF | Journal Voucher Entry | 47 | CreateTime | Generation Time | Int | 6 | 0 | ||
6 | OJDT | Journal Entry | 47 | CreateTime | Generation Time | Int | 6 | 0 | ||
7 | OJST | TDS Adjustment | 9 | CreateTime | Generation Time | Int | 11 | 0 | ||
Inventory and Production | ||||||||||
8 | OAIM | Archive Inventory Message | 23 | CreateTime | Generation Time | Int | 6 | 0 | ||
9 | OILM | Inventory Log Message | 32 | CreateTime | Generation Time | Int | 6 | 0 | ||
10 | OIVL | Whse Journal | 6 | CreateTime | Generation Time | Int | 6 | 0 | ||
11 | UILM | IVI Inventory Log Message | 32 | CreateTime | Generation Time | Int | 6 | 0 | ||
12 | UIVL | Whse Journal | 6 | CreateTime | Generation Time | Int | 6 | 0 | ||
Marketing Documents | ||||||||||
13 | OWDD | Docs. for Confirmation | 12 | CreateTime | Production Time | Int | 6 | 0 | ||
14 | WDD1 | Documents for Approval - Authorizers | 8 | CreateTime | Request Time | Int | 6 | 0 | ||
Reports | ||||||||||
15 | OLLR | Electronic Report Generation Result | 4 | CreateTime | Creation Time | Int | 6 | 0 | ||
Service | ||||||||||
16 | ASCL | History | 28 | createTime | Creation Time | Int | 6 | 0 | ||
17 | OREQ | External System Call Request | 5 | CreateTime | Request Creation Time | Int | 11 | 0 | ||
18 | OSCL | Service Calls | 28 | createTime | Creation Time | Int | 6 | 0 | ||
19 | QUE2 | Queue Elements | 7 | createTime | Creation Time | Int | 6 | 0 |