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