| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAMI Event Management |
1 | EFDT_EXPR003 | FDT: Expression - Create Service Order | 4 | ORDER_CODE | Order Code | nvarchar | 4 | 0 | | |
2 | EFDT_EXPR003A | FDT: Expression - Create Service Order | 4 | ORDER_CODE | Order Code | nvarchar | 4 | 0 | | |
3 | EFDT_EXPR003S | FDT: Expression - Create Service Order | 3 | ORDER_CODE | Order Code | nvarchar | 4 | 0 | | |
4 | EFDT_EXPR003T | FDT: Expression - Create Service Order | 3 | ORDER_CODE | Order Code | nvarchar | 4 | 0 | | |
TOPDevice Management |
5 | EGERS | IS-U Device Master Data | 30 | ORDER_CODE | Special Order Code for Dev./Dev. Category in Replacement | nvarchar | 4 | 0 | | |
6 | ETYP | Dev. Cat.: IS-U Additional Material Data | 33 | ORDER_CODE | Special Order Code for Dev./Dev. Category in Replacement | nvarchar | 4 | 0 | | |
TOPProcessing |
7 | EWMINSPDETAIL | Inspection List Detail | 23 | ORDER_CODE | Order Code | nvarchar | 4 | 0 | | |
8 | EWMOBJINSP | Inspection date for equipment or functional location | 4 | ORDER_CODE | Order code for inspection | nvarchar | 4 | 0 | | |
9 | EWMPERIODEQ | Periods for equipment inspections | 6 | ORDER_CODE | Order code for inspection | nvarchar | 4 | 0 | | |
10 | EWMPERIODTI | Periods for technical installation inspections | 6 | ORDER_CODE | Order code for inspection | nvarchar | 4 | 0 | | |
11 | TEWOCODE | Alloc. of Message Codes to Order Texts | 2 | ORDER_CODE | Order Code | nvarchar | 4 | 0 | | |
12 | TEWOCODES | Order Codes | 2 | ORDER_CODE | Order Code | nvarchar | 4 | 0 | | |
13 | TEWOCODEST | Order Codes (Texts) | 3 | ORDER_CODE | Order Code | nvarchar | 4 | 0 | | |
14 | TEWOCODET | Allocation of Message Codes to Order Cats (Texts) | 3 | ORDER_CODE | Order Code | nvarchar | 4 | 0 | | |