| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPClinical System |
1 | N2DFINDREL | IS-H*MED RAD: Reference level of the radiological findings | 9 | FKEY | Foreign code on a radiological information object | nvarchar | 30 | 0 | | |
TOPDictionary Maintenance |
2 | AUDDD_FOR_LOHS | TO: table with LOB handle structure (don't use/change it) | 1 | FKEY | | int | 10 | 0 | | |
3 | AUDDD_FOR_XINX | TO: table with INDX und XINX (don't use/change it) | 1 | FKEY | | nvarchar | 1 | 0 | | |
TOPGenerating, Monitoring for Mass Data Archiving Solutions |
4 | AFX_OBJDATA_KEY | Key Terms for Generated Runtime Data | 1 | FKEY | Key | nvarchar | 20 | 0 | | |
5 | AFX_OBJDATA_KEYT | Key Terms for Generated Runtime Data: Texts | 1 | FKEY | Key | nvarchar | 20 | 0 | | |
6 | AFX_OBJECT_DATA | Generated Runtime Data of AFX Objects | 2 | FKEY | Key | nvarchar | 20 | 0 | | |
7 | AFX_OBJECT_IDATA | Generated Runtime Data (Items) for AFX Objects | 2 | FKEY | Key | nvarchar | 20 | 0 | | |
8 | AFX_OBJECT_MDATA | Generated Run Time Data fo AFX Objects: Mapping Table | 2 | FKEY | Key | nvarchar | 20 | 0 | | |
TOPPatient Management |
9 | NWBUTTON | Pushbuttons for Function Variants | 8 | FKEY | Function Key | nvarchar | 3 | 0 | | |
10 | NWFVARP | Functions below a Pushbutton per Function Variant | 9 | FKEY | Function Key | nvarchar | 3 | 0 | | |
TOPRecycling Administration Core Functions |
11 | J_7LC03 | REA Data Filter: Billing Types | 2 | FKEY | Data Filter Key | nvarchar | 10 | 0 | | |
12 | J_7LC04 | REA Data Filters: Sales Areas | 2 | FKEY | Data Filter Key | nvarchar | 10 | 0 | | |
13 | J_7LC05 | REA Data Filter: Material Types | 2 | FKEY | Data Filter Key | nvarchar | 10 | 0 | | |
14 | J_7LC06 | REA Data Filter: Product Hierarchies | 2 | FKEY | Data Filter Key | nvarchar | 10 | 0 | | |
15 | J_7LC07 | REA Data Filter: Material Groups | 2 | FKEY | Data Filter Key | nvarchar | 10 | 0 | | |
16 | J_7LC13 | REA Data Filters: Transaction Types | 2 | FKEY | Data Filter Key | nvarchar | 10 | 0 | | |
17 | J_7LC14 | REA Data Filter: Movement Types | 2 | FKEY | Data Filter Key | nvarchar | 10 | 0 | | |
18 | J_7LC15 | REA Data Filter: Document Types | 2 | FKEY | Data Filter Key | nvarchar | 10 | 0 | | |
19 | J_7LC28 | REA Data Filter: Sales Document Item Category | 2 | FKEY | Data Filter Key | nvarchar | 10 | 0 | | |
20 | J_7LC29 | REA Data Filter: Packaging Material Type | 2 | FKEY | Data Filter Key | nvarchar | 10 | 0 | | |
21 | J_7LC32 | REA Data Filters: Customer Industry Key | 2 | FKEY | Data Filter Key | nvarchar | 10 | 0 | | |
22 | J_7LC41 | REA Data Filter: Country Allocations | 2 | FKEY | Data Filter Key | nvarchar | 10 | 0 | | |
23 | J_7LC42 | REA Data Filter: Allocation R-Partner, Country and Comp.Code | 6 | FKEY | Data Filter Key | nvarchar | 10 | 0 | | |
24 | J_7LC44 | REA Data Filter: Field Definition Country Assignment | 2 | FKEY | Data Filter Key | nvarchar | 10 | 0 | | |
25 | J_7LC45 | REA Data Filter: Key | 2 | FKEY | Data Filter Key | nvarchar | 10 | 0 | | |
26 | J_7LC45T | REA Data Filter: Short Texts for Keys | 2 | FKEY | Data Filter Key | nvarchar | 10 | 0 | | |
27 | J_7LC48 | REA Data Filter: Field Definition Charact. Material Master | 2 | FKEY | Data Filter Key | nvarchar | 10 | 0 | | |
28 | J_7LC49 | REA Data Filter: Material Master Characteristic Values | 2 | FKEY | Data Filter Key | nvarchar | 10 | 0 | | |
29 | J_7LV1F | REA Document: Characteristics/Grouping from MM | 4 | FKEY | Data Filter Key | nvarchar | 10 | 0 | | |