| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | N1MESORTORDHDR | Medication: Header for Man. Sorting | 2 | SORTID | Medication: ID for Manual Sort Order Assignments | nvarchar | 32 | 0 | | |
| 2 | N1MESORTORDPOS | Medication: Position of MO in Man. Sort Order | 3 | SORTID | Medication: ID for Manual Sort Order Assignments | nvarchar | 32 | 0 | | |
| TOPClinical System |
| 3 | N1WVIEWZ | IS-H*MED: Structure for Views | 7 | SORTID | Prioritizing Nodes from the Second Level | nvarchar | 3 | 0 | | |
| TOPFinancial Accounting |
| 4 | J_1GJOURNAL3 | Journal document type references | 5 | SORTID | Sort sequence | nvarchar | 4 | 0 | | |
| TOPLoans Management |
| 5 | TDESRTZB0A | CML Corr.: Sequence When Printing Items | 5 | SORTID | Classification: Sort Item | nvarchar | 2 | 0 | | |
| TOPLocalization |
| 6 | J_3RKACT | Assign Rules to Groups of Accounting Documents | 5 | SORTID | Sort Rule | nvarchar | 10 | 0 | | |
| TOPPatient Management |
| 7 | NWPVZ | Work Environment-to-View Assignment | 6 | SORTID | Priority of View in Work Environment | nvarchar | 3 | 0 | | |
| TOPReuse Services for Country Development |
| 8 | T799BATTRIB02 | Fixed Values of HR Attributes | 7 | SORTID | Sort Identifier for Fixed Values of an HR Attribute | nvarchar | 5 | 0 | | |
| 9 | T799BATTRIB05 | HR Attributes of HR Attribute Class | 5 | SORTID | Sort Identifier for HR Attributes within HR Attribute Class | nvarchar | 5 | 0 | | |
