Cash Flow Forecast Entry

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

Table Type: Company

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

Table Number: 0

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 Forecast Entry can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Cash Flow Forecast Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Entry No_]
   ,[User ID]
   ,[Cash Flow Forecast No_]
   ,[Cash Flow Date]
   ,[Document No_]
   ,[Cash Flow Account No_]
   ,[Source Type]
   ,[Description]
   ,[Overdue]
   ,[Document Date]
   ,[Payment Discount]
   ,[Associated Entry No_]
   ,[Associated Document No_]
   ,[Global Dimension 2 Code]
   ,[Global Dimension 1 Code]
   ,[Recurring Method]
   ,[Amount (LCY)]
   ,[Positive]
   ,[Source No_]
   ,[G_L Budget Name]
   ,[Source Line No_]
   ,[Dimension Set ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Cash Flow Forecast Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Cash Flow Forecast Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3User ID Searchnvarchar(100)
4Cash Flow Forecast No_ Searchnvarchar(40)
5Cash Flow Date Searchdatetime
6Document No_ Searchnvarchar(40)
7Cash Flow Account No_ Searchnvarchar(40)
8Source Type Searchint
9Description Searchnvarchar(500)
10Overdue Searchtinyint
11Document Date Searchdatetime
12Payment Discount Searchdecimal(38,38)
13Associated Entry No_ Searchint
14Associated Document No_ Searchnvarchar(40)
15Global Dimension 2 Code Searchnvarchar(40)
16Global Dimension 1 Code Searchnvarchar(40)
17Recurring Method Searchint
18Amount (LCY) Searchdecimal(38,38)
19Positive Searchtinyint
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

Leave a Reply

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