| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdministration |
1 | CPL1 | Quick Copy - Instance Log | 4 | Instance | Instance Key | nVarChar | 254 | 0 | | |
2 | DAR1 | Data Archive - Transaction Log | 23 | Instance | Instance | Int | 6 | 0 | 0 | |
TOPBanking |
3 | ABOE | Bill of Exchange for Payment - History | 40 | Instance | Instance | Int | 6 | 0 | 0 | |
4 | ACHO | Checks for Payment - History | 41 | Instance | Instance | Int | 6 | 0 | 0 | |
5 | OBOE | Bill of Exchange for Payment | 40 | Instance | Instance | Int | 6 | 0 | 0 | |
6 | OCHD | Checks for Payment Drafts | 41 | Instance | Instance | Int | 6 | 0 | 0 | |
7 | OCHH | Check Register | 25 | Instance | Instance | Int | 6 | 0 | 0 | |
8 | OCHO | Checks for Payment | 41 | Instance | Instance | Int | 6 | 0 | 0 | |
9 | OCRH | Credit Card Management | 33 | Instance | Instance | Int | 6 | 0 | 0 | |
10 | OCRV | Credit Payments | 25 | Instance | Instance | Int | 6 | 0 | 0 | |
TOPBusiness Partners |
11 | ACLG | Activities - History | 40 | Instance | Instance | Int | 6 | 0 | 0 | |
12 | ACPN | Campaign | 21 | Instance | Instance | Int | 6 | 0 | 0 | |
13 | AOAT | Blanket Agreement | 42 | Instance | Instance | Int | 6 | 0 | 0 | |
14 | OCLG | Activities | 40 | Instance | Instance | Int | 6 | 0 | 0 | |
15 | OCPN | Campaign | 21 | Instance | Instance | Int | 6 | 0 | 0 | |
16 | OOAT | Blanket Agreement | 42 | Instance | Instance | Int | 6 | 0 | 0 | |
TOPFinance |
17 | BGT1 | Budget - Rows | 21 | Instance | Instance | Int | 11 | 0 | 1 | |
18 | BGT2 | Budget - Cost Accounting | 4 | Instance | Instance | Int | 11 | 0 | 1 | |
19 | BGT3 | Budget - Cost Accounting Rows | 4 | Instance | Instance | Int | 11 | 0 | 1 | |
20 | OBGT | Budget | 23 | Instance | Instance | Int | 11 | 0 | 1 | |
21 | ORCR | Recurring Postings | 18 | Instance | Instance | Int | 6 | 0 | 0 | |
22 | RCR1 | Recurring Postings - Rows | 8 | Instance | Instance | Int | 6 | 0 | | |
TOPGeneral |
23 | AHF1 | Hide Functions Configuration - Rows History | 13 | Instance | Instance | Int | 6 | 0 | 0 | |
24 | AHF2 | Hide Function Configuration - Rows History | 9 | Instance | Instance | Int | 6 | 0 | 0 | |
25 | AHFC | Hide Functions Configuration - History | 8 | Instance | Instance | Int | 6 | 0 | 0 | |
26 | HFC1 | Hide Function Configuration - Rows | 13 | Instance | Instance | Int | 6 | 0 | 0 | |
27 | HFC2 | Hide Function Configuration - Rows | 9 | Instance | Instance | Int | 6 | 0 | 0 | |
28 | OHFC | Hide Functions Configuration | 8 | Instance | Instance | Int | 6 | 0 | 0 | |
29 | SHQR | Upgrade queries history | 3 | Instance | Query instance | Int | 6 | 0 | | |
TOPInventory and Production |
30 | ABAT | Attribute - History | 7 | Instance | Instance | Int | 6 | 0 | 0 | |
31 | ABFC | Bin Field Configuration - History | 9 | Instance | Instance | Int | 6 | 0 | 0 | |
32 | ABIN | Bin Location - History | 47 | Instance | Instance | Int | 6 | 0 | 0 | |
33 | ABSL | Warehouse Sublevel - History | 8 | Instance | Instance | Int | 6 | 0 | 0 | |
34 | ABTN | Batch Numbers Master Data | 18 | Instance | Instance | Int | 6 | 0 | 0 | |
35 | ABTW | Batch Attributes in Location | 8 | Instance | Instance | Int | 6 | 0 | 0 | |
36 | ASRN | Serial Numbers Master Data | 18 | Instance | Instance | Int | 6 | 0 | 0 | |
37 | OBAT | Bin Location Attribute | 7 | Instance | Instance | Int | 6 | 0 | 0 | |
38 | OBFC | Bin Field Configuration | 9 | Instance | Instance | Int | 6 | 0 | 0 | |
39 | OBIN | Bin Location | 47 | Instance | Instance | Int | 6 | 0 | 0 | |
40 | OBSL | Warehouse Sublevel | 8 | Instance | Instance | Int | 6 | 0 | 0 | |
41 | OBTN | Batch Numbers Master Data | 18 | Instance | Instance | Int | 6 | 0 | 0 | |
42 | OBTW | Batch Attributes in Location | 8 | Instance | Instance | Int | 6 | 0 | 0 | |
43 | ODBN | Bat. Nos - Draft - Master Data | 18 | Instance | Instance | Int | 6 | 0 | 0 | |
44 | ODBW | Batch Draft Attribs in Locat. | 8 | Instance | Instance | Int | 6 | 0 | 0 | |
45 | ODSN | SNs - Draft - Master Data | 18 | Instance | Instance | Int | 6 | 0 | 0 | |
46 | ODSW | SN Draft Attribs in Location | 8 | Instance | Instance | Int | 6 | 0 | 0 | |
47 | OIGE | Goods Issue | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
48 | OIGN | Goods Receipt | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
49 | OIPF | Landed Costs | 41 | Instance | Instance | Int | 6 | 0 | 0 | |
50 | OITL | Inventory Transactions Log | 29 | Instance | INSTANCE | Int | 6 | 0 | 0 | |
51 | OIVK | IVL Vs OINM Keys | 5 | Instance | Instance | Int | 11 | 0 | 0 | |
52 | OMRL | Advanced Inventory Revaluation | 17 | Instance | Instance | Int | 6 | 0 | 0 | |
53 | OSRN | Serial Numbers Master Data | 18 | Instance | Instance | Int | 6 | 0 | 0 | |
54 | OSRW | Serial No. Attribs in Location | 8 | Instance | Instance | Int | 6 | 0 | 0 | |
55 | OWKO | Production Instructions | 21 | Instance | Instance | Int | 6 | 0 | 0 | |
56 | OWTQ | Inventory Transfer Request | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
57 | OWTR | Inventory Transfer | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
58 | SIVK | IVL Vs OINM Keys | 5 | Instance | Instance | Int | 11 | 0 | 0 | |
59 | UBTN | Batch Numbers Master Data | 18 | Instance | Instance | Int | 6 | 0 | 0 | |
60 | UIVK | IVL Vs OINM Keys | 5 | Instance | Instance | Int | 11 | 0 | 0 | |
61 | USRN | Serial Numbers Master Data | 18 | Instance | Instance | Int | 6 | 0 | 0 | |
62 | UWKO | Production Instructions | 21 | Instance | Instance | Int | 6 | 0 | 0 | |
TOPMarketing Documents |
63 | ADOC | Invoice - History | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
64 | BAL1 | Opening Balance Instances | 2 | Instance | Instance | Int | 11 | 0 | | |
65 | OCIN | A/R Correction Invoice | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
66 | OCPI | A/P Correction Invoice | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
67 | OCPV | A/P Correction Invoice Reversal | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
68 | OCSI | A/R Correction Invoice | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
69 | OCSV | A/R Correction Invoice Reversal | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
70 | ODLN | Delivery | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
71 | ODPI | A/R Down Payment | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
72 | ODPO | A/P Down Payment | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
73 | ODRF | Drafts | 49 | Instance | Instance | Int | 6 | 0 | | |
74 | OIEI | Incoming Excise Invoice | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
75 | OINV | A/R Invoice | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
76 | OOEI | Outgoing Excise Invoice | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
77 | OPCH | A/P Invoice | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
78 | OPDN | Goods Receipt PO | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
79 | OPOR | Purchase Order | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
80 | OPQT | Purchase Quotation | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
81 | OPRQ | Purchase Request | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
82 | OPRR | Goods Return Request | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
83 | OQUT | Sales Quotation | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
84 | ORCL | Recurring Transaction Instances | 3 | Instance | Recurrence Instance | Int | 11 | 0 | 0 | |
85 | ORDN | Returns | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
86 | ORDR | Sales Order | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
87 | ORIN | A/R Credit Memo | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
88 | ORPC | A/P Credit Memo | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
89 | ORPD | Goods Return | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
90 | ORRR | Return Request | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
91 | OSFC | Self Credit Memo | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
92 | OSFI | Self Invoice | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
TOPSales Opportunities |
93 | AOPR | Opportunity | 32 | Instance | Instance | Int | 6 | 0 | 0 | |
94 | OOPR | Opportunity | 32 | Instance | Instance | Int | 6 | 0 | 0 | |
TOPService |
95 | ACTR | Service Contracts | 60 | Instance | Instance | Int | 6 | 0 | 0 | |
96 | AINS | Customer Equipment Card - History | 51 | Instance | Instance | Int | 6 | 0 | 0 | |
97 | ASC4 | Service Call Travel/Labor Expenses - History | 17 | Instance | Instance | Int | 6 | 0 | 0 | |
98 | ASCL | History | 58 | Instance | Instance | Int | 6 | 0 | 0 | |
99 | OCTR | Service Contracts | 60 | Instance | Instance | Int | 6 | 0 | 0 | |
100 | OINS | Customer Equipment Card | 51 | Instance | Instance | Int | 6 | 0 | 0 | |
101 | OSCL | Service Calls | 58 | Instance | Instance | Int | 6 | 0 | 0 | |
102 | OSLT | Service Call Solutions | 16 | Instance | Instance | Int | 6 | 0 | 0 | |
103 | SCL4 | Expense Documents | 17 | Instance | Instance | Int | 6 | 0 | 0 | |