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
[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 an example select of all columns including those from all joined tables
SELECT
*
FROM
[] AS [Cash Flow Account]
LEFT JOIN
[CRONUS UK Ltd_$Cash Flow Forecast$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Forecast]
ON
[Cash Flow Account].[Cash Flow Forecast Filter] = [Cash Flow Forecast].[No_]
LEFT JOIN
[User] AS [User]
ON
[Cash Flow Account].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Cash Flow Account].[SystemModifiedBy] = [User].[User Security ID]
Show/hide columns in Cash Flow Account table
Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
---|---|---|---|---|---|---|---|
1 | No. | No. | Normal | Code | 20 | No_ | nvarchar(40) |
2 | Name | Name | Normal | Text | 50 | Name | nvarchar(100) |
3 | Search Name | Search Name | Normal | Code | 50 | Search Name | nvarchar(100) |
4 | Account Type | Account Type | Normal | Option | 4 | Account Type | int |
Available options are:
| |||||||
5 | Comment | Comment | FlowField | Boolean | 4 | ||
6 | Blocked | Blocked | Normal | Boolean | 4 | Blocked | tinyint |
7 | New Page | New Page | Normal | Boolean | 4 | New Page | tinyint |
8 | No. of Blank Lines | No. of Blank Lines | Normal | Integer | 4 | No_ of Blank Lines | int |
9 | Indentation | Indentation | Normal | Integer | 4 | Indentation | int |
10 | Last Date Modified | Last Date Modified | Normal | Date | 4 | Last Date Modified | datetime |
11 | Date Filter | Date Filter | FlowFilter | Date | 4 | ||
12 | Cash Flow Forecast Filter | Cash Flow Forecast Filter | FlowFilter | Code | 20 | ||
13 | Amount | Amount | FlowField | Decimal | 12 | ||
29 | Global Dimension 1 Filter | Global Dimension 1 Filter | FlowFilter | Code | 20 | ||
30 | Global Dimension 2 Filter | Global Dimension 2 Filter | FlowFilter | Code | 20 | ||
34 | Totaling | Totaling | Normal | Text | 250 | Totaling | nvarchar(500) |
35 | Source Type | Source Type | Normal | Option | 4 | Source Type | int |
Available options are:
| |||||||
36 | G/L Integration | G/L Integration | Normal | Option | 4 | G_L Integration | int |
Available options are:
| |||||||
37 | G/L Account Filter | G/L Account Filter | Normal | Code | 250 | G_L Account Filter | nvarchar(500) |
Key to join to the G/L Account table.Show/hide example querySELECT
[Cash Flow Account].[G_L Account Filter]
,[G/L Account].[No_]
FROM
[CRONUS UK Ltd_$Cash Flow Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Account]
LEFT JOIN
[CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
ON
[Cash Flow Account].[G_L Account Filter] = [G/L Account].[No_] | |||||||
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 querySELECT
[Cash Flow Account].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Cash Flow Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Account]
LEFT JOIN
[User] AS [User]
ON
[Cash Flow Account].[$systemCreatedBy] = [User].[User Security ID] | |||||||
2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |
Key to join to the User table.Show/hide example querySELECT
[Cash Flow Account].[$systemModifiedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Cash Flow Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Account]
LEFT JOIN
[User] AS [User]
ON
[Cash Flow Account].[$systemModifiedBy] = [User].[User Security ID] |