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: 3903

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
   [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 an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Retention Policy Allowed Table$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Retention Policy Allowed Table]
LEFT JOIN
   [CRONUS UK Ltd_$Data Exch_ Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch. Mapping]
      ON
         [Retention Policy Allowed Table].[Table ID] = [Data Exch. Mapping].[Table ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Retention Policy Allowed Table].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Retention Policy Allowed Table].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Retention Policy Allowed Table table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Table Id Primary Key SearchTable IdNormalInteger4Table Idint
Key to join to the Data Exch. Mapping table.

Show/hide example query

SELECT
       [Retention Policy Allowed Table].[Table Id]
       ,[Data Exch. Mapping].[Table ID]
FROM
       [CRONUS UK Ltd_$Retention Policy Allowed Table$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Retention Policy Allowed Table]
LEFT JOIN
       [CRONUS UK Ltd_$Data Exch_ Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch. Mapping]
              ON
                     [Retention Policy Allowed Table].[Table Id] = [Data Exch. Mapping].[Table ID]
2Default Date Field No. SearchDefault Date Field No.NormalInteger4Default Date Field No_int
10Mandatory Min. Reten. Days SearchMandatory Min. Reten. DaysNormalInteger4Mandatory Min_ Reten_ Daysint
20Reten. Pol. Filtering SearchReten. Pol. Filtering NormalOption4Reten_ Pol_ Filtering int
Available options are:
  • “Default”
  • “Document Archive Filtering”
30Reten. Pol. Deleting SearchReten. Pol. DeletingNormalOption4Reten_ Pol_ Deletingint
Available options are:
  • “Default”
100Table Filters SearchTable FiltersNormalBLOB8Table Filtersimage
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Retention Policy Allowed Table].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Retention Policy Allowed Table$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Retention Policy Allowed Table]
LEFT JOIN
       [User] AS [User]
              ON
                     [Retention Policy Allowed Table].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Retention Policy Allowed Table].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Retention Policy Allowed Table$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Retention Policy Allowed Table]
LEFT JOIN
       [User] AS [User]
              ON
                     [Retention Policy Allowed Table].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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