Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
# | Name | Type | ||
---|---|---|---|---|
1 | Entry No. (Entry No.) | Integer | ||
3 | Document No. (Document No.) | Code20 | ||
4 | Posting Date (Posting Date) | Date | ||
5 | Customer No. (Customer No.) | Code20 |
|
|
6 | Ship-to Code (Ship-to Code) | Code10 |
|
|
7 | Bill-to Customer No. (Bill-to Customer No.) | Code20 |
|
|
8 | Variant Code (Serviced) (Variant Code (Serviced)) | Code10 |
|
|
9 | Service Item No. (Serviced) (Service Item No. (Serviced)) | Code20 |
|
|
10 | Item No. (Serviced) (Item No. (Serviced)) | Code20 |
|
|
11 | Serial No. (Serviced) (Serial No. (Serviced)) | Code20 | ||
12 | Service Item Group (Serviced) (Service Item Group (Serviced)) | Code10 |
|
|
13 | Service Order No. (Service Order No.) | Code20 | ||
14 | Service Contract No. (Service Contract No.) | Code20 |
|
|
15 | Fault Reason Code (Fault Reason Code) | Code10 |
|
|
16 | Fault Area Code (Fault Area Code) | Code10 |
|
|
17 | Fault Code (Fault Code) | Code10 |
|
|
18 | Symptom Code (Symptom Code) | Code10 |
|
|
19 | Resolution Code (Resolution Code) | Code10 |
|
|
20 | Type (Type) | Option | [ ,Item,Resource,Service Cost] | |
21 | No. (No.) | Code20 |
|
|
22 | Quantity (Quantity) | Decimal (0:5) | ||
24 | Work Type Code (Work Type Code) | Code10 |
|
|
25 | Unit of Measure Code (Unit of Measure Code) | Code10 |
|
|
26 | Amount (Amount) | Decimal | AutoFormatType: 1 | |
27 | Description (Description) | Text50 | ||
29 | Gen. Bus. Posting Group (Gen. Bus. Posting Group) | Code10 |
|
|
30 | Gen. Prod. Posting Group (Gen. Prod. Posting Group) | Code10 |
|
|
31 | Global Dimension 1 Code (Global Dimension 1 Code) | Code20 | CaptionClass: '1,2,1'
|
|
32 | Global Dimension 2 Code (Global Dimension 2 Code) | Code20 | CaptionClass: '1,2,2'
|
|
33 | Open (Open) | Boolean | ||
35 | Vendor No. (Vendor No.) | Code20 |
|
|
36 | Vendor Item No. (Vendor Item No.) | Text20 | ||
38 | Variant Code (Variant Code) | Code10 |
|
|
39 | Service Order Line No. (Service Order Line No.) | Integer | ||
480 | Dimension Set ID (Dimension Set ID) | Integer |
|
Editable: No |
Keys
# | Fields | ||
---|---|---|---|
0 | Entry No. (Entry No.) | Clustered: Yes | |
1 | Service Item No. (Serviced),Posting Date,Document No. (Service Item No. (Serviced),Posting Date,Document No.) | ||
2 | Service Order No.,Posting Date,Document No. (Service Order No.,Posting Date,Document No.) | ||
3 | Service Contract No.,Posting Date,Document No. (Service Contract No.,Posting Date,Document No.) | ||
4 | Document No.,Posting Date (Document No.,Posting Date) |
Table Relations To Other Tables
Field | Related Table | Related Field | ||
---|---|---|---|---|
Bill-to Customer No. (Bill-to Customer No.) | Customer | No. (No.) |
|
1..n |
Dimension Set ID (Dimension Set ID) | Dimension Set Entry | () |
|
1..n |
Global Dimension 2 Code (Global 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 |
Gen. Bus. Posting Group (Gen. Bus. Posting Group) | Gen. Business Posting Group | Code (Code) |
|
1..n |
Gen. Prod. Posting Group (Gen. Prod. Posting Group) | Gen. Product Posting Group | Code (Code) |
|
1..n |
No. (No.) | Item | No. (No.) |
|
1..n |
Unit of Measure Code (Unit of Measure Code) | Item Unit of Measure | Code (Code) |
|
1..n |
Variant Code (Variant Code) | Item Variant | Code (Code) |
|
1..n |
Resolution Code (Resolution Code) | Resolution Code | Code (Code) |
|
1..n |
No. (No.) | Resource | No. (No.) |
|
1..n |
Service Contract No. (Service Contract No.) | Service Contract Header | Contract No. (Contract No.) |
|
1..n |
No. (No.) | Service Cost | Code (Code) |
|
1..n |
Service Item No. (Serviced) (Service Item No. (Serviced)) | Service Item | No. (No.) |
|
1..n |
Service Item Group (Serviced) (Service Item Group (Serviced)) | Service Item Group | Code (Code) |
|
1..n |
Ship-to Code (Ship-to Code) | Ship-to Address | Code (Code) |
|
1..n |
No. (No.) | Standard Text | Code (Code) |
|
1..n |
Symptom Code (Symptom Code) | Symptom Code | Code (Code) |
|
1..n |
Unit of Measure Code (Unit of Measure Code) | Unit of Measure | Code (Code) |
|
1..n |
Vendor No. (Vendor No.) | Vendor | No. (No.) |
|
1..n |
Work Type Code (Work Type Code) | Work Type | Code (Code) |
|
1..n |
Table Relations From Other Tables
From Table | From Field | ||
---|---|---|---|
Service Register | To Warranty Entry No. (To Warranty Entry No.) |
|
1..n |