Terms And Conditions State

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

Table Type: System

Table Name: Terms And Conditions State
Database Table Name:

Table Number: 9191

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 Terms And Conditions State can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   []

Show/hide an example select of all columns by name

SELECT

FROM
   []

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [] AS [Terms And Conditions State]
LEFT JOIN
   [User] AS [User]
      ON
         [Terms And Conditions State].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Terms And Conditions State].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Terms And Conditions State table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Terms And Conditions Code Primary Key SearchTerms And Conditions CodeNormalCode20
2User ID Primary Key SearchUser IDNormalCode50
3Accepted SearchAcceptedNormalBoolean4
4Date Accepted SearchDate AcceptedNormalDateTime8
2000000000$systemId SearchSystem IDNormalGUID16
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8
2000000002SystemCreatedBy SearchCreated ByNormalGUID16
2000000003SystemModifiedAt SearchModified AtNormalDateTime8
2000000004SystemModifiedBy SearchModified ByNormalGUID16

Leave a Reply

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