| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPData Collection |
1 | S100 | Problems: Material Analysis | 12 | FEART | Report Type for Defects Recording | nvarchar | 8 | 0 | | |
2 | S100E | S100 - Structural Information | 7 | FEART | Report Type for Defects Recording | nvarchar | 8 | 0 | | |
3 | S102 | Problems: Vendor Analysis | 13 | FEART | Report Type for Defects Recording | nvarchar | 8 | 0 | | |
4 | S102E | S102 - Structural Information | 8 | FEART | Report Type for Defects Recording | nvarchar | 8 | 0 | | |
5 | S103 | Problems: Customer Analysis | 13 | FEART | Report Type for Defects Recording | nvarchar | 8 | 0 | | |
6 | S103E | S103 - Structural Information | 8 | FEART | Report Type for Defects Recording | nvarchar | 8 | 0 | | |
TOPMaintenance Notifications |
7 | QMEL | Quality Notification | 83 | FEART | Report Type for Defects Recording | nvarchar | 8 | 0 | | |
8 | QMFE | Quality notification - items | 33 | FEART | Report Type for Defects Recording | nvarchar | 8 | 0 | | |
TOPResults Recording |
9 | TQ86 | Report category for defects recording | 2 | FEART | Report Type for Defects Recording | nvarchar | 8 | 0 | | |
10 | TQ86A | Assignment report category for work center | 4 | FEART | Report Type for Defects Recording | nvarchar | 8 | 0 | | |
11 | TQ86T | Text table for report category | 3 | FEART | Report Type for Defects Recording | nvarchar | 8 | 0 | | |