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
   [timestamp]
   ,[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 columns in Cash Flow Setup table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Primary Key Primary Key Searchnvarchar(20)
3Cash Flow Forecast No_ Series Searchnvarchar(40)
4Receivables CF Account No_ Searchnvarchar(40)
5Payables CF Account No_ Searchnvarchar(40)
6Sales Order CF Account No_ Searchnvarchar(40)
7Purch_ Order CF Account No_ Searchnvarchar(40)
8FA Budget CF Account No_ Searchnvarchar(40)
9FA Disposal CF Account No_ Searchnvarchar(40)
10Service CF Account No_ Searchnvarchar(40)
11CF No_ on Chart in Role Center Searchnvarchar(40)
12Job CF Account No_ Searchnvarchar(40)
13Automatic Update Frequency Searchint
14Tax CF Account No_ Searchnvarchar(40)
15Taxable Period Searchint
16Tax Payment Window Searchvarchar(32)
17Tax Bal_ Account Type Searchint
18Tax Bal_ Account No_ Searchnvarchar(40)
19API Key Searchnvarchar(500)
20API URL Searchnvarchar(500)
21Variance _ Searchint
22Historical Periods Searchint
23Horizon Searchint
24Period Type Searchint
25TimeOut Searchint
26Service Pass API Key ID Searchuniqueidentifier
27Cortana Intelligence Enabled Searchtinyint
28Show Cortana Notification Searchtinyint
29Time Series Model Searchint
30Azure AI Enabled Searchtinyint
31Show AzureAI Notification Searchtinyint
32$systemId Searchuniqueidentifier
33$systemCreatedAt Searchdatetime
34$systemCreatedBy Searchuniqueidentifier
35$systemModifiedAt Searchdatetime
36$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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