| 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 | | |
TOPGeneral |
11 | GRTS | GRTS | 2 | Descript | Description | nVarChar | 50 | 0 | | |
TOPInventory and Production |
12 | OOFR | Defect Cause | 2 | Descript | Description | nVarChar | 30 | 0 | | |
13 | OOIN | Interest | 2 | Descript | Description | nVarChar | 30 | 0 | | |
14 | OOIR | Interest Level | 2 | Descript | Description | nVarChar | 30 | 0 | | |
15 | OOSR | Information Source | 2 | Descript | Description | nVarChar | 30 | 0 | | |
16 | UWKO1 | Production Instructions - Rows | 4 | Descript | Item Description | nVarChar | 100 | 0 | | |
17 | WKO1 | Production Instructions - Rows | 4 | Descript | Item Description | nVarChar | 100 | 0 | | |
TOPMarketing Documents |
18 | GPA2 | Gross Profit Adjustments - Parameters | 3 | Descript | Wizard Parameters Description | nVarChar | 100 | 0 | | |
TOPReports |
19 | OTSM | Tax Summary Report Method | 2 | Descript | Description | nVarChar | 20 | 0 | | |
TOPSales Opportunities |
20 | OOST | Opportunity Stage | 2 | Descript | Name | nVarChar | 30 | 0 | | |
TOPService |
21 | OQUE | Queue | 2 | descript | Description | nVarChar | 200 | 0 | | |