Membership Entitlement

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

Table Type: System

Table Name: Membership Entitlement
Database Table Name: Membership Entitlement

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [Membership Entitlement]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Type]
   ,[ID]
   ,[Entitlement Set ID]
   ,[Name]
   ,[Is Evaluation]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [Membership Entitlement]

Show/hide columns in Membership Entitlement table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Type Primary Key Searchint
3ID Primary Key Searchnvarchar(500)
4Entitlement Set ID Primary Key Searchnvarchar(40)
5Name Searchnvarchar(500)
6Is Evaluation Searchtinyint
7$systemId Searchuniqueidentifier
8$systemCreatedAt Searchdatetime
9$systemCreatedBy Searchuniqueidentifier
10$systemModifiedAt Searchdatetime
11$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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