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
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
[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]
,[IC Partner Code]
,[IC Inbox Type]
,[IC Inbox Details]
,[Auto_ Send Transactions]
,[System Indicator]
,[Custom System Indicator Text]
,[System Indicator Style]
,[Allow Blank Payment Info_]
,[Contact Person]
,[GLN]
,[EORI Number]
,[Suppl_ VAT Registration No_]
,[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]
,[Show Chart On RoleCenter]
,[Sync with O365 Bus_ profile]
,[Id]
,[Registered Name]
,[Registered Name 2]
,[Registered Address]
,[Registered Address 2]
,[Registered City]
,[Registered County]
,[Registered Post Code]
,[Branch Number]
,[Contact Name]
,[$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_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
ON
[Company Information].[Location Code] = [Location].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
ON
[Company Information].[Country_Region Code] = [Country_Region].[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]Show/hide columns in Company Information 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 querySELECT
[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 | 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 querySELECT
[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 | nvarchar(20) | ||||
| 38 | IBAN | nvarchar(100) | ||||
| 39 | SWIFT Code | nvarchar(40) | ||||
| 40 | Industrial Classification | nvarchar(60) | ||||
| 41 | IC Partner Code | nvarchar(40) | ||||
Key to join to the IC Partner table.Show/hide example querySELECT
[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 | int | ||||
| 43 | IC Inbox Details | nvarchar(500) | ||||
| 44 | Auto_ Send Transactions | tinyint | ||||
| 45 | System Indicator | int | ||||
| 46 | Custom System Indicator Text | nvarchar(500) | ||||
| 47 | System Indicator Style | int | ||||
| 48 | Allow Blank Payment Info_ | tinyint | ||||
| 49 | Contact Person | nvarchar(100) | ||||
| 50 | GLN | nvarchar(26) | ||||
| 51 | EORI Number | nvarchar(80) | ||||
| 52 | Suppl_ VAT Registration No_ | nvarchar(80) | ||||
| 53 | Use GLN in Electronic Document | tinyint | ||||
| 54 | Picture – Last Mod_ Date Time | datetime | ||||
| 55 | Last Modified Date Time | datetime | ||||
| 56 | Created DateTime | datetime | ||||
| 57 | Demo Company | tinyint | ||||
| 58 | Alternative Language Code | nvarchar(20) | ||||
| 59 | Brand Color Value | nvarchar(20) | ||||
| 60 | Brand Color Code | nvarchar(40) | ||||
| 61 | Responsibility Center | nvarchar(20) | ||||
| 62 | Check-Avail_ Period Calc_ | varchar(32) | ||||
| 63 | Check-Avail_ Time Bucket | int | ||||
| 64 | Base Calendar Code | nvarchar(20) | ||||
| 65 | Cal_ Convergence Time Frame | varchar(32) | ||||
| 66 | Show Chart On RoleCenter | tinyint | ||||
| 67 | Sync with O365 Bus_ profile | tinyint | ||||
| 68 | Id | uniqueidentifier | ||||
| 69 | Registered Name | nvarchar(100) | ||||
| 70 | Registered Name 2 | nvarchar(100) | ||||
| 71 | Registered Address | nvarchar(100) | ||||
| 72 | Registered Address 2 | nvarchar(100) | ||||
| 73 | Registered City | nvarchar(60) | ||||
| 74 | Registered County | nvarchar(60) | ||||
| 75 | Registered Post Code | nvarchar(40) | ||||
| 76 | Branch Number | nvarchar(6) | ||||
| 77 | Contact Name | nvarchar(70) | ||||
| 78 | $systemId | uniqueidentifier | ||||
| 79 | $systemCreatedAt | datetime | ||||
| 80 | $systemCreatedBy | uniqueidentifier | ||||
| 81 | $systemModifiedAt | datetime | ||||
| 82 | $systemModifiedBy | uniqueidentifier | ||||