| 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 | PRCNT | SDB: Problem damage number in problem damage record | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | ITEMNR | SDB: Trigger Number | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | PRCAT | SDB: Catalog type - Problem Damage | char | 1 | 0 | | | | Allow NULL? |
| 7 | PRGRP | SDB: Code Group - Problem Damage | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | PRCOD | SDB: Code - Problem Damage | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | OPCNT | SDB: Problem location number in Problem record | nvarchar | 4 | 0 | | | | Allow NULL? |
| 10 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 11 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | ERTIM | Time, at Which Record Was Added | nvarchar | 6 | 0 | | | | Allow NULL? |
| 13 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 14 | AEDAT | Changed On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 15 | AETIM | Time of Change | nvarchar | 6 | 0 | | | | Allow NULL? |
| 16 | FLGDEL | Delete Data Record | char | 1 | 0 | | | | Allow NULL? |