Diagrams

Table

Service Item Group

DynamicsDocs.comService Item Group«Table 5904»Service Item GroupCode [PK,NN]DescriptionCreate Service ItemDefault Contract Discount %Default Serv. Price Group CodeDefault Response Time [Hours]«Table 1301»Item TemplateKey [PK]Code [NN]Template Name [NN]Base Unit of MeasureType; [Inventory,Service]Inventory Posting GroupItem Disc. GroupAllow Invoice Disc.Price/Profit Calculation; [Profit=Pric...Profit %Costing Method; [FIFO,LIFO,Specific,Av...Indirect Cost %Price Includes VATGen. Prod. Posting GroupAutomatic Ext. TextsTax Group CodeVAT Prod. Posting GroupItem Category CodeService Item GroupWarehouse Class 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 352»Default DimensionTable ID [PK,NN]No. [PK]Dimension Code [PK,NN]Dimension Value CodeValue Posting; [,Code Mandatory,Same C...Table CaptionMulti Selection Action; [,Change,Delet...«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 5908»Warranty Ledger EntryEntry No. [PK]Document No.Posting DateCustomer No.Ship-to CodeBill-to Customer No.Variant Code [Serviced]Service Item No. [Serviced]Item No. [Serviced]Serial No. [Serviced]Service Item Group [Serviced]Service Order No.Service Contract No.Fault Reason CodeFault Area CodeFault CodeSymptom CodeResolution CodeType; [,Item,Resource,Service Cost]No.QuantityWork Type CodeUnit of Measure CodeAmountDescriptionGen. Bus. Posting GroupGen. Prod. Posting GroupGlobal Dimension 1 CodeGlobal Dimension 2 CodeOpenVendor No....«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 5920»Fault/Resol. Cod. RelationshipFault Code [PK]Symptom Code [PK]Fault Area Code [PK]Resolution Code [PK]OccurrencesDescriptionService Item Group Code [PK]Created Manually«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 5945»Troubleshooting SetupType; [Service Item Group,Item,Service...No. [PK]Troubleshooting No. [PK,NN]Troubleshooting Description«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 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 5971»Filed Contract LineContract Type; [Quote,Contract]Contract No.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 5972»Contract/Service DiscountContract Type; [Quote,Contract,Templat...Contract No. [PK]Type; [Service Item Group,Resource Gro...No. [PK]Starting Date [PK]Discount %«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 5998»Standard Service Item Gr. CodeService Item Group Code [PK]Code [PK,NN]Description«Table 6080»Service Price GroupCode [PK,NN]Description<Default Serv. Price Group Code><Service Item Group><Service Item Group><No.><Service Item Group Code><Service Item Group (Serviced)><Service Item Group Code><Service Item Group Code><Service Item Group Code><No.><No.><Service Item Group Code><Service Item Group Code><No.><Service Item Group Code><Service Item Group Code><Alternative Item No.><No.><Item No.><Item No. (Serviced)><No.><Item No.><No.><No.><Item No.><Item No.><Item No.><No.><Service Item No.><Service Price Group Code><Contract Line No.><Service Item No. (Serviced)><Service Item No.><Service Price Group Code><No.><No.><Service Item No.><Service Item No.><Service Item No.><Service Price Group Code>

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

Fields

# Name Type
1 Code (Code) Code10 NotBlank: Yes
2 Description (Description) Text50
3 Create Service Item (Create Service Item) Boolean
4 Default Contract Discount % (Default Contract Discount %) Decimal (0:5) BlankZero: Yes
5 Default Serv. Price Group Code (Default Serv. Price Group Code) Code10
6 Default Response Time (Hours) (Default Response Time (Hours)) Decimal (0:5)

Keys

# Fields
0 Code (Code) Clustered: Yes
1 Description (Description)

Table Relations To Other Tables

Field Related Table Related Field
Default Serv. Price Group Code (Default Serv. Price Group Code) Service Price Group Code (Code) 1..n

Table Relations From Other Tables

From Table From Field
Contract/Service Discount No. (No.) 1..n
Default Dimension No. (No.) 1..n
Fault/Resol. Cod. Relationship Service Item Group Code (Service Item Group Code) 1..n
Filed Contract Line Service Item Group Code (Service Item Group Code) 1..n
Item Service Item Group (Service Item Group) 1..n
Item Template Service Item Group (Service Item Group) 1..n
Loaner Entry Service Item Group Code (Service Item Group Code) 1..n
Resource Skill No. (No.) 1..n
Service Contract Line Service Item Group Code (Service Item Group Code) 1..n
Service Item Service Item Group Code (Service Item Group Code) 1..n
Service Item Line Service Item Group Code (Service Item Group Code) 1..n
Service Shipment Item Line Service Item Group Code (Service Item Group Code) 1..n
Standard Service Item Gr. Code Service Item Group Code (Service Item Group Code) 1..n
Troubleshooting Setup No. (No.) 1..n
Warranty Ledger Entry Service Item Group (Serviced) (Service Item Group (Serviced)) 1..n