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: 847

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
   [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 an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Cash Flow Forecast Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Forecast Entry]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Cash Flow Forecast Entry].[Global Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Cash Flow Forecast Entry].[Global 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 Forecast Entry].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Cash Flow Forecast Entry].[Shortcut Dimension 3 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Cash Flow Forecast Entry].[Shortcut Dimension 4 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Cash Flow Forecast Entry].[Shortcut Dimension 5 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Cash Flow Forecast Entry].[Shortcut Dimension 6 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Cash Flow Forecast Entry].[Shortcut Dimension 7 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Cash Flow Forecast Entry].[Shortcut Dimension 8 Code] = [Dimension].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Cash Flow Forecast Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Cash Flow Forecast Entry].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Cash Flow Forecast Entry table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Entry No. Primary Key SearchEntry No.NormalInteger4Entry No_int
2User ID SearchUser IDNormalCode50User IDnvarchar(100)
10Cash Flow Forecast No. 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 Forecast Entry].[Cash Flow Forecast No_]
       ,[Cash Flow Forecast].[No_]
FROM
       [CRONUS UK Ltd_$Cash Flow Forecast Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Forecast Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Cash Flow Forecast$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Forecast]
              ON
                     [Cash Flow Forecast Entry].[Cash Flow Forecast No_] = [Cash Flow Forecast].[No_]
11Cash Flow Date SearchCash Flow DateNormalDate4Cash Flow Datedatetime
12Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
13Cash 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 Forecast Entry].[Cash Flow Account No_]
       ,[Cash Flow Account].[No_]
FROM
       [CRONUS UK Ltd_$Cash Flow Forecast Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Forecast Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Cash Flow Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Account]
              ON
                     [Cash Flow Forecast Entry].[Cash Flow Account No_] = [Cash Flow Account].[No_]
14Source 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”
15Description SearchDescriptionNormalText250Descriptionnvarchar(500)
16Overdue SearchOverdueNormalBoolean4Overduetinyint
17Document Date SearchDocument DateNormalDate4Document Datedatetime
21Payment Discount SearchPayment DiscountNormalDecimal12Payment Discountdecimal(38,38)
22Associated Entry No. SearchAssociated Entry No.NormalInteger4Associated Entry No_int
23Associated Document No. SearchAssociated Document No.NormalCode20Associated Document No_nvarchar(40)
24Global Dimension 2 Code SearchGlobal Dimension 2 CodeNormalCode20Global Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Cash Flow Forecast Entry].[Global Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Cash Flow Forecast Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Forecast Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Cash Flow Forecast Entry].[Global Dimension 2 Code] = [Dimension].[Code]
25Global Dimension 1 Code SearchGlobal Dimension 1 CodeNormalCode20Global Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Cash Flow Forecast Entry].[Global Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Cash Flow Forecast Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Forecast Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Cash Flow Forecast Entry].[Global Dimension 1 Code] = [Dimension].[Code]
26Recurring Method SearchRecurring MethodNormalOption4Recurring Methodint
Available options are:
  • “”
  • “Fixed”
  • “Variable”
29Amount (LCY) SearchAmount ($)NormalDecimal12Amount (LCY)decimal(38,38)
30Positive SearchPositiveNormalBoolean4Positivetinyint
33Source No. SearchSource No.NormalCode20Source No_nvarchar(40)
35G/L Budget Name SearchG/L Budget NameNormalCode10G_L Budget Namenvarchar(20)
Key to join to the G/L Budget Name table.

Show/hide example query

SELECT
       [Cash Flow Forecast Entry].[G_L Budget Name]
       ,[G/L Budget Name].[Name]
FROM
       [CRONUS UK Ltd_$Cash Flow Forecast Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Forecast Entry]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Budget Name]
              ON
                     [Cash Flow Forecast Entry].[G_L Budget Name] = [G/L Budget Name].[Name]
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 Forecast Entry].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Cash Flow Forecast Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Forecast Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Cash Flow Forecast Entry].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
481Shortcut Dimension 3 Code SearchShortcut Dimension 3 CodeFlowFieldCode20
482Shortcut Dimension 4 Code SearchShortcut Dimension 4 CodeFlowFieldCode20
483Shortcut Dimension 5 Code SearchShortcut Dimension 5 CodeFlowFieldCode20
484Shortcut Dimension 6 Code SearchShortcut Dimension 6 CodeFlowFieldCode20
485Shortcut Dimension 7 Code SearchShortcut Dimension 7 CodeFlowFieldCode20
486Shortcut Dimension 8 Code SearchShortcut Dimension 8 CodeFlowFieldCode20
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 Forecast Entry].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Cash Flow Forecast Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Forecast Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Cash Flow Forecast Entry].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Cash Flow Forecast Entry].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Cash Flow Forecast Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Forecast Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Cash Flow Forecast Entry].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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