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
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 ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | Table Id  | int |
| 3 | Default Date Field No_ | int |
| 4 | Mandatory Min_ Reten_ Days | int |
| 5 | Reten_ Pol_ Filtering | int |
| 6 | Reten_ Pol_ Deleting | int |
| 7 | Table Filters | image |
| 8 | $systemId | uniqueidentifier |
| 9 | $systemCreatedAt | datetime |
| 10 | $systemCreatedBy | uniqueidentifier |
| 11 | $systemModifiedAt | datetime |
| 12 | $systemModifiedBy | uniqueidentifier |