| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdministration |
| 1 | FTT1 | Financial Template Import - Files | 5 | Descript | Description | nVarChar | 100 | 0 | | |
| TOPBanking |
| 2 | ABTC | Internal Bank Operation Codes - Log | 12 | Descript | Operation Description | nVarChar | 40 | 0 | | |
| 3 | OBTC | Internal Bank Operation Codes | 12 | Descript | Operation Description | nVarChar | 40 | 0 | | |
| 4 | OPYM | Payment Methods for Payment Wizard | 2 | Descript | Description | nVarChar | 100 | 0 | | |
| 5 | OROC | Retorno Operation Codes | 5 | Descript | Description | nVarChar | 254 | 0 | | |
| TOPBusiness Partners |
| 6 | AOAT | Blanket Agreement | 8 | Descript | Description | nVarChar | 254 | 0 | | |
| 7 | OOAT | Blanket Agreement | 8 | Descript | Description | nVarChar | 254 | 0 | | |
| 8 | OTER | Territories | 2 | descript | Description | nVarChar | 200 | 0 | | |
| 9 | OVTP | Vendor Type | 3 | Descript | Description | nVarChar | 120 | 0 | | |
| TOPFinance |
| 10 | OSVT | Define Summary VAT Report Type | 3 | Descript | Description | nVarChar | 254 | 0 | | |
| TOPInventory and Production |
| 11 | OOFR | Defect Cause | 2 | Descript | Description | nVarChar | 30 | 0 | | |
| 12 | OOIN | Interest | 2 | Descript | Description | nVarChar | 30 | 0 | | |
| 13 | OOIR | Interest Level | 2 | Descript | Description | nVarChar | 30 | 0 | | |
| 14 | OOSR | Information Source | 2 | Descript | Description | nVarChar | 30 | 0 | | |
| 15 | UWKO1 | Production Instructions - Rows | 4 | Descript | Item Description | nVarChar | 100 | 0 | | |
| 16 | WKO1 | Production Instructions - Rows | 4 | Descript | Item Description | nVarChar | 100 | 0 | | |
| TOPMarketing Documents |
| 17 | GPA2 | Gross Profit Adjustments - Parameters | 3 | Descript | Wizard Parameters Description | nVarChar | 100 | 0 | | |
| TOPSales Opportunities |
| 18 | OOST | Opportunity Stage | 2 | Descript | Name | nVarChar | 30 | 0 | | |
| TOPService |
| 19 | OQUE | Queue | 2 | descript | Description | nVarChar | 200 | 0 | | |
