OData Edm Type

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

Table Type: System

Table Name: OData Edm Type
Database Table Name: OData Edm Type

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [OData Edm Type]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Key]
   ,[Description]
   ,[Edm Xml]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [OData Edm Type]

Show/hide columns in OData Edm Type table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Key Primary Key Searchnvarchar(100)
3Description Searchnvarchar(500)
4Edm Xml Searchimage
5$systemId Searchuniqueidentifier
6$systemCreatedAt Searchdatetime
7$systemCreatedBy Searchuniqueidentifier
8$systemModifiedAt Searchdatetime
9$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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