| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAudit Management |
| 1 | PLMM_AUDIT_ACT | Audit - Corrective Action | 27 | FENUM | Notification Print Item Number | nvarchar | 4 | 0 | | |
| 2 | PLMM_QUEST_RES | Audit Question/Reply List/Item | 58 | FENUM | Notification Print Item Number | nvarchar | 4 | 0 | | |
| TOPHoliday Calendar, Factory Calendar, Appointment Calendar |
| 3 | TFACS | Factory calendar (display) | 16 | FENUM | Number of days in year | nvarchar | 3 | 0 | | |
| 4 | THOCS | Public holiday calendar (display) | 15 | FENUM | Number of days in year | nvarchar | 3 | 0 | | |
| TOPMaintenance Notifications |
| 5 | QMFE | Quality notification - items | 3 | FENUM | Item Number in Item Record | nvarchar | 4 | 0 | | |
| 6 | QMMA | Quality notification - activities | 4 | FENUM | Item Number in Item Record | nvarchar | 4 | 0 | | |
| 7 | QMSM | Quality notification - tasks | 26 | FENUM | Item Number in Item Record | nvarchar | 4 | 0 | | |
| 8 | QMUR | Quality notification - causes | 3 | FENUM | Item Number in Item Record | nvarchar | 4 | 0 | | |
| 9 | QNAOD_AOBJECT | Assigned Objects for Notification Item | 4 | FENUM | Item Number in Item Record | nvarchar | 4 | 0 | | |
