Diagrams

Table

Repair Status

DynamicsDocs.comRepair Status«Table 5927»Repair StatusCode [PK,NN]DescriptionService Order Status; [Pending,In Proc...Priority; [High,Medium High,Medium Low...InitialPartly ServicedIn ProcessFinishedReferredSpare Part OrderedSpare Part ReceivedWaiting for CustomerQuote FinishedPosting AllowedPending Status AllowedIn Process Status AllowedFinished Status AllowedOn Hold Status Allowed«Table 5901»Service Item LineDocument No. [PK]Line No. [PK]Service Item No.Service Item Group CodeItem No.Serial No.DescriptionDescription 2Repair Status CodePriority; [Low,Medium,High]Response Time [Hours]Response DateResponse TimeStarting DateStarting TimeFinishing DateFinishing TimeService Shelf No.Warranty Starting Date [Parts]Warranty Ending Date [Parts]WarrantyWarranty % [Parts]Warranty % [Labor]Warranty Starting Date [Labor]Warranty Ending Date [Labor]Contract No.Location of Service ItemLoaner No.Vendor No.Vendor Item No.Fault Reason Code...<Repair Status Code><Repair Status Code Filter>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 Code (Code) Code10 NotBlank: Yes
2 Description (Description) Text50
3 Service Order Status (Service Order Status) Option
4 Priority (Priority) Option Editable: No
5 Initial (Initial) Boolean
6 Partly Serviced (Partly Serviced) Boolean
7 In Process (In Process) Boolean
8 Finished (Finished) Boolean
9 Referred (Referred) Boolean
10 Spare Part Ordered (Spare Part Ordered) Boolean
11 Spare Part Received (Spare Part Received) Boolean
12 Waiting for Customer (Waiting for Customer) Boolean
13 Quote Finished (Quote Finished) Boolean
20 Posting Allowed (Posting Allowed) Boolean
21 Pending Status Allowed (Pending Status Allowed) Boolean
22 In Process Status Allowed (In Process Status Allowed) Boolean
23 Finished Status Allowed (Finished Status Allowed) Boolean
24 On Hold Status Allowed (On Hold Status Allowed) Boolean

Keys

# Fields
0 Code (Code) Clustered: Yes
1 Priority (Priority)
2 Description (Description)

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field
Service Item Line Repair Status Code Filter (Repair Status Code Filter) 1..n