Diagrams

Table

Service Register

DynamicsDocs.comService Register«Table 5934»Service RegisterNo. [PK]From Entry No.To Entry No.From Warranty Entry No.To Warranty Entry No.Creation DateSource CodeUser ID«Table 5907»Service Ledger EntryEntry No. [PK]Service Contract No.Document Type; [,Payment,Invoice,Credi...Document No.Serv. Contract Acc. Gr. CodeDocument Line No.Moved from Prepaid Acc.Posting DateAmount [LCY]Customer No.Ship-to CodeItem No. [Serviced]Serial No. [Serviced]User IDContract Invoice PeriodGlobal Dimension 1 CodeGlobal Dimension 2 CodeService Item No. [Serviced]Variant Code [Serviced]Contract Group CodeType; [,Resource,Item,Service Cost,Ser...No.Cost AmountDiscount AmountUnit CostQuantityCharged Qty.Unit PriceDiscount %Contract Disc. AmountBill-to Customer No....«Table 5908»Warranty Ledger EntryEntry No. [PK]Document No.Posting DateCustomer No.Ship-to CodeBill-to Customer No.Variant Code [Serviced]Service Item No. [Serviced]Item No. [Serviced]Serial No. [Serviced]Service Item Group [Serviced]Service Order No.Service Contract No.Fault Reason CodeFault Area CodeFault CodeSymptom CodeResolution CodeType; [,Item,Resource,Service Cost]No.QuantityWork Type CodeUnit of Measure CodeAmountDescriptionGen. Bus. Posting GroupGen. Prod. Posting GroupGlobal Dimension 1 CodeGlobal Dimension 2 CodeOpenVendor No....«Table 230»Source CodeCode [PK,NN]Description«Table 2000000120»UserUser Security ID [PK]User NameFull NameState; [Enabled,Disabled]Expiry DateWindows Security IDChange PasswordLicense Type; [Full User,Limited User,...Authentication EmailContact EmailExchange IdentifierApplication ID<From Entry No.><To Entry No.><From Warranty Entry No.><To Warranty Entry No.><Source Code><User ID><User ID>

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

Fields

# Name Type
1 No. (No.) Integer
2 From Entry No. (From Entry No.) Integer
3 To Entry No. (To Entry No.) Integer
4 From Warranty Entry No. (From Warranty Entry No.) Integer
5 To Warranty Entry No. (To Warranty Entry No.) Integer
6 Creation Date (Creation Date) Date
7 Source Code (Source Code) Code10
8 User ID (User ID) Code50

Keys

# Fields
0 No. (No.) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
To Entry No. (To Entry No.) Service Ledger Entry Entry No. (Entry No.) 1..n
Source Code (Source Code) Source Code Code (Code) 1..n
User ID (User ID) User User Name (User Name) 1..n
To Warranty Entry No. (To Warranty Entry No.) Warranty Ledger Entry Entry No. (Entry No.) 1..n

Table Relations From Other Tables

From Table From Field