| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T131A | Change code, selection group, and material master table | 2 | VCODE | Change code | nvarchar | 3 | 0 | | |
2 | T131V | Change code plus maintenance status | 2 | VCODE | Change code | nvarchar | 3 | 0 | | |
3 | T131X | Change Codes with Descriptions | 3 | VCODE | Change code | nvarchar | 3 | 0 | | |
4 | TDA10 | Alloc. of trans.codes to ok-codes and screen overview | 10 | VCODE | Not More Closely Defined Area, Possibly Used for Patchlevels | nvarchar | 4 | 0 | | |
5 | TZV37 | Activities and their internal status area | 1 | VCODE | Not More Closely Defined Area, Possibly Used for Patchlevels | nvarchar | 4 | 0 | | |
6 | ZQUALITY_PARMS | Inspection Lot Parameters for material quality task lists | 14 | VCODE | Usage Decision Code | nvarchar | 4 | 0 | | |
TOPBasic Data |
7 | TNDYM | IS-H: Screen Modifications | 7 | VCODE | IS-H: Processing Mode | nvarchar | 3 | 0 | | |
TOPClinical System |
8 | N1PRERROR | IS-H*MED: PATREG: Nicht verbuchbare Pat.Reg.-Datensätze | 8 | VCODE | IS-H: Isleme kipi | nvarchar | 3 | 0 | | |
9 | N2BATMP | IS-H*MED: Temporary treatment order | 11 | VCODE | Processing Code | nvarchar | 20 | 0 | | |
TOPInformation System |
10 | S290 | BW: Inspection Lot/Usage Dec. | 11 | VCODE | Usage Decision Code | nvarchar | 4 | 0 | | |
11 | S290BIW1 | S290BIW1 * BW: Inspection Lot/Usage Decision | 11 | VCODE | Usage Decision Code | nvarchar | 4 | 0 | | |
12 | S290BIW2 | S290BIW2 * BW: Inspection Lot/Usage Decision | 11 | VCODE | Usage Decision Code | nvarchar | 4 | 0 | | |
TOPInspection Lot Completion |
13 | QAVE | Inspection processing: Usage decision | 9 | VCODE | Usage Decision Code | nvarchar | 4 | 0 | | |
TOPMaterial Master |
14 | T130F | Field attributes | 4 | VCODE | Change code | nvarchar | 3 | 0 | | |
TOPPatient Management |
15 | N1TC_ACCESS_LOG | Log of Access to Treatment Contracts Applied for | 10 | VCODE | IS-H: Processing Mode | nvarchar | 3 | 0 | | |
16 | NVVF | IS-H: Case-Related Insurance Relationships | 47 | VCODE | IS-H CA: Version Code for OHIP Health Number | nvarchar | 2 | 0 | | |
17 | NVVP | IS-H: Patient-related insurance relationship | 61 | VCODE | IS-H CA: Version Code for OHIP Health Number | nvarchar | 2 | 0 | | |
18 | NWPLACE_DTM | IS-H: Determination of Work Environment at Callup | 4 | VCODE | IS-H: Processing Mode | nvarchar | 3 | 0 | | |
19 | NWVIEW_FCD | Function Bar: Function Code Data | 8 | VCODE | IS-H: Processing Mode | nvarchar | 3 | 0 | | |
TOPQuality Inspection |
20 | QAPP | Inspection point | 33 | VCODE | Usage Decision Code | nvarchar | 4 | 0 | | |