Service Contract Template

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

Table Type: Company

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

Table Number: 5968

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [No_]
   ,[Description]
   ,[Invoice Period]
   ,[Max_ Labor Unit Price]
   ,[Combine Invoices]
   ,[Prepaid]
   ,[Service Zone Code]
   ,[Language Code]
   ,[Default Response Time (Hours)]
   ,[Contract Lines on Invoice]
   ,[Default Service Period]
   ,[Invoice after Service]
   ,[Allow Unbalanced Amounts]
   ,[Contract Group Code]
   ,[Service Order Type]
   ,[Automatic Credit Memos]
   ,[No_ Series]
   ,[Price Update Period]
   ,[Price Inv_ Increase Code]
   ,[Serv_ Contract Acc_ Gr_ Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Service Contract Template$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 Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Template]
LEFT JOIN
   [CRONUS UK Ltd_$Service Zone$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Zone]
      ON
         [Service Contract Template].[Service Zone Code] = [Service Zone].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [Service Contract Template].[Language Code] = [Language].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Contract Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contract Group]
      ON
         [Service Contract Template].[Contract Group Code] = [Contract Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Service Order Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Order Type]
      ON
         [Service Contract Template].[Service Order Type] = [Service Order Type].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Service Contract Template].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Service Contract Template].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Service Contract Template table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1No. Primary Key SearchNo.NormalCode20No_nvarchar(40)
2Description SearchDescriptionNormalText100Descriptionnvarchar(200)
3Invoice Period SearchInvoice PeriodNormalOption4Invoice Periodint
Available options are:
  • “Month”
  • “Two Months”
  • “Quarter”
  • “Half Year”
  • “Year”
  • “None”
4Max. Labor Unit Price SearchMax. Labor Unit PriceNormalDecimal12Max_ Labor Unit Pricedecimal(38,38)
5Combine Invoices SearchCombine InvoicesNormalBoolean4Combine Invoicestinyint
6Prepaid SearchPrepaidNormalBoolean4Prepaidtinyint
7Service Zone Code SearchService Zone CodeNormalCode10Service Zone Codenvarchar(20)
Key to join to the Service Zone table.

Show/hide example query

SELECT
       [Service Contract Template].[Service Zone Code]
       ,[Service Zone].[Code]
FROM
       [CRONUS UK Ltd_$Service Contract Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Template]
LEFT JOIN
       [CRONUS UK Ltd_$Service Zone$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Zone]
              ON
                     [Service Contract Template].[Service Zone Code] = [Service Zone].[Code]
8Language Code SearchLanguage CodeNormalCode10Language Codenvarchar(20)
Key to join to the Language table.

Show/hide example query

SELECT
       [Service Contract Template].[Language Code]
       ,[Language].[Code]
FROM
       [CRONUS UK Ltd_$Service Contract Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Template]
LEFT JOIN
       [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
              ON
                     [Service Contract Template].[Language Code] = [Language].[Code]
9Default Response Time (Hours) SearchDefault Response Time (Hours)NormalDecimal12Default Response Time (Hours)decimal(38,38)
10Contract Lines on Invoice SearchContract Lines on InvoiceNormalBoolean4Contract Lines on Invoicetinyint
11Default Service Period SearchDefault Service PeriodNormalDateFormula32Default Service Periodvarchar(32)
14Invoice after Service SearchInvoice after ServiceNormalBoolean4Invoice after Servicetinyint
15Allow Unbalanced Amounts SearchAllow Unbalanced AmountsNormalBoolean4Allow Unbalanced Amountstinyint
16Contract Group Code SearchContract Group CodeNormalCode10Contract Group Codenvarchar(20)
Key to join to the Contract Group table.

Show/hide example query

SELECT
       [Service Contract Template].[Contract Group Code]
       ,[Contract Group].[Code]
FROM
       [CRONUS UK Ltd_$Service Contract Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Template]
LEFT JOIN
       [CRONUS UK Ltd_$Contract Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contract Group]
              ON
                     [Service Contract Template].[Contract Group Code] = [Contract Group].[Code]
17Service Order Type SearchService Order TypeNormalCode10Service Order Typenvarchar(20)
Key to join to the Service Order Type table.

Show/hide example query

SELECT
       [Service Contract Template].[Service Order Type]
       ,[Service Order Type].[Code]
FROM
       [CRONUS UK Ltd_$Service Contract Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Template]
LEFT JOIN
       [CRONUS UK Ltd_$Service Order Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Order Type]
              ON
                     [Service Contract Template].[Service Order Type] = [Service Order Type].[Code]
18Automatic Credit Memos SearchAutomatic Credit MemosNormalBoolean4Automatic Credit Memostinyint
20No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Service Contract Template].[No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Service Contract Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Template]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Service Contract Template].[No_ Series] = [No. Series].[Code]
21Price Update Period SearchPrice Update PeriodNormalDateFormula32Price Update Periodvarchar(32)
22Price Inv. Increase Code SearchPrice Inv. Increase CodeNormalCode20Price Inv_ Increase Codenvarchar(40)
Key to join to the Standard Text table.

Show/hide example query

SELECT
       [Service Contract Template].[Price Inv_ Increase Code]
       ,[Standard Text].[Code]
FROM
       [CRONUS UK Ltd_$Service Contract Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Template]
LEFT JOIN
       [CRONUS UK Ltd_$Standard Text$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Text]
              ON
                     [Service Contract Template].[Price Inv_ Increase Code] = [Standard Text].[Code]
23Serv. Contract Acc. Gr. Code SearchServ. Contract Acc. Gr. CodeNormalCode10Serv_ Contract Acc_ Gr_ Codenvarchar(20)
Key to join to the Service Contract Account Group table.

Show/hide example query

SELECT
       [Service Contract Template].[Serv_ Contract Acc_ Gr_ Code]
       ,[Service Contract Account Group].[Code]
FROM
       [CRONUS UK Ltd_$Service Contract Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Template]
LEFT JOIN
       [CRONUS UK Ltd_$Service Contract Account Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Account Group]
              ON
                     [Service Contract Template].[Serv_ Contract Acc_ Gr_ Code] = [Service Contract Account Group].[Code]
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 Template].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Service Contract Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Template]
LEFT JOIN
       [User] AS [User]
              ON
                     [Service Contract Template].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Service Contract Template].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Service Contract Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Template]
LEFT JOIN
       [User] AS [User]
              ON
                     [Service Contract Template].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Service Contract Template table

Leave a Reply

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