Universal Printer Settings

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

Table Type: Company

Table Name: Universal Printer Settings
Database Table Name: CRONUS UK Ltd_$Universal Printer Settings$2654d7e7-9afd-4947-9e02-6bb8f3e0cd04

Table Number: 2751

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Universal Printer Settings$2654d7e7-9afd-4947-9e02-6bb8f3e0cd04]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Name]
   ,[Print Share ID]
   ,[Print Share Name]
   ,[Description]
   ,[Paper Size]
   ,[Paper Height]
   ,[Paper Width]
   ,[Paper Unit]
   ,[Landscape]
   ,[AllowAllUsers]
   ,[outputBin]
   ,[Paper Tray]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Universal Printer Settings$2654d7e7-9afd-4947-9e02-6bb8f3e0cd04]

Show/hide columns in Universal Printer Settings table

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

Leave a Reply

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