Diagrams


Table

Service Item

DynamicsDocs.comService Item«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 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 5942»Service Item LogService Item No. [PK,NN]Entry No. [PK]Event No.Document No.AfterBeforeChange DateChange TimeUser IDDocument Type; [,Quote,Order,Contract]«Table 5945»Troubleshooting SetupType; [Service Item Group,Item,Service...No. [PK]Troubleshooting No. [PK,NN]Troubleshooting Description«Table 5950»Service Order AllocationEntry No. [PK]Status; [Nonactive,Active,Finished,Can...Document No.Allocation DateResource No.Resource Group No.Service Item Line No.Allocated HoursStarting TimeFinishing TimeDescriptionReason CodeService Item No.PostedService Item DescriptionService Item Serial No.Repair StatusService StartedDocument Type; [Quote,Order]«Table 5956»Resource SkillType; [Resource,Service Item Group,Ite...No. [PK,NN]Skill Code [PK,NN]Assigned From; [,Service Item Group,It...Source Type; [,Service Item Group,Item...Source Code«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...«Table 222»Ship-to AddressCustomer No. [PK,NN]Code [PK,NN]NameName 2AddressAddress 2CityContactPhone No.Telex No.Shipment Method CodeShipping Agent CodePlace of ExportCountry/Region CodeLast Date ModifiedLocation CodeFax No.Telex Answer BackPost CodeCountyE-MailHome PageTax Area CodeTax LiableShipping Agent Service CodeService Zone 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 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 CodeSymbolLast Modified Date TimeId«Table 23»VendorNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Our Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeBudgeted AmountVendor Posting GroupCurrency CodeLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodePurchaser CodeShipment Method CodeShipping Agent CodeInvoice Disc. CodeCountry/Region CodeCommentBlocked; [,Payment,All]Pay-to Vendor No.PriorityPayment Method Code...«Table 156»ResourceNo. [PK]Type; [Person,Machine]NameSearch NameName 2AddressAddress 2CitySocial Security No.Job TitleEducationContract ClassEmployment DateResource Group No.Global Dimension 1 CodeGlobal Dimension 2 CodeBase Unit of MeasureDirect Unit CostIndirect Cost %Unit CostProfit %Price/Profit Calculation; [Profit=Pric...Unit PriceVendor No.Last Date ModifiedCommentBlockedDate FilterUnit of Measure FilterCapacityQty. on Order [Job]...«Table 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2«Table 6080»Service Price GroupCode [PK,NN]Description<Service Item Group Code><Customer No.><Ship-to Code><Item No.><Unit of Measure Code><Unit of Measure Code><Vendor No.><Preferred Resource><Variant Code><Service Price Group Code><Parent Service Item No.><No.><Service Item No.><No.><Service Item No.><No.><No.><Variant Code><No.><No.><Resource No.><No.><No.><No.><Default Serv. Price Group Code><Service Item Group><Bill-to Customer No.><Ship-to Filter><Customer No.><Vendor No.><Alternative Item No.><Variant Filter><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Unit of Measure Id><Code><Base Unit of Measure><Unit of Measure Filter><Pay-to Vendor No.><Vendor No.>

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

Fields

# Name Type
1 No. Code20
2 Serial No. Code20
3 Service Item Group Code Code10
4 Description Text50
5 Description 2 Text50
6 Status Option
7 Priority Option
8 Customer No. Code20
9 Ship-to Code Code10
10 Item No. Code20
11 Unit of Measure Code Code10
12 Location of Service Item Text30
13 Sales Unit Price Decimal BlankZero: Yes
14 Sales Unit Cost Decimal BlankZero: Yes
15 Warranty Starting Date (Labor) Date
16 Warranty Ending Date (Labor) Date
17 Warranty Starting Date (Parts) Date
18 Warranty Ending Date (Parts) Date
19 Warranty % (Parts) Decimal (0:5) BlankZero: Yes
20 Warranty % (Labor) Decimal (0:5) BlankZero: Yes
21 Response Time (Hours) Decimal (0:5) BlankZero: Yes
22 Installation Date Date
23 Sales Date Date
24 Last Service Date Date
25 Default Contract Value Decimal BlankZero: Yes
26 Default Contract Discount % Decimal (0:5) BlankZero: Yes
28 No. of Active Contracts Integer FlowField
33 Vendor No. Code20
34 Vendor Item No. Code20
47 No. Series Code20
48 Item Description Text50 Editable: No
FlowField
49 Name Text50 Editable: No
FlowField
50 Address Text50 Editable: No
FlowField
51 Address 2 Text50 Editable: No
FlowField
52 Post Code Code20 Editable: No
FlowField
53 City Text30 Editable: No
FlowField
54 Contact Text50 Editable: No
FlowField
55 Phone No. Text30 [Phone No.] Editable: No
FlowField
56 Ship-to Name Text50 Editable: No
FlowField
57 Ship-to Address Text50 Editable: No
FlowField
58 Ship-to Address 2 Text50 Editable: No
FlowField
59 Ship-to Post Code Code20 Editable: No
FlowField
60 Ship-to City Text30 Editable: No
FlowField
61 Ship-to Contact Text50 Editable: No
FlowField
62 Ship-to Phone No. Text30 [Phone No.] Editable: No
FlowField
63 Usage (Cost) Decimal Editable: No
FlowField
64 Usage (Amount) Decimal Editable: No
FlowField
65 Invoiced Amount Decimal Editable: No
FlowField
66 Total Quantity Decimal (0:5) Editable: No
FlowField
67 Total Qty. Invoiced Decimal (0:5) Editable: No
FlowField
68 Resources Used Decimal Editable: No
FlowField
69 Parts Used Decimal Editable: No
FlowField
70 Cost Used Decimal Editable: No
FlowField
71 Vendor Name Text50 Editable: No
FlowField
72 Vendor Item Name Text50
73 Comment Boolean Editable: No
FlowField
74 Service Item Components Boolean Editable: No
FlowField
75 Preferred Resource Code20
76 Variant Code Code10
77 County Text30 Editable: No
FlowField
78 Ship-to County Text30 Editable: No
FlowField
79 Contract Cost Decimal FlowField
81 Country/Region Code Code10 Editable: No
FlowField
82 Ship-to Country/Region Code Code10 Editable: No
FlowField
83 Name 2 Text50 Editable: No
FlowField
84 Ship-to Name 2 Text50 Editable: No
FlowField
85 Service Price Group Code Code10
86 Default Contract Cost Decimal BlankZero: Yes
87 Prepaid Amount Decimal Editable: No
FlowField
88 Search Description Code50
89 Service Contracts Boolean Editable: No
FlowField
90 Total Qty. Consumed Decimal (0:5) Editable: No
FlowField
100 Date Filter Date FlowFilter
101 Type Filter Option FlowFilter
102 Contract Filter Code20 FlowFilter
103 Service Order Filter Code20 FlowFilter
104 Sales/Serv. Shpt. Document No. Code20
105 Sales/Serv. Shpt. Line No. Integer
106 Shipment Type Option

Keys

# Fields
0 No. Clustered: Yes
1 Item No.,Serial No.
2 Customer No.,Ship-to Code,Item No.,Serial No.
3 Warranty Ending Date (Parts),Customer No.,Ship-to Code
4 Sales/Serv. Shpt. Document No.,Sales/Serv. Shpt. Line No.
5 Service Item Group Code

Table Relations To Other Tables

Field Related Table Related Field
Customer No. Customer No. 1..n
Item No. Item No. 1..n
Unit of Measure Code Item Unit of Measure Code 1..n
Variant Code Item Variant Code 1..n
No. Series No. Series Code 1..n
Preferred Resource Resource No. 1..n
Sales/Serv. Shpt. Line No. Sales Shipment Line Line No. 1..n
Contract Filter Service Contract Header Contract No. 1..n
Service Order Filter Service Header No. 1..n
Service Item Group Code Service Item Group Code 1..n
Service Price Group Code Service Price Group Code 1..n
Ship-to Code Ship-to Address Code 1..n
Unit of Measure Code Unit of Measure Code 1..n
Vendor No. Vendor No. 1..n

Table Relations From Other Tables

From Table From Field
Default Dimension No. 1..n
Filed Contract Line Service Item No. 1..n
Loaner Entry Service Item No. 1..n
Resource Skill No. 1..n
Sales Line Archive Service Item No. 1..n
Service Comment Line No. 1..n
Service Contract Line Service Item No. 1..n
Service Cr.Memo Line Service Item No. 1..n
Service Invoice Line Replaced Item No. 1..n
Service Item Component No. 1..n
Service Item Line Service Item No. 1..n
Service Item Log Service Item No. 1..n
Service Ledger Entry Service Item No. (Serviced) 1..n
Service Line Replaced Item No. 1..n
Service Line Price Adjmt. Service Item No. 1..n
Service Order Allocation Service Item No. 1..n
Service Shipment Item Line Service Item No. 1..n
Service Shipment Line Replaced Item No. 1..n
Troubleshooting Setup No. 1..n
Warranty Ledger Entry Service Item No. (Serviced) 1..n