Email Printer Settings

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/2650

Table Type: Company

Table Name: Email Printer Settings
Database Table Name: CRONUS UK Ltd_$Email Printer Settings$8c972578-fe72-4aa5-ae51-cc5575fef2ea

Table Number: 2650

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 Email Printer Settings can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Email Printer Settings$8c972578-fe72-4aa5-ae51-cc5575fef2ea]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[ID]
   ,[Description]
   ,[Email Address]
   ,[Email Subject]
   ,[Email Body]
   ,[Paper Size]
   ,[Paper Height]
   ,[Paper Width]
   ,[Paper Unit]
   ,[Landscape]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Email Printer Settings$8c972578-fe72-4aa5-ae51-cc5575fef2ea]

Show/hide columns in Email Printer Settings table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2ID Primary Key Searchnvarchar(500)
3Description Searchnvarchar(500)
4Email Address Searchnvarchar(500)
5Email Subject Searchnvarchar(500)
6Email Body Searchnvarchar(4096)
7Paper Size Searchint
8Paper Height Searchdecimal(38,38)
9Paper Width Searchdecimal(38,38)
10Paper Unit Searchint
11Landscape Searchtinyint
12$systemId Searchuniqueidentifier
13$systemCreatedAt Searchdatetime
14$systemCreatedBy Searchuniqueidentifier
15$systemModifiedAt Searchdatetime
16$systemModifiedBy Searchuniqueidentifier

Leave a Reply

Your email address will not be published. Required fields are marked *