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 | ||
| 2 | Serial No. (Serial No.) | Code20 | ||
| 3 | Service Item Group Code (Service Item Group Code) | Code10 |
|
|
| 4 | Description (Description) | Text50 | ||
| 5 | Description 2 (Description 2) | Text50 | ||
| 6 | Status (Status) | Option | [ ,Own Service Item,Installed,Temporarily Installed,Defective] | |
| 7 | Priority (Priority) | Option | [Low,Medium,High] | |
| 8 | Customer No. (Customer No.) | Code20 |
|
|
| 9 | Ship-to Code (Ship-to Code) | Code10 |
|
|
| 10 | Item No. (Item No.) | Code20 |
|
|
| 11 | Unit of Measure Code (Unit of Measure Code) | Code10 |
|
|
| 12 | Location of Service Item (Location of Service Item) | Text30 | ||
| 13 | Sales Unit Price (Sales Unit Price) | Decimal | AutoFormatType: 2 | BlankZero: Yes |
| 14 | Sales Unit Cost (Sales Unit Cost) | Decimal | AutoFormatType: 2 | BlankZero: Yes |
| 15 | Warranty Starting Date (Labor) (Warranty Starting Date (Labor)) | Date | ||
| 16 | Warranty Ending Date (Labor) (Warranty Ending Date (Labor)) | Date | ||
| 17 | Warranty Starting Date (Parts) (Warranty Starting Date (Parts)) | Date | ||
| 18 | Warranty Ending Date (Parts) (Warranty Ending Date (Parts)) | Date | ||
| 19 | Warranty % (Parts) (Warranty % (Parts)) | Decimal (0:5) | MaxValue: 100 | BlankZero: Yes |
| 20 | Warranty % (Labor) (Warranty % (Labor)) | Decimal (0:5) | MaxValue: 100 | BlankZero: Yes |
| 21 | Response Time (Hours) (Response Time (Hours)) | Decimal (0:5) | BlankZero: Yes | |
| 22 | Installation Date (Installation Date) | Date | ||
| 23 | Sales Date (Sales Date) | Date | ||
| 24 | Last Service Date (Last Service Date) | Date | ||
| 25 | Default Contract Value (Default Contract Value) | Decimal | AutoFormatType: 2 | BlankZero: Yes |
| 26 | Default Contract Discount % (Default Contract Discount %) | Decimal (0:5) | MaxValue: 100 | BlankZero: Yes |
| 28 | No. of Active Contracts (No. of Active Contracts) | Integer |
|
FlowField |
| 33 | Vendor No. (Vendor No.) | Code20 |
|
|
| 34 | Vendor Item No. (Vendor Item No.) | Code20 | ||
| 47 | No. Series (No. Series) | Code10 |
|
|
| 48 | Item Description (Item Description) | Text50 |
|
Editable: No FlowField |
| 49 | Name (Name) | Text50 |
|
Editable: No FlowField |
| 50 | Address (Address) | Text50 |
|
Editable: No FlowField |
| 51 | Address 2 (Address 2) | Text50 |
|
Editable: No FlowField |
| 52 | Post Code (Post Code) | Code20 |
|
Editable: No FlowField |
| 53 | City (City) | Text30 |
|
Editable: No FlowField |
| 54 | Contact (Contact) | Text50 |
|
Editable: No FlowField |
| 55 | Phone No. (Phone No.) | Text30 [Phone No.] |
|
Editable: No FlowField |
| 56 | Ship-to Name (Ship-to Name) | Text50 |
|
Editable: No FlowField |
| 57 | Ship-to Address (Ship-to Address) | Text50 |
|
Editable: No FlowField |
| 58 | Ship-to Address 2 (Ship-to Address 2) | Text50 |
|
Editable: No FlowField |
| 59 | Ship-to Post Code (Ship-to Post Code) | Code20 |
|
Editable: No FlowField |
| 60 | Ship-to City (Ship-to City) | Text30 |
|
Editable: No FlowField |
| 61 | Ship-to Contact (Ship-to Contact) | Text50 |
|
Editable: No FlowField |
| 62 | Ship-to Phone No. (Ship-to Phone No.) | Text30 [Phone No.] |
|
Editable: No FlowField |
| 63 | Usage (Cost) (Usage (Cost)) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 64 | Usage (Amount) (Usage (Amount)) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 65 | Invoiced Amount (Invoiced Amount) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 66 | Total Quantity (Total Quantity) | Decimal (0:5) |
|
Editable: No FlowField |
| 67 | Total Qty. Invoiced (Total Qty. Invoiced) | Decimal (0:5) |
|
Editable: No FlowField |
| 68 | Resources Used (Resources Used) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 69 | Parts Used (Parts Used) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 70 | Cost Used (Cost Used) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 71 | Vendor Name (Vendor Name) | Text50 |
|
Editable: No FlowField |
| 72 | Vendor Item Name (Vendor Item Name) | Text50 | ||
| 73 | Comment (Comment) | Boolean |
|
Editable: No FlowField |
| 74 | Service Item Components (Service Item Components) | Boolean |
|
Editable: No FlowField |
| 75 | Preferred Resource (Preferred Resource) | Code20 |
|
|
| 76 | Variant Code (Variant Code) | Code10 |
|
|
| 77 | County (County) | Text30 |
|
Editable: No FlowField |
| 78 | Ship-to County (Ship-to County) | Text30 |
|
Editable: No FlowField |
| 79 | Contract Cost (Contract Cost) | Decimal |
|
FlowField |
| 81 | Country/Region Code (Country/Region Code) | Code10 |
|
Editable: No FlowField |
| 82 | Ship-to Country/Region Code (Ship-to Country/Region Code) | Code10 |
|
Editable: No FlowField |
| 83 | Name 2 (Name 2) | Text50 |
|
Editable: No FlowField |
| 84 | Ship-to Name 2 (Ship-to Name 2) | Text50 |
|
Editable: No FlowField |
| 85 | Service Price Group Code (Service Price Group Code) | Code10 |
|
|
| 86 | Default Contract Cost (Default Contract Cost) | Decimal | AutoFormatType: 2 | BlankZero: Yes |
| 87 | Prepaid Amount (Prepaid Amount) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 88 | Search Description (Search Description) | Code50 | ||
| 89 | Service Contracts (Service Contracts) | Boolean |
|
Editable: No FlowField |
| 90 | Total Qty. Consumed (Total Qty. Consumed) | Decimal (0:5) |
|
Editable: No FlowField |
| 100 | Date Filter (Date Filter) | Date | FlowFilter | |
| 101 | Type Filter (Type Filter) | Option | [ ,Resource,Item,Service Cost,Service Contract,G/L Account] | FlowFilter |
| 102 | Contract Filter (Contract Filter) | Code20 |
|
FlowFilter |
| 103 | Service Order Filter (Service Order Filter) | Code20 |
|
FlowFilter |
| 104 | Sales/Serv. Shpt. Document No. (Sales/Serv. Shpt. Document No.) | Code20 |
|
|
| 105 | Sales/Serv. Shpt. Line No. (Sales/Serv. Shpt. Line No.) | Integer |
|
|
| 106 | Shipment Type (Shipment Type) | Option | [Sales,Service] |
Keys
| # | Fields | ||
|---|---|---|---|
| 0 | No. (No.) | Clustered: Yes | |
| 1 | Item No.,Serial No. (Item No.,Serial No.) | ||
| 2 | Customer No.,Ship-to Code,Item No.,Serial No. (Customer No.,Ship-to Code,Item No.,Serial No.) | ||
| 3 | Warranty Ending Date (Parts),Customer No.,Ship-to Code (Warranty Ending Date (Parts),Customer No.,Ship-to Code) | ||
| 4 | Sales/Serv. Shpt. Document No.,Sales/Serv. Shpt. Line No. (Sales/Serv. Shpt. Document No.,Sales/Serv. Shpt. Line No.) | ||
| 5 | Service Item Group Code (Service Item Group Code) |
Table Relations To Other Tables
| Field | Related Table | Related Field | ||
|---|---|---|---|---|
| Customer No. (Customer No.) | Customer | No. (No.) |
|
1..n |
| Item No. (Item 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 |
| No. Series (No. Series) | No. Series | Code (Code) |
|
1..n |
| Preferred Resource (Preferred Resource) | Resource | No. (No.) |
|
1..n |
| Sales/Serv. Shpt. Line No. (Sales/Serv. Shpt. Line No.) | Sales Shipment Line | Line No. (Line No.) |
|
1..n |
| Contract Filter (Contract Filter) | Service Contract Header | Contract No. (Contract No.) |
|
1..n |
| Service Order Filter (Service Order Filter) | Service Header | No. (No.) |
|
1..n |
| Service Item Group Code (Service Item Group Code) | Service Item Group | Code (Code) |
|
1..n |
| Service Price Group Code (Service Price Group Code) | Service Price Group | Code (Code) |
|
1..n |
| Ship-to Code (Ship-to Code) | Ship-to Address | 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 |
Table Relations From Other Tables
| From Table | From Field | ||
|---|---|---|---|
| Default Dimension | No. (No.) |
|
1..n |
| Filed Contract Line | Service Item No. (Service Item No.) |
|
1..n |
| Loaner Entry | Service Item No. (Service Item No.) |
|
1..n |
| Resource Skill | No. (No.) |
|
1..n |
| Sales Line Archive | Service Item No. (Service Item No.) |
|
1..n |
| Service Comment Line | No. (No.) |
|
1..n |
| Service Contract Line | Service Item No. (Service Item No.) |
|
1..n |
| Service Cr.Memo Line | Service Item No. (Service Item No.) |
|
1..n |
| Service Invoice Line | Replaced Item No. (Replaced Item No.) |
|
1..n |
| Service Item Component | No. (No.) |
|
1..n |
| Service Item Line | Service Item No. (Service Item No.) |
|
1..n |
| Service Item Log | Service Item No. (Service Item No.) |
|
1..n |
| Service Ledger Entry | Service Item No. (Serviced) (Service Item No. (Serviced)) |
|
1..n |
| Service Line | Replaced Item No. (Replaced Item No.) |
|
1..n |
| Service Line Price Adjmt. | Service Item No. (Service Item No.) |
|
1..n |
| Service Order Allocation | Service Item No. (Service Item No.) |
|
1..n |
| Service Shipment Item Line | Service Item No. (Service Item No.) |
|
1..n |
| Service Shipment Line | Replaced Item No. (Replaced Item No.) |
|
1..n |
| Troubleshooting Setup | No. (No.) |
|
1..n |
| Warranty Ledger Entry | Service Item No. (Serviced) (Service Item No. (Serviced)) |
|
1..n |