Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/409
Table Type: Company
Table Name: SMTP Mail Setup
Database Table Name: CRONUS UK Ltd_$SMTP Mail Setup$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 SMTP Mail Setup can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$SMTP Mail Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[Primary Key]
,[SMTP Server]
,[Authentication]
,[User ID]
,[SMTP Server Port]
,[Secure Connection]
,[Password Key]
,[Send As]
,[Allow Sender Substitution]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$SMTP Mail Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$SMTP Mail Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [SMTP Mail Setup]
LEFT JOIN
[User] AS [User]
ON
[SMTP Mail Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[SMTP Mail Setup].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in SMTP Mail Setup table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Primary Key  | Primary Key | Normal | Code | 10 | Primary Key | nvarchar(20) |
| 2 | SMTP Server  | SMTP Server | Normal | Text | 250 | SMTP Server | nvarchar(500) |
| 3 | Authentication | Authentication | Normal | Option | 4 | Authentication | int |
Available options are:
| |||||||
| 4 | User ID | User ID | Normal | Text | 250 | User ID | nvarchar(500) |
| 6 | SMTP Server Port | SMTP Server Port | Normal | Integer | 4 | SMTP Server Port | int |
| 7 | Secure Connection | Secure Connection | Normal | Boolean | 4 | Secure Connection | tinyint |
| 8 | Password Key | Password Key | Normal | GUID | 16 | Password Key | uniqueidentifier |
| 9 | Send As | Send As | Normal | Text | 250 | Send As | nvarchar(500) |
| 10 | Allow Sender Substitution | Allow Sender Substitution | Normal | Boolean | 4 | Allow Sender Substitution | 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 [SMTP Mail Setup].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$SMTP Mail Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [SMTP Mail Setup] LEFT JOIN [User] AS [User] ON [SMTP Mail Setup].[$systemCreatedBy] = [User].[User Security ID] | |||||||
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |