Cash Flow Account

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

Table Type: Company

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

Table Number: 841

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [No_]
   ,[Name]
   ,[Search Name]
   ,[Account Type]
   ,[Blocked]
   ,[New Page]
   ,[No_ of Blank Lines]
   ,[Indentation]
   ,[Last Date Modified]
   ,[Totaling]
   ,[Source Type]
   ,[G_L Integration]
   ,[G_L Account Filter]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Cash Flow Account$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [] AS [Cash Flow Account]
LEFT JOIN
   [CRONUS UK Ltd_$Cash Flow Forecast$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Forecast]
      ON
         [Cash Flow Account].[Cash Flow Forecast Filter] = [Cash Flow Forecast].[No_]
LEFT JOIN
   [User] AS [User]
      ON
         [Cash Flow Account].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Cash Flow Account].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Cash Flow Account table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1No. Primary Key SearchNo.NormalCode20No_nvarchar(40)
2Name SearchNameNormalText50Namenvarchar(100)
3Search Name SearchSearch NameNormalCode50Search Namenvarchar(100)
4Account Type SearchAccount TypeNormalOption4Account Typeint
Available options are:
  • “Entry”
  • “Heading”
  • “Total”
  • “Begin-Total”
  • “End-Total”
5Comment SearchCommentFlowFieldBoolean4
6Blocked SearchBlockedNormalBoolean4Blockedtinyint
7New Page SearchNew PageNormalBoolean4New Pagetinyint
8No. of Blank Lines SearchNo. of Blank LinesNormalInteger4No_ of Blank Linesint
9Indentation SearchIndentationNormalInteger4Indentationint
10Last Date Modified SearchLast Date ModifiedNormalDate4Last Date Modifieddatetime
11Date Filter SearchDate FilterFlowFilterDate4
12Cash Flow Forecast Filter SearchCash Flow Forecast FilterFlowFilterCode20
13Amount SearchAmountFlowFieldDecimal12
29Global Dimension 1 Filter SearchGlobal Dimension 1 FilterFlowFilterCode20
30Global Dimension 2 Filter SearchGlobal Dimension 2 FilterFlowFilterCode20
34Totaling SearchTotalingNormalText250Totalingnvarchar(500)
35Source 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”
36G/L Integration SearchG/L IntegrationNormalOption4G_L Integrationint
Available options are:
  • ” “
  • “Balance”
  • “Budget”
  • “Both”
37G/L Account Filter SearchG/L Account FilterNormalCode250G_L Account Filternvarchar(500)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [Cash Flow Account].[G_L Account Filter]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$Cash Flow Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Account]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [Cash Flow Account].[G_L Account Filter] = [G/L Account].[No_]
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 Account].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Cash Flow Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Account]
LEFT JOIN
       [User] AS [User]
              ON
                     [Cash Flow Account].[$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 Account].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Cash Flow Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Account]
LEFT JOIN
       [User] AS [User]
              ON
                     [Cash Flow Account].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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