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
   [timestamp]
   ,[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_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [Service Contract Template].[Language Code] = [Language].[Code]

Show/hide columns in Service Contract Template table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchnvarchar(40)
3Description Searchnvarchar(200)
4Invoice Period Searchint
5Max_ Labor Unit Price Searchdecimal(38,38)
6Combine Invoices Searchtinyint
7Prepaid Searchtinyint
8Service Zone Code Searchnvarchar(20)
9Language Code Searchnvarchar(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]
10Default Response Time (Hours) Searchdecimal(38,38)
11Contract Lines on Invoice Searchtinyint
12Default Service Period Searchvarchar(32)
13Invoice after Service Searchtinyint
14Allow Unbalanced Amounts Searchtinyint
15Contract Group Code Searchnvarchar(20)
16Service Order Type Searchnvarchar(20)
17Automatic Credit Memos Searchtinyint
18No_ Series Searchnvarchar(40)
19Price Update Period Searchvarchar(32)
20Price Inv_ Increase Code Searchnvarchar(40)
21Serv_ Contract Acc_ Gr_ Code Searchnvarchar(20)
22$systemId Searchuniqueidentifier
23$systemCreatedAt Searchdatetime
24$systemCreatedBy Searchuniqueidentifier
25$systemModifiedAt Searchdatetime
26$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Service Contract Template table

Leave a Reply

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