Company

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

Table Type: System

Table Name: Company
Database Table Name: Company

Table Number: 2000000006

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [Company]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Name]
   ,[Evaluation Company]
   ,[Display Name]
   ,[Id]
   ,[Business Profile Id]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [Company]

Show/hide columns in Company table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Name Primary Key Searchnvarchar(60)
3Evaluation Company Searchtinyint
4Display Name Searchnvarchar(500)
5Id Searchuniqueidentifier
6Business Profile Id Searchnvarchar(500)
7$systemId Searchuniqueidentifier
8$systemCreatedAt Searchdatetime
9$systemCreatedBy Searchuniqueidentifier
10$systemModifiedAt Searchdatetime
11$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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