Media

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

Table Type: System

Table Name: Media
Database Table Name: 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 Media can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [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
   [Media]

Show/hide columns in 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 *