| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdministration |
1 | DAR1 | Data Archive - Transaction Log | 23 | Instance | Instance | Int | 6 | 0 | 0 | |
TOPBanking |
2 | ABOE | Bill of Exchange for Payment - History | 40 | Instance | Instance | Int | 6 | 0 | 0 | |
3 | ACHO | Checks for Payment - History | 41 | Instance | Instance | Int | 6 | 0 | 0 | |
4 | OBOE | Bill of Exchange for Payment | 40 | Instance | Instance | Int | 6 | 0 | 0 | |
5 | OCHD | Checks for Payment Drafts | 41 | Instance | Instance | Int | 6 | 0 | 0 | |
6 | OCHH | Check Register | 25 | Instance | Instance | Int | 6 | 0 | 0 | |
7 | OCHO | Checks for Payment | 41 | Instance | Instance | Int | 6 | 0 | 0 | |
8 | OCRH | Credit Card Management | 33 | Instance | Instance | Int | 6 | 0 | 0 | |
9 | OCRV | Credit Payments | 25 | Instance | Instance | Int | 6 | 0 | 0 | |
TOPBusiness Partners |
10 | ACPN | Campaign | 21 | Instance | Instance | Int | 6 | 0 | 0 | |
11 | OCLG | Activities | 40 | Instance | Instance | Int | 6 | 0 | 0 | |
12 | OCPN | Campaign | 21 | Instance | Instance | Int | 6 | 0 | 0 | |
TOPFinance |
13 | BGT1 | Budget - Rows | 21 | Instance | Instance | Int | 11 | 0 | 1 | |
14 | BGT2 | Budget - Cost Accounting | 4 | Instance | Instance | Int | 11 | 0 | 1 | |
15 | BGT3 | Budget - Cost Accounting Rows | 4 | Instance | Instance | Int | 11 | 0 | 1 | |
16 | OBGT | Budget | 23 | Instance | Instance | Int | 11 | 0 | 1 | |
17 | ORCR | Recurring Postings | 18 | Instance | Instance | Int | 6 | 0 | 0 | |
18 | RCR1 | Recurring Postings - Rows | 8 | Instance | Instance | Int | 6 | 0 | | |
TOPInventory and Production |
19 | ABTN | Batch Numbers Master Data | 18 | Instance | Instance | Int | 6 | 0 | 0 | |
20 | ABTW | Batch Attributes in Location | 8 | Instance | Instance | Int | 6 | 0 | 0 | |
21 | ASRN | Serial Numbers Master Data | 18 | Instance | Instance | Int | 6 | 0 | 0 | |
22 | OBTN | Batch Numbers Master Data | 18 | Instance | Instance | Int | 6 | 0 | 0 | |
23 | OBTW | Batch Attributes in Location | 8 | Instance | Instance | Int | 6 | 0 | 0 | |
24 | ODBN | Bat. Nos - Draft - Master Data | 18 | Instance | Instance | Int | 6 | 0 | 0 | |
25 | ODBW | Batch Draft Attribs in Locat. | 8 | Instance | Instance | Int | 6 | 0 | 0 | |
26 | ODSN | SNs - Draft - Master Data | 18 | Instance | Instance | Int | 6 | 0 | 0 | |
27 | ODSW | SN Draft Attribs in Location | 8 | Instance | Instance | Int | 6 | 0 | 0 | |
28 | OIBT | Batch No. for Item | 28 | Instance | Instance | Int | 6 | 0 | 0 | |
29 | OIGE | Goods Issue | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
30 | OIGN | Goods Receipt | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
31 | OINM | Whse Journal | 37 | Instance | Instance | Int | 11 | 0 | 0 | |
32 | OIPF | Landed Costs | 41 | Instance | Instance | Int | 6 | 0 | 0 | |
33 | OITL | Inventory Transactions Log | 29 | Instance | INSTANCE | Int | 6 | 0 | 0 | |
34 | OIVK | IVL Vs OINM Keys | 5 | Instance | Instance | Int | 11 | 0 | 0 | |
35 | OMRL | Advanced Inventory Revaluation | 17 | Instance | Instance | Int | 6 | 0 | 0 | |
36 | OSRI | Serial Numbers for Items | 28 | Instance | Instance | Int | 6 | 0 | 0 | |
37 | OSRN | Serial Numbers Master Data | 18 | Instance | Instance | Int | 6 | 0 | 0 | |
38 | OSRW | Serial No. Attribs in Location | 8 | Instance | Instance | Int | 6 | 0 | 0 | |
39 | OWKO | Production Instructions | 21 | Instance | Instance | Int | 6 | 0 | 0 | |
40 | OWTQ | Inventory Transfer Request | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
41 | OWTR | Inventory Transfer | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
42 | SIVK | IVL Vs OINM Keys | 5 | Instance | Instance | Int | 11 | 0 | 0 | |
43 | UIVK | IVL Vs OINM Keys | 5 | Instance | Instance | Int | 11 | 0 | 0 | |
44 | UWKO | Production Instructions | 21 | Instance | Instance | Int | 6 | 0 | 0 | |
TOPMarketing Documents |
45 | ADOC | Invoice - History | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
46 | OCIN | A/R Correction Invoice | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
47 | OCPI | A/P Correction Invoice | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
48 | OCPV | A/P Correction Invoice Reversal | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
49 | OCSI | A/R Correction Invoice | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
50 | OCSV | A/R Correction Invoice Reversal | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
51 | ODLN | Delivery | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
52 | ODPI | A/R Down Payment | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
53 | ODPO | A/P Down Payment | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
54 | ODRF | Drafts | 49 | Instance | Instance | Int | 6 | 0 | | |
55 | OIEI | Incoming Excise Invoice | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
56 | OINV | A/R Invoice | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
57 | OOEI | Outgoing Excise Invoice | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
58 | OPCH | A/P Invoice | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
59 | OPDN | Goods Receipt PO | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
60 | OPOR | Purchase Order | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
61 | OPQT | Purchase Quotation | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
62 | OQUT | Sales Quotation | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
63 | ORCL | Recurring Transaction Instances | 3 | Instance | Recurrence Instance | Int | 11 | 0 | 0 | |
64 | ORDN | Returns | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
65 | ORDR | Sales Order | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
66 | ORIN | A/R Credit Memo | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
67 | ORPC | A/P Credit Memo | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
68 | ORPD | Goods Return | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
TOPSales Opportunities |
69 | OOPR | Sales Opportunity | 32 | Instance | Instance | Int | 6 | 0 | 0 | |
TOPService |
70 | AINS | Customer Equipment Card - History | 51 | Instance | Instance | Int | 6 | 0 | 0 | |
71 | ASC4 | Service Call Travel/Labor Expenses - History | 17 | Instance | Instance | Int | 6 | 0 | 0 | |
72 | ASCL | History | 58 | Instance | Instance | Int | 6 | 0 | 0 | |
73 | OCTR | Service Contracts | 60 | Instance | Instance | Int | 6 | 0 | 0 | |
74 | OINS | Customer Equipment Card | 51 | Instance | Instance | Int | 6 | 0 | 0 | |
75 | OSCL | Service Calls | 58 | Instance | Instance | Int | 6 | 0 | 0 | |
76 | OSLT | Service Call Solutions | 16 | Instance | Instance | Int | 6 | 0 | 0 | |
77 | SCL4 | Expense Documents | 17 | Instance | Instance | Int | 6 | 0 | 0 | |