| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdministration |
1 | APJ2 | Project Plan Steps Time Record | 7 | Remarks | Remarks | nVarChar | 254 | 0 | | |
2 | DAR1 | Data Archive - Transaction Log | 9 | Remarks | Remarks | nVarChar | 100 | 0 | | |
3 | DAR2 | Data Archive - Transaction Log | 13 | Remarks | Remarks | nVarChar | 50 | 0 | | |
4 | OWST | Confirmation Level | 3 | Remarks | Description | nVarChar | 100 | 0 | | |
5 | OWTM | Approval Templates | 3 | Remarks | Description | nVarChar | 100 | 0 | | |
6 | PJT2 | Project Plan Steps Time Record | 7 | Remarks | Remarks | nVarChar | 254 | 0 | | |
7 | WTM2 | Confirmation Templates - Stages | 4 | Remarks | Description | nVarChar | 100 | 0 | | |
TOPBanking |
8 | OUBR | Branches | 3 | Remarks | Description | nVarChar | 100 | 0 | | |
9 | OUDP | Departments | 3 | Remarks | Description | nVarChar | 100 | 0 | | |
TOPBusiness Partners |
10 | ACPN | Campaign | 9 | Remarks | Campaign Remarks | Text | 16 | 0 | | |
11 | AOAT | Blanket Agreement | 16 | Remarks | Remarks | Text | 16 | 0 | | |
12 | OCPN | Campaign | 9 | Remarks | Campaign Remarks | Text | 16 | 0 | | |
13 | OOAT | Blanket Agreement | 16 | Remarks | Remarks | Text | 16 | 0 | | |
TOPFinance |
14 | ACD1 | Credit Memo - Rows | 10 | Remarks | Remarks | nVarChar | 100 | 0 | | |
15 | ACQ1 | Capitalization - Rows | 10 | Remarks | Remarks | nVarChar | 100 | 0 | | |
16 | AFA1 | Asset Document - Rows | 10 | Remarks | Remarks | nVarChar | 100 | 0 | | |
17 | FAR1 | Fixed Asset Revaluation - Rows | 6 | Remarks | Remarks | nVarChar | 100 | 0 | | |
18 | FTR1 | Transfer - Rows | 10 | Remarks | Remarks | nVarChar | 100 | 0 | | |
19 | ISW3 | Declaration Rows | 74 | Remarks | Remarks | nVarChar | 250 | 0 | | |
20 | MDP1 | Manual Depreciation - Rows | 10 | Remarks | Remarks | nVarChar | 100 | 0 | | |
21 | OBTD | Journal Vouchers List | 10 | Remarks | Journal Voucher Remarks Field | nVarChar | 50 | 0 | | |
22 | ODRN | Depreciation Run | 11 | Remarks | Remarks | nVarChar | 32 | 0 | | |
23 | OFAM | Fixed Asset Data Migration | 12 | Remarks | Remarks | nVarChar | 254 | 0 | | |
24 | RTI1 | Retirement - Rows | 10 | Remarks | Remarks | nVarChar | 100 | 0 | | |
25 | VRW2 | VAT Reposting Wizard - Rows 2 | 14 | Remarks | Remarks | nVarChar | 50 | 0 | | |
TOPGeneral |
26 | ARSC6 | Resources - Daily Capacities - Log | 8 | Remarks | Remarks | nVarChar | 100 | 0 | | |
27 | OFNS | Folio Numbering - Series | 10 | Remarks | Remarks | nVarChar | 100 | 0 | | |
28 | OGPA | Gross Profit Adjustment | 6 | Remarks | Description | nVarChar | 254 | 0 | | |
29 | OPTI | Point of Issue | 6 | Remarks | Remarks | nVarChar | 100 | 0 | | |
30 | RDMS | Dictionary Master | 4 | Remarks | Remarks | nVarChar | 250 | 0 | | |
31 | RINF | Resource Info | 2 | Remarks | Remarks | nVarChar | 254 | 0 | | |
32 | RSC6 | Resources - Daily Capacities | 8 | Remarks | Remarks | nVarChar | 100 | 0 | | |
TOPHuman Resources |
33 | AHE3 | Employee Reviews | 7 | remarks | Reviews | Text | 16 | 0 | | |
34 | AHE4 | Previous Employment | 7 | remarks | Previous Employment | Text | 16 | 0 | | |
35 | HEM3 | Employee Reviews | 7 | remarks | Reviews | Text | 16 | 0 | | |
36 | HEM4 | Previous Employment | 7 | remarks | Previous Employment | Text | 16 | 0 | | |
TOPInventory and Production |
37 | AINC | Inventory Counting | 13 | Remarks | Remarks | Text | 16 | 0 | | |
38 | APKL | Pick List - History | 6 | Remarks | Remarks | Text | 16 | 0 | | |
39 | OALI | Alternative Items 2 | 4 | Remarks | Item Remarks | nVarChar | 50 | 0 | | |
40 | OICD | Inventory Counting Draft | 13 | Remarks | Remarks | Text | 16 | 0 | | |
41 | OINC | Inventory Counting | 13 | Remarks | Remarks | Text | 16 | 0 | | |
42 | OPKL | Pick List | 6 | Remarks | Remarks | Text | 16 | 0 | | |
TOPMarketing Documents |
43 | ODWZ | Dunning Wizard | 36 | Remarks | Remarks | nVarChar | 254 | 0 | | |
44 | OGTI | GTS Invoice | 22 | Remarks | Remarks | nVarChar | 160 | 0 | | |
45 | OVRT | Tax Invoice Report | 16 | Remarks | Remarks | nVarChar | 254 | 0 | | |
46 | OWDD | Docs. for Confirmation | 9 | Remarks | Remarks | nVarChar | 100 | 0 | | |
47 | WDD1 | Documents for Approval - Authorizers | 5 | Remarks | Remarks | nVarChar | 100 | 0 | | |