Cash Flow Manual Revenue

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

Table Type: Company

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

Table Number: 849

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Code]
   ,[Cash Flow Account No_]
   ,[Description]
   ,[Starting Date]
   ,[Ending Date]
   ,[Recurring Frequency]
   ,[Amount]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Cash Flow Manual Revenue$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Cash Flow Manual Revenue table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Code Primary Key Searchnvarchar(20)
3Cash Flow Account No_ Searchnvarchar(40)
4Description Searchnvarchar(200)
5Starting Date Searchdatetime
6Ending Date Searchdatetime
7Recurring Frequency Searchvarchar(32)
8Amount Searchdecimal(38,38)
9Global Dimension 1 Code Searchnvarchar(40)
10Global Dimension 2 Code Searchnvarchar(40)
11$systemId Searchuniqueidentifier
12$systemCreatedAt Searchdatetime
13$systemCreatedBy Searchuniqueidentifier
14$systemModifiedAt Searchdatetime
15$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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