Insurance

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

Table Type: Company

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

Table Number: 5628

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [No_]
   ,[Effective Date]
   ,[Expiration Date]
   ,[Policy No_]
   ,[Annual Premium]
   ,[Policy Coverage]
   ,[Insurance Type]
   ,[Last Date Modified]
   ,[Insurance Vendor No_]
   ,[FA Class Code]
   ,[FA Subclass Code]
   ,[FA Location Code]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[Location Code]
   ,[Blocked]
   ,[Description]
   ,[Search Description]
   ,[No_ Series]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Insurance$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Insurance$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Insurance]
LEFT JOIN
   [CRONUS UK Ltd_$Insurance Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Insurance Type]
      ON
         [Insurance].[Insurance Type] = [Insurance Type].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$FA Class$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Class]
      ON
         [Insurance].[FA Class Code] = [FA Class].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$FA Subclass$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Subclass]
      ON
         [Insurance].[FA Subclass Code] = [FA Subclass].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$FA Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Location]
      ON
         [Insurance].[FA Location Code] = [FA Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Insurance].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Insurance].[Global Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Insurance].[Location Code] = [Location].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Insurance].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Insurance].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Insurance table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1No. Primary Key SearchNo.NormalCode20No_nvarchar(40)
2Effective Date SearchEffective DateNormalDate4Effective Datedatetime
3Expiration Date SearchExpiration DateNormalDate4Expiration Datedatetime
4Policy No. SearchPolicy No.NormalText30Policy No_nvarchar(60)
6Annual Premium SearchAnnual PremiumNormalDecimal12Annual Premiumdecimal(38,38)
7Policy Coverage SearchPolicy CoverageNormalDecimal12Policy Coveragedecimal(38,38)
10Total Value Insured SearchTotal Value InsuredFlowFieldDecimal12
11Comment SearchCommentFlowFieldBoolean4
12Insurance Type SearchInsurance TypeNormalCode10Insurance Typenvarchar(20)
Key to join to the Insurance Type table.

Show/hide example query

SELECT
       [Insurance].[Insurance Type]
       ,[Insurance Type].[Code]
FROM
       [CRONUS UK Ltd_$Insurance$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Insurance]
LEFT JOIN
       [CRONUS UK Ltd_$Insurance Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Insurance Type]
              ON
                     [Insurance].[Insurance Type] = [Insurance Type].[Code]
13Last Date Modified SearchLast Date ModifiedNormalDate4Last Date Modifieddatetime
14Insurance Vendor No. SearchInsurance Vendor No.NormalCode20Insurance Vendor No_nvarchar(40)
Key to join to the Vendor table.

Show/hide example query

SELECT
       [Insurance].[Insurance Vendor No_]
       ,[Vendor].[No_]
FROM
       [CRONUS UK Ltd_$Insurance$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Insurance]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Insurance].[Insurance Vendor No_] = [Vendor].[No_]
15FA Class Code SearchFA Class CodeNormalCode10FA Class Codenvarchar(20)
Key to join to the FA Class table.

Show/hide example query

SELECT
       [Insurance].[FA Class Code]
       ,[FA Class].[Code]
FROM
       [CRONUS UK Ltd_$Insurance$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Insurance]
LEFT JOIN
       [CRONUS UK Ltd_$FA Class$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Class]
              ON
                     [Insurance].[FA Class Code] = [FA Class].[Code]
16FA Subclass Code SearchFA Subclass CodeNormalCode10FA Subclass Codenvarchar(20)
Key to join to the FA Subclass table.

Show/hide example query

SELECT
       [Insurance].[FA Subclass Code]
       ,[FA Subclass].[Code]
FROM
       [CRONUS UK Ltd_$Insurance$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Insurance]
LEFT JOIN
       [CRONUS UK Ltd_$FA Subclass$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Subclass]
              ON
                     [Insurance].[FA Subclass Code] = [FA Subclass].[Code]
17FA Location Code SearchFA Location CodeNormalCode10FA Location Codenvarchar(20)
Key to join to the FA Location table.

Show/hide example query

SELECT
       [Insurance].[FA Location Code]
       ,[FA Location].[Code]
FROM
       [CRONUS UK Ltd_$Insurance$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Insurance]
LEFT JOIN
       [CRONUS UK Ltd_$FA Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Location]
              ON
                     [Insurance].[FA Location Code] = [FA Location].[Code]
18Global Dimension 1 Code SearchGlobal Dimension 1 CodeNormalCode20Global Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Insurance].[Global Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Insurance$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Insurance]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Insurance].[Global Dimension 1 Code] = [Dimension].[Code]
19Global Dimension 2 Code SearchGlobal Dimension 2 CodeNormalCode20Global Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Insurance].[Global Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Insurance$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Insurance]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Insurance].[Global Dimension 2 Code] = [Dimension].[Code]
20Location Code SearchLocation CodeNormalCode10Location Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Insurance].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Insurance$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Insurance]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Insurance].[Location Code] = [Location].[Code]
32Blocked SearchBlockedNormalBoolean4Blockedtinyint
33Description SearchDescriptionNormalText100Descriptionnvarchar(200)
34Search Description SearchSearch DescriptionNormalCode100Search Descriptionnvarchar(200)
35Date Filter SearchDate FilterFlowFilterDate4
36No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Insurance].[No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Insurance$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Insurance]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Insurance].[No_ Series] = [No. Series].[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
       [Insurance].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Insurance$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Insurance]
LEFT JOIN
       [User] AS [User]
              ON
                     [Insurance].[$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
       [Insurance].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Insurance$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Insurance]
LEFT JOIN
       [User] AS [User]
              ON
                     [Insurance].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Insurance table

Leave a Reply

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