Company Information – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables CCompany Information

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

Table Type: Company

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

Table Number: 79

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Company Information$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]
   ,[IC Partner Code]
   ,[IC Inbox Type]
   ,[IC Inbox Details]
   ,[Auto_ Send Transactions]
   ,[Allow Blank Payment Info_]
   ,[Contact Person]
   ,[GLN]
   ,[EORI Number]
   ,[Use GLN in Electronic Document]
   ,[Picture - Last Mod_ Date Time]
   ,[Last Modified Date Time]
   ,[Created DateTime]
   ,[Demo Company]
   ,[Alternative Language Code]
   ,[Brand Color Value]
   ,[Brand Color Code]
   ,[Responsibility Center]
   ,[Check-Avail_ Period Calc_]
   ,[Check-Avail_ Time Bucket]
   ,[Base Calendar Code]
   ,[Cal_ Convergence Time Frame]
   ,[Cal_ Convergence Time Frame]
   ,[Show Chart On RoleCenter]
   ,[Sync with O365 Bus_ profile]
   ,[Id]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Company Information$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Company Information$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Company Information]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Company Information].[City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Company Information].[Ship-to City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Company Information].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Company Information].[Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Company Information].[Ship-to Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$SWIFT Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [SWIFT Code]
      ON
         [Company Information].[SWIFT Code] = [SWIFT Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
      ON
         [Company Information].[IC Partner Code] = [IC Partner].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [Company Information].[Alternative Language Code] = [Language].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$O365 Brand Color$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [O365 Brand Color]
      ON
         [Company Information].[Brand Color Code] = [O365 Brand Color].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
      ON
         [Company Information].[Responsibility Center] = [Responsibility Center].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Base Calendar$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Base Calendar]
      ON
         [Company Information].[Base Calendar Code] = [Base Calendar].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Company Information].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Company Information].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Company Information].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Company Information table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Primary Key	Primary Key	Normal	Code	10	Primary Key	nvarchar(20)
2	Name	Name	Normal	Text	100	Name	nvarchar(200)
3	Name 2	Name 2	Normal	Text	50	Name 2	nvarchar(100)
4	Address	Address	Normal	Text	100	Address	nvarchar(200)
5	Address 2	Address 2	Normal	Text	50	Address 2	nvarchar(100)
6	City	City	Normal	Text	30	City	nvarchar(60)
	Key to join to the Post Code table. Show/hide example query SELECT [Company Information].[City] ,[Post Code].[City] FROM [CRONUS UK Ltd_$Company Information$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Company Information] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [Company Information].[City] = [Post Code].[City]
7	Phone No.	Phone No.	Normal	Text	30	Phone No_	nvarchar(60)
8	Phone No. 2	Phone No. 2	Normal	Text	30	Phone No_ 2	nvarchar(60)
9	Telex No.	Telex No.	Normal	Text	30	Telex No_	nvarchar(60)
10	Fax No.	Fax No.	Normal	Text	30	Fax No_	nvarchar(60)
11	Giro No.	Giro No.	Normal	Text	20	Giro No_	nvarchar(40)
12	Bank Name	Bank Name	Normal	Text	100	Bank Name	nvarchar(200)
13	Bank Branch No.	Bank Branch No.	Normal	Text	20	Bank Branch No_	nvarchar(40)
14	Bank Account No.	Bank Account No.	Normal	Text	30	Bank Account No_	nvarchar(60)
	Key to join to the Bank Account table. Show/hide example query SELECT [Company Information].[Bank Account No_] ,[Bank Account].[No_] FROM [CRONUS UK Ltd_$Company Information$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Company Information] LEFT JOIN [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account] ON [Company Information].[Bank Account No_] = [Bank Account].[No_]
15	Payment Routing No.	Payment Routing No.	Normal	Text	20	Payment Routing No_	nvarchar(40)
17	Customs Permit No.	Customs Permit No.	Normal	Text	10	Customs Permit No_	nvarchar(20)
18	Customs Permit Date	Customs Permit Date	Normal	Date	4	Customs Permit Date	datetime
19	VAT Registration No.	Tax Registration No.	Normal	Text	20	VAT Registration No_	nvarchar(40)
20	Registration No.	Registration No.	Normal	Text	20	Registration No_	nvarchar(40)
21	Telex Answer Back	Telex Answer Back	Normal	Text	20	Telex Answer Back	nvarchar(40)
22	Ship-to Name	Ship-to Name	Normal	Text	100	Ship-to Name	nvarchar(200)
23	Ship-to Name 2	Ship-to Name 2	Normal	Text	50	Ship-to Name 2	nvarchar(100)
24	Ship-to Address	Ship-to Address	Normal	Text	100	Ship-to Address	nvarchar(200)
25	Ship-to Address 2	Ship-to Address 2	Normal	Text	50	Ship-to Address 2	nvarchar(100)
26	Ship-to City	Ship-to City	Normal	Text	30	Ship-to City	nvarchar(60)
	Key to join to the Post Code table. Show/hide example query SELECT [Company Information].[Ship-to City] ,[Post Code].[City] FROM [CRONUS UK Ltd_$Company Information$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Company Information] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [Company Information].[Ship-to City] = [Post Code].[City]
27	Ship-to Contact	Ship-to Contact	Normal	Text	100	Ship-to Contact	nvarchar(200)
28	Location Code	Location Code	Normal	Code	10	Location Code	nvarchar(20)
	Key to join to the Location table. Show/hide example query SELECT [Company Information].[Location Code] ,[Location].[Code] FROM [CRONUS UK Ltd_$Company Information$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Company Information] LEFT JOIN [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location] ON [Company Information].[Location Code] = [Location].[Code]
29	Picture	Picture	Normal	BLOB	8	Picture	image
30	Post Code	ZIP Code	Normal	Code	20	Post Code	nvarchar(40)
	Key to join to the Post Code table. Show/hide example query SELECT [Company Information].[Post Code] ,[Post Code].[Code] FROM [CRONUS UK Ltd_$Company Information$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Company Information] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [Company Information].[Post Code] = [Post Code].[Code]
31	County	State	Normal	Text	30	County	nvarchar(60)
32	Ship-to Post Code	Ship-to ZIP Code	Normal	Code	20	Ship-to Post Code	nvarchar(40)
	Key to join to the Post Code table. Show/hide example query SELECT [Company Information].[Ship-to Post Code] ,[Post Code].[Code] FROM [CRONUS UK Ltd_$Company Information$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Company Information] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [Company Information].[Ship-to Post Code] = [Post Code].[Code]
33	Ship-to County	Ship-to State	Normal	Text	30	Ship-to County	nvarchar(60)
34	E-Mail	Email	Normal	Text	80	E-Mail	nvarchar(160)
35	Home Page	Home Page	Normal	Text	80	Home Page	nvarchar(160)
36	Country/Region Code	Country/Region Code	Normal	Code	10	Country_Region Code	nvarchar(20)
	Key to join to the Country/Region table. Show/hide example query SELECT [Company Information].[Country_Region Code] ,[Country/Region].[Code] FROM [CRONUS UK Ltd_$Company Information$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Company Information] LEFT JOIN [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region] ON [Company Information].[Country_Region Code] = [Country/Region].[Code]
37	Ship-to Country/Region Code	Ship-to Country/Region Code	Normal	Code	10	Ship-to Country_Region Code	nvarchar(20)
	Key to join to the Country/Region table. Show/hide example query SELECT [Company Information].[Ship-to Country_Region Code] ,[Country/Region].[Code] FROM [CRONUS UK Ltd_$Company Information$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Company Information] LEFT JOIN [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region] ON [Company Information].[Ship-to Country_Region Code] = [Country/Region].[Code]
38	IBAN	IBAN	Normal	Code	50	IBAN	nvarchar(100)
39	SWIFT Code	SWIFT Code	Normal	Code	20	SWIFT Code	nvarchar(40)
	Key to join to the SWIFT Code table. Show/hide example query SELECT [Company Information].[SWIFT Code] ,[SWIFT Code].[Code] FROM [CRONUS UK Ltd_$Company Information$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Company Information] LEFT JOIN [CRONUS UK Ltd_$SWIFT Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [SWIFT Code] ON [Company Information].[SWIFT Code] = [SWIFT Code].[Code]
40	Industrial Classification	Industrial Classification	Normal	Text	30	Industrial Classification	nvarchar(60)
41	IC Partner Code	IC Partner Code	Normal	Code	20	IC Partner Code	nvarchar(40)
	Key to join to the IC Partner table. Show/hide example query SELECT [Company Information].[IC Partner Code] ,[IC Partner].[Code] FROM [CRONUS UK Ltd_$Company Information$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Company Information] LEFT JOIN [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner] ON [Company Information].[IC Partner Code] = [IC Partner].[Code]
42	IC Inbox Type	IC Inbox Type	Normal	Option	4	IC Inbox Type	int
	Available options are: “File Location” “Database”
43	IC Inbox Details	IC Inbox Details	Normal	Text	250	IC Inbox Details	nvarchar(500)
44	Auto. Send Transactions	Auto. Send Transactions	Normal	Boolean	4	Auto_ Send Transactions	tinyint
46	System Indicator	System Indicator	Normal	Option	4
47	Custom System Indicator Text	Custom System Indicator Text	Normal	Text	250
48	System Indicator Style	System Indicator Style	Normal	Option	4
50	Allow Blank Payment Info.	Allow Blank Payment Info.	Normal	Boolean	4	Allow Blank Payment Info_	tinyint
51	Contact Person	Contact Person	Normal	Text	50	Contact Person	nvarchar(100)
90	GLN	GLN	Normal	Code	13	GLN	nvarchar(26)
92	EORI Number	EORI Number	Normal	Text	40	EORI Number	nvarchar(80)
95	Use GLN in Electronic Document	Use GLN in Electronic Documents	Normal	Boolean	4	Use GLN in Electronic Document	tinyint
96	Picture – Last Mod. Date Time	Picture – Last Mod. Date Time	Normal	DateTime	8	Picture – Last Mod_ Date Time	datetime
98	Last Modified Date Time	Last Modified Date Time	Normal	DateTime	8	Last Modified Date Time	datetime
99	Created DateTime	Created DateTime	Normal	DateTime	8	Created DateTime	datetime
100	Demo Company	Demo Company	Normal	Boolean	4	Demo Company	tinyint
200	Alternative Language Code	Alternative Language Code	Normal	Code	10	Alternative Language Code	nvarchar(20)
	Key to join to the Language table. Show/hide example query SELECT [Company Information].[Alternative Language Code] ,[Language].[Code] FROM [CRONUS UK Ltd_$Company Information$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Company Information] LEFT JOIN [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language] ON [Company Information].[Alternative Language Code] = [Language].[Code]
300	Brand Color Value	Brand Color Value	Normal	Code	10	Brand Color Value	nvarchar(20)
301	Brand Color Code	Brand Color Code	Normal	Code	20	Brand Color Code	nvarchar(40)
	Key to join to the O365 Brand Color table. Show/hide example query SELECT [Company Information].[Brand Color Code] ,[O365 Brand Color].[Code] FROM [CRONUS UK Ltd_$Company Information$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Company Information] LEFT JOIN [CRONUS UK Ltd_$O365 Brand Color$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [O365 Brand Color] ON [Company Information].[Brand Color Code] = [O365 Brand Color].[Code]
5700	Responsibility Center	Responsibility Center	Normal	Code	10	Responsibility Center	nvarchar(20)
	Key to join to the Responsibility Center table. Show/hide example query SELECT [Company Information].[Responsibility Center] ,[Responsibility Center].[Code] FROM [CRONUS UK Ltd_$Company Information$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Company Information] LEFT JOIN [CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center] ON [Company Information].[Responsibility Center] = [Responsibility Center].[Code]
5791	Check-Avail. Period Calc.	Check-Avail. Period Calc.	Normal	DateFormula	32	Check-Avail_ Period Calc_	varchar(32)
5792	Check-Avail. Time Bucket	Check-Avail. Time Bucket	Normal	Option	4	Check-Avail_ Time Bucket	int
	Available options are: “Day” “Week” “Month” “Quarter” “Year” “Accounting Period”
7600	Base Calendar Code	Base Calendar Code	Normal	Code	10	Base Calendar Code	nvarchar(20)
	Key to join to the Base Calendar table. Show/hide example query SELECT [Company Information].[Base Calendar Code] ,[Base Calendar].[Code] FROM [CRONUS UK Ltd_$Company Information$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Company Information] LEFT JOIN [CRONUS UK Ltd_$Base Calendar$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Base Calendar] ON [Company Information].[Base Calendar Code] = [Base Calendar].[Code]
7601	Cal. Convergence Time Frame	Cal. Convergence Time Frame	Normal	DateFormula	32	Cal_ Convergence Time Frame	varchar(32)
7602	Show Chart On RoleCenter	Show Chart On RoleCenter	Normal	Boolean	4	Show Chart On RoleCenter	tinyint
7603	Sync with O365 Bus. profile	Sync with O365 Bus. profile	Normal	Boolean	4	Sync with O365 Bus_ profile	tinyint
8000	Id	Id	Normal	GUID	16	Id	uniqueidentifier
10005	Ship-to UPS Zone	Ship-to UPS Zone	Normal	Code	2
10006	UPS Shipper ID	UPS Shipper ID	Normal	Text	15
10010	Tax Area Code	Tax Area Code	Normal	Code	20
10015	Tax Exemption No.	Tax Exemption No.	Normal	Text	30
10016	Federal ID No.	Federal ID No.	Normal	Text	30
10017	QST Registration No.	QST Registration No.	Normal	Text	20
10018	EIN Number	EIN Number	Normal	Code	10
10019	IRS Contact No.	IRS Contact No.	Normal	Code	20
10021	Provincial Tax Area Code	Provincial Tax Area Code	Normal	Code	20
10022	Software Identification Code	Software Identification Code	Normal	Code	10
10023	RFC No.	RFC No.	Normal	Code	12
10024	CURP No.	CURP No.	Normal	Code	18
10025	State Inscription	State Inscription	Normal	Text	30
10026	Tax Scheme	Tax Scheme	Normal	Text	250
14021	RFC Number	RFC Number	Normal	Text	30
27000	SAT Tax Regime Classification	SAT Tax Regime Classification	Normal	Code	10
27001	SAT Postal Code	SAT ZIP Code	Normal	Code	10
27002	SCT Permission Type	SCT Permission Type	Normal	Code	10
27003	SCT Permission Number	SCT Permission Number	Normal	Code	20
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Company Information].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Company Information$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Company Information] LEFT JOIN [User] AS [User] ON [Company Information].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Company Information].[$systemModifiedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Company Information$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Company Information] LEFT JOIN [User] AS [User] ON [Company Information].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Company Information table

IC Partner Location Post Code Responsibility Center Tax Area

Dynamics 365 BC Table Reference Tables Company Tables CCompany Information

Leave a Reply Cancel reply