Ins. Coverage Ledger Entry

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

Table Type: Company

Table Name: Ins. Coverage Ledger Entry
Database Table Name: CRONUS UK Ltd_$Ins_ Coverage Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5629

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 Ins. Coverage Ledger Entry can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Ins_ Coverage Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [Entry No_]
   ,[Insurance No_]
   ,[Disposed FA]
   ,[FA No_]
   ,[FA Description]
   ,[Posting Date]
   ,[Document Type]
   ,[Document Date]
   ,[Document No_]
   ,[External Document No_]
   ,[Amount]
   ,[Description]
   ,[FA Class Code]
   ,[FA Subclass Code]
   ,[FA Location Code]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[Location Code]
   ,[User ID]
   ,[Source Code]
   ,[Journal Batch Name]
   ,[Reason Code]
   ,[Index Entry]
   ,[No_ Series]
   ,[Dimension Set ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Ins_ Coverage Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Ins_ Coverage Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ins. Coverage Ledger Entry]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [Ins. Coverage Ledger Entry].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [Ins. Coverage Ledger Entry].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [Ins. Coverage Ledger Entry].[Document Type] = [Sales Header].[Document Type]
      AND
         [Ins. Coverage Ledger Entry].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$FA Class$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Class]
      ON
         [Ins. Coverage Ledger Entry].[FA Class Code] = [FA Class].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$FA Subclass$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Subclass]
      ON
         [Ins. Coverage Ledger Entry].[FA Subclass Code] = [FA Subclass].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$FA Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Location]
      ON
         [Ins. Coverage Ledger Entry].[FA Location Code] = [FA Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Ins. Coverage Ledger Entry].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Ins. Coverage Ledger Entry].[Global Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Ins. Coverage Ledger Entry].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Ins. Coverage Ledger Entry].[Source Code] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
      ON
         [Ins. Coverage Ledger Entry].[Reason Code] = [Reason Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Ins. Coverage Ledger Entry].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Ins. Coverage Ledger Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Ins. Coverage Ledger Entry].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Ins. Coverage Ledger Entry table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Entry No. Primary Key SearchEntry No.NormalInteger4Entry No_int
2Insurance No. SearchInsurance No.NormalCode20Insurance No_nvarchar(40)
Key to join to the Insurance table.

Show/hide example query

SELECT
       [Ins. Coverage Ledger Entry].[Insurance No_]
       ,[Insurance].[No_]
FROM
       [CRONUS UK Ltd_$Ins_ Coverage Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ins. Coverage Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Insurance$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Insurance]
              ON
                     [Ins. Coverage Ledger Entry].[Insurance No_] = [Insurance].[No_]
3Disposed FA SearchDisposed FANormalBoolean4Disposed FAtinyint
4FA No. SearchFA No.NormalCode20FA No_nvarchar(40)
Key to join to the Fixed Asset table.

Show/hide example query

SELECT
       [Ins. Coverage Ledger Entry].[FA No_]
       ,[Fixed Asset].[No_]
FROM
       [CRONUS UK Ltd_$Ins_ Coverage Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ins. Coverage Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Fixed Asset$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fixed Asset]
              ON
                     [Ins. Coverage Ledger Entry].[FA No_] = [Fixed Asset].[No_]
5FA Description SearchFA DescriptionNormalText100FA Descriptionnvarchar(200)
6Posting Date SearchPosting DateNormalDate4Posting Datedatetime
7Document Type SearchDocument TypeNormalOption4Document Typeint
Available options are:
  • ” “
  • “Payment”
  • “Invoice”
  • “Credit Memo”
  • “Finance Charge Memo”
  • “Reminder”
  • “Refund”
8Document Date SearchDocument DateNormalDate4Document Datedatetime
9Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
10External Document No. SearchExternal Document No.NormalCode35External Document No_nvarchar(70)
14Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
16Description SearchDescriptionNormalText100Descriptionnvarchar(200)
17FA Class Code SearchFA Class CodeNormalCode10FA Class Codenvarchar(20)
Key to join to the FA Class table.

Show/hide example query

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

Show/hide example query

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

Show/hide example query

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

Show/hide example query

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

Show/hide example query

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

Show/hide example query

SELECT
       [Ins. Coverage Ledger Entry].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Ins_ Coverage Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ins. Coverage Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Ins. Coverage Ledger Entry].[Location Code] = [Location].[Code]
23User ID SearchUser IDNormalCode50User IDnvarchar(100)
24Source Code SearchSource CodeNormalCode10Source Codenvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Ins. Coverage Ledger Entry].[Source Code]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Ins_ Coverage Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ins. Coverage Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Ins. Coverage Ledger Entry].[Source Code] = [Source Code].[Code]
25Journal Batch Name SearchJournal Batch NameNormalCode10Journal Batch Namenvarchar(20)
26Reason Code SearchReason CodeNormalCode10Reason Codenvarchar(20)
Key to join to the Reason Code table.

Show/hide example query

SELECT
       [Ins. Coverage Ledger Entry].[Reason Code]
       ,[Reason Code].[Code]
FROM
       [CRONUS UK Ltd_$Ins_ Coverage Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ins. Coverage Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
              ON
                     [Ins. Coverage Ledger Entry].[Reason Code] = [Reason Code].[Code]
27Index Entry SearchIndex EntryNormalBoolean4Index Entrytinyint
28No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Ins. Coverage Ledger Entry].[No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Ins_ Coverage Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ins. Coverage Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Ins. Coverage Ledger Entry].[No_ Series] = [No. Series].[Code]
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
       [Ins. Coverage Ledger Entry].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Ins_ Coverage Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ins. Coverage Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Ins. Coverage Ledger Entry].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
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
       [Ins. Coverage Ledger Entry].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Ins_ Coverage Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ins. Coverage Ledger Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Ins. Coverage Ledger Entry].[$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
       [Ins. Coverage Ledger Entry].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Ins_ Coverage Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ins. Coverage Ledger Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Ins. Coverage Ledger Entry].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Ins. Coverage Ledger Entry table

Leave a Reply

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