Cash Flow Worksheet Line

Dynamics 365 BC Table ReferenceTablesCompany TablesCCash Flow Worksheet Line

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

Table Type: Company

Table Name: Cash Flow Worksheet Line
Database Table Name: CRONUS UK Ltd_$Cash Flow Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 846

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 Cash Flow Worksheet Line can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Cash Flow Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Line No_]
   ,[Cash Flow Forecast No_]
   ,[Cash Flow Date]
   ,[Document No_]
   ,[Cash Flow Account No_]
   ,[Source Type]
   ,[Description]
   ,[Document Type]
   ,[Document Date]
   ,[Pmt_ Discount Date]
   ,[Pmt_ Disc_ Tolerance Date]
   ,[Payment Terms Code]
   ,[Payment Discount]
   ,[Associated Entry No_]
   ,[Overdue]
   ,[Shortcut Dimension 2 Code]
   ,[Shortcut Dimension 1 Code]
   ,[Amount (LCY)]
   ,[Source No_]
   ,[G_L Budget Name]
   ,[Source Line No_]
   ,[Dimension Set ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Cash Flow Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Cash Flow Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Worksheet Line]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [Cash Flow Worksheet Line].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [Cash Flow Worksheet Line].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [Cash Flow Worksheet Line].[Document Type] = [Sales Header].[Document Type]
      AND
         [Cash Flow Worksheet Line].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
      ON
         [Cash Flow Worksheet Line].[Payment Terms Code] = [Payment Terms].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Cash Flow Worksheet Line].[Shortcut Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Cash Flow Worksheet Line].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Cash Flow Worksheet Line].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Cash Flow Worksheet Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Cash Flow Worksheet Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Cash Flow Worksheet Line table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
2Line No. SearchLine No.NormalInteger4Line No_int
3Cash Flow Forecast No. Primary Key SearchCash Flow Forecast No.NormalCode20Cash Flow Forecast No_nvarchar(40)
Key to join to the Cash Flow Forecast table.

Show/hide example query

SELECT
	       [Cash Flow Worksheet Line].[Cash Flow Forecast No_]
	       ,[Cash Flow Forecast].[No_]
	FROM
	       [CRONUS UK Ltd_$Cash Flow Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Worksheet Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Cash Flow Forecast$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Forecast]
	              ON
	                     [Cash Flow Worksheet Line].[Cash Flow Forecast No_] = [Cash Flow Forecast].[No_]
4Cash Flow Date SearchCash Flow DateNormalDate4Cash Flow Datedatetime
5Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
6Cash Flow Account No. SearchCash Flow Account No.NormalCode20Cash Flow Account No_nvarchar(40)
Key to join to the Cash Flow Account table.

Show/hide example query

SELECT
	       [Cash Flow Worksheet Line].[Cash Flow Account No_]
	       ,[Cash Flow Account].[No_]
	FROM
	       [CRONUS UK Ltd_$Cash Flow Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Worksheet Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Cash Flow Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Account]
	              ON
	                     [Cash Flow Worksheet Line].[Cash Flow Account No_] = [Cash Flow Account].[No_]
7Source Type SearchSource TypeNormalOption4Source Typeint
Available options are:
  • ” “
  • “Receivables”
  • “Payables”
  • “Liquid Funds”
  • “Cash Flow Manual Expense”
  • “Cash Flow Manual Revenue”
  • “Sales Orders”
  • “Purchase Orders”
  • “Fixed Assets Budget”
  • “Fixed Assets Disposal”
  • “Service Orders”
  • “G/L Budget”
  • “Job”
  • “Tax”
  • “Azure AI”
8Description SearchDescriptionNormalText250Descriptionnvarchar(500)
9Document Type SearchDocument TypeNormalOption4Document Typeint
Available options are:
  • ” “
  • “Payment”
  • “Invoice”
  • “Credit Memo”
  • “Finance Charge Memo”
  • “Reminder”
  • “Refund”
10Document Date SearchDocument DateNormalDate4Document Datedatetime
11Pmt. Discount Date SearchPmt. Discount DateNormalDate4Pmt_ Discount Datedatetime
12Pmt. Disc. Tolerance Date SearchPmt. Disc. Tolerance DateNormalDate4Pmt_ Disc_ Tolerance Datedatetime
13Payment Terms Code SearchPayment Terms CodeNormalCode10Payment Terms Codenvarchar(20)
Key to join to the Payment Terms table.

Show/hide example query

SELECT
	       [Cash Flow Worksheet Line].[Payment Terms Code]
	       ,[Payment Terms].[Code]
	FROM
	       [CRONUS UK Ltd_$Cash Flow Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Worksheet Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
	              ON
	                     [Cash Flow Worksheet Line].[Payment Terms Code] = [Payment Terms].[Code]
14Payment Discount SearchPayment DiscountNormalDecimal12Payment Discountdecimal(38,38)
15Associated Entry No. SearchAssociated Entry No.NormalInteger4Associated Entry No_int
16Overdue SearchOverdueNormalBoolean4Overduetinyint
17Shortcut Dimension 2 Code SearchShortcut Dimension 2 CodeNormalCode20Shortcut Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
	       [Cash Flow Worksheet Line].[Shortcut Dimension 2 Code]
	       ,[Dimension].[Code]
	FROM
	       [CRONUS UK Ltd_$Cash Flow Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Worksheet Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
	              ON
	                     [Cash Flow Worksheet Line].[Shortcut Dimension 2 Code] = [Dimension].[Code]
18Shortcut Dimension 1 Code SearchShortcut Dimension 1 CodeNormalCode20Shortcut Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
	       [Cash Flow Worksheet Line].[Shortcut Dimension 1 Code]
	       ,[Dimension].[Code]
	FROM
	       [CRONUS UK Ltd_$Cash Flow Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Worksheet Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
	              ON
	                     [Cash Flow Worksheet Line].[Shortcut Dimension 1 Code] = [Dimension].[Code]
30Amount (LCY) SearchAmount ($)NormalDecimal12Amount (LCY)decimal(38,38)
34Source No. SearchSource No.NormalCode20Source No_nvarchar(40)
35G/L Budget Name SearchG/L Budget NameNormalCode10G_L Budget Namenvarchar(20)
36Source Line No. SearchSource Line No.NormalInteger4Source Line No_int
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
	       [Cash Flow Worksheet Line].[Dimension Set ID]
	       ,[Dimension Set Entry].[Dimension Set ID]
	FROM
	       [CRONUS UK Ltd_$Cash Flow Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Worksheet Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
	              ON
	                     [Cash Flow Worksheet Line].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
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
	       [Cash Flow Worksheet Line].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Cash Flow Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Worksheet Line]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Cash Flow Worksheet Line].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Cash Flow Worksheet Line table

Payment TermsSales HeaderSales Header Archive
Dynamics 365 BC Table ReferenceTablesCompany TablesCCash Flow Worksheet Line

Leave a Reply

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