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
   [timestamp]
   ,[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 columns in Curr_ Exch_ Rate Update Setup table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Code Primary Key Searchnvarchar(40)
3Description Searchnvarchar(500)
4Web Service URL Searchimage
5Enabled Searchtinyint
6Service Provider Searchnvarchar(60)
7Terms of Service Searchnvarchar(500)
8Data Exch_ Def Code Searchnvarchar(40)
9Log Web Requests Searchtinyint
10$systemId Searchuniqueidentifier
11$systemCreatedAt Searchdatetime
12$systemCreatedBy Searchuniqueidentifier
13$systemModifiedAt Searchdatetime
14$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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