Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/7309
Table Type: Company
Table Name: Warehouse Journal Template
Database Table Name: CRONUS UK Ltd_$Warehouse Journal Template$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 Warehouse Journal Template can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Warehouse Journal Template$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[Name]
,[Description]
,[Test Report ID]
,[Page ID]
,[Registering Report ID]
,[Force Registering Report]
,[Type]
,[Source Code]
,[Reason Code]
,[No_ Series]
,[Registering No_ Series]
,[Increment Batch Name]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Warehouse Journal Template$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$Warehouse Journal Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Journal Template]
LEFT JOIN
[CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
ON
[Warehouse Journal Template].[Source Code] = [Source Code].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
ON
[Warehouse Journal Template].[Reason Code] = [Reason Code].[Code]
LEFT JOIN
[User] AS [User]
ON
[Warehouse Journal Template].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Warehouse Journal Template].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in Warehouse Journal Template table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Name   | Name | Normal | Code | 10 | Name | nvarchar(20) |
| 2 | Description | Description | Normal | Text | 80 | Description | nvarchar(160) |
| 5 | Test Report ID | Test Report ID | Normal | Integer | 4 | Test Report ID | int |
| 6 | Page ID | Page ID | Normal | Integer | 4 | Page ID | int |
| 7 | Registering Report ID | Registering Report ID | Normal | Integer | 4 | Registering Report ID | int |
| 8 | Force Registering Report | Force Registering Report | Normal | Boolean | 4 | Force Registering Report | tinyint |
| 9 | Type | Type | Normal | Option | 4 | Type | int |
Available options are:
| |||||||
| 10 | Source Code | Source Code | Normal | Code | 10 | Source Code | nvarchar(20) |
Key to join to the Source Code table.Show/hide example querySELECT
[Warehouse Journal Template].[Source Code]
,[Source Code].[Code]
FROM
[CRONUS UK Ltd_$Warehouse Journal Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Journal Template]
LEFT JOIN
[CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
ON
[Warehouse Journal Template].[Source Code] = [Source Code].[Code] | |||||||
| 11 | Reason Code | Reason Code | Normal | Code | 10 | Reason Code | nvarchar(20) |
Key to join to the Reason Code table.Show/hide example querySELECT
[Warehouse Journal Template].[Reason Code]
,[Reason Code].[Code]
FROM
[CRONUS UK Ltd_$Warehouse Journal Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Journal Template]
LEFT JOIN
[CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
ON
[Warehouse Journal Template].[Reason Code] = [Reason Code].[Code] | |||||||
| 15 | Test Report Caption | Test Report Caption | FlowField | Text | 250 | ||
| 16 | Page Caption | Page Caption | FlowField | Text | 250 | ||
| 17 | Registering Report Caption | Registering Report Caption | FlowField | Text | 250 | ||
| 19 | No. Series | No. Series | Normal | Code | 20 | No_ Series | nvarchar(40) |
Key to join to the No. Series table.Show/hide example querySELECT
[Warehouse Journal Template].[No_ Series]
,[No. Series].[Code]
FROM
[CRONUS UK Ltd_$Warehouse Journal Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Journal Template]
LEFT JOIN
[CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
ON
[Warehouse Journal Template].[No_ Series] = [No. Series].[Code] | |||||||
| 20 | Registering No. Series | Registering No. Series | Normal | Code | 20 | Registering No_ Series | nvarchar(40) |
Key to join to the No. Series table.Show/hide example querySELECT
[Warehouse Journal Template].[Registering No_ Series]
,[No. Series].[Code]
FROM
[CRONUS UK Ltd_$Warehouse Journal Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Journal Template]
LEFT JOIN
[CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
ON
[Warehouse Journal Template].[Registering No_ Series] = [No. Series].[Code] | |||||||
| 30 | Increment Batch Name | Increment Batch Name | Normal | Boolean | 4 | Increment Batch Name | tinyint |
| 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
[Warehouse Journal Template].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Warehouse Journal Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Journal Template]
LEFT JOIN
[User] AS [User]
ON
[Warehouse Journal Template].[$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
[Warehouse Journal Template].[$systemModifiedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Warehouse Journal Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Journal Template]
LEFT JOIN
[User] AS [User]
ON
[Warehouse Journal Template].[$systemModifiedBy] = [User].[User Security ID] | |||||||