| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdministration |
| 1 | ODOW | Data Ownership - Objects | 1 | Object | The Object Number | nVarChar | 20 | 0 | | |
| 2 | ODOX | Data Ownership - Exceptions | 2 | Object | The Object Number | nVarChar | 20 | 0 | | |
| TOPBanking |
| 3 | PWZ5 | Payment Wizard - Rows 5 | 10 | Object | Object Type | nVarChar | 20 | 0 | 0 | |
| TOPGeneral |
| 4 | ARSB | Resource Groups - History | 6 | Object | Object Type - History | nVarChar | 20 | 0 | 292 | |
| 5 | ORSB | Resource Groups | 6 | Object | Object Type - History | nVarChar | 20 | 0 | 292 | |
| 6 | SOUT | [SOUT] | 4 | Object | Object | Int | 11 | 0 | | |
| TOPHuman Resources |
| 7 | HEM5 | Employee Data Ownership Authorization | 2 | Object | The Object Number | nVarChar | 20 | 0 | | |
| TOPInventory and Production |
| 8 | AITB | Item Groups - History | 47 | Object | Object Type - History | nVarChar | 20 | 0 | 52 | |
| 9 | AITT | Product Tree - History | 13 | Object | Object Type | nVarChar | 20 | 0 | 66 | |
| 10 | AITW | Items - Warehouse - History | 48 | Object | Object Type - History | nVarChar | 20 | 0 | 31 | |
| 11 | ATT1 | Bill of Materials - Components - History | 16 | Object | Object | nVarChar | 20 | 0 | 66 | |
| 12 | ITT1 | Bill of Materials - Components | 16 | Object | Object | nVarChar | 20 | 0 | 66 | |
| 13 | OITB | Item Groups | 47 | Object | Object Type - History | nVarChar | 20 | 0 | 52 | |
| 14 | OITT | Product Tree | 13 | Object | Object Type | nVarChar | 20 | 0 | 66 | |
| 15 | OITW | Items - Warehouse | 48 | Object | Object Type - History | nVarChar | 20 | 0 | 31 | |
| 16 | SITW | Items - Warehouse | 48 | Object | Object Type - History | nVarChar | 20 | 0 | 31 | |
| 17 | UITW | Items - Warehouse | 48 | Object | Object Type - History | nVarChar | 20 | 0 | 31 | |
| TOPService |
| 18 | ASC4 | Service Call Travel/Labor Expenses - History | 5 | Object | Document Type | nVarChar | 20 | 0 | 13 | 13=A/R Invoice, 14=A/R Credit Memo, 15=Delivery, 165=A/R Correction Invoice, 16=Returns, 17=Sales Order, 18=A/P Invoice, 19=A/P Credit Memo, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 234000031=Return Request, 234000032=Goods Return Request, 23=Sales Quotation, 540000006=Purchase Quotation, 67=Inventory Transaction |
| 19 | SCL4 | Expense Documents | 5 | Object | Document Type | nVarChar | 20 | 0 | 13 | 13=A/R Invoice, 14=A/R Credit Memo, 15=Delivery, 165=A/R Correction Invoice, 16=Returns, 17=Sales Order, 18=A/P Invoice, 19=A/P Credit Memo, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 234000031=Return Request, 234000032=Goods Return Request, 23=Sales Quotation, 540000006=Purchase Quotation, 67=Inventory Transfer |
