| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdministration |
1 | CSN1 | Certificate Series - Series | 2 | Series | Series | Int | 6 | 0 | | |
2 | DAR1 | Data Archive - Transaction Log | 20 | Series | Series | Int | 6 | 0 | | |
3 | NNM1 | Documents Numbering - Series | 2 | Series | Series | Int | 6 | 0 | 0 | |
4 | NNM2 | Series Default | 3 | Series | Series | Int | 6 | 0 | | |
5 | NNM3 | Documents Numbering -Belgium Series | 2 | Series | Series | Int | 6 | 0 | 0 | |
6 | NNM4 | Electronic Series | 2 | Series | Series | Int | 6 | 0 | | |
7 | NNM5 | Document Numbering - Removed Serial Numbers | 2 | Series | Series | Int | 6 | 0 | | |
8 | ODGP | Document Generation Parameter Sets | 10 | Series | Series | Int | 6 | 0 | | |
TOPBanking |
9 | ARCT | Incoming Payment - History | 62 | Series | Series | Int | 6 | 0 | | |
10 | ODPS | Deposit | 35 | Series | Series | Int | 6 | 0 | | |
11 | OPDF | Payment Draft | 62 | Series | Series | Int | 6 | 0 | | |
12 | OPMN | Payment | 62 | Series | Series | Int | 6 | 0 | | |
13 | OPOI | Incoming Payment Order | 3 | Series | Series | Int | 6 | 0 | | |
14 | OPOO | Outgoing Payment Order | 3 | Series | Series | Int | 6 | 0 | | |
15 | ORCT | Incoming Payment | 62 | Series | Series | Int | 6 | 0 | | |
16 | OTPW | Tax Payment Wizard | 9 | Series | Wizard Series | Int | 6 | 0 | | |
17 | OVPM | Outgoing Payments | 62 | Series | Series | Int | 6 | 0 | | |
TOPBusiness Partners |
18 | ACRD | Business Partners - History | 298 | Series | Series | Int | 6 | 0 | | |
19 | AOAT | Blanket Agreement | 36 | Series | Series | Int | 6 | 0 | | |
20 | OCRD | Business Partner | 298 | Series | Series | Int | 6 | 0 | | |
21 | OOAT | Blanket Agreement | 36 | Series | Series | Int | 6 | 0 | | |
TOPFinance |
22 | AFAD | Asset Document - History | 3 | Series | Series | Int | 6 | 0 | | |
23 | AJDT | Journal Entry - History | 41 | Series | Series | Int | 6 | 0 | 0 | |
24 | OACD | Credit Memo | 3 | Series | Series | Int | 6 | 0 | | |
25 | OACQ | Capitalization | 3 | Series | Series | Int | 6 | 0 | | |
26 | OBTF | Journal Voucher Entry | 41 | Series | Series | Int | 6 | 0 | 0 | |
27 | ODRN | Depreciation Run | 3 | Series | Series | Int | 6 | 0 | | |
28 | OFAD | Asset Document | 3 | Series | Series | Int | 6 | 0 | | |
29 | OFAR | Fixed Asset Revaluation | 3 | Series | Series | Int | 6 | 0 | | |
30 | OFTR | Transfer | 3 | Series | Series | Int | 6 | 0 | | |
31 | OJDT | Journal Entry | 41 | Series | Series | Int | 6 | 0 | 0 | |
32 | OMDP | Manual Depreciation | 3 | Series | Series | Int | 6 | 0 | | |
33 | ORTI | Retirement | 3 | Series | Series | Int | 6 | 0 | | |
TOPGeneral |
34 | AIWZ | Summary Wizard | 45 | Series | Series | Int | 6 | 0 | | |
35 | ARSC | Resource Master Data - Log | 3 | Series | Series | Int | 6 | 0 | | |
36 | ORSC | Resource Master Data | 3 | Series | Series | Int | 6 | 0 | | |
37 | TDAR | Temp Data Archive | 21 | Series | Series | Int | 6 | 0 | | |
TOPInventory and Production |
38 | AINC | Inventory Counting | 3 | Series | Series | Int | 6 | 0 | | |
39 | AIQI | Inventory Opening Balance | 17 | Series | Series | Int | 6 | 0 | | |
40 | AIQR | Inventory Posting | 17 | Series | Series | Int | 6 | 0 | | |
41 | AITM | Items - History | 252 | Series | Series | Int | 6 | 0 | | |
42 | AMRV | Inventory Revaluation - History | 13 | Series | Series | Int | 6 | 0 | 0 | |
43 | AWOR | Production Order - History | 3 | Series | Series | Int | 6 | 0 | 0 | |
44 | OENT | Shipping Types | 37 | Series | Series | Int | 6 | 0 | | |
45 | OICD | Inventory Counting Draft | 3 | Series | Series | Int | 6 | 0 | | |
46 | OIGE | Goods Issue | 70 | Series | Series | Int | 6 | 0 | | |
47 | OIGN | Goods Receipt | 70 | Series | Series | Int | 6 | 0 | | |
48 | OINC | Inventory Counting | 3 | Series | Series | Int | 6 | 0 | | |
49 | OIOD | Inventory Opening Balance Draft | 17 | Series | Series | Int | 6 | 0 | | |
50 | OIPD | Inventory Posting Draft | 17 | Series | Series | Int | 6 | 0 | | |
51 | OIPF | Landed Costs | 43 | Series | Series | Int | 6 | 0 | | |
52 | OIQI | Inventory Opening Balance | 17 | Series | Series | Int | 6 | 0 | | |
53 | OIQR | Inventory Posting | 17 | Series | Series | Int | 6 | 0 | | |
54 | OITM | Items | 252 | Series | Series | Int | 6 | 0 | | |
55 | OMRL | Advanced Inventory Revaluation | 3 | Series | Series | Int | 6 | 0 | 0 | |
56 | OMRV | Inventory Revaluation | 13 | Series | Series | Int | 6 | 0 | | |
57 | OWKO | Production Instructions | 22 | Series | Series | Int | 6 | 0 | | |
58 | OWOR | Production Order | 3 | Series | Series | Int | 6 | 0 | 0 | |
59 | OWTQ | Inventory Transfer Request | 70 | Series | Series | Int | 6 | 0 | | |
60 | OWTR | Inventory Transfer | 70 | Series | Series | Int | 6 | 0 | | |
61 | SITM | Items | 252 | Series | Series | Int | 6 | 0 | | |
62 | UITM | Items | 252 | Series | Series | Int | 6 | 0 | | |
63 | UWKO | Production Instructions | 22 | Series | Series | Int | 6 | 0 | | |
64 | UWOR | Production Order | 3 | Series | Series | Int | 6 | 0 | 0 | |
TOPMarketing Documents |
65 | ADO21 | A/R Invoice (Resource Costs) - History | 14 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
66 | ADOC | Invoice - History | 70 | Series | Series | Int | 6 | 0 | | |
67 | ATXI | Tax Invoice - History | 14 | Series | Series | Int | 6 | 0 | 0 | |
68 | CIN21 | Correction Invoice - Resource Costs | 14 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
69 | CPI21 | A/P Correction Invoice - Resource Costs | 14 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
70 | CPV21 | A/P Correction Invoice Reversal - Resource Costs | 14 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
71 | CSI21 | A/R Correction Invoice - Resource Costs | 14 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
72 | CSV21 | A/R Correction Invoice Reversal - Resource Costs | 14 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
73 | DLN21 | Delivery - Resource Costs | 14 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
74 | DOC21 | Mktg Docs - Resource Costs | 14 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
75 | DPI21 | A/R Down Payment - Resource Costs | 14 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
76 | DPO21 | A/P Down Payment - Resource Costs | 14 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
77 | DRF21 | Draft - Resource Costs | 14 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
78 | IEI21 | Incoming Excise Invoice - Resource Costs | 14 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
79 | IGE21 | Goods Issue - Resource Costs | 14 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
80 | IGN21 | Goods Receipt - Resource Costs | 14 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
81 | INV21 | A/R Invoice - Resource Costs | 14 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
82 | OCIN | A/R Correction Invoice | 70 | Series | Series | Int | 6 | 0 | | |
83 | OCPI | A/P Correction Invoice | 70 | Series | Series | Int | 6 | 0 | | |
84 | OCPV | A/P Correction Invoice Reversal | 70 | Series | Series | Int | 6 | 0 | | |
85 | OCSI | A/R Correction Invoice | 70 | Series | Series | Int | 6 | 0 | | |
86 | OCSV | A/R Correction Invoice Reversal | 70 | Series | Series | Int | 6 | 0 | | |
87 | ODLN | Delivery | 70 | Series | Series | Int | 6 | 0 | | |
88 | ODOC | Marketing Documents | 70 | Series | Series | Int | 6 | 0 | | |
89 | ODPI | A/R Down Payment | 70 | Series | Series | Int | 6 | 0 | | |
90 | ODPO | A/P Down Payment | 70 | Series | Series | Int | 6 | 0 | | |
91 | ODRF | Drafts | 70 | Series | Series | Int | 6 | 0 | | |
92 | ODWZ | Dunning Wizard | 37 | Series | Series | Int | 6 | 0 | 0 | |
93 | OEI21 | Outgoing Excise Invoice - Resource Costs | 14 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
94 | OIEI | Incoming Excise Invoice | 70 | Series | Series | Int | 6 | 0 | | |
95 | OINV | A/R Invoice | 70 | Series | Series | Int | 6 | 0 | | |
96 | OMIN | A/R Monthly Invoice | 16 | Series | Series | Int | 6 | 0 | | |
97 | OMIV | A/P Monthly Invoice | 16 | Series | Series | Int | 6 | 0 | | |
98 | OOEI | Outgoing Excise Invoice | 70 | Series | Series | Int | 6 | 0 | | |
99 | OPCH | A/P Invoice | 70 | Series | Series | Int | 6 | 0 | | |
100 | OPDN | Goods Receipt PO | 70 | Series | Series | Int | 6 | 0 | | |
101 | OPOR | Purchase Order | 70 | Series | Series | Int | 6 | 0 | | |
102 | OPQT | Purchase Quotation | 70 | Series | Series | Int | 6 | 0 | | |
103 | OPRQ | Purchase Request | 70 | Series | Series | Int | 6 | 0 | | |
104 | OQUT | Sales Quotation | 70 | Series | Series | Int | 6 | 0 | | |
105 | ORDN | Returns | 70 | Series | Series | Int | 6 | 0 | | |
106 | ORDR | Sales Order | 70 | Series | Series | Int | 6 | 0 | | |
107 | ORIN | A/R Credit Memo | 70 | Series | Series | Int | 6 | 0 | | |
108 | ORPC | A/P Credit Memo | 70 | Series | Series | Int | 6 | 0 | | |
109 | ORPD | Goods Return | 70 | Series | Series | Int | 6 | 0 | | |
110 | OSAL | Outgoing | 37 | Series | Series | Int | 6 | 0 | | |
111 | OTPI | Purchase Tax Invoice | 14 | Series | Series | Int | 6 | 0 | 0 | |
112 | OTRA | Transition | 37 | Series | Series | Int | 6 | 0 | | |
113 | OTSI | Sales Tax Invoice | 14 | Series | Series | Int | 6 | 0 | 0 | |
114 | OTXD | Tax Invoice Draft | 14 | Series | Series | Int | 6 | 0 | 0 | |
115 | PCH21 | A/P Invoice - Resource Costs | 14 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
116 | PDN21 | Goods Receipt PO - Resource Costs | 14 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
117 | POR21 | Purchase Order - Resource Costs | 14 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
118 | PQT21 | Purchase Quotation - Resource Costs | 14 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
119 | PRQ21 | Purchase Request - Resource Costs | 14 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
120 | QUT21 | Sales Quotation - Resource Costs | 14 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
121 | RDN21 | Returns - Resource Costs | 14 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
122 | RDR21 | Sales Order - Resource Costs | 14 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
123 | RIN21 | A/R Credit Memo - Resource Costs | 14 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
124 | RPC21 | A/P Credit Memo - Resource Costs | 14 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
125 | RPD21 | Goods Return - Resource Costs | 14 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
126 | WTQ21 | Inventory Transfer Request - Resource Costs | 14 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
127 | WTR21 | Inventory Transfer - Resource Costs | 14 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
TOPService |
128 | ASCL | History | 60 | Series | Series | Int | 6 | 0 | | |
129 | OSCL | Service Calls | 60 | Series | Series | Int | 6 | 0 | | |