Diagrams

Table

Service Item Component

DynamicsDocs.comService Item Component«Table 5941»Service Item ComponentParent Service Item No. [PK]Line No. [PK]Active [PK]Type; [Service Item,Item]No.Date InstalledVariant CodeSerial No.DescriptionDescription 2Service Order No.From Line No.Last Date Modified«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 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 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2<Parent Service Item No.><No.><No.><Variant Code><Item No.><Variant Code><Alternative Item No.><Variant Filter><Item No.>

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

Fields

# Name Type
1 Parent Service Item No. (Parent Service Item No.) Code20
3 Line No. (Line No.) Integer
4 Active (Active) Boolean
5 Type (Type) Option
6 No. (No.) Code20
7 Date Installed (Date Installed) Date
8 Variant Code (Variant Code) Code10
11 Serial No. (Serial No.) Code20
12 Description (Description) Text50
13 Description 2 (Description 2) Text50
15 Service Order No. (Service Order No.) Code20
16 From Line No. (From Line No.) Integer
17 Last Date Modified (Last Date Modified) Date

Keys

# Fields
0 Active,Parent Service Item No.,Line No. (Active,Parent Service Item No.,Line No.) Clustered: Yes
1 Active,Parent Service Item No.,From Line No. (Active,Parent Service Item No.,From Line No.)
2 Type,No.,Active (Type,No.,Active)
3 Active,Parent Service Item No.,Type,No. (Active,Parent Service Item No.,Type,No.)
4 Parent Service Item No.,Line No. (Parent Service Item No.,Line No.)

Table Relations To Other Tables

Field Related Table Related Field
No. (No.) Item No. (No.) 1..n
Variant Code (Variant Code) Item Variant Code (Code) 1..n
No. (No.) Service Item No. (No.) 1..n

Table Relations From Other Tables

From Table From Field