LP 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
   [timestamp]
   ,[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
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [LP ML Input Data].[Bill-to Customer No_] = [Customer].[No_]

Show/hide columns in LP ML Input Data table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Number Primary Key Searchnvarchar(40)
3Payment Terms Days Searchint
4Corrected Searchtinyint
5No_ Paid Invoices Searchint
6No_ Paid Late Invoices Searchint
7Ratio Paid Late_Paid Invoices Searchdecimal(38,38)
8Total Paid Invoices Amount Searchdecimal(38,38)
9Total Paid Late Inv_ Amount Searchdecimal(38,38)
10Ratio PaidLateAmnt_PaidAmnt Searchdecimal(38,38)
11Average Days Late Searchdecimal(38,38)
12No_ Outstanding Inv_ Searchint
13No_ Outstanding Late Inv_ Searchint
14Ratio NoOutstngLate_NoOutstng Searchdecimal(38,38)
15Total Outstng Invoices Amt_ Searchdecimal(38,38)
16Total Outstng Late Inv_ Amt_ Searchdecimal(38,38)
17Ratio AmtLate_Amt Outstng Inv Searchdecimal(38,38)
18Average Outstanding Days Late Searchdecimal(38,38)
19Bill-to Customer No_ Searchnvarchar(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_]
20Base Amount Searchdecimal(38,38)
21Posting Date Searchdatetime
22Due Date Searchdatetime
23Closed Date Searchdatetime
24Closed Searchtinyint
25Paid Late Days Searchint
26UsedForPredict And ToBeDeleted Searchtinyint
27Is Late Searchtinyint
28Confidence Searchdecimal(38,38)
29$systemId Searchuniqueidentifier
30$systemCreatedAt Searchdatetime
31$systemCreatedBy Searchuniqueidentifier
32$systemModifiedAt Searchdatetime
33$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from LP ML Input Data table

Leave a Reply

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