Currency – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables CCurrency

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 Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Code	Code	Normal	Code	10	Code	nvarchar(20)
2	Last Date Modified	Last Date Modified	Normal	Date	4	Last Date Modified	datetime
3	Last Date Adjusted	Last Date Adjusted	Normal	Date	4	Last Date Adjusted	datetime
4	ISO Code	ISO Code	Normal	Code	3	ISO Code	nvarchar(6)
5	ISO Numeric Code	ISO Numeric Code	Normal	Code	3	ISO Numeric Code	nvarchar(6)
6	Unrealized Gains Acc.	Unrealized Gains Acc.	Normal	Code	20	Unrealized 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_]
7	Realized Gains Acc.	Realized Gains Acc.	Normal	Code	20	Realized 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_]
8	Unrealized Losses Acc.	Unrealized Losses Acc.	Normal	Code	20	Unrealized 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_]
9	Realized Losses Acc.	Realized Losses Acc.	Normal	Code	20	Realized 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_]
10	Invoice Rounding Precision	Invoice Rounding Precision	Normal	Decimal	12	Invoice Rounding Precision	decimal(38,38)
12	Invoice Rounding Type	Invoice Rounding Type	Normal	Option	4	Invoice Rounding Type	int
	Available options are: “Nearest” “Up” “Down”
13	Amount Rounding Precision	Amount Rounding Precision	Normal	Decimal	12	Amount Rounding Precision	decimal(38,38)
14	Unit-Amount Rounding Precision	Unit-Amount Rounding Precision	Normal	Decimal	12	Unit-Amount Rounding Precision	decimal(38,38)
15	Description	Description	Normal	Text	30	Description	nvarchar(60)
17	Amount Decimal Places	Amount Decimal Places	Normal	Text	5	Amount Decimal Places	nvarchar(10)
18	Unit-Amount Decimal Places	Unit-Amount Decimal Places	Normal	Text	5	Unit-Amount Decimal Places	nvarchar(10)
19	Customer Filter	Customer Filter	FlowFilter	Code	20
20	Vendor Filter	Vendor Filter	FlowFilter	Code	20
21	Global Dimension 1 Filter	Global Dimension 1 Filter	FlowFilter	Code	20
22	Global Dimension 2 Filter	Global Dimension 2 Filter	FlowFilter	Code	20
23	Date Filter	Date Filter	FlowFilter	Date	4
24	Cust. Ledg. Entries in Filter	Cust. Ledg. Entries in Filter	FlowField	Boolean	4
25	Customer Balance	Customer Balance	FlowField	Decimal	12
26	Customer Outstanding Orders	Customer Outstanding Orders	FlowField	Decimal	12
27	Customer Shipped Not Invoiced	Customer Shipped Not Invoiced	FlowField	Decimal	12
28	Customer Balance Due	Customer Balance Due	FlowField	Decimal	12
29	Vendor Ledg. Entries in Filter	Vendor Ledg. Entries in Filter	FlowField	Boolean	4
30	Vendor Balance	Vendor Balance	FlowField	Decimal	12
31	Vendor Outstanding Orders	Vendor Outstanding Orders	FlowField	Decimal	12
32	Vendor Amt. Rcd. Not Invoiced	Vendor Amt. Rcd. Not Invoiced	FlowField	Decimal	12
33	Vendor Balance Due	Vendor Balance Due	FlowField	Decimal	12
34	Customer Balance (LCY)	Customer Balance ($)	FlowField	Decimal	12
35	Vendor Balance (LCY)	Vendor Balance ($)	FlowField	Decimal	12
40	Realized G/L Gains Account	Realized G/L Gains Account	Normal	Code	20	Realized G_L Gains Account	nvarchar(40)
	Key to join to the G/L Account table. Show/hide example query SELECT [Currency].[Realized G_L 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].[Realized G_L Gains Account] = [G/L Account].[No_]
41	Realized G/L Losses Account	Realized G/L Losses Account	Normal	Code	20	Realized G_L Losses Account	nvarchar(40)
	Key to join to the G/L Account table. Show/hide example query SELECT [Currency].[Realized G_L 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].[Realized G_L Losses Account] = [G/L Account].[No_]
44	Appln. Rounding Precision	Appln. Rounding Precision	Normal	Decimal	12	Appln_ Rounding Precision	decimal(38,38)
45	EMU Currency	EMU Currency	Normal	Boolean	4	EMU Currency	tinyint
46	Currency Factor	Currency Factor	Normal	Decimal	12	Currency Factor	decimal(38,38)
47	Residual Gains Account	Residual Gains Account	Normal	Code	20	Residual Gains Account	nvarchar(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_]
48	Residual Losses Account	Residual Losses Account	Normal	Code	20	Residual Losses Account	nvarchar(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_]
50	Conv. LCY Rndg. Debit Acc.	Conv. $ Rndg. Debit Acc.	Normal	Code	20	Conv_ 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_]
51	Conv. LCY Rndg. Credit Acc.	Conv. $ Rndg. Credit Acc.	Normal	Code	20	Conv_ 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_]
52	Max. VAT Difference Allowed	Max. Tax Difference Allowed	Normal	Decimal	12	Max_ VAT Difference Allowed	decimal(38,38)
53	VAT Rounding Type	Tax Rounding Type	Normal	Option	4	VAT Rounding Type	int
	Available options are: “Nearest” “Up” “Down”
54	Payment Tolerance %	Payment Tolerance %	Normal	Decimal	12	Payment Tolerance _	decimal(38,38)
55	Max. Payment Tolerance Amount	Max. Payment Tolerance Amount	Normal	Decimal	12	Max_ Payment Tolerance Amount	decimal(38,38)
56	Symbol	Symbol	Normal	Text	10	Symbol	nvarchar(20)
57	Last Modified Date Time	Last Modified Date Time	Normal	DateTime	8	Last Modified Date Time	datetime
720	Coupled to CRM	Coupled to Dataverse	Normal	Boolean	4	Coupled to CRM	tinyint
721	Coupled to Dataverse	Coupled to Dataverse	FlowField	Boolean	4
8000	Id	Id	Normal	GUID	16	Id	uniqueidentifier
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 [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]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Currency].[$systemModifiedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency] LEFT JOIN [User] AS [User] ON [Currency].[$systemModifiedBy] = [User].[User Security ID]

Dynamics 365 BC Table Reference Tables Company Tables CCurrency

Leave a Reply Cancel reply