LP ML Input Data

Dynamics 365 BC Table ReferenceTablesCompany TablesLLP ML Input Data

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

Table Type: Company

Table Name: LP ML Input Data
Database Table Name: CRONUS UK Ltd_$LP ML Input Data$3d5b2137-efeb-4014-8489-41d37f8fd4c3

Table Number: 1951

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 ML Input Data can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$LP ML Input Data$3d5b2137-efeb-4014-8489-41d37f8fd4c3]

Show/hide an example select of all columns by name

SELECT

   [Number]
   ,[Payment Terms Days]
   ,[Corrected]
   ,[No_ Paid Invoices]
   ,[No_ Paid Late Invoices]
   ,[Ratio Paid Late_Paid Invoices]
   ,[Total Paid Invoices Amount]
   ,[Total Paid Late Inv_ Amount]
   ,[Ratio PaidLateAmnt_PaidAmnt]
   ,[Average Days Late]
   ,[No_ Outstanding Inv_]
   ,[No_ Outstanding Late Inv_]
   ,[Ratio NoOutstngLate_NoOutstng]
   ,[Total Outstng Invoices Amt_]
   ,[Total Outstng Late Inv_ Amt_]
   ,[Ratio AmtLate_Amt Outstng Inv]
   ,[Average Outstanding Days Late]
   ,[Bill-to Customer No_]
   ,[Base Amount]
   ,[Posting Date]
   ,[Due Date]
   ,[Closed Date]
   ,[Closed]
   ,[Paid Late Days]
   ,[UsedForPredict And ToBeDeleted]
   ,[Is Late]
   ,[Confidence]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$LP ML Input Data$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 ML Input Data$3d5b2137-efeb-4014-8489-41d37f8fd4c3] AS [LP ML Input Data]
LEFT JOIN
   [User] AS [User]
      ON
         [LP ML Input Data].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [LP ML Input Data].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in LP ML Input Data table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Number SearchNumberNormalCode20Numbernvarchar(40)
2Payment Terms Days Primary Key SearchPayment Terms DaysNormalInteger4Payment Terms Daysint
3Corrected SearchCorrectedNormalBoolean4Correctedtinyint
4No. Paid Invoices SearchNo. Paid InvoicesNormalInteger4No_ Paid Invoicesint
5No. Paid Late Invoices SearchNo. Paid Late InvoicesNormalInteger4No_ Paid Late Invoicesint
6Ratio Paid Late/Paid Invoices SearchRatio Paid Late/Paid InvoicesNormalDecimal12Ratio Paid Late_Paid Invoicesdecimal(38,38)
7Total Paid Invoices Amount SearchTotal Paid Invoices AmountNormalDecimal12Total Paid Invoices Amountdecimal(38,38)
8Total Paid Late Inv. Amount SearchTotal Paid Late Inv. AmountNormalDecimal12Total Paid Late Inv_ Amountdecimal(38,38)
9Ratio PaidLateAmnt/PaidAmnt SearchRatio PaidLateAmnt/PaidAmntNormalDecimal12Ratio PaidLateAmnt_PaidAmntdecimal(38,38)
10Average Days Late SearchAverage Days LateNormalDecimal12Average Days Latedecimal(38,38)
11No. Outstanding Inv. SearchNo. Outstanding Inv.NormalInteger4No_ Outstanding Inv_int
12No. Outstanding Late Inv. SearchNo. Outstanding Late Inv.NormalInteger4No_ Outstanding Late Inv_int
13Ratio NoOutstngLate/NoOutstng SearchRatio NoOutstngLate/NoOutstngNormalDecimal12Ratio NoOutstngLate_NoOutstngdecimal(38,38)
14Total Outstng Invoices Amt. SearchTotal Outstng Invoices Amt.NormalDecimal12Total Outstng Invoices Amt_decimal(38,38)
15Total Outstng Late Inv. Amt. SearchTotal Outstng Late Inv. Amt.NormalDecimal12Total Outstng Late Inv_ Amt_decimal(38,38)
16Ratio AmtLate/Amt Outstng Inv SearchRatio AmtLate/Amt Outstng InvNormalDecimal12Ratio AmtLate_Amt Outstng Invdecimal(38,38)
17Average Outstanding Days Late SearchAverage Outstanding Days LateNormalDecimal12Average Outstanding Days Latedecimal(38,38)
18Bill-to Customer No. SearchBill-to Customer No.NormalCode20Bill-to Customer No_nvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
	       [LP ML Input Data].[Bill-to Customer No_]
	       ,[Customer].[No_]
	FROM
	       [CRONUS UK Ltd_$LP ML Input Data$3d5b2137-efeb-4014-8489-41d37f8fd4c3] AS [LP ML Input Data]
	LEFT JOIN
	       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
	              ON
	                     [LP ML Input Data].[Bill-to Customer No_] = [Customer].[No_]
19Base Amount SearchBase AmountNormalDecimal12Base Amountdecimal(38,38)
20Posting Date SearchPosting DateNormalDate4Posting Datedatetime
21Due Date SearchDue DateNormalDate4Due Datedatetime
22Closed Date SearchClosed DateNormalDate4Closed Datedatetime
23Closed SearchClosedNormalBoolean4Closedtinyint
24Paid Late Days SearchPaid Late DaysNormalInteger4Paid Late Daysint
25UsedForPredict And ToBeDeleted SearchUsedForPredict And ToBeDeletedNormalBoolean4UsedForPredict And ToBeDeletedtinyint
100Is Late SearchIs LateNormalBoolean4Is Latetinyint
101Confidence SearchConfidenceNormalDecimal12Confidencedecimal(38,38)
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 ML Input Data].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$LP ML Input Data$3d5b2137-efeb-4014-8489-41d37f8fd4c3] AS [LP ML Input Data]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [LP ML Input Data].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Dynamics 365 BC Table ReferenceTablesCompany TablesLLP ML Input Data

Leave a Reply

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