Cash Flow Setup – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables CCash 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 Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Primary Key	Primary Key	Normal	Code	10	Primary Key	nvarchar(20)
2	Cash Flow Forecast No. Series	Cash Flow Forecast No. Series	Normal	Code	20	Cash Flow Forecast No_ Series	nvarchar(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]
3	Receivables CF Account No.	Receivables CF Account No.	Normal	Code	20	Receivables 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_]
4	Payables CF Account No.	Payables CF Account No.	Normal	Code	20	Payables 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_]
5	Sales Order CF Account No.	Sales Order CF Account No.	Normal	Code	20	Sales 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_]
6	Purch. Order CF Account No.	Purch. Order CF Account No.	Normal	Code	20	Purch_ 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_]
8	FA Budget CF Account No.	FA Budget CF Account No.	Normal	Code	20	FA 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_]
9	FA Disposal CF Account No.	FA Disposal CF Account No.	Normal	Code	20	FA 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_]
10	Service CF Account No.	Service CF Account No.	Normal	Code	20	Service 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_]
11	CF No. on Chart in Role Center	CF No. on Chart in Role Center	Normal	Code	20	CF No_ on Chart in Role Center	nvarchar(40)
12	Job CF Account No.	Job CF Account No.	Normal	Code	20	Job 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_]
13	Automatic Update Frequency	Automatic Update Frequency	Normal	Option	4	Automatic Update Frequency	int
	Available options are: “Never” “Daily” “Weekly”
14	Tax CF Account No.	Tax CF Account No.	Normal	Code	20	Tax 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_]
19	Taxable Period	Taxable Period	Normal	Option	4	Taxable Period	int
	Available options are: “Monthly” “Quarterly” “Accounting Period” “Yearly”
20	Tax Payment Window	Tax Payment Window	Normal	DateFormula	32	Tax Payment Window	varchar(32)
21	Tax Bal. Account Type	Tax Bal. Account Type	Normal	Option	4	Tax Bal_ Account Type	int
	Available options are: ” “ “Vendor” “G/L Account”
22	Tax Bal. Account No.	Tax Bal. Account No.	Normal	Code	20	Tax Bal_ Account No_	nvarchar(40)
23	API Key	API Key	Normal	Text	250	API Key	nvarchar(500)
24	API URL	API URL	Normal	Text	250	API URL	nvarchar(500)
25	Variance %	Variance %	Normal	Integer	4	Variance _	int
26	Historical Periods	Historical Periods	Normal	Integer	4	Historical Periods	int
27	Horizon	Horizon	Normal	Integer	4	Horizon	int
28	Period Type	Period Type	Normal	Option	4	Period Type	int
	Available options are: “Day” “Week” “Month” “Quarter” “Year”
29	TimeOut	TimeOut	Normal	Integer	4	TimeOut	int
30	Service Pass API Key ID	Service Pass API Key ID	Normal	GUID	16	Service Pass API Key ID	uniqueidentifier
31	Cortana Intelligence Enabled	Cortana Intelligence Enabled	Normal	Boolean	4	Cortana Intelligence Enabled	tinyint
32	Show Cortana Notification	Show AzureAI Notification	Normal	Boolean	4	Show Cortana Notification	tinyint
33	Time Series Model	Time Series Model	Normal	Option	4	Time Series Model	int
	Available options are: “ARIMA” “ETS” “STL” “ETS+ARIMA” “ETS+STL” “ALL” “TBATS”
34	Azure AI Enabled	Azure AI Enabled	Normal	Boolean	4	Azure AI Enabled	tinyint
35	Show AzureAI Notification	Show AzureAI Notification	Normal	Boolean	4	Show AzureAI Notification	tinyint
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	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]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Dynamics 365 BC Table Reference Tables Company Tables CCash Flow Setup

Leave a Reply Cancel reply