Config. Setup

Dynamics 365 BC Table ReferenceTablesCompany TablesCConfig. 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

   [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_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Config. Setup].[City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Config. Setup].[Ship-to City] = [Post Code].[City]
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_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Config. Setup].[Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Config. Setup].[Ship-to Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$SWIFT Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [SWIFT Code]
      ON
         [Config. Setup].[SWIFT Code] = [SWIFT Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
      ON
         [Config. Setup].[Responsibility Center] = [Responsibility Center].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Base Calendar$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Base Calendar]
      ON
         [Config. Setup].[Base Calendar Code] = [Base Calendar].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Config_ Package$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Config. Package]
      ON
         [Config. Setup].[Package Code] = [Config. Package].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [Config. Setup].[Language ID] = [Language].[Windows Language ID]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Config. Setup].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Config. Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Config. Setup].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Config. Setup table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Primary Key Primary Key SearchPrimary KeyNormalCode10Primary Keynvarchar(20)
2Name SearchNameNormalText100Namenvarchar(200)
3Name 2 SearchName 2NormalText50Name 2nvarchar(100)
4Address SearchAddressNormalText100Addressnvarchar(200)
5Address 2 SearchAddress 2NormalText50Address 2nvarchar(100)
6City SearchCityNormalText30Citynvarchar(60)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Config. Setup].[City]
       ,[Post Code].[City]
FROM
       [CRONUS UK Ltd_$Config_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Config. Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Config. Setup].[City] = [Post Code].[City]
7Phone No. SearchPhone No.NormalText30Phone No_nvarchar(60)
8Phone No. 2 SearchPhone No. 2NormalText30Phone No_ 2nvarchar(60)
9Telex No. SearchTelex No.NormalText30Telex No_nvarchar(60)
10Fax No. SearchFax No.NormalText30Fax No_nvarchar(60)
11Giro No. SearchGiro No.NormalText20Giro No_nvarchar(40)
12Bank Name SearchBank NameNormalText100Bank Namenvarchar(200)
13Bank Branch No. SearchBank Branch No.NormalText20Bank Branch No_nvarchar(40)
14Bank Account No. SearchBank Account No.NormalText30Bank Account No_nvarchar(60)
Key to join to the Bank Account table.

Show/hide example query

SELECT
       [Config. Setup].[Bank Account No_]
       ,[Bank Account].[No_]
FROM
       [CRONUS UK Ltd_$Config_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Config. Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account]
              ON
                     [Config. Setup].[Bank Account No_] = [Bank Account].[No_]
15Payment Routing No. SearchPayment Routing No.NormalText20Payment Routing No_nvarchar(40)
17Customs Permit No. SearchCustoms Permit No.NormalText10Customs Permit No_nvarchar(20)
18Customs Permit Date SearchCustoms Permit DateNormalDate4Customs Permit Datedatetime
19VAT Registration No. SearchTax Registration No.NormalText20VAT Registration No_nvarchar(40)
20Registration No. SearchRegistration No.NormalText20Registration No_nvarchar(40)
21Telex Answer Back SearchTelex Answer BackNormalText20Telex Answer Backnvarchar(40)
22Ship-to Name SearchShip-to NameNormalText100Ship-to Namenvarchar(200)
23Ship-to Name 2 SearchShip-to Name 2NormalText50Ship-to Name 2nvarchar(100)
24Ship-to Address SearchShip-to AddressNormalText100Ship-to Addressnvarchar(200)
25Ship-to Address 2 SearchShip-to Address 2NormalText50Ship-to Address 2nvarchar(100)
26Ship-to City SearchShip-to CityNormalText30Ship-to Citynvarchar(60)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Config. Setup].[Ship-to City]
       ,[Post Code].[City]
FROM
       [CRONUS UK Ltd_$Config_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Config. Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Config. Setup].[Ship-to City] = [Post Code].[City]
27Ship-to Contact SearchShip-to ContactNormalText100Ship-to Contactnvarchar(200)
28Location Code SearchLocation CodeNormalCode10Location Codenvarchar(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 SearchPictureNormalBLOB8Pictureimage
30Post Code SearchZIP CodeNormalCode20Post Codenvarchar(40)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Config. Setup].[Post Code]
       ,[Post Code].[Code]
FROM
       [CRONUS UK Ltd_$Config_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Config. Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Config. Setup].[Post Code] = [Post Code].[Code]
31County SearchStateNormalText30Countynvarchar(60)
32Ship-to Post Code SearchShip-to ZIP CodeNormalCode20Ship-to Post Codenvarchar(40)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Config. Setup].[Ship-to Post Code]
       ,[Post Code].[Code]
FROM
       [CRONUS UK Ltd_$Config_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Config. Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Config. Setup].[Ship-to Post Code] = [Post Code].[Code]
33Ship-to County SearchShip-to StateNormalText30Ship-to Countynvarchar(60)
34E-Mail SearchEmailNormalText80E-Mailnvarchar(160)
35Home Page SearchHome PageNormalText80Home Pagenvarchar(160)
36Country/Region Code SearchCountry/Region CodeNormalCode10Country_Region Codenvarchar(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 SearchShip-to Country/Region CodeNormalCode10Ship-to Country_Region Codenvarchar(20)
Key to join to the Country/Region table.

Show/hide example query

SELECT
       [Config. Setup].[Ship-to 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].[Ship-to Country_Region Code] = [Country/Region].[Code]
38IBAN SearchIBANNormalCode50IBANnvarchar(100)
39SWIFT Code SearchSWIFT CodeNormalCode20SWIFT Codenvarchar(40)
Key to join to the SWIFT Code table.

Show/hide example query

SELECT
       [Config. Setup].[SWIFT Code]
       ,[SWIFT Code].[Code]
FROM
       [CRONUS UK Ltd_$Config_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Config. Setup]
LEFT JOIN
       [CRONUS UK Ltd_$SWIFT Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [SWIFT Code]
              ON
                     [Config. Setup].[SWIFT Code] = [SWIFT Code].[Code]
40Industrial Classification SearchIndustrial ClassificationNormalText30Industrial Classificationnvarchar(60)
500Logo Position on Documents SearchLogo Position on DocumentsNormalOption4Logo Position on Documentsint
Available options are:
  • “No Logo”
  • “Left”
  • “Center”
  • “Right”
5700Responsibility Center SearchResponsibility CenterNormalCode10Responsibility Centernvarchar(20)
Key to join to the Responsibility Center table.

Show/hide example query

SELECT
       [Config. Setup].[Responsibility Center]
       ,[Responsibility Center].[Code]
FROM
       [CRONUS UK Ltd_$Config_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Config. Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
              ON
                     [Config. Setup].[Responsibility Center] = [Responsibility Center].[Code]
5791Check-Avail. Period Calc. SearchCheck-Avail. Period Calc.NormalDateFormula32Check-Avail_ Period Calc_varchar(32)
5792Check-Avail. Time Bucket SearchCheck-Avail. Time BucketNormalOption4Check-Avail_ Time Bucketint
Available options are:
  • “Day”
  • “Week”
  • “Month”
  • “Quarter”
  • “Year”
7600Base Calendar Code SearchBase Calendar CodeNormalCode10Base Calendar Codenvarchar(20)
Key to join to the Base Calendar table.

Show/hide example query

SELECT
       [Config. Setup].[Base Calendar Code]
       ,[Base Calendar].[Code]
FROM
       [CRONUS UK Ltd_$Config_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Config. Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Base Calendar$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Base Calendar]
              ON
                     [Config. Setup].[Base Calendar Code] = [Base Calendar].[Code]
7601Cal. Convergence Time Frame SearchCal. Convergence Time FrameNormalDateFormula32Cal_ Convergence Time Framevarchar(32)
8600Package File Name SearchPackage File NameNormalText250Package File Namenvarchar(500)
8601Package Code SearchPackage CodeNormalCode20Package Codenvarchar(40)
Key to join to the Config. Package table.

Show/hide example query

SELECT
       [Config. Setup].[Package Code]
       ,[Config. Package].[Code]
FROM
       [CRONUS UK Ltd_$Config_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Config. Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Config_ Package$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Config. Package]
              ON
                     [Config. Setup].[Package Code] = [Config. Package].[Code]
8602Language ID SearchLanguage IDNormalInteger4Language IDint
Key to join to the Language table.

Show/hide example query

SELECT
       [Config. Setup].[Language ID]
       ,[Language].[Windows Language ID]
FROM
       [CRONUS UK Ltd_$Config_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Config. Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
              ON
                     [Config. Setup].[Language ID] = [Language].[Windows Language ID]
8603Product Version SearchProduct VersionNormalText80Product Versionnvarchar(160)
8604Package Name SearchPackage NameNormalText50Package Namenvarchar(100)
8605Your Profile Code SearchYour Profile CodeNormalCode30Your Profile Codenvarchar(60)
8606Your Profile App ID SearchYour Profile App IDNormalGUID16Your Profile App IDuniqueidentifier
8607Your Profile Scope SearchYour Profile ScopeNormalOption4Your Profile Scopeint
Available options are:
  • “System”
  • “Tenant”
8608Package File SearchPackage FileNormalBLOB8Package Fileimage
10010Tax Area Code SearchTax Area CodeNormalCode20
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
       [Config. Setup].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Config_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Config. Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [Config. 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
       [Config. Setup].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Config_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Config. Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [Config. Setup].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Config. Setup table

LocationPost CodeResponsibility CenterTax Area
Dynamics 365 BC Table ReferenceTablesCompany TablesCConfig. Setup

Leave a Reply

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