Diagrams

Table

Loaner Entry

DynamicsDocs.comLoaner Entry«Table 5914»Loaner EntryEntry No. [PK]Loaner No.Document No.Service Item Line No.Service Item No.Service Item Group CodeCustomer No.Date LentTime LentDate ReceivedTime ReceivedLentDocument Type; [,Quote,Order]«Table 5913»LoanerNo. [PK]DescriptionDescription 2Unit of Measure CodeItem No.Last Date ModifiedCommentBlockedNo. SeriesDocument No.LentSerial No.Document Type; [,Quote,Order]«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 5904»Service Item GroupCode [PK,NN]DescriptionCreate Service ItemDefault Contract Discount %Default Serv. Price Group CodeDefault Response Time [Hours]«Table 18»CustomerNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Document Sending ProfileOur Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameBudgeted AmountCredit Limit [LCY]Customer Posting GroupCurrency CodeCustomer Price GroupLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodeSalesperson CodeShipment Method CodeShipping Agent CodePlace of ExportInvoice Disc. CodeCustomer Disc. Group...<Loaner No.><Service Item No.><Service Item Group Code><Customer No.><Service Item Group Code><Customer No.><Bill-to Customer 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. (Entry No.) Integer
2 Loaner No. (Loaner No.) Code20
3 Document No. (Document No.) Code20
4 Service Item Line No. (Service Item Line No.) Integer
5 Service Item No. (Service Item No.) Code20
6 Service Item Group Code (Service Item Group Code) Code10
7 Customer No. (Customer No.) Code20
8 Date Lent (Date Lent) Date
9 Time Lent (Time Lent) Time
10 Date Received (Date Received) Date
11 Time Received (Time Received) Time
12 Lent (Lent) Boolean
14 Document Type (Document Type) Option

Keys

# Fields
0 Entry No. (Entry No.) Clustered: Yes
1 Loaner No.,Document Type,Document No. (Loaner No.,Document Type,Document No.)
2 Document Type,Document No.,Loaner No.,Lent (Document Type,Document No.,Loaner No.,Lent)
3 Loaner No.,Date Lent,Time Lent,Date Received,Time Received (Loaner No.,Date Lent,Time Lent,Date Received,Time Received)

Table Relations To Other Tables

Field Related Table Related Field
Customer No. (Customer No.) Customer No. (No.) 1..n
Loaner No. (Loaner No.) Loaner No. (No.) 1..n
Service Item No. (Service Item No.) Service Item No. (No.) 1..n
Service Item Group Code (Service Item Group Code) Service Item Group Code (Code) 1..n

Table Relations From Other Tables

From Table From Field