Aged Report Entity

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

Table Type: Company

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

Table Number: 5499

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 Aged Report Entity can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[AccountId]
   ,[No_]
   ,[Name]
   ,[Currency Code]
   ,[Before]
   ,[Period 1]
   ,[Period 2]
   ,[Period 3]
   ,[After]
   ,[Balance]
   ,[Period Start Date]
   ,[Period Length]
   ,[Display Order]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Aged Report Entity$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Aged Report Entity$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Aged Report Entity]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Aged Report Entity].[Currency Code] = [Currency].[Code]

Show/hide columns in Aged Report Entity table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2AccountId Primary Key Searchuniqueidentifier
3No_ Searchnvarchar(40)
4Name Searchnvarchar(200)
5Currency Code Searchnvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Aged Report Entity].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Aged Report Entity$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Aged Report Entity]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Aged Report Entity].[Currency Code] = [Currency].[Code]
6Before Searchdecimal(38,38)
7Period 1 Searchdecimal(38,38)
8Period 2 Searchdecimal(38,38)
9Period 3 Searchdecimal(38,38)
10After Searchdecimal(38,38)
11Balance Searchdecimal(38,38)
12Period Start Date Searchdatetime
13Period Length Searchnvarchar(20)
14Display Order Searchint
15$systemId Searchuniqueidentifier
16$systemCreatedAt Searchdatetime
17$systemCreatedBy Searchuniqueidentifier
18$systemModifiedAt Searchdatetime
19$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Aged Report Entity table

Leave a Reply

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