Cash 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 IDColumn NameData Type
1timestamp Searchtimestamp
2Line No_ Primary Key Searchint
3Cash Flow Forecast No_ Searchnvarchar(40)
4Cash Flow Date Searchdatetime
5Document No_ Searchnvarchar(40)
6Cash Flow Account No_ Searchnvarchar(40)
7Source Type Searchint
8Description Searchnvarchar(500)
9Document Type Searchint
10Document Date Searchdatetime
11Pmt_ Discount Date Searchdatetime
12Pmt_ Disc_ Tolerance Date Searchdatetime
13Payment Terms Code Searchnvarchar(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 Searchdecimal(38,38)
15Associated Entry No_ Searchint
16Overdue Searchtinyint
17Shortcut Dimension 2 Code Searchnvarchar(40)
18Shortcut Dimension 1 Code Searchnvarchar(40)
19Amount (LCY) Searchdecimal(38,38)
20Source No_ Searchnvarchar(40)
21G_L Budget Name Searchnvarchar(20)
22Source Line No_ Searchint
23Dimension Set ID Searchint
24$systemId Searchuniqueidentifier
25$systemCreatedAt Searchdatetime
26$systemCreatedBy Searchuniqueidentifier
27$systemModifiedAt Searchdatetime
28$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Cash Flow Worksheet Line table

Leave a Reply

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