| 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 | OCLG | Activities | 40 | Instance | Instance | Int | 6 | 0 | 0 | |
TOPFinance |
11 | BGT1 | Budget - Rows | 21 | Instance | Instance | Int | 11 | 0 | 1 | |
12 | OBGT | Budget | 23 | Instance | Instance | Int | 11 | 0 | 1 | |
13 | ORCR | Recurring Postings | 18 | Instance | Instance | Int | 6 | 0 | 0 | |
14 | RCR1 | Recurring Postings - Rows | 8 | Instance | Instance | Int | 6 | 0 | | |
TOPInventory and Production |
15 | OBTN | Batch Numbers Master Data | 18 | Instance | Instance | Int | 6 | 0 | 0 | |
16 | OBTW | Batch Attributes in Location | 8 | Instance | Instance | Int | 6 | 0 | 0 | |
17 | ODBN | Bat. Nos - Draft - Master Data | 18 | Instance | Instance | Int | 6 | 0 | 0 | |
18 | ODBW | Batch Draft Attribs in Locat. | 8 | Instance | Instance | Int | 6 | 0 | 0 | |
19 | ODSN | SNs - Draft - Master Data | 18 | Instance | Instance | Int | 6 | 0 | 0 | |
20 | ODSW | SN Draft Attribs in Location | 8 | Instance | Instance | Int | 6 | 0 | 0 | |
21 | OIBT | Batch No. for Item | 28 | Instance | Instance | Int | 6 | 0 | 0 | |
22 | OIGE | Goods Issue | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
23 | OIGN | Goods Receipt | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
24 | OINM | Whse Journal | 37 | Instance | Instance | Int | 11 | 0 | 0 | |
25 | OIPF | Landed Costs | 41 | Instance | Instance | Int | 6 | 0 | 0 | |
26 | OITL | Inventory Transactions Log | 29 | Instance | INSTANCE | Int | 6 | 0 | 0 | |
27 | OIVK | IVL Vs OINM Keys | 5 | Instance | Instance | Int | 11 | 0 | 0 | |
28 | OMRL | Advanced Inventory Revaluation | 17 | Instance | Instance | Int | 6 | 0 | 0 | |
29 | OSRI | Serial Numbers for Items | 28 | Instance | Instance | Int | 6 | 0 | 0 | |
30 | OSRN | Serial Numbers Master Data | 18 | Instance | Instance | Int | 6 | 0 | 0 | |
31 | OSRW | Serial No. Attribs in Location | 8 | Instance | Instance | Int | 6 | 0 | 0 | |
32 | OWKO | Production Instructions | 21 | Instance | Instance | Int | 6 | 0 | 0 | |
33 | OWTR | Inventory Transfer | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
34 | UIVK | IVL Vs OINM Keys | 5 | Instance | Instance | Int | 11 | 0 | 0 | |
35 | UWKO | Production Instructions | 21 | Instance | Instance | Int | 6 | 0 | 0 | |
TOPMarketing Documents |
36 | ADOC | Invoice - History | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
37 | OCIN | A/R Correction Invoice | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
38 | OCPI | A/P Correction Invoice | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
39 | OCPV | A/P Correction Invoice Reversal | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
40 | OCSI | A/R Correction Invoice | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
41 | OCSV | A/R Correction Invoice Reversal | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
42 | ODLN | Delivery | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
43 | ODPI | A/R Down Payment | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
44 | ODPO | A/P Down Payment | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
45 | ODRF | Drafts | 49 | Instance | Instance | Int | 6 | 0 | | |
46 | OIEI | Incoming Excise Invoice | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
47 | OINV | A/R Invoice | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
48 | OOEI | Outgoing Excise Invoice | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
49 | OPCH | A/P Invoice | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
50 | OPDN | Goods Receipt PO | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
51 | OPOR | Purchase Order | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
52 | OQUT | Sales Quotation | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
53 | ORDN | Returns | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
54 | ORDR | Sales Order | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
55 | ORIN | A/R Credit Memo | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
56 | ORPC | A/P Credit Memo | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
57 | ORPD | Goods Return | 49 | Instance | Instance | Int | 6 | 0 | 0 | |
TOPSales Opportunities |
58 | OOPR | Sales Opportunity | 32 | Instance | Instance | Int | 6 | 0 | 0 | |
TOPService |
59 | AINS | Customer Equipment Card - History | 51 | Instance | Instance | Int | 6 | 0 | 0 | |
60 | ASC4 | Service Call Travel/Labor Expenses - History | 17 | Instance | Instance | Int | 6 | 0 | 0 | |
61 | ASCL | History | 58 | Instance | Instance | Int | 6 | 0 | 0 | |
62 | OCTR | Service Contracts | 60 | Instance | Instance | Int | 6 | 0 | 0 | |
63 | OINS | Customer Equipment Card | 51 | Instance | Instance | Int | 6 | 0 | 0 | |
64 | OSCL | Service Calls | 58 | Instance | Instance | Int | 6 | 0 | 0 | |
65 | OSLT | Service Call Solutions | 16 | Instance | Instance | Int | 6 | 0 | 0 | |
66 | SCL4 | Expense Documents | 17 | Instance | Instance | Int | 6 | 0 | 0 | |