LP ML Input Data – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables LLP 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 Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Number	Number	Normal	Code	20	Number	nvarchar(40)
2	Payment Terms Days	Payment Terms Days	Normal	Integer	4	Payment Terms Days	int
3	Corrected	Corrected	Normal	Boolean	4	Corrected	tinyint
4	No. Paid Invoices	No. Paid Invoices	Normal	Integer	4	No_ Paid Invoices	int
5	No. Paid Late Invoices	No. Paid Late Invoices	Normal	Integer	4	No_ Paid Late Invoices	int
6	Ratio Paid Late/Paid Invoices	Ratio Paid Late/Paid Invoices	Normal	Decimal	12	Ratio Paid Late_Paid Invoices	decimal(38,38)
7	Total Paid Invoices Amount	Total Paid Invoices Amount	Normal	Decimal	12	Total Paid Invoices Amount	decimal(38,38)
8	Total Paid Late Inv. Amount	Total Paid Late Inv. Amount	Normal	Decimal	12	Total Paid Late Inv_ Amount	decimal(38,38)
9	Ratio PaidLateAmnt/PaidAmnt	Ratio PaidLateAmnt/PaidAmnt	Normal	Decimal	12	Ratio PaidLateAmnt_PaidAmnt	decimal(38,38)
10	Average Days Late	Average Days Late	Normal	Decimal	12	Average Days Late	decimal(38,38)
11	No. Outstanding Inv.	No. Outstanding Inv.	Normal	Integer	4	No_ Outstanding Inv_	int
12	No. Outstanding Late Inv.	No. Outstanding Late Inv.	Normal	Integer	4	No_ Outstanding Late Inv_	int
13	Ratio NoOutstngLate/NoOutstng	Ratio NoOutstngLate/NoOutstng	Normal	Decimal	12	Ratio NoOutstngLate_NoOutstng	decimal(38,38)
14	Total Outstng Invoices Amt.	Total Outstng Invoices Amt.	Normal	Decimal	12	Total Outstng Invoices Amt_	decimal(38,38)
15	Total Outstng Late Inv. Amt.	Total Outstng Late Inv. Amt.	Normal	Decimal	12	Total Outstng Late Inv_ Amt_	decimal(38,38)
16	Ratio AmtLate/Amt Outstng Inv	Ratio AmtLate/Amt Outstng Inv	Normal	Decimal	12	Ratio AmtLate_Amt Outstng Inv	decimal(38,38)
17	Average Outstanding Days Late	Average Outstanding Days Late	Normal	Decimal	12	Average Outstanding Days Late	decimal(38,38)
18	Bill-to Customer No.	Bill-to Customer No.	Normal	Code	20	Bill-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_]
19	Base Amount	Base Amount	Normal	Decimal	12	Base Amount	decimal(38,38)
20	Posting Date	Posting Date	Normal	Date	4	Posting Date	datetime
21	Due Date	Due Date	Normal	Date	4	Due Date	datetime
22	Closed Date	Closed Date	Normal	Date	4	Closed Date	datetime
23	Closed	Closed	Normal	Boolean	4	Closed	tinyint
24	Paid Late Days	Paid Late Days	Normal	Integer	4	Paid Late Days	int
25	UsedForPredict And ToBeDeleted	UsedForPredict And ToBeDeleted	Normal	Boolean	4	UsedForPredict And ToBeDeleted	tinyint
100	Is Late	Is Late	Normal	Boolean	4	Is Late	tinyint
101	Confidence	Confidence	Normal	Decimal	12	Confidence	decimal(38,38)
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	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]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [LP ML Input Data].[$systemModifiedBy] ,[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].[$systemModifiedBy] = [User].[User Security ID]