Service Contract Line

Dynamics 365 BC Table ReferenceTablesCompany TablesSService Contract Line

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/5964

Table Type: Company

Table Name: Service Contract Line
Database Table Name: CRONUS UK Ltd_$Service Contract Line$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5964

Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how Service Contract Line can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Service Contract Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Contract Type]
   ,[Contract No_]
   ,[Line No_]
   ,[Contract Status]
   ,[Service Item No_]
   ,[Description]
   ,[Serial No_]
   ,[Service Item Group Code]
   ,[Customer No_]
   ,[Ship-to Code]
   ,[Item No_]
   ,[Unit of Measure Code]
   ,[Response Time (Hours)]
   ,[Last Planned Service Date]
   ,[Next Planned Service Date]
   ,[Last Service Date]
   ,[Last Preventive Maint_ Date]
   ,[Invoiced to Date]
   ,[Credit Memo Date]
   ,[Contract Expiration Date]
   ,[Service Period]
   ,[Line Value]
   ,[Line Discount _]
   ,[Line Amount]
   ,[Variant Code]
   ,[Starting Date]
   ,[New Line]
   ,[Credited]
   ,[Line Cost]
   ,[Line Discount Amount]
   ,[Profit]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Service Contract Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Service Contract Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Line]
LEFT JOIN
   [CRONUS UK Ltd_$Service Item Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item Group]
      ON
         [Service Contract Line].[Service Item Group Code] = [Service Item Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address]
      ON
         [Service Contract Line].[Ship-to Code] = [Ship-to Address].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Service Contract Line].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Service Contract Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Service Contract Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Service Contract Line table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Contract Type SearchContract TypeNormalOption4Contract Typeint
Available options are:
  • “Quote”
  • “Contract”
  • “Template”
2Contract No. Primary Key SearchContract No.NormalCode20Contract No_nvarchar(40)
3Line No. Primary Key SearchLine No.NormalInteger4Line No_int
4Contract Status Primary Key SearchContract StatusNormalOption4Contract Statusint
Available options are:
  • ” “
  • “Signed”
  • “Cancelled”
5Service Item No. SearchService Item No.NormalCode20Service Item No_nvarchar(40)
Key to join to the Service Item table.

Show/hide example query

SELECT
	       [Service Contract Line].[Service Item No_]
	       ,[Service Item].[No_]
	FROM
	       [CRONUS UK Ltd_$Service Contract Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Service Item$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item]
	              ON
	                     [Service Contract Line].[Service Item No_] = [Service Item].[No_]
6Description SearchDescriptionNormalText100Descriptionnvarchar(200)
7Serial No. SearchSerial No.NormalCode50Serial No_nvarchar(100)
8Service Item Group Code SearchService Item Group CodeNormalCode10Service Item Group Codenvarchar(20)
Key to join to the Service Item Group table.

Show/hide example query

SELECT
	       [Service Contract Line].[Service Item Group Code]
	       ,[Service Item Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Service Contract Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Service Item Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item Group]
	              ON
	                     [Service Contract Line].[Service Item Group Code] = [Service Item Group].[Code]
9Customer No. SearchCustomer No.NormalCode20Customer No_nvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
	       [Service Contract Line].[Customer No_]
	       ,[Customer].[No_]
	FROM
	       [CRONUS UK Ltd_$Service Contract Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
	              ON
	                     [Service Contract Line].[Customer No_] = [Customer].[No_]
10Ship-to Code SearchShip-to CodeNormalCode10Ship-to Codenvarchar(20)
Key to join to the Ship-to Address table.

Show/hide example query

SELECT
	       [Service Contract Line].[Ship-to Code]
	       ,[Ship-to Address].[Code]
	FROM
	       [CRONUS UK Ltd_$Service Contract Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address]
	              ON
	                     [Service Contract Line].[Ship-to Code] = [Ship-to Address].[Code]
11Item No. SearchItem No.NormalCode20Item No_nvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
	       [Service Contract Line].[Item No_]
	       ,[Item].[No_]
	FROM
	       [CRONUS UK Ltd_$Service Contract Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
	              ON
	                     [Service Contract Line].[Item No_] = [Item].[No_]
12Unit of Measure Code SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
13Response Time (Hours) SearchResponse Time (Hours)NormalDecimal12Response Time (Hours)decimal(38,38)
14Last Planned Service Date SearchLast Planned Service DateNormalDate4Last Planned Service Datedatetime
15Next Planned Service Date SearchNext Planned Service DateNormalDate4Next Planned Service Datedatetime
16Last Service Date SearchLast Service DateNormalDate4Last Service Datedatetime
17Last Preventive Maint. Date SearchLast Preventive Maint. DateNormalDate4Last Preventive Maint_ Datedatetime
18Invoiced to Date SearchInvoiced to DateNormalDate4Invoiced to Datedatetime
19Credit Memo Date SearchCredit Memo DateNormalDate4Credit Memo Datedatetime
20Contract Expiration Date SearchContract Expiration DateNormalDate4Contract Expiration Datedatetime
21Service Period SearchService PeriodNormalDateFormula32Service Periodvarchar(32)
22Line Value SearchLine ValueNormalDecimal12Line Valuedecimal(38,38)
23Line Discount % SearchLine Discount %NormalDecimal12Line Discount _decimal(38,38)
24Line Amount SearchLine AmountNormalDecimal12Line Amountdecimal(38,38)
28Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
	       [Service Contract Line].[Variant Code]
	       ,[Item Variant].[Code]
	FROM
	       [CRONUS UK Ltd_$Service Contract Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
	              ON
	                     [Service Contract Line].[Variant Code] = [Item Variant].[Code]
29Starting Date SearchStarting DateNormalDate4Starting Datedatetime
30New Line SearchNew LineNormalBoolean4New Linetinyint
31Credited SearchCreditedNormalBoolean4Creditedtinyint
32Line Cost SearchLine CostNormalDecimal12Line Costdecimal(38,38)
33Line Discount Amount SearchLine Discount AmountNormalDecimal12Line Discount Amountdecimal(38,38)
34Profit SearchProfitNormalDecimal12Profitdecimal(38,38)
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
	       [Service Contract Line].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Service Contract Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Line]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Service Contract Line].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Service Contract Line table

Ship-to AddressUnit of Measure
Dynamics 365 BC Table ReferenceTablesCompany TablesSService Contract Line

Leave a Reply

Your email address will not be published. Required fields are marked *