Diagrams


Table

Service Order Allocation

DynamicsDocs.comService Order Allocation«Table 5950»Service Order AllocationEntry No. [PK]Status; [Nonactive,Active,Finished,Can...Document No.Allocation DateResource No.Resource Group No.Service Item Line No.Allocated HoursStarting TimeFinishing TimeDescriptionReason CodeService Item No.PostedService Item DescriptionService Item Serial No.Repair StatusService StartedDocument Type; [Quote,Order]«Table 156»ResourceNo. [PK]Type; [Person,Machine]NameSearch NameName 2AddressAddress 2CitySocial Security No.Job TitleEducationContract ClassEmployment DateResource Group No.Global Dimension 1 CodeGlobal Dimension 2 CodeBase Unit of MeasureDirect Unit CostIndirect Cost %Unit CostProfit %Price/Profit Calculation; [Profit=Pric...Unit PriceVendor No.Last Date ModifiedCommentBlockedDate FilterUnit of Measure FilterCapacityQty. on Order [Job]...«Table 152»Resource GroupNo. [PK,NN]NameDate FilterCapacityQty. on Order [Job]Qty. Quoted [Job]Unit of Measure FilterUsage [Qty.]Usage [Cost]Usage [Price]Sales [Qty.]Sales [Cost]Sales [Price]Chargeable FilterGlobal Dimension 1 CodeGlobal Dimension 2 CodeNo. of Resources AssignedQty. on Service Order«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...«Table 231»Reason CodeCode [PK,NN]DescriptionDate FilterContract Gain/Loss Amount«Table 5940»Service ItemNo. [PK]Serial No.Service Item Group CodeDescriptionDescription 2Status; [,Own Service Item,Installed,T...Priority; [Low,Medium,High]Customer No.Ship-to CodeItem No.Unit of Measure CodeLocation of Service ItemSales Unit PriceSales Unit CostWarranty Starting Date [Labor]Warranty Ending Date [Labor]Warranty Starting Date [Parts]Warranty Ending Date [Parts]Warranty % [Parts]Warranty % [Labor]Response Time [Hours]Installation DateSales DateLast Service DateDefault Contract ValueDefault Contract Discount %No. of Active ContractsVendor No.Vendor Item No.No. SeriesItem Description...<Resource No.><Resource Group No.><Service Item Line No.><Reason Code><Service Item No.><Resource Group No.><Resource Filter><Preferred Resource><Resource Group Filter><Service Item No.>

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

Fields

# Name Type
1 Entry No. Integer
2 Status Option Editable: No
3 Document No. Code20 Editable: No
4 Allocation Date Date
5 Resource No. Code20
6 Resource Group No. Code20
7 Service Item Line No. Integer
8 Allocated Hours Decimal (0:5)
9 Starting Time Time
10 Finishing Time Time
11 Description Text50
12 Reason Code Code10
13 Service Item No. Code20
14 Posted Boolean
15 Service Item Description Text50 Editable: No
FlowField
16 Service Item Serial No. Code20
17 Repair Status Code20 Editable: No
FlowField
18 Service Started Boolean
19 Document Type Option Editable: No

Keys

# Fields
0 Entry No. Clustered: Yes
1 Status,Document Type,Document No.,Service Item Line No.,Allocation Date,Starting Time,Posted
2 Document Type,Document No.,Status,Resource Group No.,Allocation Date,Starting Time,Posted
3 Status,Document Type,Document No.,Service Item Line No.,Resource No.,Allocation Date,Starting Time,Posted
4 Document Type,Document No.,Service Item Line No.,Allocation Date,Starting Time,Posted
5 Resource No.,Document Type,Allocation Date,Status,Posted

Table Relations To Other Tables

Field Related Table Related Field
Reason Code Reason Code Code 1..n
Resource No. Resource No. 1..n
Resource Group No. Resource Group No. 1..n
Service Item No. Service Item No. 1..n
Service Item Line No. Service Item Line Line No. 1..n

Table Relations From Other Tables

From Table From Field