Tenant Media Thumbnails

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

Table Type: System

Table Name: Tenant Media Thumbnails
Database Table Name: Tenant Media Thumbnails

Table Number: 0

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 Tenant Media Thumbnails can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [Tenant Media Thumbnails]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[ID]
   ,[Media ID]
   ,[Content]
   ,[Mime Type]
   ,[Height]
   ,[Width]
   ,[Company Name]
   ,[Embedded]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [Tenant Media Thumbnails]

Show/hide columns in Tenant Media Thumbnails table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2ID Primary Key Searchuniqueidentifier
3Media ID Searchuniqueidentifier
4Content Searchimage
5Mime Type Searchnvarchar(200)
6Height Searchint
7Width Searchint
8Company Name Searchnvarchar(60)
9Embedded Searchtinyint
10$systemId Searchuniqueidentifier
11$systemCreatedAt Searchdatetime
12$systemCreatedBy Searchuniqueidentifier
13$systemModifiedAt Searchdatetime
14$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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