Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
# | Name | Type | ||
---|---|---|---|---|
1 | No. (No.) | Code20 |
|
Editable: No |
2 | Line No. (Line No.) | Integer | ||
3 | Service Item No. (Service Item No.) | Code20 |
|
|
4 | Service Item Group Code (Service Item Group Code) | Code10 |
|
|
5 | Item No. (Item No.) | Code20 |
|
|
6 | Serial No. (Serial No.) | Code20 | ||
7 | Description (Description) | Text50 | ||
8 | Description 2 (Description 2) | Text50 | ||
10 | Priority (Priority) | Option | [Low,Medium,High] | |
11 | Response Time (Hours) (Response Time (Hours)) | Decimal (0:5) | ||
12 | Response Date (Response Date) | Date | ||
13 | Response Time (Response Time) | Time | ||
14 | Starting Date (Starting Date) | Date | Editable: No | |
15 | Starting Time (Starting Time) | Time | Editable: No | |
16 | Finishing Date (Finishing Date) | Date | Editable: No | |
17 | Finishing Time (Finishing Time) | Time | Editable: No | |
18 | Service Shelf No. (Service Shelf No.) | Code10 |
|
|
19 | Warranty Starting Date (Parts) (Warranty Starting Date (Parts)) | Date | ||
20 | Warranty Ending Date (Parts) (Warranty Ending Date (Parts)) | Date | ||
21 | Warranty (Warranty) | Boolean | ||
22 | Warranty % (Parts) (Warranty % (Parts)) | Decimal (0:5) | ||
23 | Warranty % (Labor) (Warranty % (Labor)) | Decimal (0:5) | ||
24 | Warranty Starting Date (Labor) (Warranty Starting Date (Labor)) | Date | ||
25 | Warranty Ending Date (Labor) (Warranty Ending Date (Labor)) | Date | ||
26 | Contract No. (Contract No.) | Code20 |
|
Editable: No |
27 | Location of Service Item (Location of Service Item) | Text30 |
|
Editable: No FlowField |
28 | Loaner No. (Loaner No.) | Code20 |
|
|
29 | Vendor No. (Vendor No.) | Code20 |
|
|
30 | Vendor Item No. (Vendor Item No.) | Text20 | ||
31 | Fault Reason Code (Fault Reason Code) | Code10 |
|
|
32 | Service Price Group Code (Service Price Group Code) | Code10 |
|
|
33 | Fault Area Code (Fault Area Code) | Code10 |
|
|
34 | Symptom Code (Symptom Code) | Code10 |
|
|
35 | Fault Code (Fault Code) | Code10 |
|
|
36 | Resolution Code (Resolution Code) | Code10 |
|
|
37 | Fault Comment (Fault Comment) | Boolean |
|
Editable: No FlowField |
38 | Resolution Comment (Resolution Comment) | Boolean |
|
Editable: No FlowField |
39 | Accessory Comment (Accessory Comment) | Boolean |
|
Editable: No FlowField |
40 | Variant Code (Variant Code) | Code10 |
|
|
42 | Actual Response Time (Hours) (Actual Response Time (Hours)) | Decimal (0:5) | ||
44 | Service Price Adjmt. Gr. Code (Service Price Adjmt. Gr. Code) | Code10 |
|
Editable: No |
45 | Adjustment Type (Adjustment Type) | Option | [Fixed,Maximum,Minimum] | Editable: No |
46 | Base Amount to Adjust (Base Amount to Adjust) | Decimal | Editable: No | |
60 | No. of Active/Finished Allocs (No. of Active/Finished Allocs) | Integer |
|
Editable: No FlowField |
64 | Ship-to Code (Ship-to Code) | Code10 |
|
Editable: No |
65 | Customer No. (Customer No.) | Code20 |
|
Editable: No |
91 | Date Filter (Date Filter) | Date | FlowFilter | |
92 | Resource Filter (Resource Filter) | Code20 |
|
FlowFilter |
93 | Allocation Date Filter (Allocation Date Filter) | Date | FlowFilter | |
95 | Resource Group Filter (Resource Group Filter) | Code20 |
|
FlowFilter |
97 | Responsibility Center (Responsibility Center) | Code10 |
|
Editable: No |
480 | Dimension Set ID (Dimension Set ID) | Integer |
|
Editable: No |
Keys
# | Fields | ||
---|---|---|---|
0 | No.,Line No. (No.,Line No.) | Clustered: Yes | |
1 | Service Item No. (Service Item No.) | ||
2 | Item No.,Serial No.,Loaner No. (Item No.,Serial No.,Loaner No.) | ||
3 | Service Price Group Code,Adjustment Type,Base Amount to Adjust,Customer No. (Service Price Group Code,Adjustment Type,Base Amount to Adjust,Customer No.) |
Table Relations To Other Tables
Field | Related Table | Related Field | ||
---|---|---|---|---|
Customer No. (Customer No.) | Customer | No. (No.) |
|
1..n |
Dimension Set ID (Dimension Set ID) | Dimension Set Entry | () |
|
1..n |
Fault Area Code (Fault Area Code) | Fault Area | Code (Code) |
|
1..n |
Fault Code (Fault Code) | Fault Code | Code (Code) |
|
1..n |
Fault Reason Code (Fault Reason Code) | Fault Reason Code | Code (Code) |
|
1..n |
Item No. (Item No.) | Item | No. (No.) |
|
1..n |
Variant Code (Variant Code) | Item Variant | Code (Code) |
|
1..n |
Loaner No. (Loaner No.) | Loaner | No. (No.) |
|
1..n |
Resolution Code (Resolution Code) | Resolution Code | Code (Code) |
|
1..n |
Resource Filter (Resource Filter) | Resource | No. (No.) |
|
1..n |
Resource Group Filter (Resource Group Filter) | Resource Group | No. (No.) |
|
1..n |
Responsibility Center (Responsibility Center) | Responsibility Center | Code (Code) |
|
1..n |
Contract No. (Contract No.) | Service Contract Header | Contract No. (Contract No.) |
|
1..n |
Service Item No. (Service Item No.) | Service Item | No. (No.) |
|
1..n |
Service Item Group Code (Service Item Group Code) | Service Item Group | Code (Code) |
|
1..n |
Service Price Adjmt. Gr. Code (Service Price Adjmt. Gr. Code) | Service Price Adjustment Group | Code (Code) |
|
1..n |
Service Price Group Code (Service Price Group Code) | Service Price Group | Code (Code) |
|
1..n |
Service Shelf No. (Service Shelf No.) | Service Shelf | No. (No.) |
|
1..n |
No. (No.) | Service Shipment Header | No. (No.) |
|
1..n |
Ship-to Code (Ship-to Code) | Ship-to Address | Code (Code) |
|
1..n |
Symptom Code (Symptom Code) | Symptom Code | Code (Code) |
|
1..n |
Vendor No. (Vendor No.) | Vendor | No. (No.) |
|
1..n |
Table Relations From Other Tables
From Table | From Field |
---|