Retention Policy Allowed Table

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

Table Type: Company

Table Name: Retention Policy Allowed Table
Database Table Name: CRONUS UK Ltd_$Retention Policy Allowed Table$63ca2fa4-4f03-4f2b-a480-172fef340d3f

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 Retention Policy Allowed Table can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Retention Policy Allowed Table$63ca2fa4-4f03-4f2b-a480-172fef340d3f]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Table Id]
   ,[Default Date Field No_]
   ,[Mandatory Min_ Reten_ Days]
   ,[Reten_ Pol_ Filtering ]
   ,[Reten_ Pol_ Deleting]
   ,[Table Filters]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Retention Policy Allowed Table$63ca2fa4-4f03-4f2b-a480-172fef340d3f]

Show/hide columns in Retention Policy Allowed Table table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Table Id Primary Key Searchint
3Default Date Field No_ Searchint
4Mandatory Min_ Reten_ Days Searchint
5Reten_ Pol_ Filtering Searchint
6Reten_ Pol_ Deleting Searchint
7Table Filters Searchimage
8$systemId Searchuniqueidentifier
9$systemCreatedAt Searchdatetime
10$systemCreatedBy Searchuniqueidentifier
11$systemModifiedAt Searchdatetime
12$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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