Diagrams

Table

Service Contract Line

DynamicsDocs.comService Contract Line«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 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 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 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 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 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 5404»Item Unit of MeasureItem No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureLengthWidthHeightCubageWeight«Table 204»Unit of MeasureCode [PK,NN]DescriptionInternational Standard Code«Table 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2<Contract No.><Service Item No.><Service Item Group Code><Customer No.><Ship-to Code><Item No.><Unit of Measure Code><Unit of Measure Code><Variant Code><Contract Line No.><Service Item No.><Service Item Group Code><Item No.><Contract No.><Variant Code><Ship-to Code><Customer No.><Customer No.><Bill-to Customer No.><Ship-to Code><Item Filter><Contract Filter><Service Item Group Code><Customer No.><Ship-to Code><Item No.><Unit of Measure Code><Unit of Measure Code><Variant Code><Service Item Group><Bill-to Customer No.><Ship-to Filter><Customer No.><Alternative Item No.><Variant Filter><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Code>

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

Fields

# Name Type
1 Contract Type (Contract Type) Option
2 Contract No. (Contract No.) Code20
3 Line No. (Line No.) Integer
4 Contract Status (Contract Status) Option
5 Service Item No. (Service Item No.) Code20
6 Description (Description) Text50
7 Serial No. (Serial No.) Code20
8 Service Item Group Code (Service Item Group Code) Code10
9 Customer No. (Customer No.) Code20
10 Ship-to Code (Ship-to Code) Code10 Editable: No
11 Item No. (Item No.) Code20
12 Unit of Measure Code (Unit of Measure Code) Code10
13 Response Time (Hours) (Response Time (Hours)) Decimal (0:5) BlankZero: Yes
14 Last Planned Service Date (Last Planned Service Date) Date Editable: No
15 Next Planned Service Date (Next Planned Service Date) Date
16 Last Service Date (Last Service Date) Date
17 Last Preventive Maint. Date (Last Preventive Maint. Date) Date Editable: No
18 Invoiced to Date (Invoiced to Date) Date Editable: No
19 Credit Memo Date (Credit Memo Date) Date
20 Contract Expiration Date (Contract Expiration Date) Date
21 Service Period (Service Period) DateFormula
22 Line Value (Line Value) Decimal BlankZero: Yes
23 Line Discount % (Line Discount %) Decimal (0:5) BlankZero: Yes
24 Line Amount (Line Amount) Decimal BlankZero: Yes
28 Variant Code (Variant Code) Code10
29 Starting Date (Starting Date) Date Editable: No
30 New Line (New Line) Boolean Editable: No
31 Credited (Credited) Boolean
32 Line Cost (Line Cost) Decimal BlankZero: Yes
33 Line Discount Amount (Line Discount Amount) Decimal BlankZero: Yes
34 Profit (Profit) Decimal BlankZero: Yes

Keys

# Fields
0 Contract Type,Contract No.,Line No. (Contract Type,Contract No.,Line No.) Clustered: Yes
MaintainSIFTIndex: No
1 Contract No.,Line No.,Contract Type (Contract No.,Line No.,Contract Type)
2 Service Item No.,Contract Status (Service Item No.,Contract Status)
3 Contract Type,Contract No.,Credited,New Line (Contract Type,Contract No.,Credited,New Line) MaintainSQLIndex: No
MaintainSIFTIndex: No
4 Customer No.,Ship-to Code (Customer No.,Ship-to Code)

Table Relations To Other Tables

Field Related Table Related Field
Customer No. (Customer No.) Customer No. (No.) 1..n
Item No. (Item No.) Item () 1..n
Unit of Measure Code (Unit of Measure Code) Item Unit of Measure Code (Code) 1..n
Variant Code (Variant Code) Item Variant Code (Code) 1..n
Contract No. (Contract No.) Service Contract Header Contract No. (Contract No.) 1..n
Service Item No. (Service Item No.) Service Item No. (No.) 1..n
Service Item Group Code (Service Item Group Code) Service Item Group Code (Code) 1..n
Ship-to Code (Ship-to Code) Ship-to Address Code (Code) 1..n
Unit of Measure Code (Unit of Measure Code) Unit of Measure Code (Code) 1..n

Table Relations From Other Tables

From Table From Field
Service Item Line Contract Line No. (Contract Line No.) 1..n