Service 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
   [timestamp]
   ,[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_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Service Contract Line].[Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Service Contract Line].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Service Contract Line].[Unit of Measure Code] = [Unit of Measure].[Code]

Show/hide columns in Service Contract Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Contract Type Primary Key Searchint
3Contract No_ Primary Key Searchnvarchar(40)
4Line No_ Primary Key Searchint
5Contract Status Searchint
6Service Item No_ Searchnvarchar(40)
7Description Searchnvarchar(200)
8Serial No_ Searchnvarchar(100)
9Service Item Group Code Searchnvarchar(20)
10Customer No_ Searchnvarchar(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_]
11Ship-to Code Searchnvarchar(20)
12Item No_ Searchnvarchar(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$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Service Contract Line].[Item No_] = [Item].[No_]
13Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Service Contract Line].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Service Contract Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Line]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Service Contract Line].[Unit of Measure Code] = [Unit of Measure].[Code]
14Response Time (Hours) Searchdecimal(38,38)
15Last Planned Service Date Searchdatetime
16Next Planned Service Date Searchdatetime
17Last Service Date Searchdatetime
18Last Preventive Maint_ Date Searchdatetime
19Invoiced to Date Searchdatetime
20Credit Memo Date Searchdatetime
21Contract Expiration Date Searchdatetime
22Service Period Searchvarchar(32)
23Line Value Searchdecimal(38,38)
24Line Discount _ Searchdecimal(38,38)
25Line Amount Searchdecimal(38,38)
26Variant Code Searchnvarchar(20)
27Starting Date Searchdatetime
28New Line Searchtinyint
29Credited Searchtinyint
30Line Cost Searchdecimal(38,38)
31Line Discount Amount Searchdecimal(38,38)
32Profit Searchdecimal(38,38)
33$systemId Searchuniqueidentifier
34$systemCreatedAt Searchdatetime
35$systemCreatedBy Searchuniqueidentifier
36$systemModifiedAt Searchdatetime
37$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Service Contract Line table

Leave a Reply

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