| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdministration |
| 1 | AADM | Administration - Log | 289 | UpdateDate | Update Date | Date | 8 | 0 | | |
| 2 | ACRC | Credit Cards | 10 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 3 | AEXD | Freight Setup | 33 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 4 | AUSR | Archive Users - History | 71 | updateDate | Update Date | Date | 8 | 0 | | |
| 5 | OADM | Administration | 289 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 6 | OCHF | 312 | 3 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 7 | OCRC | Credit Cards | 10 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 8 | ODOW | Data Ownership - Objects | 8 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 9 | ODOX | Data Ownership - Exceptions | 7 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 10 | OEXD | Freight Setup | 33 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 11 | OUSR | Users | 71 | updateDate | Date of Update - History | Date | 8 | 0 | | |
| TOPBanking |
| 12 | ABOC | External Bank Operation Code - Log | 4 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 13 | ABOE | Bill of Exchange for Payment - History | 28 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 14 | ABTC | Internal Bank Operation Codes - | 10 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 15 | ACHO | Checks for Payment - History | 31 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 16 | ADS1 | House Bank Accounts | 61 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 17 | ARCT | Incoming Payment - History | 58 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 18 | DSC1 | House Bank Accounts | 61 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 19 | OBOC | External Bank Operation Code Category | 4 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 20 | OBOE | Bill of Exchange for Payment | 28 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 21 | OBTC | Internal Bank Operation Codes | 10 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 22 | OCHD | Checks for Payment Drafts | 31 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 23 | OCHO | Checks for Payment | 31 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 24 | ODPS | Deposit | 26 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 25 | OPDF | Payment Draft | 58 | UpdateDate | Update Date | Date | 8 | 0 | | |
| 26 | ORCT | Incoming Payment | 58 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 27 | OVPM | Outgoing Payments | 58 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| TOPBusiness Partners |
| 28 | ACPR | Contact Persons - History | 23 | updateDate | Date of Update | Date | 8 | 0 | | |
| 29 | ACRD | Business Partners - History | 133 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 30 | OCPR | Contact Persons | 23 | updateDate | Date of Update | Date | 8 | 0 | | |
| 31 | OCRD | Business Partner | 133 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| TOPFinance |
| 32 | AACP | Periods Category-Log | 15 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 33 | AACT | G/L Account - History | 39 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 34 | AFPR | Posting Period-Log | 22 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 35 | AJDT | Journal Entry - History | 25 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 36 | AVTG | Tax Definition | 30 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 37 | AWHT | Withholding Tax | 17 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 38 | OACP | Periods Category | 15 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 39 | OACT | G/L Accounts | 39 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 40 | OBTF | Journal Voucher Entry | 25 | UpdateDate | Update Date | Date | 8 | 0 | | |
| 41 | OFPR | Posting Period | 22 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 42 | OJDT | Journal Entry | 25 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 43 | OSCM | Special Ledger - Analytical Accounting Configuration Rules: Material | 8 | UpdateDate | Date of Rule Change | Date | 8 | 0 | | |
| 44 | OSCR | Special Ledger - Analytical Accounting Configuration Rules: Revenues & Expenses | 8 | UpdateDate | Date of Rule Change | Date | 8 | 0 | | |
| 45 | OVTG | Tax Definition | 30 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 46 | OWHT | Withholding Tax | 17 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| TOPHuman Resources |
| 47 | AHEM | Employees | 98 | UpdateDate | Update Date | Date | 8 | 0 | | |
| 48 | OHEM | Employees | 98 | UpdateDate | Update Date | Date | 8 | 0 | | |
| TOPInventory and Production |
| 49 | AITB | Item Groups - History | 51 | updateDate | Update Date - History | Date | 8 | 0 | | |
| 50 | AITM | Items - History | 167 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 51 | AITT | Product Tree - History | 7 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 52 | AITW | Items - Warehouse - History | 52 | updateDate | Update Date - History | Date | 8 | 0 | | |
| 53 | AMRV | Inventory Revaluation - History | 11 | UpdateDate | Update Date | Date | 8 | 0 | | |
| 54 | APKL | Pick List - History | 13 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 55 | AWHS | Warehouses - History | 58 | updateDate | Date of Update - History | Date | 8 | 0 | | |
| 56 | AWOR | Production Order - History | 40 | UpdateDate | Update Date | Date | 8 | 0 | | |
| 57 | LIVI | IVI Log File | 7 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 58 | OENT | Shipping Types | 34 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 59 | OIGE | Goods Issue | 63 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 60 | OIGN | Goods Receipt | 63 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 61 | OIPF | Landed Costs | 38 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 62 | OITB | Item Groups | 51 | updateDate | Date of Update - History | Date | 8 | 0 | | |
| 63 | OITM | Items | 167 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 64 | OITT | Product Tree | 7 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 65 | OITW | Items - Warehouse | 52 | updateDate | Date of Update - History | Date | 8 | 0 | | |
| 66 | OMRL | Advanced Inventory Revaluation | 18 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 67 | OMRV | Inventory Revaluation | 11 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 68 | OPKL | Pick List | 13 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 69 | OWHS | Warehouses | 58 | updateDate | Date of Update - History | Date | 8 | 0 | | |
| 70 | OWKO | Production Instructions | 18 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 71 | OWOR | Production Order | 40 | UpdateDate | Update Date | Date | 8 | 0 | | |
| 72 | OWTR | Inventory Transfer | 63 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 73 | UITM | Items | 167 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 74 | UITW | Items - Warehouse | 52 | updateDate | Date of Update - History | Date | 8 | 0 | | |
| 75 | UWKO | Production Instructions | 18 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 76 | UWOR | Production Order | 40 | UpdateDate | Update Date | Date | 8 | 0 | | |
| TOPMarketing Documents |
| 77 | ADOC | Invoice - History | 63 | UpdateDate | Update Date | Date | 8 | 0 | | |
| 78 | ATXI | Tax Invoice - History | 12 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 79 | OCIN | A/R Correction Invoice | 63 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 80 | OCPI | A/P Correction Invoice | 63 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 81 | OCPV | A/P Correction Invoice Reversal | 63 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 82 | OCSI | A/R Correction Invoice | 63 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 83 | OCSV | A/R Correction Invoice Reversal | 63 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 84 | ODLN | Delivery | 63 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 85 | ODPI | A/R Down Payment | 63 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 86 | ODPO | A/P Down Payment | 63 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 87 | ODRF | Drafts | 63 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 88 | OIEI | Incoming Excise Invoice | 63 | UpdateDate | Update Date | Date | 8 | 0 | | |
| 89 | OINV | A/R Invoice | 63 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 90 | OOEI | Outgoing Excise Invoice | 63 | UpdateDate | Update Date | Date | 8 | 0 | | |
| 91 | OPCH | A/P Invoice | 63 | UpdateDate | Update Date | Date | 8 | 0 | | |
| 92 | OPDN | Goods Receipt PO | 63 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 93 | OPOR | Purchase Order | 63 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 94 | OQUT | Sales Quotation | 63 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 95 | ORDN | Returns | 63 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 96 | ORDR | Sales Order | 63 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 97 | ORIN | A/R Credit Memo | 63 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 98 | ORPC | A/P Credit Memo | 63 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 99 | ORPD | Goods Return | 63 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 100 | OSAL | Outgoing | 34 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 101 | OTPI | Purchase Tax Invoice | 12 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 102 | OTRA | Transition | 34 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 103 | OTSI | Sales Tax Invoice | 12 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 104 | OTXD | Tax Invoice Draft | 12 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 105 | WDD1 | Documents for Approval - Authorizers | 9 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| TOPReports |
| 106 | RDOC | Document | 53 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| TOPService |
| 107 | AINS | Customer Equipment Card - History | 41 | updateDate | Update Date | Date | 8 | 0 | | |
| 108 | ASC1 | Service Call Solutions - History | 9 | updateDate | Date of Update - History | Date | 8 | 0 | | |
| 109 | ASC2 | Service Call Inventory Expenses - History | 17 | UpdateDate | Date of Update - History | Date | 8 | 0 | | |
| 110 | ASC3 | Service Call Travel/Labor Expenses - History | 17 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 111 | ASC4 | Service Call Travel/Labor Expenses - History | 12 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 112 | ASC5 | Service Call Activities - History | 9 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 113 | ASCL | History | 32 | updateDate | Date of Update | Date | 8 | 0 | | |
| 114 | OINS | Customer Equipment Card | 41 | updateDate | Date of Update | Date | 8 | 0 | | |
| 115 | OSCL | Service Calls | 32 | updateDate | Date of Update | Date | 8 | 0 | | |
| 116 | SCL1 | Service Call Solutions - Rows | 9 | updateDate | Date of Update | Date | 8 | 0 | | |
| 117 | SCL2 | Service Call Inventory Expenses | 17 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 118 | SCL3 | Service Call Travel/Labor Expenses | 17 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 119 | SCL4 | Expense Documents | 12 | UpdateDate | Date of Update | Date | 8 | 0 | | |
| 120 | SCL5 | Service Call Activities | 9 | UpdateDate | Date of Update | Date | 8 | 0 | | |
