Diagrams


Table

Service Cost

DynamicsDocs.comService Cost«Table 5905»Service CostCode [PK,NN]DescriptionAccount No.Default Unit PriceDefault QuantityUnit of Measure CodeCost Type; [Travel,Support,Other]Service Zone CodeDefault Unit Cost«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 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 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 5911»Service Mgt. SetupPrimary Key [PK]Fault Reporting Level; [None,Fault,Fau...Link Service to Service ItemSalesperson MandatoryWarranty Disc. % [Parts]Warranty Disc. % [Labor]Contract Rsp. Time MandatoryService Order Starting FeeRegister Contract ChangesContract Inv. Line Text CodeContract Line Inv. Text CodeContract Inv. Period Text CodeContract Credit Line Text CodeSend First Warning ToSend Second Warning ToSend Third Warning ToFirst Warning Within [Hours]Second Warning Within [Hours]Third Warning Within [Hours]Next Service Calc. Method; [Planned,Ac...Service Order Type MandatoryService Zones Option; [Code Shown,Warn...Service Order Start MandatoryService Order Finish MandatoryResource Skills Option; [Code Shown,Wa...One Service Item Line/OrderUnit of Measure MandatoryFault Reason Code MandatoryContract Serv. Ord. Max. DaysLast Contract Service DateWork Type Code Mandatory...«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 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 5997»Standard Service LineStandard Service Code [PK]Line No. [PK]Type; [,Item,Resource,Cost,G/L Account...No.DescriptionQuantityAmount Excl. VATUnit of Measure CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeVariant CodeDimension Set ID«Table 6083»Serv. Price Adjustment DetailServ. Price Adjmt. Gr. Code [PK,NN]Type; [Item,Resource,Resource Group,Se...No. [PK]Work Type [PK]Gen. Prod. Posting Group [PK]Description«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«Table 15»G/L AccountNo. [PK,NN]NameSearch NameAccount Type; [Posting,Heading,Total,B...Global Dimension 1 CodeGlobal Dimension 2 CodeAccount Category; [,Assets,Liabilities...Income/Balance; [Income Statement,Bala...Debit/Credit; [Both,Debit,Credit]No. 2CommentBlockedDirect PostingReconciliation AccountNew PageNo. of Blank LinesIndentationLast Modified Date TimeLast Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudget at DateConsol. Translation Method; [Average R...Consol. Debit Acc....«Table 204»Unit of MeasureCode [PK,NN]DescriptionInternational Standard CodeSymbolLast Modified Date TimeId«Table 5957»Service ZoneCode [PK,NN]Description<Account No.><Unit of Measure Code><Service Zone Code><No.><No.><No.><Service Order Starting Fee><No.><No.><No.><No.><No.><No.><No.><No.><Attached to Line No.><Unit of Measure Code><No.><Unit of Measure Code><Unit of Measure Code><No.><Unit of Measure Code><No.><Attached to Line No.><Unit of Measure Code><No.><Attached to Line No.><Unit of Measure Code><No.><Unit of Measure Code><No.>

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

Fields

# Name Type
1 Code Code10 NotBlank: Yes
2 Description Text50
3 Account No. Code20
4 Default Unit Price Decimal
5 Default Quantity Decimal (0:5)
6 Unit of Measure Code Code10
7 Cost Type Option
8 Service Zone Code Code10
9 Default Unit Cost Decimal

Keys

# Fields
0 Code Clustered: Yes
1 Service Zone Code

Table Relations To Other Tables

Field Related Table Related Field
Account No. G/L Account No. 1..n
Service Zone Code Service Zone Code 1..n
Unit of Measure Code Unit of Measure Code 1..n

Table Relations From Other Tables

From Table From Field
Contract/Service Discount No. 1..n
Serv. Price Adjustment Detail No. 1..n
Service Cr.Memo Line No. 1..n
Service Invoice Line No. 1..n
Service Ledger Entry No. 1..n
Service Line No. 1..n
Service Line Price Adjmt. No. 1..n
Service Mgt. Setup Service Order Starting Fee 1..n
Service Shipment Line No. 1..n
Standard Service Line No. 1..n
Warranty Ledger Entry No. 1..n