Diagrams

Table

Service Price Group

DynamicsDocs.comService Price Group«Table 6080»Service Price GroupCode [PK,NN]Description«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 5904»Service Item GroupCode [PK,NN]DescriptionCreate Service ItemDefault Contract Discount %Default Serv. Price Group CodeDefault Response Time [Hours]«Table 5907»Service Ledger EntryEntry No. [PK]Service Contract No.Document Type; [,Payment,Invoice,Credi...Document No.Serv. Contract Acc. Gr. CodeDocument Line No.Moved from Prepaid Acc.Posting DateAmount [LCY]Customer No.Ship-to CodeItem No. [Serviced]Serial No. [Serviced]User IDContract Invoice PeriodGlobal Dimension 1 CodeGlobal Dimension 2 CodeService Item No. [Serviced]Variant Code [Serviced]Contract Group CodeType; [,Resource,Item,Service Cost,Ser...No.Cost AmountDiscount AmountUnit CostQuantityCharged Qty.Unit PriceDiscount %Contract Disc. AmountBill-to Customer No....«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 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 5991»Service Shipment LineCustomer No.Document No. [PK]Line No. [PK]Type; [,Item,Resource,Cost,G/L Account...No.Location CodePosting GroupDescriptionDescription 2Unit of MeasureQuantityUnit PriceUnit Cost [LCY]VAT %Line Discount %Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryItem Shpt. Entry No.Shortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price GroupWork Type CodeQty. Shipped Not InvoicedQuantity InvoicedOrder No.Order Line No.Bill-to Customer No....«Table 5993»Service Invoice LineCustomer No.Document No. [PK]Line No. [PK]Type; [,Item,Resource,Cost,G/L Account...No.Location CodePosting GroupDescriptionDescription 2Unit of MeasureQuantityUnit 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 GroupWork Type CodeShipment No.Shipment Line No.Bill-to Customer No....«Table 5995»Service Cr.Memo LineCustomer No.Document No. [PK]Line No. [PK]Type; [,Item,Resource,Cost,G/L Account...No.Location CodePosting GroupDescriptionDescription 2Unit of MeasureQuantityUnit PriceUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price GroupWork Type CodeShipment No.Bill-to Customer No.Inv. Discount AmountGen. Bus. Posting Group...«Table 6081»Serv. Price Group SetupService Price Group Code [PK,NN]Fault Area Code [PK]Cust. Price Group Code [PK]Currency Code [PK]Starting Date [PK]Serv. Price Adjmt. Gr. CodeInclude DiscountsAdjustment Type; [Fixed,Maximum,Minimu...AmountInclude VAT«Table 6084»Service Line Price Adjmt.Document Type; [Quote,Order] [PK]Document No. [PK]Service Line No. [PK]Service Item Line No. [PK]Service Item No.Serv. Price Adjmt. Gr. CodeType; [,Item,Resource,Cost,G/L Account...No.DescriptionQuantityAmountNew AmountUnit PriceNew Unit PriceUnit CostDiscount %Discount AmountAmount incl. VATNew Amount incl. VATWeightAdjustment Type; [Fixed,Maximum,Minimu...Service Price Group CodeManually AdjustedVat %New Amount Excl. VAT<Service Price Group Code><Service Price Group Code><Default Serv. Price Group Code><Service Price Group Code><Service Price Group Code><Service Price Group Code><Service Price Group Code><Service Price Group Code><Service Price Group Code><Service Price Group Code><Service Price Group Code><Service Item No.><Service Item Group Code><Service Item Line No.><Attached to Line No.><Service Item No.><Replaced Item No.><Service Item Group Code><Service Item Group Code><Service Item No. (Serviced)><Service Item No.><Service Item No.><Replaced Item No.><Service Item No.><Replaced Item No.><Service Item No.><Service Item No.><Attached to Line No.><Attached to Line No.>

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

Keys

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

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field
Serv. Price Group Setup Service Price Group Code (Service Price Group Code) 1..n
Service Cr.Memo Line Service Price Group Code (Service Price Group Code) 1..n
Service Invoice Line Service Price Group Code (Service Price Group Code) 1..n
Service Item Service Price Group Code (Service Price Group Code) 1..n
Service Item Group Default Serv. Price Group Code (Default Serv. Price Group Code) 1..n
Service Item Line Service Price Group Code (Service Price Group Code) 1..n
Service Ledger Entry Service Price Group Code (Service Price Group Code) 1..n
Service Line Service Price Group Code (Service Price Group Code) 1..n
Service Line Price Adjmt. Service Price Group Code (Service Price Group Code) 1..n
Service Shipment Item Line Service Price Group Code (Service Price Group Code) 1..n
Service Shipment Line Service Price Group Code (Service Price Group Code) 1..n