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

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

Column IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchnvarchar(40)
3Name Searchnvarchar(100)
4Search Name Searchnvarchar(100)
5Account Type Searchint
6Blocked Searchtinyint
7New Page Searchtinyint
8No_ of Blank Lines Searchint
9Indentation Searchint
10Last Date Modified Searchdatetime
11Totaling Searchnvarchar(500)
12Source Type Searchint
13G_L Integration Searchint
14G_L Account Filter Searchnvarchar(500)
15$systemId Searchuniqueidentifier
16$systemCreatedAt Searchdatetime
17$systemCreatedBy Searchuniqueidentifier
18$systemModifiedAt Searchdatetime
19$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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