Config_ Setup

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

Table Type: Company

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

Table Number: 8627

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Primary Key]
   ,[Name]
   ,[Name 2]
   ,[Address]
   ,[Address 2]
   ,[City]
   ,[Phone No_]
   ,[Phone No_ 2]
   ,[Telex No_]
   ,[Fax No_]
   ,[Giro No_]
   ,[Bank Name]
   ,[Bank Branch No_]
   ,[Bank Account No_]
   ,[Payment Routing No_]
   ,[Customs Permit No_]
   ,[Customs Permit Date]
   ,[VAT Registration No_]
   ,[Registration No_]
   ,[Telex Answer Back]
   ,[Ship-to Name]
   ,[Ship-to Name 2]
   ,[Ship-to Address]
   ,[Ship-to Address 2]
   ,[Ship-to City]
   ,[Ship-to Contact]
   ,[Location Code]
   ,[Picture]
   ,[Post Code]
   ,[County]
   ,[Ship-to Post Code]
   ,[Ship-to County]
   ,[E-Mail]
   ,[Home Page]
   ,[Country_Region Code]
   ,[Ship-to Country_Region Code]
   ,[IBAN]
   ,[SWIFT Code]
   ,[Industrial Classification]
   ,[Logo Position on Documents]
   ,[Responsibility Center]
   ,[Check-Avail_ Period Calc_]
   ,[Check-Avail_ Time Bucket]
   ,[Base Calendar Code]
   ,[Cal_ Convergence Time Frame]
   ,[Package File Name]
   ,[Package Code]
   ,[Language ID]
   ,[Product Version]
   ,[Package Name]
   ,[Your Profile Code]
   ,[Your Profile App ID]
   ,[Your Profile Scope]
   ,[Package File]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Config_ 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_$Config_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Config_ Setup]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Config_ Setup].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
      ON
         [Config_ Setup].[Country_Region Code] = [Country_Region].[Code]

Show/hide columns in Config_ Setup table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Primary Key Primary Key Searchnvarchar(20)
3Name Searchnvarchar(200)
4Name 2 Searchnvarchar(100)
5Address Searchnvarchar(200)
6Address 2 Searchnvarchar(100)
7City Searchnvarchar(60)
8Phone No_ Searchnvarchar(60)
9Phone No_ 2 Searchnvarchar(60)
10Telex No_ Searchnvarchar(60)
11Fax No_ Searchnvarchar(60)
12Giro No_ Searchnvarchar(40)
13Bank Name Searchnvarchar(200)
14Bank Branch No_ Searchnvarchar(40)
15Bank Account No_ Searchnvarchar(60)
16Payment Routing No_ Searchnvarchar(40)
17Customs Permit No_ Searchnvarchar(20)
18Customs Permit Date Searchdatetime
19VAT Registration No_ Searchnvarchar(40)
20Registration No_ Searchnvarchar(40)
21Telex Answer Back Searchnvarchar(40)
22Ship-to Name Searchnvarchar(200)
23Ship-to Name 2 Searchnvarchar(100)
24Ship-to Address Searchnvarchar(200)
25Ship-to Address 2 Searchnvarchar(100)
26Ship-to City Searchnvarchar(60)
27Ship-to Contact Searchnvarchar(200)
28Location Code Searchnvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Config_ Setup].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Config_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Config_ Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Config_ Setup].[Location Code] = [Location].[Code]
29Picture Searchimage
30Post Code Searchnvarchar(40)
31County Searchnvarchar(60)
32Ship-to Post Code Searchnvarchar(40)
33Ship-to County Searchnvarchar(60)
34E-Mail Searchnvarchar(160)
35Home Page Searchnvarchar(160)
36Country_Region Code Searchnvarchar(20)
Key to join to the Country_Region table.

Show/hide example query

SELECT
       [Config_ Setup].[Country_Region Code]
       ,[Country_Region].[Code]
FROM
       [CRONUS UK Ltd_$Config_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Config_ Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
              ON
                     [Config_ Setup].[Country_Region Code] = [Country_Region].[Code]
37Ship-to Country_Region Code Searchnvarchar(20)
38IBAN Searchnvarchar(100)
39SWIFT Code Searchnvarchar(40)
40Industrial Classification Searchnvarchar(60)
41Logo Position on Documents Searchint
42Responsibility Center Searchnvarchar(20)
43Check-Avail_ Period Calc_ Searchvarchar(32)
44Check-Avail_ Time Bucket Searchint
45Base Calendar Code Searchnvarchar(20)
46Cal_ Convergence Time Frame Searchvarchar(32)
47Package File Name Searchnvarchar(500)
48Package Code Searchnvarchar(40)
49Language ID Searchint
50Product Version Searchnvarchar(160)
51Package Name Searchnvarchar(100)
52Your Profile Code Searchnvarchar(60)
53Your Profile App ID Searchuniqueidentifier
54Your Profile Scope Searchint
55Package File Searchimage
56$systemId Searchuniqueidentifier
57$systemCreatedAt Searchdatetime
58$systemCreatedBy Searchuniqueidentifier
59$systemModifiedAt Searchdatetime
60$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Config_ Setup table

Leave a Reply

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