Cash Flow Forecast

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

Table Type: Company

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

Table Number: 840

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[No_]
   ,[Search Name]
   ,[Description]
   ,[Description 2]
   ,[Consider Discount]
   ,[Creation Date]
   ,[Created By]
   ,[Manual Payments To]
   ,[No_ Series]
   ,[Manual Payments From]
   ,[G_L Budget From]
   ,[G_L Budget To]
   ,[Consider CF Payment Terms]
   ,[Consider Pmt_ Disc_ Tol_ Date]
   ,[Consider Pmt_ Tol_ Amount]
   ,[Overdue CF Dates to Work Date]
   ,[Default G_L Budget Name]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Cash Flow Forecast$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Cash Flow Forecast table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchnvarchar(40)
3Search Name Searchnvarchar(200)
4Description Searchnvarchar(200)
5Description 2 Searchnvarchar(100)
6Consider Discount Searchtinyint
7Creation Date Searchdatetime
8Created By Searchnvarchar(100)
9Manual Payments To Searchdatetime
10No_ Series Searchnvarchar(40)
11Manual Payments From Searchdatetime
12G_L Budget From Searchdatetime
13G_L Budget To Searchdatetime
14Consider CF Payment Terms Searchtinyint
15Consider Pmt_ Disc_ Tol_ Date Searchtinyint
16Consider Pmt_ Tol_ Amount Searchtinyint
17Overdue CF Dates to Work Date Searchtinyint
18Default G_L Budget Name Searchnvarchar(20)
19$systemId Searchuniqueidentifier
20$systemCreatedAt Searchdatetime
21$systemCreatedBy Searchuniqueidentifier
22$systemModifiedAt Searchdatetime
23$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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