Diagrams


Table

Service Item Line

DynamicsDocs.comService Item Line«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 5902»Service LineDocument Type; [Quote,Order,Invoice,Cr...Customer No.Document No. [PK]Line No. [PK]Type; [,Item,Resource,Cost,G/L Account...No.Location CodePosting GroupDescriptionDescription 2Unit of MeasureQuantityOutstanding QuantityQty. to InvoiceQty. to ShipUnit PriceUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price Group...«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 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 5904»Service Item GroupCode [PK,NN]DescriptionCreate Service ItemDefault Contract Discount %Default Serv. Price Group CodeDefault Response Time [Hours]«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 5927»Repair StatusCode [PK,NN]DescriptionService Order Status; [Pending,In Proc...Priority; [High,Medium High,Medium Low...InitialPartly ServicedIn ProcessFinishedReferredSpare Part OrderedSpare Part ReceivedWaiting for CustomerQuote FinishedPosting AllowedPending Status AllowedIn Process Status AllowedFinished Status AllowedOn Hold Status Allowed«Table 5929»Service ShelfNo. [PK,NN]Description«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 5913»LoanerNo. [PK]DescriptionDescription 2Unit of Measure CodeItem No.Last Date ModifiedCommentBlockedNo. SeriesDocument No.LentSerial No.Document Type; [,Quote,Order]«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 5917»Fault Reason CodeCode [PK,NN]DescriptionExclude Warranty DiscountExclude Contract Discount«Table 6080»Service Price GroupCode [PK,NN]Description«Table 5915»Fault AreaCode [PK,NN]Description«Table 5916»Symptom CodeCode [PK,NN]Description«Table 5918»Fault CodeFault Area Code [PK]Symptom Code [PK]Code [PK,NN]Description«Table 5919»Resolution CodeCode [PK,NN]Description«Table 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2«Table 6082»Service Price Adjustment GroupCode [PK,NN]Description«Table 5964»Service Contract LineContract Type; [Quote,Contract] [PK]Contract No. [PK]Line No. [PK]Contract Status; [,Signed,Cancelled]Service Item No.DescriptionSerial No.Service Item Group CodeCustomer No.Ship-to CodeItem No.Unit of Measure CodeResponse Time [Hours]Last Planned Service DateNext Planned Service DateLast Service DateLast Preventive Maint. DateInvoiced to DateCredit Memo DateContract Expiration DateService PeriodLine ValueLine Discount %Line AmountVariant CodeStarting DateNew LineCreditedLine CostLine Discount AmountProfit...«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 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 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 5714»Responsibility CenterCode [PK,NN]NameAddressAddress 2CityPost CodeCountry/Region CodePhone No.Fax No.Name 2ContactGlobal Dimension 1 CodeGlobal Dimension 2 CodeLocation CodeCountyE-MailHome PageDate FilterContract Gain/Loss Amount«Table 152»Resource GroupNo. [PK,NN]NameDate FilterCapacityQty. on Order [Job]Qty. Quoted [Job]Unit of Measure FilterUsage [Qty.]Usage [Cost]Usage [Price]Sales [Qty.]Sales [Cost]Sales [Price]Chargeable FilterGlobal Dimension 1 CodeGlobal Dimension 2 CodeNo. of Resources AssignedQty. on Service Order«Table 349»Dimension ValueDimension Code [PK,NN]Code [PK,NN]NameDimension Value Type; [Standard,Headin...TotalingBlockedConsolidation CodeIndentationGlobal Dimension No.Map-to IC Dimension CodeMap-to IC Dimension Value CodeDimension Value IDIdLast Modified Date Time«Table 480»Dimension Set EntryDimension Set ID [PK]Dimension Code [PK,NN]Dimension Value Code [NN]Dimension Value IDDimension NameDimension Value Name<Document No.><Service Order Filter><Service Item No.><Service Item Group Code><Item No.><Repair Status Code><Repair Status Code Filter><Service Shelf No.><Contract No.><Loaner No.><Vendor No.><Fault Reason Code><Service Price Group Code><Fault Area Code><Symptom Code><Fault Code><Resolution Code><Variant Code><Serv. Price Adjmt. Gr. Code><Contract Line No.><Ship-to Code><Customer No.><Resource Filter><Responsibility Center><Resource Group Filter><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Dimension Set ID><Service Item Line No.><Service Item Line No.><Customer No.><Bill-to Customer No.><Document No.><No.><Replaced Item No.><No.><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Attached to Line No.><Dimension Set ID><Variant Code><Responsibility Center><Service Item No.><Replaced Item No.><Serv. Price Adjmt. Gr. Code><Ship-to Code><Service Price Group Code><Fault Area Code><Symptom Code><Fault Code><Resolution Code><Contract No.><Fault Reason Code><Resource No.><Resource Group No.><Service Item No.><Customer No.><Bill-to Customer No.><Customer Filter><Ship-to Code><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Dimension Set ID><Responsibility Center><Contract No.><Contract Filter><Resource Filter><Resource Group Filter><Service Order Filter><Service Item Group Code><Customer No.><Ship-to Code><Item No.><Vendor No.><Preferred Resource><Variant Code><Service Price Group Code><Contract Filter><Service Item No.><Default Serv. Price Group Code><Service Item Group><Service Item Group Code><Vendor No.><Alternative Item No.><Global Dimension 1 Filter><Global Dimension 2 Filter><Global Dimension 1 Code><Global Dimension 2 Code><Variant Filter><Item No.><Item No.><Item No.><Item Filter><Customer No.><Bill-to Customer No.><Ship-to Code><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Responsibility Center><Dimension Set ID><Contract No.><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Pay-to Vendor No.><Responsibility Center><Vendor No.><Fault Area Code><Symptom Code><Variant Code><Customer No.><Ship-to Code><Customer No.><Ship-to Filter><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Bill-to Customer No.><Responsibility Center><Resource Group No.><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Code><Global Dimension 2 Code><Dimension Value Code>

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

Fields

# Name Type
1 Document No. Code20 Editable: No
2 Line No. Integer
3 Service Item No. Code20
4 Service Item Group Code Code10
5 Item No. Code20
6 Serial No. Code20
7 Description Text50
8 Description 2 Text50
9 Repair Status Code Code10
10 Priority Option
11 Response Time (Hours) Decimal (0:5)
12 Response Date Date
13 Response Time Time
14 Starting Date Date
15 Starting Time Time
16 Finishing Date Date
17 Finishing Time Time
18 Service Shelf No. Code10
19 Warranty Starting Date (Parts) Date
20 Warranty Ending Date (Parts) Date
21 Warranty Boolean
22 Warranty % (Parts) Decimal (0:5)
23 Warranty % (Labor) Decimal (0:5)
24 Warranty Starting Date (Labor) Date
25 Warranty Ending Date (Labor) Date
26 Contract No. Code20
27 Location of Service Item Text30 Editable: No
FlowField
28 Loaner No. Code20
29 Vendor No. Code20
30 Vendor Item No. Text20
31 Fault Reason Code Code10
32 Service Price Group Code Code10
33 Fault Area Code Code10
34 Symptom Code Code10
35 Fault Code Code10
36 Resolution Code Code10
37 Fault Comment Boolean Editable: No
FlowField
38 Resolution Comment Boolean Editable: No
FlowField
40 Variant Code Code10
41 Service Item Loaner Comment Boolean Editable: No
FlowField
42 Actual Response Time (Hours) Decimal (0:5)
43 Document Type Option Editable: No
44 Serv. Price Adjmt. Gr. Code Code10 Editable: No
45 Adjustment Type Option Editable: No
46 Base Amount to Adjust Decimal Editable: No
60 No. of Active/Finished Allocs Integer Editable: No
FlowField
61 No. of Allocations Integer Editable: No
FlowField
62 No. of Previous Services Integer Editable: No
FlowField
63 Contract Line No. Integer
64 Ship-to Code Code10 Editable: No
65 Customer No. Code20 Editable: No
91 Date Filter Date FlowFilter
92 Resource Filter Code20 FlowFilter
93 Allocation Date Filter Date FlowFilter
94 Repair Status Code Filter Code10 FlowFilter
96 Allocation Status Filter Option FlowFilter
97 Responsibility Center Code10 Editable: No
98 Service Order Filter Code20 FlowFilter
99 Resource Group Filter Code20 FlowFilter
100 Shortcut Dimension 1 Code Code20
101 Shortcut Dimension 2 Code Code20
130 Release Status Option
480 Dimension Set ID Integer Editable: No

Keys

# Fields
0 Document Type,Document No.,Line No. Clustered: Yes
1 Document No.,Line No.,Document Type
2 Document Type,Document No.,Service Item No.,Contract No.,Contract Line No. MaintainSQLIndex: No
3 Service Item No.
4 Document Type,Document No.,Response Date,Response Time
5 Response Date,Response Time,Priority
6 Loaner No.
7 Document Type,Document No.,Starting Date,Starting Time MaintainSQLIndex: No
8 Document Type,Document No.,Finishing Date,Finishing Time MaintainSQLIndex: No
9 Fault Reason Code
10 Contract No.

Table Relations To Other Tables

Field Related Table Related Field
Customer No. Customer No. 1..n
Dimension Set ID Dimension Set Entry 1..n
Shortcut Dimension 2 Code Dimension Value Code 1..n
Fault Area Code Fault Area Code 1..n
Fault Code Fault Code Code 1..n
Fault Reason Code Fault Reason Code Code 1..n
Item No. Item No. 1..n
Variant Code Item Variant Code 1..n
Loaner No. Loaner No. 1..n
Repair Status Code Filter Repair Status Code 1..n
Resolution Code Resolution Code Code 1..n
Resource Filter Resource No. 1..n
Resource Group Filter Resource Group No. 1..n
Responsibility Center Responsibility Center Code 1..n
Contract No. Service Contract Header Contract No. 1..n
Contract Line No. Service Contract Line Line No. 1..n
Service Order Filter Service Header No. 1..n
Service Item No. Service Item No. 1..n
Service Item Group Code Service Item Group Code 1..n
Serv. Price Adjmt. Gr. Code Service Price Adjustment Group Code 1..n
Service Price Group Code Service Price Group Code 1..n
Service Shelf No. Service Shelf No. 1..n
Ship-to Code Ship-to Address Code 1..n
Symptom Code Symptom Code Code 1..n
Vendor No. Vendor No. 1..n

Table Relations From Other Tables

From Table From Field
Service Line Service Item Line No. 1..n
Service Order Allocation Service Item Line No. 1..n