Currency for Reminder Level

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

Table Type: Company

Table Name: Currency for Reminder Level
Database Table Name: CRONUS UK Ltd_$Currency for Reminder Level$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 329

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 Currency for Reminder Level can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Currency for Reminder Level$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Reminder Terms Code]
   ,[No_]
   ,[Currency Code]
   ,[Additional Fee]
   ,[Add_ Fee per Line]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Currency for Reminder Level$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Currency for Reminder Level$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency for Reminder Level]
LEFT JOIN
   [CRONUS UK Ltd_$Reminder Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reminder Terms]
      ON
         [Currency for Reminder Level].[Reminder Terms Code] = [Reminder Terms].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Currency for Reminder Level].[Currency Code] = [Currency].[Code]

Show/hide columns in Currency for Reminder Level table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Reminder Terms Code Primary Key Searchnvarchar(20)
Key to join to the Reminder Terms table.

Show/hide example query

SELECT
       [Currency for Reminder Level].[Reminder Terms Code]
       ,[Reminder Terms].[No_]
FROM
       [CRONUS UK Ltd_$Currency for Reminder Level$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency for Reminder Level]
LEFT JOIN
       [CRONUS UK Ltd_$Reminder Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reminder Terms]
              ON
                     [Currency for Reminder Level].[Reminder Terms Code] = [Reminder Terms].[No_]
3No_ Primary Key Searchint
4Currency Code Primary Key Searchnvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Currency for Reminder Level].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Currency for Reminder Level$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency for Reminder Level]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Currency for Reminder Level].[Currency Code] = [Currency].[Code]
5Additional Fee Searchdecimal(38,38)
6Add_ Fee per Line Searchdecimal(38,38)
7$systemId Searchuniqueidentifier
8$systemCreatedAt Searchdatetime
9$systemCreatedBy Searchuniqueidentifier
10$systemModifiedAt Searchdatetime
11$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Currency for Reminder Level table

Leave a Reply

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