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
   [timestamp]
   ,[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_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Insurance].[Insurance Vendor No_] = [Vendor].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Insurance].[Location Code] = [Location].[Code]

Show/hide columns in Insurance table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchnvarchar(40)
3Effective Date Searchdatetime
4Expiration Date Searchdatetime
5Policy No_ Searchnvarchar(60)
6Annual Premium Searchdecimal(38,38)
7Policy Coverage Searchdecimal(38,38)
8Insurance Type Searchnvarchar(20)
9Last Date Modified Searchdatetime
10Insurance Vendor No_ Searchnvarchar(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_]
11FA Class Code Searchnvarchar(20)
12FA Subclass Code Searchnvarchar(20)
13FA Location Code Searchnvarchar(20)
14Global Dimension 1 Code Searchnvarchar(40)
15Global Dimension 2 Code Searchnvarchar(40)
16Location Code Searchnvarchar(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]
17Blocked Searchtinyint
18Description Searchnvarchar(200)
19Search Description Searchnvarchar(200)
20No_ Series Searchnvarchar(40)
21$systemId Searchuniqueidentifier
22$systemCreatedAt Searchdatetime
23$systemCreatedBy Searchuniqueidentifier
24$systemModifiedAt Searchdatetime
25$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Insurance table

Leave a Reply

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