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

   [Charge Per Line]
   ,[Reminder Terms Code]
   ,[Reminder Level No_]
   ,[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].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Additional Fee Setup].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Additional Fee Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Additional Fee Setup].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Additional Fee Setup table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Charge Per Line	Charge Per Line	Normal	Boolean	4	Charge Per Line	tinyint
2	Reminder Terms Code	Reminder Terms Code	Normal	Code	10	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].[Code] 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].[Code]
3	Reminder Level No.	Reminder Level No.	Normal	Integer	4	Reminder Level No_	int
	Key to join to the Reminder Level table. Show/hide example query SELECT [Additional Fee Setup].[Reminder Level No_] ,[Reminder Level].[No_] FROM [CRONUS UK Ltd_$Additional Fee Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Additional Fee Setup] LEFT JOIN [CRONUS UK Ltd_$Reminder Level$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reminder Level] ON [Additional Fee Setup].[Reminder Level No_] = [Reminder Level].[No_]
4	Currency Code	Currency Code	Normal	Code	10	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]
5	Threshold Remaining Amount	Threshold Remaining Amount	Normal	Decimal	12	Threshold Remaining Amount	decimal(38,38)
6	Additional Fee Amount	Additional Fee Amount	Normal	Decimal	12	Additional Fee Amount	decimal(38,38)
7	Additional Fee %	Additional Fee %	Normal	Decimal	12	Additional Fee _	decimal(38,38)
8	Min. Additional Fee Amount	Min. Additional Fee Amount	Normal	Decimal	12	Min_ Additional Fee Amount	decimal(38,38)
9	Max. Additional Fee Amount	Max. Additional Fee Amount	Normal	Decimal	12	Max_ Additional Fee Amount	decimal(38,38)
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Additional Fee Setup].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Additional Fee Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Additional Fee Setup] LEFT JOIN [User] AS [User] ON [Additional Fee Setup].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Additional Fee Setup table

Dynamics 365 BC Table Reference Tables Company Tables AAdditional Fee Setup

Leave a Reply Cancel reply