| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPGeneral status management |
| 1 | TJ01T | Business Transaction Texts | 4 | SHORTTXT | Text (10 Characters) | nvarchar | 10 | 0 | | |
| TOPMedia Product Sales and Distribution |
| 2 | JKSDQMSG | Quality Notification | 6 | SHORTTXT | IS-M: Long Text | nvarchar | 40 | 0 | | |
| TOPTravel Expenses |
| 3 | PTRV_SREC | Trip Statistics - Receipts | 17 | SHORTTXT | Short Receipt Information | nvarchar | 10 | 0 | | |
| TOPTravel Planning |
| 4 | TA20NC1 | Negotiated rental car rates (language-dependent) | 9 | SHORTTXT | Description of Rate | nvarchar | 20 | 0 | | |
| 5 | TA20NEGOF1 | Negotiated Flight Fares (Language-Dependent) | 11 | SHORTTXT | Description of Rate | nvarchar | 20 | 0 | | |
| 6 | TA20NF1 | Negotiated flight fares (language-dependent) | 8 | SHORTTXT | Description of Rate | nvarchar | 20 | 0 | | |
| 7 | TA20NH1 | Negotiated hotel rates (language-dependent) | 12 | SHORTTXT | Description of Rate | nvarchar | 20 | 0 | | |
