Tenant Media

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

Table Type: System

Table Name: Tenant Media
Database Table Name: Tenant Media

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [Tenant Media]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[ID]
   ,[Description]
   ,[Content]
   ,[Mime Type]
   ,[Height]
   ,[Width]
   ,[Company Name]
   ,[Expiration Date]
   ,[Prohibit Cache]
   ,[File Name]
   ,[Security Token]
   ,[Creating User]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [Tenant Media]

Show/hide columns in Tenant Media table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2ID Primary Key Searchuniqueidentifier
3Description Searchnvarchar(500)
4Content Searchimage
5Mime Type Searchnvarchar(200)
6Height Searchint
7Width Searchint
8Company Name Searchnvarchar(60)
9Expiration Date Searchdatetime
10Prohibit Cache Searchtinyint
11File Name Searchnvarchar(500)
12Security Token Searchnvarchar(200)
13Creating User Searchnvarchar(100)
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 *