| 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 | 11 | 0 | | |
3 | NNM1 | Documents Numbering - Series | 2 | Series | Series | Int | 11 | 0 | 0 | |
4 | NNM2 | Series Default | 3 | Series | Series | Int | 11 | 0 | | |
5 | NNM3 | Documents Numbering -Belgium Series | 2 | Series | Series | Int | 11 | 0 | 0 | |
6 | NNM4 | Electronic Series | 2 | Series | Series | Int | 11 | 0 | | |
7 | NNM5 | Document Numbering - Removed Serial Numbers | 2 | Series | Series | Int | 11 | 0 | | |
8 | ODGP | Document Generation Parameter Sets | 10 | Series | Series | Int | 11 | 0 | | |
TOPBanking |
9 | ARCT | Incoming Payment - History | 62 | Series | Series | Int | 11 | 0 | | |
10 | ODPS | Deposit | 35 | Series | Series | Int | 11 | 0 | | |
11 | OPDF | Payment Draft | 62 | Series | Series | Int | 11 | 0 | | |
12 | OPOI | Incoming Payment Order | 3 | Series | Series | Int | 11 | 0 | | |
13 | OPOO | Outgoing Payment Order | 3 | Series | Series | Int | 11 | 0 | | |
14 | ORCT | Incoming Payment | 62 | Series | Series | Int | 11 | 0 | | |
15 | OTPW | Tax Payment Wizard | 9 | Series | Wizard Series | Int | 11 | 0 | | |
16 | OVPM | Outgoing Payments | 62 | Series | Series | Int | 11 | 0 | | |
TOPBusiness Partners |
17 | ACRD | Business Partners - History | 298 | Series | Series | Int | 11 | 0 | | |
18 | AOAT | Blanket Agreement | 36 | Series | Series | Int | 11 | 0 | | |
19 | OCRD | Business Partner | 298 | Series | Series | Int | 11 | 0 | | |
20 | OOAT | Blanket Agreement | 36 | Series | Series | Int | 11 | 0 | | |
TOPFinance |
21 | AFAD | Asset Document - History | 3 | Series | Series | Int | 11 | 0 | | |
22 | AJDT | Journal Entry - History | 41 | Series | Series | Int | 11 | 0 | 0 | |
23 | OACD | Credit Memo | 3 | Series | Series | Int | 11 | 0 | | |
24 | OACQ | Capitalization | 3 | Series | Series | Int | 11 | 0 | | |
25 | OBTF | Journal Voucher Entry | 41 | Series | Series | Int | 11 | 0 | 0 | |
26 | ODRN | Depreciation Run | 3 | Series | Series | Int | 11 | 0 | | |
27 | OFAR | Fixed Asset Revaluation | 3 | Series | Series | Int | 11 | 0 | | |
28 | OFTR | Transfer | 3 | Series | Series | Int | 11 | 0 | | |
29 | OJDT | Journal Entry | 41 | Series | Series | Int | 11 | 0 | 0 | |
30 | OMDP | Manual Depreciation | 3 | Series | Series | Int | 11 | 0 | | |
31 | ORTI | Retirement | 3 | Series | Series | Int | 11 | 0 | | |
TOPGeneral |
32 | AIRI | Input Service Distribution - Recipient Invoice | 3 | Series | Series | Int | 11 | 0 | | |
33 | AIRR | Input Service Distribution - Recipient Credit Memo | 3 | Series | Series | Int | 11 | 0 | | |
34 | AISC | Input Service Distribution - Credit Memo | 3 | Series | Series | Int | 11 | 0 | | |
35 | AISD | Input Service Distribution | 5 | Series | Series | Int | 11 | 0 | | |
36 | AISI | Input Service Distribution - Invoice | 3 | Series | Series | Int | 11 | 0 | | |
37 | APMG | Project Management Document - History | 7 | Series | Series | Int | 11 | 0 | | |
38 | ARSC | Resource Master Data - Log | 3 | Series | Series | Int | 11 | 0 | | |
39 | FND1 | Folio Numbering - Document Series | 2 | Series | Series ID | Int | 11 | 0 | | |
40 | FNS1 | Folio Numbering - Voided Series | 1 | Series | Series ID | Int | 11 | 0 | | |
41 | OFNS | Folio Numbering - Series | 1 | Series | Series ID | Int | 11 | 0 | | |
42 | OIRI | Input Service Distribution - Recipient Invoice | 3 | Series | Series | Int | 11 | 0 | | |
43 | OIRR | Input Service Distribution - Recipient Credit Memo | 3 | Series | Series | Int | 11 | 0 | | |
44 | OISC | Input Service Distribution - Credit Memo | 3 | Series | Series | Int | 11 | 0 | | |
45 | OISD | Input Service Distribution | 5 | Series | Series | Int | 11 | 0 | | |
46 | OISI | Input Service Distribution - Invoice | 3 | Series | Series | Int | 11 | 0 | | |
47 | OPMG | Project Management Document | 7 | Series | Series | Int | 11 | 0 | | |
48 | ORSC | Resources | 3 | Series | Series | Int | 11 | 0 | | |
TOPInventory and Production |
49 | AINC | Inventory Counting | 3 | Series | Series | Int | 11 | 0 | | |
50 | AIQI | Inventory Opening Balance | 17 | Series | Series | Int | 11 | 0 | | |
51 | AIQR | Inventory Posting | 17 | Series | Series | Int | 11 | 0 | | |
52 | AITM | Items - History | 252 | Series | Series | Int | 11 | 0 | | |
53 | AMRV | Inventory Revaluation - History | 13 | Series | Series | Int | 11 | 0 | 0 | |
54 | AWOR | Production Order - History | 3 | Series | Series | Int | 11 | 0 | 0 | |
55 | IGE21 | Goods Issue - Document Reference Information | 15 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
56 | IGN21 | Goods Receipt - Document Reference Information | 15 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
57 | OENT | Shipping Types | 37 | Series | Series | Int | 11 | 0 | | |
58 | OICD | Inventory Counting Draft | 3 | Series | Series | Int | 11 | 0 | | |
59 | OIGE | Goods Issue | 70 | Series | Series | Int | 11 | 0 | | |
60 | OIGN | Goods Receipt | 70 | Series | Series | Int | 11 | 0 | | |
61 | OINC | Inventory Counting | 3 | Series | Series | Int | 11 | 0 | | |
62 | OIOD | Inventory Opening Balance Draft | 17 | Series | Series | Int | 11 | 0 | | |
63 | OIPD | Inventory Posting Draft | 17 | Series | Series | Int | 11 | 0 | | |
64 | OIPF | Landed Costs | 43 | Series | Series | Int | 11 | 0 | | |
65 | OIQI | Inventory Opening Balance | 17 | Series | Series | Int | 11 | 0 | | |
66 | OIQR | Inventory Posting | 17 | Series | Series | Int | 11 | 0 | | |
67 | OITM | Items | 252 | Series | Series | Int | 11 | 0 | | |
68 | OMRL | Advanced Inventory Revaluation | 3 | Series | Series | Int | 11 | 0 | 0 | |
69 | OMRV | Inventory Revaluation | 13 | Series | Series | Int | 11 | 0 | | |
70 | OWKO | Production Instructions | 22 | Series | Series | Int | 11 | 0 | | |
71 | OWOR | Production Order | 3 | Series | Series | Int | 11 | 0 | 0 | |
72 | OWTQ | Inventory Transfer Request | 70 | Series | Series | Int | 11 | 0 | | |
73 | OWTR | Inventory Transfer | 70 | Series | Series | Int | 11 | 0 | | |
74 | SITM | Items | 252 | Series | Series | Int | 11 | 0 | | |
75 | UITM | Items | 252 | Series | Series | Int | 11 | 0 | | |
76 | UWKO | Production Instructions | 22 | Series | Series | Int | 11 | 0 | | |
77 | UWOR | Production Order | 3 | Series | Series | Int | 11 | 0 | 0 | |
78 | WTQ21 | Inventory Transfer Request - Document Reference Information | 15 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
79 | WTR21 | Inventory Transfer - Document Reference Information | 15 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
TOPMarketing Documents |
80 | ADO21 | A/R Invoice - Document Reference Information - History | 15 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
81 | ADOC | Invoice - History | 70 | Series | Series | Int | 11 | 0 | | |
82 | ATXI | Tax Invoice - History | 14 | Series | Series | Int | 11 | 0 | 0 | |
83 | CIN21 | Correction Invoice - Document Reference Information | 15 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
84 | CPI21 | A/P Correction Invoice - Document Reference Information | 15 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
85 | CPV21 | A/P Correction Invoice Reversal - Document Reference Information | 15 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
86 | CSI21 | A/R Correction Invoice - Document Reference Information | 15 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
87 | CSV21 | A/R Correction Invoice Reversal - Document Reference Information | 15 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
88 | DLN21 | Delivery - Document Reference Information | 15 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
89 | DPI21 | A/R Down Payment - Document Reference Information | 15 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
90 | DPO21 | A/P Down Payment - Document Reference Information | 15 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
91 | DRF21 | Draft - Document Reference Information | 15 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
92 | GPA3 | Gross Profit Adjustment - JE Details | 5 | Series | Series | Int | 11 | 0 | 0 | |
93 | GPA7 | Product Cost Adjustment - Journal Entry Details | 4 | Series | Series | Int | 11 | 0 | 0 | |
94 | IEI21 | Incoming Excise Invoice - Document Reference Information | 15 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
95 | INV21 | A/R Invoice - Document Reference Information | 15 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
96 | OCIN | A/R Correction Invoice | 70 | Series | Series | Int | 11 | 0 | | |
97 | OCPI | A/P Correction Invoice | 70 | Series | Series | Int | 11 | 0 | | |
98 | OCPV | A/P Correction Invoice Reversal | 70 | Series | Series | Int | 11 | 0 | | |
99 | OCSI | A/R Correction Invoice | 70 | Series | Series | Int | 11 | 0 | | |
100 | OCSV | A/R Correction Invoice Reversal | 70 | Series | Series | Int | 11 | 0 | | |
101 | ODLN | Delivery | 70 | Series | Series | Int | 11 | 0 | | |
102 | ODPI | A/R Down Payment | 70 | Series | Series | Int | 11 | 0 | | |
103 | ODPO | A/P Down Payment | 70 | Series | Series | Int | 11 | 0 | | |
104 | ODRF | Drafts | 70 | Series | Series | Int | 11 | 0 | | |
105 | ODWZ | Dunning Wizard | 37 | Series | Series | Int | 11 | 0 | 0 | |
106 | OEI21 | Outgoing Excise Invoice - Document Reference Information | 15 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
107 | OIEI | Incoming Excise Invoice | 70 | Series | Series | Int | 11 | 0 | | |
108 | OINV | A/R Invoice | 70 | Series | Series | Int | 11 | 0 | | |
109 | OMIN | A/R Monthly Invoice | 16 | Series | Series | Int | 11 | 0 | | |
110 | OMIV | A/P Monthly Invoice | 16 | Series | Series | Int | 11 | 0 | | |
111 | OOEI | Outgoing Excise Invoice | 70 | Series | Series | Int | 11 | 0 | | |
112 | OPCH | A/P Invoice | 70 | Series | Series | Int | 11 | 0 | | |
113 | OPDN | Goods Receipt PO | 70 | Series | Series | Int | 11 | 0 | | |
114 | OPOR | Purchase Order | 70 | Series | Series | Int | 11 | 0 | | |
115 | OPQT | Purchase Quotation | 70 | Series | Series | Int | 11 | 0 | | |
116 | OPRQ | Purchase Request | 70 | Series | Series | Int | 11 | 0 | | |
117 | OPRR | Goods Return Request | 70 | Series | Series | Int | 11 | 0 | | |
118 | OQUT | Sales Quotation | 70 | Series | Series | Int | 11 | 0 | | |
119 | ORDN | Returns | 70 | Series | Series | Int | 11 | 0 | | |
120 | ORDR | Sales Order | 70 | Series | Series | Int | 11 | 0 | | |
121 | ORIN | A/R Credit Memo | 70 | Series | Series | Int | 11 | 0 | | |
122 | ORPC | A/P Credit Memo | 70 | Series | Series | Int | 11 | 0 | | |
123 | ORPD | Goods Return | 70 | Series | Series | Int | 11 | 0 | | |
124 | ORRR | Return Request | 70 | Series | Series | Int | 11 | 0 | | |
125 | OSAL | Outgoing | 37 | Series | Series | Int | 11 | 0 | | |
126 | OSFC | Self Credit Memo | 70 | Series | Series | Int | 11 | 0 | | |
127 | OSFI | Self Invoice | 70 | Series | Series | Int | 11 | 0 | | |
128 | OTPI | Purchase Tax Invoice | 14 | Series | Series | Int | 11 | 0 | 0 | |
129 | OTRA | Transition | 37 | Series | Series | Int | 11 | 0 | | |
130 | OTSI | Sales Tax Invoice | 14 | Series | Series | Int | 11 | 0 | 0 | |
131 | OTXD | Tax Invoice Draft | 14 | Series | Series | Int | 11 | 0 | 0 | |
132 | PCH21 | A/P Invoice - Document Reference Information | 15 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
133 | PDN21 | Goods Receipt PO - Document Reference Information | 15 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
134 | POR21 | Purchase Order - Document Reference Information | 15 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
135 | PQT21 | Purchase Quotation - Document Reference Information | 15 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
136 | PRQ21 | Purchase Request - Document Reference Information | 15 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
137 | PRR21 | A/P Return Request - Document Reference Information | 15 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
138 | QUT21 | Sales Quotation - Document Reference Information | 15 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
139 | RDN21 | Returns - Document Reference Information | 15 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
140 | RDR21 | Sales Order - Document Reference Information | 15 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
141 | RIN21 | A/R Credit Memo - Document Reference Information | 15 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
142 | RPC21 | A/P Credit Memo - Document Reference Information | 15 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
143 | RPD21 | Goods Return - Document Reference Information | 15 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
144 | RRR21 | A/R Return Request - Document Reference Information | 15 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
145 | SFC21 | Self Credit Memo - Document Reference Information | 15 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
146 | SFI21 | Self Invoice - Document Reference Information | 15 | Series | Fiscal Document Series | nVarChar | 3 | 0 | | |
TOPService |
147 | ASCL | History | 60 | Series | Series | Int | 11 | 0 | | |
148 | OSCL | Service Calls | 60 | Series | Series | Int | 11 | 0 | | |