Company 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: 0

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 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
       [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]
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
       [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]
37Ship-to Country_Region Code Searchnvarchar(20)
38IBAN Searchnvarchar(100)
39SWIFT Code Searchnvarchar(40)
40Industrial Classification Searchnvarchar(60)
41IC Partner Code Searchnvarchar(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]
42IC Inbox Type Searchint
43IC Inbox Details Searchnvarchar(500)
44Auto_ Send Transactions Searchtinyint
45System Indicator Searchint
46Custom System Indicator Text Searchnvarchar(500)
47System Indicator Style Searchint
48Allow Blank Payment Info_ Searchtinyint
49Contact Person Searchnvarchar(100)
50GLN Searchnvarchar(26)
51EORI Number Searchnvarchar(80)
52Suppl_ VAT Registration No_ Searchnvarchar(80)
53Use GLN in Electronic Document Searchtinyint
54Picture – Last Mod_ Date Time Searchdatetime
55Last Modified Date Time Searchdatetime
56Created DateTime Searchdatetime
57Demo Company Searchtinyint
58Alternative Language Code Searchnvarchar(20)
59Brand Color Value Searchnvarchar(20)
60Brand Color Code Searchnvarchar(40)
61Responsibility Center Searchnvarchar(20)
62Check-Avail_ Period Calc_ Searchvarchar(32)
63Check-Avail_ Time Bucket Searchint
64Base Calendar Code Searchnvarchar(20)
65Cal_ Convergence Time Frame Searchvarchar(32)
66Show Chart On RoleCenter Searchtinyint
67Sync with O365 Bus_ profile Searchtinyint
68Id Searchuniqueidentifier
69Registered Name Searchnvarchar(100)
70Registered Name 2 Searchnvarchar(100)
71Registered Address Searchnvarchar(100)
72Registered Address 2 Searchnvarchar(100)
73Registered City Searchnvarchar(60)
74Registered County Searchnvarchar(60)
75Registered Post Code Searchnvarchar(40)
76Branch Number Searchnvarchar(6)
77Contact Name Searchnvarchar(70)
78$systemId Searchuniqueidentifier
79$systemCreatedAt Searchdatetime
80$systemCreatedBy Searchuniqueidentifier
81$systemModifiedAt Searchdatetime
82$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Company Information table

Leave a Reply

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