Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/293
Table Type: Company
Table Name: Reminder Level
Database Table Name: CRONUS UK Ltd_$Reminder Level$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 Reminder Level can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Reminder Level$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[timestamp]
,[Reminder Terms Code]
,[No_]
,[Grace Period]
,[Additional Fee (LCY)]
,[Calculate Interest]
,[Due Date Calculation]
,[Add_ Fee per Line Amount (LCY)]
,[Add_ Fee per Line Description]
,[Add_ Fee Calculation Type]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Reminder Level$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$Reminder Level$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reminder Level]
LEFT JOIN
[CRONUS UK Ltd_$Reminder Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reminder Terms]
ON
[Reminder Level].[Reminder Terms Code] = [Reminder Terms].[No_]Show/hide columns in Reminder Level table
| Column ID | Column Name | Data Type | ||||
|---|---|---|---|---|---|---|
| 1 | timestamp  | timestamp | ||||
| 2 | Reminder Terms Code  | nvarchar(20) | ||||
Key to join to the Reminder Terms table.Show/hide example querySELECT
[Reminder Level].[Reminder Terms Code]
,[Reminder Terms].[No_]
FROM
[CRONUS UK Ltd_$Reminder Level$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reminder Level]
LEFT JOIN
[CRONUS UK Ltd_$Reminder Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reminder Terms]
ON
[Reminder Level].[Reminder Terms Code] = [Reminder Terms].[No_] | ||||||
| 3 | No_ | int | ||||
| 4 | Grace Period | varchar(32) | ||||
| 5 | Additional Fee (LCY) | decimal(38,38) | ||||
| 6 | Calculate Interest | tinyint | ||||
| 7 | Due Date Calculation | varchar(32) | ||||
| 8 | Add_ Fee per Line Amount (LCY) | decimal(38,38) | ||||
| 9 | Add_ Fee per Line Description | nvarchar(200) | ||||
| 10 | Add_ Fee Calculation Type | int | ||||
| 11 | $systemId | uniqueidentifier | ||||
| 12 | $systemCreatedAt | datetime | ||||
| 13 | $systemCreatedBy | uniqueidentifier | ||||
| 14 | $systemModifiedAt | datetime | ||||
| 15 | $systemModifiedBy | uniqueidentifier | ||||