| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdministration |
1 | AUSR | Archive Users - History | 69 | createDate | Creation Date | Date | 8 | 0 | | |
2 | ODAR | Data Archiving | 4 | CreateDate | Archive Date | Date | 8 | 0 | | |
3 | ODGP | Document Generation Parameter Sets | 4 | CreateDate | Creation Date | Date | 8 | 0 | | |
4 | ODOW | Data Ownership - Objects | 7 | CreateDate | Creation Date | Date | 8 | 0 | | |
5 | ODOX | Data Ownership - Exceptions | 6 | CreateDate | Creation Date | Date | 8 | 0 | | |
6 | OUSR | Users | 69 | createDate | Creation Date - History | Date | 8 | 0 | | |
TOPBanking |
7 | ABOE | Bill of Exchange for Payment - History | 29 | CreateDate | Creation Date | Date | 8 | 0 | | |
8 | ACHO | Checks for Payment - History | 32 | CreateDate | Creation Date | Date | 8 | 0 | | |
9 | ARCT | Incoming Payment - History | 59 | CreateDate | Creation Date | Date | 8 | 0 | | |
10 | OBOE | Bill of Exchange for Payment | 29 | CreateDate | Creation Date | Date | 8 | 0 | | |
11 | OCHD | Checks for Payment Drafts | 32 | CreateDate | Creation Date | Date | 8 | 0 | | |
12 | OCHO | Checks for Payment | 32 | CreateDate | Creation Date | Date | 8 | 0 | | |
13 | OCRH | Credit Card Management | 36 | CreateDate | Creation Date | Date | 8 | 0 | | |
14 | ODPS | Deposit | 28 | CreateDate | Creation Date | Date | 8 | 0 | | |
15 | OITR | Internal Reconciliation | 12 | CreateDate | Creation Date | Date | 8 | 0 | | |
16 | OMTH | Reconciliation History | 12 | createDate | Creation Date | Date | 8 | 0 | | |
17 | OPDF | Payment Draft | 59 | CreateDate | Creation Date | Date | 8 | 0 | | |
18 | OPYM | Payment Methods for Payment Wizard | 17 | CreateDate | Creation Date | Date | 8 | 0 | | |
19 | ORCT | Incoming Payment | 59 | CreateDate | Creation Date | Date | 8 | 0 | | |
20 | OSVR | Saved Reconciliations | 6 | createDate | Creation Date | Date | 8 | 0 | | |
21 | OTPW | Tax Payment Wizard | 5 | CreateDate | Wizard Creation Date | Date | 8 | 0 | | |
22 | OVPM | Outgoing Payments | 59 | CreateDate | Creation Date | Date | 8 | 0 | | |
TOPBusiness Partners |
23 | ACRD | Business Partners - History | 132 | CreateDate | Creation Date | Date | 8 | 0 | | |
24 | OCRD | Business Partner | 132 | CreateDate | Creation Date | Date | 8 | 0 | | |
TOPFinance |
25 | AACT | G/L Account - History | 38 | CreateDate | Creation Date | Date | 8 | 0 | | |
26 | AJDT | Journal Entry - History | 26 | CreateDate | Creation Date | Date | 8 | 0 | | |
27 | CASE | Internal Recon. Upgrade 2007A | 2 | CreateDate | Creation Date | Date | 8 | 0 | | |
28 | OACT | G/L Accounts | 38 | CreateDate | Creation Date | Date | 8 | 0 | | |
29 | OBTF | Journal Voucher Entry | 26 | CreateDate | Recording Date | Date | 8 | 0 | | |
30 | OCFH | Cash Flow Statement History | 5 | CreateDate | Recording Date | Date | 8 | 0 | | |
31 | OGBI | GB Interface: Common Info | 7 | CreateDate | Report Creation Date | nVarChar | 8 | 0 | | |
32 | OIWZ | Inflation Wizard | 31 | CreateDate | Create Date | Date | 8 | 0 | | |
33 | OJDT | Journal Entry | 26 | CreateDate | Recording Date | Date | 8 | 0 | | |
34 | OJST | TDS Adjustment | 8 | CreateDate | Creation Date | Date | 8 | 0 | | |
35 | OSCM | Special Ledger - Analytical Accounting Configuration Rules: Material | 7 | CreateDate | Date of Rule Generation | Date | 8 | 0 | | |
36 | OSCR | Special Ledger - Analytical Accounting Configuration Rules: Revenues & Expenses | 7 | CreateDate | Date of Rule Generation | Date | 8 | 0 | | |
37 | OSHR | Shareholder's Rights and Interests Report History | 5 | CreateDate | Report Created on | Date | 8 | 0 | | |
TOPInventory and Production |
38 | AITB | Item Groups - History | 49 | createDate | Creation Date - History | Date | 8 | 0 | | |
39 | AITM | Items - History | 166 | CreateDate | Production Date | Date | 8 | 0 | | |
40 | AITT | Product Tree - History | 6 | CreateDate | Creation Date | Date | 8 | 0 | | |
41 | AITW | Items - Warehouse - History | 50 | createDate | Creation Date - History | Date | 8 | 0 | | |
42 | AMRV | Inventory Revaluation - History | 12 | CreateDate | Creation Date | Date | 8 | 0 | | |
43 | APKL | Pick List - History | 14 | CreateDate | Creation Date | Date | 8 | 0 | | |
44 | AWHS | Warehouses - History | 56 | createDate | Creation Date - History | Date | 8 | 0 | | |
45 | AWOR | Production Order - History | 26 | CreateDate | Creation Date | Date | 8 | 0 | | |
46 | LIVI1 | IVI Log Array File | 3 | CreateDate | Create Date | Date | 8 | 0 | | |
47 | OAIM | Archive Inventory Message | 24 | CreateDate | Creation Date | Date | 8 | 0 | | |
48 | OBTN | Batch Numbers Master Data | 11 | CreateDate | Creation Date | Date | 8 | 0 | | |
49 | ODBN | Bat. Nos - Draft - Master Data | 11 | CreateDate | Creation Date | Date | 8 | 0 | | |
50 | ODSN | SNs - Draft - Master Data | 11 | CreateDate | Creation Date | Date | 8 | 0 | | |
51 | OENT | Shipping Types | 33 | CreateDate | Creation Date | Date | 8 | 0 | | |
52 | OIBT | Batch No. for Item | 19 | CreateDate | Creation Date | Date | 8 | 0 | | |
53 | OIGE | Goods Issue | 65 | CreateDate | Creation Date | Date | 8 | 0 | | |
54 | OIGN | Goods Receipt | 65 | CreateDate | Creation Date | Date | 8 | 0 | | |
55 | OILM | Inventory Log Message | 34 | CreateDate | Creation Date | Date | 8 | 0 | | |
56 | OINM | Whse Journal | 54 | CreateDate | Creation Date | Date | 8 | 0 | | |
57 | OIPF | Landed Costs | 39 | CreateDate | Creation Date | Date | 8 | 0 | | |
58 | OIQI | Inventory Initial Quantity | 2 | CreateDate | Creation Date | Date | 8 | 0 | | |
59 | OIQR | Inventory Stock Posting (Reconcile) | 2 | CreateDate | Creation Date | Date | 8 | 0 | | |
60 | OITB | Item Groups | 49 | createDate | Creation Date - History | Date | 8 | 0 | | |
61 | OITL | Inventory Transactions Log | 23 | CreateDate | Creation Date | Date | 8 | 0 | | |
62 | OITM | Items | 166 | CreateDate | Production Date | Date | 8 | 0 | | |
63 | OITT | Product Tree | 6 | CreateDate | Creation Date | Date | 8 | 0 | | |
64 | OITW | Items - Warehouse | 50 | createDate | Creation Date - History | Date | 8 | 0 | | |
65 | OIVL | Whse Journal | 22 | CreateDate | Creation Date | Date | 8 | 0 | | |
66 | OMRL | Advanced Inventory Revaluation | 19 | CreateDate | Creation Date | Date | 8 | 0 | | |
67 | OMRV | Inventory Revaluation | 12 | CreateDate | Creation Date | Date | 8 | 0 | | |
68 | OPKL | Pick List | 14 | CreateDate | Creation Date | Date | 8 | 0 | | |
69 | OSRI | Serial Numbers for Items | 19 | CreateDate | Creation Date | Date | 8 | 0 | | |
70 | OSRN | Serial Numbers Master Data | 11 | CreateDate | Creation Date | Date | 8 | 0 | | |
71 | OWHS | Warehouses | 56 | createDate | Creation Date - History | Date | 8 | 0 | | |
72 | OWKO | Production Instructions | 19 | CreateDate | Creation Date | Date | 8 | 0 | | |
73 | OWOR | Production Order | 26 | CreateDate | Creation Date | Date | 8 | 0 | | |
74 | OWTR | Inventory Transfer | 65 | CreateDate | Creation Date | Date | 8 | 0 | | |
75 | UILM | IVI Inventory Log Message | 34 | CreateDate | Creation Date | Date | 8 | 0 | | |
76 | UITM | Items | 166 | CreateDate | Production Date | Date | 8 | 0 | | |
77 | UITW | Items - Warehouse | 50 | createDate | Creation Date - History | Date | 8 | 0 | | |
78 | UIVL | Whse Journal | 22 | CreateDate | Creation Date | Date | 8 | 0 | | |
79 | UWKO | Production Instructions | 19 | CreateDate | Creation Date | Date | 8 | 0 | | |
80 | UWOR | Production Order | 26 | CreateDate | Creation Date | Date | 8 | 0 | | |
TOPMarketing Documents |
81 | ADOC | Invoice - History | 65 | CreateDate | Creation Date | Date | 8 | 0 | | |
82 | ATXI | Tax Invoice - History | 11 | CreateDate | Creation Date | Date | 8 | 0 | | |
83 | OCIN | A/R Correction Invoice | 65 | CreateDate | Creation Date | Date | 8 | 0 | | |
84 | OCPI | A/P Correction Invoice | 65 | CreateDate | Creation Date | Date | 8 | 0 | | |
85 | OCPV | A/P Correction Invoice Reversal | 65 | CreateDate | Creation Date | Date | 8 | 0 | | |
86 | OCSI | A/R Correction Invoice | 65 | CreateDate | Creation Date | Date | 8 | 0 | | |
87 | OCSV | A/R Correction Invoice Reversal | 65 | CreateDate | Creation Date | Date | 8 | 0 | | |
88 | ODLN | Delivery | 65 | CreateDate | Creation Date | Date | 8 | 0 | | |
89 | ODPI | A/R Down Payment | 65 | CreateDate | Creation Date | Date | 8 | 0 | | |
90 | ODPO | A/P Down Payment | 65 | CreateDate | Creation Date | Date | 8 | 0 | | |
91 | ODRF | Drafts | 65 | CreateDate | Creation Date | Date | 8 | 0 | | |
92 | ODWZ | Dunning Wizard | 4 | CreateDate | Creation Date | Date | 8 | 0 | | |
93 | OIEI | Incoming Excise Invoice | 65 | CreateDate | Creation Date | Date | 8 | 0 | | |
94 | OINV | A/R Invoice | 65 | CreateDate | Creation Date | Date | 8 | 0 | | |
95 | OOEI | Outgoing Excise Invoice | 65 | CreateDate | Creation Date | Date | 8 | 0 | | |
96 | OPCH | A/P Invoice | 65 | CreateDate | Creation Date | Date | 8 | 0 | | |
97 | OPDN | Goods Receipt PO | 65 | CreateDate | Creation Date | Date | 8 | 0 | | |
98 | OPOR | Purchase Order | 65 | CreateDate | Creation Date | Date | 8 | 0 | | |
99 | OQUT | Sales Quotation | 65 | CreateDate | Creation Date | Date | 8 | 0 | | |
100 | ORDN | Returns | 65 | CreateDate | Creation Date | Date | 8 | 0 | | |
101 | ORDR | Sales Order | 65 | CreateDate | Creation Date | Date | 8 | 0 | | |
102 | ORIN | A/R Credit Memo | 65 | CreateDate | Creation Date | Date | 8 | 0 | | |
103 | ORPC | A/P Credit Memo | 65 | CreateDate | Creation Date | Date | 8 | 0 | | |
104 | ORPD | Goods Return | 65 | CreateDate | Creation Date | Date | 8 | 0 | | |
105 | OSAL | Outgoing | 33 | CreateDate | Creation Date | Date | 8 | 0 | | |
106 | OTPI | Purchase Tax Invoice | 11 | CreateDate | Creation Date | Date | 8 | 0 | | |
107 | OTRA | Transition | 33 | CreateDate | Creation Date | Date | 8 | 0 | | |
108 | OTSI | Sales Tax Invoice | 11 | CreateDate | Creation Date | Date | 8 | 0 | | |
109 | OTXD | Tax Invoice Draft | 11 | CreateDate | Creation Date | Date | 8 | 0 | | |
110 | OWDD | Docs. for Confirmation | 11 | CreateDate | Production Date | Date | 8 | 0 | | |
111 | WDD1 | Documents for Approval - Authorizers | 7 | CreateDate | Request Date | Date | 8 | 0 | | |
TOPReports |
112 | OLLR | Electronic Report Generation Result | 3 | CreateDate | Creation Date | Date | 8 | 0 | | |
113 | RDOC | Document | 52 | CreateDate | Creation Date | Date | 8 | 0 | | |
114 | XROBJ | XLR Company Report Objects | 5 | CreateDate | Creation Date | Date | 8 | 0 | | |
TOPService |
115 | AINS | Customer Equipment Card - History | 39 | createDate | Creation Date | Date | 8 | 0 | | |
116 | ASC1 | Service Call Solutions - History | 7 | createDate | Creation Date - History | Date | 8 | 0 | | |
117 | ASC2 | Service Call Inventory Expenses - History | 15 | CreateDate | Creation Date - History | Date | 8 | 0 | | |
118 | ASC3 | Service Call Travel/Labor Expenses - History | 15 | CreateDate | Creation Date | Date | 8 | 0 | | |
119 | ASC4 | Service Call Travel/Labor Expenses - History | 10 | CreateDate | Creation Date | Date | 8 | 0 | | |
120 | ASC5 | Service Call Activities - History | 7 | CreateDate | Creation Date | Date | 8 | 0 | | |
121 | ASCL | History | 27 | createDate | Creation Date | Date | 8 | 0 | | |
122 | OCTR | Service Contracts | 45 | CreateDate | Creation Date | Date | 8 | 0 | | |
123 | OCTT | Contract Template | 37 | CreateDate | Creation Date | Date | 8 | 0 | | |
124 | OINS | Customer Equipment Card | 39 | createDate | Creation Date | Date | 8 | 0 | | |
125 | OREQ | External System Call Request | 4 | CreateDate | Request Creation Date | Date | 8 | 0 | | |
126 | OSCL | Service Calls | 27 | createDate | Creation Date | Date | 8 | 0 | | |
127 | QUE2 | Queue Elements | 6 | createDate | Creation Date | Date | 8 | 0 | | |
128 | SCL1 | Service Call Solutions - Rows | 7 | createDate | Creation Date | Date | 8 | 0 | | |
129 | SCL2 | Service Call Inventory Expenses | 15 | CreateDate | Creation Date | Date | 8 | 0 | | |
130 | SCL3 | Service Call Travel/Labor Expenses | 15 | CreateDate | Creation Date | Date | 8 | 0 | | |
131 | SCL4 | Expense Documents | 10 | CreateDate | Creation Date | Date | 8 | 0 | | |
132 | SCL5 | Service Call Activities | 7 | CreateDate | Creation Date | Date | 8 | 0 | | |