LP Machine Learning Setup

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

Table Type: Company

Table Name: LP Machine Learning Setup
Database Table Name: CRONUS UK Ltd_$LP Machine Learning Setup$3d5b2137-efeb-4014-8489-41d37f8fd4c3

Table Number: 1950

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 LP Machine Learning Setup can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$LP Machine Learning Setup$3d5b2137-efeb-4014-8489-41d37f8fd4c3]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Primary Key]
   ,[Make Predictions]
   ,[My Model]
   ,[Selected Model]
   ,[My Model Quality]
   ,[Standard Model Quality]
   ,[Model Quality Threshold]
   ,[Use My Model Credentials]
   ,[Custom API Uri]
   ,[Custom API Key]
   ,[Exact Invoice No OnLastML]
   ,[OverestimatedInvNo OnLastReset]
   ,[Last Feature Table Reset]
   ,[Last Background Analysis]
   ,[Standard Model Pdf]
   ,[My Model Pdf]
   ,[Posting Date OnLastML]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$LP Machine Learning Setup$3d5b2137-efeb-4014-8489-41d37f8fd4c3]

Show/hide columns in LP Machine Learning Setup table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Primary Key Primary Key Searchnvarchar(20)
3Make Predictions Searchtinyint
4My Model Searchimage
5Selected Model Searchint
6My Model Quality Searchdecimal(38,38)
7Standard Model Quality Searchdecimal(38,38)
8Model Quality Threshold Searchdecimal(38,38)
9Use My Model Credentials Searchtinyint
10Custom API Uri Searchnvarchar(500)
11Custom API Key Searchnvarchar(400)
12Exact Invoice No OnLastML Searchint
13OverestimatedInvNo OnLastReset Searchint
14Last Feature Table Reset Searchdatetime
15Last Background Analysis Searchdatetime
16Standard Model Pdf Searchimage
17My Model Pdf Searchimage
18Posting Date OnLastML Searchdatetime
19$systemId Searchuniqueidentifier
20$systemCreatedAt Searchdatetime
21$systemCreatedBy Searchuniqueidentifier
22$systemModifiedAt Searchdatetime
23$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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