| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdministration |
1 | DAR1 | Data Archive - Transaction Log | 4 | DocNum | Document Number | Int | 11 | 0 | | |
2 | DAR2 | Data Archive - Transaction Log | 5 | DocNum | Document Number | Int | 11 | 0 | | |
3 | DAR3 | Data Archive - Handwritten Documents | 5 | DocNum | Document Number | Int | 11 | 0 | | |
4 | OCCD | Cargo Customs Declaration Numbers | 4 | DocNum | Imp./Exp. Document Number | nVarChar | 20 | 0 | | |
5 | OSRL | Serial Numbers | 4 | DocNum | Invoice Number | Int | 11 | 0 | | |
TOPBanking |
6 | ARC1 | Incoming Payment - Checks - History | 1 | DocNum | Document Number | Int | 11 | 0 | | |
7 | ARC2 | Incoming Payment - Invoices - History | 1 | DocNum | Document Number | Int | 11 | 0 | | |
8 | ARC3 | Credit Vouchers History | 1 | DocNum | Document No. | Int | 11 | 0 | | |
9 | ARC4 | Incoming Payment - Account List - History | 1 | DocNum | Document Number | Int | 11 | 0 | | |
10 | ARC5 | Reciept log vat adjustment-History | 1 | DocNum | Document No. - History | Int | 11 | 0 | | |
11 | ARC6 | Incoming Payments - WTax Rows - History | 1 | DocNum | Document Number | Int | 11 | 0 | | |
12 | ARC7 | Incoming Payments - Tax Amount per Document - History | 1 | DocNum | Document Number | Int | 11 | 0 | | |
13 | ARC8 | Incoming Payment - TDS Entries - History | 1 | DocNum | Document Number | Int | 11 | 0 | | |
14 | ARCT | Incoming Payment - History | 2 | DocNum | Document Number | Int | 11 | 0 | | |
15 | BNK2 | Bank Statement - Recommendation List | 19 | DocNum | Document Number | Int | 11 | 0 | | |
16 | OBNK | External Bank Statement Received | 20 | DocNum | Invoice Document | nVarChar | 27 | 0 | | |
17 | OPDF | Payment Draft | 2 | DocNum | Document Number | Int | 11 | 0 | | |
18 | ORCT | Incoming Payment | 2 | DocNum | Document Number | Int | 11 | 0 | | |
19 | OVPM | Outgoing Payments | 2 | DocNum | Document Number | Int | 11 | 0 | | |
20 | PDF1 | Payment Draft - Checks | 1 | DocNum | Document Number | Int | 11 | 0 | | |
21 | PDF2 | Payment Draft - Invoices | 1 | DocNum | Document Number | Int | 11 | 0 | | |
22 | PDF3 | Payment Draft - Credit Vouchers | 1 | DocNum | Document No. | Int | 11 | 0 | | |
23 | PDF4 | Payment Draft - Account List | 1 | DocNum | Document Number | Int | 11 | 0 | | |
24 | PDF5 | PaymentDraft - vat adjustment | 1 | DocNum | Document Number | Int | 11 | 0 | | |
25 | PDF6 | Payment Drafts - Withholding Tax - Rows | 1 | DocNum | Document Number | Int | 11 | 0 | | |
26 | PDF7 | Payment Draft - Tax Amount per Document | 1 | DocNum | Document Number | Int | 11 | 0 | | |
27 | PDF8 | Payment Draft - TDS Entries | 1 | DocNum | Document Number | Int | 11 | 0 | | |
28 | PEX1 | Payment Results Table - Rows | 26 | DocNum | Document Number | Int | 11 | 0 | | |
29 | PMN5 | Payment - VAT Adjustment | 1 | DocNum | Document Number | Int | 11 | 0 | | |
30 | PMV8 | Incoming Payment - TDS Entries | 1 | DocNum | Document Number | Int | 11 | 0 | | |
31 | PWZ3 | Payment Wizard - Rows 3 | 12 | DocNum | Document Number | Int | 11 | 0 | | |
32 | RCC4 | Incoming Payment - Credit Vouchers | 1 | DocNum | Document Number | Int | 11 | 0 | | |
33 | RCT1 | Incoming Payment - Checks | 1 | DocNum | Document Number | Int | 11 | 0 | | |
34 | RCT2 | Incoming Payments - Invoices | 1 | DocNum | Document Number | Int | 11 | 0 | | |
35 | RCT3 | Incoming Pmt - Credit Vouchers | 1 | DocNum | Document No. | Int | 11 | 0 | | |
36 | RCT4 | Incoming Payment - Account List | 1 | DocNum | Document Number | Int | 11 | 0 | | |
37 | RCT5 | Reciept vat adjustment | 1 | DocNum | Document Number | Int | 11 | 0 | | |
38 | RCT6 | Incoming Payments - WTax Rows | 1 | DocNum | Document Number | Int | 11 | 0 | | |
39 | RCT7 | Incoming Pmt - Tax Amount per Document | 1 | DocNum | Document Number | Int | 11 | 0 | | |
40 | RCT8 | Incoming Payment - TDS Entries | 1 | DocNum | Document Number | Int | 11 | 0 | | |
41 | TMP8 | Incoming Payment - TDS Entries | 1 | DocNum | Document Number | Int | 11 | 0 | | |
42 | VPM1 | Outgoing Payments - Check Rows | 1 | DocNum | Document Number | Int | 11 | 0 | | |
43 | VPM2 | Outgoing Payments - Invoices | 1 | DocNum | Document Number | Int | 11 | 0 | | |
44 | VPM3 | Outgoing Payments - Credit Vouchers | 1 | DocNum | Document No. | Int | 11 | 0 | | |
45 | VPM4 | Outgoing Payments - Accounts | 1 | DocNum | Document Number | Int | 11 | 0 | | |
46 | VPM5 | Outgoing Payments - Vat Adjustment | 1 | DocNum | Document Number | Int | 11 | 0 | | |
47 | VPM6 | Outgoing Payments - WTax Rows | 1 | DocNum | Document Number | Int | 11 | 0 | | |
48 | VPM7 | Outgoing Payments - Tax Amount per Document | 1 | DocNum | Document Number | Int | 11 | 0 | | |
49 | VPM8 | Outgoing Payment - TDS Entries | 1 | DocNum | Document Number | Int | 11 | 0 | | |
TOPBusiness Partners |
50 | ACLG | Activities - History | 15 | DocNum | Linked Document Number | nVarChar | 50 | 0 | | |
51 | OCLG | Activities | 15 | DocNum | Linked Document Number | nVarChar | 50 | 0 | | |
TOPFinance |
52 | AFAD | Asset Document - History | 2 | DocNum | Document Number | Int | 11 | 0 | | |
53 | AJD1 | Journal Entry - History - Rows | 131 | DocNum | Source Document Number | Int | 11 | 0 | | |
54 | BTF1 | Journal Voucher - Rows | 131 | DocNum | Source Document Number | Int | 11 | 0 | | |
55 | GBI7 | GBI Row 7 - Accounting Vouchers | 29 | DocNum | Document Number | nVarChar | 20 | 0 | | |
56 | ISW3 | Declaration Rows | 7 | DocNum | Document Number | Int | 11 | 0 | | |
57 | JDT1 | Journal Entry - Rows | 131 | DocNum | Source Document Number | Int | 11 | 0 | | |
58 | OACD | Credit Memo | 2 | DocNum | Document Number | Int | 11 | 0 | | |
59 | OACQ | Capitalization | 2 | DocNum | Document Number | Int | 11 | 0 | | |
60 | ODRN | Depreciation Run | 2 | DocNum | Document Number | Int | 11 | 0 | | |
61 | OFAR | Fixed Asset Revaluation | 2 | DocNum | Document Number | Int | 11 | 0 | | |
62 | OFTR | Transfer | 2 | DocNum | Document Number | Int | 11 | 0 | | |
63 | OMDP | Manual Depreciation | 2 | DocNum | Document Number | Int | 11 | 0 | | |
64 | ORTI | Retirement | 2 | DocNum | Document Number | Int | 11 | 0 | | |
TOPGeneral |
65 | AIRI | Input Service Distribution - Recipient Invoice | 2 | DocNum | Document Number | Int | 11 | 0 | | |
66 | AIRR | Input Service Distribution - Recipient Credit Memo | 2 | DocNum | Document Number | Int | 11 | 0 | | |
67 | AISC | Input Service Distribution - Credit Memo | 2 | DocNum | Document Number | Int | 11 | 0 | | |
68 | AISD | Input Service Distribution | 2 | DocNum | Document Number | Int | 11 | 0 | | |
69 | AISI | Input Service Distribution - Invoice | 2 | DocNum | Document Number | Int | 11 | 0 | | |
70 | APH4 | Project Management - Stages - Documents - History | 5 | DOCNUM | Document Number | Int | 11 | 0 | | |
71 | APH7 | Project Management - Workorders - History | 4 | DOCNUM | Document Number | Int | 11 | 0 | | |
72 | APM4 | Project Management - Stages - Documents - History | 5 | DOCNUM | Document Number | Int | 11 | 0 | | |
73 | APM7 | Project Management - Workorders - History | 4 | DOCNUM | Document Number | Int | 11 | 0 | | |
74 | APMG | Project Management Document - History | 6 | DocNum | Document Number | Int | 11 | 0 | | |
75 | ATSH | Project Management Time Sheet - Header - History | 3 | DocNum | Document Number | Int | 11 | 0 | | |
76 | OBTA | Brazil - Tax Adjustment | 4 | DocNum | Document Number | Int | 11 | 0 | | |
77 | OIRI | Input Service Distribution - Recipient Invoice | 2 | DocNum | Document Number | Int | 11 | 0 | | |
78 | OIRR | Input Service Distribution - Recipient Credit Memo | 2 | DocNum | Document Number | Int | 11 | 0 | | |
79 | OISC | Input Service Distribution - Credit Memo | 2 | DocNum | Document Number | Int | 11 | 0 | | |
80 | OISD | Input Service Distribution | 2 | DocNum | Document Number | Int | 11 | 0 | | |
81 | OISI | Input Service Distribution - Invoice | 2 | DocNum | Document Number | Int | 11 | 0 | | |
82 | OPMG | Project Management Document | 6 | DocNum | Document Number | Int | 11 | 0 | | |
83 | OTSH | Project Management Time Sheet - Header | 3 | DocNum | Document Number | Int | 11 | 0 | | |
84 | PHA4 | Project Management - Stages - Documents | 5 | DOCNUM | Document Number | Int | 11 | 0 | | |
85 | PHA7 | Project Management - Workorders | 4 | DOCNUM | Document Number | Int | 11 | 0 | | |
86 | PMG4 | Project Management - Stages - Documents | 5 | DOCNUM | Document Number | Int | 11 | 0 | | |
87 | PMG7 | Project Management - Workorders | 4 | DOCNUM | Document Number | Int | 11 | 0 | | |
TOPInventory and Production |
88 | AINC | Inventory Counting | 2 | DocNum | Document Number | Int | 11 | 0 | | |
89 | AIQI | Inventory Opening Balance | 16 | DocNum | Document Number | Int | 11 | 0 | | |
90 | AIQR | Inventory Posting | 16 | DocNum | Document Number | Int | 11 | 0 | | |
91 | AMRV | Inventory Revaluation - History | 2 | DocNum | Document Number | Int | 11 | 0 | | |
92 | AWOR | Production Order - History | 2 | DocNum | Document Number | Int | 11 | 0 | | |
93 | OENT | Shipping Types | 2 | DocNum | Document Number | Int | 11 | 0 | | |
94 | OICD | Inventory Counting Draft | 2 | DocNum | Document Number | Int | 11 | 0 | | |
95 | OIGE | Goods Issue | 2 | DocNum | Document Number | Int | 11 | 0 | | |
96 | OIGN | Goods Receipt | 2 | DocNum | Document Number | Int | 11 | 0 | | |
97 | OINC | Inventory Counting | 2 | DocNum | Document Number | Int | 11 | 0 | | |
98 | OIOD | Inventory Opening Balance Draft | 16 | DocNum | Document Number | Int | 11 | 0 | | |
99 | OIPD | Inventory Posting Draft | 16 | DocNum | Document Number | Int | 11 | 0 | | |
100 | OIPF | Landed Costs | 2 | DocNum | Document Number | Int | 11 | 0 | | |
101 | OIQI | Inventory Opening Balance | 16 | DocNum | Document Number | Int | 11 | 0 | | |
102 | OIQR | Inventory Posting | 16 | DocNum | Document Number | Int | 11 | 0 | | |
103 | OITL | Inventory Transactions Log | 9 | DocNum | Doc. Number | Int | 11 | 0 | | |
104 | OMRL | Advanced Inventory Revaluation | 2 | DocNum | Document Number | Int | 11 | 0 | | |
105 | OMRV | Inventory Revaluation | 2 | DocNum | Document Number | Int | 11 | 0 | | |
106 | ORTL | Resource Transaction Log | 20 | DocNum | Document Number | nVarChar | 11 | 0 | | |
107 | OTNL | CCD Log | 7 | DocNum | Doc Number | Int | 11 | 0 | | |
108 | OWOR | Production Order | 2 | DocNum | Document Number | Int | 11 | 0 | | |
109 | OWTQ | Inventory Transfer Request | 2 | DocNum | Document Number | Int | 11 | 0 | | |
110 | OWTR | Inventory Transfer | 2 | DocNum | Document Number | Int | 11 | 0 | | |
111 | UWOR | Production Order | 2 | DocNum | Document Number | Int | 11 | 0 | | |
TOPMarketing Documents |
112 | ADOC | Invoice - History | 2 | DocNum | Document Number | Int | 11 | 0 | | |
113 | ATXI | Tax Invoice - History | 2 | DocNum | Document Number | Int | 11 | 0 | | |
114 | DWZ2 | Dunning Wizard Array 2-Invoice Filter | 10 | DocNum | Doc. No. | Int | 11 | 0 | | |
115 | DWZ3 | Dunning Wizard Array 3 - Recommended Service Invoice | 20 | DocNum | Document Number | Int | 11 | 0 | | |
116 | DWZ4 | Dunning Wizard Array 4-Paging Grid | 11 | DocNum | Doc. No. | Int | 11 | 0 | | |
117 | GPA1 | Gross Profit Adjustment - Documents | 6 | DocNum | Document Number | Int | 11 | 0 | | |
118 | GPA5 | Product Cost Adjustment - Recalculation of Product Cost | 11 | DocNum | Document Number | Int | 11 | 0 | | |
119 | MIN1 | Monthly Invoice Report Document Information | 3 | DocNum | Document Number | Int | 11 | 0 | | |
120 | MIN2 | Item Imformation of MI | 2 | DocNum | Document Number | Int | 11 | 0 | | |
121 | MIV1 | A/P Monthly Invoice - Document | 3 | DocNum | Document Number | Int | 11 | 0 | | |
122 | MIV2 | A/P Monthly Invoice - Item | 2 | DocNum | Document Number | Int | 11 | 0 | | |
123 | OCIN | A/R Correction Invoice | 2 | DocNum | Document Number | Int | 11 | 0 | | |
124 | OCPI | A/P Correction Invoice | 2 | DocNum | Document Number | Int | 11 | 0 | | |
125 | OCPV | A/P Correction Invoice Reversal | 2 | DocNum | Document Number | Int | 11 | 0 | | |
126 | OCSI | A/R Correction Invoice | 2 | DocNum | Document Number | Int | 11 | 0 | | |
127 | OCSV | A/R Correction Invoice Reversal | 2 | DocNum | Document Number | Int | 11 | 0 | | |
128 | ODLN | Delivery | 2 | DocNum | Document Number | Int | 11 | 0 | | |
129 | ODPI | A/R Down Payment | 2 | DocNum | Document Number | Int | 11 | 0 | | |
130 | ODPO | A/P Down Payment | 2 | DocNum | Document Number | Int | 11 | 0 | | |
131 | ODRF | Drafts | 2 | DocNum | Document Number | Int | 11 | 0 | | |
132 | OIEI | Incoming Excise Invoice | 2 | DocNum | Document Number | Int | 11 | 0 | | |
133 | OINV | A/R Invoice | 2 | DocNum | Document Number | Int | 11 | 0 | | |
134 | OOEI | Outgoing Excise Invoice | 2 | DocNum | Document Number | Int | 11 | 0 | | |
135 | OPCH | A/P Invoice | 2 | DocNum | Document Number | Int | 11 | 0 | | |
136 | OPDN | Goods Receipt PO | 2 | DocNum | Document Number | Int | 11 | 0 | | |
137 | OPOR | Purchase Order | 2 | DocNum | Document Number | Int | 11 | 0 | | |
138 | OPQT | Purchase Quotation | 2 | DocNum | Document Number | Int | 11 | 0 | | |
139 | OPRQ | Purchase Request | 2 | DocNum | Document Number | Int | 11 | 0 | | |
140 | OPRR | Goods Return Request | 2 | DocNum | Document Number | Int | 11 | 0 | | |
141 | OQUT | Sales Quotation | 2 | DocNum | Document Number | Int | 11 | 0 | | |
142 | ORDN | Returns | 2 | DocNum | Document Number | Int | 11 | 0 | | |
143 | ORDR | Sales Order | 2 | DocNum | Document Number | Int | 11 | 0 | | |
144 | ORIN | A/R Credit Memo | 2 | DocNum | Document Number | Int | 11 | 0 | | |
145 | ORPC | A/P Credit Memo | 2 | DocNum | Document Number | Int | 11 | 0 | | |
146 | ORPD | Goods Return | 2 | DocNum | Document Number | Int | 11 | 0 | | |
147 | ORRR | Return Request | 2 | DocNum | Document Number | Int | 11 | 0 | | |
148 | OSAL | Outgoing | 2 | DocNum | Document Number | Int | 11 | 0 | | |
149 | OSFC | Self Credit Memo | 2 | DocNum | Document Number | Int | 11 | 0 | | |
150 | OSFI | Self Invoice | 2 | DocNum | Document Number | Int | 11 | 0 | | |
151 | OTPI | Purchase Tax Invoice | 2 | DocNum | Document Number | Int | 11 | 0 | | |
152 | OTRA | Transition | 2 | DocNum | Document Number | Int | 11 | 0 | | |
153 | OTSI | Sales Tax Invoice | 2 | DocNum | Document Number | Int | 11 | 0 | | |
154 | OTXD | Tax Invoice Draft | 2 | DocNum | Document Number | Int | 11 | 0 | | |
155 | TGPA | Gross Profit Adjustment - Log | 7 | DocNum | Document Number | Int | 11 | 0 | | |
TOPReports |
156 | AEC5 | List of Canceled Reconciliations for Actions in Electronic Communication | 5 | DocNum | Document Number | Int | 11 | 0 | | |
157 | ECM5 | List of Related Documents for Actions in Electronic Communication | 5 | DocNum | Document Number | Int | 11 | 0 | | |
158 | OEML | E-mail Log | 6 | DocNum | Document Number | Int | 11 | 0 | | |
159 | SOI4 | Statement of Import - Invoices | 5 | DocNum | Doc. No. | Int | 11 | 0 | | |
TOPSales Opportunities |
160 | AOPR | Opportunity | 47 | DocNum | Linked Document Number | Int | 11 | 0 | | |
161 | OOPR | Opportunity | 47 | DocNum | Linked Document Number | Int | 11 | 0 | | |
TOPService |
162 | ACTR | Service Contracts | 19 | DocNum | Source Document | Int | 11 | 0 | | |
163 | ASCL | History | 59 | DocNum | Document Number | Int | 11 | 0 | | |
164 | OCTR | Service Contracts | 19 | DocNum | Source Document | Int | 11 | 0 | | |
165 | OSCL | Service Calls | 59 | DocNum | Document Number | Int | 11 | 0 | | |