Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/328
Table Type: Company
Table Name: Currency for Fin_ Charge Terms
Database Table Name: CRONUS UK Ltd_$Currency for Fin_ Charge Terms$437dbf0e-84ff-417a-965d-ed2bb9650972
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 for Fin_ Charge Terms can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Currency for Fin_ Charge Terms$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[timestamp]
,[Fin_ Charge Terms Code]
,[Currency Code]
,[Additional Fee]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Currency for Fin_ Charge Terms$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$Currency for Fin_ Charge Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency for Fin_ Charge Terms]
LEFT JOIN
[CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
ON
[Currency for Fin_ Charge Terms].[Currency Code] = [Currency].[Code]Show/hide columns in Currency for Fin_ Charge Terms table
| Column ID | Column Name | Data Type | ||||
|---|---|---|---|---|---|---|
| 1 | timestamp  | timestamp | ||||
| 2 | Fin_ Charge Terms Code  | nvarchar(20) | ||||
| 3 | Currency Code | nvarchar(20) | ||||
Key to join to the Currency table.Show/hide example querySELECT
[Currency for Fin_ Charge Terms].[Currency Code]
,[Currency].[Code]
FROM
[CRONUS UK Ltd_$Currency for Fin_ Charge Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency for Fin_ Charge Terms]
LEFT JOIN
[CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
ON
[Currency for Fin_ Charge Terms].[Currency Code] = [Currency].[Code] | ||||||
| 4 | Additional Fee | decimal(38,38) | ||||
| 5 | $systemId | uniqueidentifier | ||||
| 6 | $systemCreatedAt | datetime | ||||
| 7 | $systemCreatedBy | uniqueidentifier | ||||
| 8 | $systemModifiedAt | datetime | ||||
| 9 | $systemModifiedBy | uniqueidentifier | ||||