Additional Fee Setup

Dynamics 365 BC Table ReferenceTablesCompany TablesAAdditional 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 NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Charge Per Line SearchCharge Per LineNormalBoolean4Charge Per Linetinyint
2Reminder Terms Code Primary Key SearchReminder Terms CodeNormalCode10Reminder Terms Codenvarchar(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]
3Reminder Level No. Primary Key SearchReminder Level No.NormalInteger4Reminder 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_]
4Currency Code Primary Key SearchCurrency CodeNormalCode10Currency Codenvarchar(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]
5Threshold Remaining Amount Primary Key SearchThreshold Remaining AmountNormalDecimal12Threshold Remaining Amountdecimal(38,38)
6Additional Fee Amount Primary Key SearchAdditional Fee AmountNormalDecimal12Additional Fee Amountdecimal(38,38)
7Additional Fee % SearchAdditional Fee %NormalDecimal12Additional Fee _decimal(38,38)
8Min. Additional Fee Amount SearchMin. Additional Fee AmountNormalDecimal12Min_ Additional Fee Amountdecimal(38,38)
9Max. Additional Fee Amount SearchMax. Additional Fee AmountNormalDecimal12Max_ Additional Fee Amountdecimal(38,38)
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
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]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Additional Fee Setup table

CurrencyReminder Terms
Dynamics 365 BC Table ReferenceTablesCompany TablesAAdditional Fee Setup

Leave a Reply

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