Easily find this page again using the shortlink:

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


Show/hide an example select of all columns by name

   ,[Evaluation Company]
   ,[Display Name]
   ,[Business Profile Id]

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 *