Currency

Dynamics 365 BC Table ReferenceTablesCompany TablesCCurrency

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

Table Type: Company

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

Table Number: 4

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Code]
   ,[Last Date Modified]
   ,[Last Date Adjusted]
   ,[ISO Code]
   ,[ISO Numeric Code]
   ,[Unrealized Gains Acc_]
   ,[Realized Gains Acc_]
   ,[Unrealized Losses Acc_]
   ,[Realized Losses Acc_]
   ,[Invoice Rounding Precision]
   ,[Invoice Rounding Type]
   ,[Amount Rounding Precision]
   ,[Unit-Amount Rounding Precision]
   ,[Description]
   ,[Amount Decimal Places]
   ,[Unit-Amount Decimal Places]
   ,[Realized G_L Gains Account]
   ,[Realized G_L Losses Account]
   ,[Appln_ Rounding Precision]
   ,[EMU Currency]
   ,[Currency Factor]
   ,[Residual Gains Account]
   ,[Residual Losses Account]
   ,[Conv_ LCY Rndg_ Debit Acc_]
   ,[Conv_ LCY Rndg_ Credit Acc_]
   ,[Max_ VAT Difference Allowed]
   ,[VAT Rounding Type]
   ,[Payment Tolerance _]
   ,[Max_ Payment Tolerance Amount]
   ,[Symbol]
   ,[Last Modified Date Time]
   ,[Coupled to CRM]
   ,[Id]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [] AS [Currency]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Currency].[Customer Filter] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Currency].[Vendor Filter] = [Vendor].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [Currency].[Residual Gains Account] = [G/L Account].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [Currency].[Residual Losses Account] = [G/L Account].[No_]
LEFT JOIN
   [User] AS [User]
      ON
         [Currency].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Currency].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Currency table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Code SearchCodeNormalCode10Codenvarchar(20)
2Last Date Modified Primary Key SearchLast Date ModifiedNormalDate4Last Date Modifieddatetime
3Last Date Adjusted SearchLast Date AdjustedNormalDate4Last Date Adjusteddatetime
4ISO Code SearchISO CodeNormalCode3ISO Codenvarchar(6)
5ISO Numeric Code SearchISO Numeric CodeNormalCode3ISO Numeric Codenvarchar(6)
6Unrealized Gains Acc. SearchUnrealized Gains Acc.NormalCode20Unrealized Gains Acc_nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [Currency].[Unrealized Gains Acc_]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [Currency].[Unrealized Gains Acc_] = [G/L Account].[No_]
7Realized Gains Acc. SearchRealized Gains Acc.NormalCode20Realized Gains Acc_nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [Currency].[Realized Gains Acc_]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [Currency].[Realized Gains Acc_] = [G/L Account].[No_]
8Unrealized Losses Acc. SearchUnrealized Losses Acc.NormalCode20Unrealized Losses Acc_nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [Currency].[Unrealized Losses Acc_]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [Currency].[Unrealized Losses Acc_] = [G/L Account].[No_]
9Realized Losses Acc. SearchRealized Losses Acc.NormalCode20Realized Losses Acc_nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [Currency].[Realized Losses Acc_]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [Currency].[Realized Losses Acc_] = [G/L Account].[No_]
10Invoice Rounding Precision SearchInvoice Rounding PrecisionNormalDecimal12Invoice Rounding Precisiondecimal(38,38)
12Invoice Rounding Type SearchInvoice Rounding TypeNormalOption4Invoice Rounding Typeint
Available options are:
  • “Nearest”
  • “Up”
  • “Down”
13Amount Rounding Precision SearchAmount Rounding PrecisionNormalDecimal12Amount Rounding Precisiondecimal(38,38)
14Unit-Amount Rounding Precision SearchUnit-Amount Rounding PrecisionNormalDecimal12Unit-Amount Rounding Precisiondecimal(38,38)
15Description SearchDescriptionNormalText30Descriptionnvarchar(60)
17Amount Decimal Places SearchAmount Decimal PlacesNormalText5Amount Decimal Placesnvarchar(10)
18Unit-Amount Decimal Places SearchUnit-Amount Decimal PlacesNormalText5Unit-Amount Decimal Placesnvarchar(10)
19Customer Filter SearchCustomer FilterFlowFilterCode20
Key to join to the Customer table.

Show/hide example query

SELECT
	       [Currency].[]
	       ,[Customer].[No_]
	FROM
	       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
	LEFT JOIN
	       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
	              ON
	                     [Currency].[] = [Customer].[No_]
20Vendor Filter SearchVendor FilterFlowFilterCode20
Key to join to the Vendor table.

Show/hide example query

SELECT
	       [Currency].[]
	       ,[Vendor].[No_]
	FROM
	       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
	LEFT JOIN
	       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
	              ON
	                     [Currency].[] = [Vendor].[No_]
21Global Dimension 1 Filter SearchGlobal Dimension 1 FilterFlowFilterCode20
22Global Dimension 2 Filter SearchGlobal Dimension 2 FilterFlowFilterCode20
23Date Filter SearchDate FilterFlowFilterDate4
24Cust. Ledg. Entries in Filter SearchCust. Ledg. Entries in FilterFlowFieldBoolean4
25Customer Balance SearchCustomer BalanceFlowFieldDecimal12
26Customer Outstanding Orders SearchCustomer Outstanding OrdersFlowFieldDecimal12
27Customer Shipped Not Invoiced SearchCustomer Shipped Not InvoicedFlowFieldDecimal12
28Customer Balance Due SearchCustomer Balance DueFlowFieldDecimal12
29Vendor Ledg. Entries in Filter SearchVendor Ledg. Entries in FilterFlowFieldBoolean4
30Vendor Balance SearchVendor BalanceFlowFieldDecimal12
31Vendor Outstanding Orders SearchVendor Outstanding OrdersFlowFieldDecimal12
32Vendor Amt. Rcd. Not Invoiced SearchVendor Amt. Rcd. Not InvoicedFlowFieldDecimal12
33Vendor Balance Due SearchVendor Balance DueFlowFieldDecimal12
34Customer Balance (LCY) SearchCustomer Balance ($)FlowFieldDecimal12
35Vendor Balance (LCY) SearchVendor Balance ($)FlowFieldDecimal12
40Realized G/L Gains Account SearchRealized G/L Gains AccountNormalCode20Realized G_L Gains Accountnvarchar(40)
41Realized G/L Losses Account SearchRealized G/L Losses AccountNormalCode20Realized G_L Losses Accountnvarchar(40)
44Appln. Rounding Precision SearchAppln. Rounding PrecisionNormalDecimal12Appln_ Rounding Precisiondecimal(38,38)
45EMU Currency SearchEMU CurrencyNormalBoolean4EMU Currencytinyint
46Currency Factor SearchCurrency FactorNormalDecimal12Currency Factordecimal(38,38)
47Residual Gains Account SearchResidual Gains AccountNormalCode20Residual Gains Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [Currency].[Residual Gains Account]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [Currency].[Residual Gains Account] = [G/L Account].[No_]
48Residual Losses Account SearchResidual Losses AccountNormalCode20Residual Losses Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [Currency].[Residual Losses Account]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [Currency].[Residual Losses Account] = [G/L Account].[No_]
50Conv. LCY Rndg. Debit Acc. SearchConv. $ Rndg. Debit Acc.NormalCode20Conv_ LCY Rndg_ Debit Acc_nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [Currency].[Conv_ LCY Rndg_ Debit Acc_]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [Currency].[Conv_ LCY Rndg_ Debit Acc_] = [G/L Account].[No_]
51Conv. LCY Rndg. Credit Acc. SearchConv. $ Rndg. Credit Acc.NormalCode20Conv_ LCY Rndg_ Credit Acc_nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [Currency].[Conv_ LCY Rndg_ Credit Acc_]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [Currency].[Conv_ LCY Rndg_ Credit Acc_] = [G/L Account].[No_]
52Max. VAT Difference Allowed SearchMax. Tax Difference AllowedNormalDecimal12Max_ VAT Difference Alloweddecimal(38,38)
53VAT Rounding Type SearchTax Rounding TypeNormalOption4VAT Rounding Typeint
Available options are:
  • “Nearest”
  • “Up”
  • “Down”
54Payment Tolerance % SearchPayment Tolerance %NormalDecimal12Payment Tolerance _decimal(38,38)
55Max. Payment Tolerance Amount SearchMax. Payment Tolerance AmountNormalDecimal12Max_ Payment Tolerance Amountdecimal(38,38)
56Symbol SearchSymbolNormalText10Symbolnvarchar(20)
57Last Modified Date Time SearchLast Modified Date TimeNormalDateTime8Last Modified Date Timedatetime
720Coupled to CRM SearchCoupled to DataverseNormalBoolean4Coupled to CRMtinyint
721Coupled to Dataverse SearchCoupled to DataverseFlowFieldBoolean4
8000Id SearchIdNormalGUID16Iduniqueidentifier
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
	       [Currency].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Currency].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Dynamics 365 BC Table ReferenceTablesCompany TablesCCurrency

Leave a Reply

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