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
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 ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | No_  | nvarchar(40) |
| 3 | Name | nvarchar(100) |
| 4 | Search Name | nvarchar(100) |
| 5 | Account Type | int |
| 6 | Blocked | tinyint |
| 7 | New Page | tinyint |
| 8 | No_ of Blank Lines | int |
| 9 | Indentation | int |
| 10 | Last Date Modified | datetime |
| 11 | Totaling | nvarchar(500) |
| 12 | Source Type | int |
| 13 | G_L Integration | int |
| 14 | G_L Account Filter | nvarchar(500) |
| 15 | $systemId | uniqueidentifier |
| 16 | $systemCreatedAt | datetime |
| 17 | $systemCreatedBy | uniqueidentifier |
| 18 | $systemModifiedAt | datetime |
| 19 | $systemModifiedBy | uniqueidentifier |