Service Contract Header

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

Table Type: Company

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

Table Number: 5965

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 Header can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Contract Type]
   ,[Contract No_]
   ,[Description]
   ,[Description 2]
   ,[Status]
   ,[Change Status]
   ,[Customer No_]
   ,[Contact Name]
   ,[Your Reference]
   ,[Salesperson Code]
   ,[Bill-to Customer No_]
   ,[Ship-to Code]
   ,[Serv_ Contract Acc_ Gr_ Code]
   ,[Invoice Period]
   ,[Last Invoice Date]
   ,[Next Invoice Date]
   ,[Starting Date]
   ,[Expiration Date]
   ,[First Service Date]
   ,[Max_ Labor Unit Price]
   ,[Annual Amount]
   ,[Amount per Period]
   ,[Combine Invoices]
   ,[Prepaid]
   ,[Next Invoice Period]
   ,[Service Zone Code]
   ,[Language Code]
   ,[Cancel Reason Code]
   ,[Last Price Update Date]
   ,[Next Price Update Date]
   ,[Last Price Update _]
   ,[Response Time (Hours)]
   ,[Contract Lines on Invoice]
   ,[Service Period]
   ,[Payment Terms Code]
   ,[Invoice after Service]
   ,[Quote Type]
   ,[Allow Unbalanced Amounts]
   ,[Contract Group Code]
   ,[Service Order Type]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Accept Before]
   ,[Automatic Credit Memos]
   ,[Template No_]
   ,[Price Update Period]
   ,[Price Inv_ Increase Code]
   ,[Print Increase Text]
   ,[Currency Code]
   ,[No_ Series]
   ,[Probability]
   ,[Responsibility Center]
   ,[Phone No_]
   ,[Fax No_]
   ,[E-Mail]
   ,[Next Invoice Period Start]
   ,[Next Invoice Period End]
   ,[Payment Method Code]
   ,[Dimension Set ID]
   ,[Direct Debit Mandate ID]
   ,[Contact No_]
   ,[Bill-to Contact No_]
   ,[Bill-to Contact]
   ,[Last Invoice Period End]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Service Contract Header$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 Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Header]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Service Contract Header].[Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson_Purchaser]
      ON
         [Service Contract Header].[Salesperson Code] = [Salesperson_Purchaser].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Service Contract Header].[Bill-to Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [Service Contract Header].[Language Code] = [Language].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
      ON
         [Service Contract Header].[Payment Terms Code] = [Payment Terms].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Service Contract Header].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method]
      ON
         [Service Contract Header].[Payment Method Code] = [Payment Method].[Code]

Show/hide columns in Service Contract Header table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Contract Type Primary Key Searchint
3Contract No_ Primary Key Searchnvarchar(40)
4Description Searchnvarchar(200)
5Description 2 Searchnvarchar(100)
6Status Searchint
7Change Status Searchint
8Customer No_ Searchnvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Service Contract Header].[Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Service Contract Header].[Customer No_] = [Customer].[No_]
9Contact Name Searchnvarchar(200)
10Your Reference Searchnvarchar(70)
11Salesperson Code Searchnvarchar(40)
Key to join to the Salesperson_Purchaser table.

Show/hide example query

SELECT
       [Service Contract Header].[Salesperson Code]
       ,[Salesperson_Purchaser].[No_]
FROM
       [CRONUS UK Ltd_$Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson_Purchaser]
              ON
                     [Service Contract Header].[Salesperson Code] = [Salesperson_Purchaser].[No_]
12Bill-to Customer No_ Searchnvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Service Contract Header].[Bill-to Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Service Contract Header].[Bill-to Customer No_] = [Customer].[No_]
13Ship-to Code Searchnvarchar(20)
14Serv_ Contract Acc_ Gr_ Code Searchnvarchar(20)
15Invoice Period Searchint
16Last Invoice Date Searchdatetime
17Next Invoice Date Searchdatetime
18Starting Date Searchdatetime
19Expiration Date Searchdatetime
20First Service Date Searchdatetime
21Max_ Labor Unit Price Searchdecimal(38,38)
22Annual Amount Searchdecimal(38,38)
23Amount per Period Searchdecimal(38,38)
24Combine Invoices Searchtinyint
25Prepaid Searchtinyint
26Next Invoice Period Searchnvarchar(60)
27Service Zone Code Searchnvarchar(20)
28Language Code Searchnvarchar(20)
Key to join to the Language table.

Show/hide example query

SELECT
       [Service Contract Header].[Language Code]
       ,[Language].[Code]
FROM
       [CRONUS UK Ltd_$Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
              ON
                     [Service Contract Header].[Language Code] = [Language].[Code]
29Cancel Reason Code Searchnvarchar(20)
30Last Price Update Date Searchdatetime
31Next Price Update Date Searchdatetime
32Last Price Update _ Searchdecimal(38,38)
33Response Time (Hours) Searchdecimal(38,38)
34Contract Lines on Invoice Searchtinyint
35Service Period Searchvarchar(32)
36Payment Terms Code Searchnvarchar(20)
Key to join to the Payment Terms table.

Show/hide example query

SELECT
       [Service Contract Header].[Payment Terms Code]
       ,[Payment Terms].[Code]
FROM
       [CRONUS UK Ltd_$Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
              ON
                     [Service Contract Header].[Payment Terms Code] = [Payment Terms].[Code]
37Invoice after Service Searchtinyint
38Quote Type Searchint
39Allow Unbalanced Amounts Searchtinyint
40Contract Group Code Searchnvarchar(20)
41Service Order Type Searchnvarchar(20)
42Shortcut Dimension 1 Code Searchnvarchar(40)
43Shortcut Dimension 2 Code Searchnvarchar(40)
44Accept Before Searchdatetime
45Automatic Credit Memos Searchtinyint
46Template No_ Searchnvarchar(40)
47Price Update Period Searchvarchar(32)
48Price Inv_ Increase Code Searchnvarchar(40)
49Print Increase Text Searchtinyint
50Currency Code Searchnvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Service Contract Header].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Service Contract Header].[Currency Code] = [Currency].[Code]
51No_ Series Searchnvarchar(40)
52Probability Searchdecimal(38,38)
53Responsibility Center Searchnvarchar(20)
54Phone No_ Searchnvarchar(60)
55Fax No_ Searchnvarchar(60)
56E-Mail Searchnvarchar(160)
57Next Invoice Period Start Searchdatetime
58Next Invoice Period End Searchdatetime
59Payment Method Code Searchnvarchar(20)
Key to join to the Payment Method table.

Show/hide example query

SELECT
       [Service Contract Header].[Payment Method Code]
       ,[Payment Method].[Code]
FROM
       [CRONUS UK Ltd_$Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method]
              ON
                     [Service Contract Header].[Payment Method Code] = [Payment Method].[Code]
60Dimension Set ID Searchint
61Direct Debit Mandate ID Searchnvarchar(70)
62Contact No_ Searchnvarchar(40)
63Bill-to Contact No_ Searchnvarchar(40)
64Bill-to Contact Searchnvarchar(200)
65Last Invoice Period End Searchdatetime
66$systemId Searchuniqueidentifier
67$systemCreatedAt Searchdatetime
68$systemCreatedBy Searchuniqueidentifier
69$systemModifiedAt Searchdatetime
70$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Service Contract Header table

Leave a Reply

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