| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdministration |
1 | AADM | Administration - Log | 313 | UserSign2 | Updating User | Int | 6 | 0 | | |
2 | AADP | Print Preferences | 30 | UserSign2 | Updating User | Int | 6 | 0 | | |
3 | ACFP | CFOP for Nota Fiscal | 9 | UserSign2 | Updating User | Int | 6 | 0 | | |
4 | ACRC | Credit Cards | 12 | UserSign2 | Updating User | Int | 6 | 0 | | |
5 | AEXD | Freight Setup | 34 | UserSign2 | Updating User | Int | 6 | 0 | | |
6 | AFML | Tax Formula Master Table | 7 | UserSign2 | Updating User | Int | 6 | 0 | | |
7 | AINF | Company Info | 188 | UserSign2 | Updating User | Int | 6 | 0 | | |
8 | ANCM | NCM Code | 5 | UserSign2 | Updating User | Int | 6 | 0 | | |
9 | ASTC | Sales Tax Codes | 15 | UserSign2 | Updating User | Int | 6 | 0 | | |
10 | ATSC | CST Code for Nota Fiscal | 11 | UserSign2 | Updating User | Int | 6 | 0 | | |
11 | AUSR | Archive Users - History | 70 | userSign2 | Updating User | Int | 6 | 0 | | |
12 | CINF | Company Info | 188 | UserSign2 | Updating User | Int | 6 | 0 | | |
13 | OADM | Administration | 313 | UserSign2 | Updating User | Int | 6 | 0 | | |
14 | OADP | Print Preferences | 30 | UserSign2 | Updating User | Int | 6 | 0 | | |
15 | OCFP | CFOP for Nota Fiscal | 9 | UserSign2 | Updating User | Int | 6 | 0 | | |
16 | OCRC | Credit Cards | 12 | UserSign2 | Updating User | Int | 6 | 0 | | |
17 | OCRN | Currency Codes | 12 | UserSign2 | Updating User | Int | 6 | 0 | | |
18 | OEXD | Freight Setup | 34 | UserSign2 | Updating User | Int | 6 | 0 | | |
19 | OFML | Tax Formula Master Table | 7 | UserSign2 | Updating User | Int | 6 | 0 | | |
20 | ONCM | NCM Code | 5 | UserSign2 | Updating User | Int | 6 | 0 | | |
21 | OSTC | Sales Tax Codes | 15 | UserSign2 | Updating User | Int | 6 | 0 | | |
22 | OTSC | CST Code for Nota Fiscal | 11 | UserSign2 | Updating User | Int | 6 | 0 | | |
23 | OUSR | Users | 70 | userSign2 | Updating User - History | Int | 6 | 0 | | |
TOPBanking |
24 | ABOC | External Bank Operation Code - Log | 6 | UserSign2 | Updating User | Int | 6 | 0 | | |
25 | ABOE | Bill of Exchange for Payment - History | 77 | UserSign2 | Updating User | Int | 6 | 0 | | |
26 | ABTC | Internal Bank Operation Codes - | 17 | UserSign2 | Updating User | Int | 6 | 0 | | |
27 | ADS1 | House Bank Accounts | 63 | UserSign2 | Updating User | Int | 6 | 0 | | |
28 | ARCT | Incoming Payment - History | 150 | UserSign2 | Updating User | Int | 6 | 0 | | |
29 | DSC1 | House Bank Accounts | 63 | UserSign2 | Updating User | Int | 6 | 0 | | |
30 | OBOC | External Bank Operation Code Category | 6 | UserSign2 | Updating User | Int | 6 | 0 | | |
31 | OBOE | Bill of Exchange for Payment | 77 | UserSign2 | Updating User | Int | 6 | 0 | | |
32 | OBTC | Internal Bank Operation Codes | 17 | UserSign2 | Updating User | Int | 6 | 0 | | |
33 | OPDF | Payment Draft | 150 | UserSign2 | Updating User | Int | 6 | 0 | | |
34 | ORCT | Incoming Payment | 150 | UserSign2 | Updating User | Int | 6 | 0 | | |
35 | OVPM | Outgoing Payments | 150 | UserSign2 | Updating User | Int | 6 | 0 | | |
TOPBusiness Partners |
36 | ABPL | Business Place | 14 | UserSign2 | Updating User | Int | 6 | 0 | | |
37 | ACPN | Campaign | 15 | UserSign2 | Updating User - History | Int | 6 | 0 | | |
38 | ACRD | Business Partners - History | 274 | UserSign2 | Updating User | Int | 6 | 0 | | |
39 | AOAT | Blanket Agreement | 20 | UserSign2 | User Signature 2 | Int | 6 | 0 | | |
40 | OBPL | Business Place | 14 | UserSign2 | Updating User | Int | 6 | 0 | | |
41 | OCPN | Campaign | 15 | UserSign2 | Updating User - History | Int | 6 | 0 | | |
42 | OCRD | Business Partner | 274 | UserSign2 | Updating User | Int | 6 | 0 | | |
43 | OOAT | Blanket Agreement | 20 | UserSign2 | User Signature 2 | Int | 6 | 0 | | |
44 | OSCN | Customer/Vendor Cat. No. | 7 | UserSign2 | Updating User | Int | 6 | 0 | | |
TOPFinance |
45 | AACP | Periods Category-Log | 134 | UserSign2 | Updating User | Int | 6 | 0 | | |
46 | AACT | G/L Account - History | 91 | UserSign2 | Updating User | Int | 6 | 0 | | |
47 | AFPR | Posting Period-Log | 25 | UserSign2 | Updating User | Int | 6 | 0 | | |
48 | AJDT | Journal Entry - History | 28 | UserSign2 | Updated by | Int | 6 | 0 | | |
49 | AMDR | Manual Distribution Rule | 12 | UserSign2 | Updating User | Int | 6 | 0 | | |
50 | AMDR1 | Manual Distribution Rule - Rows | 10 | UserSign2 | Updating User | Int | 6 | 0 | | |
51 | AVTG | Tax Definition | 33 | UserSign2 | Updating User | Int | 6 | 0 | | |
52 | AWHT | Withholding Tax | 34 | UserSign2 | Updating User | Int | 6 | 0 | | |
53 | MDR1 | Manual Distribution Rule - Rows | 10 | UserSign2 | Updating User | Int | 6 | 0 | | |
54 | OACP | Periods Category | 134 | UserSign2 | Updating User | Int | 6 | 0 | | |
55 | OACT | G/L Accounts | 91 | UserSign2 | Updating User | Int | 6 | 0 | | |
56 | OBTF | Journal Voucher Entry | 28 | UserSign2 | Updating User | Int | 6 | 0 | | |
57 | OFPR | Posting Period | 25 | UserSign2 | Updating User | Int | 6 | 0 | | |
58 | OIWZ | Inflation Wizard | 34 | userSign2 | Updating User | Int | 6 | 0 | | |
59 | OJDT | Journal Entry | 28 | UserSign2 | Updating User | Int | 6 | 0 | | |
60 | OMDR | Manual Distribution Rule | 12 | UserSign2 | Updating User | Int | 6 | 0 | | |
61 | ONFM | Nota Fiscal Model | 5 | UserSign2 | Updating User | Int | 6 | 0 | | |
62 | OSCM | Special Ledger - Analytical Accounting Configuration Rules: Material | 10 | UserSign2 | Rule Changed By | Int | 6 | 0 | | |
63 | OSCR | Special Ledger - Analytical Accounting Configuration Rules: Revenues & Expenses | 10 | UserSign2 | Rule Changed By | Int | 6 | 0 | | |
64 | OVTG | Tax Definition | 33 | UserSign2 | Updating User | Int | 6 | 0 | | |
65 | OWHT | Withholding Tax | 34 | UserSign2 | Updating User | Int | 6 | 0 | | |
TOPHuman Resources |
66 | AHEM | Employees | 97 | UserSign2 | Updating User | Int | 6 | 0 | | |
67 | OHEM | Employees | 97 | UserSign2 | Updating User | Int | 6 | 0 | | |
TOPInventory and Production |
68 | ABTN | Batch Numbers Master Data | 23 | UserSign2 | Updating User | Int | 6 | 0 | | |
69 | ABTW | Batch Attributes in Location | 13 | UserSign2 | Updating User | Int | 6 | 0 | | |
70 | ADNF | DNF Code | 7 | UserSign2 | Updating User | Int | 6 | 0 | | |
71 | AITB | Item Groups - History | 50 | userSign2 | Updating User - History | Int | 6 | 0 | | |
72 | AITM | Items - History | 249 | UserSign2 | Updating User | Int | 6 | 0 | | |
73 | AITT | Product Tree - History | 16 | UserSign2 | Updating User | Int | 11 | 0 | | |
74 | AITW | Items - Warehouse - History | 51 | userSign2 | Updating User - History | Int | 6 | 0 | | |
75 | AMGP | Material Group | 5 | UserSign2 | Updating User | Int | 6 | 0 | | |
76 | AMRV | Inventory Revaluation - History | 17 | UserSign2 | Updating User | Int | 6 | 0 | | |
77 | APKL | Pick List - History | 16 | UserSign2 | Updating User | Int | 6 | 0 | | |
78 | ASRN | Serial Numbers Master Data | 23 | UserSign2 | Updating User | Int | 6 | 0 | | |
79 | AWHS | Warehouses - History | 57 | userSign2 | Updating User - History | Int | 6 | 0 | | |
80 | AWOR | Production Order - History | 39 | UserSign2 | Updating User | Int | 6 | 0 | | |
81 | OBTN | Batch Numbers Master Data | 23 | UserSign2 | Updating User | Int | 6 | 0 | | |
82 | OBTW | Batch Attributes in Location | 13 | UserSign2 | Updating User | Int | 6 | 0 | | |
83 | ODBN | Bat. Nos - Draft - Master Data | 23 | UserSign2 | Updating User | Int | 6 | 0 | | |
84 | ODBW | Batch Draft Attribs in Locat. | 13 | UserSign2 | Updating User | Int | 6 | 0 | | |
85 | ODNF | DNF Code | 7 | UserSign2 | Updating User | Int | 6 | 0 | | |
86 | ODSN | SNs - Draft - Master Data | 23 | UserSign2 | Updating User | Int | 6 | 0 | | |
87 | ODSW | SN Draft Attribs in Location | 13 | UserSign2 | Updating User | Int | 6 | 0 | | |
88 | OIGE | Goods Issue | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
89 | OIGN | Goods Receipt | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
90 | OITB | Item Groups | 50 | userSign2 | Updating User - History | Int | 6 | 0 | | |
91 | OITM | Items | 249 | UserSign2 | Updating User | Int | 6 | 0 | | |
92 | OITT | Product Tree | 16 | UserSign2 | Updating User | Int | 11 | 0 | | |
93 | OITW | Items - Warehouse | 51 | userSign2 | Updating User - History | Int | 6 | 0 | | |
94 | OMGP | Material Group | 5 | UserSign2 | Updating User | Int | 6 | 0 | | |
95 | OMRL | Advanced Inventory Revaluation | 25 | UserSign2 | Updating User | Int | 6 | 0 | | |
96 | OMRV | Inventory Revaluation | 17 | UserSign2 | Updating User | Int | 6 | 0 | | |
97 | OPKL | Pick List | 16 | UserSign2 | Updating User | Int | 6 | 0 | | |
98 | OSRN | Serial Numbers Master Data | 23 | UserSign2 | Updating User | Int | 6 | 0 | | |
99 | OSRW | Serial No. Attribs in Location | 13 | UserSign2 | Updating User | Int | 6 | 0 | | |
100 | OWHS | Warehouses | 57 | userSign2 | Updating User - History | Int | 6 | 0 | | |
101 | OWOR | Production Order | 39 | UserSign2 | Updating User | Int | 6 | 0 | | |
102 | OWTQ | Inventory Transfer Request | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
103 | OWTR | Inventory Transfer | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
104 | SITM | Items | 249 | UserSign2 | Updating User | Int | 6 | 0 | | |
105 | SITW | Items - Warehouse | 51 | userSign2 | Updating User - History | Int | 6 | 0 | | |
106 | UITM | Items | 249 | UserSign2 | Updating User | Int | 6 | 0 | | |
107 | UITW | Items - Warehouse | 51 | userSign2 | Updating User - History | Int | 6 | 0 | | |
108 | UWOR | Production Order | 39 | UserSign2 | Updating User | Int | 6 | 0 | | |
TOPMarketing Documents |
109 | ADOC | Invoice - History | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
110 | ATXI | Tax Invoice - History | 27 | UserSign2 | Updating User | Int | 6 | 0 | | |
111 | OCIN | A/R Correction Invoice | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
112 | OCPI | A/P Correction Invoice | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
113 | OCPV | A/P Correction Invoice Reversal | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
114 | OCSI | A/R Correction Invoice | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
115 | OCSV | A/R Correction Invoice Reversal | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
116 | ODLN | Delivery | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
117 | ODPI | A/R Down Payment | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
118 | ODPO | A/P Down Payment | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
119 | ODRF | Drafts | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
120 | OIEI | Incoming Excise Invoice | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
121 | OINV | A/R Invoice | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
122 | OOEI | Outgoing Excise Invoice | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
123 | OPCH | A/P Invoice | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
124 | OPDN | Goods Receipt PO | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
125 | OPOR | Purchase Order | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
126 | OPQT | Purchase Quotation | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
127 | OQUT | Sales Quotation | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
128 | ORDN | Returns | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
129 | ORDR | Sales Order | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
130 | ORIN | A/R Credit Memo | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
131 | ORPC | A/P Credit Memo | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
132 | ORPD | Goods Return | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
133 | OTPI | Purchase Tax Invoice | 27 | UserSign2 | Updating User | Int | 6 | 0 | | |
134 | OTSI | Sales Tax Invoice | 27 | UserSign2 | Updating User | Int | 6 | 0 | | |
135 | OTXD | Tax Invoice Draft | 27 | UserSign2 | Updating User | Int | 6 | 0 | | |
TOPReports |
136 | OTWS | E-Tax Web Site | 6 | UserSign2 | Updating User | Int | 6 | 0 | | |
137 | RDOC | Document | 55 | UserSign2 | Updating User | Int | 6 | 0 | | |
TOPSales Opportunities |
138 | AOC1 | Distribution Rule - Rows | 10 | UserSign2 | Updating User | Int | 6 | 0 | | |
139 | AOCR | Distribution Rule | 12 | UserSign2 | Updating User | Int | 6 | 0 | | |
140 | OCR1 | Distribution Rule - Rows | 10 | UserSign2 | Updating User | Int | 6 | 0 | | |
141 | OOCR | Distribution Rule | 12 | UserSign2 | Updating User | Int | 6 | 0 | | |
TOPService |
142 | AINS | Customer Equipment Card - History | 40 | userSign2 | Updating User | Int | 6 | 0 | | |
143 | ASC1 | Service Call Solutions - History | 8 | userSign2 | Updating User - History | Int | 6 | 0 | | |
144 | ASC2 | Service Call Inventory Expenses - History | 16 | UserSign2 | User Signature 2 - History | Int | 6 | 0 | | |
145 | ASC3 | Service Call Travel/Labor Expenses - History | 16 | UserSign2 | User Signature 2 | Int | 6 | 0 | | |
146 | ASC4 | Service Call Travel/Labor Expenses - History | 11 | UserSign2 | User Signature 2 | Int | 6 | 0 | | |
147 | ASC5 | Service Call Activities - History | 8 | UserSign2 | User Signature 2 | Int | 6 | 0 | | |
148 | ASCL | History | 31 | userSign2 | Updating User | Int | 6 | 0 | | |
149 | ASGP | Service Group for Brazil | 5 | UserSign2 | Updating User | Int | 6 | 0 | | |
150 | ATHL | Thresholds | 9 | UserSign2 | Updating User | Int | 6 | 0 | | |
151 | OINS | Customer Equipment Card | 40 | userSign2 | Updating User | Int | 6 | 0 | | |
152 | OSCL | Service Calls | 31 | userSign2 | Updating User | Int | 6 | 0 | | |
153 | OSGP | Service Group for Brazil | 5 | UserSign2 | Updating User | Int | 6 | 0 | | |
154 | OTHL | Thresholds | 9 | UserSign2 | Updating User | Int | 6 | 0 | | |
155 | SCL1 | Service Call Solutions - Rows | 8 | userSign2 | Updating User | Int | 6 | 0 | | |
156 | SCL2 | Service Call Inventory Expenses | 16 | UserSign2 | User Signature 2 | Int | 6 | 0 | | |
157 | SCL3 | Service Call Travel/Labor Expenses | 16 | UserSign2 | User Signature 2 | Int | 6 | 0 | | |
158 | SCL4 | Expense Documents | 11 | UserSign2 | User Signature 2 | Int | 6 | 0 | | |
159 | SCL5 | Service Call Activities | 8 | UserSign2 | User Signature 2 | Int | 6 | 0 | | |