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
   [timestamp]
   ,[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_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Ins_ Coverage Ledger Entry].[Location Code] = [Location].[Code]

Show/hide columns in Ins_ Coverage Ledger Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Insurance No_ Searchnvarchar(40)
4Disposed FA Searchtinyint
5FA No_ Searchnvarchar(40)
6FA Description Searchnvarchar(200)
7Posting Date Searchdatetime
8Document Type Searchint
9Document Date Searchdatetime
10Document No_ Searchnvarchar(40)
11External Document No_ Searchnvarchar(70)
12Amount Searchdecimal(38,38)
13Description Searchnvarchar(200)
14FA Class Code Searchnvarchar(20)
15FA Subclass Code Searchnvarchar(20)
16FA Location Code Searchnvarchar(20)
17Global Dimension 1 Code Searchnvarchar(40)
18Global Dimension 2 Code Searchnvarchar(40)
19Location Code Searchnvarchar(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]
20User ID Searchnvarchar(100)
21Source Code Searchnvarchar(20)
22Journal Batch Name Searchnvarchar(20)
23Reason Code Searchnvarchar(20)
24Index Entry Searchtinyint
25No_ Series Searchnvarchar(40)
26Dimension Set ID Searchint
27$systemId Searchuniqueidentifier
28$systemCreatedAt Searchdatetime
29$systemCreatedBy Searchuniqueidentifier
30$systemModifiedAt Searchdatetime
31$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Ins_ Coverage Ledger Entry table

Leave a Reply

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