Additional Fee Setup

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

Table Type: Company

Table Name: Additional Fee Setup
Database Table Name: CRONUS UK Ltd_$Additional Fee Setup$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 1050

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 Additional Fee Setup can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Additional Fee Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Reminder Terms Code]
   ,[Reminder Level No_]
   ,[Charge Per Line]
   ,[Currency Code]
   ,[Threshold Remaining Amount]
   ,[Additional Fee Amount]
   ,[Additional Fee _]
   ,[Min_ Additional Fee Amount]
   ,[Max_ Additional Fee Amount]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Additional Fee Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

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

Show/hide columns in Additional Fee Setup 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
       [Additional Fee Setup].[Reminder Terms Code]
       ,[Reminder Terms].[No_]
FROM
       [CRONUS UK Ltd_$Additional Fee Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Additional Fee Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Reminder Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reminder Terms]
              ON
                     [Additional Fee Setup].[Reminder Terms Code] = [Reminder Terms].[No_]
3Reminder Level No_ Primary Key Searchint
4Charge Per Line Primary Key Searchtinyint
5Currency Code Primary Key Searchnvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Additional Fee Setup].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Additional Fee Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Additional Fee Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Additional Fee Setup].[Currency Code] = [Currency].[Code]
6Threshold Remaining Amount Primary Key Searchdecimal(38,38)
7Additional Fee Amount Searchdecimal(38,38)
8Additional Fee _ Searchdecimal(38,38)
9Min_ Additional Fee Amount Searchdecimal(38,38)
10Max_ Additional Fee Amount Searchdecimal(38,38)
11$systemId Searchuniqueidentifier
12$systemCreatedAt Searchdatetime
13$systemCreatedBy Searchuniqueidentifier
14$systemModifiedAt Searchdatetime
15$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Additional Fee Setup table

Leave a Reply

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