Curr. Exch. Rate Update Setup

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

Table Type: Company

Table Name: Curr. Exch. Rate Update Setup
Database Table Name: CRONUS UK Ltd_$Curr_ Exch_ Rate Update Setup$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 1650

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 Curr. Exch. Rate Update Setup can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Curr_ Exch_ Rate Update Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [Code]
   ,[Description]
   ,[Web Service URL]
   ,[Enabled]
   ,[Service Provider]
   ,[Terms of Service]
   ,[Data Exch_ Def Code]
   ,[Log Web Requests]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Curr_ Exch_ Rate Update Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Curr_ Exch_ Rate Update Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Curr. Exch. Rate Update Setup]
LEFT JOIN
   [User] AS [User]
      ON
         [Curr. Exch. Rate Update Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Curr. Exch. Rate Update Setup].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Curr. Exch. Rate Update Setup table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Code Primary Key SearchCodeNormalCode20Codenvarchar(40)
2Description SearchDescriptionNormalText250Descriptionnvarchar(500)
3Web Service URL SearchService URLNormalBLOB8Web Service URLimage
5Enabled SearchEnabledNormalBoolean4Enabledtinyint
10Service Provider SearchService ProviderNormalText30Service Providernvarchar(60)
11Terms of Service SearchTerms of ServiceNormalText250Terms of Servicenvarchar(500)
20Data Exch. Def Code SearchData Exch. Def CodeNormalCode20Data Exch_ Def Codenvarchar(40)
Key to join to the Data Exch. Def table.

Show/hide example query

SELECT
       [Curr. Exch. Rate Update Setup].[Data Exch_ Def Code]
       ,[Data Exch. Def].[Code]
FROM
       [CRONUS UK Ltd_$Curr_ Exch_ Rate Update Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Curr. Exch. Rate Update Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Data Exch_ Def$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch. Def]
              ON
                     [Curr. Exch. Rate Update Setup].[Data Exch_ Def Code] = [Data Exch. Def].[Code]
21Log Web Requests SearchLog Web RequestsNormalBoolean4Log Web Requeststinyint
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
       [Curr. Exch. Rate Update Setup].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Curr_ Exch_ Rate Update Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Curr. Exch. Rate Update Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [Curr. Exch. Rate Update Setup].[$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
       [Curr. Exch. Rate Update Setup].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Curr_ Exch_ Rate Update Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Curr. Exch. Rate Update Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [Curr. Exch. Rate Update Setup].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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