Country_Region

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

Table Type: Company

Table Name: Country_Region
Database Table Name: CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 0

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 Country_Region can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Code]
   ,[Name]
   ,[ISO Code]
   ,[ISO Numeric Code]
   ,[EU Country_Region Code]
   ,[Intrastat Code]
   ,[Address Format]
   ,[Contact Address Format]
   ,[VAT Scheme]
   ,[Last Modified Date Time]
   ,[County Name]
   ,[Id]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Country_Region table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Code Primary Key Searchnvarchar(20)
3Name Searchnvarchar(100)
4ISO Code Searchnvarchar(4)
5ISO Numeric Code Searchnvarchar(6)
6EU Country_Region Code Searchnvarchar(20)
7Intrastat Code Searchnvarchar(20)
8Address Format Searchint
9Contact Address Format Searchint
10VAT Scheme Searchnvarchar(20)
11Last Modified Date Time Searchdatetime
12County Name Searchnvarchar(60)
13Id Searchuniqueidentifier
14$systemId Searchuniqueidentifier
15$systemCreatedAt Searchdatetime
16$systemCreatedBy Searchuniqueidentifier
17$systemModifiedAt Searchdatetime
18$systemModifiedBy Searchuniqueidentifier

Show/hide tables related to Country_Region table

Leave a Reply

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