Easily find this page again using the shortlink:

Table Type: Company

Table Name: MTD-Liability
Database Table Name: CRONUS UK Ltd_$MTD-Liability$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 MTD-Liability can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

   ,[From Date]
   ,[To Date]
   ,[Original Amount]
   ,[Outstanding Amount]
   ,[Due Date]
   [CRONUS UK Ltd_$MTD-Liability$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in MTD-Liability table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2From Date Primary Key Searchdatetime
3To Date Primary Key Searchdatetime
4Type Searchint
5Original Amount Searchdecimal(38,38)
6Outstanding Amount Searchdecimal(38,38)
7Due Date Searchdatetime
8$systemId Searchuniqueidentifier
9$systemCreatedAt Searchdatetime
10$systemCreatedBy Searchuniqueidentifier
11$systemModifiedAt Searchdatetime
12$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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