Diagrams

Table

Service Comment Line

DynamicsDocs.comService Comment Line«Table 5906»Service Comment LineType; [General,Fault,Resolution,Access...No. [PK,NN]Table Line No. [PK]Line No. [PK]CommentDateTable Subtype; [0,1,2,3] [PK]Table Name; [Service Contract,Service...«Table 5965»Service Contract HeaderContract No. [PK]Contract Type; [Quote,Contract] [PK]DescriptionDescription 2Status; [,Signed,Canceled]Change Status; [Open,Locked]Customer No. [NN]NameAddressAddress 2Post CodeCityContact NameYour ReferenceSalesperson CodeBill-to Customer No.Bill-to NameBill-to AddressBill-to Address 2Bill-to Post CodeBill-to CityShip-to CodeShip-to NameShip-to AddressShip-to Address 2Ship-to Post CodeShip-to CityServ. Contract Acc. Gr. CodeInvoice Period; [Month,Two Months,Quar...Last Invoice DateNext Invoice Date...«Table 5900»Service HeaderDocument Type; [Quote,Order,Invoice,Cr...Customer No.No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder Date [NN]Posting DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting GroupCurrency Code...«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...«Table 5913»LoanerNo. [PK]DescriptionDescription 2Unit of Measure CodeItem No.Last Date ModifiedCommentBlockedNo. SeriesDocument No.LentSerial No.Document Type; [,Quote,Order]<No.><No.><No.><No.><Contract No.><Contract Filter><Contract Filter><Service Order Filter>

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

Fields

# Name Type
1 Type (Type) Option
2 No. (No.) Code20 NotBlank: Yes
3 Table Line No. (Table Line No.) Integer
4 Line No. (Line No.) Integer
6 Comment (Comment) Text80
7 Date (Date) Date
8 Table Subtype (Table Subtype) Option
9 Table Name (Table Name) Option

Keys

# Fields
0 Table Name,Table Subtype,No.,Type,Table Line No.,Line No. (Table Name,Table Subtype,No.,Type,Table Line No.,Line No.) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
No. (No.) Loaner No. (No.) 1..n
No. (No.) Service Contract Header Contract No. (Contract No.) 1..n
No. (No.) Service Header No. (No.) 1..n
No. (No.) Service Item No. (No.) 1..n

Table Relations From Other Tables

From Table From Field