| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdministration |
1 | DAR1 | Data Archive - Transaction Log | 25 | CardCode | Card Code | nVarChar | 15 | 0 | | |
2 | DAR2 | Data Archive - Transaction Log | 7 | CardCode | Customer/Vendor Code | nVarChar | 15 | 0 | | |
3 | DGP1 | Customer List | 2 | CardCode | Customer Code | nVarChar | 15 | 0 | | |
4 | GPC1 | Authority Assignment | 4 | CardCode | Vendor Code | nVarChar | 15 | 0 | | |
5 | NFN4 | Manual Nota Fiscal Number | 9 | CardCode | Customer/Vendor Code | nVarChar | 15 | 0 | - | |
6 | OSRL | Serial Numbers | 3 | CardCode | Customer Code | nVarChar | 15 | 0 | | |
TOPBanking |
7 | ABOE | Bill of Exchange for Payment - History | 17 | CardCode | BP Code | nVarChar | 15 | 0 | | |
8 | ARCT | Incoming Payment - History | 9 | CardCode | BP Code | nVarChar | 15 | 0 | | |
9 | OBCG | Bank Charge for Bank Transfers | 1 | CardCode | BP Code | nVarChar | 15 | 0 | | |
10 | OBNK | External Bank Statement Received | 17 | CardCode | BP Code | nVarChar | 15 | 0 | | |
11 | OBOE | Bill of Exchange for Payment | 17 | CardCode | BP Code | nVarChar | 15 | 0 | | |
12 | OCHH | Check Register | 8 | CardCode | BP/Account Code | nVarChar | 15 | 0 | | |
13 | OCRH | Credit Card Management | 25 | CardCode | BP/Account Code | nVarChar | 15 | 0 | | |
14 | OCRV | Credit Payments | 19 | CardCode | BP/Account Code | nVarChar | 15 | 0 | | |
15 | OPDF | Payment Draft | 9 | CardCode | Customer/Vendor Code | nVarChar | 15 | 0 | | |
16 | OPWB | PWZ - Bank Account | 2 | CardCode | BP Code | nVarChar | 15 | 0 | | |
17 | ORCT | Incoming Payment | 9 | CardCode | Customer/Vendor Code | nVarChar | 15 | 0 | | |
18 | OVPM | Outgoing Payments | 9 | CardCode | Customer/Vendor Code | nVarChar | 15 | 0 | | |
19 | PWZ1 | Payment Wizard - Rows 1 | 2 | CardCode | BP Code | nVarChar | 15 | 0 | | |
20 | PWZ3 | Payment Wizard - Rows 3 | 3 | CardCode | Vendor Code | nVarChar | 15 | 0 | | |
21 | PWZ4 | Payment Wizard - Rows 4 | 3 | CardCode | Vendor's Card code | nVarChar | 15 | 0 | | |
22 | PWZ5 | Payment Wizard - Rows 5 | 4 | CardCode | Card Code | nVarChar | 15 | 0 | | |
23 | RTW1 | Boleto Retorno Wizard: Import Table | 43 | CardCode | BoE BP Code | nVarChar | 15 | 0 | | |
TOPBusiness Partners |
24 | ACLG | Activities - History | 2 | CardCode | BP Code | nVarChar | 15 | 0 | | |
25 | ACPR | Contact Persons - History | 2 | CardCode | BP Code | nVarChar | 15 | 0 | | |
26 | ACR1 | Business Partner Addresses - History | 2 | CardCode | BP Code | nVarChar | 15 | 0 | | |
27 | ACR11 | BP Tributary Info. | 1 | CardCode | BP Code | nVarChar | 25 | 0 | | |
28 | ACR12 | BP eDoc Settings | 1 | CardCode | BP Code | nVarChar | 15 | 0 | | |
29 | ACR2 | Bussiness Partners - Payment Methods-History | 1 | CardCode | BP Code | nVarChar | 15 | 0 | | |
30 | ACR3 | Business Partner Control Accounts - History | 1 | CardCode | BP Code | nVarChar | 15 | 0 | | |
31 | ACR4 | Allowed WTax Codes for BP - History | 1 | CardCode | BP Code | nVarChar | 15 | 0 | | |
32 | ACR5 | BP Payment Dates | 1 | CardCode | BP Code | nVarChar | 15 | 0 | | |
33 | ACR7 | Fiscal IDs for BP Master Data | 1 | CardCode | BP Code | nVarChar | 25 | 0 | | |
34 | ACRB | Business Partner Bank Accounts - History | 2 | CardCode | BP Code | nVarChar | 15 | 0 | | |
35 | ACRD | Business Partners - History | 1 | CardCode | BP Code | nVarChar | 15 | 0 | | |
36 | CRD1 | Business Partners - Addresses | 2 | CardCode | BP Code | nVarChar | 15 | 0 | | |
37 | CRD11 | BP Tributary Info. | 1 | CardCode | BP Code | nVarChar | 25 | 0 | | |
38 | CRD12 | BP eDoc Settings | 1 | CardCode | BP Code | nVarChar | 15 | 0 | | |
39 | CRD2 | Bussiness Partners - Payment Methods | 1 | CardCode | BP Code | nVarChar | 15 | 0 | | |
40 | CRD3 | BP Control Account | 1 | CardCode | BP Code | nVarChar | 15 | 0 | | |
41 | CRD4 | Allowed WTax Codes for BP | 1 | CardCode | BP Code | nVarChar | 15 | 0 | | |
42 | CRD5 | BP Payment Dates | 1 | CardCode | BP Code | nVarChar | 15 | 0 | | |
43 | CRD6 | BP's Payer Name | 1 | CardCode | BP Code | nVarChar | 15 | 0 | | |
44 | CRD7 | Fiscal IDs for BP Master Data | 1 | CardCode | BP Code | nVarChar | 25 | 0 | | |
45 | CRD8 | BP Branch Assignment | 1 | CardCode | BP Code | nVarChar | 15 | 0 | | |
46 | CRD9 | OCRD Extension | 1 | CardCode | BP Code | nVarChar | 25 | 0 | | |
47 | OCLG | Activities | 2 | CardCode | BP Code | nVarChar | 15 | 0 | | |
48 | OCPR | Contact Persons | 2 | CardCode | BP Code | nVarChar | 15 | 0 | | |
49 | OCRB | BP - Bank Account | 2 | CardCode | BP Code | nVarChar | 15 | 0 | | |
50 | OCRD | Business Partner | 1 | CardCode | BP Code | nVarChar | 15 | 0 | | |
51 | OCRW | BP for IIS Annual | 2 | CardCode | BP Code | nVarChar | 15 | 0 | | |
52 | ODDT | Withholding Tax Deduction Hierarchy | 2 | CardCode | BP Code | nVarChar | 15 | 0 | | |
53 | OSCN | Customer/Vendor Cat. No. | 2 | CardCode | BP Code | nVarChar | 15 | 0 | | |
54 | OTBP | Target Group Business Partner | 1 | CardCode | BP Code | nVarChar | 15 | 0 | | |
55 | TGG1 | Target Group Details | 2 | CardCode | BP Code | nVarChar | 15 | 0 | | |
TOPFinance |
56 | AGAR | G/L Account Advanced Rules - History | 81 | CardCode | Customer/Vendor Code | nVarChar | 15 | 0 | | |
57 | ISW1 | Reported Business Partners | 2 | CardCode | Business Partner Code | nVarChar | 15 | 0 | | |
58 | ISW3 | Declaration Rows | 5 | CardCode | Business Partner Code | nVarChar | 15 | 0 | | |
59 | OACM | Accumulation | 2 | CardCode | Customer/Vendor Code | nVarChar | 15 | 0 | | |
60 | OGAR | G/L Account Advanced Rules | 81 | CardCode | Customer/Vendor Code | nVarChar | 15 | 0 | | |
61 | OWTA | Withholding Tax Accumulation | 2 | CardCode | BP Code | nVarChar | 15 | 0 | | |
62 | RTM2 | Rate Differences - SC Adjustment Rows | 3 | CardCode | BP Code | nVarChar | 15 | 0 | | |
63 | VRW3 | VAT Reposting Wizard - Rows 3 | 2 | CardCode | Customer/Vendor Code | nVarChar | 15 | 0 | | |
TOPGeneral |
64 | AGRS | G/L Account Advanced Rules for Resources - History | 54 | CardCode | Customer/Vendor Code | nVarChar | 15 | 0 | | |
65 | APMG | Project Management Document - History | 9 | CARDCODE | BP Code | nVarChar | 15 | 0 | | |
66 | ARSC | Resource Master Data - Log | 14 | CardCode | Preferred Vendor | nVarChar | 15 | 0 | | |
67 | CRDC | BP - Communication Means | 1 | CardCode | BP Code | nVarChar | 15 | 0 | | |
68 | OGRS | G/L Account Advanced Rules for Resources | 54 | CardCode | Customer/Vendor Code | nVarChar | 15 | 0 | | |
69 | OPMG | Project Management Document | 9 | CARDCODE | BP Code | nVarChar | 15 | 0 | | |
70 | ORSC | Resources | 14 | CardCode | Preferred Vendor | nVarChar | 15 | 0 | | |
71 | OSWA | Specific Withholding Amounts | 2 | CardCode | BP Code | nVarChar | 15 | 0 | | |
72 | OTCN | Tracking Note | 7 | CardCode | BP Code | nVarChar | 15 | 0 | | |
73 | TCN2 | Tracking Note - Brokers | 3 | CardCode | BP Code | nVarChar | 15 | 0 | | |
TOPInventory and Production |
74 | AITM | Items - History | 19 | CardCode | Preferred Vendor | nVarChar | 15 | 0 | | |
75 | AMRV | Inventory Revaluation - History | 30 | CardCode | Customer/Vendor Code | nVarChar | 15 | 0 | | |
76 | AQI1 | Inventory Opening Balance - Rows | 30 | CardCode | Preferred Vendor | nVarChar | 15 | 0 | | |
77 | AQR1 | Inventory Posting - Rows | 29 | CardCode | Preferred Vendor | nVarChar | 15 | 0 | | |
78 | ASP1 | Special Prices - Data Areas | 2 | CardCode | BP Code | nVarChar | 15 | 0 | | |
79 | ASP2 | Special Prices - Quantity Areas | 2 | CardCode | BP Code | nVarChar | 15 | 0 | | |
80 | ASPP | Special Prices | 2 | CardCode | BP Code | nVarChar | 15 | 0 | | |
81 | AWOR | Production Order - History | 19 | CardCode | Customer Code | nVarChar | 15 | 0 | | |
82 | IOD1 | Inventory Opening Balance Draft - Rows | 30 | CardCode | Preferred Vendor | nVarChar | 15 | 0 | | |
83 | IPD1 | Inventory Posting Draft - Rows | 29 | CardCode | Preferred Vendor | nVarChar | 15 | 0 | | |
84 | IPF1 | Landed Costs - Rows | 25 | CardCode | Vendor Code | nVarChar | 15 | 0 | | |
85 | IQI1 | Inventory Opening Balance - Rows | 30 | CardCode | Preferred Vendor | nVarChar | 15 | 0 | | |
86 | IQR1 | Inventory Posting - Rows | 29 | CardCode | Preferred Vendor | nVarChar | 15 | 0 | | |
87 | OENT | Shipping Types | 8 | CardCode | BP Code | nVarChar | 15 | 0 | | |
88 | OIGE | Goods Issue | 13 | CardCode | Expense Account | nVarChar | 15 | 0 | | |
89 | OIGN | Goods Receipt | 13 | CardCode | Revenue Account | nVarChar | 15 | 0 | | |
90 | OIPF | Landed Costs | 5 | CardCode | Vendor Code | nVarChar | 15 | 0 | | |
91 | OITL | Inventory Transactions Log | 17 | CardCode | BP Code | nVarChar | 15 | 0 | | |
92 | OITM | Items | 19 | CardCode | Preferred Vendor | nVarChar | 15 | 0 | | |
93 | OMRV | Inventory Revaluation | 30 | CardCode | Customer/Vendor Code | nVarChar | 15 | 0 | | |
94 | OSPG | Special Prices for Groups | 1 | CardCode | BP Code | nVarChar | 15 | 0 | | |
95 | OSPP | Special Prices | 2 | CardCode | BP Code | nVarChar | 15 | 0 | | |
96 | OWKO | Production Instructions | 9 | CardCode | Sold-to Party Code | nVarChar | 15 | 0 | | |
97 | OWOR | Production Order | 19 | CardCode | Customer Code | nVarChar | 15 | 0 | | |
98 | OWTQ | Inventory Transfer Request | 13 | CardCode | Customer/Vendor Code | nVarChar | 15 | 0 | | |
99 | OWTR | Inventory Transfer | 13 | CardCode | Customer/Vendor Code | nVarChar | 15 | 0 | | |
100 | SITM | Items | 19 | CardCode | Preferred Vendor | nVarChar | 15 | 0 | | |
101 | SPP1 | Special Prices - Data Areas | 2 | CardCode | BP Code | nVarChar | 15 | 0 | | |
102 | SPP2 | Special Prices - Quantity Areas | 2 | CardCode | BP Code | nVarChar | 15 | 0 | | |
103 | UITM | Items | 19 | CardCode | Preferred Vendor | nVarChar | 15 | 0 | | |
104 | UWKO | Production Instructions | 9 | CardCode | Sold-To-Party Code | nVarChar | 15 | 0 | | |
105 | UWOR | Production Order | 19 | CardCode | Customer Code | nVarChar | 15 | 0 | | |
106 | WOR2V | Production Order - Base | 4 | CardCode | Customer Code | nVarChar | 15 | 0 | | |
TOPMarketing Documents |
107 | ADOC | Invoice - History | 13 | CardCode | BP Code | nVarChar | 15 | 0 | | |
108 | ATX3 | Tax Invoice Archive - Document Reference Information | 11 | CardCode | Business Partner | nVarChar | 15 | 0 | | |
109 | ATXI | Tax Invoice - History | 10 | CardCode | Customer Code | nVarChar | 15 | 0 | | |
110 | DWZ1 | Dunning Wizard Array1 - BP Filter | 2 | CardCode | BP Card Code | nVarChar | 15 | 0 | | |
111 | DWZ2 | Dunning Wizard Array 2-Invoice Filter | 2 | CardCode | BP Card Code | nVarChar | 15 | 0 | | |
112 | DWZ3 | Dunning Wizard Array 3 - Recommended Service Invoice | 2 | CardCode | BP Card Code | nVarChar | 15 | 0 | | |
113 | DWZ4 | Dunning Wizard Array 4-Paging Grid | 5 | CardCode | BP Card Code | nVarChar | 15 | 0 | | |
114 | OCIN | A/R Correction Invoice | 13 | CardCode | Customer/Vendor Code | nVarChar | 15 | 0 | | |
115 | OCPI | A/P Correction Invoice | 13 | CardCode | Customer/Vendor Code | nVarChar | 15 | 0 | | |
116 | OCPV | A/P Correction Invoice Reversal | 13 | CardCode | Customer/Vendor Code | nVarChar | 15 | 0 | | |
117 | OCSI | A/R Correction Invoice | 13 | CardCode | Customer/Vendor Code | nVarChar | 15 | 0 | | |
118 | OCSV | A/R Correction Invoice Reversal | 13 | CardCode | Customer/Vendor Code | nVarChar | 15 | 0 | | |
119 | ODLN | Delivery | 13 | CardCode | Customer/Vendor Code | nVarChar | 15 | 0 | | |
120 | ODPI | A/R Down Payment | 13 | CardCode | Customer/Vendor Code | nVarChar | 15 | 0 | | |
121 | ODPO | A/P Down Payment | 13 | CardCode | Customer/Vendor Code | nVarChar | 15 | 0 | | |
122 | ODRF | Drafts | 13 | CardCode | BP Code | nVarChar | 15 | 0 | | |
123 | OIEI | Incoming Excise Invoice | 13 | CardCode | Customer/Vendor Code | nVarChar | 15 | 0 | | |
124 | OINV | A/R Invoice | 13 | CardCode | Customer/Vendor Code | nVarChar | 15 | 0 | | |
125 | OOEI | Outgoing Excise Invoice | 13 | CardCode | Customer/Vendor Code | nVarChar | 15 | 0 | | |
126 | OPCH | A/P Invoice | 13 | CardCode | Customer/Vendor Code | nVarChar | 15 | 0 | | |
127 | OPDN | Goods Receipt PO | 13 | CardCode | Customer/Vendor Code | nVarChar | 15 | 0 | | |
128 | OPOR | Purchase Order | 13 | CardCode | Customer/Vendor Code | nVarChar | 15 | 0 | | |
129 | OPQT | Purchase Quotation | 13 | CardCode | Customer/Vendor Code | nVarChar | 15 | 0 | | |
130 | OPRQ | Purchase Request | 13 | CardCode | Customer/Vendor Code | nVarChar | 15 | 0 | | |
131 | OPRR | Goods Return Request | 13 | CardCode | Customer/Vendor Code | nVarChar | 15 | 0 | | |
132 | OQUT | Sales Quotation | 13 | CardCode | Customer/Vendor Code | nVarChar | 15 | 0 | | |
133 | ORDN | Returns | 13 | CardCode | Customer/Vendor Code | nVarChar | 15 | 0 | | |
134 | ORDR | Sales Order | 13 | CardCode | Customer/Vendor Code | nVarChar | 15 | 0 | | |
135 | ORIN | A/R Credit Memo | 13 | CardCode | Customer/Vendor Code | nVarChar | 15 | 0 | | |
136 | ORPC | A/P Credit Memo | 13 | CardCode | Customer/Vendor Code | nVarChar | 15 | 0 | | |
137 | ORPD | Goods Return | 13 | CardCode | Customer/Vendor Code | nVarChar | 15 | 0 | | |
138 | ORRR | Return Request | 13 | CardCode | Customer/Vendor Code | nVarChar | 15 | 0 | | |
139 | OSAL | Outgoing | 8 | CardCode | BP Code | nVarChar | 15 | 0 | | |
140 | OSFC | Self Credit Memo | 13 | CardCode | Customer/Vendor Code | nVarChar | 15 | 0 | | |
141 | OSFI | Self Invoice | 13 | CardCode | Customer/Vendor Code | nVarChar | 15 | 0 | | |
142 | OTPI | Purchase Tax Invoice | 10 | CardCode | Customer Code | nVarChar | 15 | 0 | | |
143 | OTRA | Transition | 8 | CardCode | BP Code | nVarChar | 15 | 0 | | |
144 | OTSI | Sales Tax Invoice | 10 | CardCode | Customer Code | nVarChar | 15 | 0 | | |
145 | OTXD | Tax Invoice Draft | 10 | CardCode | Customer Code | nVarChar | 15 | 0 | | |
146 | OVRT | Tax Invoice Report | 4 | CardCode | Receipt BP Code | nVarChar | 15 | 0 | | |
147 | TPI3 | Purchase Tax Invoice - Document Reference Information | 11 | CardCode | Business Partner | nVarChar | 15 | 0 | | |
148 | TSI3 | Sales Tax Invoice - Document Reference Information | 11 | CardCode | Business Partner | nVarChar | 15 | 0 | | |
149 | TXD3 | Tax Invoice Draft - Document Reference Information | 11 | CardCode | Business Partner | nVarChar | 15 | 0 | | |
TOPMRP |
150 | ORCM | Recommendation Data | 9 | CardCode | Preferred Vendor | nVarChar | 15 | 0 | | |
TOPReports |
151 | AMD1 | Amout Differences Report Lines | 5 | CardCode | BP Code | nVarChar | 15 | 0 | | |
152 | OAMD | Amount Differences Report | 4 | CardCode | BP Code | nVarChar | 15 | 0 | | |
153 | OEML | E-mail Log | 2 | CardCode | BP Code | nVarChar | 15 | 0 | | |
154 | RDFL | Document Standards | 4 | CardCode | BP Code | nVarChar | 15 | 0 | -1 | |
155 | SOI1 | Statement of Import - Business Partners | 2 | CardCode | BP Card Code | nVarChar | 15 | 0 | | |
156 | SOI3 | Statement of Import - Invoices | 5 | CardCode | Customer/Vendor Code | nVarChar | 15 | 0 | | |
157 | SRT2 | Korean Summary Report - Rows2 | 4 | CardCode | BP Code on OCRD | nVarChar | 15 | 0 | | |
158 | TRB5 | Tax Report Wizard Reported Tax Sums | 3 | CardCode | Vendor Code | nVarChar | 15 | 0 | | |
TOPSales Opportunities |
159 | AOPR | Opportunity | 2 | CardCode | BP Code | nVarChar | 15 | 0 | | |
160 | OOPR | Opportunity | 2 | CardCode | BP Code | nVarChar | 15 | 0 | | |