| 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 | Journal Entry Remarks | nVarChar | 50 | 0 | | |
TOPGeneral |
26 | APH2 | Project Management - Stages - Open Issues - History | 6 | REMARKS | Remarks | Text | 16 | 0 | | |
27 | APM2 | Project Management - Stages - Open Issues - History | 6 | REMARKS | Remarks | Text | 16 | 0 | | |
28 | ARSC6 | Resources - Daily Capacities - Log | 8 | Remarks | Remarks | nVarChar | 100 | 0 | | |
29 | OFNS | Folio Numbering - Series | 10 | Remarks | Remarks | nVarChar | 100 | 0 | | |
30 | OGPA | Gross Profit Adjustment | 6 | Remarks | Description | nVarChar | 254 | 0 | | |
31 | OPCM | POS/Cash Register | 7 | Remarks | Remarks | nVarChar | 250 | 0 | | |
32 | OPTI | Point of Issue | 6 | Remarks | Remarks | nVarChar | 100 | 0 | | |
33 | PHA2 | Project Management - Stages - Open Issues | 6 | REMARKS | Remarks | Text | 16 | 0 | | |
34 | PMG2 | Project Management - Stages - Open Issues | 6 | REMARKS | Remarks | Text | 16 | 0 | | |
35 | RDMS | Dictionary Master | 4 | Remarks | Remarks | nVarChar | 250 | 0 | | |
36 | RINF | Resource Info | 2 | Remarks | Remarks | nVarChar | 254 | 0 | | |
37 | RSC6 | Resources - Daily Capacities | 8 | Remarks | Remarks | nVarChar | 100 | 0 | | |
TOPHuman Resources |
38 | AHE3 | Employee Reviews | 7 | remarks | Reviews | Text | 16 | 0 | | |
39 | AHE4 | Previous Employment | 7 | remarks | Previous Employment | Text | 16 | 0 | | |
40 | HEM3 | Employee Reviews | 7 | remarks | Reviews | Text | 16 | 0 | | |
41 | HEM4 | Previous Employment | 7 | remarks | Previous Employment | Text | 16 | 0 | | |
TOPInventory and Production |
42 | AINC | Inventory Counting | 13 | Remarks | Remarks | Text | 16 | 0 | | |
43 | APKL | Pick List - History | 6 | Remarks | Remarks | Text | 16 | 0 | | |
44 | OALI | Alternative Items 2 | 4 | Remarks | Item Remarks | nVarChar | 50 | 0 | | |
45 | OICD | Inventory Counting Draft | 13 | Remarks | Remarks | Text | 16 | 0 | | |
46 | OINC | Inventory Counting | 13 | Remarks | Remarks | Text | 16 | 0 | | |
47 | OPKL | Pick List | 6 | Remarks | Remarks | Text | 16 | 0 | | |
TOPMarketing Documents |
48 | ADO23 | A/P Invoice - Selected Asset Master Data | 5 | Remarks | Remarks | nVarChar | 100 | 0 | | |
49 | CIN23 | A/P Invoice - Selected Asset Master Data | 5 | Remarks | Remarks | nVarChar | 100 | 0 | | |
50 | CPI23 | A/P Invoice - Selected Asset Master Data | 5 | Remarks | Remarks | nVarChar | 100 | 0 | | |
51 | CPV23 | A/P Invoice - Selected Asset Master Data | 5 | Remarks | Remarks | nVarChar | 100 | 0 | | |
52 | CSI23 | A/P Invoice - Selected Asset Master Data | 5 | Remarks | Remarks | nVarChar | 100 | 0 | | |
53 | CSV23 | A/P Invoice - Selected Asset Master Data | 5 | Remarks | Remarks | nVarChar | 100 | 0 | | |
54 | DLN23 | A/P Invoice - Selected Asset Master Data | 5 | Remarks | Remarks | nVarChar | 100 | 0 | | |
55 | DOC23 | A/P Invoice - Selected Asset Master Data | 5 | Remarks | Remarks | nVarChar | 100 | 0 | | |
56 | DPI23 | A/P Invoice - Selected Asset Master Data | 5 | Remarks | Remarks | nVarChar | 100 | 0 | | |
57 | DPO23 | A/P Invoice - Selected Asset Master Data | 5 | Remarks | Remarks | nVarChar | 100 | 0 | | |
58 | DRF23 | A/P Invoice - Selected Asset Master Data | 5 | Remarks | Remarks | nVarChar | 100 | 0 | | |
59 | IEI23 | A/P Invoice - Selected Asset Master Data | 5 | Remarks | Remarks | nVarChar | 100 | 0 | | |
60 | IGE23 | A/P Invoice - Selected Asset Master Data | 5 | Remarks | Remarks | nVarChar | 100 | 0 | | |
61 | IGN23 | A/P Invoice - Selected Asset Master Data | 5 | Remarks | Remarks | nVarChar | 100 | 0 | | |
62 | INV23 | A/P Invoice - Selected Asset Master Data | 5 | Remarks | Remarks | nVarChar | 100 | 0 | | |
63 | ODWZ | Dunning Wizard | 36 | Remarks | Remarks | nVarChar | 254 | 0 | | |
64 | OEI23 | A/P Invoice - Selected Asset Master Data | 5 | Remarks | Remarks | nVarChar | 100 | 0 | | |
65 | OGTI | GTS Invoice | 22 | Remarks | Remarks | nVarChar | 160 | 0 | | |
66 | OVRT | Tax Invoice Report | 16 | Remarks | Remarks | nVarChar | 254 | 0 | | |
67 | OWDD | Docs. for Confirmation | 9 | Remarks | Remarks | nVarChar | 254 | 0 | | |
68 | PCH23 | A/P Invoice - Selected Asset Master Data | 5 | Remarks | Remarks | nVarChar | 100 | 0 | | |
69 | PDN23 | A/P Invoice - Selected Asset Master Data | 5 | Remarks | Remarks | nVarChar | 100 | 0 | | |
70 | POR23 | A/P Invoice - Selected Asset Master Data | 5 | Remarks | Remarks | nVarChar | 100 | 0 | | |
71 | PQT23 | A/P Invoice - Selected Asset Master Data | 5 | Remarks | Remarks | nVarChar | 100 | 0 | | |
72 | PRQ23 | A/P Invoice - Selected Asset Master Data | 5 | Remarks | Remarks | nVarChar | 100 | 0 | | |
73 | PRR23 | A/P Return Request - Selected Asset Master Data | 5 | Remarks | Remarks | nVarChar | 100 | 0 | | |
74 | QUT23 | A/P Invoice - Selected Asset Master Data | 5 | Remarks | Remarks | nVarChar | 100 | 0 | | |
75 | RDN23 | A/P Invoice - Selected Asset Master Data | 5 | Remarks | Remarks | nVarChar | 100 | 0 | | |
76 | RDR23 | A/P Invoice - Selected Asset Master Data | 5 | Remarks | Remarks | nVarChar | 100 | 0 | | |
77 | RIN23 | A/P Invoice - Selected Asset Master Data | 5 | Remarks | Remarks | nVarChar | 100 | 0 | | |
78 | RPC23 | A/P Invoice - Selected Asset Master Data | 5 | Remarks | Remarks | nVarChar | 100 | 0 | | |
79 | RPD23 | A/P Invoice - Selected Asset Master Data | 5 | Remarks | Remarks | nVarChar | 100 | 0 | | |
80 | RRR23 | A/R Return Request - Selected Asset Master Data | 5 | Remarks | Remarks | nVarChar | 100 | 0 | | |
81 | SFC23 | A/P Invoice - Selected Asset Master Data | 5 | Remarks | Remarks | nVarChar | 100 | 0 | | |
82 | SFI23 | Self Invoice - Selected Asset Master Data | 5 | Remarks | Remarks | nVarChar | 100 | 0 | | |
83 | WDD1 | Documents for Approval - Authorizers | 5 | Remarks | Remarks | nVarChar | 254 | 0 | | |
84 | WTQ23 | A/P Invoice - Selected Asset Master Data | 5 | Remarks | Remarks | nVarChar | 100 | 0 | | |
85 | WTR23 | A/P Invoice - Selected Asset Master Data | 5 | Remarks | Remarks | nVarChar | 100 | 0 | | |