Cash Flow Worksheet Line – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables CCash 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

   [timestamp]
   ,[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_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
      ON
         [Cash Flow Worksheet Line].[Payment Terms Code] = [Payment Terms].[Code]

Show/hide columns in Cash Flow Worksheet Line table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	Line No_	int
3	Cash Flow Forecast No_	nvarchar(40)
4	Cash Flow Date	datetime
5	Document No_	nvarchar(40)
6	Cash Flow Account No_	nvarchar(40)
7	Source Type	int
8	Description	nvarchar(500)
9	Document Type	int
10	Document Date	datetime
11	Pmt_ Discount Date	datetime
12	Pmt_ Disc_ Tolerance Date	datetime
13	Payment Terms Code	nvarchar(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]
14	Payment Discount	decimal(38,38)
15	Associated Entry No_	int
16	Overdue	tinyint
17	Shortcut Dimension 2 Code	nvarchar(40)
18	Shortcut Dimension 1 Code	nvarchar(40)
19	Amount (LCY)	decimal(38,38)
20	Source No_	nvarchar(40)
21	G_L Budget Name	nvarchar(20)
22	Source Line No_	int
23	Dimension Set ID	int
24	$systemId	uniqueidentifier
25	$systemCreatedAt	datetime
26	$systemCreatedBy	uniqueidentifier
27	$systemModifiedAt	datetime
28	$systemModifiedBy	uniqueidentifier