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