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
[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].[Code]
LEFT JOIN
[User] AS [User]
ON
[Reminder Level].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Reminder Level].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in Reminder Level table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Reminder Terms Code   | Reminder Terms Code | Normal | Code | 10 | Reminder Terms Code | nvarchar(20) |
Key to join to the Reminder Terms table.Show/hide example querySELECT
[Reminder Level].[Reminder Terms Code]
,[Reminder Terms].[Code]
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].[Code] | |||||||
| 2 | No. | No. | Normal | Integer | 4 | No_ | int |
| 3 | Grace Period | Grace Period | Normal | DateFormula | 32 | Grace Period | varchar(32) |
| 4 | Additional Fee (LCY) | Additional Fee ($) | Normal | Decimal | 12 | Additional Fee (LCY) | decimal(38,38) |
| 5 | Calculate Interest | Calculate Interest | Normal | Boolean | 4 | Calculate Interest | tinyint |
| 6 | Due Date Calculation | Due Date Calculation | Normal | DateFormula | 32 | Due Date Calculation | varchar(32) |
| 7 | Add. Fee per Line Amount (LCY) | Add. Fee per Line Amount ($) | Normal | Decimal | 12 | Add_ Fee per Line Amount (LCY) | decimal(38,38) |
| 8 | Add. Fee per Line Description | Add. Fee per Line Description | Normal | Text | 100 | Add_ Fee per Line Description | nvarchar(200) |
| 9 | Add. Fee Calculation Type | Add. Fee Calculation Type | Normal | Option | 4 | Add_ Fee Calculation Type | int |
Available options are:
| |||||||
| 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 querySELECT
[Reminder Level].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Reminder Level$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reminder Level]
LEFT JOIN
[User] AS [User]
ON
[Reminder Level].[$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 querySELECT
[Reminder Level].[$systemModifiedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Reminder Level$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reminder Level]
LEFT JOIN
[User] AS [User]
ON
[Reminder Level].[$systemModifiedBy] = [User].[User Security ID] | |||||||