| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPEarly Warning System |
| 1 | MCYA | Early Warning: Exceptions | 7 | GEDAT | Date of last change | nvarchar | 8 | 0 | | |
| TOPPatient Accounting |
| 2 | NMATO | IS-H: Material requisition by nurse station | 21 | GEDAT | IS-H MM: Date of Approval | nvarchar | 8 | 0 | | |
| 3 | NMATP | IS-H: Material planned for case | 23 | GEDAT | IS-H MM: Date of Approval | nvarchar | 8 | 0 | | |
| TOPPurchasing |
| 4 | WDFR_DISP | Perishables Planning Header | 129 | GEDAT | Field of type DATS | nvarchar | 8 | 0 | | |
| TOPReporting |
| 5 | MCRSV | Selection versions: Header data | 7 | GEDAT | Date of last change | nvarchar | 8 | 0 | | |
| 6 | MCSHIERK | Header of general hierarchy | 15 | GEDAT | Date of last change | nvarchar | 8 | 0 | | |
