Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/357
Table Type: Company
Table Name: Gen. Jnl. Dim. Filter
Database Table Name: CRONUS UK Ltd_$Gen_ Jnl_ Dim_ Filter$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 Gen. Jnl. Dim. Filter can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Gen_ Jnl_ Dim_ Filter$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[Journal Template Name]
,[Journal Batch Name]
,[Journal Line No_]
,[Dimension Code]
,[Dimension Value Filter]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Gen_ Jnl_ Dim_ Filter$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$Gen_ Jnl_ Dim_ Filter$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Jnl. Dim. Filter]
LEFT JOIN
[User] AS [User]
ON
[Gen. Jnl. Dim. Filter].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Gen. Jnl. Dim. Filter].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in Gen. Jnl. Dim. Filter table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Journal Template Name  | Journal Template Name | Normal | Code | 10 | Journal Template Name | nvarchar(20) |
| 2 | Journal Batch Name  | Journal Batch Name | Normal | Code | 10 | Journal Batch Name | nvarchar(20) |
| 3 | Journal Line No. | Journal Line No. | Normal | Integer | 4 | Journal Line No_ | int |
| 4 | Dimension Code | Dimension Code | Normal | Code | 20 | Dimension Code | nvarchar(40) |
| 5 | Dimension Value Filter | Dimension Value Filter | Normal | Text | 250 | Dimension Value Filter | nvarchar(500) |
| 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 [Gen. Jnl. Dim. Filter].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Gen_ Jnl_ Dim_ Filter$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Jnl. Dim. Filter] LEFT JOIN [User] AS [User] ON [Gen. Jnl. Dim. Filter].[$systemCreatedBy] = [User].[User Security ID] | |||||||
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |