Diagrams

Table

Loaner

DynamicsDocs.comLoaner«Table 5913»LoanerNo. [PK]DescriptionDescription 2Unit of Measure CodeItem No.Last Date ModifiedCommentBlockedNo. SeriesDocument No.LentSerial No.Document Type; [,Quote,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 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 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 5989»Service Shipment Item LineNo. [PK]Line No. [PK]Service Item No.Service Item Group CodeItem No.Serial No.DescriptionDescription 2Priority; [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 CodeService Price Group Code...«Table 5404»Item Unit of MeasureItem No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureLengthWidthHeightCubageWeight«Table 204»Unit of MeasureCode [PK,NN]DescriptionInternational Standard Code«Table 27»ItemNo. [PK]No. 2DescriptionSearch DescriptionDescription 2Assembly BOMBase Unit of MeasurePrice Unit ConversionType; [Inventory,Service]Inventory Posting GroupShelf No.Item Disc. GroupAllow Invoice Disc.Statistics GroupCommission GroupUnit PricePrice/Profit Calculation; [Profit=Pric...Profit %Costing Method; [FIFO,LIFO,Specific,Av...Unit CostStandard CostLast Direct CostIndirect Cost %Cost is AdjustedAllow Online AdjustmentVendor No.Vendor Item No.Lead Time CalculationReorder PointMaximum InventoryReorder Quantity...«Table 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order<Unit of Measure Code><Unit of Measure Code><Item No.><No. Series><Loaner No.><No.><Loaner No.><Loaner No.><Item No.><Item No.><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Code><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Alternative Item No.><No. Series><Serial Nos.><Lot Nos.>

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

Fields

# Name Type
1 No. (No.) Code20
2 Description (Description) Text50
4 Description 2 (Description 2) Text50
5 Unit of Measure Code (Unit of Measure Code) Code10
6 Item No. (Item No.) Code20
7 Last Date Modified (Last Date Modified) Date Editable: No
8 Comment (Comment) Boolean Editable: No
FlowField
9 Blocked (Blocked) Boolean
11 No. Series (No. Series) Code10 Editable: No
12 Document No. (Document No.) Code20 Editable: No
FlowField
13 Lent (Lent) Boolean Editable: No
FlowField
14 Serial No. (Serial No.) Code20
15 Document Type (Document Type) Option Editable: No
FlowField

Keys

# Fields
0 No. (No.) Clustered: Yes
1 Description (Description)
2 Item No. (Item No.)

Table Relations To Other Tables

Field Related Table Related Field
Item No. (Item No.) Item No. (No.) 1..n
Unit of Measure Code (Unit of Measure Code) Item Unit of Measure Code (Code) 1..n
No. Series (No. Series) No. Series Code (Code) 1..n
Unit of Measure Code (Unit of Measure Code) Unit of Measure Code (Code) 1..n

Table Relations From Other Tables

From Table From Field
Loaner Entry Loaner No. (Loaner No.) 1..n
Service Comment Line No. (No.) 1..n
Service Item Line Loaner No. (Loaner No.) 1..n
Service Shipment Item Line Loaner No. (Loaner No.) 1..n