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