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