Additional Fee Setup – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables AAdditional 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 ID	Column Name	Data Type
1	timestamp	timestamp
2	Reminder Terms Code	nvarchar(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_]
3	Reminder Level No_	int
4	Charge Per Line	tinyint
5	Currency Code	nvarchar(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]
6	Threshold Remaining Amount	decimal(38,38)
7	Additional Fee Amount	decimal(38,38)
8	Additional Fee _	decimal(38,38)
9	Min_ Additional Fee Amount	decimal(38,38)
10	Max_ Additional Fee Amount	decimal(38,38)
11	$systemId	uniqueidentifier
12	$systemCreatedAt	datetime
13	$systemCreatedBy	uniqueidentifier
14	$systemModifiedAt	datetime
15	$systemModifiedBy	uniqueidentifier