Diagrams


Table

Service Contract Header

DynamicsDocs.comService Contract Header«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 5108»Sales Line ArchiveDocument Type; [Quote,Order,Invoice,Cr...Sell-to Customer No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,Resource,Fixe...No.Location CodePosting GroupQuantity Disc. CodeShipment DateDescriptionDescription 2Unit of MeasureQuantityOutstanding QuantityQty. to InvoiceQty. to ShipUnit PriceUnit Cost [LCY]VAT %Quantity Disc. %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item Entry...«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 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 5906»Service Comment LineType; [General,Fault,Resolution,Access...No. [PK,NN]Table Line No. [PK]Line No. [PK]CommentDateTable Subtype; [0,1,2,3] [PK]Table Name; [Service Contract,Service...«Table 5910»Service HourService Contract No. [PK]Starting Date [PK]Day; [Monday,Tuesday,Wednesday,Thursda...Starting TimeEnding TimeValid on HolidaysService Contract Type; [,Quote,Contrac...«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 5942»Service Item LogService Item No. [PK,NN]Entry No. [PK]Event No.Document No.AfterBeforeChange DateChange TimeUser IDDocument Type; [,Quote,Order,Contract]«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 5967»Contract Change LogContract Type; [Quote,Contract]Contract No. [PK]Change No. [PK]User IDDate of ChangeTime of ChangeContract Part; [Header,Line,Discount]Field DescriptionOld ValueNew ValueType of Change; [Modify,Insert,Delete,...Service Item No.Serv. Contract Line No.«Table 5970»Filed Service Contract HeaderContract No.Contract Type; [Quote,Contract]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 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 5990»Service Shipment HeaderCustomer No. [NN]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 DateLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting GroupCurrency CodeCurrency FactorCustomer Price Group...«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 5992»Service Invoice HeaderCustomer No. [NN]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 DateLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting GroupCurrency CodeCurrency FactorCustomer Price Group...«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 5994»Service Cr.Memo HeaderCustomer No. [NN]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 ContactPosting DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting GroupCurrency CodeCurrency FactorCustomer Price GroupPrices Including VAT...«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 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 5973»Service Contract Account GroupCode [PK]DescriptionNon-Prepaid Contract Acc.Prepaid Contract Acc.«Table 5957»Service ZoneCode [PK,NN]Description«Table 231»Reason CodeCode [PK,NN]DescriptionDate FilterContract Gain/Loss Amount«Table 3»Payment TermsCode [PK,NN]Due Date CalculationDiscount Date CalculationDiscount %DescriptionCalc. Pmt. Disc. on Cr. Memos«Table 5966»Contract GroupCode [PK,NN]DescriptionDisc. on Contr. Orders OnlyDate FilterContract Gain/Loss Amount«Table 5903»Service Order TypeCode [PK,NN]Description«Table 7»Standard TextCode [PK,NN]Description«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 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 5050»ContactNo. [PK]NameSearch NameName 2AddressAddress 2CityPhone No.Telex No.Territory CodeCurrency CodeLanguage CodeSalesperson CodeCountry/Region CodeCommentLast Date ModifiedFax No.Telex Answer BackVAT Registration No.PicturePost CodeCountyE-MailHome PageNo. SeriesImageType; [Company,Person]Company No.Company NameLookup Contact No.First Name...<Customer No.><Bill-to Customer No.><Ship-to Code><Serv. Contract Acc. Gr. Code><Service Zone Code><Cancel Reason Code><Reason Code Filter><Payment Terms Code><Contract Group Code><Service Order Type><Price Inv. Increase Code><Responsibility Center><Posted Service Order Filter><Contract No.><Contract Filter><Item Filter><Contact No.><Bill-to Contact No.><Service Contract No.><Contract No.><Contract Filter><Contract No.><Contract No.><No.><Service Contract No.><Contract Filter><Document No.><Contract No.><Contract No.><Contract No. Relation><Contract No.><Contract No.><Contract No.><Contract No.><Contract Filter><Contract No.><Contract No.><Contract Filter><Contract No.><Sell-to Customer No.><Bill-to Customer No.><No.><No.><Originally Ordered No.><BOM Item No.><Attached to Line No.><Responsibility Center><Service Item No.><Customer No.><Bill-to Customer No.><Customer Filter><Ship-to Code><Payment Terms Code><Last Shipping No.><Last Posting No.><Reason Code><Contact No.><Bill-to Contact No.><Responsibility Center><Service Order Type><Service Zone Filter><Service Zone Code><Document No.><Service Order Filter><Document No.><No.><Service Order Filter><Document No.><Service Item No.><Item No.><Contract Line No.><Ship-to Code><Customer No.><Responsibility Center><Service Item Line No.><Customer No.><Bill-to Customer No.><No.><No.><Replaced Item No.><Attached to Line No.><Responsibility Center><Service Item No.><Replaced Item No.><Ship-to Code><No.><Customer No.><Ship-to Code><Item No.><Service Item No.><Service Item No.><Service Item No.><Service Item No.><Replaced Item No.><Service Item No.><Replaced Item No.><Service Item No.><Customer No.><Ship-to Code><Item No.><Customer No.><Bill-to Customer No.><Ship-to Code><Serv. Contract Acc. Gr. Code><Service Zone Code><Cancel Reason Code><Payment Terms Code><Contract Group Code><Service Order Type><Price Inv. Increase Code><Responsibility Center><No.><Item No.><Ship-to Code><Customer No.><Responsibility Center><Customer No.><Bill-to Customer No.><Customer Filter><Ship-to Code><Payment Terms Code><Reason Code><Contact No.><Bill-to Contact No.><Responsibility Center><Service Order Type><Service Zone Filter><Service Zone Code><Document No.><Customer No.><Bill-to Customer No.><No.><No.><Replaced Item No.><Responsibility Center><Ship-to Code><Customer No.><Bill-to Customer No.><Customer Filter><Ship-to Code><Payment Terms Code><Reason Code><Contact No.><Bill-to Contact No.><Responsibility Center><Service Order Type><Service Zone Filter><Service Zone Code><Customer No.><Bill-to Customer No.><No.><No.><Replaced Item No.><Attached to Line No.><Responsibility Center><Ship-to Code><Customer No.><Bill-to Customer No.><Customer Filter><Ship-to Code><Payment Terms Code><Reason Code><Contact No.><Bill-to Contact No.><Responsibility Center><Service Order Type><Service Zone Filter><Service Zone Code><Document No.><Customer No.><Bill-to Customer No.><No.><No.><Replaced Item No.><Attached to Line No.><Responsibility Center><Ship-to Code><Payment Terms Code><Cash Flow Payment Terms Code><Bill-to Customer No.><Primary Contact No.><Responsibility Center><Service Zone Code><Ship-to Filter><Customer No.><Service Zone Code><Alternative Item No.><Company No.><Lookup Contact No.>

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

Fields

# Name Type
1 Contract No. Code20
2 Contract Type Option
3 Description Text50
4 Description 2 Text50
5 Status Option Editable: Yes
6 Change Status Option Editable: No
7 Customer No. Code20 NotBlank: Yes
8 Name Text50 Editable: No
FlowField
9 Address Text50 Editable: No
FlowField
10 Address 2 Text50 Editable: No
FlowField
11 Post Code Code20 Editable: No
FlowField
12 City Text30 Editable: No
FlowField
13 Contact Name Text50
14 Your Reference Text35
15 Salesperson Code Code10
16 Bill-to Customer No. Code20
17 Bill-to Name Text50 Editable: No
FlowField
18 Bill-to Address Text50 Editable: No
FlowField
19 Bill-to Address 2 Text50 Editable: No
FlowField
20 Bill-to Post Code Code20 Editable: No
FlowField
21 Bill-to City Text30 Editable: No
FlowField
22 Ship-to Code Code10
23 Ship-to Name Text50 Editable: No
FlowField
24 Ship-to Address Text50 Editable: No
FlowField
25 Ship-to Address 2 Text50 Editable: No
FlowField
26 Ship-to Post Code Code20 Editable: No
FlowField
27 Ship-to City Text30 Editable: No
FlowField
28 Serv. Contract Acc. Gr. Code Code10
32 Invoice Period Option
33 Last Invoice Date Date Editable: No
34 Next Invoice Date Date Editable: No
35 Starting Date Date
36 Expiration Date Date
38 First Service Date Date
39 Max. Labor Unit Price Decimal BlankZero: Yes
40 Calcd. Annual Amount Decimal Editable: No
FlowField
42 Annual Amount Decimal BlankZero: Yes
43 Amount per Period Decimal BlankZero: Yes
Editable: No
44 Combine Invoices Boolean
45 Prepaid Boolean
46 Next Invoice Period Text30 Editable: No
47 Service Zone Code Code10
48 Language Code Code10
50 Cancel Reason Code Code10
51 Last Price Update Date Date Editable: No
52 Next Price Update Date Date
53 Last Price Update % Decimal (0:5) Editable: No
55 Response Time (Hours) Decimal (0:5) BlankZero: Yes
56 Contract Lines on Invoice Boolean
57 No. of Posted Invoices Integer Editable: No
FlowField
58 No. of Unposted Invoices Integer Editable: No
FlowField
59 Service Period DateFormula
60 Payment Terms Code Code10
62 Invoice after Service Boolean
63 Quote Type Option
64 Allow Unbalanced Amounts Boolean
65 Contract Group Code Code10
66 Service Order Type Code10
67 Shortcut Dimension 1 Code Code20
68 Shortcut Dimension 2 Code Code20
69 Accept Before Date
71 Automatic Credit Memos Boolean
74 Template No. Code20
75 Price Update Period DateFormula
79 Price Inv. Increase Code Code20
80 Print Increase Text Boolean
81 Currency Code Code10
82 No. Series Code10 Editable: No
83 Probability Decimal (0:5)
84 Comment Boolean Editable: No
FlowField
85 Responsibility Center Code10
86 Phone No. Text30 [Phone No.]
87 Fax No. Text30
88 E-Mail Text80 [E-Mail]
89 Bill-to County Text30 Editable: No
FlowField
90 County Text30 Editable: No
FlowField
91 Ship-to County Text30 Editable: No
FlowField
92 Country/Region Code Code10 Editable: No
FlowField
93 Bill-to Country/Region Code Code10 Editable: No
FlowField
94 Ship-to Country/Region Code Code10 Editable: No
FlowField
95 Name 2 Text50 Editable: No
FlowField
96 Bill-to Name 2 Text50 Editable: No
FlowField
97 Ship-to Name 2 Text50 Editable: No
FlowField
98 Next Invoice Period Start Date Editable: No
99 Next Invoice Period End Date Editable: No
100 Contract Invoice Amount Decimal Editable: No
FlowField
101 Contract Prepaid Amount Decimal Editable: No
FlowField
102 Contract Discount Amount Decimal Editable: No
FlowField
103 Contract Cost Amount Decimal Editable: No
FlowField
104 Contract Gain/Loss Amount Decimal Editable: No
FlowField
106 No. of Posted Credit Memos Integer Editable: No
FlowField
107 No. of Unposted Credit Memos Integer Editable: No
FlowField
140 Type Filter Option FlowFilter
141 Reason Code Filter Code10 FlowFilter
142 Posted Service Order Filter Code20 FlowFilter
143 Date Filter Date FlowFilter
144 Item Filter Code20 FlowFilter
480 Dimension Set ID Integer Editable: No
5050 Contact No. Code20
5051 Bill-to Contact No. Code20
5052 Bill-to Contact Text50
5053 Last Invoice Period End Date

Keys

# Fields
0 Contract Type,Contract No. Clustered: Yes
1 Contract No.,Contract Type
2 Customer No.,Ship-to Code
3 Bill-to Customer No.,Contract Type,Combine Invoices,Next Invoice Date
4 Next Price Update Date
5 Responsibility Center,Service Zone Code,Status,Contract Group Code
6 Salesperson Code,Status
7 Template No.
8 Customer No.,Bill-to Customer No. MaintainSQLIndex: No
9 Customer No.,Currency Code,Ship-to Code MaintainSQLIndex: No

Table Relations To Other Tables

Field Related Table Related Field
Bill-to Contact No. Contact No. 1..n
Contract Group Code Contract Group Code 1..n
Currency Code Currency Code 1..n
Bill-to Customer No. Customer No. 1..n
Dimension Set ID Dimension Set Entry 1..n
Shortcut Dimension 2 Code Dimension Value Code 1..n
Item Filter Item No. 1..n
Language Code Language Code 1..n
No. Series No. Series Code 1..n
Payment Terms Code Payment Terms Code 1..n
Reason Code Filter Reason Code Code 1..n
Responsibility Center Responsibility Center Code 1..n
Salesperson Code Salesperson/Purchaser Code 1..n
Serv. Contract Acc. Gr. Code Service Contract Account Group Code 1..n
Service Order Type Service Order Type Code 1..n
Posted Service Order Filter Service Shipment Header No. 1..n
Service Zone Code Service Zone Code 1..n
Ship-to Code Ship-to Address Code 1..n
Price Inv. Increase Code Standard Text Code 1..n

Table Relations From Other Tables

From Table From Field
Contract Change Log Contract No. 1..n
Contract Gain/Loss Entry Contract No. 1..n
Contract/Service Discount Contract No. 1..n
Filed Service Contract Header Contract No. Relation 1..n
Sales Line Archive Service Contract No. 1..n
Service Comment Line No. 1..n
Service Contract Line Contract No. 1..n
Service Cr.Memo Header Contract Filter 1..n
Service Cr.Memo Line Contract No. 1..n
Service Header Contract Filter 1..n
Service Hour Service Contract No. 1..n
Service Invoice Header Contract Filter 1..n
Service Invoice Line Contract No. 1..n
Service Item Contract Filter 1..n
Service Item Line Contract No. 1..n
Service Item Log Document No. 1..n
Service Ledger Entry No. 1..n
Service Line Contract No. 1..n
Service Shipment Header Contract Filter 1..n
Service Shipment Item Line Contract No. 1..n
Service Shipment Line Contract No. 1..n
Warranty Ledger Entry Service Contract No. 1..n