| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdministration |
1 | AAD1 | Administration Extension-Log | 36 | SnapShotId | Snapshot ID | Int | 11 | 0 | 0 | |
2 | AADM | Administration - Log | 334 | SnapShotId | Snapshot ID | Int | 11 | 0 | 0 | |
3 | AADP | Print Preferences | 31 | SnapShotId | Snapshot ID | Int | 11 | 0 | 0 | |
4 | ADM1 | Administration Extension | 36 | SnapShotId | Snapshot ID | Int | 11 | 0 | 0 | |
5 | AINF | Company Info | 189 | SnapShotId | Snapshot ID | Int | 11 | 0 | 0 | |
6 | AUSR | Archive Users - History | 90 | SnapShotId | Snapshot ID | Int | 11 | 0 | 0 | |
7 | CINF | Company Info | 189 | SnapShotId | Snapshot ID | Int | 11 | 0 | 0 | |
8 | OADM | Administration | 334 | SnapShotId | Snapshot ID | Int | 11 | 0 | 0 | |
9 | OADP | Print Preferences | 31 | SnapShotId | Snapshot ID | Int | 11 | 0 | 0 | |
10 | OUSR | Users | 90 | SnapShotId | Snapshot ID | Int | 11 | 0 | 0 | |
TOPFinance |
11 | AAC1 | Asset Classes - Depreciation Areas - History | 9 | SnapshotId | Snapshot ID | Int | 11 | 0 | 0 | |
12 | AACP | Periods Category-Log | 141 | SnapShotId | Snapshot ID | Int | 11 | 0 | 0 | |
13 | AACS | Asset Classes - History | 14 | SnapshotId | Snapshot ID | Int | 11 | 0 | 0 | |
14 | AACT | G/L Account - History | 104 | SnapShotId | Snapshot ID | Int | 11 | 0 | 0 | |
15 | AADT | Fixed Assets Account Determination - History | 27 | SnapshotId | Snapshot ID | Int | 11 | 0 | 0 | |
16 | ACS1 | Asset Classes - Depreciation Areas | 9 | SnapshotId | Snapshot ID | Int | 11 | 0 | 0 | |
17 | ADPA | Fixed Asset Depreciation Areas - History | 17 | SnapshotId | Snapshot ID | Int | 11 | 0 | 0 | |
18 | ADT1 | Depreciation Types - Rows - History | 8 | SnapshotId | Snapshot ID | Int | 11 | 0 | 0 | |
19 | ADTP | Fixed Assets Depreciation Types - History | 46 | SnapshotId | Snapshot ID | Int | 11 | 0 | 0 | |
20 | DTP1 | Depreciation Types - Rows | 8 | SnapshotId | Snapshot ID | Int | 11 | 0 | 0 | |
21 | FAA1 | Asset Attributes - Rows | 8 | SnapshotId | Snapshot ID | Int | 11 | 0 | 0 | |
22 | OACP | Periods Category | 141 | SnapShotId | Snapshot ID | Int | 11 | 0 | 0 | |
23 | OACS | Asset Classes | 14 | SnapshotId | Snapshot ID | Int | 11 | 0 | 0 | |
24 | OACT | G/L Accounts | 104 | SnapShotId | Snapshot ID | Int | 11 | 0 | 0 | |
25 | OADT | Fixed Assets Account Determination | 27 | SnapshotId | Snapshot ID | Int | 11 | 0 | 0 | |
26 | ODPA | Fixed Asset Depreciation Areas | 17 | SnapshotId | Snapshot ID | Int | 11 | 0 | 0 | |
27 | ODTP | Fixed Assets Depreciation Types | 46 | SnapshotId | Snapshot ID | Int | 11 | 0 | 0 | |
28 | OFAA | Asset Attributes | 10 | SnapshotId | Snapshot ID | Int | 11 | 0 | 0 | |