Config_ Setup – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables CConfig_ 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 ID	Column Name	Data Type
1	timestamp	timestamp
2	Primary Key	nvarchar(20)
3	Name	nvarchar(200)
4	Name 2	nvarchar(100)
5	Address	nvarchar(200)
6	Address 2	nvarchar(100)
7	City	nvarchar(60)
8	Phone No_	nvarchar(60)
9	Phone No_ 2	nvarchar(60)
10	Telex No_	nvarchar(60)
11	Fax No_	nvarchar(60)
12	Giro No_	nvarchar(40)
13	Bank Name	nvarchar(200)
14	Bank Branch No_	nvarchar(40)
15	Bank Account No_	nvarchar(60)
16	Payment Routing No_	nvarchar(40)
17	Customs Permit No_	nvarchar(20)
18	Customs Permit Date	datetime
19	VAT Registration No_	nvarchar(40)
20	Registration No_	nvarchar(40)
21	Telex Answer Back	nvarchar(40)
22	Ship-to Name	nvarchar(200)
23	Ship-to Name 2	nvarchar(100)
24	Ship-to Address	nvarchar(200)
25	Ship-to Address 2	nvarchar(100)
26	Ship-to City	nvarchar(60)
27	Ship-to Contact	nvarchar(200)
28	Location Code	nvarchar(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]
29	Picture	image
30	Post Code	nvarchar(40)
31	County	nvarchar(60)
32	Ship-to Post Code	nvarchar(40)
33	Ship-to County	nvarchar(60)
34	E-Mail	nvarchar(160)
35	Home Page	nvarchar(160)
36	Country_Region Code	nvarchar(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]
37	Ship-to Country_Region Code	nvarchar(20)
38	IBAN	nvarchar(100)
39	SWIFT Code	nvarchar(40)
40	Industrial Classification	nvarchar(60)
41	Logo Position on Documents	int
42	Responsibility Center	nvarchar(20)
43	Check-Avail_ Period Calc_	varchar(32)
44	Check-Avail_ Time Bucket	int
45	Base Calendar Code	nvarchar(20)
46	Cal_ Convergence Time Frame	varchar(32)
47	Package File Name	nvarchar(500)
48	Package Code	nvarchar(40)
49	Language ID	int
50	Product Version	nvarchar(160)
51	Package Name	nvarchar(100)
52	Your Profile Code	nvarchar(60)
53	Your Profile App ID	uniqueidentifier
54	Your Profile Scope	int
55	Package File	image
56	$systemId	uniqueidentifier
57	$systemCreatedAt	datetime
58	$systemCreatedBy	uniqueidentifier
59	$systemModifiedAt	datetime
60	$systemModifiedBy	uniqueidentifier