Cash Flow Setup

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

Table Type: Company

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

Table Number: 843

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [Primary Key]
   ,[Cash Flow Forecast No_ Series]
   ,[Receivables CF Account No_]
   ,[Payables CF Account No_]
   ,[Sales Order CF Account No_]
   ,[Purch_ Order CF Account No_]
   ,[FA Budget CF Account No_]
   ,[FA Disposal CF Account No_]
   ,[Service CF Account No_]
   ,[CF No_ on Chart in Role Center]
   ,[Job CF Account No_]
   ,[Automatic Update Frequency]
   ,[Tax CF Account No_]
   ,[Taxable Period]
   ,[Tax Payment Window]
   ,[Tax Bal_ Account Type]
   ,[Tax Bal_ Account No_]
   ,[API Key]
   ,[API URL]
   ,[Variance _]
   ,[Historical Periods]
   ,[Horizon]
   ,[Period Type]
   ,[TimeOut]
   ,[Service Pass API Key ID]
   ,[Cortana Intelligence Enabled]
   ,[Show Cortana Notification]
   ,[Time Series Model]
   ,[Azure AI Enabled]
   ,[Show AzureAI Notification]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Cash Flow Setup$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 Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Setup]
LEFT JOIN
   [User] AS [User]
      ON
         [Cash Flow Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Cash Flow Setup].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Cash Flow Setup table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Primary Key Primary Key SearchPrimary KeyNormalCode10Primary Keynvarchar(20)
2Cash Flow Forecast No. Series SearchCash Flow Forecast No. SeriesNormalCode20Cash Flow Forecast No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Cash Flow Setup].[Cash Flow Forecast No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Cash Flow Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Cash Flow Setup].[Cash Flow Forecast No_ Series] = [No. Series].[Code]
3Receivables CF Account No. SearchReceivables CF Account No.NormalCode20Receivables CF Account No_nvarchar(40)
Key to join to the Cash Flow Account table.

Show/hide example query

SELECT
       [Cash Flow Setup].[Receivables CF Account No_]
       ,[Cash Flow Account].[No_]
FROM
       [CRONUS UK Ltd_$Cash Flow Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Cash Flow Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Account]
              ON
                     [Cash Flow Setup].[Receivables CF Account No_] = [Cash Flow Account].[No_]
4Payables CF Account No. SearchPayables CF Account No.NormalCode20Payables CF Account No_nvarchar(40)
Key to join to the Cash Flow Account table.

Show/hide example query

SELECT
       [Cash Flow Setup].[Payables CF Account No_]
       ,[Cash Flow Account].[No_]
FROM
       [CRONUS UK Ltd_$Cash Flow Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Cash Flow Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Account]
              ON
                     [Cash Flow Setup].[Payables CF Account No_] = [Cash Flow Account].[No_]
5Sales Order CF Account No. SearchSales Order CF Account No.NormalCode20Sales Order CF Account No_nvarchar(40)
Key to join to the Cash Flow Account table.

Show/hide example query

SELECT
       [Cash Flow Setup].[Sales Order CF Account No_]
       ,[Cash Flow Account].[No_]
FROM
       [CRONUS UK Ltd_$Cash Flow Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Cash Flow Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Account]
              ON
                     [Cash Flow Setup].[Sales Order CF Account No_] = [Cash Flow Account].[No_]
6Purch. Order CF Account No. SearchPurch. Order CF Account No.NormalCode20Purch_ Order CF Account No_nvarchar(40)
Key to join to the Cash Flow Account table.

Show/hide example query

SELECT
       [Cash Flow Setup].[Purch_ Order CF Account No_]
       ,[Cash Flow Account].[No_]
FROM
       [CRONUS UK Ltd_$Cash Flow Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Cash Flow Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Account]
              ON
                     [Cash Flow Setup].[Purch_ Order CF Account No_] = [Cash Flow Account].[No_]
8FA Budget CF Account No. SearchFA Budget CF Account No.NormalCode20FA Budget CF Account No_nvarchar(40)
Key to join to the Cash Flow Account table.

Show/hide example query

SELECT
       [Cash Flow Setup].[FA Budget CF Account No_]
       ,[Cash Flow Account].[No_]
FROM
       [CRONUS UK Ltd_$Cash Flow Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Cash Flow Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Account]
              ON
                     [Cash Flow Setup].[FA Budget CF Account No_] = [Cash Flow Account].[No_]
9FA Disposal CF Account No. SearchFA Disposal CF Account No.NormalCode20FA Disposal CF Account No_nvarchar(40)
Key to join to the Cash Flow Account table.

Show/hide example query

SELECT
       [Cash Flow Setup].[FA Disposal CF Account No_]
       ,[Cash Flow Account].[No_]
FROM
       [CRONUS UK Ltd_$Cash Flow Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Cash Flow Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Account]
              ON
                     [Cash Flow Setup].[FA Disposal CF Account No_] = [Cash Flow Account].[No_]
10Service CF Account No. SearchService CF Account No.NormalCode20Service CF Account No_nvarchar(40)
Key to join to the Cash Flow Account table.

Show/hide example query

SELECT
       [Cash Flow Setup].[Service CF Account No_]
       ,[Cash Flow Account].[No_]
FROM
       [CRONUS UK Ltd_$Cash Flow Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Cash Flow Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Account]
              ON
                     [Cash Flow Setup].[Service CF Account No_] = [Cash Flow Account].[No_]
11CF No. on Chart in Role Center SearchCF No. on Chart in Role CenterNormalCode20CF No_ on Chart in Role Centernvarchar(40)
12Job CF Account No. SearchJob CF Account No.NormalCode20Job CF Account No_nvarchar(40)
Key to join to the Cash Flow Account table.

Show/hide example query

SELECT
       [Cash Flow Setup].[Job CF Account No_]
       ,[Cash Flow Account].[No_]
FROM
       [CRONUS UK Ltd_$Cash Flow Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Cash Flow Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Account]
              ON
                     [Cash Flow Setup].[Job CF Account No_] = [Cash Flow Account].[No_]
13Automatic Update Frequency SearchAutomatic Update FrequencyNormalOption4Automatic Update Frequencyint
Available options are:
  • “Never”
  • “Daily”
  • “Weekly”
14Tax CF Account No. SearchTax CF Account No.NormalCode20Tax CF Account No_nvarchar(40)
Key to join to the Cash Flow Account table.

Show/hide example query

SELECT
       [Cash Flow Setup].[Tax CF Account No_]
       ,[Cash Flow Account].[No_]
FROM
       [CRONUS UK Ltd_$Cash Flow Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Cash Flow Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Account]
              ON
                     [Cash Flow Setup].[Tax CF Account No_] = [Cash Flow Account].[No_]
19Taxable Period SearchTaxable PeriodNormalOption4Taxable Periodint
Available options are:
  • “Monthly”
  • “Quarterly”
  • “Accounting Period”
  • “Yearly”
20Tax Payment Window SearchTax Payment WindowNormalDateFormula32Tax Payment Windowvarchar(32)
21Tax Bal. Account Type SearchTax Bal. Account TypeNormalOption4Tax Bal_ Account Typeint
Available options are:
  • ” “
  • “Vendor”
  • “G/L Account”
22Tax Bal. Account No. SearchTax Bal. Account No.NormalCode20Tax Bal_ Account No_nvarchar(40)
23API Key SearchAPI KeyNormalText250API Keynvarchar(500)
24API URL SearchAPI URLNormalText250API URLnvarchar(500)
25Variance % SearchVariance %NormalInteger4Variance _int
26Historical Periods SearchHistorical PeriodsNormalInteger4Historical Periodsint
27Horizon SearchHorizonNormalInteger4Horizonint
28Period Type SearchPeriod TypeNormalOption4Period Typeint
Available options are:
  • “Day”
  • “Week”
  • “Month”
  • “Quarter”
  • “Year”
29TimeOut SearchTimeOutNormalInteger4TimeOutint
30Service Pass API Key ID SearchService Pass API Key IDNormalGUID16Service Pass API Key IDuniqueidentifier
31Cortana Intelligence Enabled SearchCortana Intelligence EnabledNormalBoolean4Cortana Intelligence Enabledtinyint
32Show Cortana Notification SearchShow AzureAI NotificationNormalBoolean4Show Cortana Notificationtinyint
33Time Series Model SearchTime Series ModelNormalOption4Time Series Modelint
Available options are:
  • “ARIMA”
  • “ETS”
  • “STL”
  • “ETS+ARIMA”
  • “ETS+STL”
  • “ALL”
  • “TBATS”
34Azure AI Enabled SearchAzure AI EnabledNormalBoolean4Azure AI Enabledtinyint
35Show AzureAI Notification SearchShow AzureAI NotificationNormalBoolean4Show AzureAI Notificationtinyint
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 Setup].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Cash Flow Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [Cash Flow Setup].[$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 Setup].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Cash Flow Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [Cash Flow Setup].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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