Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
| # | Name | Type | ||
|---|---|---|---|---|
| 1 | Document No. (Document 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 | ||
| 9 | Repair Status Code (Repair Status Code) | Code10 |
|
|
| 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 | ||
| 15 | Starting Time (Starting Time) | Time | ||
| 16 | Finishing Date (Finishing Date) | Date | ||
| 17 | Finishing Time (Finishing Time) | Time | ||
| 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) | MaxValue: 100 | |
| 23 | Warranty % (Labor) (Warranty % (Labor)) | Decimal (0:5) | MaxValue: 100 | |
| 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 |
|
|
| 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 |
| 40 | Variant Code (Variant Code) | Code10 |
|
|
| 41 | Service Item Loaner Comment (Service Item Loaner Comment) | Boolean |
|
Editable: No FlowField |
| 42 | Actual Response Time (Hours) (Actual Response Time (Hours)) | Decimal (0:5) | ||
| 43 | Document Type (Document Type) | Option | [Quote,Order] | Editable: No |
| 44 | Serv. Price Adjmt. Gr. Code (Serv. 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 |
| 61 | No. of Allocations (No. of Allocations) | Integer |
|
Editable: No FlowField |
| 62 | No. of Previous Services (No. of Previous Services) | Integer |
|
Editable: No FlowField |
| 63 | Contract Line No. (Contract Line No.) | Integer |
|
|
| 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 | |
| 94 | Repair Status Code Filter (Repair Status Code Filter) | Code10 |
|
FlowFilter |
| 96 | Allocation Status Filter (Allocation Status Filter) | Option | [Nonactive,Active,Finished,Canceled,Reallocation Needed] | FlowFilter |
| 97 | Responsibility Center (Responsibility Center) | Code10 |
|
Editable: No |
| 98 | Service Order Filter (Service Order Filter) | Code20 |
|
FlowFilter |
| 99 | Resource Group Filter (Resource Group Filter) | Code20 |
|
FlowFilter |
| 100 | Shortcut Dimension 1 Code (Shortcut Dimension 1 Code) | Code20 | CaptionClass: '1,2,1'
|
|
| 101 | Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) | Code20 | CaptionClass: '1,2,2'
|
|
| 130 | Release Status (Release Status) | Option | [Open,Released to Ship] | |
| 480 | Dimension Set ID (Dimension Set ID) | Integer |
|
Editable: No |
Keys
| # | Fields | ||
|---|---|---|---|
| 0 | Document Type,Document No.,Line No. (Document Type,Document No.,Line No.) | Clustered: Yes | |
| 1 | Document No.,Line No.,Document Type (Document No.,Line No.,Document Type) | ||
| 2 | Document Type,Document No.,Service Item No.,Contract No.,Contract Line No. (Document Type,Document No.,Service Item No.,Contract No.,Contract Line No.) | MaintainSQLIndex: No | |
| 3 | Service Item No. (Service Item No.) | ||
| 4 | Document Type,Document No.,Response Date,Response Time (Document Type,Document No.,Response Date,Response Time) | ||
| 5 | Response Date,Response Time,Priority (Response Date,Response Time,Priority) | ||
| 6 | Loaner No. (Loaner No.) | ||
| 7 | Document Type,Document No.,Starting Date,Starting Time (Document Type,Document No.,Starting Date,Starting Time) | MaintainSQLIndex: No | |
| 8 | Document Type,Document No.,Finishing Date,Finishing Time (Document Type,Document No.,Finishing Date,Finishing Time) | MaintainSQLIndex: No | |
| 9 | Fault Reason Code (Fault Reason Code) | ||
| 10 | Contract No. (Contract 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 |
| Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) | Dimension Value | Code (Code) |
|
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 |
| Repair Status Code Filter (Repair Status Code Filter) | Repair Status | Code (Code) |
|
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 |
| Contract Line No. (Contract Line No.) | Service Contract Line | Line No. (Line No.) |
|
1..n |
| Service Order Filter (Service Order Filter) | Service Header | No. (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 |
| Serv. Price Adjmt. Gr. Code (Serv. 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 |
| 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 | ||
|---|---|---|---|
| Service Line | Service Item Line No. (Service Item Line No.) |
|
1..n |
| Service Order Allocation | Service Item Line No. (Service Item Line No.) |
|
1..n |