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
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 ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | Primary Key  | nvarchar(20) |
| 3 | Make Predictions | tinyint |
| 4 | My Model | image |
| 5 | Selected Model | int |
| 6 | My Model Quality | decimal(38,38) |
| 7 | Standard Model Quality | decimal(38,38) |
| 8 | Model Quality Threshold | decimal(38,38) |
| 9 | Use My Model Credentials | tinyint |
| 10 | Custom API Uri | nvarchar(500) |
| 11 | Custom API Key | nvarchar(400) |
| 12 | Exact Invoice No OnLastML | int |
| 13 | OverestimatedInvNo OnLastReset | int |
| 14 | Last Feature Table Reset | datetime |
| 15 | Last Background Analysis | datetime |
| 16 | Standard Model Pdf | image |
| 17 | My Model Pdf | image |
| 18 | Posting Date OnLastML | datetime |
| 19 | $systemId | uniqueidentifier |
| 20 | $systemCreatedAt | datetime |
| 21 | $systemCreatedBy | uniqueidentifier |
| 22 | $systemModifiedAt | datetime |
| 23 | $systemModifiedBy | uniqueidentifier |