LP Machine Learning Setup

Dynamics 365 BC Table ReferenceTablesCompany TablesLLP 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

   [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 an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$LP Machine Learning Setup$3d5b2137-efeb-4014-8489-41d37f8fd4c3] AS [LP Machine Learning Setup]
LEFT JOIN
   [User] AS [User]
      ON
         [LP Machine Learning Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [LP Machine Learning Setup].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in LP Machine Learning Setup table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Primary Key SearchPrimary KeyNormalCode10Primary Keynvarchar(20)
2Make Predictions Primary Key SearchMake PredictionsNormalBoolean4Make Predictionstinyint
3My Model SearchMy ModelNormalBLOB8My Modelimage
4Selected Model SearchSelected ModelNormalOption4Selected Modelint
Available options are:
  • “Standard”
  • “My”
5My Model Quality SearchMy Model QualityNormalDecimal12My Model Qualitydecimal(38,38)
6Standard Model Quality SearchStandard Model QualityNormalDecimal12Standard Model Qualitydecimal(38,38)
7Model Quality Threshold SearchModel Quality ThresholdNormalDecimal12Model Quality Thresholddecimal(38,38)
8Use My Model Credentials SearchUse My Azure SubscriptionNormalBoolean4Use My Model Credentialstinyint
9Custom API Uri SearchCustom API UriNormalText250Custom API Urinvarchar(500)
10Custom API Key SearchCustom API KeyNormalText200Custom API Keynvarchar(400)
11Exact Invoice No OnLastML SearchExact Invoice No OnLastMLNormalInteger4Exact Invoice No OnLastMLint
12OverestimatedInvNo OnLastReset SearchOverestimatedInvNo OnLastResetNormalInteger4OverestimatedInvNo OnLastResetint
13Last Feature Table Reset SearchLast Feature Table ResetNormalDateTime8Last Feature Table Resetdatetime
14Last Background Analysis SearchLast Background AnalysisNormalDateTime8Last Background Analysisdatetime
15Standard Model Pdf SearchStandard Model PdfNormalBLOB8Standard Model Pdfimage
16My Model Pdf SearchMy Model PdfNormalBLOB8My Model Pdfimage
17Posting Date OnLastML SearchPosting Date OnLastMLNormalDate4Posting Date OnLastMLdatetime
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
	       [LP Machine Learning Setup].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$LP Machine Learning Setup$3d5b2137-efeb-4014-8489-41d37f8fd4c3] AS [LP Machine Learning Setup]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [LP Machine Learning Setup].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Dynamics 365 BC Table ReferenceTablesCompany TablesLLP Machine Learning Setup

Leave a Reply

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