| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | ISMNR | SDB: Symptom Number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 3 | ISMVR | SDB: Version Number | nvarchar | 3 | 0 | | | | Allow NULL? |
| 4 | COPER | SDB: Name of the Contact Person | nvarchar | 12 | 0 | | | | Allow NULL? |
| 5 | ISMTP | SDB: Symptom Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 6 | APPLAR | SDB: Application Area | nvarchar | 20 | 0 | | | | Allow NULL? |
| 7 | ISMART | SDB: Symptom Category | nvarchar | 2 | 0 | | | | Allow NULL? |
| 8 | VALDTFRM | SDB: Validation Date From | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | VALDTTO | SDB: Validation Date To | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | ISMCAT | SDB: Catalog Type - Symptom | char | 1 | 0 | | | | Allow NULL? |
| 11 | ISMGRP | SDB: Symptom Code Group - Coding | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | ISMCOD | SDB: Coding | nvarchar | 4 | 0 | | | | Allow NULL? |
| 13 | ARTPR | Priority Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 14 | PRIOK | Priority | char | 1 | 0 | | | | Allow NULL? |
| 15 | ISMST | SDB: Symptom Status | char | 1 | 0 | | | | Allow NULL? |
| 16 | RBNR | Catalog Profile | nvarchar | 9 | 0 | | | | Allow NULL? |
| 17 | OPCAT | SDB: Catalog type - Problem Location | char | 1 | 0 | | | | Allow NULL? |
| 18 | PRCAT | SDB: Catalog Type - Problem Damage | char | 1 | 0 | | | | Allow NULL? |
| 19 | CACAT | SDB: Catalog type - Causes | char | 1 | 0 | | | | Allow NULL? |
| 20 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 21 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 22 | ERTIM | Time, at Which Record Was Added | nvarchar | 6 | 0 | | | | Allow NULL? |
| 23 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 24 | AEDAT | Changed On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 25 | AETIM | Time of Change | nvarchar | 6 | 0 | | | | Allow NULL? |
| 26 | FLGDEL | Delete Data Record | char | 1 | 0 | | | | Allow NULL? |
| 27 | OBJNR | Object Number for Status Management | nvarchar | 22 | 0 | | | | Allow NULL? |